Business Background
The client is a direct-to-consumer online retail brand that manages sales through an online storefront and receives customer payments through multiple payment processors. As the business grew, its payment flow became more complex, with each processor following its own settlement schedule, fee structure, and payout process. This created a need for accounting records that could track sales from the initial customer order through the final bank deposit.
The business was using both a card processor and a buy-now-pay-later processor, creating different paths between sales and cash. Processor fees, rolling reserves, and payments still in transit also needed to be accounted for separately. GATP was brought in to keep the books current and create a reliable connection between reported sales, processor activity, and cash received in the bank.
Key Challenges
The business faced several accounting challenges caused by multiple payment processors, different settlement schedules, and gaps between recorded sales, processor activity, and actual bank deposits.
- Sales Not Matching Deposits: Gross storefront sales were being reduced by processor fees and reserves before payouts reached the bank, making deposits difficult to reconcile back to the original sales.
- Multiple Processor Settlement Schedules: The card processor and buy-now-pay-later processor settled transactions on different timelines, creating timing differences between the sales recorded and cash received.
- Growing Undeposited Funds Balance: Transactions recorded as received but not matched to processor payouts accumulated in undeposited funds, making it difficult to identify which amounts were still in transit.
- Negative Clearing Account Balances: Delays in recording processor deposits caused clearing accounts to move negative, signaling that the books were no longer accurately tracking money moving through the payment processors.
- Multi-State Sales Tax Tracking: Online sales across multiple states required sales tax to be tracked accurately and connected to the amounts collected through the payment processors.
These issues made it harder to connect the storefront’s reported sales with actual cash activity. Without a clear reconciliation process, fees, reserves, timing differences, and outstanding payouts could distort revenue and leave management without a reliable view of the business’s financial position.
Impact
The accounting gaps created uncertainty around one of the most important questions for the business: did the sales recorded by the online store actually become cash in the bank? Because two payment processors followed different settlement schedules, deposits did not consistently match the timing or value of storefront sales. Processor fees and rolling reserves further reduced payout amounts, while undeposited funds and clearing-account balances made it difficult to see which transactions were still in transit. This affected the clarity of revenue reporting and made routine reconciliation more difficult.
Without a structured process, these differences could remain hidden until a month-end or year-end review. The business needed a clearer way to separate gross sales, processor fees, reserves, and payouts while keeping sales tax activity organized. Reliable processor-level reconciliation became essential for maintaining accurate books and understanding actual cash movement.
Requirements & Expectations
The business needed an accounting process that could accurately track sales from the online storefront through each payment processor and into the bank. The expectation was to separate gross sales, processor fees, reserves, and payouts rather than record only net deposits. It also required clearing accounts for each processor, regular reconciliation of undeposited funds, visibility into money still in transit, and consistent multi-state sales tax tracking. The process needed to provide current, reliable books and identify reconciliation issues before they became larger problems.
Strategic Approach
GATP established a processor-level accounting structure that followed each transaction from sale to settlement and final bank deposit. Separate clearing accounts were created for the card processor and buy-now-pay-later processor, allowing sales, fees, reserves, and payouts to be recorded independently. Processor deposits were matched to the orders behind them, while undeposited funds were cleared against actual payouts. Weekly reconciliation and balance reviews provided visibility into outstanding activity, helped identify negative clearing balances quickly, and supported consistent sales tax and accounts payable tracking.
Comprehensive Solution
GATP implemented a structured reconciliation process designed to connect every storefront sale with processor activity, fees, reserves, payouts, and the final cash deposited in the bank.
- Processor-Specific Clearing Accounts: Separate clearing accounts were established for each payment processor, keeping transaction activity organized and making it easier to trace sales through settlement.
- Sales and Payout Reconciliation: Processor payouts were matched against the orders behind them, ensuring deposits were connected to the corresponding sales rather than recorded as revenue on their own.
- Fee and Reserve Tracking: Processor fees were recorded separately, while rolling reserves were tracked as amounts still owed to the business instead of reducing reported revenue.
- Undeposited Funds Cleanup: Transactions were moved out of undeposited funds only when matched to actual processor payouts, keeping the account limited to legitimate money still in transit.
- Weekly Financial Monitoring: GATP reviewed bank activity, processor balances, accounts payable, unpaid bills, and sales tax activity weekly to identify discrepancies before they became larger accounting issues.
This approach gave the business a clearer transaction trail, stronger reconciliation controls, and greater visibility into how online sales moved through processors and into cash.
Measurable Results
The new accounting structure improved visibility across sales, payment processors, and cash, giving the business a more reliable process for tracking transactions and identifying reconciliation issues.
- 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
For a growing online store, accurate accounting requires more than matching bank deposits to sales. Every transaction can move through a payment processor before the business receives the cash, with fees, reserves, settlement timing, and sales tax affecting the final payout. Using a separate clearing account for each processor creates a clearer trail from the original sale to the bank deposit. Regular reconciliation also keeps undeposited funds from becoming a catch-all balance and makes unusual clearing-account activity easier to identify. With this structure in place, the business can distinguish gross revenue from processor deductions and understand which funds have been received, held, or remain in transit. The result is a cleaner set of books that provides a more dependable view of sales, cash flow, and financial performance.
Client Impact
The business now has greater confidence in the connection between storefront sales, payment processor activity, and cash received in the bank. Separate clearing accounts provide clearer visibility into outstanding payouts, processor fees, and reserves, while weekly reviews help identify discrepancies sooner. Undeposited funds no longer carries unexplained activity, and sales tax tracking is more organized across states. With these improvements, management has a more dependable financial picture and can review sales and cash movement without relying on net deposits alone.
Conclusion – Let’s Talk
For ecommerce businesses using multiple payment processors, accurate books depend on tracking every transaction from the storefront to the final bank deposit. A clear reconciliation structure can prevent fees, reserves, timing differences, and outstanding payouts from creating unexplained balances. GATP helps growing businesses build reliable accounting processes that connect sales to cash and provide clearer financial visibility. If your books do not fully explain where your ecommerce sales go, it may be time to strengthen the process behind them.
