Knowledge base

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 of these words can be flagged to the user within the summary tab. This feature is enabled by selecting the ‘identify missing words’ checkbox. The specified words can be found as separate words or as part of other words, as required, by selecting the ‘find as separate words’ checkbox. #All #Transactionsummary #Features

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 specified keywords in the narrative. In addition, bounced transactions can be identified as being reversed within [2] days and a difference of up to [CURRENCY100] where [neither, one or both] of these is in [Cash] category. Also, transactions can be listed from the 'fee' category (must exist) within [E] days and with a value less than [CURRENCY100]

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, the other settings that have been configured (including the keywords, whether the category is output as a separate tab in Excel, and also whether the transactions matching the keywords are restricted to receipts/payments/both). Additionally, you can set the order of priority incase more than one category matches against a single transaction

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’ section of the analysis options; this includes setting the column mapping (e.g. for the date, description, amount and balance columns) and browsing for the Excel file containing the transactions. #Transactionsummary #Features #All

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 account specific keywords [See ‘General’ within the analysis options window] -Once completed, automatically save the analysis output to a specified directory [See ‘General’ within the analysis options window] #Transactionsummary #Features #All

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) - fortnightly turnover analysis - monthly balance analysis - monthly category analysis #Transactionsummary #Features #All

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 (e.g. add account specific keywords) at ‘runtime’. #Features #Transactionsummary #All

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 transaction level. Also, once the transactions are in ascending order, missing balance figures can also be completed (again, see the ‘General’ section). #Features #Transactionsummary #All

1 min

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 includes setting the column mapping (e.g. for the date, description, amount and balance columns) and browsing for the Excel file containing the additional data. #Features #Transactionsummary #All

1 min

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 by multiplying the currency exchange rate shown on each individual bank analysis tab. #Features #Transactionsummary #All

1 min

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 are merged and analysed together. #Transactionsummary #Features #All

1 min

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 transactions for the particular day (including debits and credits) will then be listed in the recurring transactions tab(s). #Features #Transactionsummary #All

1 min

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 separate column. #Features #Transactionsummary #All

1 min

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 on each line are correct; where enough validated data exists for the application to make a ’safe’ change of an error, this cell will be shaded in green and if there is a potential error that the user should check the cell containing the balance figure for the transaction in question will be shaded in orange. Hyperlinks from the page column

1 min

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 Excel to manipulate it to suit their needs. If there are other tabs that should have been included, simply return to the Analysis options window (either when the job is being processed or from the Options menu), edit the parameters available and right click on the job in StatementReader to process the analysis again. Contact us for any additi

1 min

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 selection’ section of the Analysis options window. #All #General #Features #Transactionsummary

1 min

Extract password protected bank statements

Any document password protection is automatically recognised by StatementReader once a new file is selected for data extraction. If a file cannot be used by the StatementReader engine without a password, then the password must be provided by the user. The user is prompted of this with an input box. Once the correct password is provided, the data extraction, validation and analysis process can continue. #Features #All

1 min

How can I create a new bank template?

The ability for the user to create new bank templates for immediate use are a key differentiator of StatementReader. These can be saved, edited and shared on a local network drive, to suit your needs. There are several options that are available in the template creation tool, these include: Footer This is text that identifies the end of the table on a page. Multiple footers can be separated by ||. Where multiple footers are specified, they should be entered in the same orde

1 min

Offline bank statement OCR solution

An offline version of StatementReader is available. This is typically required by closed network, banking clients. If this is something you require, contact us, and we can discuss the information we will require to provide you with an offline version of StatementReader. If you use the application offline, we provide update files to a software administrator. This file can be placed in a shared network folder so that multiple users’ installations can be updated easily, and mana

1 min

Automated bank statement corrections

Once a scanned document has been converted to Excel, StatementReader can check and correct date and amount errors that may have been introduced during the character recognition process. There are two types of corrections that can be selected, safe or unsafe, each of which can be applied to either the dates or amounts. Errors that are identified and corrected in the dates and amounts will be highlighted in Excel. Orange cell shading signifies error, green means a correction