Import issues with invoices

Hi I was loading up my invoices spreadsheet and it would not recognise the number format for the nominal accounts 20, 40, etc it had no problems recognizing the other nominal accounts. I tried changing the number format from “Numbers” to “general” but nothing helped.

Also I wanted to upload the bank payment nominal account number ie 1200 but it did not load that information. Is this because I did not put in a payment date??



most likely yes, date are important for payments and invoices

I would try entering the nominal accounts in the format 0020 and 0040, it seems our import tool doesn’t automatically add the leading zeros. CSV files don’t have any concept of formats (e.g. numbers, dates), everything is treated as plain text.

If you provide a payment nominal account then you will also need to supply a payment date.

I moved a post to a new topic: Part payment on bank transaction