This article will explore Bank Statements, a module within Bookkeeper.

1. Bank Statement

This module allows users to import bank statements supplied in electronic format. It requires the user to have permission to access it.

Import Bank Statement

The main interface of the module lists the bank accounts and allows the user to select a bank account with its bank statements.  Opening the bank account will give the user the option to import a bank statement. 

Click the Import Statement button. This will open a 5-step wizard which will lead you through the import process.

The import wizard walks the user though the process in a similar way to the Bulk Import module. It allows the user to:

• Search for and select a file to import
• Set the delimiter options
• Map the fields
• Set a default narration (if not mapped) and date format
• Save the template and/or import 
   

At the end of the import process click Finish. You will be returned to the Statement Details dialog.

Changing Transaction Settings

The imported transactions are then displayed. All debits are imported as "Receipts" by default and all credits as "Payment". The type of transactions can be changed by selecting them, right-clicking and selecting the desired transaction type (see below) or by clicking on "Set Type" on the toolbar.

Other details on the transaction can be edited by selecting “Edit” and then changing them on the collapsible pane on the left.

Generating Batches

This feature allows for the generation of Bank Charge and Interest batches from the Bank Statement module. 

To do this the user should select the Interest and/or Bank Charge transactions that they wish to create a batch for by checking the check boxes next to the required transactions and then clicking on the Generate Batch button on the toolbar. The user will then be able to enter some details required for the batch.