Selling through an online store, marketplaces, and other channels gives customers more ways to buy—and creates several records of the same transaction. Your store may record the order, a processor may report the payment, and a marketplace may send a payout after fees. Treating every record as a separate sale inflates revenue. A reliable bookkeeping process connects these records, distinguishes sales from cash deposits, and makes it easier to reconcile accounts and understand channel performance.
Map Each Channel’s Records
List every place an order can originate and every system that handles its payment. For each channel, note where you can find order totals, refunds, taxes, discounts, processing fees, and payout details. This map helps you identify which system is the source for each type of information instead of importing overlapping reports without a plan.
Assign a clear role to each record. An order report can support gross sales and discounts; a processor statement can support fees and settlement activity; a bank statement can confirm the deposit. A marketplace payout report may combine several orders, refunds, fees, and reserves. Keep the reports that explain the activity, but do not treat each one as new revenue.
Record Sales Once
Choose a consistent method for recording sales. You can record individual orders or summarize activity by channel and date, provided the totals tie back to detailed reports. In either case, create the sale from the order or marketplace data—not again from the processor payout or bank deposit. Use separate channel labels or accounts so you can compare results without duplicating income.
When a processor transfers funds to your bank, record the transfer as a movement between accounts, not as another sale. The sales record increases revenue and creates an amount due from the processor. The payout then clears that amount, with fees, refunds, or reserves recorded separately as applicable. This keeps bank deposits aligned with cash received while preserving the full sales picture.
Reconcile Fees and Refunds
Reconcile each processor or marketplace payout to its settlement report. Start with the orders included in the payout, then account for refunds, chargebacks, fees, taxes collected or remitted, and any reserve or timing adjustment shown in the report. The payout should explain the net amount deposited; it will often differ from gross sales because these items affect the settlement.
Record refunds against the original sales channel when possible, and keep chargebacks distinct from ordinary refunds. Categorize processing and marketplace fees consistently so you can review them by channel. If a refund or fee appears in more than one export, use the settlement and order references to confirm whether the records describe one event before entering it.
Use a Repeatable Close
Set a regular schedule to download channel and settlement reports, import or enter transactions, match payouts to bank deposits, and investigate exceptions. Use a consistent date basis, such as order date for sales and settlement date for processor transfers, and document that choice. Timing differences between an order and its payout are normal; leave them open for follow-up rather than forcing a match.
Keep a reconciliation record with the report period, channel, gross sales, refunds, fees, payout total, and unresolved differences. Review unusual changes and transactions that lack an order or settlement reference. Crescent Ledger helps ecommerce sellers organize channel activity, but any business can use this workflow with its own accounting system and source reports.
The key is to separate the sale from the payment records that follow it. Use order data to record revenue once, settlement reports to explain fees and net payouts, and bank records to verify deposits. A consistent channel-by-channel reconciliation makes errors easier to spot and monthly reporting more dependable. If you need help refining your process, consider speaking with an ecommerce bookkeeping professional.