Tolerance Matching: Amounts Within a Few Cents and Dates Within N Days
This lesson is part of the course
In this lesson
You round the differences between ledger and statement to cents, accept amounts within ± 0.05 and dates up to three days apart, and count the lines that match within both tolerances.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Match or Missing: COUNTIF in Both Directions & Status Flags Locked
- Composite Keys: Customer & Invoice, Stripped Prefixes and False Matches Locked
- Duplicates Inside a List: COUNTIF, First Occurrences and Inflated Totals Locked
- Changed Values: XLOOKUP the Other List and Flag Each Field Locked
- Tolerance Matching: Amounts Within a Few Cents and Dates Within N Days Locked
- Partial Keys: Matching on the First Characters and Finding Numbers Inside Text Locked
- The Reconciliation Summary: Totals A vs B, Explained and Unexplained Differences Locked
- The Exception Report: A Numbered List of Every Open Item Locked