Customer and supplier accounts: tracking receivables, payables and cash

Tracking customer and supplier accounts in bookkeeping means recording every receivable and payable against a document, following its due date, closing it with collections and payments, and agreeing balances with the other party at regular intervals. Well-kept accounts show at a glance who owes you what, whom you owe and how much cash will come in over the coming weeks. This article covers the basic steps for building that order.

What is a customer or supplier account, and why track it separately?

An account of this kind records a business's receivable and payable relationship with a particular person or organisation. Every invoice issued to a customer creates a receivable on the account, every invoice received from a supplier creates a payable, and collections and payments close them. The account balance is a snapshot of the relationship between the two parties at that moment.

A bank balance or a cash count shows where the business stands today; customer and supplier accounts show tomorrow. A business can look profitable and still run short of cash because its sales have not yet been collected. That is why account tracking is not just the recording side of bookkeeping but the decision-making side of management.

For tracking to work, each counterparty should have exactly one account card. Two cards for the same customer, opened under slightly different spellings, split the balance and send reminders to the wrong place. Validating the tax or ID number with a checksum is the simplest way to prevent duplicate and faulty cards.

How do you record receivables and payables correctly?

Every movement on an account should be backed by a document: a sales or purchase invoice, a return invoice, a collection receipt, a bank slip or a netting entry. An undocumented balance adjustment may make life easier in the short term, but it turns into an unexplained difference during reconciliation.

Corrections must be documented too. Cancelling an entry with a reversal rather than deleting it shows that history has not been rewritten and makes it easy to explain why the balance changed. The same principle applies to netting when a customer is also a supplier: mutual receivables and payables should be closed with a separate, traceable entry.

• Give every account card a type, a tax or ID number, contact details and a default payment term.
• Post each invoice to the account as soon as it is issued and state the due date on the document.
• Record collections and payments showing which invoice each one settles.
• Correct entries with a reversal instead of deleting them, and note the reason.
• For foreign-currency documents, record the exchange rate used and any FX difference separately.

The payables side needs as much care as the receivables side. Recording supplier invoices on the day they arrive, keeping payment due dates visible and clearly marking which invoice has been paid prevents both problems caused by late payment and mistakes such as paying the same invoice twice. What keeps a supplier relationship healthy is being able to pay on the promised date.

Why does due-date tracking matter?

When a receivable should be collected matters as much as its amount. A receivable without a due date is a receivable nobody follows; when the customer pays late, no one can see how late or what it costs the business. That is why every invoice should carry a due date, and that date should be visible on the account.

The aging report is the most useful tool for due-date tracking. It sorts open receivables into buckets by due date: not yet due, recently overdue and long unpaid. Seeing how much each customer owes in each bucket helps you set collection priorities and spot risky customers early.

Cheques and promissory notes add another dimension. A cheque's maturity in the portfolio, its deposit for collection, its endorsement to a third party or its bouncing all affect the account directly. Tracking the life cycle of cheques and notes alongside the account, and seeing their due dates on a calendar, means fewer surprises in cash planning.

Assigning customers a risk level strengthens due-date tracking as well. For a customer with irregular payment habits, shorter terms or payment in advance on new sales keep open receivables from growing out of control.

How do you organise the collection process?

Collection is the moment a sale is truly complete. Payments can arrive by bank transfer, card, cash, cheque or promissory note; whatever the channel, each collection should be linked to the right account and, where possible, to the invoice it settles. With partial payments, it should be clear how much of which invoice has been closed.

Keying in bank movements one by one is slow and error-prone. Importing the bank statement and matching each movement to the right account speeds up collection records. Movements whose counterparty cannot be identified from the description should be held in a queue of pending matches, not booked to an account by guesswork.

• Send customers a short, polite reminder for invoices that are nearly due.
• Prioritise overdue receivables using the aging report.
• Note every collection call and any payment promise on the account card.
• After a collection, send the customer a statement showing the updated balance.
• Decide in advance what steps to take for receivables that stay unpaid for a long time.

It should also be clear who is responsible for collection. If the person who made the sale and the person who follows up payment are different, any payment terms or special conditions promised to the customer must be written on the account card. Otherwise the collections officer ends up calling a customer without knowing what the sales team agreed.

Profit shows in the ledger; cash shows in how well you follow your accounts.

How is account reconciliation done?

Reconciliation means both parties confirming that the balance in their own records is the same. The business sends the other party a statement as of a given date; the other party either confirms the balance or reports a difference with its reason. It can be done once a year, but doing it more often with high-volume customers and suppliers catches differences before they grow.

Most reconciliation differences come from a handful of familiar causes: an invoice one side has not yet recorded, a payment in transit, a currency transaction recorded at a different rate or a movement booked twice. Matching the difference document by document gets you to the right balance and stops the same mistakes from recurring.

Running reconciliation through email attachments and phone calls makes it hard to track who confirmed what. A set-up in which the other party can view the statement through a secure link and confirm or dispute it also keeps a record of the reconciliation history.

• Set the reconciliation date and make sure every document up to that date has been recorded.
• Send the other party a statement that includes the list of movements.
• Record the confirmation or dispute together with its date.
• Match disputed differences one by one against the supporting documents.
• Correct any wrong entries with a reversal and repeat the reconciliation.

How do you get visibility over cash flow?

Cash flow visibility comes from bringing receivables and payables with due dates, cheque and note maturities and regular expenses together on one calendar. That picture shows on which days in the coming weeks you will have surplus cash and on which you will fall short.

• Place upcoming receivables on the calendar, taking each customer's payment habits into account.
• Show supplier payment dates on the same calendar.
• Add the maturities of cheques in your portfolio and cheques you have issued.
• Enter regular expenses such as rent, salaries and taxes with their dates.
• Compare the forecast with actual figures every week and update it.

This visibility puts decisions on calmer ground. Knowing in advance which collection a supplier payment should follow, which month a new investment should move to, or which customer could be offered an early-payment discount reduces the need for last-minute fixes.

A cash forecast is only as reliable as the account records behind it. Invoices issued but not recorded, unmatched bank movements or out-of-date cheque statuses all distort it. That is why a short weekly check routine is worth far more than a big monthly clean-up.

Frequently asked questions

Is account tracking the same as bookkeeping entries?

No. Account tracking is the part of bookkeeping that follows entries counterparty by counterparty. In a double-entry ledger every account movement is also an accounting entry, but account tracking lets you read those entries from the customer's and the supplier's point of view.

How often should accounts be reconciled?

At least at the end of each period. With high-volume customers and suppliers, monthly or quarterly reconciliation catches differences before they grow.

What is an aging report for?

An aging report sorts open receivables into buckets by due date and shows how long each customer has gone without paying. It is the most practical way to set collection priorities and spot risky customers early.

How are foreign-currency accounts tracked?

Foreign-currency documents are recorded in Turkish lira at the rate on the document date; when the collection or payment happens at a different rate, the FX difference is posted separately. Consult your accountant on which rate to use and on the tax consequences of FX differences.

Can a small business track accounts in a spreadsheet?

For a business with very few customers it can work at first. Once due dates, partial payments, cheques and reconciliation come into play, spreadsheets quickly become error-prone, and moving to document-based bookkeeping software saves time.

Good account tracking is a habit

Account tracking is not a big project but a habit that takes a few minutes a day: recording documents on time, linking collections to the right invoices, following due dates and reconciling regularly with the other party. Once the habit is in place, cash flow becomes predictable and management decisions rest on numbers. In Bir Finans, which we use in our own operations at Bir Web Ajans, account statements, aging reports and a reconciliation page that clients can confirm or dispute all draw on the same double-entry ledger.