EN
Bookkeeping

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
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is a current account and why is a separate one kept for each customer?
  3. Lesson 2: How do you read an account statement?
  4. Lesson 3: How is the account balance calculated?
  5. Lesson 4: What is receivables aging and how is it done?
  6. Lesson 5: How do you set a risk limit for a customer?
  7. Lesson 6: How do you manage balance reminders and collections?
  8. Lesson 7: How do you find and close a reconciliation difference?
  9. Lesson 8: How do you track supplier accounts and set up a weekly routine?
  10. What are the most common mistakes in tracking customer and supplier accounts?
  11. How does NetKasam make account tracking easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Read the statements of your top 5 customers this week
  14. 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.

Course mapThe six steps of account tracking
  1. 01
    RecordOpen a single current account for each customer and supplier and enter the opening balance.
  2. 02
    StatementRead the statement line by line and verify the balance.
  3. 03
    AgeSeparate receivables into day ranges.
  4. 04
    LimitSet a risk limit and payment terms for each customer.
  5. 05
    ReminderSend reminders for balances approaching or past due.
  6. 06
    ReconciliationMatch 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 typeDebited byCredited byMeaning of a positive balance
Customer accountSales invoiceCollection, sales returnThe customer owes you
Supplier accountPayment, purchase returnPurchase invoiceYou 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).

DateDocumentDebitCreditBalance
01.09Opening balance12.000 ₺-₺12,000 debit
05.09Sales invoice F-10118.000 ₺-₺30,000 debit
12.09Collection (bank transfer)-15.000 ₺₺15,000 debit
18.09Sales invoice F-1029.600 ₺-₺24,600 debit
20.09Return invoice (partial F-101)-2.400 ₺₺22,200 debit
28.09Collection (cheque)-10.000 ₺₺12,200 debit
Total39.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 Software

Lesson 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).

FormulaFive formulas of account tracking
  1. Account balance = Opening balance + Total debits − Total credits
  2. Risk limit usage = Account balance ÷ Risk limit
  3. Days to collect = Receivables ÷ Daily sales
  4. Overdue rate = Overdue receivables ÷ Total receivables
  5. 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.

ChartYıldız Market's September balance: from ₺12,000 opening to ₺12,200 closing
  1. Opening balance₺12,000
  2. Sales invoice F-101₺18,000
  3. Sales invoice F-102₺9,600
  4. Bank transfer collection−₺15,000
  5. Return invoice−₺2,400
  6. Cheque collection−₺10,000
  7. 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.

ChartAge distribution of the sample business's ₺100,000 in receivables
  • 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 rangeAmountShareWhat to do?
0-30 days58.000 ₺%58Normal follow-up; remind those approaching their due date
31-60 days24.000 ₺%24Send a reminder and follow up by phone
61-90 days12.000 ₺%12Consider stopping new sales and set up a payment plan
Over 90 days6.000 ₺%6Evaluate 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.

  1. Classify your customers: Separate cash-paying, credit-term, new and risky customer groups.
  2. Set the limit: The customer's monthly purchase volume, payment history and your own cash strength are the criteria for the limit.
  3. Write down the terms: Along with the limit, decide how many days of payment terms you give.
  4. Monitor usage: Check the balance ÷ limit ratio every week.
  5. Stop when the limit is reached: Do not make new credit sales until a collection comes in.
ChartRisk limit usage of five customers: a customer above 90 percent should be closed to new credit sales
  1. Akın Tekstil92%
  2. Su Elektrik78%
  3. Demir Gıda55%
  4. Yıldız Market41%
  5. 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.

TimingActionTone
3-5 days before the due dateBalance and due date reminderInformative
Due dateStatement sharing and payment detailsPolite
7 days after the due dateSecond reminder, phone callClear
30 days after the due dateWritten notice, new credit sales stoppedFormal

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 differenceSignSolution
Invoice not entered on one sideDifference equals the invoice amountSend the invoice so the other party records it
Return or discount not enteredDifference equals the return amount (as in the example)Forward the return invoice
Collection not entered or entered on a different dateDifference equals the collection amountCompare the receipt and its date
Cheque not yet collectedDifference equal to the cheque amountVerify the cheque's due date and status
Exchange rate or amount differenceSmall, recurring differenceCheck the exchange rate difference invoice
Wrong accountDifference equals another customer's amountMove 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 accountSupplier account
Sales invoice: balance goes upPurchase invoice: debt goes up
Collection: balance goes downPayment: debt goes down
Risky balance: collection is delayedRisky balance: payment due date passes
Question asked: when will I collect?Question asked: when do I need to pay?
Takeaways from the exampleFour numbers from the sample tracking
  • ₺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 dayPost incoming collections and payments to the accountsAccounting
Every weekList balances that are due and overdue, send remindersCollections officer
Every weekCheck accounts whose limit usage exceeds 90%Sales manager
Month-endRun the aging report, share statements, reconcileAccounting
Every three monthsReview customer limit and payment term conditionsManager

What are the most common mistakes in account tracking?

  1. Opening more than one account for the same customer. The balance is split and the total debt is not visible.
  2. Entering the opening balance incorrectly. All subsequent balances shift.
  3. Not posting the return invoice to the account. A difference shows up at reconciliation.
  4. Not matching collections to invoices. You cannot tell which invoice is closed, and aging breaks down.
  5. Not setting a limit. One large customer failing to pay affects all your cash.
  6. Reconciling once a year. The difference is found at year end, and the evidence is lost.
  7. 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.

  1. 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?
  2. 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?
  3. If the risk limit is ₺40,000 and the balance is ₺38,000, what is the limit usage and what do you do?
  4. In a supplier account, is a purchase invoice a debit or a credit?
  5. Why is receivables aging more important than the total balance?

Answer key:

  1. 5,000 + 20,000 − 12,000 − 1,000 = ₺12,000 debit (the customer owes you).
  2. 8,000 − 6,500 = ₺1,500. First check whether there is an invoice, return or collection equal to this amount.
  3. 38,000 ÷ 40,000 = 95%; you stop new credit sales and wait for a collection.
  4. A credit. In a supplier account, a purchase invoice is recorded as a credit and a payment as a debit.
  5. 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.

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