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:
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 ||.
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.
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.
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.
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.
Recent PostsSee All
Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo