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.
Recent Posts
See AllRevisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing...