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> 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=Navigate%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 > 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. > -- https://freeperiod.co.uk _______________________________________________ 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.