Online Shop Accounting: The Complete Guide to Costs, Profit and Monthly Close
From revenue versus real profit to cost categories and reconciling bank transfers, everything your shop's bookkeeping actually takes.
Published: September 2, 20265 min read

Imagine closing out the month with no real idea how much you made. That is the gap online shop accounting is supposed to close: not just tracking sales, but knowing real profit. Instagram DMs and product pages show you revenue easily. They never show you, on their own, what that revenue cost you.
Why online shop accounting is different
A physical shop has one clean moment: the customer pays, done. An online shop spreads that moment across a messier trail: bank transfers with no formal receipt, returns that need to come back out of revenue, shipping costs you sometimes absorb, and discounts handed out in a DM chat that never got written down anywhere.
- Bank transfers arrive with no invoice, so you have to match them to an order yourself.
- A return that is not logged stays wrong in both inventory and revenue.
- Free shipping is not free, it is a cost you paid instead of the customer.
- A discount you gave in a chat is a real cost the moment you agreed to it.
None of this is a mistake, it is just what running an online shop looks like. These gaps are exactly why online shop management and accounting have to work together instead of living in separate places.
The six numbers to track
You do not need to be a bookkeeper to know where you stand. Six numbers, checked on the right schedule, cover almost everything you need to know about your shop's finances.
| Number | What it tells you | How often |
|---|---|---|
| Net sales | What you actually sold after discounts and returns | Daily |
| Direct cost of goods | What sold items cost you to buy or make | Daily |
| Indirect costs | Packaging, shipping, payment fees | Weekly |
| Unmatched transfers | Money received but not yet tied to an order | Weekly |
| Real profit | Net sales minus every cost above | Weekly |
| Inventory value | How much cash is sitting on your shelves | Monthly |
Track these over time with a proper online shop sales report instead of mixing trend data into daily bookkeeping.
Revenue is not profit
A busy month can still be a bad one. More orders often means more ad spend, more discounts and more returns, all of which quietly eat into what looks like a great sales number.
For the exact math behind this, see online shop profit, which walks through a full worked example.
Automatic recording versus spreadsheets
Spreadsheets work fine, with one condition: you have to remember to open them every single time. That is exactly where they fail, because you are usually mid conversation with three customers at once.
When an order is recorded where it actually happens, price, discount, shipping cost and payment method travel with it automatically into your books. Nothing gets entered twice, and nothing gets forgotten at midnight.
We cover the full path from a customer message to a tracking code in online shop order management, and automated bookkeeping starts at that exact same point.
If you are still on spreadsheets, start by reading how to choose an online shop management panel, since accounting is only one of the things worth checking.
Cost categories
Dumping every cost into one vague bucket means you never learn where the money actually goes. Split it out, even by hand at first.
| Category | Example | Note |
|---|---|---|
| Cost of goods | What you paid to make or buy the product | The base of every profit calculation |
| Packaging | Boxes, wrapping, shop stickers | Small per order, adds up at volume |
| Shipping | Courier or postal cost | Still a cost even when free for the customer |
| Payment fees | The cut the payment gateway takes | Comes straight off profit |
| Idle inventory | Stock that has not sold in a long time | Cash sitting on a shelf, not in your account |
That last row is easy to miss, so read online shop inventory to catch idle stock before it turns into a real loss.
Reconciling bank transfers
Direct bank transfers are convenient, but the bank statement never says which order a payment belongs to. With several transfers a day, matching them by hand gets slow and error prone fast.
Match each transfer to its order the moment it lands, not at the end of the week. Every day it stays unmatched is a day it could get forgotten entirely.
If bank transfers are still your only payment method, look at an instagram payment gateway, which reconciles automatically and is faster for the customer too.
The monthly close routine
Closing the month should not take a full day. If you keep the numbers current week by week, closing is really just adding them up.
- 1Pull net sales for the month, after discounts and returns.
- 2Add up every cost category: goods, packaging, shipping, fees, ads.
- 3Match any remaining unconfirmed transfers to their orders.
- 4Compare recorded inventory against what you can actually count.
- 5Calculate real profit and compare it against the previous month.
Common mistakes
- Never logging the cost of free shipping, as if free meant no cost at all.
- Keeping DM discounts in memory instead of in the system.
- Restocking a return without ever removing it from recorded revenue.
- Never recording the cost price of goods, so real profit stays a guess.
If you have not settled on a tool for any of this yet, our guide to picking an accounting app for your online shop walks through exactly what to look for.
Where to start tomorrow morning
You do not need to fix everything overnight. Tomorrow morning, three things are enough to get started.
- 1Open one single place to record every order with its price, discount and payment method.
- 2Match this week's bank transfers to their orders, one by one.
- 3List this month's fixed costs, packaging, shipping and ads, in one place.
ProMall automates two of these three: every order placed through a DM carries its price, discount and shipping cost straight into your reports, bank transfers stay matched to the order they belong to, and each product's profit is calculated from the cost price you already entered. Listing fixed costs like packaging and ads is still on you. This is not an accountant or a general ledger, it just makes sure the order and payment side never slips through the cracks.
Frequently asked questions
What makes online shop accounting different from regular bookkeeping?
A large share of the money arrives as bank transfers with no formal receipt, and returns and DM discounts have to be tracked separately. Your bookkeeping has to capture all of that, not just total sales minus total cost of goods.
What is the difference between revenue and real profit?
Revenue is the total money that came in from sales. Real profit is that number minus the cost of goods, packaging, shipping, payment fees, ads, discounts and returns.
Do I need software to keep my shop's books?
No, a spreadsheet can work at first. Once order volume grows, manual entry starts falling behind, and a system that links orders directly to your books removes most of that risk.
How do I reconcile bank transfers with orders?
Match every transfer to its order number as soon as it arrives, not at the end of the week. Doing this automatically means nothing stays unmatched and no customer is left waiting.
How long does the monthly close take?
If you keep the six core numbers updated weekly, closing the month is usually a couple of hours: adding up net sales, costs, remaining unmatched transfers and inventory value.
Hand your online shop to ProMall
See a free demo built on your own products. Setup takes under ten minutes.
Get a free demoRelated reading
Accounting
Online Shop Profit: A Full Worked Example for One Product and Month
One product, one month, one full worked example, from revenue to real profit, plus four hidden costs that quietly eat into it.
Accounting
Online Shop Accounting App: A Buying Guide and 10 Must-Have Features
Three kinds of accounting tools, ten features none of them should skip, and a 15-minute test to run before you hand over any money.
Reports
Online shop sales report: the seven numbers to read every week
A sales report you only glance at and archive is worthless. Here are the numbers that should actually change what you do.