Excel Template to Prepare CSV for Accounting Software Import - SageOne

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.

Next: How to Reconcile Bank Transaction that is Less than Invoice Amount Due to Bank Fees and Merchant Fees Like Paypal and Stripe being Deducted

Sign up to post comments

Have A Question?

Get in touch!