Sage allows you to import bank and credit card statements that you have downloaded from your Internet banking platform. You can import your bank statement in either CSV or OFX format.
Please note the following concerning the file types:
OFX
Open financial exchange file.
This is a text file which contains financial data and allows the exchange of financial information.
OFX is the preferred file type to import as it has a standardised format. This means that no further formatting is required.
You may be hindered from importing OFX format bank statement for the following reasons:
o Not all banks support this format. Your bank may not provide bank statements in OFX format.
o Not all computers support this format and it can prove to be challenging to find an application which is supported by your computer that is able to OFX files.
It is not a standardized format like OFX. Different banks provide CSV files that are in various layouts.
You should only choose CSV files if OFX is not available or is not supported by your computer.
Cause
Resolution
How to import a bank statement manually
Before
Before you can import your transactions into Sage Accounting, you will need to export/download the statement files from your online banking website. To do this, log into your online banking platform and look at the export options (date range and file type). You will need to export files for each of the accounts you'd like to import.
Each online banking website will look different. Please contact your bank for assistance should you encounter difficulty in downloading your bank statement from your bank account.
If you have downloaded your bank statement in CSV format you will reformat the file to meet the requirements of Sage One.
In Sage Accounting
In Sage One, navigate to Banking > Transactions > Banking menu option
Select your Bank or Credit Card account. The statement details will be imported into this bank or credit card account that you have selected.
Click on the Import Bank Statements button
The following screen will appear
There are two Date Range options available:
Options
Explanation
All Transactions
Select this option when you want to import all the transactions contained in the import file.
Dates to Import
This option allows you to import new transactions by selecting the relevant date range.
In the Import File Type field, select the file type which you would like to import - Historic CSV allows you to import a previously exported csv file from Sage Accounting.
In the Import File field, click on the Browse button to search for your downloaded bank statement (OFX or CSV format).
If you selected to import a CSV file, the Date Format field must be set correctly. When you open your CSV file ensure that the date format selected on this screen matches the date format displayed in the CSV file.
Transactions will be uploaded into Sage Accounting. A successful import will show you how many rows were imported and how many transactions are unallocated (not allocated by Bank Statement Mapping Rules) as below.
Note: When you make use of Bank Feeds or import your Bank Statements, you will be notified of possible duplicate transactions that you can review.
