Skip to main content
ProMall
Accounting

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

Online shop accounting illustrated as an open ledger with a fountain pen, a small calculator and a few coins

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.

NumberWhat it tells youHow often
Net salesWhat you actually sold after discounts and returnsDaily
Direct cost of goodsWhat sold items cost you to buy or makeDaily
Indirect costsPackaging, shipping, payment feesWeekly
Unmatched transfersMoney received but not yet tied to an orderWeekly
Real profitNet sales minus every cost aboveWeekly
Inventory valueHow much cash is sitting on your shelvesMonthly

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.

CategoryExampleNote
Cost of goodsWhat you paid to make or buy the productThe base of every profit calculation
PackagingBoxes, wrapping, shop stickersSmall per order, adds up at volume
ShippingCourier or postal costStill a cost even when free for the customer
Payment feesThe cut the payment gateway takesComes straight off profit
Idle inventoryStock that has not sold in a long timeCash 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.

  1. 1Pull net sales for the month, after discounts and returns.
  2. 2Add up every cost category: goods, packaging, shipping, fees, ads.
  3. 3Match any remaining unconfirmed transfers to their orders.
  4. 4Compare recorded inventory against what you can actually count.
  5. 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.

  1. 1Open one single place to record every order with its price, discount and payment method.
  2. 2Match this week's bank transfers to their orders, one by one.
  3. 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 demo