Back

Free Excel template

MSME supplier payment tracker

List your purchases from micro and small suppliers. The tracker works out each due date (15 days, or the agreed date up to 45), flags anything overdue, and estimates the interest and the tax effect.

Download the Excel file

.xlsx · 79 KB · Works in Excel, LibreOffice and Google Sheets · No sign-up

What is in it

  • Due date from the acceptance date and the agreed credit days, capped at 45
  • Status for each invoice: not yet due, paid on time, paid late or overdue
  • Whether the supplier is covered: micro or small on Udyam, and not a trader
  • An interest estimate at three times the RBI bank rate, and the tax year in which a late payment is allowed
  • Room for 500 invoices, with totals

How to use it

  1. Enter each supplier’s Udyam category and activity once you have it in writing.
  2. Enter the date goods or services were accepted and the agreed credit days (leave blank if there is no written agreement).
  3. Sort by the "Due date" column every week and pay what falls due first.
  4. Before 31 March, check every "OVERDUE" line: paying it before the year ends keeps the expense in this year.

Blue cells are for your figures; everything else is a formula. The first rows hold an example: replace them with your own. This is a general format, not professional advice for your case.

Want us to do this for you every month? Talk to us.