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...
top of page
Knowledge base
Search
- 1 min
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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...
bottom of page