Automated bank statement corrections
Once a scanned document has been converted to Excel, StatementReader can check and correct date and amount errors that may have been introduced during the character recognition process. There are two types of corrections that can be selected, safe or unsafe, each of which can be applied to either the dates or amounts.
Errors that are identified and corrected in the dates and amounts will be highlighted in Excel. Orange cell shading signifies error, green means a correction has been made. To get started, right-click on a completed job.
When a date is in an incorrect format but the date before and after are the same (say 1 January 2015), StatementReader can safely assume that the incorrect date should also equal 1 January 2015.
When a balance figure is displayed on consecutive lines, StatementReader can use multiple lines to calculate whether an error lies in the receipt, payment or balance column, and make the appropriate correction. This is a safe assumption.
Other date corrections can also be completed, for example assuming that the previous correct date should be used for any subsequent incorrect dates. This is fast but slightly unsafe and so requires the user to select this option.
Unsafe amount checks assume that the balance column is always correct, and the receipt or payment column should be corrected.
Recent PostsSee All
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