Business

A weekly supplier payment calendar for a small shop

A one-page weekday supplier payment calendar for a small shop, with supplier, amount due, mode and cash needed, so Monday shows the whole week's cash need.

Editorial illustration for A weekly supplier payment calendar for a small shop

A weekly supplier payment calendar is a one-page grid with one row per payment: the weekday, the supplier, the bill, the amount, the mode (cash, UPI, cheque) and the cash needed. Fill it every Monday morning and the week's cash need is visible before the first payment is due, instead of surfacing on Thursday when the drawer is short.

What goes on the page

Rule columns on a sheet of paper, or open a spreadsheet, and give each supplier a day. The columns that matter are few.

  • Day: the weekday you pay this supplier. Try to keep it the same every week.
  • Supplier and bill reference: so you can tie the payment back to the bill.
  • Amount due: from the supplier's bill or statement, not memory.
  • Mode: cash, UPI or NEFT, or cheque. This decides where the money must be.
  • Cash needed: the part that must come out of the counter drawer. Leave it blank for bank payments.
  • Paid? and date: filled in as you pay, so partly paid weeks are visible.

A made-up week

DaySupplierAmount dueModeCash needed
MonMilk dairy₹9,500UPI₹0
TueBiscuit distributor₹14,200Cash₹14,200
WedOil agency₹22,000NEFT₹0
ThuDal wholesaler₹18,600UPI₹0
FriCold-drinks agency₹7,800Cash₹7,800
SatStationery supplier₹3,400Cash₹3,400

Add the columns on Monday. Total due: 9,500 + 14,200 + 22,000 + 18,600 + 7,800 + 3,400 = ₹75,500. Cash needed: 14,200 + 7,800 + 3,400 = ₹25,400. Bank money needed: 9,500 + 22,000 + 18,600 = ₹50,100. And 25,400 + 50,100 = 75,500, so the page balances. In one glance you know to draw about ₹25,400 for the cash payments and keep at least ₹50,100 in the bank, spread across the week.

How do you decide which supplier gets which day?

  1. Ask each supplier when their salesman comes or when they prefer payment. Many are happy with a regular day.
  2. Spread the big bills across the week so no single day needs most of the cash.
  3. Put cash suppliers on days after your best sales days, such as the day after the weekend rush.
  4. Put suppliers who give a discount for timely payment on a day you can always keep.
  5. Leave one lighter day, usually Saturday or Sunday, so there is room for a surprise.

What should the Monday routine look like?

Spend ten minutes with the supplier statements and bills. Copy the amounts into the grid, add the columns, and compare the cash needed with what you expect in the drawer. If the cash column is larger than what you have, decide on Monday which payments to move or ask for a date, not on Thursday afternoon.

If you use a spreadsheet, a sum for the week's cash need can be =SUMIFS($E$2:$E$20,$D$2:$D$20,"Cash") where column D holds the mode and column E the amount. The same formula with "UPI" or "NEFT" in place of "Cash" gives the bank money needed for each mode.

What to do when the week does not fit

  • If cash needed is more than you can spare, look at moving a payment to a supplier who is flexible. Ask early, not at the last minute.
  • If two bank payments fall on the same day and the balance is short, move one by a day.
  • If a supplier changes the amount, write both the original and the new amount, with a note.
  • If a bill is disputed, mark it 'on hold' with the reason, and put a date to review it.

Monday checklist

  • All supplier bills for the week copied into the grid with day and amount?
  • Totals worked out: total due, cash needed, bank money needed?
  • Cash for the week drawn or planned from the drawer?
  • Bank balance checked against the bank-paid total?
  • One payment identified that can move if sales are slow?
SPENDIXAI JOURNAL

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

Explore your reports