Hello Geert & GNUCash users, https://wiki.gnucash.org/wiki/AqBanking - do you know if AQBanking (or GnuCash for that matter), is a member of the Linux Foundation's FinTech Open Source Foundation/FINOS? https://www.finos.org/
--- Thanks, Brad - https://www.facebook.com/brad.morrison.12327/ & https://norcal.social/@BradMorrison On 2025-01-17 05:52, Geert Janssens wrote: > It's unlikely to be a bug. > The generic csv importer is written to handle all possible kinds of csv data > so it can't make assumptions about the sense of the transactions (be it > positive or negative, or debit/credit). You have to tell it exactly how you > want to interpret the numbers. We have had several discussions about this, > but haven't found a solution that is less ambiguous and at the same time > keeps the interface manageable. > We know this means it may take two tries before you get it right, but that > should only be the first time you import, assuming you remember what was the > right choice of amount/amount negated. > You can always save the good combination as a preset to make it easier on > subsequent imports. > As a side note, I have been pondering for a while that the aqbanking importer > may be the more useful importer for actual bank statements in csv format. It > allows to select predefined and tested format combinations that should work > well. The downside probably is there are plenty of banks in the world and > most of them are not listed in the aqbanking selectors. Maybe the aqbanking > project would welcome other format specifications as contributions (to be > discussed on the aqbanking project of course) ? > Regards, > Geert > Op donderdag 16 januari 2025 21:20:03 Midden-Europese standaardtijd schreef > Brad Morrison: > >> Hi Tom & GNUCash users, > >> > >> In case this issue turns out to be a bug: > >> > >> What operating system are you using? > >> > >> What version of GnuCash are you using? The current version is 5.10 - > >> https://gnucash.org/download.phtml > >> > >> As far as importing data into GNC - > >> https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data > >> > >> --- > >> Thanks, > >> > >> Brad - https://www.facebook.com/brad.morrison.12327/ & > >> https://norcal.social/@BradMorrison > >> > >> On 2025-01-16 11:55, Michael or Penny Novack via gnucash-user wrote: > >>> The statement from the credit card company is likely from THEIR point of > >>> view. Just like the statement of your bank account you get from your bank > >>> is from their point of view. > >>> > >>> What you owe them is a credit in your books but a debit in theirs. What > >>> money they owe you is a debit in your books and a credit in theirs. > >>> > >>> Michael D Novack > >>> > >>> PS --- It was once always positive amounts in double entry bookkeeping > >>> (older than negative numbers were accepted in Western mathematics). The > >>> senses are not positive and negative but debit and credit. Those senses > >>> do not correspond (whether a debit is positive or negative depends on > >>> what kind of account -- same with credit.> > >>> On 1/16/2025 2:22 PM, Tom Balazs wrote: > >>>> I just imported a bunch of credit card transactions from a CSV file. I > >>>> imported them into a liability credit card account, positive values, > >>>> column > >>>> title "amount". > >>>> But they all the purchases / charge transactions went into the "payment" > >>>> column, not the "charge" column. All the other info imported fine. > >>>> > >>>> Apparently I have to make those transactions either a negative value, or > >>>> the column title has to be "amount negated". Is that correct? > >>>> > >>>> Tom > >>>> _______________________________________________ > >>>> gnucash-user mailing list > >>>> gnucash-user@gnucash.org > >>>> To update your subscription preferences or to unsubscribe: > >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user > >>>> ----- > >>>> Please remember to CC this list on all your replies. > >>>> You can do this by using Reply-To-List or Reply-All. > >> > >> _______________________________________________ > >> gnucash-user mailing list > >> gnucash-user@gnucash.org > >> To update your subscription preferences or to unsubscribe: > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user > >> ----- > >> Please remember to CC this list on all your replies. > >> You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
