Bank Statement Mapping allows you to take a portion of the transaction description that are always present in the downloaded bank statement (typically Customer and Supplier Names), and select which column you want these transactions placed in when automatically adding records to Money In and Money Out during the Imported Bank Reconciliation process.

To access the Map Bank Statement Description option, when in the Reconciliation section:
1.Select the [Imported Reconciliation] option
2.Click on the [Reconciliation Setup] button
3.Click on the [Map Bank Statement Description] button

Add a Mapped Bank Statement Description:
To map your downloaded bank statement, please follow these instructions:
1.Click on the [Map Bank Statement Description] button – here, the Map Bank Statement Description screen will appear showing a Money In and Money Out section. It is recommended to download your bank statement, in csv format, prior to this process.

2.The Map Bank Statement Description screen will default to the Money In section. Click on [Add]. A Map Bank Statement Description screen will appear, allowing you to Open a Bank Statement File (the downloaded bank statement csv).


3.Click on the [Open Bank Statement File] button. An Open screen will appear – navigate to the location of your downloaded bank statement (E.g. Desktop). Click on the file and [Open]. 


4.The transactions on your csv file will now load into the Money In section.


5.To take a portion of a transaction’s description (i.e. a Customer’s Name), highlight the word or name by using your cursor. Then right-click on the word or name and select [Copy].

6.In the 'Mapping Data 1 field', right-click and select [Paste]. This will now paste the word or name in the field. You can now select the column you wish these transactions to be allocated, by accessing the drop-down menu in the Money In Column To Map To field. You can also add this description as a Customer, by ticking the [Add as Customer] cell. 

7.Click [Save]. A message will appear asking if you wish to close the screen. If you wish to map more transactions, click [No]. To add more transactions, follow steps 5 &6.
Once you have completed mapping the Money In section, repeat the mapping process in the Money Out section. To access the Money Out section, click on the [Money Out] tab in the mapping screen. This will be related to Money Out transactions, allowing you to add portions of the description as “Suppliers”, and allocating transactions to Money Out columns.


Modify a Mapped Bank Statement Description:
On a list of Mapped Bank Statement Descriptions, you have the option to modify Mapped Bank Statement Descriptions.

To modify a Mapped Bank Statement Description:
1.Select the description line, by clicking in the cell at the beginning of the line.
2.Click on [Edit].
3. If a bank statement file (CSV) has already been opened, the transactions will be displayed and both the 'Mapping Data 1' and 'Money In Column To Map To' fields will be available to change.
4.Click [Save]. A message will appear asking if you wish to close the screen. Click [Yes] if you have finished modifying the record.


Delete a Mapped Bank Statement Description:
On the list of Mapped Bank Statement Descriptions, you have the option to delete Mapped Bank Statement Descriptions.

To delete a Mapped Bank Statement Description:
1.Select the description line, by clicking in the cell at the beginning of the line.
2.Click on [Delete].

Did this answer your question?