How to Track Receivables? A Guide to Payment Terms, Receivables Aging, Collection Period and Credit Limits
How do you track receivables? Account entries, a receivables aging table, the days sales outstanding (DSO) formula, credit limit calculation, steps for overdue receivables and 7 mistakes.
Contents 12 sections
- What is receivables tracking?
- Why is receivables tracking so important?
- What information should be kept for receivables tracking?
- What is receivables aging, and how is the table prepared?
- How is days sales outstanding (DSO) calculated?
- What does a late receivable cost the business?
- How is a customer credit limit set?
- How do you track receivables step by step?
- What should be done about an overdue receivable?
- The 7 most common mistakes in receivables tracking
- How do you track receivables with NetKasam?
- Frequently Asked Questions About Receivables Tracking
When a business looks at its income statement at the end of the month, it may appear profitable, yet there is no money in the till. That is because some sales were made on credit, and part of that money is still with customers even though it is past due. In small and medium-sized businesses, the most common cause of a cash crunch is not a lack of sales but receivables that cannot be collected. So the answer to how to track receivables is not just a list of "who owes me how much"; it is the regular measurement of payment terms, delays and risk.
In this guide we explain receivables tracking from start to finish: what information to keep in each receivable record, how to prepare a receivables aging table, how to calculate days sales outstanding (DSO) and receivables turnover, what a late receivable costs the business, how to set a customer credit limit, what to do and in what order for an overdue receivable, and the 7 most common mistakes. The customers and figures in the examples were chosen only to illustrate the method.
What is receivables tracking?
In short: Receivables tracking is monitoring amounts arising from credit sales that have not yet been collected by customer, invoice and due date, collecting them on time and systematically following up on late ones.
When a business sells goods or services on credit rather than for cash, a sales invoice is issued but the money has not yet arrived. In accounting, this amount sits in the customer's current account as a trade receivable. Receivables tracking makes visible which of these pending amounts will arrive when, which are late and which customer's payment behavior has deteriorated.
Receivables tracking and collection are connected but not the same thing. Collection is the moment the money is actually received; receivables tracking manages the whole process from sale to collection: setting payment terms, sending reminders, measuring delays, limiting risk and enforcing when necessary.
Why is receivables tracking so important?
In short: Because profit and cash are not the same thing. A credit sale appears as profit on the income statement, but until it is collected you cannot pay salaries, rent or suppliers with it. Every late receivable forces the business either to borrow or to postpone its own payments.
Let's think it through with an example: a business with ₺300,000 in monthly sales that gives its customers 30-day payment terms always has roughly one month of sales, that is ₺300,000, sitting with its customers. If customers pay 15 days late on average, this amount grows by another half month of sales. Even though sales have not increased, the money the business has to finance has gone up by ₺150,000. You can find the difference between the income statement and cash in detail in our article how to prepare an income statement, and the cash side in the definition of the cash flow statement.
The second benefit of receivables tracking is risk management. A customer's payment behavior rarely deteriorates all at once: first they are a few days late, then a few weeks. Regular tracking reveals this trend early and lets you take action before the open balance grows. The concept of liquidity, which describes a business's short-term ability to pay, also depends directly on collecting receivables on time.
What information should be kept for receivables tracking?
In short: For each receivable, keep the customer, invoice number and date, amount, due date, payment method, amount collected and remaining, and days overdue. Without this information, neither the aging table nor the collection period can be calculated.
| Information | Example | What is it for? |
|---|---|---|
| Customer (current account) | Customer C | Lets you total receivables by customer and monitor the credit limit |
| Invoice number and date | Invoice date September 1 | Shows which sale the receivable came from and enables matching during reconciliation |
| Amount | 25.000 ₺ | Makes up the total receivable and the aging groups |
| Due date | October 1 (30 days) | Sets the day the delay begins |
| Payment method | Bank transfer, credit card, cheque, promissory note | Lets you track the collection channel and cheque/promissory note due dates separately |
| Amount collected and remaining | ₺10,000 received, ₺15,000 remaining | Tracks partial payments correctly |
| Days overdue | 12 days | Sets the receivable's aging group and follow-up step |
Having this information scattered across Excel and invoices is the most common reason receivables tracking breaks down. A bookkeeping setup in which each invoice is recorded in the customer account with its due date the moment it is issued, and closed as collections come in, makes all the calculations below possible automatically.
Product pageFree Bookkeeping SoftwareWhat is receivables aging, and how is the table prepared?
In short: Receivables aging is the grouping of open receivables by the number of days since their due date. Common groups are not yet due, and 1–30 days, 31–60 days, 61–90 days and more than 90 days overdue. The table shows at a glance how much of the total receivable is at risk.
To prepare an aging table, calculate the days overdue for each open invoice: Days overdue = Today's date − Due date. If the result is zero or negative, the receivable is in the not-yet-due group; if positive, it goes into the relevant group by number of days. Below is the aging table of a business with ₺100,000 in total open receivables:
| Customer | Open amount | Due status | Delay | Aging group |
|---|---|---|---|---|
| Customer A | 18.000 ₺ | In 15 days | — | Not yet due |
| Customer B | 22.000 ₺ | In 5 days | — | Not yet due |
| Customer C | 25.000 ₺ | Past due | 12 days | 1–30 days |
| Customer D | 15.000 ₺ | Past due | 45 days | 31–60 days |
| Customer E | 12.000 ₺ | Past due | 75 days | 61–90 days |
| Customer F | 8.000 ₺ | Past due | 120 days | More than 90 days |
- Not yet due₺40,00040%
- 1–30 days overdue₺25,00025%
- 31–60 days overdue₺15,00015%
- 61–90 days overdue₺12,00012%
- More than 90 days overdue₺8,0008%
Prepared with sample values.
Three conclusions follow from the table. First, 60% of receivables are past due; the business is unable to collect at the end of the payment term. Second, receivables older than 60 days amount to ₺20,000 (20% of the total); collecting receivables in this group gets harder as the delay grows, and they need priority follow-up. Third, if credit sales continue to Customer F, who is more than 90 days overdue, the risk is growing.
- ₺100,000total open receivables
- 60%share of past-due receivables in the total
- ₺20,000receivables older than 60 days needing priority follow-up
- 1customer over 90 days: new credit sales should be stopped
Prepared with sample values.
How is days sales outstanding (DSO) calculated?
In short: Average collection period = Average trade receivables ÷ Credit sales for the period × Number of days in the period. The result shows how many days on average it takes for a sale to turn into cash. Compared with the average payment term you give, it reveals the average delay.
The average collection period, known as DSO (days sales outstanding), is the single most important indicator in receivables tracking. While the aging table gives you a snapshot of today, DSO shows whether your collection pattern is improving over time. Receivables turnover is calculated from the same data.
- Days overdue = Today's date − Due date
- Average trade receivables = (Opening receivables + Closing receivables) ÷ 2
- Receivables turnover = Credit sales for the period ÷ Average trade receivables
- Average collection period (days) = Average trade receivables ÷ Credit sales for the period × Number of days in the period
- Average delay (days) = Average collection period − Average payment term given
Amounts are taken including VAT, because the amount collected from the customer includes VAT.
Example: A business's credit sales over a three-month (90-day) period are ₺300,000. Open receivables were ₺90,000 at the start of the period and ₺110,000 at the end. The average payment term it gives customers is 20 days.
- Average receivables: (90,000 + 110,000) ÷ 2 = ₺100,000.
- Receivables turnover: 300,000 ÷ 100,000 = 3 (receivables were collected and renewed 3 times during the period).
- Average collection period: 100,000 ÷ 300,000 × 90 = 30 days.
- Average delay: 30 − 20 = 10 days.
The business gives 20-day terms but collects its money in 30 days on average. This 10-day gap is the time the business finances out of its own pocket. Calculating DSO every period and putting the results side by side shows the trend:
- Average payment term given20 days
- Q1 collection period22 days
- Q2 collection period25 days
- Q3 collection period30 days
Prepared with sample values. The difference between the payment term and the collection period is the average delay.
The trend in the chart is a warning: although the payment term has not changed, the collection period rose from 22 to 30 days over three periods. If sales are growing, this gap creates an even larger cash need. We explained how cash moves through a business in our article on cash flow.
What does a late receivable cost the business?
In short: A late receivable is money the business has to finance from another source for that period. Its cost is roughly calculated with the formula Overdue amount × Annual financing rate × Days overdue ÷ 365.
Suppose Customer D's ₺15,000 receivable in the aging table is 45 days late. If the business covers this gap with a short-term loan and its financing cost is, for example, 40% a year, the cost of the delay is 15,000 × 0.40 × 45 ÷ 365 ≈ ₺740. When the same calculation is done for all past-due receivables, you see that "small delays" add up to a significant amount per year. The financing rate is an example; use your own borrowing cost.
Delay also has a hidden cost: the longer it lasts, the lower the chance of collection, the harder reconciliation becomes and the more strained the customer relationship gets. That is why the goal of receivables tracking is not just to collect money but to catch delays early. You can also look at the business-wide cash balance under the heading of liquidity management.
How is a customer credit limit set?
In short: A credit limit is the maximum a customer's open balance can reach. A practical starting formula: Average monthly purchases × Payment term (in months) × (1 + tolerance margin). When the limit is exceeded, new credit sales are stopped until the balance comes down.
Example: A customer makes ₺20,000 in purchases per month on average and works on 45-day terms. 45 days is 1.5 months; under normal conditions their open balance would be around 20,000 × 1.5 = ₺30,000. With a 20% tolerance margin, the credit limit is set at 30,000 × 1.20 = ₺36,000. If the customer has a good payment history, the tolerance is raised; if they have been late, it is lowered. For the general framework of evaluating customers, see the definition of risk analysis.
The credit limit is monitored together with the customer's account balance. The example below shows the customer's account movements during the period and the room left under the limit:
- Opening balance₺12,000
- Sales invoices issued in the period₺30,000
- Balance before collections₺42,000
- Collections made in the period−₺20,000
- Return invoice−₺2,000
- Closing balance₺20,000
Prepared with sample values. Credit limit ₺36,000; room left under the limit 36,000 − 20,000 = ₺16,000.
In businesses that work with cheques and promissory notes, cheques and notes that are not yet due should also be included in the risk calculation. Even if the customer's account balance appears to be zero, if you hold cheques that are not yet due, the risk continues until those cheques are cashed. You can find the basics of these concepts in the definition of cheques and promissory notes.
How do you track receivables step by step?
In short: Set the payment term and credit limit at the time of sale, record the invoice in the customer account with its due date, send a reminder before the due date, make payment easy on the due date, pull an aging report every week and apply a step-by-step follow-up plan when payments are late.
- 01Set terms and limitsDefine the payment term and credit limit for each customer before the sale.
- 02Record the invoice with its due dateAs soon as the invoice is issued, have the amount and due date written to the customer's account.
- 03Remind before the due dateSend a short reminder with the amount and date a few days before the due date.
- 04Make payment easyOffer a card payment link alongside your bank transfer details; keep payment one click away.
- 05Pull aging weeklyCheck the aging report and collection period every week.
- 06Follow up on delays step by stepApply predefined steps according to days overdue, and confirm the balance through reconciliation.
Collections should be matched with the related invoices as they come in; no partial payment should be left unmatched.
The most effective step in this routine is usually the fourth. Many customers delay payment not out of reluctance but out of forgetfulness or hassle. A link sent on the due date that allows card payment with one click gets results much faster than an email with bank transfer details. We explained the advantages of electronic collection in our article on the e-collection system.
What should be done about an overdue receivable?
In short: A step-by-step plan is applied according to days overdue: a polite reminder in the first week, a phone call and payment link in the first month, stopping new credit sales and setting up a payment plan after 30 days, a written notice and reconciliation after 60 days, and evaluating legal action after 90 days.
| Delay | What to do? | Goal |
|---|---|---|
| 1–7 days | Polite reminder message; the invoice and payment link are attached | Collect a forgotten payment right away |
| 8–30 days | Phone call; a promised payment date is obtained and noted | Find out the reason for the delay |
| 31–60 days | New credit sales are stopped; an installment payment plan is set up if needed | Keep the open balance from growing |
| 61–90 days | Written notice and account reconciliation; the balance is mutually confirmed | Document the receivable and surface any dispute |
| More than 90 days | Evaluation with a lawyer for legal action | Protect the receivable |
The strength of this plan is that it is defined in advance: what to do on which day is clear, and nothing is postponed because it might seem "impolite." The first thing to do when a payment is late is to mutually confirm the balance; most disputes stem from an unnoticed return invoice, a short delivery or an incorrectly recorded payment. Always consult a lawyer about legal steps and deadlines.
Recommended readingHow to Calculate the Break-Even Point? A Guide to Unit and Revenue Calculations with the Formula, a Chart and an e-Commerce ExampleThe 7 most common mistakes in receivables tracking
In short: The most common mistakes are issuing invoices without recording the due date, tracking receivables only by customer totals, not setting credit limits and continuing credit sales to late-paying customers.
- Not recording the due date. Without a due date, you cannot know when a receivable becomes late; aging and the collection period cannot be calculated.
- Looking only at customer totals. The total balance may look reasonable while a 120-day-old invoice hides inside it. Tracking is done invoice by invoice.
- Not setting credit limits. With a customer who has no limit, the open balance grows unnoticed; by the time delays start, the receivable is already high.
- Continuing to sell to late-paying customers. New credit sales to a customer with a past-due balance multiply the risk. A rule should be set for anything past 30 days.
- Not matching collections to invoices. An unmatched collection leaves it unclear which invoice was closed; the aging comes out wrong.
- Not tracking cheques and promissory notes separately. A cheque that is not yet due appears closed in the account balance, but the risk continues until it is cashed.
- Neglecting reconciliation. Receivables whose balances were not confirmed at the end of the period cannot be documented when a dispute arises.
How do you track receivables with NetKasam?
In short: In NetKasam you keep your customers in unlimited current accounts, set credit limits, track your invoices and collections in the same place, collect online by card and send reconciliation letters with a single click. Bookkeeping is always free.
With NetKasam customer and supplier account tracking you create as many customers as you like, filter them and set a credit limit for each one: when a customer's open balance exceeds the limit you set, you can have the system block sales to that customer. With the easy reconciliation feature you send reconciliation letters to your customers with a single click, and you store contracts and documents on the account card. With invoice tracking you follow the invoices you issue from one place.
With online collection you can take account balance payments, payment for an invoice you issued or a product sale by credit card; the payment infrastructure is protected by 3D Secure and 256-bit SSL. With Pay by Link you send your customer a single link and get paid. If you work with cheques and promissory notes, the cheques and promissory notes module shows cheques that are not yet due as risk, lets you set a cheque credit limit for a customer, and lets you mark bounced documents and update balances automatically. Virtual POS commission rates are on the pricing page.
Frequently Asked Questions About Receivables Tracking
How do you track receivables?
Every credit sale is recorded in the customer account with the customer, invoice, amount and due date; collections are matched with the related invoices. An aging report is pulled every week, and for overdue receivables a step-by-step follow-up plan is applied according to days overdue.
What is receivables aging?
It is the grouping of open receivables by the number of days since their due date. Common groups are not yet due, and 1–30, 31–60, 61–90 and more than 90 days overdue.
How is the average collection period calculated?
Average trade receivables are divided by the period's credit sales and multiplied by the number of days in the period. For example, with ₺300,000 of credit sales over 90 days and ₺100,000 of average receivables, the collection period is 30 days.
What is receivables turnover?
It is the ratio of the period's credit sales to average trade receivables, and it shows how many times receivables are collected and renewed during the period. The higher the turnover, the faster collection has become.
How is a customer credit limit set?
A practical starting formula is to multiply the average monthly purchases by the payment term expressed in months and add a tolerance margin on top. With ₺20,000 of monthly purchases, a 45-day term and a 20% tolerance, the limit is ₺36,000.
What should be done about an overdue receivable?
In the first week a reminder is sent, in the first month a phone call is made and a payment link is offered, after 30 days new credit sales are stopped, and after 60 days a written notice is sent and a reconciliation is done. For receivables more than 90 days overdue, legal action is evaluated with a lawyer.
Can receivables be tracked in Excel?
It can with a small number of customers, but when invoices, collections and due dates are kept in separate places, matching errors increase. Bookkeeping software that records each invoice with its due date in the customer account updates aging and balances automatically.
What can be done to shorten the collection period?
The most effective methods are sending reminders before the due date, offering a card payment link, applying credit limits and stopping new credit sales to late-paying customers. Progress is tracked by measuring the collection period every period.
Receivables tracking is the last and most neglected step of a sale. Today, list all your open invoices with their due dates and sort them into aging groups. The total of receivables older than 60 days, and the customers who owe them, will already give you the list of your first phone calls this week.
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.