Resource hub
Become a master of your craft
StatementReader is more than an application. We are a valuable business resource which financial professionals rely on to upskill themselves and their teams, and from which companies seek advice to improve their reputations and build stronger client relationships.
Our resource hub provides all the information you might need to get the very most from StatementReader, increase your knowledge of Excel and find out more about your industry.
Your helpful guides
SCANNING BANK STATEMENTS
StatementReader outputs 100% accurate results into Excel from electronically created documents. The quality of scanned documents affects the reliability of the extracted results; here are some tips to improve your results:
Get the original documents (not photocopies), if possible
Scan to 300 DPI TIF or PDF with zero/low compression
Set content as 'text', if possible on the scanner
Use scanner feeder for the consistent alignment of each page
Keep the same page orientation throughout (portrait/landscape)
Each PDF file should contain the same bank template
PROCESSING TRANSACTIONS
StatementReader offers an intuitive interface that requires minimal training - you can see this online here, in our illustrated tutorials. The main points are here:
Select the template that matches your document
Tick 'Parse PDF' if you can select the text in PDF
Check whether the transactions and pages flow in date order when running 'detect and repair transactions'
Analyse keywords, key periods, round amounts and recurring transactions in one-click, use the options menu to configure the settings
CREATE A BANK TEMPLATE
You can create the bank template to extract the transactions from your bank statement if it's not already available from the 100s listed (separated by country) within StatementReader. When using this "create a bank layout" tool, you must:
Always copy column headers (date etc.) exactly from your bank statement
Select from the dropdown boxes showing various data and date types
Check the date and balance position for one multi-line transaction, is the balance at the top or middle or bottom?
You can quickly go back and edit a template by right-clicking on it
Hover your mouse over the options for more information
TROUBLESHOOTING
Our support team takes great pride in seeing your scanned and electronically created documents from PDF all the way through to the Excel you need. Some quick points to check if you're not seeing accurate results are:
If the text in Excel is misread from a scanned image, check that our scanning tips were followed
If data is in the wrong row/column then check the template
For missed pages, run with 'extract all lines' checked
If there are missing/incorrect years, use DATE( ) formula
Always keep in mind that you can request a template from the File menu, and we will return it with your sample data in Excel within 24 hours
Refined date extraction if column dashes exist (Barclays) or the year isn't printed (BNP) 03/2021
Removed need to have Excel installed on user's machine, kept formatting and hyperlinks 12/2020
A more effective and cheaper offline OCR engine 09/2020
See StatementReader in action:
Download some sample bank statements, see the validation and analysis and output in Excel
FAQs
Need to be sure StatementReader is of value for every member of your team? Use our FAQs section below to find out how different job roles benefit from StatementReader, or you can contact us for more information.
-
Excel user “I want to analyse PDF bank statements in two clicks”How do I start using StatementReader? Simply download, install and enter your email address to get started. Next, within the application, choose the bank from the countries and thumbnail images provided, select your PDF file and click ‘go’ to see your data in Excel. It’s as simple as that. Using our demo, you can extract 30 pages to Excel for free. What are the most used features of StatementReader? StatementReader has over 350 built in templates (including 90 from the UK) that are used every working day (and some weekends!) to extract and validate bank statement data in Excel. Also, our users quickly start to impress their teammates with our automated summary that picks out keywords, key days (with extreme activity based on a 3-month rolling average) and round amounts. Illustrated tutorials showing users how to use our most popular features can be found by clicking here. What if StatementReader doesn’t have a template for the bank I’m using? In the event that a template isn’t already built we have an intuitive integrated tool to get users their data in Excel in under a minute. It all starts by dragging some lines to identify the columns and copying the column headers so we can isolate your transactions perfectly. Alternatively, leave it to us and send us a sample directly from the File menu, we’ll get back to you within 24 hours (usually less than two hours) Can you process my document remotely? Yes, we offer a 24-hour turnaround on documents, and templates, although we always aim for less than two hours.
-
IT team “I want to keep case staff happy without another solution to monitor”What is the implementation process? Our clients often like to see a remote demonstration by one of our team, then download and test out the full version of StatementReader (available here) on their own Windows machine. We then provide individual or team training lasting 20-30 minutes, if you require it. Once you start to show others the quick and accurate results from StatementReader, you’ll be able to share a company account code to make it easy for your colleagues to share page credit. We are on hand throughout the implementation process, to answer any questions on document security or the technology behind the program. Does StatementReader need internet connectivity? The full version of StatementReader, available on our website requires an internet connection for page credit authentication and seamless software updates, with optional (though recommended) access to our remote OCR server. However, we often accommodate clients that require an offline or client hosted OCR server amongst other bespoke modifications. Speak to us about your requirements and we’ll tailor everything to your needs. Will we have to support users ourselves? StatementReader’s support services are something that long-term users feedback to us as being one of our best features. So that you are not burdened with yet another application to support across your team, we provide individual or group training on how to get the most from StatementReader, illustrated step-by-step tutorials and also our direct contact details for the quick resolution of any user questions.
-
Compliance team “I want to satisfy the regulatory requirements by checking and documenting common client concerns”Can you explain your Service Level Agreement (SLA) in plain English? Quite simply, we aim for all questions and issues affecting the effective use of StatementReader to be answered within two hours, and definitely within 24 hours. We also offer ongoing communication with the developer in charge of your request, so you can experience high quality, one-to-one support. What is your pledge as software developers and business owners with ACCA and Masters accreditations? We are driven to create software that just works. To us this means constantly testing, listening to our users, and developing intuitive interfaces with elegant code. On this note, if you’d like to take part in a short shadowing or feedback session to guide our development and improvement to suit your firm’s needs, please contact David Elms on +44 (0)20 3287 8283 or send us a message here. What is your stance on data privacy? We are committed to uphold each element of our privacy statement, which can be found here.