Two tables: Balance by Manufacturer (given, paid back, outstanding, status)
and Payment History (period, manufacturer, estimated, actually paid,
difference, notes).
Record a payment
1
Choose Record Payment Received
2
Pick the manufacturer and period
The period is the month, as
YYYY-MM.3
Enter the amount received
What actually landed, not what you expected.
4
Add notes
Especially when the amount differs from the estimate — the note is what lets
you query it later.
Reading the difference column
Estimated against actually paid is the point of this page. A small gap is normal. A consistent shortfall from one manufacturer is worth raising with them — and the payment history is the evidence.Accruals cannot double-count: if a weekly run is repeated, the same sale is
not booked twice.