Shopify Bookkeeping Checklist: Monthly and Year-End

A Shopify store can show orders, refunds, taxes, payment activity, and product movement, but those records do not automatically become a complete set of books. The bookkeeping job is to preserve what happened, connect the platform activity to money received or still in transit, and keep inventory and source documents traceable. This practical checklist gives Shopify sellers a repeatable monthly close and a year-end handoff routine.

This is general bookkeeping education, not individualized accounting, tax, legal, or sales-tax advice. Organizing records is different from preparing a tax return or deciding what rules apply to your business. Confirm accounting treatment, filing obligations, and tax questions with a qualified tax professional.

First, separate orders from cash deposits

Sales activity and bank activity answer different questions. Store order records describe customer transactions: items, discounts, shipping charged, taxes, cancellations, and returns. Payment processor activity describes how those transactions were settled. A payout is usually a net transfer after some combination of processing fees, refunds, disputes or chargebacks, adjustments, and timing differences. Funds can also be held in a processor balance or reserve and released later.

For example, a payout arriving today might combine eligible transactions from more than one day, subtract refunds or fees from earlier activity, and exclude a charge that has not settled yet. Another day's sales may still be waiting for payout. Therefore, one net bank deposit is not necessarily one day's revenue, and recording the deposit itself as revenue can hide both gross sales and expenses.

Instead, retain the sales and settlement detail, record the activity using a consistent method with your bookkeeper or accounting system, and use a separate clearing or funds-in-transit account for each payment processor when appropriate. The clearing account is the bridge: sales and adjustments enter it from the processor detail; the payout reduces it; the matching bank deposit confirms where the cash landed. Its remaining balance should be explainable by unsettled activity, reserves, timing, or a specific open exception.

Build a monthly Shopify close packet

At each month-end, save source exports or statements for the period from the store, Shopify Payments and any other processors, connected sales channels, bank accounts, and credit cards. Keep the original files read-only. Use clear filenames with the platform, period, and download date, and store them in a predictable folder structure. If you also sell through Amazon, Etsy, PayPal, Stripe, or another channel, keep its settlement and sales records distinct rather than blending unlike reports.

Collect order and transaction detail; refunds and cancellations; processor fees; payout or settlement records with their identifiers; dispute and chargeback notices; reserve or hold activity; tax-related reports; inventory purchase and receiving records; shipping and fulfillment charges; and the bank statement showing deposits. Save invoices, receipts, credit notes, supplier bills, and other source documents alongside the monthly exports. Add a brief note when a report changes format, a payout is split, or a balance carries forward.

Repeatable month-end close sequence

1. Set the period and capture the evidence. Confirm the month-end cutoff used in the books. Download the store activity, processor transactions and settlements, bank statements, inventory movement, and relevant bills. Record who downloaded each file and when if several people handle the close.
2. Review sales, discounts, and refunds. Compare order activity for the month with the sales totals recorded in the accounting system. Keep gross sales visible, and separately identify discounts, cancellations, returns, and refunds according to the bookkeeping method used for the business. Check that refunds are linked to the original order where the source data permits; a refund paid this month can relate to an earlier month's sale.
3. Separate tax and shipping components. Keep customer-collected sales tax distinguishable from sales revenue in the records. Identify shipping charged to customers separately from shipping or fulfillment costs paid by the business. Confirm that amounts in the store's tax-related exports are not silently folded into product revenue.
4. Reconcile every processor through a clearing account. For each processor, start with its opening balance and activity for the period. Bridge gross customer charges to refunds, fees, disputes, reserve movements, other adjustments, and the net payouts. Tie each payout by its processor reference or payout identifier to the bank deposit. Investigate split deposits, combined deposits, transfers still in transit, and unmatched amounts rather than forcing a plug.
5. Record fees and exceptions explicitly. Keep processing fees distinct from sales. Log chargebacks, dispute fees, reserve withholdings and releases, currency conversion, and corrections as their own identifiable items under your established bookkeeping categories. Track the case or transaction reference and status so an unresolved dispute does not disappear in a generic adjustment.
6. Update inventory and cost records. Match supplier invoices and receiving records to inventory purchases; collect freight, duties, packaging, and other product-cost information for review under the method used in your books. Compare the inventory subledger or stock records with the accounting balance, note damaged, missing, returned, or obsolete goods, and retain the count or system report used. Coordinate the period's cost-of-goods-sold entry with the method selected for your business rather than treating every cash purchase as the same kind of cost.
7. Review the bank and close the exceptions. Reconcile the operating bank and card statements, verify that processor clearing balances have support, and list unresolved differences with an owner and next step. Review the period's profit-and-loss and balance-sheet reports for unusual swings, duplicate entries, negative clearing balances, or inventory balances that lack support. Save the final reconciliation and a short close note.

Monthly checklist: a quick recurring pass

• ☐ Save store order, refund, discount, and tax-related exports for the month.
• ☐ Save each processor's transaction, fee, dispute, reserve, and payout detail.
• ☐ Match settlement activity to the processor clearing balance, then match each payout to the bank deposit.
• ☐ Explain timing differences and carry-forward balances; do not label a net deposit as a day's sales.
• ☐ Reconcile bank and credit-card statements and review open chargebacks or refunds.
• ☐ Collect supplier bills, receiving records, inventory adjustments, fulfillment charges, and other receipts.
• ☐ Review channel and destination records that help monitor sales-tax activity, marketplace collection, exemptions, and filing support.
• ☐ Review financial reports, document unusual changes, and assign any unresolved item a follow-up date.

Keep sales-tax records organized, not guessed

Preserve records that help you and a qualified tax professional review where sales occurred and how tax was handled: order destinations, dates, gross and returned sales, tax amounts shown, channel or marketplace, and any available indicator of tax collected or remitted by a marketplace. Keep exemption documentation when applicable, marketplace statements, notices, registration or filing records supplied to you, and a simple log of open questions and prior reviews.

These records can support monitoring and filing preparation, but they do not determine whether or where your business must register, collect, file, or remit. Requirements and the treatment of platform activity depend on the business and applicable jurisdictions. Ask a qualified tax professional to assess your obligations and how to treat a particular transaction.

Year-end checklist: make the handoff traceable

• ☐ Confirm that every month is closed and every bank, card, processor, and payout-clearing balance is reconciled or explained.
• ☐ Export and retain the full-year store, processor, marketplace, refund, fee, dispute, reserve, and tax-related records, plus year-end statements.
• ☐ Tie annual channel totals to the monthly books and document differences in timing, refunds, or settlement adjustments.
• ☐ Complete or retain the year-end inventory count or system valuation support, purchase invoices, receiving records, returns, write-offs, and the costing-method documentation used in the books.
• ☐ Gather supplier invoices, shipping and fulfillment bills, software and advertising invoices, bank and loan statements, and receipts for material business transactions.
• ☐ Collect sales-tax notices, marketplace collection information, exemption records, filing confirmations, and the current question list for your tax professional.
• ☐ Provide the final financial reports, reconciliations, source-document index, and open-items note to the person responsible for tax preparation. Keep record organization separate from return preparation and tax advice.

Records to keep easy to retrieve

A strong archive includes the unmodified exports behind reported totals, monthly reconciliations, payout identifiers, deposit evidence, invoices and receipts, inventory counts and adjustments, customer refund or dispute documentation, and notes explaining unusual entries. Use access controls, a consistent naming convention, and a retention approach reviewed with your professional advisers. Never rely on a screenshot alone when the platform can provide a downloadable statement or transaction file.

If your current process is mostly “the bank deposit looks close,” start with one processor and one month. Build the bridge from customer activity to settlement to bank, list what remains in transit, and repeat it next month. For a deeper walkthrough of the payout side, see how to reconcile Stripe, PayPal, and Shopify Payments payouts. For stock and cost methods, read inventory costing methods for e-commerce sellers; for tax-record organization across channels, see the e-commerce sales-tax recordkeeping guide. The broader bookkeeping guide for e-commerce sellers covers the full channel picture.