Health and family

Chemist credit account: tracking a monthly bill you settle later

Keep a running ledger for a chemist who lets the family run a tab: items, dates, payments and the balance carried forward, so settling up is never a surprise.

Editorial illustration for Chemist credit account: tracking a monthly bill you settle later

To track a chemist credit account, keep a ledger with the date, what was taken, who it was for, the bill amount, any payment and the balance after each line. Check it against the chemist's own book at every settlement, and decide in advance whether you count the medicine in the month you take it or the month you pay.

Why a tab needs its own record

A running account at a local chemist is convenient and usually built on trust. But money you owe is invisible in your bank statement until it is paid. If you rely on the statement alone, you will see one large payment at the end of the month and have no idea what it covered, or whether the shop's total was right.

The ledger columns

  • Date
  • Particulars: what was taken, in a few words or the bill number
  • For whom: family member
  • Bill amount
  • Payment made
  • Balance, carried forward after each line

Ask for a slip or bill with each purchase, or photograph the chemist's book entry. At the end of the month, ask for the total and compare.

A worked example

Say the previous month closed with ₹1,200 still owed. These are made-up numbers.

DateParticularsBill (Rs)Paid (Rs)Balance (Rs)
1 OctBalance brought forward001,200
5 OctElder A monthly tablets64001,840
12 OctCough syrup for child31002,150
19 OctElder B tablets and dressings1,15003,300
30 OctPart payment by UPI03,000300

The balance is the previous balance plus the bill minus the payment. 1,200 plus 640 is 1,840, plus 310 is 2,150, plus 1,150 is 3,300, minus 3,000 leaves ₹300 to carry into November. The month's new bills were 640 + 310 + 1,150 = ₹2,100, even though the payment was ₹3,000.

How is the balance calculated in a sheet?

With Bill in column C, Paid in column D and Balance in column E, and the opening balance typed in E2, put this in E3 and copy it down. Cells in C and D that are empty are treated as zero.

  • Running balance: =E2+C3-D3
  • Total billed this month: =SUM($C$3:$C$200)
  • Total paid this month: =SUM($D$3:$D$200)

Because the first row holds an opening balance rather than a bill, start the formula one row lower, as above. Dates may be formatted as day and month.

Do I count the bill or the payment as my expense?

Decide once, and say which in your notes. If you want a monthly picture of what you used, count the bills in the month they were taken, which here is ₹2,100 for October. If you want to follow your bank account, count payments, which is ₹3,000. Do not count both, or you will double the spend. If you count bills as the expense, treat the UPI payment as settling a debt, not as a new health cost.

How does an app fit in?

SpendixAI shows the settlement payment from your statement once it is imported, and lets you add manual expenses and attach receipts. The ledger itself, with its running balance, is easier to keep in a sheet. A useful habit is to compare the sheet's month-end payments with the matching statement entries, and to add a note on the transaction such as "settles Oct tab".

Housekeeping

  1. Keep the slips together, one envelope or folder per month.
  2. Pay on a regular date so the balance does not drift.
  3. Write the balance at the foot of each month so you can start fresh.
  4. If several family members buy on the account, add their initials to each line.

If the balance keeps growing month on month, treat it as a signal and look at the pattern.

SPENDIXAI JOURNAL

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

Explore your reports