How do I use a bank statement template to extract my transactions?
Follow the steps below to use StatementReader template files that we have sent you. Note that if you have already set this up, you may...
top of page
Knowledge base
Search
1 min read
How can I compare the numbers within the transaction narrative with the credit or debit amount?
You can use one of Excel's text formatting formulas to identify whether the credit or debit matches the numbers in the transaction...
1 min read
How can I strip out the recipient from the transaction narrative?
Some text manipulation can be used to cut out the sections of the narrative that interest you. This formula looks for 'from' or 'to' and...
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
Can I identify unlikely transactions, such as those occurring on a weekend?
Yes, the ‘key transactions’ area of the analysis shows the user transactions falling on a weekend (Friday or Saturday, as defined in the...
1 min read
How to identify reversed transactions in Excel
Transactions that are reversed within a user defined number of days, with one or two credits that equal (or are within an acceptable %...
1 min read
How do I use the most accurate OCR technology?
We are committed to providing the fastest and most accurate bank statement extraction solution to all of our clients. StatementReader can...
1 min read
Can you demonstrate StatementReader to my team?
We are on hand to help you to explain, demonstrate and provide training on the StatementReader application, either remotely or in-person,...
1 min read
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...
1 min read
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,...
1 min read
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...
1 min read
Who needs StatementReader?
Anyone who would like to convert transactions displayed on paper or PDF bank statements to Microsoft Excel quickly and accurately, has a...
1 min read
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...
1 min read
Edit your own template
If you have created your own template, you can quickly edit the options that you selected. Using the correct options will make the data...
bottom of page