Singapore guide

Invoice tracker for Singapore freelancers: separate unpaid, overdue and paid

Copy a simple SGD invoice tracker with an outstanding-balance formula, a dated-payment log and worked examples.

Updated 22 November 2026. Information only, not personalised advice.

An invoice tells a client what to pay. An invoice tracker helps you see what remains unpaid, what is already settled and which agreed deadlines have passed. For a Singapore freelancer managing a few projects, a simple sheet can make those differences visible without buying software.

This is a copyable worksheet for ordinary non-GST SGD service invoices. It is not an online ledger, a GST reporting template or a debt-collection service. Keep your own secure copy; this page does not accept or save invoice details.

Copy one row for each issued invoice

Keep the invoice reference, issue date, agreed due date, original amount, separately agreed credits, matched payments and outstanding balance. Add a short project reference and your next review action if useful. The sample below omits the issue-date column to keep it readable; include that date in your own record.

Fictional snapshot on 17 November 2026; all amounts in SGD
Reference Agreed due date Original amount Credits Payments matched Outstanding Status
INV-A 9 Nov 2026 S$1,000 S$100 S$400 S$500 8 days overdue
INV-B 10 Nov 2026 S$600 S$0 S$600 S$0 Settled
INV-C 30 Nov 2026 S$800 S$0 S$0 S$800 Not yet due

The unpaid total is S$1,300: S$500 plus S$800. Only S$500 is overdue at this review date. Calling the whole S$1,300 late would misstate the agreed payment timing. No standard Singapore payment period is assumed.

Calculate the balance without hiding differences

Outstanding balance = original invoice amount − agreed credits − matched payments. For INV-A: S$1,000 − S$100 − S$400 = S$500. A credit changes the amount owed; it is not another payment into your bank.

If your own sheet uses columns C, D and E for those three numeric amounts, the balance in F2 can be =ROUND(C2-D2-E2,2). Copy it only after checking the column layout. Spreadsheet settings may require a different argument separator. Store currency amounts as numbers and apply currency formatting.

Do not automatically replace a negative balance with zero. It may flag an overpayment, duplicate receipt or credit needing review. A negative balance on one invoice should not silently cancel a positive balance on an unrelated invoice.

Keep the credit-note reference and reason beside the invoice it adjusts. A S$1,200 bill less an agreed S$200 credit and S$900 of matched payments leaves S$100 outstanding. Do not enter the credit as another bank receipt.

The non-GST credit-note guide includes the official IRAS source, a document checklist and a separate fully-paid/refund scenario. Our tools do not generate credit notes or reconcile these changes automatically.

Keep a separate dated payment log

If you issue a receipt, add its reference beside the payment entry so you can retrieve the acknowledgement. The receipt number is not another bank transaction. One S$300 transfer acknowledged by a receipt is still S$300 received, not S$600.

Use the receipt-template guide for a partial-payment example and current IRAS record guidance. Our tools do not generate receipts or link a payment log automatically.

The table shows S$1,000 of payments matched across INV-A and INV-B. It does not say all that cash arrived this month. Record each actual bank receipt once, with its date, amount and the invoice allocation. Then total receipts for the period you are reviewing.

If one transfer pays several invoices, allocate it across their references and check that the allocated amounts equal the transfer. If you cannot identify a receipt, investigate it before treating an invoice as settled. Do not issue a second invoice merely because a customer paid part of the first one.

Use status to choose the next action

  1. Check the original agreement and invoice due date.
  2. Match bank receipts and any agreed credits.
  3. Review disputes or missing billing information before following up.
  4. For an unpaid amount past its agreed deadline, use a factual reminder with the correct remaining balance.
  5. Record the response and next review date without promising that collection will succeed.

Use our payment-reminder examples after reconciliation. The site does not send reminders or contact your clients. Payment terms and changes need agreement; a spreadsheet formula cannot establish a contractual entitlement.

Create the document, then maintain your own history

The free quotation and invoice sheet lists up to five lines of work in SGD for an ordinary non-GST quotation or invoice, without a login, and you print the page or save it as a PDF from your browser. It has no CSV export. It does not maintain this tracker, import payments or save client history. See the invoice checklist before generating a document.

Use actual receipts and paid business cash costs in the income and expense calculator. Invoice totals, cash received and taxable net trade income are different figures. The sheet is not a tax calculation or a complete set of accounts.

IRAS requires proper business records supported by documents and generally five years of retention. Keep invoice copies, credit explanations and payment evidence together. Use project references and avoid unnecessary personal information. Do not submit invoices, client identities or bank details through our public feedback form.

Would saved invoice history or payment tracking help your work? Use the optional feedback form on the home page to describe the task without sharing client data. No saved-history account is offered yet.

A fuller column set for a busy month

The sample table above is trimmed for reading. In your own sheet, a fuller set of columns saves time once you have more than a handful of clients:

Suggested columns for your own tracker
Column What to record
Invoice reference The number on the invoice, unique for each one
Client A short name or code, not unnecessary personal details
Issue date and due date The actual date issued and the due date in your agreement
Original amount The invoice total as issued, as a number
Credits Agreed reductions, linked to a credit note reference
Payments matched The total of bank receipts allocated to this invoice
Outstanding A formula: original − credits − payments
Status Settled, not yet due or overdue, worked out from the other columns
Last contact and next review When you last asked about it, and when you will look again

