Hi everyone,
I'm new to GNUcash and starting to just get some simple things input
into the program from Excel. Let's assume a simple account structure
like this:
Assets
> Current Assets
>> Chequing Account
Income
> Revenue/POS Machine
>> VISA
>> M/C
>> Debit Card
So I have a business that has a machine that accepts VISA, M/C, Debit
card processing. The money gets deposited straight into my Chequing
account. I tried to import data from Excel in CSV format but it seemed
to do everything in reverse. That is, instead of Income it made it
Charges, and I tried to make it Transfer to Assets:Current:Chequing it
made it a Withdrawal. That is, it was backwards too.
I assumed that money coming in via a point-of-sale terminal could be
placed under income and then transfered to the chequing account and
that it would show up as INCOME and then I transfer to the CHEQUING
account and it shows up as deposit in there. I'm confused as to why
things are "backwards".
Second issue is... I am importing a pile of Excel data from CSV. Is
there any easy way to populate the "Transfer" field in the CSV file.
That is, can I have it set up like this:
Date,Description,Amount,TransferAcct
So for example:
2018-06-15,Sale to Bob,$500,Assets:Current:Chequing
So I would import it into the Income:Revenue:VISA account, and it would
automatically make all the entries have the appropriate transfer field
already populated. Otherwise I assume I just copy/paste that field.
There is no way to select a bunch of transactions and make them all
transfer (create the double-entry) to another single account of my
choosing? Thanks for any help... I'm pretty good with computers
normally so I hope I can be up to speed fairly quickly.
Edy
e...@dr.com
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
