Here’s an excel template file that you can fill in if you have bank transactions that need importing into SageOne.

excel-template-for-sageone-bank-import.xlsx (90.0 KB)

Use this spreadsheet to fill in details your bank transactions (fill in the areas shaded grey). You can’t import this directly into SageOne but it puts the data into an easy format where I can check to make sure everything matches and then easily modify into a csv to upload into SageOne.

With the amount, only put in one amount in either the cash in or cash out column. You don’t need to put 0 in the other column.

Let me know if you have any questions/issues with the template by commenting below.