top of page

How can I ensure that opening and closing balances match on each bank statement?

StatementReader provides an automated validation of the extracted transactions. This checks that the debits, credits and balance figures on each line are correct; where enough validated data exists for the application to make a ’safe’ change of an error, this cell will be shaded in green and if there is a potential error that the user should check the cell containing the balance figure for the transaction in question will be shaded in orange. Hyperlinks from the page column can be used by the user to quickly open the page and check the shaded cells.

validate transactions

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page