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
Tables
Invoices, Clients
Fields
26
Views
grid, kanban, calendar, dashboard
Updated
2026-11-19
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.
16 fields · 6 sample rows
| Invoice #Text | ClientLink to another table | DescriptionText | Issue DateDate | Due DateDate | SubtotalCurrency | GST RatePercent | TotalFormula | Amount PaidCurrency | BalanceFormula | StatusSingle select | Days OverdueFormula | Paid OnDate | Payment MethodSingle select | Invoice PDFAttachment | NotesLong text |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INV-1041 | Acme Retail Pvt Ltd | Website maintenance – October | 10 Oct 2026 | 9 Nov 2026 | ₹85,000.00 | 18% | ₹1,00,300.00 | ₹1,00,300.00 | ₹0.00 | Paid | 7 Nov 2026 | NEFT / RTGS | |||
| INV-1042 | Bluewave Logistics | Mobile app – milestone 2 | 15 Oct 2026 | 14 Nov 2026 | ₹2,40,000.00 | 18% | ₹2,83,200.00 | ₹1,00,000.00 | ₹1,83,200.00 | Partially paid | 5 | NEFT / RTGS | Balance promised by end of week. | ||
| INV-1043 | Northstar Labs Inc. | Data dashboard sprint | 25 Oct 2026 | 9 Nov 2026 | ₹1,50,000.00 | 0% | ₹1,50,000.00 | ₹1,50,000.00 | Overdue | 10 | Export of services – zero-rated under LUT. | ||||
| INV-1044 | Acme Retail Pvt Ltd | Website maintenance – November | 14 Nov 2026 | 14 Dec 2026 | ₹85,000.00 | 18% | ₹1,00,300.00 | ₹1,00,300.00 | Sent | ||||||
| INV-1045 | Green Leaf Organics | Brand identity package | 17 Nov 2026 | 2 Dec 2026 | ₹1,20,000.00 | 18% | ₹1,41,600.00 | ₹1,41,600.00 | Sent | ||||||
| INV-1046 | Bluewave Logistics | Mobile app – milestone 3 | 19 Nov 2026 | 19 Dec 2026 | ₹2,40,000.00 | 18% | ₹2,83,200.00 | ₹2,83,200.00 | Draft |
10 fields · 4 sample rows
| ClientText | Contact PersonText | EmailEmail | PhonePhone | GSTINText | Payment TermsSingle select | InvoicesLink to another table | Invoice CountCount | Total BilledRollup | OutstandingRollup |
|---|---|---|---|---|---|---|---|---|---|
| Acme Retail Pvt Ltd | Meenal Joshi | [email protected] | +91 22 5555 0101 | 27AABCA1234F1Z5 | Net 30 | INV-1041, INV-1044 | 2 | ₹2,00,600.00 | ₹1,00,300.00 |
| Bluewave Logistics | Suresh Kumar | [email protected] | +91 44 5555 0199 | 33AACCB5678K1Z2 | Net 30 | INV-1042, INV-1046 | 2 | ₹5,66,400.00 | ₹4,66,400.00 |
| Northstar Labs Inc. | Jason Reed | [email protected] | +1 646 555 0123 | Net 15 | INV-1043 | 1 | ₹1,50,000.00 | ₹1,50,000.00 | |
| Green Leaf Organics | Divya Hegde | [email protected] | +91 80 5555 0142 | 29AAFCG9012L1Z8 | Net 15 | INV-1045 | 1 | ₹1,41,600.00 | ₹1,41,600.00 |
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.
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.
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 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.
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.
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.
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.
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.
Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.
Add your clients with their GSTIN and payment terms, then delete the sample clients and invoices.
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.
When money arrives, update Amount Paid, the Paid On date and the payment method, and change the status to Partially paid or Paid.
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.
Vendor invoices are matched to the PO and goods receipt, routed to the right approver by value (budget owner, finance manager or CFO), filed in Google Drive and scheduled for payment.
11 steps · 4 rolesEdesy FormsInvoice Submission FormCollect files and the details that go with them using an invoice submission form.
9 questionsEdesy AgentsInvoice Request AgentCaptures complete invoice request submissions — what, why, by when and priority — and routes them to the right team.
Request · 2 actionsEdesy SignInvoice Acceptance AcknowledgementFor a customer to confirm an invoice is accepted, the goods or services were received, and the amount is not disputed — useful for MSME Samadhaan and TReDS discounting.
2 signer roles · 27 fieldsTotal = 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.
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.
Employees group receipts into expense reports, managers approve them, and the reimbursement due is worked out for you.
2 tables · 25 fieldsBalance Sheet TemplateList every asset, liability and equity account with this and last period’s balances, and check that the books balance.
1 table · 10 fieldsBusiness Budget TemplatePlan annual budget lines by department, log real expenses against them and see year-to-date variance at a glance.
2 tables · 19 fieldsClassified Balance SheetClassify accounts into current and non-current groups and get working capital, current ratio and debt-to-equity per period automatically.
2 tables · 23 fieldsGrant Budget TemplateBuild funder-ready grant budgets with cost-share, justification and burn rate, and keep unallocated award money in view.
2 tables · 24 fieldsPetty Cash LogRecord every petty cash voucher and top-up with approvals and receipts, and see each cash box’s live balance and top-up alert.
2 tables · 23 fields