mmmmmmmpivottables
My payment reconciliation is very simple.
Each moth has it's own tab. On that tab is a "Payments Expected" section. When I do a shop I put an entry into that section in the month I expect to be paid. It includes the date payment is due per their terms, the MSC, client, location, and total expected payment. That section is sorted by date. When I get a payment I simply cut and paste it from that section into the "Payments Received" section. My summary page links that so at the end of the year I have a simple glance at my summary page and can see exactly what my total income for the year was. I can also look at the Payments Expected section and see immediately if any payments are past due. At the end of the month everything unpaid gets cut from that month and pasted at the top of the expected payments for the next month. Not only is it easy to see what's past due and what's upcoming, I also have an easy to see total of how much I expect to be paid for each month. It's a pretty handy system.
There are reasons that a body stays in motion
At the moment only demons come to mind