Op zondag 3 september 2023 15:47:26 CEST schreef Tom Balazs: > I'm importing checking account transactions from a CSV file. > > I see that in the Transaction Import Assistant I can > A. Choose Account at the top of the Assistant (Import Preview), where I > would designate it Checking Account #1 > OR I can > B. Choose Account as a column heading. Where I would designate it: Expense: > Auto : Auto Repair > I can't do both. Is there a way for me to do both? > That might save me the trouble of having to go in an manually choose > account for each transaction. > > Check Account #1 Transaction ... Date: 1/1/23, Description: Bob's Auto, > Account: Auto Repair, Amount: 50.00
A transaction in GnuCash involves (at least) two accounts. I assume you want to import a csv file with several transactions related to your Checking Account #1. As the example you give doesn't have a column with this account name in it, that's probably what you want to set as your base account. Your csv example holds the other account related to the transaction: "Auto Repair". In the CSV importer that's known as the "Transfer account". You should be able to select that in the list with no issues. Put differently: if your csv data has two account columns, one will be your "Account" and the other will be "Transfer Account". If you only have one account column, the whole csv file is assumed to go into one account. That account is what you have to set as base account. The column in your csv data will be the "Transfer Account" in this case. Regards, Geert _______________________________________________ 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.
