Why retailers need a bookkeeper who understands stock and COGS

a bookkeeper working at a desk
A competent generalist can keep a retail business perfectly compliant and completely blind at once. (Source: Unsplash)

Most bookkeepers can reconcile a bank account. Far fewer can tell you why your gross margin moved two points last quarter, which in retail is the only question that matters.

A competent generalist can keep a retail business perfectly compliant and completely blind at once. The BAS goes in on time. The bank reconciles. The P&L balances. And the number that decides whether the business works is quietly wrong.

Retail profit is decided above the gross margin line

In retail, profit is won or lost between revenue and cost of goods sold, and that line is assembled from a dozen moving parts: purchase price, freight, duty, foreign exchange, rebates, markdowns, damaged stock and shrinkage.

Australian retailers run gross margins between roughly 30 and 55 per cent depending on category. That is wide enough that a two-point error is easy to miss and expensive to carry. Shrinkage alone runs well over one per cent of sales, and because it lands inside COGS, it never appears as a line you can go looking for.

Where generalist bookkeeping goes wrong

The most common error is the simplest. Stock purchases get coded straight to COGS on the date the supplier is paid.

It reconciles. It is also nonsense. You have recorded the cost of goods you have not sold yet, in a month you did not sell them. Buy heavily in March for a June promotion and your March margin collapses while June looks heroic. Neither number is real. Stock belongs on the balance sheet until it sells.

The other recurring miss is landed cost. If freight, duty and FX are coded to expenses rather than loaded into the cost of the stock, every unit looks cheaper than it is. For importers, that is often the whole gap between the reported margin and the bank.

It is worth being fair about why

Most Australian bookkeepers cut their teeth on trades and professional services, where there is no inventory to speak of. You invoice time, you bank it, the cost side is wages. Nothing in a decade of that teaches you what to do with a container of stock sitting in a warehouse in Welshpool.

So this is not incompetence. I have met superb bookkeepers who never had reason to learn inventory, because no client of theirs had any. It is a specialism, invisible until the day it is expensive.

The system has to talk to the ledger

Retail is one of the few sectors where the accounting file is not the source of truth. The POS or inventory platform is. Whether that is Shopify, Vend, Cin7 or Unleashed, the question is whether it actually integrates with the ledger, or whether someone is keying summary journals once a month and hoping.

When it is wrong, your stock on hand has not been credible since anyone last counted, and your margin is technically an opinion.

What to ask before you hire

How do you treat stock purchases? If the answer does not distinguish the balance sheet from the P&L, stop there.

What goes into landed cost? Freight, duty and FX should be in the answer without prompting.

How do you handle a stocktake variance? You want write-offs, shrinkage and a journal, not a shrug.

Which inventory systems have you integrated with Xero? Specific product names, and what broke.

None of this is about compliance. The BAS will be fine either way. It is whether your bookkeeper can hand you a gross margin by category you would bet a buying decision on, and forecast cash in a business where your working capital is sitting on a shelf.

The encouraging part is that this is fixable, and faster than owners fear. Recoding stock and fixing the integration is weeks of work, not a rebuild. What retailers describe afterwards is not relief exactly. It is closer to being handed back numbers they trust.

Retail is a margin business run on borrowed time and borrowed cash. A bookkeeper who does not understand stock is not cheaper. They are just charging you somewhere else.

About the author: Andrew Erkins is founder and CEO of Digit, a registered BAS agent and Xero Platinum Partner providing outsourced bookkeeping, payroll and business advisory to Australian retailers.

Recommended By IR