Bank Statement Mappings allow you to take a portion of the transaction descriptions 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 Automatic Bank Reconciliation process.
To access the Map Bank Statement Description option, click on the [Settings] tab at the bottom of the bank reconciliation screen.
Alternatively, Map Bank Statement Description option can be accessed in the Cashflow section, by clicking on Tools/ Map 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. If you have not downloaded a Bank Statement, select a bank from the drop-down menu and click the [Download] button.
- 2. The Map Bank Statement Description screen will default to the Money In section. Click on [Add], and a message will appear asking you to open a Bank Statement File before proceeding. Click [OK].
- 3. A window will appear, defaulting to the Cashflow 12 Bank Folder, for you to select your Bank Statement File (CSV). If you have downloaded the file to another location, navigate to this destination. Select the csv file and click [Open].
- 4. The transactions on your csv file will now load into the Money In section, and in specific columns depending on how the file is formatted (refer to the Adding a New Financial Institution section on formatting the csv).
- 5. To take a portion of a transactions’ description (i.e. a “Customers” 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 field, towards the bottom left corner of the screen, right click and select Paste. This will now paste the word or name in the field. (Refer to the HELP option next to the field for additional information about the Mapping Data field)
- 7. If you wish to have this description added to the Customer column automatically every time you process an automatic bank reconciliation, in the Money In section, click in the checkbox next to Add as Customer. (Refer to the HELP option next to the field for additional information about the Add as Customer field)
- 8. 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.
- 9. Click on [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, repeat the mapping process 5 – 9.
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 the list of Mapped Bank Statement Descriptions, you have the option to modify Mapped Bank Statement Descriptions.
To modify a Mapped Bank Statement Description:
- 1. Highlight the description line by clicking in the square at the beginning of the line
- 2. Click on [Modify]
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. Highlight the description line by clicking in the square at the beginning of the line
- 2. Click on [Delete]