Invoice Tracker Template

Track invoices from draft to paid with GST totals, partial payments and days overdue, plus outstanding balance per client.

An invoice tracker template is a ready-made register of every invoice you have raised, with its client, amounts, tax, payments received and due date, so you can see at a glance what has been paid, what is outstanding and who is late.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Finance

Tables

Invoices, Clients

Fields

26

Views

grid, kanban, calendar, dashboard

Updated

2026-11-19

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Invoices

16 fields · 6 sample rows

  • All invoices (Grid)
  • Outstanding (Grid)
  • Status board (Kanban)
  • Due dates (Calendar)
  • Receivables (Dashboard)
Invoice #TextClientLink to another tableDescriptionTextIssue DateDateDue DateDateSubtotalCurrencyGST RatePercentTotalFormulaAmount PaidCurrencyBalanceFormulaStatusSingle selectDays OverdueFormulaPaid OnDatePayment MethodSingle selectInvoice PDFAttachmentNotesLong text
INV-1041Acme Retail Pvt LtdWebsite maintenance – October10 Oct 20269 Nov 2026₹85,000.0018%₹1,00,300.00₹1,00,300.00₹0.00Paid7 Nov 2026NEFT / RTGS
INV-1042Bluewave LogisticsMobile app – milestone 215 Oct 202614 Nov 2026₹2,40,000.0018%₹2,83,200.00₹1,00,000.00₹1,83,200.00Partially paid5NEFT / RTGSBalance promised by end of week.
INV-1043Northstar Labs Inc.Data dashboard sprint25 Oct 20269 Nov 2026₹1,50,000.000%₹1,50,000.00₹1,50,000.00Overdue10Export of services – zero-rated under LUT.
INV-1044Acme Retail Pvt LtdWebsite maintenance – November14 Nov 202614 Dec 2026₹85,000.0018%₹1,00,300.00₹1,00,300.00Sent
INV-1045Green Leaf OrganicsBrand identity package17 Nov 20262 Dec 2026₹1,20,000.0018%₹1,41,600.00₹1,41,600.00Sent
INV-1046Bluewave LogisticsMobile app – milestone 319 Nov 202619 Dec 2026₹2,40,000.0018%₹2,83,200.00₹2,83,200.00Draft
Field details
Invoice # · Text
Client · Link to another table
Links to Clients
Description · Text
Issue Date · Date
Due Date · Date
Subtotal · Currency
INR
GST Rate · Percent
Total · Formula
ROUND({Subtotal} * (1 + {GST Rate}), 2)
Amount Paid · Currency
INR
Balance · Formula
IF({Status} = 'Void', 0, ROUND({Subtotal} * (1 + {GST Rate}), 2) - {Amount Paid})
Status · Single select
Draft, Sent, Partially paid, Paid, Overdue, Void
Days Overdue · Formula
IF(AND({Due Date}, {Status} != 'Paid', {Status} != 'Void', {Status} != 'Draft', IS_BEFORE({Due Date}, TODAY())), DATETIME_DIFF(TODAY(), {Due Date}, 'days'), BLANK())
Paid On · Date
Payment Method · Single select
NEFT / RTGS, UPI, Cheque, Card, Wire (international)
Invoice PDF · Attachment
Notes · Long text

Clients

10 fields · 4 sample rows

  • Clients (Grid)
ClientTextContact PersonTextEmailEmailPhonePhoneGSTINTextPayment TermsSingle selectInvoicesLink to another tableInvoice CountCountTotal BilledRollupOutstandingRollup
Acme Retail Pvt LtdMeenal Joshi[email protected]+91 22 5555 010127AABCA1234F1Z5Net 30INV-1041, INV-10442₹2,00,600.00₹1,00,300.00
Bluewave LogisticsSuresh Kumar[email protected]+91 44 5555 019933AACCB5678K1Z2Net 30INV-1042, INV-10462₹5,66,400.00₹4,66,400.00
Northstar Labs Inc.Jason Reed[email protected]+1 646 555 0123Net 15INV-10431₹1,50,000.00₹1,50,000.00
Green Leaf OrganicsDivya Hegde[email protected]+91 80 5555 014229AAFCG9012L1Z8Net 15INV-10451₹1,41,600.00₹1,41,600.00
Field details
Client · Text
Contact Person · Text
Email · Email
Phone · Phone
GSTIN · Text
Payment Terms · Single select
Due on receipt, Net 15, Net 30, Net 45
Invoices · Link to another table
Links to Invoices
Invoice Count · Count
Total Billed · Rollup
sum of Total via Invoices
Outstanding · Rollup
sum of Balance via Invoices

