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