3 REPORTS PRODUCED BY THE ACCOUNTING SYSTEM

3.1 INTRODUCTION

In addition to recording purchase invoices, input sales tax, discount received and returns outwards, computerised accounting systems will produce a range of documents and reports to assist managers and employees within a business, such as transactions listings, or individual payables' ledger accounts for specific suppliers if there is a query to be resolved.

Depending upon how large or complex an organisation is, the purchase of goods or services is normally initiated by a purchase requisition. This is a request for goods or services to be ordered when a business need has been identified. Upon approval of the requisition, a supplier can be selected based upon appropriate criteria (cost, delivery date etc.) and a purchase order raised and issued to that supplier.

FA1: RECORDING FINANCIAL TRANSACTIONS

Upon receipt of the goods or services, they will be checked to confirm they are complete and in good condition and the progress of the purchase order can be updated. Receipt of the invoice from the supplier will enable the general ledger purchases and trade payables' accounts to be updated. Simultaneously, the memorandum information of the individual credit supplier account will be updated, along with the aged payables' analysis (see 3.2 below) and other management reports (see 3.3 below).

The cycle will be completed in due course when payment is made for the goods and services received. This will be evidenced by a detailed listing of bank payments which is used to update the general ledger accounts and the memorandum management information.

3.2 AGED PAYABLES' ANALYSIS

In exactly the same way as customer balances can be analysed in terms of their age, so too can suppliers' balances. We refer in this case to an aged payables analysis.

An aged payables analysis is a report showing amounts owed to credit suppliers, analysed in terms of the number of days each amount has been outstanding.

An aged debt analysis relating to credit customers is an important tool of management control. By referring to amounts overdue, managers can initiate appropriate action to chase slow payers. This is obviously not an important consideration in the reverse situation (money owed to credit suppliers) and as a result, most businesses make less use of their payables analysis than of their receivables analysis.

Despite this, there are good reasons why managers should pay attention to the aged payables analysis. One reason is the need to maintain good relationships with trusted suppliers. If an organisation is consistently late in paying its debts, suppliers may retaliate by reducing the level of customer service, withdrawing favourable trading terms, or, in the last resort, refusing to make further supplies. To avoid this issue, it makes sense to monitor suppliers' balances to ensure that debts due are paid in good time.

It is also a good idea for a business to monitor amounts owed to ensure that settlement discounts are claimed and not missed.

An aged payables' analysis is prepared exactly the same way as the aged receivables' analysis. The layout of the report, also, is the same as we have already seen in the aged receivables' analysis. The only difference, obviously, is that the starting point is the ledger accounts for credit suppliers rather than credit customers. In addition the time periods used may be shorter, to indicate time periods within which payments must be made if discount received on early settlement of amounts due is to be earned.

An analysis is typically presented as follows. In this example, there are just three credit suppliers, but in reality there could be any number of them.

PAYABLES CHAPTER 12
Aged payables analysis as at (date)Total due $Outstanding for
Credit supplierLess than 10 days $10-30 days $30-60 days $More than 60 days $
Box Co3,557.22950.002,468.19139.03
Carton Co2,963.451,778.07830.00355.38
Crate Co1,418.47129.50748.30216.27324.40
Total7,939.141,079.504,994.561,185.30679.78

Notes

  1. Although the columns are headed 'Less than 10 days', '10-30 days' and so on. it is common practice to assume that there are 30 days in a month, so less than 30 days means less than one calendar month and 30-60 days really means between one and two months,
  2. For each supplier, the total due in the 'Outstanding for columns add up to the total amount currently owed to each supplier, as shown in the Total due column.
  3. It is usual to show total figures at the end of the report, because these provide useful information for management.

3.3 OTHER REPORTS

Other reports produced by a computerised accounting system relating to payables include:

  • purchase requisitions record, including progress towards order placement
  • purchase orders record, including progress towards completion, which may be in several stages if there are multiple deliveries of goods, or if damaged goods are returned
  • a transaction listing e.g. purchase invoices processed in a particular week or on a specific date or a list of bank payments made to individual credit suppliers
  • a payable ledger account extract or summary for an individual credit supplier which may be used to reconciled with statements issued by the supplier to confirm that the payable ledger account balance is fairly stated
  • a summary of the results of a 'search enquiry' eg a list of all invoices processed with a net cost of $2,500 or a list of all payable ledger account balances in excess of $7.500 as at a specific date.
FA1: RECORDING FINANCIAL TRANSACTIONS

ACTIVITY 1

1 XZ Co purchased goods at a cost of $450, including sales tax of 20%. What accounting entries should XZ Co make to record this transaction in the general ledger?

A

Debit: Purchases $450
Credit: Payables $540
Debit: Sales tax $90

B

Debit: Purchases $375
Debit: Sales tax $75
Credit: Purchases $375
Debit: Payables $450
Credit: Sales tax $75

C

Debit: Purchases $375
Debit: Sales tax $75
Credit: Payables $450

D

Debit: Payables $375
Credit: Purchases $450
Debit: Sales tax $75

2 PR Co purchased goods at a cost of $450, on which sales tax at 20% was added. PR Co was offered settlement discount of 5% if payment was made within 10 days of the invoice date, PR Co made the payment within 10 days.
What accounting entries should PR Co make to record this payment?

A

Debit: Payables $450
Debit: Sales tax $90
Credit: Bank $540

B

Debit: Payables $450
Credit: Bank $540
Debit: Sales tax $90

C

Debit: Payables $540
Credit: Bank $513
Credit: Discount received $27

D

Debit: Bank $513
Credit: Payables $540
Debit: Discount received $27

3 GH Co purchased goods at a net cost of $680, on which sales tax at 15% was added. GH Co was offered settlement discount of 5% if payment was made within 10 days of the invoice date. GH Co made the payment within 10 days. What accounting entries should GH Co make to record this payment?

A

Debit: Payables $646 Debit: Discount received $34
Credit: Bank $680

B

Debit: Bank $742.90 Discount received $39.10
Credit: Payables $782.00

C

Debit: Payables $782.00
Credit: Bank $646
Credit: Sales tax $102
Credit: Discount received $34

D

Debit: Payables $782.00
Credit: Bank $742.90
Credit: Discount received $39.10

For a suggested answer, see the 'Answers' section at the end of the book.