EN
e-Invoice and Tax

How to Track Invoices? A Guide to Invoice Statuses, Due Dates, Collection Matching, Overdue Invoice Aging, Returns and Weekly Tracking

How do you track invoices? Invoice statuses, due dates, collection matching, aging of overdue invoices and a weekly routine: an 8-lesson guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is invoice tracking for?
  3. Lesson 2: What statuses does an invoice go through?
  4. Lesson 3: What should you record correctly when issuing an invoice?
  5. Lesson 4: How is a collection matched to an invoice?
  6. Lesson 5: How do you set up a due date calendar and reminders?
  7. Lesson 6: How are overdue invoices aged?
  8. Lesson 7: How do returns and cancellations affect invoice tracking?
  9. Lesson 8: How do you set up a weekly invoice tracking routine?
  10. What are the most common mistakes in invoice tracking?
  11. How does NetKasam make invoice tracking easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: List your overdue invoices this week
  14. Frequently Asked Questions About Invoice Tracking

You issued 120 invoices during the month, totaling ₺960,000. At month end, a question comes up: how many of these were collected, how many are not yet due, and how many are overdue? If the answer is scattered across ledgers, the bank statement, a few spreadsheets and the memories of a few people, by the time you notice an overdue invoice, the delay is usually well advanced. Yet issuing the invoice is only half the job; a sale is not complete until you see that the invoice has been collected.

This article is not a narrative but an 8-lesson hands-on training. We will answer the question how to track invoices with numbers, using an example month of 120 invoices: invoice statuses, correct recording at the time of issue, collection matching, the due date calendar, aging of overdue invoices, the effect of returns and cancellations, and the weekly tracking routine. At the end there is a mini quiz with an answer key. For the side of collecting overdue receivables, see the article how to track receivables; here we focus on the tracking routine from issuing the invoice to collecting it.

What will you be able to do by the end of this training?

In short: You will classify invoices by status, record the due date when the invoice is issued, match collections to invoices, age overdue invoices, and set up a weekly tracking routine.

Training mapThe six steps of invoice tracking
  1. 01
    IssueIssue the invoice in the correct format with a due date.
  2. 02
    AccountThe invoice is posted to the customer's open balance.
  3. 03
    ReminderNotify the customer as the due date approaches.
  4. 04
    CollectionMatch the incoming payment to the invoice.
  5. 05
    OverdueGroup overdue invoices by age.
  6. 06
    ClosingDeduct returns and cancellations from the balance.

The 8 lessons of this training: (1) the purpose of invoice tracking, (2) invoice statuses, (3) recording at the time of issue, (4) matching collections, (5) due date calendar and reminders, (6) aging overdue invoices, (7) the effect of returns and cancellations, (8) the weekly tracking routine.

Lesson 1: What is invoice tracking for?

In short: Invoice tracking monitors whether the money for an issued invoice comes in on time. It makes the gap between sales and cash visible.

Without trackingWith tracking
Late payments are noticed at month endLate payments are noticed on the due date
"Has the payment arrived?" is checked one by oneOpen balances are visible on a single screen
Unclear which invoice has been paidEvery collection is linked to an invoice
Cash flow is hard to forecastExpected collections are on the calendar

In NetKasam, invoices work linked to the current account: an invoice you issue increases the customer's balance, a collection you receive reduces it, and cash and bank movements are updated from the same record. So you don't need a separate spreadsheet for invoice tracking; tracking is built into the recording flow itself. For the basics of customer accounts, see the article how to track customer and supplier accounts and the invoice tracking page. Example business: a wholesaler that issues about 120 invoices a month and has corporate and dealer customers, some of whom buy on credit terms.

Lesson 2: What statuses does an invoice go through?

In short: An invoice is issued, reaches the customer, and is either partially or fully collected or becomes overdue. Each status calls for a different action.

