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