Tax and GST

A vendor payment tracker with due dates and status

A vendor payment tracker template sorted by due date, with status (due, paid, disputed), payment mode and a Monday review. Twelve sample rows.

Editorial illustration for A vendor payment tracker with due dates and status

A vendor payment tracker is a sheet of bills to pay, sorted by due date, with a status for each: Due, Paid or Disputed. Six columns are enough: vendor, bill number, amount, due date, payment mode and status. Review it every Monday and pay what falls in the week ahead, and nothing slips past its date by accident.

What columns does the sheet need?

  • A Vendor: name as on the bill.
  • B Bill no.: as printed.
  • C Amount: the payable amount in rupees.
  • D Due date: the date the vendor expects payment.
  • E Mode: NEFT, UPI, cheque or cash.
  • F Status: Due, Paid or Disputed.

If you have the credit terms with the vendor, such as payment in thirty days, add the bill date and let a formula work out the due date: =B2+30 where B2 holds the bill date. Change the 30 to your own agreed terms.

What does a sample workshop sheet look like?

A small workshop has twelve open or recent bills in November. The names and amounts are invented.

VendorAmountDue dateModeStatus
Steel Traders₹14,50005 NovNEFTPaid
Welding Supplies₹6,20007 NovUPIPaid
Paint House₹3,80010 NovUPIDue
Bearings Co₹9,75012 NovNEFTDue
Electricals₹2,40014 NovUPIPaid
Packaging₹5,60015 NovNEFTDisputed
Fasteners₹1,85018 NovUPIDue
Tool Hire₹4,00020 NovCashDue
Transport₹7,30022 NovUPIDue
Lubricants₹2,95025 NovUPIDue
Cutting Discs₹3,15028 NovNEFTDue
Scrap Handling₹1,50030 NovCashDue

Add it up: paid is 14,500 plus 6,200 plus 2,400, which is ₹23,100. Disputed is ₹5,600. Due is 3,800 plus 9,750 plus 1,850 plus 4,000 plus 7,300 plus 2,950 plus 3,150 plus 1,500, which is ₹34,300. All three together make ₹63,000, matching the sum of the twelve amounts.

Which formulas give the totals?

Assume Amount in column C, Due date in column D and Status in column F, rows 2 to 200. These work in Excel and Google Sheets.

  • Total still due: =SUMIFS($C$2:$C$200, $F$2:$F$200, "Due")
  • Total disputed: =SUMIFS($C$2:$C$200, $F$2:$F$200, "Disputed")
  • Due and already past the date: =SUMIFS($C$2:$C$200, $F$2:$F$200, "Due", $D$2:$D$200, "<"&TODAY())
  • Due in the next seven days: =SUMIFS($C$2:$C$200, $F$2:$F$200, "Due", $D$2:$D$200, ">="&TODAY(), $D$2:$D$200, "<="&TODAY()+7)

The due date column must hold real dates, not text. If a formula returns zero when you expect a number, check that first.

What is the Monday review?

  1. Sort the sheet by due date, earliest first.
  2. Read the totals for overdue and the next seven days.
  3. Check that the bank balance can cover them, and plan the transfers.
  4. Make the payments and change each status to Paid.
  5. Chase or resolve Disputed items, with a note of what is wrong.

What do you do with disputed bills?

Keep them on the sheet with the status Disputed and a note, rather than ignoring them. Pay the undisputed part if you and the vendor agree on it, and record that as a separate line. Dates of calls and messages go next to the row.

How does a tracker fit with the sheet?

The sheet says what you plan to pay. SpendixAI shows what you actually paid: import the statement, review the rows and see each vendor's payments by merchant name. Pro also has budgets, bills and savings goals. Use the statement to flip a row to Paid with confidence.

A weekly closing check

  • No Due rows older than today.
  • Every Paid row has a payment reference.
  • Disputed rows have a note and a date.
  • Next Monday's list printed or open.
SPENDIXAI JOURNAL

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

Explore your reports