Recording Sales Credit Customers and Customer Advances

Track what was sold, what was paid and what each customer still owes without counting a sale twice.

Part 4 of 10 | Bookkeeping for Small Businesses

Learning goals

You will maintain a sales list and individual customer balances, apply part payments and distinguish customer advances from completed sales. You will use invoice references to follow up unpaid amounts without exposing customer information.

Before you begin

Allow about an hour. Use Customer A and Customer B rather than real names or phone numbers. The examples use a simplified management approach that records a sale when goods are delivered or the service is completed. Obtain advice on the accounting and tax treatment appropriate to your actual contracts.

Record the sale once

A useful sales record contains date, sales reference, customer label, description, amount and payment arrangement. Add delivery or completion evidence and any related order reference. Cash sales and credit sales both belong in the sales record when the assumed sale event occurs. Their payment timing is different.

Keep the sales list separate from the cashbook's money-in total. The cashbook can include loan receipts, owner contributions and collections of earlier invoices. Conversely, today's sales can include amounts not yet received. Using the cashbook total as the sales figure without reviewing its composition can overstate or understate trading activity.

Follow a customer balance

Suppose Customer A receives goods worth GMD 900 under Invoice A and pays GMD 300 immediately. Record sales of GMD 900, cash received of GMD 300 and an unpaid balance of GMD 600. The customer's account connects all three facts to the same invoice. It should not show a GMD 900 debt after ignoring the deposit made at delivery.

When Customer A pays a further GMD 400, record that receipt in the cashbook and apply it to Invoice A. The remaining balance becomes GMD 200. Do not record another GMD 400 sale. The later payment changes the amount owed, not the value of the goods already supplied.

Track due dates and disagreements

Record the agreed due date and payment terms at the start. Review outstanding invoices regularly, grouping those not yet due, recently overdue and overdue for longer. This is an internal follow-up tool, not a legal collection deadline. Check payments and credits before asking a customer to pay again.

If a customer disputes an amount, record the reason and supporting evidence while the issue is investigated. Do not silently delete the sale or conceal the dispute. For a return or agreed price reduction, use an appropriate credit or adjustment record linked to the original invoice. Ask for advice where the required tax document or recognition treatment is uncertain.

Handle advances and cancellations

Customer B pays GMD 500 toward a repair that has not yet been done. Record the money received and label it customer advance for Order B. In this simplified example, there is not yet a completed service sale. The business has an obligation relating to the order, so the receipt is not automatically money the owner can treat as profit.

Suppose the repair is later completed at an agreed price of GMD 800. Record the GMD 800 sale, apply the GMD 500 advance and show GMD 300 still due. When that balance is paid, enter the GMD 300 receipt without creating another sale. If the order is cancelled instead, record the actual agreement and any refund; do not assume every deposit has the same refund terms.

Review without making collection promises

Make reminders factual: identify the invoice, amount outstanding and agreed date, then ask whether payment or a query is pending. Use a private channel. A screenshot supplied by the customer should be matched to your own payment record before updating the balance. If it relates to a different invoice, resolve the allocation rather than applying it twice.

An old unpaid amount is not automatically collectible, and age alone does not dictate its accounting write-off or tax treatment. Keep it visible for review and seek advice about any provision or adjustment needed. Record agreed changes and who authorised them. A reliable customer list shows uncertainty instead of pretending every balance will certainly become cash.

Guided exercise

1. Create a sales list and separate customer-account pages. Enter Invoice A for GMD 900 and the first GMD 300 payment.

2. Apply the later GMD 400 receipt. Write the remaining balance and explain why cumulative sales are still GMD 900.

3. Record Customer B's GMD 500 advance before work, then the GMD 800 completed service and the GMD 300 final collection.

4. Prepare a private reminder for Customer A using only the invoice label and outstanding amount. Do not threaten or invent late fees.

5. Mark a fictional dispute as under review and identify the order, delivery evidence and payment records you would inspect.

Knowledge check

1. How much does Customer A still owe after both receipts?

2. Is Customer B's pre-completion advance immediately a completed service sale in this example?

3. What are the combined sales from the two completed transactions?

Answer guide

1. GMD 200, calculated as 900 minus 300 minus 400.

2. No. It is tracked as an advance until the relevant service is completed under the stated assumptions.

3. GMD 1,700: Invoice A of GMD 900 plus Order B's completed service of GMD 800.

Completion standard

Produce accurate customer balances, correctly apply the advance and keep sales separate from collections. Your reminder and dispute note must be factual, private and linked to the original transaction.

Sources and verification notes

Original bookkeeping explanations and fictional worked examples. Simplified management records do not establish statutory accounts or tax treatment.