Bank Statement Mapping Rules

Sage One Accounting allows you to map descriptions to certain recurring transactions displayed on your bank or credit card statement.

Map Descriptions

This feature allows you to link the Bank Statement Description to a bank or credit card transaction that occurs frequently, so that when your bank or credit card statements are imported, the transactions will automatically be posted to the correct accounts.

The Bank Statement Description will be mapped to the Type, Description and VAT Type of the transaction.

You can create Map Descriptions via the Banking grid by clicking on the map link on the transaction line. The following Bank Statement Mapping Rules screen displays:

The imported Bank Statement’s Description will automatically populate into the first field of the screen. If you would like to change the imported description of the transaction to a more meaningful and more relevant description, enter the new description in the second field. This is an optional field. The new description will display on all of the processing screens, enquiries and reports.

To view your mapped transactions, go to Banking…Lists…Bank Statement Mapping Rules.

Checking for duplicate transactions will notify you of possible duplicate transactions that you can review before processing.

Click on the Save button to save your mapped transactions.

When you import your next Bank Statement, enter a description, or part thereof, in the Bank Statement Description field. Sage One Accounting will use the saved description to search for the corresponding imported bank or credit card statement and allocate the transaction details accordingly.

Maintenance

Sage One Accounting allows you to add, edit or delete Map Descriptions. To access the maintenance screen go to Banking…Lists…Bank Statement Mapping Rules.

The following screen displays:

All of your saved Map Descriptions will be listed in this screen.

To add a new Map Description, click on the grey plus button at the end of the line. A new line will display. Complete each column field with the transaction details and the Bank Statement Description to search for.
To delete a Map Description, click on the grey minus button at the end of the line.

Click on the Save button to save the new or changed Map Descriptions.