We are trying to find a way to import bank payments from Excel into Sage50 Essentials (Version 24). Each single bank payment represents several sources of income and need to be split into several nominal codes. If we use the standard input form we have to type in the same codes and descriptions every time. We need some sort of template.

One way we managed to do it was to input the bank payment into a single nominal account (1000) and then we could then transfer the amounts out of 1000 into the various required accounts using an import spreadsheet and importing using the "Audit Trail Transactions" option. However if we try to bypass the bank payment input and just modify the spreadsheet by replacing the 1000 by the account code for our bank account it complains "Error in record 8: Nominal A/C Ref: Reference to non-existent Nominal Ledger account". Is there a way to achieve direct allocation of bank receipts into several nominal accounts by importing a spreadsheet?