Why each part of the base is there

Invoice #, Client, Description and dates

The register entry for each invoice. The client is a link to the Clients table, so client details are typed once, and the issue and due dates drive the calendar and the overdue calculation.

Subtotal, GST Rate and Total

Enter the pre-tax amount and the GST rate (for example 18 percent, or 0 percent for zero-rated exports), and Total is calculated as subtotal times one plus the rate, rounded to two decimals.

Amount Paid and Balance

Recording what has been received supports part payments, which are common on milestone billing. Balance is the total minus the amount paid, and is zero for a void invoice so cancelled invoices never inflate receivables.

Status and Days Overdue

Status shows where the invoice stands on the Status board. Days Overdue is calculated only for invoices that are not paid, void or draft and whose due date has passed, so the number always reflects real late payments.

Paid On, Payment Method and Invoice PDF

The payment date and method (NEFT or RTGS, UPI, Cheque, Card or international wire) help when reconciling with the bank statement, and the attached PDF keeps the invoice itself with the record.

Clients: GSTIN, Payment Terms, Total Billed and Outstanding

Each client carries its GSTIN and agreed terms, and rollups show the total billed and the outstanding balance across all its invoices, which tells you who owes the most before you take on more work for them.

About the Invoice Tracker Template template

This invoice tracker template has two linked tables. Invoices holds each invoice number with its client, description, issue and due dates, subtotal, GST rate, the amount paid so far, a status (Draft, Sent, Partially paid, Paid, Overdue or Void), the date it was paid, the payment method, the invoice PDF and notes. Formulas work out the total including GST, the balance still owed (zero for void invoices) and the number of days overdue for unpaid invoices past their due date. Clients holds each customer with a contact person, email, phone, GSTIN and payment terms (due on receipt, Net 15, Net 30 or Net 45), and rolls up how many invoices they have, the total billed and their outstanding balance. Views include all invoices, an outstanding list, a status board, a due dates calendar and a receivables dashboard.

Who it is for

It suits freelancers, agencies, consultants, IT service firms and small businesses that raise invoices from Tally, Zoho, a word processor or a billing app but track payments in a spreadsheet. It is set up for Indian billing: amounts are in rupees, GST rates are a per-invoice percentage, clients carry a GSTIN, and payment methods include NEFT or RTGS, UPI and cheque, with a separate option for international wires on export invoices.

How to use it

  1. 1

    Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.

  2. 2

    Add your clients with their GSTIN and payment terms, then delete the sample clients and invoices.

  3. 3

    Each time you raise an invoice in your billing tool, add a row with the invoice number, client, dates, subtotal and GST rate, and attach the PDF.

  4. 4

    When money arrives, update Amount Paid, the Paid On date and the payment method, and change the status to Partially paid or Paid.

  5. 5

    Check the Outstanding view and the Receivables dashboard every week, sort by Days Overdue, and follow up with the clients at the top of the list.

Connected templates in other Edesy apps

Invoice Tracker Template: frequently asked questions

Total = Subtotal x (1 + GST Rate), rounded to two decimals. Enter the rate per invoice, such as 18 percent for most services or 0 percent for an export of services under LUT. It does not split CGST, SGST and IGST; add fields for that if you need the breakdown.

No. It tracks invoices you raise elsewhere. Record each invoice's amounts and attach its PDF; the template then follows payments, balances and overdue days.

Enter the amount received so far in Amount Paid and set the status to Partially paid. Balance updates to the remaining amount, and the client's Outstanding rollup goes down with it.

For invoices whose status is not Paid, Void or Draft and whose due date is before today, it counts the days since the due date. Other invoices show it blank, so you can sort the Outstanding view by it.

No, Status is a field you set. To change it automatically, add a scheduled automation on invoices matching a filter such as Days Overdue greater than 0 and Status is Sent, with an update-record action that sets Status to Overdue.

Yes. The Clients table rolls up Total Billed and Outstanding from the client's linked invoices, so the outstanding figure per client is always current.

About the app

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates