LedgerLens converts two fictional recurring exports into a consistent management report. The working product calculates gross revenue, net revenue, accepted orders, average order value, and refund rate.
The quality gate excludes invalid records and explains every rejected row in an exportable exception log. The sample intentionally contains duplicates, invalid dates, an unsupported currency, a negative amount, an unmatched refund, and an over-refund so the failure handling can be reviewed rather than assumed.
This is an independent portfolio project built with fictional data. It does not contain client information.
Independent fictional-data case study: reusable CSV dashboard with five metrics, row validation, exception logs, exports, and a documented refresh workflow.