HOME / COMMUNITY Switch to knowledge base

Importing your bank statement


#1

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

Once you have obtained one of the above files you can then start the upload process by first navigating to the bank statement screen to which you would like to add the data.

You can find a list of your commonly used bank accounts on your main Dashboard.

Don’t forget you can now also connect an automatic bank feed with Yodlee

On your statement screen you will see a button ‘Upload Statement’. Click the button to continue.

On the “Upload Banking Data” screen you will see a list of bank names in a drop-down menu. Select the appropriate bank from the list. Listed banks are recognized by QuickFile and it will not be necessary to manually allocate the columns (for CSV). If you are uploading an Excel (CSV) file and your bank is not listed, select the “Other” option.

You will now need to upload your bank statement file to QuickFile. Browse for the location of the file on your local computer and then click the ‘Upload’ button.

Uploading a CSV file and selecting option “Other” when nominating your bank will bring up a preview of the CSV file showing the order of the columns and the first 4 rows of information. You will need to tell QuickFile where to look for the ‘Transaction Date’, ‘Description’ and ‘Amount’ in the green bar above the table. Please, in each case where the corresponding information can be found, highlight the column and once you have completed this, click on the “Save” button below.

When uploading a new bank statement QuickFile will automatically check for any potential duplicate entries. If a suspected duplicate entry is found, you will be given the option to ignore and save the new entry or to skip to the next one.

Once your entire statement has been uploaded you will see a confirmation message. You are now ready to start tagging your bank transactions. Be sure to read our guide on Bank Transaction Tagging to save time on your bookkeeping.


Santander Bank Statement Upload Error
How to do three months of bookkeeping in 30 minutes
Barclays bank feed
Linking PayPalback History
Using quickfile for my ltd company and rental business instead of Excel
Chrome plugin not exporting statement for Lloyds
Salaries are showing incorrectly
Merging 3 different accounts into one
Recurring Supplier Costs
Bank feeds not running
Amazon Business
Paypal feed removed. (Reason : Method Specified is not Supported)
Bank import from GoCardless
Welcome to the Knowledge Base
Barclays Feed Not Working 23 Oct 15
Importing Directors Expenses from expense software