Let the sheet work out the status

Suppose your due date is in column B, the outstanding balance is in column F and the first data row is row 2. Two formulas then do the work.

Optional status formulas for row 2 of your own sheet
Column Formula Returns
Status =IF(F2<=0,"Settled",IF(TODAY()>B2,"Overdue","Not yet due")) One of three labels
Days overdue =IF(AND(F2>0,TODAY()>B2),TODAY()-B2,0) 0 for settled and not-yet-due invoices

Check the cell references against your own layout and test the formulas on a row you can verify by hand. Spreadsheet programs differ in details such as the argument separator, and TODAY() changes every time you open the file, so copy the sheet and freeze the figures if you want a record of a particular review date.

Treat a due date that falls on the review date as due, not late. An invoice becomes overdue the day after its agreed due date. That keeps the status consistent with the formula above.

Worked example: an ageing summary

Once you have the status, grouping unpaid invoices by how late they are helps you decide where to start. The invoices below are invented, with a review date of 30 November 2026.

Illustrative ageing summary, SGD
Reference Due date Outstanding Position at 30 Nov 2026
INV-D 20 Nov 2026 S$450 10 days overdue
INV-E 27 Nov 2026 S$300 3 days overdue
INV-F 10 Dec 2026 S$900 Not yet due
INV-G 15 Oct 2026 S$650 46 days overdue

The total unpaid is S$450 + S$300 + S$900 + S$650 = S$2,300. The overdue part is S$450 + S$300 + S$650 = S$1,400. The oldest item, INV-G, is the natural place to start, and the S$900 that is not yet due should not be chased at all. Your own bands, such as under a week, one to four weeks and over a month, are a matter of preference.

A weekly routine that takes about fifteen minutes

  1. Download or open your bank statement for the week and list every receipt.
  2. Match each receipt to an invoice and enter it in the payment log with its date.
  3. Add any new invoices and any credit notes issued this week.
  4. Look at the status column and filter for overdue items.
  5. For each overdue item, decide: reminder, query or wait. Note the decision and date.
  6. Check that the total of payments matched this week equals the total of receipts you listed, apart from any you cannot yet identify.

Fifteen minutes is an estimate for a small number of invoices, not a promise. If it takes much longer, your records probably need tidying rather than your routine needing speeding up.

Common tracker mistakes

  • Marking an invoice settled on a promise or a screenshot rather than money in your account.
  • Typing amounts as text with “S$” in the cell, so formulas cannot add them.
  • Changing the original amount instead of recording a credit.
  • Using today’s date as the due date for every unpaid invoice.
  • Counting unpaid invoices as money you can spend.
  • Letting the payment log and the invoice list drift apart because they are updated at different times.

Records to keep

A tracker is a working summary, not your accounts. IRAS says self-employed persons must keep proper records and accounts supported by invoices, receipts and vouchers, and retain them for five years. Its non-GST guide says businesses must retain all business-related bank statements and advises regular bank reconciliation, which is exactly what the weekly routine above does. Keep the invoices, credit notes, receipts and statements that sit behind each row, and save a dated copy of the tracker at each month end.

If your situation differs

You have many clients. Add a client column and use your spreadsheet’s filter, so you can see everything one client owes in one place. Compare each client’s average payment time over a few months before you plan around it.

A client pays before you invoice. Keep a short separate list of receipts that have not yet been allocated to an invoice. Do not enter them as negative balances on unrelated invoices, and allocate them when you issue the invoice.

You bill in instalments or a retainer. Give each instalment its own row with its own due date. The tracker then shows which instalments are due, not just the total.

You are GST-registered. IRAS says only registered businesses can charge GST. If you are registered, your tracker needs the GST treatment that IRAS’s GST guidance describes, which this page does not cover.

Frequently asked questions

What is the difference between unpaid and overdue?

Unpaid means money is still owed. Overdue means it is past the due date in your agreement. In the first example above, S$1,300 is unpaid but only S$500 is overdue.

How often should I update the tracker?

A weekly update is enough for most freelancers, plus a quick look whenever an invoice goes out or a payment arrives.

Should negative balances be set to zero?

No. A negative balance may mean an overpayment, a duplicate receipt or a credit that was entered twice. Investigate it rather than hiding it.

Can I use a spreadsheet or do I need software?

A spreadsheet works for a small number of invoices. The official pages we checked do not require any particular tool, and IRAS says records can be kept electronically using a computer or accounting software, without IRAS approval. Keep the underlying documents either way.

How do I record a refund I paid to a client?

As a separate outgoing payment with its own date, linked to the original invoice. It is not a negative receipt.

Does the website keep my tracker?

No. This page is a guide for your own spreadsheet. Nothing you type into your copy is sent to this site.

  • Quotation and invoice sheet: a Quotation or Invoice selector, up to five lines of work, a total, and print or save as PDF. It does not track payments.
  • Income and expense calculator: compares cash received with business expenses paid for one consistent period.
  • Money planner: enter six monthly figures; it shows their average and your lowest month against your commitments.

Sources and checks

The 4 pages below were fetched on 22 November 2026 for this tracker guide. Anything not listed was not re-checked.

Illustrative only, not tax or financial advice. Dates and amounts are invented. Day counts and totals were checked on 22 November 2026.

Try it with your own numbers. The money planner is free, runs in your browser and saves nothing.

Open the money planner