Upload a Bank Statement to Bank Services

If you have historical transactions, a large number of transactions, or if your bank feed isn’t working, you can upload them from a bank statement that you downloaded from your financial institution.

How to upload a statement

1. In the Home window, click Banking on the navigation pane.
2. In the Tasks pane, click the Match Bank Transactions icon.
3. Click Upload to Bank Services.
4. Click New Bank Account or Existing Bank Account. For a new account, enter the bank account details. For an existing account, select the bank account from the drop-down menu. Bank services will use this information to create a cloud-based account. You will see this account in the Match Transactions window in the Bank Account menu.

   Important! For an existing imported account, Sage 50 prefixes the current bank account with "ARCHIVE". If there are any remaining transactions to be matched and reconciled with the ARCHIVE account, make sure to do that so you can tidy up your accounts.

5. Select the file type. You can use CSV or OFX.
6. Click Select file and find the bank statement file on your computer. Select Open to add the bank statement. You can also drag and drop the file.
7. Select the date format used in your file. Choose either:

   Day, month, year

   Month, day, year

   Year, month, day (Use this option if you are uploading an OFX file.)

8. Enter a comment for this upload.
9. Click Upload file.
10. Begin verifying transactions. You need to confirm your transaction as either money in or money out of the account.
11. Review the transactions. If there are any discrepancies, you can go back to the Verify screen.
12. Click Import transactions. The transactions are imported into your cloud bank account.
13. Click Get Transactions in the Match Transactions window to bring the transactions into Sage 50.