E-Commerce Bookkeeping: Do You Know What Your Products Actually Earn?
E-commerce gives business owners an impressive amount of sales data. You can see orders by product, channel, and date. You can watch revenue climb in a dashboard.
But sales are only one part of the picture. To know what an item earns, you need to understand what it costs to make or buy, sell, and deliver it. You also need bookkeeping records that connect the store’s activity to the money arriving in your accounts.
Without that connection, a product can look successful because it sells frequently while contributing much less profit than expected.
A real client example: sales across channels and currencies
In a recent client engagement, I reviewed the records of an online business selling through multiple channels. Payments passed through a processor and between U.S. and Canadian dollar accounts before some of the funds reached the Canadian bank account.
The immediate challenge was that a bank deposit showed only the end of that journey. To understand the business’s results, the sales activity, processor fees, transfers, and currency conversions needed to be traced and recorded consistently.
The owner also needed financial information to help assess labour costs. Before a profit and loss report could support that conversation, it was necessary to review how different payments had been classified.
This case study comes from real client work. I have removed identifying details, and the review described here should not be read as a claim that every issue had already been resolved.
The true cost of an order
Let’s say an item sells for $75. Its materials cost $20, packaging costs $4, a marketplace and payment processor take $9, and the business pays $12 toward shipping. That leaves $30 before considering the labour to make or fulfil it and other business expenses.
If the books capture only the $75 sale and the amount deposited after fees, the owner may not see that breakdown clearly. They may promote the item because it sells well without realizing how little it contributes after its direct costs.
Product profitability often requires information from more than the accounting system. Store reports can show what sold. Cost records can show materials, packaging, and shipping. Time or production records can help estimate labour per item. Bookkeeping ties those pieces to the overall financial results and helps check that the totals make sense.
What can your team produce profitably?
Employees and subcontractors are a significant cost for many online businesses. Recording their payments in the right categories is essential, but it is only the first step.
If you want to know whether production is profitable, you also need to understand output. How many items can someone make in an hour? How much time does fulfilment take during a busy period? Does a custom order require more labour than its price allows?
When labour records and production information are reviewed together, an owner can make better decisions about pricing, workload, staffing, and which products deserve more attention.
How poor records affect growth plans
Unclear books can make decisions feel like guesses. An owner may know that sales increased but not whether profit increased with them. They may want to hire but be unable to estimate the cost of producing more orders. They may need a line of credit but have trouble producing financial statements they can explain and support.
Lenders make their own decisions and may ask for information beyond the financial statements. Organized, reconciled books help an owner respond to those requests and understand the business’s position before applying.
The same principle applies to forecasting. A forecast is more useful when it starts with dependable figures for sales, fees, product costs, labour, and cash flow. If those figures are incomplete or misclassified, the forecast inherits the problem.
Give your reports a job they can do
An e-commerce bookkeeping setup should reflect how your business actually sells and receives money. It should allow you to reconcile each sales and payment channel, see costs clearly, and produce reports that agree with the underlying records.
From there, you can combine financial reports with product and production data to answer the questions that matter most: Which items earn enough? What does each channel cost? Can the business afford to expand?
If your store is growing and those answers are difficult to find, Willow & Ledger Bookkeeping can review your sales flow and bookkeeping setup. The first step is understanding where the numbers come from and whether they are telling the full story.
Comments