Note: To use this feature, you need to first export a bank statement from your bank account to a csv format and save it to your computer’s hard drive.
You can import an existing bank statement (from any bank) into your Billdozer system. Billdozer analyses all successfully imported bank statements and looks for known account numbers and recognised amounts contained inside the payment description or reference and amount columns.
Billdozer will then try to identify which client made the payment by matching account numbers and amounts in the imported bank statement with account numbers and unpaid invoice amounts on the Invoice Management screen in Billdozer.
Information on imported bank statements is displayed under the following headings:
- Batch Number – Click the View Batch Log (magnifying glass) icon to view detailed information about the batch. This information displays the import log from start to finish, and is typically used to help isolate errors in the import process.
- Created on – The date on which the banks statement was imported.
- Created by – The name of the person who imported the bank statement.
- Stage – The stage of the import process, for example Import.
- Status – The import status, for example Started, Complete, Failed.
- Progress – A progress bar that displays the percent complete progress of the import process (0 to 100%).
- Type – The import type, for instance Bank Statement.
- # – The number of transactions on the bank statement.
- From – The start date of the bank statement.
- To – The end date of the bank statement.
Matched accounts and payments are displayed on the Accounting > Bank Statements screen. Refer to Accounting > Bank Statements to see how Billdozer uses matched account numbers and amounts to allow you to acknowledge payment on unpaid client invoices by, for example, issuing a quick receipt.
Once a bank statement has been imported successfully, the configuration is automatically added to the Upload Templates. These are also displayed in the Existing upload configurations drop-down on the Bank Statement Import screen to facilitate quicker and easier importing of bank statements using an existing configuration (column assignment).
