A medical store owner needs four things in order for the CA: every distributor purchase bill with its credit notes, the day-wise sales summary from the billing software, the bank and cash records, and a dated list of licences, rent and staff papers. Collect them monthly in one folder and the year-end becomes a handover, not a hunt.
What should go into the folder every month?
Think of the folder as having five shelves. Anything that touches money in or out of the shop lands on one of them.
- Purchase bills from each distributor and wholesaler, filed in bill-date order, with the payment against each one noted
- Credit notes and return slips for expired, near-expiry and damaged strips sent back
- The billing software's monthly sales report, plus a printout or PDF of the cash-book for the same month
- Bank statements for the shop account, any second account used for card swipes and UPI, and the loan account if there is one
- Rent, electricity, refrigerator or AC servicing, staff salary and delivery boy expenses, each with a bill or a handwritten voucher
How do I keep distributor bills and returns straight?
A pharmacy's biggest cost is stock, so the biggest source of confusion is stock paperwork. Write the bill number and the date you paid on the invoice itself, or on a sticker on the first page. When an expired batch goes back to the distributor, the credit note should be attached to the original invoice, not floating in a different drawer.
Say a distributor invoice is ₹46,500 and a credit note for returned strips is ₹3,200. The amount really owed on that bill is ₹43,300. If you pay ₹46,500 and never record the credit note, your books show an overpayment that nobody can explain a year later. Ask the distributor for a monthly statement of account and tick your bills against it.
Which items are personal and not the store's?
This is where a family-run medical shop slips most often. Tablets taken home, a relative's order, a family phone recharge paid from the shop's UPI, or school fees drawn from the till are personal withdrawals. They are not a shop expense and not a stock loss.
- Keep a withdrawals page: date, amount, reason. One line is enough.
- If stock is taken for home use, bill it to yourself at the same price rules the CA tells you to follow, rather than letting it disappear.
- Pay household bills from a personal account whenever you can, so the statements stay clean.
What does each record tell the CA?
| Record | Where it comes from | What the CA uses it for |
|---|---|---|
| Distributor invoices | Paper or emailed bills | Purchases and the amount owed to each supplier |
| Credit notes | Return slips from distributors | Reducing purchases and settling dues correctly |
| Day-end sales report | Billing software | Matching sales to deposits in the bank |
| Bank statements | Net banking or branch | Proving what was received and paid |
| Cash vouchers | Your own handwritten slips | Small expenses with no formal bill |
| Licence and rent papers | Renewal receipts, agreement | Fixed yearly costs and dates to track |
How do I hand the records over without a last-minute rush?
- On the first week of each month, scan or photograph the previous month's bills and name the folder with the month.
- Export the month's sales report and save it beside the bank statement for the same month.
- Write one page listing anything odd: a cheque that bounced, a distributor dispute, an advance given to a staff member.
- Send the folder to the CA on a fixed day and ask which format they prefer for the bank data.
- Keep the originals in a labelled file for the financial year, April to March.
What mistakes are specific to a pharmacy?
Four come up again and again. Sales are credited into a personal account and never reach the shop's statement. Distributor payments are made in cash without noting which invoice they settle. Expired stock is thrown away with no record of its value or the batch. And scheme discounts or free-strip offers are kept off the books because there is no cash involved. None of these is hard to fix, but each is hard to reconstruct after twelve months.
If you want the bank side done faster, SpendixAI lets you pick the account, upload the statement as PDF, CSV or Excel, review the rows before saving, and download a CSV or an accounting-format file for the CA. Ask your CA which format they want before you send anything.
A closing checklist
- Every distributor bill has a payment note and its credit notes attached
- Cash withdrawals for home use are listed separately
- Bank statements for every account are saved for each month
- Licence renewals and rent papers are in one dated file
- The CA has told you in writing which format they want
Useful ideas start with a clearer picture of your own spending.
Explore your reports

