SUNNYBILL — SINGLE-INVOICE RECONCILIATION WORKSHEET
Educational worksheet, not a tax invoice, credit note or legal statement.

Prepared by / date:
Client reference (avoid unnecessary personal information):
Invoice number / issue date / currency:
Original invoice total including tax:

VALID ADJUSTMENTS
Credit reference | Date | Reason | Tax-inclusive amount | Evidence location

PAYMENTS ALLOCATED TO THIS INVOICE
Date received | Gross amount | Transaction reference | Allocation evidence
Record processor fees separately; a net bank deposit is not always the amount paid.

COMPLETED REFUNDS
Date | Amount | Original payment reference | Adjustment reference | Evidence
Do not record a proposed refund as completed.

CALCULATION (one currency, no exchange conversion)
Original invoice total:
Minus valid credits:
Minus payments allocated:
Plus cash already refunded:
Equals balance:

Positive = remaining amount due. Zero = settled on these inputs.
Negative = customer credit / overpayment to investigate and resolve.

WORKED EXAMPLE
1,000.00 original - 100.00 credit - 400.00 received + 0.00 refunded = 500.00 due.
If already fully paid: 1,000.00 - 100.00 - 1,000.00 + 0.00 = -100.00 customer credit.
After a completed refund: 1,000.00 - 100.00 - 1,000.00 + 100.00 = 0.00.

UNRESOLVED ITEMS
Unallocated cash / disputed lines / withholding / foreign exchange / next action:
Reviewed by / date:

SunnyBill's calculator checks arithmetic only and does not update your documents.
Keep originals and supporting records. Check your jurisdiction's tax and correction rules.