Knowledge base

1 min read

XLS to QIF conversion

A few of our clients have recommended this tool for converting data from Excel format to QIF for use with bookkeeping applications/cloud...

1 min read

Import corrections from Excel

Right click on a job within StatementReader to select an Excel file that was previously created by StatementReader and refresh the job...

1 min read

Searchable PDF

You should check or uncheck the 'parse PDF' option based on the input file that you have selected. If your file is a searchable PDF...

1 min read

Extract all lines (previously full-page table)

Under normal circumstances the StatementReader engine is able to analyse a page and detect if a table of transactions is there, where the...

1 min read

[deprecated]Enable real time Excel

This option, which is checked by default, will cause StatementReader to open a new Excel window when you start a job, and use this to...

2 min read

Getting started with StatementReader

To ensure that the application is installed correctly, select an example job from the 'Help' menu. There are two to choose from. Once...

1 min read

How do I create a template for Barclays duplicate statements with column dashes?

This template hasn’t been released as this format often changes depending on which branch printed the bank statements. Here are some...

1 min read

Can StatementReader convert credit card statements to Excel

Yes, StatementReader can read credit card statements. You can use the template creation tool (from the file menu) to create your own...

1 min read

Is there a quick way to write a lengthy IF statement?

When Excel reads a statement that returns TRUE or FALSE, these values are interpreted by the formula as 1 or 0, respectively. Therefore,...

1 min read

What is a CSV file?

CSV (Comma Separated Values) is a file format that is widely accepted when importing data into a variety of different applications. It...

1 min read

What are absolute and relative formulae?

When you copy and paste formulae that reference other cells within a spreadsheet, the cell references are automatically interpreted as...

1 min read

How can I quickly categorise bank transactions using Excel?

Data validation can be used to create a drop down box showing categories that can be easily allocated to individual transactions. This...

1 min read

Is there an easy way to find company data?

If you need to search UK company data by directors, shareholders or financial performance then you should use www.duedil.com. The user...

1 min read

How can I search Companies House data for many companies?

If you have a list of many company names (perhaps creditors or debtors) and you need to check which ones are dissolved or subject to...

1 min read

Balance checks using SUM

Balance checks are used to validate that the data exported from bank statements is correct. They are quick and easy to apply, although...

1 min read

How do I access the advanced configuration options?

If you would like to benefit from the multi-user features that StatementReader provides to share templates, jobs and offline updates with...

1 min read

My issue isn't listed here

If you can take a screenshot of the problem that you are experiencing, please send it to team@statementreader.com, alternatively please...

1 min read

Some transactions are missing

Column headings are used by StatementReader to identify where the transactions begin on each page. If some pages of the bank statements...

1 min read

The summary sheet in Excel isn't using the correct column for transaction narrative

UPDATE: An option has now been introduced for the user to decide before processing a multi-narrative statement format which column should...

1 min read

Descriptions and numbers are misread

StatementReader uses a process called OCR to read and interpret images that contain text. In order for StatementReader to perform this...