Knowledge base

1 min read

How can I change the date of the opening and closing balance?

If EODFromDayOne_1_0 is set to 1, then the opening balance is used as the EOD balance from the 1st of month 1 of the analysis, and the...

1 min read

What do the summary graphs show?

The graphs displayed in the summary tab show the total monthly amounts (split by debits and credits) and the monthly balance mid-points...

1 min read

How do bounced transactions affect other analysis areas?

If BouncedFlagEOD_1_0 is set to 1, transactions within the ‘bounced’ tab are removed from the EOD balances for the day in which they...

1 min read

How do excluded transactions affect other analysis areas?

If ExclusionFlagEOD_1_0 is set to 1 and ExclusionFlagEOD_type is set to ‘normal’, excluded transactions are removed from all EOD balances...

1 min read

How do I analyse transactions for multiple bank accounts together?

When analysing transactions from an Excel document, you can select multiple input Excel files from the file browser window (where each...

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

What does the rolling average section of the analysis show?

‘Rolling average’ is defined as the 3 month rolling average of daily total activity (credits+debits), this generates 3 (‘X') values for...

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

How do I set up the analysis options and switch between profiles?

All options set from the Options -> Analysis options window will be used as default the next time the user runs an analysis. In 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 I save the analysis options to a profile?

Yes, analysis profiles can be selected, created, changed and deleted from the Options -> Analysis options window. The dropdown box shows...

1 min read

How do I change the minimum percentage for identifying month on month credit trends?

Each bank summary shows the month on month trend percentages for total amounts, debits and credits. Months are highlighted in this...

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

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