I’m trying to upload my bank statements to the desktop version, on the batch update.
My bank only supplies a basic CSV file.
The following are the column headers supplied on my csv bank statements;
Date Details Transaction Type In Out
Please can you tell me which columns these correlate with when I do the batch update copy & paste (there are sooo many columns I dont know which is which!!)
I’ve tried a few options but nothing works so far.
Don’t use ‘batch update’; use the ‘Import Bank Statement’ button on the ‘Bank and Cash Accounts’ page. You’ll have to add some headers to the file but importing a csv with no header will give you an error message that exlains how.
Ok, thanks for that.
I previously added headers.
What headers should I use?
Here’s the self-expalitory error message displayed when no headers are included in the csv file.
Header with name ‘Date’ or ‘DATE’ or ‘Transaction Date’ or ‘TransactionDate’ or ‘Trade Date’ or ‘Payment Date’ or ‘Created (UTC)’ or ‘Transaction date’[0] was not found. Header with name ‘Amount’ or ‘AMOUNT’ or ‘Credit’ or ‘Credits’ or ‘Credit Amount’ or ‘Net’ or ‘In amount(R)’ or ‘Total’ or ‘Value’ or ‘Deposited’ or ‘Amount (GBP)’ or ‘Amount ($)’[0] was not found. Headers: ‘’, ‘’, ‘’, ‘’ If you are expecting some headers to be missing and want to ignore this validation, set the configuration HeaderValidated to null. You can also change the functionality to do something else, like logging the issue. IReader state: ColumnCount: 4 CurrentIndex: -1 HeaderRecord: [“”,“”,“”,“”] IParser state: ByteCount: 0 CharCount: 4 Row: 1 RawRow: 1 Count: 4 RawRecord:
Thank you (me being dumb !)
So now I have the receipts uploaded to my bank account, how to I match them with the relevant invoices to allow them to show as paid?
You need to allocate a customer to each receipt and then categorise it as an ‘account receivable’.
Setting up ‘bank rules’ for bank receipts using expected text for each customer can also be a great time saver.