Ecommerce Bookkeeping: What to Track Each Month

When you sell online, the number that lands in your bank account is only one part of the story. Orders can move through Shopify, eBay, payment processors, discounts, refunds, shipping charges, platform fees, and inventory purchases before the month is over. Without a consistent way to sort those moving parts, it is easy to feel busy, sell well, and still be unsure what the business actually earned.

Ecommerce bookkeeping is the monthly practice of turning that activity into a dependable financial picture. It is not about making your records look tidy for their own sake. It is about being able to answer useful questions: Did this month produce a profit? Which sales channel is carrying its weight? How much cash is available after the next inventory order? What needs attention before tax time?

Use this guide as a practical monthly system. It is general educational information, not tax advice for your specific situation. Your tax professional can help you apply it to the rules that affect your business.

Start with a chart of accounts that reflects how you sell

Your chart of accounts is simply the set of buckets your bookkeeping uses. For an online store, generic buckets are rarely enough. If all income is dropped into one sales account and every platform deduction is buried in a broad expense category, the reports cannot show you where margin is improving or slipping.

Set up categories that match the decisions you make. That often means separating sales by meaningful channel, keeping merchant and marketplace fees visible, and distinguishing shipping income from shipping expense. Inventory-based businesses also need a clear place for inventory on hand and cost of goods sold. The point is not to create dozens of tiny categories. The point is to make recurring activity easy to recognize month after month.

For Shopify sellers, the platform’s finance reports separate sales, payments, taxes, fees, and payout activity. That is a useful reminder that one dashboard total does not replace a well-organized set of books. The same principle applies to eBay and every additional payment or marketplace channel.

Record sales separately from payouts

This is one of the most important ecommerce bookkeeping habits. A payout is not the same thing as revenue. It is the net amount sent to your bank after the platform has handled fees, refunds, reserve changes, shipping adjustments, and sometimes taxes. Recording only the payout makes the bank reconciliation feel easy, but it hides the details that explain profit.

Instead, use the platform’s activity to capture the full picture for the period: gross sales, discounts, refunds and returns, shipping collected, sales tax collected, marketplace or card fees, and the amount still owed or paid out. Then match the payout to the bank deposit. When each piece has a home, the bank balance and the sales activity agree without pretending they are the same number.

This approach also makes exceptions easier to spot. A payout that is smaller than expected may be completely valid, but it should have an explanation. Once the explanation is visible, you can decide whether the issue is a timing difference, a refund pattern, a fee increase, or a simple reporting error.

Keep inventory and cost of goods sold in the conversation

Cash spent on products does not automatically tell you what the month’s sales cost. Inventory is often purchased before it is sold, sometimes in large batches. If every supplier payment is treated as an immediate expense, a busy restock month can make a healthy selling month look worse than it was. If product cost is ignored until year-end, the opposite can happen and profit can look better than reality.

Keep an organized inventory record and use a method that fits your business and your tax guidance. The IRS small-business tax guide addresses inventory and accounting methods, but the right treatment can depend on your facts. Your job as an owner is to keep the purchase, quantity, product, and supporting documents easy to find. Your bookkeeper and tax professional can then help make sure the financial treatment is consistent.

At minimum, review whether your cost data is current enough to make gross profit meaningful. Shopify’s own reporting notes that only sales with recorded costs flow into its cost of goods sold and gross profit reporting. A margin report is only as useful as the product cost information behind it.

Reconcile every account that touches the business

Reconciliation is the monthly check that your books agree with the underlying records. For an ecommerce business, that list usually includes the business bank account, business credit card, payment processor balances, marketplace accounts, and any clearing accounts used to organize payouts. It may also include a loan, line of credit, payroll account, or sales-tax account.

Do not skip accounts because the balance is small. Small, unreconciled balances have a habit of becoming large questions later. Reconciliation also protects the quality of your reports. It catches duplicated transactions, missed expenses, stale transfers, and deposits that were recorded as revenue twice.

