Skip to contentSkip to search

More on sales and receivables

1 Introduction

This chapter looks in a little more detail at sales transactions and the receivables ledger

2 Recap of the receivables ledger system

Entries in the receivables ledger arise from two main sources:

  • The sales day book (SDB), where new credit sales are first recorded.

  • The cash book(CB) where receipts from credit customers are first recorded (in the receivables ledger column, on the debit side)

Additionally there will be occasional postings made from:

  • The journal (eg the offset of debts to an account in the payables ledger)

The entries made from the sales day book will be:

  • Dr   Receivables control account with the total of the SDB gross amount column

  • Cr   Sales Account with the total of the SDB net amount column

  • Cr   Sales Tax Account with the total of the SDB sales tax amount column.

In addition, each line in the gross column of the SDB will be used to Debit individual accounts in the Receivables Ledger so as to record exactly who owes what.

The entries made from the cash book will be:

  • Cr   Receivables control account with the total of the Receivables Ledger column

In addition, each line in the Receivables column of the Cash Book will be used to Credit individual accounts in the Receivables Ledger so as to record exactly who has paid.

The accounting documents used are:

  1. When sales are made, invoices will be issued to customers

  2. Statements will be sent regularly to customers, setting out what is owed and what has been paid.

  3. Remittance advices will be received from customers when they pay to explain which invoices are being settled.

3 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.

4 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% if 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 DFH Ltd’s account would be:

DFH Ltd

2/1/2013 Sales day book

700

25/1/2013 Cash book

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.

Occasionally there is a memorandum settlement discount column in the cash book so that, in the case above, $665 would be the amount of cash received and $35 would be entered in the memorandum column. The sum of the memorandum discount column would be debited to the Discounts Allowed account.

It is important to realise that the receivables control 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 control account.

For example, consider a company with just three customers:

ABC Ltd

Sales day book

700

DEF Ltd

Sales day book

400

GHI Ltd

Sales day book

200

Receivables control account

B/f

1,300

You will see that, the control account 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.

A cash book extract would be:

Cash book (Dr side)

Narrative

Total

Discount

Receivables
ledger

Other….

ABC Ltd

665

35

665

DEF Ltd

380

20

380

GHI Ltd

100

-

100

1,145

55

1,145

Posting the cash book:

  • Discount column total ($55): Dr Discounts allowed account $55, Cr Receivables control account $55.

  • Receivables ledger column total ($1,145): Cr Receivables control account $1,145.

  • Each customer's line (the ringed discount and receivables ledger amounts): post to the individual accounts in the receivables ledger.

ABC Ltd

Sales day book

700

Cash

665

Discount

35

700

700

DEF Ltd

Sales day book

400

Cash

380

Discount

20

400

400

GHI Ltd

Sales day book

200

Cash

100

Bal c/d

100

200

200

Bal b/d

100

Receivables control account

B/f

1,300

Cash

1145

Discounts allowed

55

Bal c/d

100

1,300

1300

Note that the sum of the individual balances (now GHI Ltd only) still equals the balance on the control 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.

5 Discounts received

Everything above is the seller's side. Now look at the same transaction from the buyer's side. When the business is the customer and takes a settlement discount for paying a supplier early, the discount is a discount received. It is income, not an expense: the business has been let off part of what it owed.

The account is the Discounts Received account in the general ledger, and the posting is the mirror image of discounts allowed:

Discounts allowed (the business is the seller)

Discounts received (the business is the buyer)

Nature

An expense

Income

Posting

Dr Discounts allowed, Cr Receivables control account

Dr Payables control account, Cr Discounts received

Memorandum ledger

Cr the individual customer's account

Dr the individual supplier's account

Statement of profit or loss

Deducted with the other expenses

Added as other income, or deducted from purchases

Illustration. On 3 May the business receives an invoice from PQR Ltd for $2,000 offering a 4% discount for settlement within 20 days. It pays on 19 May.

The business pays $2,000 x 96% = $1,920 and is let off $80. PQR Ltd's account in the payables ledger is:

PQR Ltd

19/5 Cash book

1,920

3/5 Purchases day book

2,000

19/5 Discount received

80

2,000

2,000

and in the general ledger Dr Payables control account $80, Cr Discounts received $80 - so the control account still agrees with the sum of the individual balances, exactly as it must when a discount is allowed.

As with a settlement discount allowed, a trade or bulk discount received is different: it is simply a reduction in the purchase price. The invoice is for the net amount and that net amount is what is debited to Purchases. It never reaches a Discounts received account.

Practice question

A customer’s invoice and payment details are as follows:

Invoice dateInvoice amount
5 May 2013$1,200
8 May 2013$400
12 May 2013$500
25 May 2013$1,000

All the invoices offered a 2.5% discount for payment at or before 30 days and all were settled by a payment on 9 June 2013.

How much should the payment be for and how much is the discount?

Practice question

The normal price of a purchase is $800, but a customer has negotiated a trade discount of 20%. The invoice is dated 16 June 2013 and offers a 5% discount for payment within 45 days. Payment is received on 25 July 2013. What amounts should be posted to the Sales account and to the Discount Allowed account in the general ledger? (Ignore sales tax)

6 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

