Payment Processor Payout Reconciliation

Every processor, marketplace and card reader payout traced back to its orders, fees, refunds and disputes through its own clearing account, so online sales in the books agree with the shop and the bank.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Payment Processor Payout Reconciliation, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help you organise decisions about money. It is not financial, investment, tax or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with a qualified, licensed adviser in yours. Investing and trading can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

201

Starter tasks

🧾 Finance & Accounting

Payment Processor Payout Reconciliation

Matching card processor, marketplace and payment app payouts to orders, fees and refunds so online sales and the bank agree.

  1. Register of every payment channel and processor
  2. Payout report archive for each processor
  3. Clearing account for each processor in the books
  4. Coding rules for fees, refunds and chargebacks
  5. Payout report column map
  6. Settlement timing for each processor
  7. Order number carried through to the processor
  8. Opening clearing balance agreed per processor
  9. Unreconciled payouts backlog assessment
  10. Catch-up payout reconciliation, oldest month first
  11. Weekly payout matching session
  12. Monthly clearing account reconciliation
  13. Monthly bridge from shop sales to bank deposits
  14. Refund and partial refund review
  15. Chargeback and dispute ledger
  16. Reserves and held funds tracker
  17. Marketplace settlement statement reconciliation
  18. Unmatched payout lines chase list
  19. In-transit payouts at month end
  20. Card terminal end-of-day batch matching
  21. Processor fee check against the agreed pricing
  22. How a payout is built from charges, fees and refunds
  23. Reading a processor balance report
  24. Recording online sales gross, not net
  25. Chargebacks in the books, from notice to outcome
  26. Gift cards, store credit and discounts in the bridge
  27. Foreign currency payouts and conversion costs
  28. Instalment and buy now pay later settlements
  29. Spreadsheet payout reconciliation without a connector
  30. Choosing a payout reconciliation connector
  31. Summary journals or line-by-line import decision
  32. Payout frequency decision
  33. Effective fee rate by sales channel
  34. Negative payouts and processor debits from the bank
  35. Year-end processor reconciliation pack
  36. Annual processor payment summary agreed to the books
  37. Peak trading season payout readiness
  38. Switching payment processor without losing a payout
  39. Shop platform migration cutover
  40. Responding to a frozen or held processor balance
  41. Founder's first month of online sales in the books
  42. Market stall and pop-up card reader sales
  43. Food delivery platform payouts for restaurants
  44. Tips and service charges through card terminals
  45. Handing payout reconciliation to a bookkeeper
  46. Payout reconciliation status board for a finance team
  47. Processor accounts across several entities or currencies
  48. Platform payouts to sellers through connected accounts
  49. Automated daily payout reconciliation with variance alerts
  50. Payout reconciliation evidence for auditors

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Register of every payment channel and processor

Online businesses rarely take money through one route: a card processor on the website, a wallet button, a marketplace, a card reader at events, an instalment provider at checkout.

First tasks

  • List every checkout option currently live on the website and in the shop
  • Search twelve months of bank statements for payout deposits by sender name
  • Record account ID, currency, login owner and payout bank account for each channel
  • Match each channel to its ledger account or flag it as missing

Payout report archive for each processor

Processor dashboards keep detailed data for a limited time and change their export formats without warning, yet the payout report is the only document that explains why a deposit is the amount it is. Downloading the monthly payout and balance reports for each processor into one folder gives every reconciliation a fixed source and gives the accountant evidence that does not depend on someone's login.

First tasks

  • Create a report folder for each processor in the register
  • Find the report in each dashboard that lists the transactions within each payout
  • Download the current and previous financial year's payout detail reports
  • Save last month's payout detail report for every processor @recurring(monthly:2)

Clearing account for each processor in the books

Recording a payout as sales on the day it reaches the bank loses the fees, the refunds and the timing, and makes the books disagree with the shop's own sales report every month. A clearing account per processor, where gross sales go in, fees and refunds come out, and payouts move the balance to the bank, gives each processor its own small balance that should always explain itself.

First tasks

  • Agree with your accountant where processor clearing accounts sit in the chart
  • Create one clearing account per processor in the accounting software
  • Recode last month's payout deposits as transfers from the clearing account
  • Write a one-paragraph note of how each processor's entries should flow

Make it yours.

Install Payment Processor Payout Reconciliation, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.