Thank you for your feedback

How to upload a bank statement

Bank reconciliation is very quick and easy.

In order to reconcile the payments you have entered, you will need to match them to the entries on your bank statements. You can do this by uploading a statement to the app.

Firstly, you will need to upload a statement, so navigate to the Banking tab and make sure you’re on the ‘dashboard’. Here you can either use the blue add new statement button in the top right of the screen or click on ‘expand’ and use the ‘import statement’ option:

On the upload statement screen, make sure the desired account is selected and then click choose a file to find the statement file on your computer. Then click upload.

You will then be presented with a preview of your statement.

In this screen it’s important to match the columns in your statement to the fields that we require. In order to match the payments, the app needs your statement to have a date, a reference, a paid in and paid out fields (in one field, or separate fields) as well as a balance field. You can use the drop down boxes at the head of each column to tell us which column is which.

After clicking import statement you will see a confirmation of how many transactions were imported.

You can choose import and start reconciling to begin reconciliation, or click import and be returned to the list of all uploaded statements for that bank account. Navigate back to the banking dashboard and you’ll notice that there is now a red number of entries to match:

Clicking on this (or clicking expand and choosing the similar red entries to match option) will take you to the bank reconciliation screen and you’ll be able to match the statement entries on the left with the entries that you’ve already entered into Crunch, on the right.

Clicking Match will then match these two payments and move them to the Matched entries section at the bottom of the screen.

Sometimes there will be only one possible match, sometimes multiple. If there are multiple matches then all possible options will be highlighted.

Before choosing a match, check that entry matches the statement entry’s date, amount and type (client payment, expense, bank transfer etc.).

When all the payments have been matched, you can move to the Matched entries area and check everything is correct before clicking Reconcile to save your progress:

Sometimes a statement entry will not be a perfect match for the information entered.

  • If you need to match several payments to one statement entry, please see our help topic here.

  • If there is an entry on your statement that does not appear in the app, see how to quick-add from within Bank Reconciliation.

  • If there is a payment that does not match a bank statement entry, perhaps because it is a duplicate, these can be deleted by clicking the red cross next to the item.

After deleting a payment you may need to review your invoices to either record credit notes or allocate the invoice to another client payment.

If you’ve made a mistake in your bank reconciliation and need to undo it, see how here.


Need more help?

Last Updated: 18 Jan 2019 05:18PM GMT
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found