Business

Records a supermarket owner should keep for the CA

A records checklist for a supermarket owner: distributor invoices, POS reports, stock counts, returns, bank statements and cash notes for your CA.

Editorial illustration for Records a supermarket owner should keep for the CA

A supermarket owner should keep every distributor invoice, the daily POS or sales summary, a year-end stock count, credit notes for returns and expiry, wage records, utility bills and all bank statements. Hand these to your CA in month order. Rules change, so the CA decides what is claimable, and your job is complete, dated records.

What makes supermarket records heavy?

Volume. A store may deal with dozens of distributors, hundreds of products and several payment modes each day. A missing invoice is not one missing page but a whole delivery. Good systems are therefore built around the supplier, not the item: one folder or ledger per supplier, with invoices, payments and credit notes in date order.

Which records are essential?

RecordWhat it showsHow to keep it
Purchase invoicesGoods receivedOne folder per supplier, by month
Supplier paymentsMoney paid and modeBank line matched to invoice
POS day-end reportSales and payment splitSave a file or print each day
Credit notesReturns and expiryAttach to the supplier's folder
Stock countClosing stockDated sheet, signed by you
Wage registerStaff payMonthly sheet with signatures

How do you reconcile supplier accounts?

Once a quarter, ask your major distributors for a statement of account and compare it with your own list: invoices received, payments sent, credit notes and balance. Differences are usually a missed invoice, a late payment or a return not yet credited. Sorting them out while records are fresh saves argument later and gives your CA a balance that both sides agree.

What about shrinkage, expiry and damage?

Stores lose goods to expiry, breakage, spoilage in a power cut and counter errors. Keep a written note when stock is written off or destroyed, with date, item, quantity, reason and who approved it. If a supplier takes the items back, keep the credit note. Your CA can then see why the stock fell without sales.

How should the stock count be done?

Count at the same date each year, preferably after closing, in teams of two so that one reads and one writes. Walk shelf by shelf, then the cold room and the back store. Record item, quantity and the cost price from your latest invoice. Photograph shelves as you go. Fast-moving lines should be counted in full and slow, low-value items can be estimated, and you should say which were estimated. Do not count goods that are sold but not yet delivered, or stock that belongs to a supplier on consignment.

How do you hand it over?

  1. Prepare a list of distributors with their total purchases and amounts paid.
  2. Provide POS reports or monthly sales summaries.
  3. Download full-year bank statements for every account.
  4. Add the stock count and write-off notes.
  5. Add the wage register, rent and utility bills.
  6. List new equipment: freezers, shelving, billing machines.

Keep returns from customers visible as well. A packet returned for a refund or exchange should show on the POS as a return and not vanish into a lower sales total. Your CA will see the pattern in your reports, and you will notice if one product keeps coming back.

What mistakes do supermarket owners make?

  • Paying distributors in cash with no receipt or entry in the supplier folder.
  • Not matching payment to the invoice it was meant for.
  • Forgetting to record cash drawn from the till for personal use.
  • Keeping POS reports only on the machine, which can fail.

SpendixAI can help on the expense side by taking bank statements and keeping receipts with transactions, and it can export a CSV or Tally, Zoho Books and QuickBooks templates. It is not a stock or billing system, so purchases and inventory stay in your POS.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports