New transaction analysis capabilities

We have been adding new flexibility to the StatementReader automated analysis recently, the new features include:


- Show options window to user before the analysis is processed for temporary changes to be made (e.g. add account specific keywords) [See ‘General’]


- Once completed, automatically save the analysis output to a specified directory [See ‘General’]


Image tab


- Embed the first page from your bank statements to the Excel analysis so you always have an easy reference point [See ‘Summary selection’ checkbox]


New tab(s) (as appropriate)


- Add an additional sheet for additional income [See ‘Summary selection’]


- Incorporate other Excel data into the analysis of scanned bank statements [See ‘Data structure’ when the job is analysed]


- Define an Excel column that contains a symbol to signal whether the transaction is a payment (e.g. Dr) [See ‘Data structure’]


Transactions tab


- Sort transactions in ascending order, allowing for combination of corrections at bank template, page and transaction level [See ‘General’]


- Complete missing balance figures [See ‘General’]


- Select between ignoring the transactions identified on the ‘Excluded’ tab by changing the named value ‘ExclusionFlag_1_0’ within Excel (Formulas -> Name manager); this accepts 0 or 1 (0 to ignore, 1 to add back excluded payments and deduct excluded receipts)


Key transactions tab


- Show high value transactions > X% of total credits [See ‘Key transactions’]


- Identify cash transactions > 5k or the top 10, with amounts as percentage of total credits or debits


Recurring and reversed tabs


- Allow for the daily sum of amounts to be included when analysing recurring and reversed transactions [See ‘Key transactions’ and ‘Recurring transactions’]


Summary tab


- Users can click on category summary hyperlinks to go straight to the relevant tab


- Show month on month % increase or decrease for credits, debits and the total


- Show the end of day balance at the 5th 15th and 25th of each month, with the minimum and maximum values. Calculate the average of the identified days, and the overall daily average


- Create a summary of each category by month


- Show the adjusted credits (A) and adjusted debits (B). Calculate the net savings (A-B). Show the loan expenses (C) from above and use this to calculate the Debt Burden Ratio (C/A)