Ecommerce payment reconciliation ties each storefront sale to the processor that settled it and to the bank deposit that followed. For an online brand paid through a card processor and a buy-now-pay-later processor, GATP set up one clearing account per processor. Gross sales, fees, rolling reserves and payouts now post separately and are reviewed weekly.
Business Background
A Direct-to-Consumer Brand Paid Through a Card Processor and a BNPL Processor
The client is a direct-to-consumer online retail brand. It sells through its own storefront and collects customer payments through two processors: a card processor and a buy-now-pay-later processor. As the business grew, each processor kept its own settlement schedule, fee structure and payout process.
That split created two separate paths between a sale and the cash behind it. The buy-now-pay-later side adds its own cost layer. In the CFPB’s 2022 market study, “fees merchants paid to BNPL lenders” go by the name merchant discount fees. The card side carries its own processing fees, and rolling reserves held back part of each payout before it reached the bank.
GATP was brought in to keep the books current and to build a reliable link between reported sales, processor activity and cash in the bank. The work sits on the same foundation as any sound ecommerce bookkeeping setup: every order has to be traceable from checkout to deposit.
Key Challenges
Five Gaps Between Storefront Sales and Bank Deposits
Two payment processors on two settlement schedules opened five gaps between recorded sales, processor activity and actual bank deposits.
- Sales not matching deposits: Processor fees and reserves came out of gross storefront sales before payouts reached the bank. Deposits were hard to reconcile back to the original sales.
- Two settlement schedules: The card processor and the buy-now-pay-later processor settled on different timelines. Sales were recorded in one period while the cash landed in another.
- A growing undeposited funds balance: Transactions recorded as received but never matched to a processor payout piled up in undeposited funds. It was hard to tell which amounts were genuinely still in transit.
- Negative clearing account balances: Processor deposits were recorded late, so clearing accounts went negative. That was the signal the books had stopped tracking money moving through the processors.
- Multi-state sales tax tracking: Online sales reached customers in several states. The tax collected had to be tracked and tied to the amounts the processors actually collected.
The sales tax point carries its own weight for online sellers. In South Dakota v. Wayfair (2018), the Supreme Court dropped the physical-presence rule. South Dakota could then require remote sellers to collect tax “as if the seller had a physical presence in the State” once they crossed its thresholds. Together, these gaps left management without a reliable view of the business’s financial position.
Impact
Why Net Deposits Hid Processor Fees, Rolling Reserves and Deposits in Transit
The accounting gaps put one question in doubt: did the sales the online store recorded actually become cash in the bank? With two processors on different schedules, deposits did not match storefront sales in timing or in value.
Processor fees and rolling reserves cut each payout further. Undeposited funds and clearing-account balances blurred which transactions were still in transit. Revenue reporting lost clarity, and routine reconciliation got harder.
The gross-versus-net gap also matters outside the books. Processors that file Form 1099-K report a gross figure. The IRS Instructions for Form 1099-K define it “without regard to any adjustments for” fees, refunds or discounts. Books that record only net deposits start below the figure a processor reports.
Without a structured process, these differences could stay hidden until a month-end or year-end review. Processor-level reconciliation became essential to keeping the books accurate and the cash picture honest.
Requirements & Expectations
Ecommerce Payment Reconciliation Requirements: Gross Sales, Fees, Reserves and Payouts
The business needed an accounting process that tracked sales from the storefront through each payment processor and into the bank. Five requirements defined it.
- Gross sales, processor fees, reserves and payouts recorded separately, not as a single net deposit.
- A clearing account for each processor.
- Regular reconciliation of undeposited funds.
- Visibility into money still in transit between processor and bank.
- Consistent multi-state sales tax tracking.
The process also had to keep the books current. Reconciliation issues needed to surface early, before they grew into larger problems.
Strategic Approach
A Clearing Account for Each of the Two Payment Processors
GATP built a processor-level accounting structure that follows each transaction from sale to settlement to final bank deposit. The card processor and the buy-now-pay-later processor each received a separate clearing account. Sales, fees, reserves and payouts for each one are recorded independently.
Processor deposits are matched to the orders behind them. Undeposited funds is cleared against actual payouts, not against expected ones. Order-level support is also what the IRS expects a business to keep. IRS Publication 583 lists bank deposit slips and credit card charge slips among the documents that show gross receipts.
A weekly reconciliation and balance review sits on top of the structure. It shows outstanding activity, catches a negative clearing balance quickly and keeps sales tax and accounts payable tracking consistent. The same matching discipline drove another GATP engagement on multi-platform revenue reconciliation for a tour operator selling across eight booking platforms.
Comprehensive Solution
Five Controls in the Payment Reconciliation Process
GATP put a structured payment reconciliation process in place. It connects every storefront sale with processor activity, fees, reserves, payouts and the final cash deposited in the bank.
- Processor-specific clearing accounts: Each payment processor has its own clearing account. Transaction activity stays organized, and any sale can be traced through settlement.
- Sales and payout reconciliation: Processor payouts are matched against the orders behind them. Deposits connect to the sales they came from and are never booked as revenue on their own.
- Fee and rolling reserve tracking: Payment processor fees are recorded separately. Each rolling reserve is tracked as an amount still owed to the business, not as a reduction in reported revenue.
- Undeposited funds cleanup: Transactions leave undeposited funds only when matched to an actual processor payout. The account now holds only money genuinely in transit.
- Weekly financial monitoring: Every week, GATP reviews bank activity, processor balances, accounts payable, unpaid bills and sales tax activity. Discrepancies get caught before they turn into larger accounting issues.
The result is a clearer transaction trail and stronger reconciliation controls. It is the core of how GATP approaches ecommerce accounting: online sales have to be visible at every step from processor to cash.
Measurable Results
Storefront Sales Now Tie Back to Cash Through Two Clearing Accounts
The new structure produced six changes across sales, payment processors and cash.
- Storefront sales now tie back to cash through dedicated processor clearing accounts.
- Gross sales, processor fees and reserves are recorded in their appropriate accounts.
- Undeposited funds now represents only transactions genuinely awaiting settlement.
- Weekly clearing-account reviews make negative balances and missing activity easier to identify.
- Multi-state sales tax activity is tracked alongside processor collections for better accuracy.
- The business now has clearer financial records for monitoring sales and cash movement.
Key Takeaway
How to Reconcile Payouts From Multiple Payment Processors to the Bank
For a growing online store, matching bank deposits to sales is not enough. A sale often passes through a payment processor before the business sees the cash. Fees, reserves, settlement timing and sales tax all change the final payout.
A separate clearing account for each processor creates a clean trail from the original sale to the bank deposit. A clearing account should return to zero once its payouts land. Any balance left behind is a deposit in transit, a held reserve or an error worth chasing.
Regular cash reconciliation keeps undeposited funds from becoming a catch-all balance. It also makes unusual clearing-account activity easy to spot. With that in place, a business can separate gross revenue from processor deductions and see which funds were received, held or still in transit.
Client Impact
What Management Can Now See Without Relying on Net Deposits
Management now has more confidence in the link between storefront sales, processor activity and cash in the bank. The two clearing accounts show outstanding payouts, processor fees and reserves at a glance. Weekly reviews surface discrepancies sooner.
Undeposited funds no longer carries unexplained activity, and sales tax tracking is organized across states. Management can review sales and cash movement without relying on net deposits alone.
Conclusion: Let’s Talk
Ecommerce Reconciliation Built Before the Year-End Review
For an online brand on more than one payment processor, accurate books depend on tracking every transaction from the storefront to the final bank deposit. A clear reconciliation structure stops fees, reserves, timing differences and outstanding payouts from turning into unexplained balances.
GATP Solutions builds that structure for 7-figure ecommerce brands. Rolling reserves and unsettled payouts are money owed to the business, and our accounts receivable outsourcing keeps those balances tracked until the cash arrives.
Do your books fully explain where your ecommerce sales go? Contact GATP to tighten the process behind them.
