Knowledge base

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing...

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

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

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

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

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

How do you work with your clients? Quickly get to know more about how we do business with some points we live by: Supporting new users...

Ever come across a bank statement with transactions that flow to the next line? These are tricky to extract into Excel, as the last...

A statement format that looks nice, but makes extracting transactions difficult is showing two dates in the same column like this: See...

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

If you can't select the text in your PDF bank statement, then you have a scanned image. To extract your transactions with StatementReader...

Select the text from your PDF bank statement, copy, then paste into notepad - if you see gibberish or different characters in notepad,...

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

Lloyds TSB send out bank statements like this: Some of the text here is searchable, and some is an image, so the OCR engine skips the...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Certain words can be located within the narrative (separate from the other analysis features such as categories) and the existence of any...

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

Bounced transactions can be identified in a similar way to other categories, i.e. as receipts, payments or both that contain the...

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

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

First, click Options -> Analysis options, then select the ‘categories’ area. Here you can see all categories and, when one is selected,...

Selecting the correct template allows StatementReader to extract the transactions from your bank statement accurately. To help with the...

Yes, analysis profiles can be selected, created, changed and deleted from the Options -> Analysis options window. The dropdown box shows...

Initial setup of StatementReader - Download and install the application from here. - Run the application and register your email address....

We recommend that you use these scanner settings to optimise documents for OCR accuracy: Main ’Scan settings’: Original Type -> Text...

We recommend that you use these scanner settings to optimise documents for OCR accuracy: Resolution: 300DPI Default Content: Text...

We recommend that you use these scanner settings to optimise documents for OCR accuracy: Application -> Scan to Folder Scanning -> Image...

We recommend that you use these scanner settings to optimise documents for OCR accuracy: File format - PDF or multi-page TIF (the latter...

We recommend that you use these scanner settings to optimise documents for OCR accuracy: Main ’Scan settings’: Original Type -> Text...

We recommend that you use these scanner settings to optimise documents for OCR accuracy: Quality Density (Format type): Multi-page TIFF...

Each bank summary shows the month on month trend percentages for total amounts, debits and credits. Months are highlighted in this...