SituationMeaningAction
Issued, not yet dueInvoice issued, payment date not yet reachedAdd to the due date calendar
Partially collectedPart of the amount has been paidTrack the remainder
Fully collectedInvoice closedArchive
OverduePayment date passed, no collectionRemind, call
Return or cancellationInvoice correctedDeduct from balance

Separating these five statuses splits a vague bucket like "pending invoices" into three: normally pending, partially paid, and overdue. Each calls for a different action; you leave the normally pending ones alone, remind partially paid customers of the remaining amount, and call the overdue ones. Without this distinction, you either bother customers whose invoices are not yet due or fail to notice the overdue invoice.

Product pageFree Bookkeeping Software

Lesson 3: What should you record correctly when issuing an invoice?

In short: The quality of tracking is determined at the time of issue. Without the right account, the right invoice type, and the right due date, the later steps do not work properly.

AreaCorrect recordConsequence of an error
AccountCorrect company name, tax numberThe balance is posted to the wrong customer
Invoice typee-Invoice or e-Archive invoice based on the taxpayer checkThe invoice may be in an invalid format
DueThe agreed payment dateThe overdue calculation goes wrong
Amount and VATConsistent with the order and waybillA difference arises at collection
ContactUp-to-date email and phoneThe reminder does not reach the customer

When you issue an invoice in NetKasam, the system checks whether the other party is an e-Invoice taxpayer and selects the correct format; the resulting invoice is sent to the customer automatically. For customers you work with regularly, you can set up recurring invoices; invoices are prepared on the specified dates and notifications go to you and the customer. To set up recurring invoices, see the article how to set up recurring invoices. For when an invoice must be issued, the article within how many days must an invoice be issued is helpful.

Lesson 4: How are collections matched to invoices?

In short: Link every collection to an invoice. For partial payments, track the remaining amount separately; post the collection to the cash account or the bank, depending on where it came in.

Example: For a ₺24,000 invoice, the customer first sent a ₺10,000 bank transfer and will pay the rest next week.

ItemAmountInvoice status
Invoice amount24.000 ₺Issued
1st collection (bank transfer)10.000 ₺Partially collected
Remaining balance14.000 ₺Being tracked
2nd collection14.000 ₺Fully collected

Payment can arrive in different ways: bank transfer, cash at the register, credit card, or a Pay by Link link. NetKasam offers a credit card payment option and payment reminders (email, SMS); for online collection options, see the article how to choose online collection methods. To match bank movements with accounts, the article how to do a bank reconciliation is a useful complement.

If a discrepancy appears during matching (the customer paid ₺23,500 instead of ₺24,000), don't quietly ignore the difference; note the reason, however small. Most of the time this difference is a commission deduction, a return, or an item that doesn't match the customer's own records. Having every collection linked to an invoice eliminates the month-end question "what is this money for?"

Lesson 5: How do you set up a due date calendar and reminders?

In short: See invoices approaching their due date on a weekly calendar and gently notify the customer a few days before the due date. A reminder before the payment is late is received much better than a call after it is late.

TimingStepChannel
3 days before the due dateNotificationEmail or SMS
Due datePayment link reminderEmail
3 days after the due dateReminderSMS, email
10 days after the due datePhone callPhone

In NetKasam, you can send invoices to the customer by email as an online statement and send payment reminders by email or SMS. Write reminders in a helpful tone that doesn't harm the relationship: the invoice number, amount, due date, and payment options are enough. Having a standard reminder template ensures consistent communication regardless of who writes it.

FormulaThe four formulas of invoice tracking
  1. Collection rate = Amount collected ÷ Total amount invoiced × 100
  2. Open receivables = Total invoiced − Collected
  3. Overdue rate = Overdue amount ÷ Total amount invoiced × 100
  4. Days overdue = Today − Due date

Prepared with sample values.

Lesson 6: How do you age overdue invoices?

In short: Group overdue invoices by how many days late they are. The older they get, the harder they are to collect; priority goes to the oldest and largest amounts.

