Bookkeeping for Retail Businesses: A Practical Guide for Australian Shop Owners

Why Retail Bookkeeping Is Uniquely Challenging

Running a retail business in Australia means managing more financial moving parts than most other small business types. You have inventory coming in from suppliers, daily sales going out across multiple payment methods, staff wages to process, and GST to track on both sides of the ledger.

When bookkeeping is done well, you can see your gross margin by product category, spot slow-moving stock before it becomes a write-off, and lodge your BAS without stress. When it is done poorly, you end up with mystery losses, cash flow surprises, and an accountant asking uncomfortable questions at tax time.

This guide covers the bookkeeping fundamentals every Australian retail business owner needs to understand.

Setting Up Your Chart of Accounts for Retail

Your chart of accounts is the backbone of your bookkeeping system. For a retail business, you need accounts that reflect the nature of your operations.

Key accounts to set up:

• Sales Revenue (one account per major product category if useful)
• Cost of Goods Sold (COGS) (the direct cost of the products you sell)
• Inventory Asset (the value of stock you hold)
• Shrinkage and Write-offs (for theft, damage, and expired stock)
• Freight and Delivery (inbound shipping costs)
• Staff Wages and Superannuation
• Rent and Outgoings
• Merchant Fees (EFTPOS, Afterpay, PayPal fees)
• Marketing and Advertising

In Xero, you can customise your chart of accounts under Accounting then Chart of Accounts. Take the time to set this up properly before you start transacting. Changing account codes later creates historical inconsistencies that are painful to clean up.

Tracking Inventory Correctly

Inventory is the biggest bookkeeping challenge for most retail businesses. You need to know what you paid for stock, what it is worth now, and how much you have sold.

The Two Common Approaches

Periodic inventory means you do a physical stocktake at set intervals (monthly, quarterly, or annually) and adjust your records to match. It is simpler to manage but gives you less real-time visibility.

Perpetual inventory means your system updates automatically with every sale and purchase. This is more accurate but requires a point-of-sale (POS) system that integrates with your accounting software.

For most retail businesses with Xero, perpetual inventory via a connected POS is the better choice. Xero integrates natively with Shopify, Square, Lightspeed, and others. When a sale is made, the POS sends the transaction to Xero, updates your inventory count, and records the revenue automatically.

Landed Cost

Many retail business owners make the mistake of recording only the invoice price of stock and ignoring freight, customs duty, and insurance. The true cost of inventory includes all costs to bring it to your premises. This is called landed cost.

If you import goods, work with your bookkeeper to include freight and duty in your COGS calculation. Under-costing inventory inflates your gross margin and makes your business look more profitable than it is.

Stocktake and Write-offs

Even with a perpetual inventory system, you need to do periodic stocktakes. Discrepancies between your system count and the physical count tell you something important: theft, breakage, or data entry errors.

Write off any damaged, obsolete, or missing stock against your Shrinkage account. Do not leave phantom inventory on your balance sheet. It overstates your assets and distorts your profit calculations.

Daily Takings Reconciliation

One of the most important daily habits for a retail business is reconciling your takings. At the end of each trading day, the total sales recorded in your POS should match the total deposits in your bank account (allowing for settlement timing on card payments).

A typical daily reconciliation process looks like this:

1. Print or export your end-of-day sales report from your POS
2. Note the total by payment type (cash, EFTPOS, Afterpay, etc.)
3. Count and bank your cash float
4. Check that your bank feed in Xero shows the expected settlement amount
5. Investigate any discrepancies before they compound

In Xero, you can use the bank reconciliation screen to match daily settlement batches to your sales transactions. Setting up a bank rule for your POS settlement makes this faster. Instead of coding each settlement manually, the rule applies the correct account automatically.

GST for Retail Businesses

If your retail business has a GST turnover of $75,000 or more, you must be registered for GST and collect it on taxable sales. Most retail products attract GST at 10%, but there are exceptions.

GST-free items include:

• Fresh food (unprocessed or minimally processed)
• Certain health goods and medicines
• Some educational materials

If you sell a mix of taxable and GST-free items, your POS must be set up to track this correctly. Applying 10% GST to items that are GST-free, or missing GST on taxable items, creates problems when you lodge your BAS.

In Xero, make sure each inventory item has the correct default tax rate assigned. When a sale is processed, Xero will apply the right rate automatically.

Claiming GST on Purchases

You can also claim GST credits (called input tax credits) on your business purchases. For a retail business, this includes stock from GST-registered suppliers, shop fit-outs, signage, marketing, and equipment.

Keep valid tax invoices for all purchases over $82.50 (including GST). Your bookkeeper needs these to substantiate your GST credits.

Managing Supplier Payments

Retail businesses often work with multiple suppliers on varying payment terms. Staying on top of accounts payable is critical for cash flow and supplier relationships.

In Xero, set up each supplier as a contact and enter their invoices in the Purchases section. This creates a clear record of what you owe and when payment is due. Set up alerts for invoices approaching their due date.

If you negotiate early payment discounts with suppliers (common in retail), make sure these are recorded correctly. A 2% early payment discount should reduce the recorded cost of goods, not just appear as miscellaneous income.

Payroll for Retail Staff

Most retail businesses employ casual or part-time staff on the relevant Modern Award. In retail, this is typically the General Retail Industry Award 2020. Key compliance obligations include:

• Paying at or above award rates including penalty rates on evenings and weekends
• Processing superannuation contributions correctly (currently 11.5% of ordinary time earnings)
• Lodging Single Touch Payroll (STP) data to the ATO every pay run via Xero Payroll or a connected payroll app

Xero Payroll handles STP automatically if set up correctly. Make sure each employee's award classification and pay rate is entered accurately. Errors here can lead to underpayment claims, which carry significant legal and reputational risk.

Key Metrics to Track in Retail

Once your bookkeeping is clean, you can start using your numbers to make better decisions. The metrics that matter most for a retail business are:

Gross Profit Margin: Revenue minus COGS, expressed as a percentage. Most retail businesses aim for 40 to 60%, depending on the category.

Inventory Turnover: How many times you sell through your entire inventory in a year. Higher is generally better, but too high means you risk stockouts.

Average Transaction Value: Total revenue divided by number of transactions. If this is falling, you may need to focus on upselling or product mix.

Shrinkage Rate: The value of stock lost to theft or damage as a percentage of sales. Industry benchmarks vary, but anything above 2% warrants attention.

Sell-through Rate: The percentage of inventory you sell within a given period. Useful for assessing which product lines are working.

Using SortBooks to Automate Retail Bookkeeping

Retail businesses generate a high volume of transactions. Even a modest shop processing 50 to 100 sales per day will have thousands of transactions to categorise every month.

SortBooks connects to your Xero account and uses AI to automatically categorise bank feed transactions, match supplier invoices, and flag anything that looks unusual. For routine retail transactions like supplier payments, merchant fee charges, and utility bills, the categorisation happens without you needing to touch it.

This frees up the time your bookkeeper (or you) would otherwise spend on data entry, allowing focus on the analysis and compliance tasks that actually require human judgement.

Clean books, reviewed regularly, are the difference between a retail business that grows confidently and one that is always reacting to surprises. Get the foundations right and the numbers will tell you exactly what your business needs.