Import bank transactions when your bank feed is not available
Due to Brexit, any 3rd party accessing Bank Feeds needs an EU regulator authorisation for Irish banks. Authorisations issued by the UK regulator are not valid after 31 December 2020.
This has caused a temporary disruption to our bank feeds service.
We are committed to supporting customers with Bank Feeds and we want to reassure you that this is a temporary disruption and we are working closely with our provider to reinstate this service as soon as possible. We anticipate the service back up and running from March 2021.
Whilst your bank feed is not available, you'll see this message at the top of your bank account.
If you import transactions regularly from your bank feed, we recommend that you import bank transactions from your bank statement or using a CSV, QIF or OFX files downloaded from your online bank account.
If your bank statement is only available in PDF format, consider using AutoEntry to convert a PDF bank statement into the CSV file that can then be used to import bank transactions directly into Sage Accounting. See Bank statement import using AutoEntry
If you only use bank feeds once or twice a month for a small number of transactions you may want to wait and import your bank transactions once your bank feed is available. Alternatively, enter your bank transactions manually:
- Customer receipt
- Supplier payments
- Payments on account
- Record a payment or receipt when there is no invoice
Import from your bank statement
Download or export transactions from your online bank account as a CSV, QIF or OFX files. You can then import the file into Sage Accounting and process the transactions exactly as you would from your bank feed. Your bank rules will still be applied.
If your bank statement is only available in PDF format, consider using AutoEntry. Upload a PDF version of your bank statement and AutoEntry will convert it to the required CSV format.
Download a file from your bank
The date range you use is important to make sure you don't import duplicate transactions, make a note of the last transaction that was imported from your bank feed
Log in to your online bank account and download your bank statement or export selected transactions.
Depending on your bank, this might be called download or export. The format should be as CSV, QIF or OFX files.
- To avoid duplicates, if you can specify a date range, choose the day after the last transaction was downloaded from your bank feed.
Make a note of your statement end balance as you will need this when reconciling your statement with transactions.
If you're download using a CSV file, amend the downloaded CSV file to make sure it's in the required format.
Prepare the CSV file
If you're importing using a CSV file, the import file must be in the correct format. Download a template file from the import page to help you.
- The column headings must be as follows: Date, Reference and Amount.
- Payment in and payments out must both be in the Amount column.
- Payments out must have a negative value.
Import your statement
- Go to Banking.
- Select Import on the relevant bank account.
- Depending on your internet browser, select Browse or Choose File.
- Find the downloaded bank statement file, select the file and click Open.
- Enter the ending balance from your statement or exported list.
- Enter the reference of the statement.
- Click Upload.
Process your transactions
Imported transactions appear on the Incoming bank transactions screen, exactly the same as if they are from your bank feed. To help you identify which ones have been imported from a file, they will have a label of Statement Import.
Process your imported transactions exactly as if they had come from your bank feed.
Bank rules will continue to be applied.
When your bank feed becomes available again
Once your bank feed is available again, a green banner is shown at the top of page with the following message: A bank feed is now available for your bank.
You'll need to re-authenticate with your bank, so make sure your have your online bank account credentials handy. Some banks may also send a code to your mobile phone or via email for additional authorisation.
- Choose Set Up from the banner.
- To prevent duplicates, choose the date to start importing transactions via your bank feed.
- Complete the authentication steps to get you back up and running.
Which date should I choose?
Importing from a file
Choose the day after the date of the last imported transaction.
Check whether you have transactions in your bank account that have not been imported from a file or from your bank feed. If you find any, enter them manually. This might happen if you imported from a file, before all the transactions for that day appeared in your bank account.
All your bank transactions were imported using a CSV file on 31st January. The bank statement balance was €300 and the last transaction imported was a receipt for €200.
On 1st February, we re-connected the bank feed and started downloading new transactions, but the bank balance was out by €100.
After checking the bank account, you found receipt dated 31st January for €100 which was not included on our last import file.
We entered the receipt manually as an Other Receipt.
Creating transactions manually
Choose the day after the date the last transaction was entered.
Check whether you have transactions in your bank account that have not been entered manually yet. This might happen if you checked your bank account before all transactions for that day appeared in your bank account.
You entered the last transaction you could see on your bank account for 31st January. The bank statement balance was €300 and the last transaction was a receipt for €200.
On 1st February, you re-connected the bank feed and started downloading new transactions, but the bank balance was out by €100.
After checking the bank account, you found receipt dated 31st January for €100 which you had not previously entered. You entered the receipt and now the bank balance is correct
Just waiting for the bank feed to be up and running
Choose the day after the last transactions were downloaded from your bank feed.