ChartStatus of the ₺960,000 invoiced: collected, awaiting due date, and overdue
  1. Total invoiced (120 invoices)₺960,000
  2. Collected (78 invoices)−₺612,000
  3. Not yet due (30 invoices)−₺228,000
  4. Overdue (12 invoices)₺120,000

Prepared with sample values. Collection rate 63.8%, overdue rate 12.5%.

ChartOf 120 invoices, 78 were collected, 30 are awaiting their due date, and 12 are overdue
  • Collected₺7865%
  • Not yet due₺3025%
  • Overdue₺1210%

Prepared with sample values.

Overdue ageInvoicingAmountAction
1–15 days538.000 ₺SMS, email reminder
16–30 days442.000 ₺Phone call
31 days and over340.000 ₺Report to management, review new sales
Total12120.000 ₺–
ChartOverdue amount by age: few invoices over 31 days, but large ones
  1. 1–15 days (5 invoices)₺38,000
  2. 16–30 days (4 invoices)₺42,000
  3. 31 days and over (3 invoices)₺40,000

Prepared with sample values. Total ₺120,000.

In the table, the riskiest group is 31 days and over: only 3 invoices but ₺40,000. The average invoice amount is about ₺13,333 in that group of 3, while it is ₺7,600 in the 1–15 day group. In other words, the oldest invoices are also the largest; set priority by amount, not just by the number of invoices. If the same customer has both old and new invoices, see the article how to set a customer risk limit to review new sales.

Recommended readingHow to Track Receivables?

Lesson 7: How do returns and cancellations affect invoice tracking?

In short: The amount of a returned or canceled invoice is deducted from the customer's open balance. If you don't include these in tracking, you end up waiting for an amount the customer doesn't actually owe you.

Example: Open receivables are ₺348,000 (228,000 awaiting due date + 120,000 overdue). A return totaling ₺14,000 was made on two of these invoices, and a return invoice was issued.

ItemAmount
Open receivables (before return)348.000 ₺
Return invoices (2)−14.000 ₺
Net open receivables334.000 ₺

When the return invoice is posted to the relevant customer account, the balance goes down, so you don't ask for too much when sending the customer a reminder. For how to issue a return invoice, see the article how to issue a return invoice. Correcting or canceling an incorrectly issued invoice is something to clarify with your certified public accountant (mali müşavir); proceeding with a correction document instead of quietly deleting the invoice preserves the tracking trail.

Return differences often surface during reconciliation: the customer has deducted the return, but you haven't recorded it yet. So issue return invoices in the same week the return arrives whenever possible. For how to find these differences, see the article how to find and close account reconciliation differences.

Lesson 8: How do you set up a weekly invoice tracking routine?

In short: Open the same list once a week: newly overdue invoices, invoices due this week, and partially paid ones. The routine should not take more than ten minutes.

DayControlDuration
MondayInvoices due this week3 min
WednesdayNewly overdue invoices, sending reminders4 min
FridayPartially paid invoices, collections received this week3 min
Month-endAging table, collection rate15 min
Takeaways from the exampleFour figures from the sample month
  • 63.8%collection rate (612,000 / 960,000)
  • ₺348,000open receivables (228,000 + 120,000)
  • 12.5%overdue rate (120,000 / 960,000)
  • ₺40,000at risk across 3 invoices over 31 days

The weekly routine takes about ten minutes: 3 minutes on Monday, 4 on Wednesday, and 3 on Friday. These ten minutes replace a cleanup that would take hours at the end of the month. Use the reports screen to save reports and open them with the same criteria every week; a saved report means you don't have to set up filters each time. Write the collection rate and overdue rate side by side month by month: if the collection rate is falling while the overdue rate is rising, the cause lies in customer payment behavior; if both are stable while cash inflows are declining, look at the timing of invoice issuance.

Connect invoice tracking with cash flow: invoices coming due are your collection forecast for the coming weeks. When you put expected collections next to expense payments, you can see in advance whether there will be a cash shortfall. For this, see the article how to prepare a cash flow statement.

