When to import transactionsIf your bank feed isn't connected or unavailable, you can import transactions. You can import your bank statement using a CSV, QIF, or OFX file. You can usually download this from your online bank account.If you only use bank feeds for a small number of transactions you may want to wait until your bank feed is available. Alternatively, enter your bank transactions manually.
What you need to do- Download or export transactions from your online bank account as a CSV, QIF or OFX files.
- Import the file into Sage Accounting.
- Process the transactions exactly as you would from your bank feed. Your bank rules will still apply.
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. Read how to Import a bank statement using AutoEntry >
Tips to download the file from the bankEvery bank is different, so we cannot advise on how to find and download the required file. However, where possible, we recommend you follow these tips: - Depending on your bank, this might be download or export. The format should be as CSV, QIF or OFX files.
- The date range you use is important. To ensure you don't duplicate transactions, note the last transaction imported from your bank feed.
- Where possible, choose a date range. The starting date should be the day after you downloaded the last transaction from your bank feed.
- Make a note of your statement end balance. You will need this when reconciling your statement.
- If you download a CSV file, amend the downloaded CSV file to make sure it's in the required format.
Prepare the CSV fileIf 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. For more details on how to prepare the CSV file, read our Import bank statement article >
Import your statement- Go to Banking.
- Select Actions on the relevant bank account.
- Choose Import statement.
- Select the relevant file type. Then follow the steps to upload your bank statement file.
For detailed steps and troubleshooting advice, read our Import bank statement article >
Process your transactionsImported transactions appear on the Incoming bank transactions screen, the same as if they are from your bank feed. To help you identify which ones you've 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 apply.
When your bank feed becomes availableOnce your bank feed is available, you'll need to authenticate with your bank. Make sure you have your online bank account credentials handy. Some banks may also send a code to your mobile phone or via email for additional authorisation. For steps on how to connect to your bank feed read the relevant article below: Connect Sage Accounting to your bank (UK) > Connect Sage Accounting to your bank (IE) > [BCB:299:UKI - Personal content block - Dane:ECB][BCB:306:UKI - Search override - Accounting UK / IE:ECB][BCB:276:UKI - hide back button:ECB]
|