[GNC] New User Oh boy I need an accountant

[davidcousens49 at gmail.com]

Phyllis,

The problem with the import is the negative sign on the Debit/Withdrawal column.
GnuCash expects this to be a positive quantity when the debits and credits are
in separate columns, i.e if both columns are specified then both columns are
positive. If the data is in a single column then negative for the debits and
positive for the credits (in the bank's account) will work fine. You would
normally apply only the Deposit header to that single column (if they import in
reverse order, then you would apply the Withdrawal header)

 In the third image, the import matcher window, the background color is yellow
because the second account ( you are importing to the GnuCash account
corresponding to your checking account) and you will need to assign, generally
an income or expense account and occasionally an asset or liability account in
most cases for the second entry (split in GnuCash terminology) for the
transaction. If the reason for this isn't clear, the introductory chapter of the
Gnucash guide (https://code.gnucash.org/docs/C/gnucash-guide/chapter_basics.html
) has a brief outline of the relevant accounting concepts.

David Cousens


On Mon, 2022-07-18 at 17:32 -0500, Phyllis Bruce wrote:
> I am getting too many unanticipated results.  Watched many YouTube videos
> since I cannot make sense of the Help manual.  I have added accounts where
> they appear to belong, added my opening balances, and imported a couple CSV
> files from a bank account.
> 
> Here is the CSV:   Note columns for Withdrawal and Deposit
> [image: 0fb3e81e-c69c-40b2-b876-6cd92092afe4.png]
> 
> [image: image.png]
> 
> Here is the bank journal showing the transactions and transfer accounts:
> Everything a deposit?!
> [image: image.png]
> 
> I'm not so far into this that I can't start over but it has taken me two
> days to create this mess.
> 
> Any help will be greatly appreciated.  Next question will be how can I
> enter my retirement income in a split transaction that shows total benefit,
> deductions and net income?  Of course the bank only records the net.
> 
> Best regards, po   (aka Phyllis Bruce)
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.