How can I create a new bank template?


The ability for the user to create new bank templates for immediate use are a key differentiator of StatementReader. These can be saved, edited and shared on a local network drive, to suit your needs. There are several options that are available in the template creation tool, these include:

Footer

This is text that identifies the end of the table on a page. Multiple footers can be separated by ||. Where multiple footers are specified, they should be entered in the same order that they are likely to appear on the bank statement.

Table start override

In addition to using the table headers, the text specified here is used to refine the starting coordinates of the table. For example, ‘balance forward’, may be entered here for this line to be removed from the transactions extracted within a table. Multiple entries can be separated by ||.

Date type

The StatementReader engine uses pre-set date formats to ensure that the date extracted is placed into a format that Excel recognises. The user should select from the list provided where an exact match is found.

Date locale

Selecting from this drop down box will allow StatementReader to correct for the locale set on the user’s computer being different to the date locale used on the bank statements processed.

Bottom date

Some bank statements show the date on the bottom line of a transaction. If this is the case for your bank statements, tick this box.

Top balance

Some bank statements show the date on the top line of a transaction. If this is the case for your bank statements, tick this box.

#Templates #Features #All