Knowledge base

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

How are categories identified by StatementReader?

Categories can be identified as receipts, payments or both that contain user defined keywords (either as a whole or part of a word); the...

1 min read

What rules are used to define the reference number?

The reference number is compiled of the first number with more than 3 consecutive digits from the transaction narrative....

1 min read

How do I remove or include the excluded transactions from the balance and turnover figures in Excel?

The user can decide to ignore the transactions identified on the ‘Excluded’ tab by changing the named value ‘ExclusionFlag_1_0’ within...

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 identify high value transactions > X% of total credits?

This parameter is set within the ‘Key transactions’ section of the Analysis options window, and the transactions identified are shown in...

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

How do I incorporate a new tab with additional transactions that are not shown on the bank statement

To automatically add an additional sheet for additional income check the ‘create additional income tab’ checkbox within the ‘Summary...

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

How do I analyse transactions for multiple bank accounts together?

First, extract the data for each bank account in StatementReader, either using file mode or folder mode. Once you have a separate line...

1 min read

Analyse transactions for multiple bank accounts

Multiple jobs containing transactions for separate bank accounts can be analysed in a single click using StatementReader. Key sections of...

1 min read

No transactions were extracted from my bank statements

If no data was extracted from your bank statements then it is likely that the template selected within StatementReader did not match the...