Start with gross orders or charges, then show refunds, disputes, processor fees, reserves, prior adjustments, and the resulting deposit as separate lines. Link each component to the processor report and bank activity so a reviewer can trace a payout without relying on the net deposit alone.
Processor payout reconciliation for a Philippines bookkeeper
Reconcile gross sales, fees, refunds, reserves, and net deposits so Philippines bookkeeping support can explain processor timing without forcing the bank to match sales.
Published · 8 minute read
The short answer
- Start with the processor settlement report, not the net bank line.
- Separate timing, fees, refunds, reserves, and missing deposits.
- Keep account mapping and write-off decisions reviewable.
Build the settlement bridge
Explain one payout
If a processor reports $10,000 in gross sales, $300 in refunds, $120 in disputes, $250 in fees, and a $9,330 bank deposit, the bridge ties exactly: $10,000 − $300 − $120 − $250 = $9,330. The workpaper should also show the settlement date and source report. A Philippines bookkeeper can match the net amount to the bank and flag any actual residual; the finance owner decides the treatment of an unexplained fee, timing item, or processor error.
Match by settlement period
Use the processor’s settlement date and the bank’s deposit date as separate fields. A deposit that crosses month-end may be a valid timing difference rather than an error. Preserve both dates so the reviewer can see the cutoff.
Track open settlement items
Keep an open-item list for payouts initiated but not received, refunds posted after settlement, and reserves released later. Reconcile the next statement to that list and retain the processor report version used so the explanation remains reproducible.
Explain residuals
Each residual should have a category and next action: missing report, unmatched order, delayed refund, reserve movement, duplicate posting, or account-mapping question. Do not bury a small difference in a generic fee account without proof.
Reconcile refunds and disputes
Tie customer refunds and chargebacks to their source transactions and approval records. The bookkeeper records the evidence; the business decides on contested disputes, customer remedies, and any write-off.
Review the chart mapping
Check whether fees, reserves, refunds, and sales are consistently posted under the written accounting policy. A proposed mapping change should include examples and reviewer approval before it is applied broadly.
Keep a repeatable close file
Save the settlement report, calculation, bank match, open-item log, and reviewer note together. This makes the work useful to a controller and gives the offshore role a clear recurring handoff.
Questions owners ask
Why does a processor deposit not equal sales?
Fees, refunds, disputes, reserves, and settlement timing can reduce or delay the deposit. Reconciliation should show each bridge explicitly.
Can offshore support prepare this reconciliation?
Yes, if the role has the reports and accounting access needed to match activity. A finance owner should approve unusual adjustments and mapping changes.