StatementReader is used by forensic accountants, bookkeepers, insolvency investigators, solicitors, auditors and business review professionals to stop wasting time and talent converting bank statements into Excel

This website uses cookies to enhance the user experience.  Click here for our cookie statement and here for our privacy policy.

All Rights Reserved 2012-2019 Suave Software Limited. London, England, United Kingdom. Email Us

  • LinkedIn Social Icon
  • Twitter Social Icon

Transaction summary, automated and comprehensive in Excel

Once the scanned bank statements have been processed, StatementReader will automatically create a summary report in Microsoft Excel that will analyse the following:

 

Keywords

Each unique word in each description cell is counted, and the associated transaction amount is accumulated to present two tables. The first table shows the keywords that appear the most number of times and the second shows the keywords that has the greatest monetary total. For each keyword, the the earliest and latest date on which it appeared is also shown.

 

Days

Whilst analysing the daily totals for a company in a state of increasing or decreasing operations, importance can be incorrectly placed on the days at the beginning or the end of the period. Therefore, the StatementReader summary uses a rolling average of daily totals over a three month period to identify which days have extreme activity, and may require further analysis.

 

Months

The months with the most and least activity, by number of transactions and total amount flowing through the bank account, is concisely summarised in four tables.  

 

Round amounts

One table shows the largest transactions that appear as a round amount. This is defined as a number greater than 1,000 that has no remainder when divided by 100.

 

Recurring amounts

The StatementReader summary shows the amounts that appear many times, together with the description of the first transaction, and the period over which the transactions occurred. This information is sorted by most occurrences and largest total amounts in two separate tables.

 

Level of materiality

Some calculations are used to outline the materiality level of the transactions analysed.

 

User defined search

Once all transactions are in Excel, you can use 'advanced filter' feature in Excel available on the 'data' menu to only show certain transactions, or copy them elsewhere.