top of page
Knowledge base
Search
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,...
bottom of page