Knowledge base

1 min read

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...

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...