Knowledge base

1 min read

How do I identify missing words from the transaction narrative?

Certain words can be located within the narrative (separate from the other analysis features such as categories) and the existence of any...

1 min read

How are bounced transactions identified?

Bounced transactions can be identified in a similar way to other categories, i.e. as receipts, payments or both that contain the...

1 min read

Step by step guide to categorising transactions automatically with StatementReader

First, click Options -> Analysis options, then select the ‘categories’ area. Here you can see all categories and, when one is selected,...

1 min read

Can Excel transactional data be analysed in Excel without data from scanned bank statements?

Yes, to do this the user must click ‘New bank analysis’ from the File menu within StatementReader and configure the ‘Data structure’...

1 min read

What other settings are available for advanced configuration of the transaction summary?

Other options available are: - Show options window to user before the analysis is processed for temporary changes to be made (e.g. add...

1 min read

What is available in the summary tab (for each account, where multiple accounts are analysed)?

- weighted average - month on month change - category totals (including transactions specified on the ‘additional income’ tab) -...

1 min read

Can I change the analysis options before the analysis is processed?

Yes, see the ‘general’ section of the analysis options to control whether the user can make temporary changes to the analysis parameters...

1 min read

Can the transactions be sorted in ascending order?

Yes, see the ‘General’ section of the analysis options to configure this feature. This allows for sorting at bank template, page and...

1 min read

Can Excel data be incorporated into the analysis of scanned bank statements?

Yes, to do this the user must configure the ‘Data structure’ section of the analysis options when the job is being processed; this...

1 min read

Can the transaction analysis manage bank accounts in multiple currencies?

For all analysis tabs the currency (and amounts) will match the bank statement, except for the overall analysis tab, which is calculated...

1 min read

Can transactions between accounts being analysed be identified?

Yes, see the ‘key transactions’ tab for a list of transactions that meet this criteria. This is only shown when multiple bank accounts...

1 min read

Can the daily sum of amounts be included when analysing reversed and recurring transactions?

Yes, simply select the checkbox in the ‘Key transactions’ and ‘Recurring transactions’ areas of the analysis options window. All...

1 min read

Can I identify cash transactions > CURRENCY5k or the top 10?

Yes, these are automatically shown in the ‘Key transactions’ tab, with the amounts as percentage of total credits or debits shown in a...

1 min read

How can I ensure that opening and closing balances match on each bank statement?

StatementReader provides an automated validation of the extracted transactions. This checks that the debits, credits and balance figures...

1 min read

Can I change the automated StatementReader analysis of my bank statements?

Yes, once the analysis is generated, it is immediately opened in Excel without any restrictions so the user can use the full power of...

1 min read

How do I save the first page of each processed bank statement to Excel?

To embed the first page from your bank statements to a separate sheet of the Excel analysis, tick the ‘Images’ checkbox in the ‘Summary...

1 min read

Extract password protected bank statements

Any document password protection is automatically recognised by StatementReader once a new file is selected for data extraction. If a...

1 min read

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,...

1 min read

Offline bank statement OCR solution

An offline version of StatementReader is available. This is typically required by closed network, banking clients. If this is something...

1 min read

Automated bank statement corrections

Once a scanned document has been converted to Excel, StatementReader can check and correct date and amount errors that may have been...