How Do You Track Customer and Supplier Accounts? A Guide to Reading Account Statements, Debit and Credit Balances, Aging and Risk Limits
How do you track customer and supplier accounts? Reading the account statement, receivable and payable balances, receivables aging, risk limits and reconciliation differences: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is a current account and why is a separate one kept for each customer?
- Lesson 2: How do you read an account statement?
- Lesson 3: How is the account balance calculated?
- Lesson 4: What is receivables aging and how is it done?
- Lesson 5: How do you set a risk limit for a customer?
- Lesson 6: How do you manage balance reminders and collections?
- Lesson 7: How do you find and close a reconciliation difference?
- Lesson 8: How do you track supplier accounts and set up a weekly routine?
- What are the most common mistakes in tracking customer and supplier accounts?
- How does NetKasam make account tracking easier?
- Mini quiz: Test what you have learned
- Conclusion: Read the statements of your top 5 customers this week
- Frequently Asked Questions About Account Tracking
Your customer says "I don't see any debt on my side", while you see a ₺12,200 receivable on screen. You may both be right: a return invoice is in one side's records but not in the other's. Current account tracking is the routine for catching such disputes before they arise, knowing at any moment who owes how much and collecting on time.
This article is not just an explanation; it is an 8-lesson practical course. It answers how to track a current account with numbers; using a sample customer, we will work through reading the account statement line by line, the receivable and payable balance, receivables aging, the risk limit, finding reconciliation differences and the supplier side. At the end there is a mini quiz and a weekly routine. For the definition of the concept, see the glossary term current account.
What will you be able to do by the end of this training?
In short: You will read an account statement without errors, calculate the balance, age your receivables, define a risk limit for the customer, and find and close a balance difference with the counterparty.
- 01RecordOpen a single current account for each customer and supplier and enter the opening balance.
- 02StatementRead the statement line by line and verify the balance.
- 03AgeSeparate receivables into day ranges.
- 04LimitSet a risk limit and payment terms for each customer.
- 05ReminderSend reminders for balances approaching or past due.
- 06ReconciliationMatch the balance with the counterparty at month end.
The 8 lessons of the course: (1) what a current account is, (2) how to read a statement, (3) how to calculate the balance, (4) receivables aging, (5) the risk limit, (6) reminders and collections, (7) reconciliation differences, (8) supplier accounts and the weekly routine.
Lesson 1: What is a current account and why is a separate one kept for each customer?
In short: A current account tracks the debit-credit movements between you and a person or organization in a single account. A separate one is kept for each customer and supplier, because that is the only way to know how much you are owed by whom and how much you owe to whom.
| Account type | Debited by | Credited by | Meaning of a positive balance |
|---|---|---|---|
| Customer account | Sales invoice | Collection, sales return | The customer owes you |
| Supplier account | Payment, purchase return | Purchase invoice | You owe the supplier (credit balance) |
For marketplace sales, a separate account is not opened for each buyer; the marketplace itself is tracked as an account and payouts are closed as collections. For the accounting of this setup, see the article marketplace accounting. Collections of cheques and promissory notes with payment terms also close the current account; for details, see the article cheque and promissory note tracking.
Lesson 2: How do you read an account statement?
In short: An account statement shows all movements of an account in date order, with debit, credit and running balance columns. As you read, check how each line changes the balance; the balance on the last line should equal the difference between total debits and total credits.
Below is the September statement of our sample customer, Yıldız Market (figures chosen only to illustrate the method).
| Date | Document | Debit | Credit | Balance |
|---|---|---|---|---|
| 01.09 | Opening balance | 12.000 ₺ | - | ₺12,000 debit |
| 05.09 | Sales invoice F-101 | 18.000 ₺ | - | ₺30,000 debit |
| 12.09 | Collection (bank transfer) | - | 15.000 ₺ | ₺15,000 debit |
| 18.09 | Sales invoice F-102 | 9.600 ₺ | - | ₺24,600 debit |
| 20.09 | Return invoice (partial F-101) | - | 2.400 ₺ | ₺22,200 debit |
| 28.09 | Collection (cheque) | - | 10.000 ₺ | ₺12,200 debit |
| Total | 39.600 ₺ | 27.400 ₺ | ₺12,200 debit |
Check: total debits ₺39,600 − total credits ₺27,400 = ₺12,200, meaning the customer owes you ₺12,200. Return invoices are the reverse of a sales invoice, so they are written on the credit side; for the logic of returns, see the article how to issue a return invoice.
Product pageFree Bookkeeping SoftwareLesson 3: How is the account balance calculated?
In short: In a customer account, balance = opening balance + debit movements − credit movements. If the result is positive, the customer owes you; if negative, the customer has a credit with you (an advance or overpayment).
- Account balance = Opening balance + Total debits − Total credits
- Risk limit usage = Account balance ÷ Risk limit
- Days to collect = Receivables ÷ Daily sales
- Overdue rate = Overdue receivables ÷ Total receivables
- Reconciliation difference = Your balance − The counterparty's balance
In a supplier account the direction is reversed: a purchase invoice is credited and a payment is debited.
- Opening balance₺12,000
- Sales invoice F-101₺18,000
- Sales invoice F-102₺9,600
- Bank transfer collection−₺15,000
- Return invoice−₺2,400
- Cheque collection−₺10,000
- Closing balance₺12,200
Prepared with sample values.
Lesson 4: What is receivables aging and how is it done?
In short: Receivables aging is the separation of receivables into ranges of 0-30, 31-60, 61-90 and over 90 days according to how many days have passed since the invoice (or due) date. As a receivable ages, the likelihood of collection falls; that is why the age distribution matters more than the total balance.
- 0-30 days₺58,00058%
- 31-60 days₺24,00024%
- 61-90 days₺12,00012%
- Over 90 days₺6,0006%
Prepared with sample values. As overdue receivables age, their follow-up priority increases.
| Age range | Amount | Share | What to do? |
|---|---|---|---|
| 0-30 days | 58.000 ₺ | %58 | Normal follow-up; remind those approaching their due date |
| 31-60 days | 24.000 ₺ | %24 | Send a reminder and follow up by phone |
| 61-90 days | 12.000 ₺ | %12 | Consider stopping new sales and set up a payment plan |
| Over 90 days | 6.000 ₺ | %6 | Evaluate a written notice and legal options with your certified public accountant (mali müşavir) |
Share check: 58 + 24 + 12 + 6 = 100. In aging, the order in which collections are applied to old invoices matters: which invoice was the payment offset against? Applying the payment to the oldest invoice is a common method and shows the age correctly. For the collection process and reminder steps, see the article how to track receivables.
Recommended readingHow to Track Receivables?Lesson 5: How do you set a risk limit for a customer?
In short: A risk limit is the highest open balance you can extend to a customer on credit terms. Stopping new credit sales once the limit is reached keeps receivables you cannot collect from growing.
- Classify your customers: Separate cash-paying, credit-term, new and risky customer groups.
- Set the limit: The customer's monthly purchase volume, payment history and your own cash strength are the criteria for the limit.
- Write down the terms: Along with the limit, decide how many days of payment terms you give.
- Monitor usage: Check the balance ÷ limit ratio every week.
- Stop when the limit is reached: Do not make new credit sales until a collection comes in.
- Akın Tekstil92%
- Su Elektrik78%
- Demir Gıda55%
- Yıldız Market41%
- Ay Kırtasiye12%
Prepared with sample values. Yıldız Market's balance of ₺12,200 is 41% of its ₺30,000 limit; the percentages are relative to each customer's own limit.
In NetKasam you can classify your customers and define a separate limit, risk and discount for each. When the set risk levels are reached, new sales for the related accounts are restricted automatically. Details: customer and supplier account tracking.
Lesson 6: How do you manage balance reminders and collections?
In short: A polite reminder as the due date approaches, a clear reminder once it has passed and sharing the account statement shorten collection time. When reminders stop being personal and follow a set routine, collections rise without harming the relationship.
| Timing | Action | Tone |
|---|---|---|
| 3-5 days before the due date | Balance and due date reminder | Informative |
| Due date | Statement sharing and payment details | Polite |
| 7 days after the due date | Second reminder, phone call | Clear |
| 30 days after the due date | Written notice, new credit sales stopped | Formal |
NetKasam sends automatic reminders for payments that are approaching or past their due date. You can send balance reminders to your customers and suppliers by bulk SMS and share your account statements online; for sharing invoices, see the question how do I share invoices with my customers. For how collection relates to payment terms, you can look at the terms payment term and collection. If you need to refund a collection, see the question refunding collections.
Lesson 7: How do you find and close a reconciliation difference?
In short: Reconciliation means confirming that your account balance matches the other party's balance. If there is a difference, compare the two statements line by line; the cause is usually that one side has not entered a record.
Example: You see a balance of ₺12,200 for Yıldız Market; the customer says ₺9,800. Difference = 12,200 − 9,800 = ₺2,400. This amount equals the return invoice dated 20.09: the customer has not entered the return invoice in their own records, or has entered it with a different amount.
| Cause of difference | Sign | Solution |
|---|---|---|
| Invoice not entered on one side | Difference equals the invoice amount | Send the invoice so the other party records it |
| Return or discount not entered | Difference equals the return amount (as in the example) | Forward the return invoice |
| Collection not entered or entered on a different date | Difference equals the collection amount | Compare the receipt and its date |
| Cheque not yet collected | Difference equal to the cheque amount | Verify the cheque's due date and status |
| Exchange rate or amount difference | Small, recurring difference | Check the exchange rate difference invoice |
| Wrong account | Difference equals another customer's amount | Move the record to the correct account |
For how to prepare a reconciliation letter and when to send it, see the article what is account reconciliation and how is it done. In NetKasam you can quickly create and share account statements for month-end reconciliation and send a reconciliation letter with one click; for the steps, see the question how do I reconcile accounts in NetKasam.
Lesson 8: How do you track supplier accounts and set up a weekly routine?
In short: A supplier account is the reverse of a customer account: a purchase invoice increases what you owe, a payment reduces it. Tracking the due date and any early payment discount protects your cash plan.
| Customer account | Supplier account |
|---|---|
| Sales invoice: balance goes up | Purchase invoice: debt goes up |
| Collection: balance goes down | Payment: debt goes down |
| Risky balance: collection is delayed | Risky balance: payment due date passes |
| Question asked: when will I collect? | Question asked: when do I need to pay? |
- ₺12,200account balance at the end of September
- ₺2,400reconciliation difference (unrecorded return)
- 42%share of receivables older than 30 days
- 41%Yıldız Market limit usage (12,200 ÷ 30,000)
| When? | What to do? | Who? |
|---|---|---|
| Every day | Post incoming collections and payments to the accounts | Accounting |
| Every week | List balances that are due and overdue, send reminders | Collections officer |
| Every week | Check accounts whose limit usage exceeds 90% | Sales manager |
| Month-end | Run the aging report, share statements, reconcile | Accounting |
| Every three months | Review customer limit and payment term conditions | Manager |
What are the most common mistakes in account tracking?
- Opening more than one account for the same customer. The balance is split and the total debt is not visible.
- Entering the opening balance incorrectly. All subsequent balances shift.
- Not posting the return invoice to the account. A difference shows up at reconciliation.
- Not matching collections to invoices. You cannot tell which invoice is closed, and aging breaks down.
- Not setting a limit. One large customer failing to pay affects all your cash.
- Reconciling once a year. The difference is found at year end, and the evidence is lost.
- Leaving reminders to individuals. Without a routine, collections are forgotten.
How does NetKasam make account tracking easier?
- One account, one statement. You manage customer and supplier accounts and quickly create and share statements (customer and supplier account tracking).
- Risk and discount settings. You classify customers and define separate limits and campaigns; when the risk level is reached, new sales are restricted automatically.
- Automatic reminders. Reminders are sent for payments that are approaching or past their due date; you can send balance reminders by bulk SMS.
- Month-end reconciliation. You speed up reconciliation by creating statements and sending a reconciliation letter with one click.
- Bulk import. You import your customers and suppliers into the system along with their balances; for moving from old software, see the question can I import my customers.
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
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.
- If the opening balance is ₺5,000, sales invoices are ₺20,000, collections are ₺12,000 and returns are ₺1,000, what is the customer account balance?
- If your balance is ₺8,000 and the other party's is ₺6,500, what is the reconciliation difference and what do you check first?
- If the risk limit is ₺40,000 and the balance is ₺38,000, what is the limit usage and what do you do?
- In a supplier account, is a purchase invoice a debit or a credit?
- Why is receivables aging more important than the total balance?
Answer key:
- 5,000 + 20,000 − 12,000 − 1,000 = ₺12,000 debit (the customer owes you).
- 8,000 − 6,500 = ₺1,500. First check whether there is an invoice, return or collection equal to this amount.
- 38,000 ÷ 40,000 = 95%; you stop new credit sales and wait for a collection.
- A credit. In a supplier account, a purchase invoice is recorded as a credit and a payment as a debit.
- The same balance is safe if it consists of fresh receivables; as it ages, the collection risk increases.
Frequently Asked Questions About Account Tracking
How do you track a current account?
A separate current account is opened for each customer and supplier, all invoices, collections and payments are posted to the account, the statement is read regularly, receivables are separated by age, a risk limit is set and at month end the account is reconciled with the counterparty.
What is an account statement?
It is a document that shows all debit and credit movements of an account in date order with a running balance. It is used to reconcile accounts with a customer or supplier.
How is the account balance calculated?
Debit movements are added to the opening balance and credit movements are subtracted. In a customer account, a positive balance shows that the customer owes you.
What is receivables aging?
It is the separation of receivables into ranges such as 0-30, 31-60, 61-90 and over 90 days according to the days elapsed since the invoice or due date. Older receivables carry a higher collection risk.
What is a risk limit?
It is the highest open balance you can extend to a customer on credit terms. Stopping new credit sales when the limit is reached limits receivables risk.
What do you do if a difference arises in account reconciliation?
The two statements are compared line by line. The difference is usually an invoice, return, collection or cheque not recorded on one side. Look for a transaction equal to the difference.
Can I share account statements in NetKasam?
Yes. You can quickly create account statements, share them with your customers and suppliers, and send a reconciliation letter with a single click at month end.
Does NetKasam send automatic reminders to customers?
Yes. It offers automatic reminders for payments that are approaching or past their due date; you can also send balance reminders by bulk SMS.
Conclusion: Read the statements of your top 5 customers this week
Account tracking may look complicated, but it rests on four habits: reading the statement line by line, aging receivables, setting limits and reconciling at month end. This week, open the statements of your five customers with the highest balances, verify the balance, look at the ages and write down the limit usage. The problematic ones are the customers you should talk to first.
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.