Interested in setting up our Open Banking or BankBolt integration?
For Barclays, Halifax, HSBC, Lloyds, Natwest & Santander, please see here.
For Metro Bank’s automated bank feed, please see here.
For Cater Allen’s automated bank feed, please see here.
Uploading your bank statements to your Crunch account to reconcile your transactions is a vital part of keeping good accounting records.
If you haven’t set up an automated feed between your bank to Crunch, you can manually upload your statement using a CSV file format. CSV stands for “Comma Separated Values”. It’s a standard file type that almost all spreadsheet programs (such as Microsoft Excel, Google Sheets, or Apple Numbers) can work with.
The Comma Separated Value (CSV) format is available from most of the major banks in the United Kingdom. CSV files are used by banks and by us to format electronic statements.
If your bank only provides a Microsoft Excel .xls download, you can easily convert the file into a .csv: simply open this file in a spreadsheet application such as Microsoft Excel or Apache Open Office, click 'Save as' and select '.CSV'.
Once you’ve uploaded a bank statement to your Crunch account, you can quickly and smoothly reconcile the expenses and invoices you’ve recorded to the entries on your bank statement.
If you reconcile regularly, you’ll be able to pay yourself and take dividends in full confidence that you’re taking the right amount.
Fancy some visual assistance?
- Watch our handy video for Reconciling your Crunch account, or if you'd like a faster import we’ve got you covered by a quick clip which you can enlarge by selecting:
How do I get .CSV files from my business bank?
Most high street banks will let you download a .CSV file of your business bank statements that you can upload directly into your Crunch account. You can usually do this by logging into your online banking and searching for transactions or statements. Many banks will also let you choose the date range you’re downloading.
Each bank has a slightly different process, so how you extract this data will change from bank to bank. Some have a self-explanatory “Export” or “History” section, but others may require a little more digging.
Unfortunately, not all banks let you download the complete history of your transactions. Some banks will only let you go as far back as 90 days, which makes regularly downloading and reconciling your bank statements in Crunch even more important.
If you need any help uploading your .CSV bank statement once you’ve downloaded it, you can check out our uploading a bank statement guide for more information.
What should my CSV look and how should I format the columns for my upload?
While different banks may use different structures and formatting in their .CSV files, we only need four/five columns of data to upload a bank statement to Crunch without a hitch:
Date (must be in UK format - DD/MM/YY).
Reference/Description (to identify the bank entry by name).
Paid In & Paid Out (this can either be combined in one column or separated into individual columns, as shown below).
Balance (this is very important, each transaction in Crunch must align from the previous balance to the next).
For example, a correctly formatted .CSV ready for upload should look similar to this:
When uploading it into Crunch, please ensure that the columns in Crunch match the columns presented in the .CSV file, as shown below:
Once you’re satisfied everything is as it should be, select ‘Upload CSV’ at the bottom of the page. You should now be able to reconcile your account.
Can I upload a .CSV if it has no balance column?
Our bank statement analyser relies on the presence of a balance column for each statement entry. However, as long as there’s at least one statement entry placed either at the top (first transaction) or at the bottom (final transaction) with a balance, the rest of the balance column can be empty, as Crunch will automatically calculate the balances for all of the other entries.
For example, this .CSV would be acceptable:
If your statement contains no balance column whatsoever, you can use a spreadsheet program such as Microsoft Excel or OpenOffice to add a new column and type in the correct balance for just one entry.
The app will then calculate the other entries' balances when you upload your statement.
Is there an Expense on your bank statement but nothing to “match” in Crunch?
If there’s an expense you’ve paid on your bank statement that you haven’t yet added to your Crunch account, check out our guide on how to quickly add an expense during bank reconciliation
Need to match several client payments to one bank statement entry?
Made a mistake during bank reconciliation and need to undo the transactions?
- Check out our guide for unreconciling your Crunch account