Import banking concern transactions when your bank feed is non available

If your bank feed has go asunder or has been temporarily unavailable, this article explains how to import transactions until your depository financial institution feed is back up and running.

When to import transactions

If you import transactions regularly from your depository financial institution feed, nosotros recommend that you import banking company transactions from your bank statement or using a CSV, QIF or OFX files downloaded from your online depository financial institution business relationship.

If yous simply use bank feeds once or twice a month for a small number of transactions you may want to await and import your bank transactions once your banking concern feed is available. Alternatively, enter your banking concern transactions manually:

  • Customer receipt
  • Supplier payments
  • Payments on account
  • Tape a payment or receipt when there is no invoice

Import from your banking company statement

Download or export transactions from your online depository financial institution account as a CSV, QIF or OFX files. You can then import the file into Accounting and process the transactions exactly as you lot would from your bank feed. Your depository financial institution rules volition still be practical.

If your banking concern statement is only available in PDF format, consider using AutoEntry. Upload a PDF version of your bank statement and AutoEntry volition convert it to the required CSV format. Run into Import a banking company statement using AutoEntry

How to import transactions

  1. Download a file from your banking company

    The date range you utilise is important to make sure you don't import duplicate transactions, make a note of the terminal transaction that was imported from your bank feed.

    Depending on your bank, this might exist called download or consign. The format should be every bit CSV, QIF or OFX files.

  2. To avoid duplicates, if you tin specify a date range, choose the day after the last transaction was downloaded from your depository financial institution feed.

  3. Brand a notation of your argument end balance as you volition demand this when reconciling your statement with transactions.

  4. If you're download using a CSV file, amend the downloaded CSV file to make sure information technology's in the required format.

Prepare the CSV file

If yous're importing using a CSV file, the import file must be in the correct format. Download a template file from the import page to assistance you.

For more details on how to prepare the CSV file, read Import bank statement

Import your statement

  1. Go to Banking.
  2. Select Import on the relevant bank account.
  3. Select the relevant file type and follow the steps to upload your depository financial institution statement file.

For detailed steps and troubleshooting advice, read Import banking company statement

Process your transactions

Imported transactions announced on the Incoming bank transactions screen, exactly the same as if they are from your bank feed. To aid yous identify which ones have been imported from a file, they volition take a characterization of Argument Import.

Process your imported transactions exactly as if they had come from your bank feed.

Bank rules volition continue to be applied.

When your bank feed becomes bachelor again

Once your bank feed is available again, you'll need to re-cosign with your depository financial institution, so make sure your take your online bank account credentials handy. Some banks may also send a lawmaking to your mobile phone or via email for additional authorisation.

  1. Choose Set Upwards from the banner.
  2. To prevent duplicates, choose the date to outset importing transactions via your banking company feed.
  3. Complete the authentication steps to go yous back up and running.

Which date should I choose?

Importing from a file

Choose the day after the engagement of the last imported transaction.

Check whether you lot take transactions in your bank account that have not been imported from a file or from your bank feed. If yous find whatever, enter them manually. This might happen if you imported from a file, before all the transactions for that day appeared in your bank account.

Meet an instance

All your bank transactions were imported using a CSV file on 31st Jan. The banking concern statement rest was €300 and the last transaction imported was a receipt for €200.

On 1st February, we re-continued the bank feed and started downloading new transactions, merely the depository financial institution balance was out by €100.

Afterwards checking the banking concern account, you lot found receipt dated 31st January for €100 which was not included on our concluding import file.

We entered the receipt manually as an Other Receipt.

Creating transactions manually

Choose the 24-hour interval after the engagement the final transaction was entered.

Check whether you take transactions in your banking company business relationship that accept not been entered manually however. This might happen if you checked your banking company account before all transactions for that day appeared in your depository financial institution business relationship.

Come across an example

You lot entered the last transaction you could come across on your banking company business relationship for 31st January. The bank statement rest was €300 and the terminal transaction was a receipt for €200.

On 1st February, you lot re-continued the banking concern feed and started downloading new transactions, but the depository financial institution residuum was out by €100.

After checking the bank account, you found receipt dated 31st January for €100 which you lot had not previously entered. You entered the receipt and now the bank balance is correct

Merely waiting for the bank feed to be upward and running

Cull the day after the final transactions were downloaded from your bank feed.