Uploading your bank statement to QuickFile is easy. Most UK banks will enable you to download a file containing your transactions from within your online banking application.

QuickFile currently supports the following file types:

• Excel (CSV)
• Microsoft Money (OFX)
• QuickBooks (QBO)
• Quicken (QIF)
• Text file (TXT) - Santander only

PDF statements can’t be imported. Download one of the file types above from your online banking instead; we don’t recommend converting a PDF with an online converter.

Once you have your file, you upload it from the statement screen of the QuickFile bank account you want to add the transactions to.

Prefer to watch?

Import using a template

We have a list of common banks with templates already set up. If your bank is listed, QuickFile already knows the layout of its file, so you don’t need to match up any columns. If it isn’t, use Other (see below).

1. Go to Banking and click View next to the bank account you want to add the transactions to.

2. Click Options, then Upload statement.

   

3. On the Bank - Upload Data to (account name) screen, choose your bank from the Please select your bank list.

   

4. Click Choose file and select the file you downloaded from your bank.

5. Click Upload.

QuickFile checks the file for possible duplicates (see below), then shows how many transactions were saved to your account.

Import using “Other”

If your bank isn’t listed, or its template doesn’t read your file correctly, choose Other. You then tell QuickFile which column holds each piece of information. This works for CSV files.

1. Click Options, then Upload statement.

2. Choose Other from the Please select your bank list.

3. Click Choose file, select your CSV file and click Upload. QuickFile shows a preview of the first 4 rows of your file.

4. Use the drop-downs above the preview to choose the column for Transaction Date:, Description: and Amount:. The columns are called Column 1, Column 2 and so on, in the same order as your file.

5. If your file has separate columns for money in and money out, tick My CSV statement has two columns for money in and money out, then choose the columns for Money Out: and Money In:.

6. If your file shows money in as a negative amount and money out as a positive amount (some credit cards do this), tick Reverse amounts (Some credit cards).

7. Click Confirm.

   

QuickFile confirms how many transactions were saved, for example 5 Transactions were Saved to Your Account.

Save the mapping as a template

As you have used a custom mapping by selecting Other, you will also be prompted to save it as a template, so next time you don’t need to map the columns again.

1. Click Save as a template next to Speed up your CSV imports and save this as a template.

   

2. Enter a Template name, for example the name of your bank or card.

3. Click Save.

   

Next time, your template appears at the bottom of the Please select your bank list as Custom: followed by its name. Choose it, then choose your file and click Upload: QuickFile uses your saved column choices, including Reverse amounts. To remove a template you no longer need, choose it in the list and click Delete custom template.

What happens if a transaction is already in QuickFile?

When uploading a new bank statement, QuickFile automatically checks for any potential duplicate entries. If a transaction in your file matches one already in the account (for example the same date, description and amount), you’ll see One of the transactions on your CSV file may conflict with an existing transaction., with the new transaction and the possible conflict side by side.

• Click Skip (This is a conflict) if it’s the same transaction. It won’t be imported again.
• Click Save (No conflict here) if it’s a different transaction that happens to match, for example two identical payments on the same day.
• The Take this action with future conflicts tick box is there so you can apply the same choice to any further possible duplicates, rather than answering each one.

Check your imported transactions

Open the bank account’s statement to see the new transactions. Each one shows a red Tag Me status until you tag it, and the Untagged count at the top goes up. Money paid out appears under Money Out and money received under Money In.

Check that the amounts are on the right side and that the balance agrees with your bank statement. If they don’t, undo the import (see below) and upload the file again with the right options.

Now you’ve imported your transactions, you are ready to start tagging them. Be sure to read our guide on Bank Transaction Tagging to save time on your bookkeeping.

How do I undo an import?

If you uploaded the wrong file, uploaded to the wrong account, or the amounts came in wrong, you can remove the whole upload in one go.

1. On the bank account’s statement, click Options, then View recent batch uploads.

   

2. Find the upload in the Recent Batch Uploads list. It shows when it was imported, its type (for example Imported CSV File) and how many of its transactions are tagged and untagged.

3. Click Delete next to the upload.

   

Troubleshooting

All the amounts went into Money In (or Money Out), or the signs are the wrong way round

Undo the import, then upload the file again with Other. Tick My CSV statement has two columns for money in and money out if your file has separate columns, or Reverse amounts (Some credit cards) if money out is shown as a positive amount.

My bank is listed, but its template doesn’t read my file

Banks sometimes change the layout of their files. Choose Other and map the columns yourself, then save it as a template so you only do this once.

“No Transactions Were Saved to Your Account” after the duplicate check

This message also appears when you skipped every transaction in the file as a duplicate, so nothing new was added. If you expected new transactions, check the file covers the right dates and that the columns are mapped correctly.

“Incorrect File Format” when uploading

QuickFile shows You must upload a CSV/OFX/QBO/QIF file here if the file is another type, such as a PDF. Download your statement from your bank in one of the supported formats.

Related topics

New to QuickFile? Start with Welcome to the Knowledge Base for the essential guides to setting up and running your accounts.

• Welcome to the Knowledge Base: Find the essential guides for getting started with QuickFile.
• Tagging your bank transactions: Match each imported transaction to an invoice, payment or nominal code.
• Automated bank tagging rules: Set up rules that tag regular transactions for you.
• Reviewing and Deleting Batch Imports: See your recent uploads and remove one that went wrong.
• Managing Open Banking Feeds: Bring your transactions in automatically every day instead of uploading files.
• Reconciling your bank: Check your QuickFile balance agrees with your bank statement.