Social media client order reconciliation worksheet
Reconcile the exact ordered service and quantity with the platform's order record, charge and any recorded settlement. Keep purchased delivery separate from organic outcomes. A completed promotion order does not prove that it produced enquiries or sales.
Your working document
Complete the record
| Record | Compare with | Keep distinct |
|---|---|---|
| Ordered quantity | Order confirmation | Current public count, which can change for other reasons |
| Charge | Wallet debit reference | Supplier cost or an unrecorded estimate |
| Status | Current order details | An assumption based on elapsed time |
| Refund | Actual settlement and wallet credit | A requested refund that has not been credited |
| Campaign outcome | Defined enquiry or order evidence | Purchased delivery and total platform views |
Check before sharing
- Use the same order reference throughout the reconciliation.
- Check whether a refund is requested, approved or actually credited.
- Keep currency and quantity units visible.
- Raise an unresolved difference with the appropriate support route.
Use the worksheet in practice
If an order reports a remaining quantity, use the order's own status and settlement record to interpret it. Do not calculate and promise a client refund from a snapshot without confirming the actual settlement.
The client report can show promotion expenditure beside organic content work, with clear labels. Combining them into one growth figure obscures what the client bought and what the content achieved independently.