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.
| Vendor | Amount | Due date | Mode | Status |
|---|---|---|---|---|
| Steel Traders | ₹14,500 | 05 Nov | NEFT | Paid |
| Welding Supplies | ₹6,200 | 07 Nov | UPI | Paid |
| Paint House | ₹3,800 | 10 Nov | UPI | Due |
| Bearings Co | ₹9,750 | 12 Nov | NEFT | Due |
| Electricals | ₹2,400 | 14 Nov | UPI | Paid |
| Packaging | ₹5,600 | 15 Nov | NEFT | Disputed |
| Fasteners | ₹1,850 | 18 Nov | UPI | Due |
| Tool Hire | ₹4,000 | 20 Nov | Cash | Due |
| Transport | ₹7,300 | 22 Nov | UPI | Due |
| Lubricants | ₹2,950 | 25 Nov | UPI | Due |
| Cutting Discs | ₹3,150 | 28 Nov | NEFT | Due |
| Scrap Handling | ₹1,500 | 30 Nov | Cash | Due |
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?
- Sort the sheet by due date, earliest first.
- Read the totals for overdue and the next seven days.
- Check that the bank balance can cover them, and plan the transfers.
- Make the payments and change each status to Paid.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


