I have been recording and analyzing transactions for several years using a spreadsheet. In effect, I have been using a variation of a single entry book-keeping system. I wish to import the data into GNUCash.
In GNUCash, I have:
- created a new entity,
- created account names including 'Assets:Current Assets:Checking Account' and 'Expenses:Auto:Gas'
In the spreadsheet program, I have created a CSV file with columns for: date, description, withdrawal, and Account. In the column for Account, all row entries contain names that are identical to those used in in my GNUCash file.
When I try and import the file, the 'Match Import and GnuCash accounts' tab asks me to manually match the account name in the CSV file (that GNUCash now calls Accountid) with an 'Account Name' within GNUCash. With many years of transactions to go through, I would like to avoid this manual step, if possible.
Should it be possible to achieve this end? If so, how?
Thank you in anticipation.