Thank you for your feedback

Bank Statement and CSV Upload Guide

Interested in setting up our Open Banking or BankBolt integration?

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 bank 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'.

If you are unsure how to obtain the CSV we have provided some links for the banks’ guidance on exporting CSV files:

If you reconcile regularly, you’ll also be able to pay yourself and take dividends in full confidence that you’re taking the right amount.

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. 

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:

  1. Date (must be in UK format - DD/MM/YY).

  2. Reference/Description (to identify the bank entry by name).

  3. Paid In & Paid Out (this can either be combined in one column or separated into individual columns, as shown below).

  4. 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? 

Need to match several client payments to one bank statement entry?

Made a mistake during bank reconciliation and need to undo the transactions?

Last Updated: 08 Nov 2019 09:24AM GMT
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete