Knowledge base

4 min read

Bank statement extraction

Do you regularly need to extract bank statements from paper versions, PDFs or JPEGs? You might be dealing with one page or hundreds; if you

1 min read

Excel Top Tip #3 - Picking apart formulas

Here is the email sent to all subscribers on 25 June 2020. To receive Excel top tips just like this, you can subscribe by clicking here....

1 min read

How can StatementReader help bookkeepers?

First and foremost, it can help you demonstrate why you meet the criteria for a job, meet industry regulations and impress your boss....

1 min read

How can StatementReader help solicitors?

Learn more about the ways StatementReader can be the secret weapon in catapulting your career. Meet the criteria Job adverts for this...

5 min read

Convert PDF tables to Excel

You’re facing deadline. You need to convert your PDF table to Excel – and quickly. But the huge selection of tools available online that pro

2 min read

How can StatementReader help insolvency practitioners/forensic accountants?

First and foremost, you must demonstrate why you meet the criteria for a job, meet industry regulations and then impress your boss. ...

1 min read

Excel Top Tip #2 – See the structure

Here is the email sent to all subscribers on 22 May 2020. To receive Excel top tips just like this, you can subscribe by clicking here....

2 min read

StatementReader: Support best practice

You may have gathered that we love serving our users with fast and personal support; and since most people have to support someone in...

2 min read

The first "Excel Top Tips – a monthly helping hand from StatementReader" email

Here is the email sent to all subscribers on 23 April 2020. To receive Excel top tips just like this, you can subscribe by clicking...

1 min read

How can I change the date of the opening and closing balance?

If EODFromDayOne_1_0 is set to 1, then the opening balance is used as the EOD balance from the 1st of month 1 of the analysis, and the...

1 min read

What do the summary graphs show?

The graphs displayed in the summary tab show the total monthly amounts (split by debits and credits) and the monthly balance mid-points...

1 min read

How do bounced transactions affect other analysis areas?

If BouncedFlagEOD_1_0 is set to 1, transactions within the ‘bounced’ tab are removed from the EOD balances for the day in which they...

1 min read

How do excluded transactions affect other analysis areas?

If ExclusionFlagEOD_1_0 is set to 1 and ExclusionFlagEOD_type is set to ‘normal’, excluded transactions are removed from all EOD balances...

1 min read

How do I analyse transactions for multiple bank accounts together?

When analysing transactions from an Excel document, you can select multiple input Excel files from the file browser window (where each...

1 min read

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

1 min read

What does the rolling average section of the analysis show?

‘Rolling average’ is defined as the 3 month rolling average of daily total activity (credits+debits), this generates 3 (‘X') values for...

1 min read

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

1 min read

How to extract transactions from Barclays bank statements that have been printed by a branch

The Barclays branch print out format can be extracted using StatementReader although the structure changes depending on the branch that...

1 min read

How do I set up the analysis options and switch between profiles?

All options set from the Options -> Analysis options window will be used as default the next time the user runs an analysis. In the...

1 min read

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