Prior to this solution, the brokerage’s monthly billing was managed through a fragmented and "chaotic" Google Sheet. This manual process required accounting staff to hand-calculate complex assistant fee splits, proration for mid-month plan changes, and various agent credits. This was not only time-consuming but also prone to human error, which directly impacted revenue and agent trust. The business required a scalable, in-platform solution capable of processing thousands of financial line items with 100% mathematical accuracy and a clear audit trail.

I developed a suite of Apex Batch Jobs within a custom billing application, "The Reckoning", to replace manual spreadsheets with programmatic precision. By leveraging batch processing, I ensured the system could handle massive data volumes such as calculating leap-year adjusted prorations and multi-agent fee splits without encountering governor limits. To enhance the user experience for the accounting team, I integrated the AsyncApexJob object into a custom UI, providing real-time progress tracking and transparent error reporting for every billing cycle.