A month-end close for a supplement ecommerce business means reconciling sales, payouts, inventory, fees, refunds, tax, and bank balances before finalizing the month.
At SAL Accounting, we see how quickly one missed payout, inventory adjustment, or clearing balance can throw the numbers off. You’ll see exactly what to reconcile each month and where small gaps can quietly turn into bigger reporting problems if they’re left unresolved.
Once the month is reconciled, see what your numbers say with our Ecommerce EBITDA Calculator.
Quick Takeaways
- Reconcile supplement sales separately from bank deposits.
- Match each major sales channel and payment processor every month.
- Keep refunds, fees, tax, chargebacks, and adjustments identifiable.
- Reconcile supplement inventory across fulfillment locations.
- Review samples, damaged units, expired stock, and COGS.
- Clear old payout and clearing-account differences before they roll forward.
Want the whole monthly process handled properly? See SAL’s Ecommerce Accounting Services.
What Should a Supplement Ecommerce Business Reconcile Every Month?
A good month-end close answers one question: Do the books agree with what actually happened during the month?
For an online supplement business, that takes more than checking the bank. Sales may sit in one platform, cash may still be with a processor, and inventory may be spread across a warehouse, 3PL, and marketplace fulfillment centre. Here are the main areas to check:
| Area | Reconcile Against | What You’re Checking | Common Problem |
|---|---|---|---|
| Sales | Channel reports | Gross sales, discounts | Payout recorded as sales |
| Payouts | Settlement reports | Expected vs received | Cash still in transit |
| Processors | Processor reports | Balances, fees | Old clearing amounts |
| Bank & cards | Statements | Recorded vs actual | Missing or duplicate entries |
| Refunds & fees | Channel reports | Amount and timing | Hidden inside payouts |
| Inventory | 3PL/warehouse reports | Units and locations | Missing or duplicate stock |
| COGS | Inventory records | Cost of units sold | Stale or missing costs |
| Tax | Tax reports + books | Tax collected/payable | Mixed into revenue |
| Suppliers | Bills/statements | Amounts still owed | Missing invoices |
This is one reason online supplement business accounting goes beyond basic bank-feed bookkeeping. Several operational systems have to meet in one reliable set of books.
How to Reconcile Online Supplement Sales and Payouts at Month-End
Sales and payouts rarely match on their own. The steps below show how to connect the two:
Step 1: Build the Sales-to-Payout Bridge
A simple reconciliation looks like this:
Gross Sales − Discounts − Refunds − Fees ± Adjustments = Expected Payout
Tax should remain separately identifiable where applicable. Here is a simple example:
| Activity | Amount | Where to Check | Month-End Treatment |
|---|---|---|---|
| Gross sales | $80,000 | Sales report | Record sales |
| Discounts | ($2,000) | Channel report | Keep identifiable |
| Refunds | ($3,500) | Refund report | Record separately |
| Fees | ($4,200) | Settlement report | Record expense |
| Adjustments | ($300) | Settlement report | Review |
| Expected payout | $70,000 | Payout report | Match to cash/clearing |
Shopify separates sales activity from when funds become available for payout, which is why a sale near month-end may not hit the bank until the following month.
Amazon also gives sellers detailed payment activity reports rather than just one final deposit number.
Step 2: Match the Payout to the Bank
Suppose the expected payout is $70,000, but only $67,000 reaches the bank before month-end. That does not automatically mean $3,000 is missing. It may simply still be in transit.
Your supplement revenue and payout reconciliation should make that difference visible instead of forcing the sales report and bank balance to match.
Step 3: Explain What Has Not Cleared Yet
By month-end, every material difference should have an explanation. It may be:
- a payout in transit;
- a refund;
- a fee;
- a chargeback;
- a reserve;
- another settlement adjustment.
Pro tip: Take the largest payout of the month and trace it from sales → deductions → payout → bank. If that trail breaks, investigate it before closing.
- Also read: “Ecommerce Reconciliation Best Practices”
Case Study: How a Leslieville Supplement Brand Explains a $12,000 Month-End Difference
A supplement brand in Leslieville, Toronto sells through its DTC store and a marketplace. The channels report $150,000 in gross sales, but only $138,000 appears in the bank by month-end.
The Problem
Looking at the bank alone makes it seem like $12,000 disappeared. Once we separate the activity, we find:
- $4,500 in refunds;
- $5,000 in channel and payment fees;
- $2,500 in payouts still in transit.
What We Do
We record the gross sales, refunds, and fees separately. Then we match the expected payouts to the deposits received and leave the remaining $2,500 in the clearing account until it reaches the bank.
Result
The full month now reconciles:
$150,000 sales − $4,500 refunds − $5,000 fees = $140,500 expected payouts
And:
$140,500 = $138,000 received + $2,500 still in transit
The seller no longer has a $12,000 mystery. Every part of the difference has an explanation.
How to Reconcile Payment Processors, Banks, and Clearing Accounts
Once sales are reconciled, check where the cash actually sits. Focus on these three areas:
Reconcile Payment Processor Balances
Stripe, PayPal, Shopify Payments, and other processors may hold funds between the customer transaction and the bank deposit. Stripe lets businesses reconcile payouts to the transactions behind them.
PayPal similarly separates payments, refunds, disputes, fees, withdrawals, and balances in its balance reconciliation report. At month-end, a processor balance should either:
- match the underlying activity;
- be on its way to the bank;
- or have another clear explanation.
Your ecommerce payment reconciliation should make that trail visible.
Reconcile Bank and Credit Card Accounts
Now compare the books with the actual statements. A normal bank reconciliation can help identify missing transactions, duplicate entries, fees, and timing differences. Do the same for business credit cards. For a supplement brand, that may catch charges for:
- packaging;
- freight;
- software;
- advertising;
- samples;
- other operating costs.
Review Clearing Accounts
A clearing balance is not automatically a problem.
A payout created on September 30 and deposited on October 2 may legitimately remain open at month-end. What you do not want is an unexplained balance sitting there for months.
Pro tip: Review clearing balances by age. A three-day timing difference and a six-month-old balance should not be treated the same way.
How to Reconcile Supplement Inventory and COGS Each Month
Inventory needs its own month-end check. Here’s where to look for the differences:
1. Reconcile Inventory by Location
Compare your accounting inventory with the records from:
- your warehouse;
- your 3PL;
- marketplace fulfillment centres;
- other material storage locations.
You should know what came in, what went out, and what remains.
2. Separate Sales From Inventory Movements
Not every unit leaving one location was sold. Review:
- customer sales;
- transfers between locations;
- samples;
- promotional units;
- damaged stock;
- expired products;
- other inventory adjustments.
Moving 800 bottles from one fulfillment centre to another should not create another 800 bottles in total inventory.
3. Review COGS
Once the quantities make sense, check whether the cost attached to the units sold also makes sense.
Changing production costs between batches can affect COGS depending on the inventory method being used. That is covered more fully in FIFO vs. weighted-average costing for ecommerce inventory.
Classification matters too. Product cost, freight-in, duties, and required preparation do not always belong in the same place as normal operating expenses. When inventory costs should be capitalized or expensed goes deeper into that issue.
Case Study: How a Port Credit Supplement Brand Finds 650 Missing Units
A supplement brand in Port Credit, Mississauga shows 11,400 bottles in its accounting records. Its warehouse and fulfillment reports show only 10,750. That leaves 650 units unexplained.
The Problem
When we trace the inventory movements, we find:
- 300 bottles sent as samples;
- 150 damaged units removed by the 3PL;
- 200 expired bottles taken out of saleable stock.
None of those movements reached the accounting records.
What We Do
We match the movements to the supporting fulfillment reports, update the inventory quantities, and review the related cost treatment.
Result
The inventory now reconciles:
11,400 recorded units − 300 samples − 150 damaged − 200 expired = 10,750 units
The business starts the next month with an inventory number that reflects what is actually available.
Which Fees, Refunds, and Tax Balances Need a Month-End Check?
Some of the easiest month-end errors are hidden inside payouts. These are the amounts to check separately.
Check Fees and Refunds
Compare the channel and processor reports with the books. Look for:
- marketplace fees;
- payment processing fees;
- refunds;
- chargebacks;
- disputes;
- settlement adjustments.
Etsy, for example, can deduct fees and other activity before the remaining balance becomes available for deposit. If you only record the bank deposit, those movements can disappear.
That is why categorizing ecommerce transactions correctly matters before month-end is finalized.
Check GST/HST Balances
For Canadian supplement businesses collecting GST/HST, compare the tax shown in your channel reports with the tax liability in the books. CRA explains that businesses generally hold GST/HST collected in trust until it is remitted. Look for:
- tax mixed into revenue;
- tax posted to the wrong account;
- differences between channel reports and the books;
- old unexplained tax balances.
For the filing side, GST/HST compliance for ecommerce stores covers the tax rules separately.
What Other Month-End Balances Should an Online Supplement Business Review?
Sales and inventory are only part of the close. A few other balances also need a monthly review:
Manufacturer and Supplier Balances
Review unpaid amounts owed to:
- manufacturers;
- co-packers;
- packaging suppliers;
- freight providers;
- other major vendors.
Also check deposits paid toward future production so you know what those amounts relate to.
Accounts Receivable
This becomes important when a supplement brand also sells wholesale. Review invoices that still appear unpaid and check whether they are actually:
- still outstanding;
- already paid;
- credited;
- written off.
An old invoice that has already been settled should not keep inflating receivables.
Prepaid and Accrued Costs
Review material costs that cross month-end, such as:
- annual software;
- insurance;
- freight;
- large vendor invoices;
- other costs where the payment date and accounting period differ.
The goal is not to create unnecessary adjustments.
It is to keep one month from looking artificially high or low simply because of timing.
What Is the Month-End Close Process for a Supplement Brand?
The close is easier when you follow the same order every month. Here’s a practical sequence:
| Step | What to Review | Main Question | Clean Result |
|---|---|---|---|
| 1. Pull reports | Channels, processors, inventory | Is the month complete? | Source data ready |
| 2. Reconcile sales | Sales, refunds, fees | Does activity tie? | Revenue explained |
| 3. Match payouts | Processors + bank | Did cash arrive? | Timing identified |
| 4. Update inventory | 3PL, warehouse, COGS | Do units and costs tie? | Inventory reconciled |
| 5. Review balances | Tax, AP, AR, clearing | What remains open? | Balances explained |
| 6. Review reports | P&L + balance sheet | Does the month make sense? | Ready to close |
1. Pull the Month’s Reports
Use the same cut-off date for sales channels, payment processors, bank accounts, and inventory reports.
2. Reconcile Sales and Payouts
Confirm gross sales, refunds, fees, adjustments, and expected payouts.
3. Reconcile Banks, Cards, and Clearing Accounts
Match deposits and withdrawals and identify anything still in transit.
4. Update Supplement Inventory and COGS
Tie inventory quantities back to fulfillment records and review samples, damage, expiry, and other adjustments.
5. Check Tax, Suppliers, and Receivables
Confirm what the business still owes and what customers still owe the business.
6. Review the Financial Statements
Finally, step back and look at the P&L and balance sheet. Does the month make sense compared with what actually happened?
A consistent ecommerce bookkeeping checklist makes this much easier than rebuilding several months at year-end.
- Also read: “Shopify Month-End Close Checklist”
How Do You Know Your Supplement Books Are Ready to Close?
Your books are ready when the material balances can be explained without forcing numbers to match.
Sales and Cash
Check that:
- sales agree with channel reports;
- material payouts can be traced;
- bank and credit-card accounts reconcile;
- processor balances make sense.
Inventory
Confirm that:
- inventory agrees with fulfillment records;
- samples and damaged units are recorded;
- expired stock has been reviewed;
- COGS makes sense.
Tax and Other Balances
Review whether:
- fees and refunds are complete;
- GST/HST balances make sense;
- supplier balances are current;
- receivables are still valid;
- clearing accounts contain no unexplained old items.
Final Review
Your ecommerce financial statements should now tell the same story as the month you just operated.
Once the books are complete, some accounting systems also let you close the finished period so earlier transactions cannot be changed casually.
Pro tip: Do not ignore a recurring difference because it looks small. A $500 error repeated every month becomes a $6,000 problem over a year.
