Chris -
While David C has provided good template for how to approach your CSV import concerns, there is one more workflow you may want to keep it in back of your mind. You have an option to always start a new blank file, experiment with import into the blank file and then you can review that by itself to make sure import looks good on its own. Keep in mind that during the import matching, you can save (and resave over again if need to) and recall the mappings profile that you have built up. Once you are satisfied with how it looks in that blank file, you can actually important into the live file that you use for accounting by using the saved import profile. This will save you lots of deletes of records until you are ready to import in the live file and get the profile configured correctly so that it can be used over again and again as well. This is what I do whenever I have concern what the process will look like for any type of import, whether CSV, OFX or QIF. Kalpesh. Message: 7 Date: Sat, 13 Nov 2021 22:45:21 +0000 From: Chris Matchett <ch...@freeperiod.co.uk <mailto:ch...@freeperiod.co.uk> > To: davidcousen...@gmail.com <mailto:davidcousen...@gmail.com> Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] import csv transactions Message-ID: <cahrzaam_8e2rznh2hfg8csv767+l0rowblytkhohnltpmek...@mail.gmail.com <mailto:cahrzaam_8e2rznh2hfg8csv767+l0rowblytkhohnltpmek...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" Thank you David. I will take your advice and work through a small number of transactions and follow your guidance. My file is csv. I caused confusion by transposing for readability in the email :-) Chris On Sat, 13 Nov 2021 at 22:38, <davidcousen...@gmail.com <mailto:davidcousen...@gmail.com> > wrote: > Chris, > > The account to import the records to will be the account in GnuCash which > records the transactions for your business bank account. If you have the > register for that account open when you initiate the import process it > will be > used as the default account to import to unless that is explicitly > specified in > the import records. Each transaction has at least one entry for that > account and > entries to 1 or more other accounts usually in you Expense and Income type > accounts and their sub accounts ( unless a capital purchase - where it > will be > an asset account). > > The Import Matching process constructs a map to the expense and income > accounts > structure based on the information in the transactions and the > associations you > make manually during your initial imports. You can add new accounts to the > income and expense account structure during the import process if a > suitable > account does not already exist in your chart of accounts. > > If the record you are importing has the format you show i.e. is multiline > and > blank separated you can select a blank as the field separator but you will > need > to ensure all fields for a transaction are either on a single line or are > in the > multiline format GnuCash uses for importing transactions with more than two > splits. This is illustrated in the Importing Transactions sectionof the > documentation > > https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#:~:text=Nav igate%20to%20the%20file%20you,name%20in%20the%20import%20file > . > > The date and description fields will best map onto those column headers. > The > Amount field will most likely be associated with the Deposit header ( you > may > have to experiment with this and perhaps assign it to the Withdrawal > header if > the Deposit header does not work - it depends on whatever conventions are > used > by your bank) in the import dialogue and the Counter Party field could be > used > as an indicator for the Transfer Account field. The import process will > ask you > to assign identifiers in this field to specific internal GNuCash > expense/income > accoounts the first time they are encountered in an import record to > construct > the mapping that will be used for subsequent imports. > > It is essential to complete the import process (click on the Import > button) to > store the data from the mapping and transfer account assignments matching > for > subsequent imports. > > I would suggest initially truncating a file to a small number of records to > familiarize yourself with the procedure. (saves having to delete a large > number > of records if you get it wrong initially and GNuCash has no process for > deleting > multiple transactions for an account register. > > David Cousens > On Sat, 2021-11-13 at 19:04 +0000, Chris Matchett wrote: > > Hi, > > > > I am experimenting with gnucash. I am trying to import a csv file of my > > business bank statement. Starling bank in the UK. > > > > I assume the date and description fields are good below for the mandatory > > requirements? I am not sure how to match deposit and/or withdrawal and > > which account to use? > > > > *(Date)* Date - 21/01/2020 > > Counter Party - Citybus Ticket Kiosk > > *(Description)* Reference - CITYBUS TICKET KIOSK > > Type - CONTACTLESS > > Amount (GBP) - -15.5 > > Balance (GBP) - 480.1 > > Spending Category - TRANSPORT > > Notes - > > > > Many thanks, > > > > Chris > > > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org <mailto: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. > -- _______________________________________________ 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.