7 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 debtor you must make to the receivables control 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 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

8 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.

Where the tax authorities allow it, the seller can reclaim the sales tax that was charged on a debt which has been written off. FA2 examines a generic sales tax, so assume the relief is available unless you are told otherwise.

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.

9 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.

  • Historical experience might suggest 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.

The allowance will be a credit balance in an Allowance for Irrecoverable Debts Account and is netted off against the receivables amount in the statement of financial position. Setting up the allowance is an expense because the allowance reduces the value of an asset. The expense is debited to the Irrecoverable Debts Expense Account and hence to the statement of profit or loss.

The adjustment is made by journal, in the same form as the write-off journal above. To create an allowance, or to increase one:

Journal number 1478

Dr

Cr

Dr Irrecoverable debts expense account

X

Cr Allowance for irrecoverable debts account

X

Being the increase in the allowance for irrecoverable debts

X

X

To reduce an allowance, reverse it: Dr Allowance for irrecoverable debts, Cr Irrecoverable debts expense - the credit reduces the expense in the statement of profit or loss, and can even turn it into income if the reduction is bigger than the debts written off in the year.

Note what is journalled: only the MOVEMENT in the allowance, never the whole closing allowance. Work out the allowance you need at the year end, compare it with the balance brought down, and journal the difference.

On 31 December 2013, the total receivables are $125,000.

Of these:

  1. An amount of $6,000 is to be written off as it is clearly not recoverable.

  2. 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.

  3. 4% of remaining receivables are to have an allowance.

Show the Receivables Control Account, the Allowance for Irrecoverable Debts Account, and the Irrecoverable Debts Expense Account and the value of receivables that will appear on the statement of financial position as at 31 December 2013

Show answerHide answer

Example 1

Working

$

Initial amount of receivables

125,000

Written off

(6,000)

119,000

Allowances   – specific

12,000

    – general 4% x (119,000 – 12,000)

4,280

(16,280)

102,720

Receivables Control Account

Balance b/d

125,000

Irrecoverable debts expense (written off)

6,000

Balance carried down

119,000

125,000

125,000

Balance brought down

119,000

Allowance for Irrecoverable Debts Account

Balance carried down

16,280

Allowance for irrecoverable debts – debit to the Allowance for Irrecoverable debts expense account

16,280

16,280

16,280

Balance brought down

16,280

Irrecoverable Debts Expense Account

Debts written off

6,000

Allowance for irrecoverable debts

16,280

To statement of profit or loss at period end [an expense]

22,280

22,280

22,280

On the statement of financial position, receivables will be shown as $102,720, the figure after any write-offs and after netting-off the allowance. The allowance is not disclosed separately.

Say that at the end of the next period of account, receivables are $140,000. Of this, an amount of $10,000 is to be written off, there is to be a specific allowance for irrecoverable debts of $15,000 and a general allowance for irrecoverable debts of 5%.

Any change in the Allowance for Irrecoverable Debts Account is posted to the Irrecoverable Debts Expense Account.

Show the Total Receivables Account, the Allowance for Irrecoverable Debts Account and the Irrecoverable Debts Expense Account.

Total receivables account

Balance b/d

140,000

Allowance for Irrecoverable Debts Account

Balance b/d

16,280

Irrecoverable Debts Expense Account

Show answerHide answer

Example 2

Total receivables account

Balance b/d

140,000

Irrecoverable Debts Expense Account

10,000

Balance carried down

130,000

140,000

140,000

Working: after the write-off, the total allowance needed is: $15,000 + ($140,000 – 10,000 – 15,000) x 5% = $20,750

Allowance for Irrecoverable Debts Account

Balance brought down

16,280

Balance carried down

20,750

Amount needed to increase the allowance – DR the expense account

4,470

20,750

20,750

Balance brought down

20,750

Irrecoverable Debts Expense Account

Written off

10,000

Increase in allowance

4,470

To statement of profit or loss [an expense]

14,470

14,470

14,470

Practice question

At the start of a period a customer owed $12,345 and sales for the year were $11,346. During the year the customer paid $10,463 and was allowed discounts of $228.

It is thought wise to make an allowance against irrecoverable debts in respect of this customer of 25%.

How much will the allowance against irrecoverable debts be?

Practice question

What does an aged receivables analysis show?

Practice question

A debt of $34,615 has been written off. Sales tax is 15%. What is the final cost of the write-off and how much sales tax can be recovered in respect to the write-off?

Practice question

The brought forward balance on the Allowance for Irrecoverable Debts Account is $12,000. In the period debts amounting to $5,000 are written off. At the end of the period the balance on the Allowance for Irrecoverable Debts Account is to be $14,000. What is the amount taken to the statement of profit or loss in respect of irrecoverable debts?

Practice question

The brought forward balance on the Allowance for Irrecoverable Debts Account is $10,000. In the period debts amounting to $4,000 are written off. In the period the total amount debited to the statement of profit or loss in respect of irrecoverable debts is $2,500. What is the carried forward balance on the Allowance for Irrecoverable Debts Account?

Practice questions

Sales and Receivables: Discounts, Irrecoverable Debts and Allowances

10 questions

Answer the questions one at a time. Your progress is saved so you can leave and come back.

Open chapter practice