Several Payments, Several Invoices: Running Totals on Both Sides & the Allocation Matrix
This lesson is part of the course
In this lesson
You put Calder Rooms' five invoices and three payments on one money line with running totals, fill a matrix that shows which payment paid which invoice with one overlap formula, and list what is still open per invoice.
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
- Running Totals as the Engine: Cumulative Amounts, What Is Left & Where It Runs Out Locked
- FIFO Payments to Invoices: Oldest First, Allocated Amounts, Open Balances & Part-Paid Flags Locked
- Several Payments, Several Invoices: Running Totals on Both Sides & the Allocation Matrix Locked
- Stock to Orders by Priority: Rank by Two Keys, Demand Ahead & Filled, Part or Zero Locked
- Fair-Share Rationing: Proportional Shares, Whole Units & the Largest-Remainder Rule Locked
- Capacity Allocation: Jobs into Days in Sequence, Finish Days, Dates & Overflow Locked
- Matching Two Lists: Exact Keys, Amount & Date Tolerances and First-Match Rules Locked
- Allocation Dashboard: Unallocated Cash, Check Totals, Exceptions & a Chart Locked