Business

Records a pharmacy owner should keep for the CA

Records a pharmacy owner should keep for the CA: purchase invoices, credit notes, daily sales, stock count, expiry write-offs and cash deposit slips.

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

A pharmacy owner should keep for the CA the purchase invoices and credit notes from every distributor, the daily sales summary, a year-end stock count, a record of expiry and damage write-offs, cash deposit slips and the complete bank statements. Because a pharmacy handles a lot of invoices, the folder gets large fast. Sort it monthly. Your CA decides the treatment of each item, and rules change.

Why do pharmacies generate so much paper?

Every purchase brings an invoice, every return a credit note, every day a sales report, and many small cash items fall between. GST is likely to be central to a business like yours, but how it applies to each line is for your CA to confirm, and the figures change. What you can control is the trail: complete, dated and in the right month.

What should be in the folder?

RecordWhat to noteCheck
Distributor purchase invoicesSupplier, date, invoice number, amountDoes the payment match the invoice?
Credit notes for returnsDate, items, amountHas every return been credited?
Daily sales summaryCash, UPI and card totalsDoes it match the bank credits?
Cash deposit slipsDate, amountIs the cash deposited the same as cash sales?
Expiry and damage listItem, batch, quantity, costIs each loss dated?
Delivery logDate, rider, fuel or feeDoes it match cash paid?
Licence and registration feesReceipt, periodIs the renewal date noted?

How should distributor accounts be tracked?

Most pharmacies buy on credit. Ask each distributor for a monthly statement and tick it against your own list of invoices. If a statement shows an invoice you do not have, find it. If you have an invoice the statement lacks, tell them. Do the same for payments and credit notes. This is the single most useful check you can make, because errors in either direction hide for months.

What should the stock count at year end look like?

A count sheet needs only four columns: item, batch or pack size, quantity and cost per unit. Count shelf by shelf, in the same order each year, with two people if you can. Set aside near-expiry and damaged items in a separate list with their cost. Keep the sheets signed and dated. The CA will use the total as closing stock, so a count done carefully in March spares you a long exchange of questions in the months that follow.

What is a good yearly rhythm?

  1. April: new folder, opening stock figure from last year's count.
  2. Monthly: distributor statements, sales summaries, bank statement, cash deposit slips.
  3. Quarterly: count the stock of fast movers and check for near-expiry items.
  4. Before the CA's deadline: ask them what they need and by when.
  5. March: a full stock count with quantities and cost.

Which mistakes show up often?

  • Discounts given at the counter that are not reflected in the sales figure.
  • Expired stock thrown away with no list.
  • Purchases paid in cash with no invoice.
  • Personal use of stock with no log.
  • Cash sales used to pay small expenses before being deposited, so deposits do not match sales.

A dated cover note is helpful, covering any change of distributor, new software or a month when the shop was closed. If your records are in SpendixAI, the Possible duplicate charges report can flag the same amount paid to the same merchant within two days, a good prompt to check for a double payment, and the Export centre can produce files in a few accounting formats. Whether your CA can use them is for them to say.

SPENDIXAI JOURNAL

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

Explore your reports