Keep the supporting documents with the month’s work. The IRS explains that records should clearly show business income and expenses, and that purchases, sales, payroll, and other transactions generate the supporting documents behind the books. Its recordkeeping guidance is a useful baseline when building your storage routine.

Review sales tax activity without treating it as revenue

Sales tax collected from customers is generally not income that belongs to the business. It is an amount held for a taxing authority, which is why it needs its own tracking rather than a spot in the sales total. Selling through a marketplace can add another wrinkle: some channels collect or file on your behalf in certain places, while direct-store sales can create different responsibilities.

Each month, review sales-tax activity by channel and state, then retain the reports that explain what was collected, refunded, or remitted. Shopify’s reports, for example, distinguish order-level tax activity and identify whether a channel filed on a seller’s behalf. That information is useful for keeping records organized, but it is not a substitute for personalized tax advice. If you are unsure about registration, filing, nexus, or a marketplace arrangement, bring the reports to a qualified tax professional.

Close the month with a short, repeatable checklist

A monthly close does not have to become a marathon. The best rhythm is one your team can repeat. Pick a deadline after the end of each month, collect the same source documents, and work through the same sequence. Over time, the work becomes less reactive because missing information shows itself quickly.

1. Gather bank, card, marketplace, processor, and inventory records for the month.
2. Record sales, refunds, discounts, fees, shipping, and taxes from each selling channel.
3. Match platform payouts and other deposits to the bank activity.
4. Reconcile bank accounts, cards, and clearing balances.
5. Review inventory and cost information, then flag anything incomplete.
6. Review the profit and loss statement, balance sheet, and cash position for questions or unexpected changes.
7. File the month’s source reports and notes where they can be found again.

As you review the reports, look for movement rather than perfection. A higher fee percentage, lower gross margin, unusual refunds, a growing payable balance, or a cash shortfall before a restock is a prompt to investigate. Monthly books give you time to respond while the details are still fresh.

Build a system that is easy to repeat

The best bookkeeping routine is rarely the fanciest one. It is the one that makes it obvious what belongs in the books, where the source documents live, and when someone will review the result. Use one dedicated business bank account and card whenever possible. Give receipts, vendor invoices, and platform exports a consistent home. Name files in a way that will still make sense six months from now.

It also helps to separate the act of collecting information from the act of judging it. First, get the month complete and reconciled. Then read the reports. That order keeps a surprising bank balance from turning into a rushed guess. If a number looks unusual, add a note and follow the trail back to the source report rather than changing entries until the report feels better.

For a founder, that discipline creates confidence. You do not need to memorize every transaction. You need a process that can show where a number came from when it matters.

Use your reports to make the next decision

Bookkeeping earns its place when it makes decisions easier. A current profit and loss statement can help you compare selling channels and operating costs. A balance sheet helps you see what the business owns and owes. Cash information helps you plan for inventory, taxes, and upcoming commitments without relying on a hopeful bank-balance guess.

Start with a few questions you will actually use: Is the store producing enough gross profit to support its operating costs? Is one channel more expensive to serve than expected? Is cash being tied up in inventory too long? Are returns or fees moving in the wrong direction? The answers are rarely contained in one number, but clean books make the conversation possible.

When it makes sense to bring in support

Many owners can manage early bookkeeping themselves, especially with a simple sales channel and a disciplined routine. Support becomes especially helpful when you add channels, carry inventory, use multiple payment methods, sell across states, or find that the books are consistently behind. The goal is not to hand off understanding. It is to have a dependable system and someone who can explain what the numbers are saying.

NFILY LLC helps Shopify and eBay sellers organize payouts, inventory, cost of goods sold, and monthly reporting through its e-commerce bookkeeping services. If your store needs a cleaner starting point, the QuickBooks Online setup service can build the foundation around how you actually sell. When the work is current, you have more room to run the store and less reason to dread the next financial question.