Most e-commerce bookkeeping problems don’t start as bookkeeping problems. They start as a task that gets pushed to “next week” three or four times in a row until next week becomes four months ago and nobody’s entirely sure what happened to a chunk of Q2’s refunds.
A checklist doesn’t fix that on its own. What it does is give you a rhythm, something to come back to on a schedule that matches how e-commerce transactions actually move, rather than a vague sense that you should “stay on top of the books” without a clear picture of what that means week to week.
I’ve built this around four cadences, because treating bookkeeping as one undifferentiated pile of tasks is exactly how things start slipping. Some of this needs daily attention. Some of it only matters once a year. Knowing which is which is most of the battle.
Daily and Weekly Tasks
These are the small, low-effort habits that prevent the bigger monthly tasks from turning into archaeology.
Review new orders and payment deposits. Not a deep audit, just a glance to confirm payouts from Shopify, Amazon, or your payment processor are landing as expected and nothing looks obviously wrong, like a payout that’s noticeably smaller than the sales volume would suggest.
Log any manual expenses. Ad spend adjustments, one-off software purchases, anything that didn’t come through an automated bank feed. These are the transactions most likely to get forgotten entirely if they’re not captured close to when they happen.
Flag refunds and chargebacks as they occur. You don’t need to process them fully every single day, but noting them somewhere prevents a surprise pile of unreconciled refund activity at month end.
Monthly Tasks
This is where the real bookkeeping work happens, and it’s the cadence most sellers either do inconsistently or skip during busy months, which is exactly when skipping it causes the most damage.
Reconcile every bank account and payment processor. Match your recorded transactions against actual bank and platform statements. This is the single task that catches duplicate entries, missing deposits, and fee changes before they compound into something harder to untangle. If you’re running multiple channels, this needs to happen for each one, not just your primary bank account.
Review and categorize all transactions. Every expense should land in the right chart of accounts category. Merchant fees, shipping costs, advertising spend, and cost of goods sold should never blend together into a single “miscellaneous” bucket, since that’s where profitability visibility disappears.
Update inventory and COGS. Confirm inventory purchases during the month are properly reflected and that cost of goods sold is being recognized against units actually sold, not simply against inventory purchased. This is one of the more common e-commerce-specific errors, and it’s worth double-checking monthly rather than assuming your software handles it correctly by default.
Review accounts receivable and payable. Less relevant for a pure direct-to-consumer store, more relevant if you also do any wholesale or B2B selling alongside your main channel.
Generate and actually read your profit and loss statement. Not just generate it and file it away. Read it, compare it against the prior month, and notice anything that doesn’t match your intuition about how the month went.
Quarterly Tasks
File and remit sales tax. Deadlines and thresholds vary by state, and multistate economic nexus obligations catch a lot of growing sellers off guard. If you’ve crossed a sales threshold in a new state this quarter, that’s worth confirming rather than assuming last quarter’s filing list still applies.
Review estimated tax payments. If your business structure requires quarterly estimated payments, this is the point to reassess based on how the year is actually trending, not just the number you estimated back in January.
Run a deeper reconciliation pass. Beyond the monthly transaction level check, a quarterly review catches slower-moving issues, things like a subscription that renewed at a different price point than expected or a fee structure change from your payment processor that only becomes obvious once you look at a few months side by side.
Year End Checklist
This is where most of the anxiety in this search topic actually lives, and for good reason, since the consequences of missing something here are more expensive than at any other point in the cycle.
Reconcile the full year, not just the final month. Confirm every month’s reconciliation actually happened and wasn’t skipped during a busy stretch. This is the point to go back and close any gaps.
Conduct a physical or system-based inventory count. Your recorded inventory value needs to match what you actually have on hand or be reasonably close to it. Discrepancies here directly affect your cost of goods sold and your reported profit.
Gather 1099 documentation. Payment processors will issue 1099-K forms based on transaction volume, and you’ll need to reconcile those figures against your own recorded revenue rather than assuming they’ll match perfectly, since processor reporting periods don’t always align cleanly with a calendar year.
Review your chart of accounts for the year. Confirm nothing got miscategorized in a way that would distort your annual financial statements, and clean up any accounts that accumulated inconsistent naming over the months.
Confirm your inventory valuation method was applied consistently. Whether you’re using FIFO, LIFO, or weighted average cost, the method needs to have been applied the same way across the entire year, not adjusted informally partway through.
Prepare final financial statements. Your annual profit and loss statement and balance sheet should be finalized and reviewed before handing anything to a tax preparer, not generated for the first time the week taxes are due.
Shopify and Amazon Specific Considerations
Shopify sellers should pay particular attention to how payout batching bundles fees, refunds, and reserves into a single deposit figure, which is one of the more common sources of monthly reconciliation confusion.
Amazon sellers have an added layer, since settlement periods don’t align neatly with calendar months, and reserve holdbacks can make a given period’s payout look smaller than the actual sales activity would suggest.
Making the Checklist Actually Stick
A checklist only works if it’s attached to an actual calendar reminder, not a mental note. Most sellers who fall behind didn’t lack the checklist; they lacked a fixed date each month where reconciliation was non-negotiable, the way payroll or rent would be.
