Debitoor Tutorials

Step-by-step guides to manage your accounting

Automatic bank reconciliation

Get started with automatic bank reconciliation

On one of our larger Debitoor plans, you can make use of automatic bank reconciliation. This means quickly and easily matching the entries in your bank statement to invoices or expenses in your account. All in a few clicks.

We’ll take you through the quickest and easiest way to ensure your accounts are balanced using this great Debitoor feature.

Simply upload your bank statement in .CSV format, find your bank, and let Debitoor do the rest. Your payments will be matched before you can pour a cup of tea.

Uploading your bank statement

1. Make sure your bank statement is in .CSV format. Most banks provide this format, although some may provide Excel format which you can open in Excel and save as .CSV

2. Log in to your Debitoor account and click on the ‘Payments’ tab. Click on the folder ‘Add a bank account +’ and a window will pop up:

tutorial_7autobankrec2.png

3. Enter the name of your bank and select it from the dropdown list. Click ‘Next’

4. A window will appear asking you to ‘Upload a bank statement’. Click on this button and select your .CSV file from your computer and click ‘Next’

5. You will be asked to confirm which columns refer to the corresponding values.

tutorial_7autobankrec4.png

6. Once you select the necessary information, including the balance of the account, you can click ‘Next’.

tutorial_7autobankrec5.png

7. You can give this bank account a name, if you wish.

8. That’s all! Click ‘Next’ and Debitoor automatically matches the transactions from the bank statement you have uploaded with the invoices or expenses in your account.

tutorial_7autobankrec.png

Need a little more guidance? Check out our video for a walk through uploading and auto-matching payments with automatic bank reconciliation:

Still have questions? Contact us at [email protected] or chat with us in-app!