Article
Bookkeeping Basics for Online Sellers: Tracking Your Real Profit
Many online sellers know their sales figure but not their profit. Revenue looks great on the seller dashboard, yet the bank account tells a different story. The gap is usually fees, shipping, ad spend, refunds and stock costs that were never tracked properly.
You do not need to be an accountant to keep good records. A few consistent habits will show you where your money goes, help you make better decisions and make tax season far less stressful. This is general guidance, so for specific tax or legal questions, speak to a qualified accountant.
Separate business and personal money
The single most helpful step is opening a separate bank account for your business. When personal spending and business payouts mix in one account, it becomes very hard to know what the business actually earns.
- Have marketplace and payment gateway payouts land in the business account
- Pay suppliers, couriers, ads and tools from the business account
- Pay yourself a set amount by transferring it to your personal account
Even if you are a sole proprietor, this separation makes everything clearer.
Record every sale and every fee
For each sales channel, you need to know the gross sales, the fees deducted and the amount actually paid out. Marketplaces and gateways provide reports or statements you can download. Make a habit of exporting them every month.
Common deductions to track include commissions, transaction fees, programme fees, shipping fees, vouchers you funded and refunds. When you look at these together, you may discover that one channel is far less profitable than you thought.
Tip: set a monthly "money day" in your calendar. Download all your statements, update your records and review your profit. An hour a month saves days of panic later.
Track your stock costs
Profit depends on what you paid for the products you sold. Keep a record of each stock purchase: supplier, date, quantity, unit cost and any extra charges like import fees or delivery. When you know your cost per unit, you can calculate the cost of goods sold each month.
A simple spreadsheet works for small ranges. As you grow, inventory software or your ecommerce platform's stock features can track this automatically. Our guide to preventing oversell also helps keep stock numbers honest.
Keep receipts and invoices organised
Save digital copies of every business expense: packaging, ads, software subscriptions, equipment, courier bills and so on. Create folders by month, or use an accounting app that lets you snap photos of receipts. Missing receipts make it harder to prove business expenses later.
Malaysia has been rolling out e-invoicing in phases for businesses, and requirements depend on your business size and situation. Check the latest guidance from LHDN or ask your accountant how it applies to you.
Calculate your monthly profit
Once your records are in place, a basic monthly profit calculation looks like this:
- Start with total sales across all channels
- Subtract refunds and returns
- Subtract platform and payment fees
- Subtract cost of goods sold
- Subtract shipping and packaging costs you paid
- Subtract marketing and ad spend
- Subtract other operating costs like software, rent and utilities
What remains is your operating profit before tax. Compare it month to month, and by channel if you can.
Use the numbers to make decisions
Good bookkeeping is not just for compliance. It tells you what to do next:
- Which products make the most profit, not just the most sales
- Which channels are worth more time and which are not
- Whether your ads pay for themselves
- When you can afford to hire help or buy more stock
If one product sells a lot but barely makes money, consider raising its price, bundling it or dropping it.
Choose simple tools
You can start with a spreadsheet and grow into accounting software when transactions become too many to manage by hand. Many accounting apps connect to bank accounts and ecommerce platforms, saving data entry. Pick something you will actually use consistently.
Do not forget hidden costs
Some costs never appear on a marketplace statement but still eat profit. Your phone bill, internet, petrol for drop-offs, printer ink, the occasional replacement order and the cost of free samples all add up. So does your own time. Add a simple "other costs" section to your monthly records and fill it honestly. It will make your profit figure smaller, but it will also make it true, and true numbers lead to better decisions.
FAQ
Do I need an accountant for a small online shop?
Not necessarily at the start, but an accountant can help you set things up correctly and handle tax matters as you grow. Many small sellers use one at least once a year.
How long should I keep records?
Keep records for as long as the law requires for your business type. Ask an accountant or check official guidance, and store copies safely.
What is the most common bookkeeping mistake?
Mixing personal and business money, and only looking at sales instead of profit. Fix those two and your numbers become much clearer.
Clear records turn your online shop from a guessing game into a business you understand. Separate your money, record sales and fees, track stock costs and review your profit every month.