More on sales and receivables
1 Introduction
This chapter looks in a little more detail at sales transactions and the receivables ledger
The accounting documents used are:
When sales are made, invoices will be issued to customers
Statements will be sent regularly to customers, setting out what is owed and what has been paid.
Remittance advices will be received from customers when they pay to explain which invoices are being settled.
2 Credit control
Credit control is the name given to the process of trying to ensure that cash is eventually received for all credit sales.
The process starts with a new customer applying for credit and this should initiate some investigation, such as:
Asking for the applicant’s recent financial statements.
Enquiries to a credit reference agency to see if the applicant has any history of poor payments.
Based on these investigations, the applicant will be accepted or rejected. A credit limit should be set for all customers.
Once credit sales have been made, each customer should be encouraged to pay according to the terms of the contract. There are three ways of proceeding:
Send statements. These often act as a gentle reminder about what’s due.
Settlement discounts. For example, pay 5% less if paid within 30 days.
Prepare aged receivables analyses and act accordingly on the information contained there.
3 Settlement discounts
For example, an invoice is issued to DFH Ltd for $700 on 2nd January 2013 with terms offering a settlement discount of 5% is settled within 30 days. The invoice was paid on 25th January 2013. Therefore, because it was paid on time the amount due will be $700 x 95% = $665.
The discount of $35 is an expense of the business. The customer has been ‘let off’ $35 for prompt payment.
The entries in the DFH’s account would be:
DFH Ltd | |||
2/1/2013 Invoice | 700 | 25/1/2013 Cash account | 665 |
Settlement discount | 35 | ||
700 | 700 | ||
The settlement discount is debited to the Discounts Allowed account in the general ledger. This is an expense account.
It is important to realise that the receivables total account should always reflect in total whatever happens the individual accounts. So, if a customer is given a settlement discount, this must also be credited to the total receivables account.
For example, consider a company with just three customers:
ABC Ltd | |||
Balance b/d | 700 | ||
DEF Ltd | |||
Balance b/d | 400 | ||
GHI Ltd | |||
Balance b/d | 200 | ||
Receivables control/total account | |||
B/f | 1,300 | ||
You will see that, the control account/total balance agrees with the sum of the individual balances in the receivables ledger ($1,300 = $700 + $400 + $200)
Each is entitled to a settlement discount of 5% if the amounts are paid within 30 days. ABC Ltd and DEF Ltd pay within this time limit; GHI does not and pays only $100 of what is owed.
After the receipts and the settlement discounts, those accounts are:
ABC Ltd | |||
Balance b/d | 700 | Cash | 665 |
Discount allowed | 35 | ||
700 | 700 | ||
DEF Ltd | |||
Balance b/d | 400 | Cash | 380 |
Discount allowed | 20 | ||
400 | 400 | ||
GHI Ltd | |||
Balance b/d | 200 | Cash | 100 |
Balance c/d | 100 | ||
200 | 200 | ||
Balance b/d | 100 | ||
Receivables control/total account | |||
B/f | 1,300 | Cash | 1,145 |
Discounts allowed | 55 | ||
Balance c/d | 100 | ||
1,300 | 1,300 | ||
Balance b/d | 100 | ||
Note that the sum of the individual balances (now GHI Ltd only, $100) still equals the balance on the total receivables account.
Note that a settlement discount is entirely different to a bulk or trade discount. The bulk or trade discount is to all intents and purposes a straight reduction in the selling price and the only amounts ever invoiced or treated as a sale are after the discount has been removed.
With a settlement discount, the sales and the invoices are for the full amount (after the trade discount) and the discount is contingent upon prompt payment.
4 Sales returns and credit notes
A credit note is not an adjustment to the invoice; it is a transaction of its own and it is posted like one. Take DFH Ltd again. The $700 invoice of 2 January is followed on 12 January by a credit note for $120 net plus $24 sales tax, because some of the goods were faulty.
The credit note is listed in the sales returns day book, and the day book's totals are posted:
Debit Sales returns account $120
Debit Sales tax account $24
Credit Receivables control account $144
and the gross $144 is credited to DFH Ltd's own account in the receivables ledger:
DFH Ltd | |||
2/1/2013 Invoice | 700.00 | 12/1/2013 Credit note 159 | 144.00 |
25/1/2013 Cash account | 528.20 | ||
Settlement discount | 27.80 | ||
700.00 | 700.00 | ||
The settlement discount is now 5% of the $556 actually owed, not of the original $700: 556 x 5% = $27.80, so the cash received is $528.20.
Note the three things a sales return always does: it reduces receivables, it reduces sales (through the sales returns account, so that gross sales and returns can both be seen), and it reverses the sales tax that was charged on the goods coming back.
4.1 Contra entries
Where the same business is both a customer and a supplier, the balance it owes you and the balance you owe it can be set against each other. That is a CONTRA ENTRY. If ABC Ltd owes you $1,400 and you owe ABC Ltd $1,600, the contra is put through by journal:
Debit Payables control account $1,400
Credit Receivables control account $1,400
and the same two entries are made in ABC Ltd's individual account in each memorandum ledger. $200 remains payable to ABC. The contra is always for the LOWER of the two balances — you cannot set off more than one side owes.
5 Aged receivables analysis
This looks at all the invoices still owed by customers and displays them in age categories.
Typically the age categories are something like:
≤ 30 days
30 to ≤ 60 days
60 to ≤ 90 days
90 to ≤ 180 days
> 180 days
Usually, the older an unpaid debt becomes, the less likely to be paid. Also, as debts become older more extreme action is likely to be taken to try to force payment. For example, final warnings, then taking customers to court.
The layout of an aged analysis is usually something along the lines of:
Customer | Total | ≤ 30 days | 30 to ≤ 60 days | 60 to ≤ 90 days | 90 to ≤ 180 days | > 180 days |
Aardvark | 1,200 | 1,100 | 100 | |||
Benson | 900 | 600 | 300 | |||
Chandos | 100 | 100 | ||||
Draghi | 600 | 500 | 100 | |||
Ephram | 500 | 100 | 200 | 200 | ||
Fahrook | 800 | 800 | ||||
: | : | : | : | : | : | : |
: | : | : | : | : | : | : |
Total | 94,560 | 85,382 | 5,993 | 2,085 | 800 | 300 |
% | 100.0 | 90.3 | 6.3 | 2.2 | 0.9 | 0.3 |
To be able to work out how old debts are, it is essential to know exactly which invoices have been paid. This is where remittance advices are important because they allow specific matching to be carried out.
For example, consider this customer’s account:
ABC Ltd | |||
Invoice 125 3/1/2013 | 700 | ||
Invoice 135 23/1/2013 | 1,000 | ||
Invoice 178 5/2/2013 | 500 | ||
Invoice 201 4/3/2013 | 2,300 | ||
Invoice 233 12/3/2013 | 950 | ||
Invoice 278 2/3/2013 | 620 | Bal c/d | 6,070 |
6,070 | 6,070 | ||
The customer sends a cheque for $3,800, and this is accompanied by a remittance advice as follows:
ABC Ltd | |
Invoices paid: | $ |
Invoice 135 23/1/2013 | 1,000 |
Invoice 178 5/2/2013 | 500 |
Invoice 201 4/3/2013 | 2,300 |
TOTAL REMITTANCE Cheque 585493 | 3,800 |
The payments set out on the remittance advice have to be matched as follows:
ABC Ltd | |||
Invoice 125 3/1/2013 | 700 | ||
Invoice 135 23/1/2013 | 1,000 | Invoice 135 31/3/2013 | 1,000 |
Invoice 178 5/2/2013 | 500 | Invoice 178 31/3/2013 | 500 |
Invoice 201 4/3/2013 | 2,300 | Invoice 201 31/3/2013 | 2,300 |
Invoice 233 12/3/2013 | 950 | ||
Invoice 278 2/3/2013 | 620 | Bal c/d | 2,270 |
6,070 | 6,070 | ||
The matched items can be cleared out of the account to leave:
ABC Ltd | |||
Invoice 125 3/1/2013 | 700 | ||
Invoice 233 12/3/2013 | 950 | ||
Invoice 278 2/3/2013 | 620 | Bal c/d 31/3/2013 | 2,270 |
2,270 | 2,270 | ||
A valid aged analysis can be performed on the outstanding amounts.
6 Irrecoverable (bad) debts
Sometimes, despite all efforts to sell only to credit-worthy customers and to follow up old amounts carefully, it becomes clear that a debt is irrecoverable and no money will ever be received. Perhaps the customer has gone into liquidation (or simply disappeared!)
There is then no point in continuing to record the debt as a receivable (an asset) when it is worthless: the amount should be written off, ie reduced to zero. This is an expense to the business and will be recorded in an irrecoverable debts account (sometimes called a bad debts account).
As always, whatever adjustment you make to an individual receivable you must make to the receivables control/total account too. Writing off bad debts is one use of the journal.
Look at this example:
Total receivables account (control account) | |||
Bal b/d 1/1/2013 | 9,700 | Total receipts | 102,500 |
Total sales | 105,000 | ||
Bal c/d 31/12/2013 | 12,200 | ||
114,700 | 114,700 | ||
One of the receivables accounts in the receivables ledger is:
Badone Ltd | |||
Bal b/d 1/1/2013 | 1,300 | ||
Sales 15/1/2013 | 2,500 | ||
Bal c/d 31/12/2013 | 3,800 | ||
3,800 | 3,800 | ||
It has been decided that none of the $3,800 due from Badone Ltd will be recovered and that this amount should be written off.
The journal to do this is:
Journal number 1411 | Dr | Cr |
Dr Irrecoverable debts account | 3,800 | |
Cr Receivables control/total account | 3,800 | |
Being the write-off of irrecoverable debts | 3,800 | 3,800 |
Authorised by | ||
The accounts would then be:
Total receivables account (control account) | |||
Bal b/d 1/1/2013 | 9,700 | Total receipts | 102,500 |
Total sales | 105,000 | Irrecoverable debts | 3,800 |
Bal c/d 31/12/2013 | 8,400 | ||
114,700 | 114,700 | ||
Bal b/d 31/12/2013 | 8,400 | ||
One of the receivables accounts in the receivables ledger is:
Badone Ltd | |||
Bal b/d 1/1/2013 | 1,300 | Written off | 3,800 |
Sales 15/1/2013 | 2,500 | ||
3,800 | 3,800 | ||
Irrecoverable debts | |||
Total receivables account | 3,800 | Bal c/d | 3,800 |
3,800 | 3,800 | ||
7 Irrecoverable (bad) debts and sales tax
Debts are not usually written off until all reasonable hope of recovery is gone and this usually takes time. Sales tax will probably have been charged on the sales giving rise to the debt, and will have been paid over to the government. Now it is clear that the sales tax will never be collected from the defaulting customer.
In many sales tax regimes the seller can eventually recover the tax on a debt that has been written off, but the conditions differ from country to country and FA1 does not examine any particular country's rules. What FA1 does expect you to be able to do is separate the tax content of a written-off debt from the net amount, because only the net amount is the real cost of the write-off.
So, if the $3,800 above contained sales tax at 20%, the sales tax content of that debt would be $3,800/6 = $633.33 and the net amount of the sale would be 3,166.67 (check: 3,166.67 x 20% = $633.33).
Therefore, the cost of the irrecoverable debt is reduced by the sales tax amount as follows:
Irrecoverable debts | |||
Total receivables account | 3,800.00 | Sales tax account | 633.33 |
Bal c/d | 3,166.67 | ||
3,800.00 | 3,800.00 | ||
The debit to the sales tax account will reduce what has to be paid to the government in the future, so gives tax relief on the irrecoverable sales tax.
8 Allowances for irrecoverable debts
Once a write-off occurs the debt is, in effect, forgotten about and will not be pursued. However, before that stage is reached it will often begin to look unlikely that the debt will be recovered, but the company does not yet want to give up all hope and does not want to write off the debt. Nevertheless, to value the debt at its full amount would be over-optimistic.
In this case, an allowance can be made to reduce the value of the receivables. The allowance can be calculated using a combination of approaches:
A specific debt is identified as ‘doubtful’. This will be a specific allowance for irrecoverable receivables.
Our experience might show that, say 4%, of debts generally have to be written off, though we do not know now which ones these will be. This might sometimes be known as a general allowance for irrecoverable receivables.
On 31 December 2013, the total receivables are $125,000.
Of these:
An amount of $6,000 is to be written off as it is clearly not recoverable.
An amount of $12,000 is thought to be in danger of not being recoverable and a 100% allowance is to be made for that.
4% of remaining receivables are to have an allowance.
What value of receivables will appear on the statement of financial position as at 31 December 2013?
Show answerHide answer
9 FA1 exam focus — Chapter 5
Common-error warning
Recognise sales and sales tax when the credit invoice is issued. A later receipt settles the gross receivable; it does not create sales tax again.
Examiner tip
Record an invoice after trade discount but before settlement discount. Only record the settlement discount when the customer meets the payment terms.
Status contrast
Irrecoverable debt: a specific balance is written off. Allowance: an estimate against balances not yet written off.
More on sales and receivables
10 questionsAnswer the questions one at a time. Your progress is saved so you can leave and come back.
Open chapter practice