Recommended readingHow to Prepare a Cash Flow Statement?

What are the most common mistakes in invoice tracking?

  1. Not entering the due date. Overdue status can't be calculated and the reminder timing is unknown.
  2. Not linking collections to invoices. It remains unclear which invoice has been paid.
  3. Counting a partial payment as full. The remaining amount is forgotten.
  4. Leaving reminders until after the payment is late. A polite reminder before the due date is more effective.
  5. Not deducting returns and cancellations from the balance. You remind the customer of too large an amount.
  6. Not aging overdue invoices. Priorities can't be set.
  7. Leaving tracking until month end. A weekly check reveals problems early.

How does NetKasam make invoice tracking easier?

  • Invoices linked to accounts. A sales invoice increases the balance, a collection reduces it; unpaid amounts appear as an open balance (invoice tracking).
  • Taxpayer check. When issuing an invoice, the correct e-Invoice or e-Archive invoice format is selected.
  • Recurring invoices. For regular customers, invoices are prepared on the specified dates and a notification is sent.
  • Online statement. Invoices are sent to the customer by email.
  • Payment reminders. Reminders by email and SMS; accept payments by credit card and Pay by Link.
  • Filtering and reports. Invoices can be filtered, and reports can be saved and exported to Excel (reports).
  • Free bookkeeping. Bookkeeping, including invoice tracking, is free; what you pay for are e-Invoice credits and integrations. For details, see the pricing page.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. 150 of 200 invoices have been collected. What is the collection rate by number of invoices?
  2. ₺800,000 was invoiced and ₺560,000 was collected. How much are the open receivables?
  3. ₺12,000 of a ₺30,000 invoice has been paid. What is the remaining amount and the status?
  4. An invoice due on November 1 is still unpaid on November 12. How many days overdue is it, and which age group is it in?
  5. Why should return invoices be included in tracking?

Answer key:

  1. 150 ÷ 200 × 100 = %75.
  2. 800.000 − 560.000 = 240.000 ₺.
  3. 30,000 − 12,000 = ₺18,000; status "partially collected".
  4. 12 − 1 = 11 days; in the 1–15 day group.
  5. A return reduces the customer's open balance; if it isn't included, you expect too large an amount.

Frequently Asked Questions About Invoice Tracking

How do you track invoices?

You monitor the status of each invoice (collected, not yet due, overdue), match collections to invoices, send reminders as the due date approaches and do a weekly check.

How do I see unpaid invoices in NetKasam?

Since invoices are linked to the current account, unpaid amounts appear in the customer's open balance; you can also list them by filtering invoices.

Is there a separate fee for invoice tracking?

No. NetKasam's bookkeeping, including invoice tracking, is free; e-Invoice credits and integrations are paid.

How do you send a payment reminder to a customer?

You can send payment reminders by email or SMS and send the invoice as an online statement by email.

How is a partial collection tracked?

The amount received is linked to the invoice and the remaining balance is tracked as open; when the full amount arrives, the invoice is closed.

Why are overdue invoices aged?

Because collection gets harder as the age increases, priority is given to the oldest invoices with the largest amounts.

How does a return invoice affect tracking?

When the return invoice is posted to the customer account, the customer's open balance decreases; this way you don't ask for too much.

Is there automation for regularly issued invoices?

Yes. With recurring invoices, invoices are prepared on set dates, and notifications go to you and your customer.

Conclusion: List the invoices that became overdue this week

The most useful thing you can do today is see your overdue invoices in a single list. Filter customers with an open balance on the accounts screen, write down the due date and days overdue for each invoice, and then group them by age. With this list, you'll know which customer needs an SMS tomorrow, which needs a phone call, and which needs a management meeting. The next step is to turn this check into a ten-minute weekly routine: invoices coming due on Monday, newly overdue ones on Wednesday, and partially paid ones on Friday.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeFree Bookkeeping Software

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools