top of page
Knowledge base
Search


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


How can I separate the analysis of multiple accounts that use the same bank template?
At the analysis stage the data is combined (into Transactions1, Transactions2 etc) based on the bank_layout column; therefore to separate...
1 min read
Fortnightly cash flow analysis
The total receipts and payments are split between the first and second half of each month and shown as a value and as a percentage of the...
1 min read
Monthly balance analysis
End of day balances are automatically identified and summarised in Excel, showing the minimum, maximum and average for each month, and...
1 min read


How can I tell who or where the account holder has most activity? Use the transaction keyword summar
StatementReader identifies keywords by [number of occurrences or total value], with a detailed breakdown showing the first and last date...
1 min read
Detailed financial summary in Excel
StatementReader performs a comprehensive summary of any number of transactions, in a single click. The user can set a variety of options...
1 min read


How to identify recurring payments and receipts in Excel
The ‘recurring transactions’ area of the analysis options allows the user to identify daily / weekly / fortnightly / monthly / quarterly...
1 min read
How can I categorise and separate transactions using StatementReader?
Transactions are categorised using a user specified keyword list and order of prioritisation; these can be edited and added to by user. ...
1 min read
Duplicate transactions in Excel
StatementReader identifies and separates duplicate (or unique) payments or receipts using a combination of the date, description, amount...
1 min read
bottom of page