Administer Account Recievable
Administer Account Recievable
Administer Account Recievable
Level III
Learning Guide
JULY, 2024
Administer, Monitor and Control General and Subsidiary Ledgers
This module covers the performance outcomes, skills and knowledge required to reconcile and
monitor financial accounts receivable systems, identify bad and doubtful debts and plan à
recovery action and remit payments to sundry creditors.
At the end of the module the trainee will be able to:
LO1. Review accounts receivable process
LO2. Identify bad and doubtful debts
LO3. Review compliance with terms and conditions and plan recovery action
LO4. Prepare reports and file documentation
LO5. Distribute creditor’s invoices for authorization
LO6. Remit payments to creditors
LO7. Prepare accounts paid report and reconcile balances outstanding
LO8. Collect and record monies due
Imagine that a business has several thousand charge (credit) customers and shows the
transactions with these customers in only one general ledger account - Accounts Receivable.
To determine the balance owed by an individual customer at any specific time. Similarly, the
amount payable to one creditor would be difficult to locate quickly from single Account Payable
account in the general ledger. Companies use subsidiary ledgers to keep track of individual
balances.
A subsidiary ledger is a group of accounts with a common characteristic (for example, all
accounts receivable). The subsidiary ledger frees the general ledger from the details of individual
balances. A subsidiary ledger is an addition to, and an expansion of, the general ledger.
Two common subsidiary ledgers are:
1. The accounts receivable (or customers’) subsidiary ledger, which collects transaction data of
individual customers.
2. The accounts payable (or creditors’) subsidiary ledger, which collects transaction data of
individual creditors.
Receivables (often referred to as loans and receivables) are claims held against customers and
others for money, goods, or services. The term receivables includes all money claims against
other entities, including people, companies, and other organizations. The receivables that results
from sales on account are normally accounts receivable or notes receivable. Notes and accounts
receivable that result from sales transactions are sometimes called trade receivables
Accounts receivable are oral promises of the purchaser to pay for goods and services sold. They
represent “open accounts” resulting from short-term extensions of credit. A company normally
collects them within 30 to 60 days. Notes receivable are written promises to pay a certain sum
of money on a specified future date. They may arise from sales, financing, or other transactions.
UNIT ONE
Review Accounts Receivable Process
Accounts Receivable
The most common transaction creating a receivable is selling merchandise or services on
account (on credit). The receivable is recorded as a debit to Accounts Receivable. Such
accounts receivable are normally expected to collect within a short period, such as 30 or 60 days.
A major issue of selling merchandise or services on account (on credit) is that some customers
will not pay their accounts. That is, some accounts receivable will be uncollectible. Companies
may shift the risk of uncollectible receivables to other companies by not accepting sales on
account.
1. The direct write-off method records bad debt expense only when an account is determined to
be worthless. The direct write-off method is often used by small companies and companies
with few receivables.
2. The allowance method records bad debt expense by estimating uncollectible accounts at the
end of the accounting period.
IFRS or GAAP require companies with a large amount of receivables to use the allowance
method.
There are two methods of accounting to consider when accounting for receivables. They are:
Under the accrual basis of accounting (which we will be using throughout our discussion) a sale
on credit will:
1. Increase sales or sales revenues, which are reported on the income statement, and
2. Increase the amount due from customers, which is reported as accounts receivable—an asset
reported on the balance sheet.
If a buyer does not pay the amount it owes, the seller will report:
1. A credit loss or bad debts expense on its income statement, and
2. A reduction of accounts receivable on its balance sheet.
The seller should report its estimated credit losses as soon as possible using the allowance
method. For income tax purposes, however, losses are reported at a later date through the use of
the direct write-off method.
To determine the customers that have already paid and identify any payments those are overdue.
The process is a simple turn of events that make the Receivables traceable and manageable.
2. Invoicing Customers
An invoice is a document provided to the buyer detailing the products and services that have been
rendered, the costs of those products and services, as well as the date payment is expected.
Each invoice has to have a unique invoice number for easy retrieval. The customer is then given
the chance to choose whether they want to receive electronic or physical invoices. Large firms
prefer to send both the electronic and paper invoices.
The officer also reconciles the AR ledger that the payments are accounted for and properly
posted, and then issues monthly statements to clients. The statement provides details for the
customers about the amounts owed as per previously sent invoices.
The tracking process differs in large and small companies. Small companies, a manual process,
companies use spreadsheets to record when they send the invoices, and when they receive
payments.
Larger companies typically invest in a team of AR Officers to conduct the tracking process, and
they use some form of an accounts tracking software system to help ensure accuracy. The system
helps the AR Officer to be more effective, because it automatically alerts the AR Officer to which
debt is outstanding.
Your accounts receivable are essential components to your financial statements. This means to
record and account for them correctly in your accounts receivable process. To do this, to make
sure you document your accounts receivable through your invoices which should describe the
goods or services you have provided the customer, the amount that is owed to you, and when that
amount needs to be paid
In principle, the seller should record the sales transaction when the ownership of the goods is
transferred to the buyer. Practically speaking, however, accountants typically record the
transaction at the time the sales invoice is prepared and the goods are shipped.
FOB Shipping Point means the ownership of the goods is transferred to the buyer at the seller's
dock. This means that the buyer is responsible for transporting the goods from Quality Product's
shipping dock. Therefore, all shipping costs (as well as any damage that might be incurred during
transit) are the responsibility of the buyer.
FOB Destination
FOB Destination means the ownership of the goods is transferred at the buyer's dock. This means
the seller is responsible for transporting the goods to the customer's dock, and will factor in the
cost of shipping when it sets its price for the goods.
Let's assume that Gem Co. makes a sale to a customer that has a sales value of $1,050 and a cost
of goods sold at $800. This transaction affects the following accounts in Gem's general ledger.
Because Gem chooses to ship its goods FOB Destination, the ownership of the goods transfers at
the buyer's. Therefore, Gem Merchandise assumes all the risks and costs associated with
transporting the goods.
Assume that Gem pays an independent shipping company $50 to transport the goods from its
warehouse to the buyer's dock. Gem records the $50 as an operating expense or selling expense
(in an account such as Delivery Expense, Freight-Out Expense, or Transportation-Out Expense).
The credit term of 2/10, net 30 work. Gem Merchandise Co. ships $1,000 of goods and the
customer returns $100 of unacceptable goods to Gem within a few days. At that point, the net
amount owed by the customer is $900. If the customer pays Gem within 10 days of the invoice
date, the customer is allowed to deduct $18 (2% of $900) from the net purchase of $900.
In other words, the $900 amount can be settled for $882 if it is paid within the 10-day discount
period.
A subsidiary ledger is a group of accounts with a common characteristic (for example, all
accounts receivable). The subsidiary ledger the details of individual balances. A subsidiary ledger
is an addition to, and an expansion of, the general ledger.
In each of these subsidiary ledgers, individual accounts are usually arranged in alphabetical order.
The detailed data from a subsidiary ledger are summarized in a general ledger account.
For example, the detailed data from the accounts receivable subsidiary ledger are summarized in
Accounts Receivable in the general ledger.
A subsidiary ledger contains the details to support a general ledger control account. For instance,
the subsidiary ledger for accounts receivable contains all of the information on each of the credit
sales to customers, each customer's remittance (a payment to a remote recipient), return of
merchandise, discounts, and so on.
By having the details a subsidiary ledger, a company can better control its financial information.
For example, the credit manager and others in the credit department of a company will have
access to any and all of the credit sales information through the subsidiary ledger without having
access to any other account in the company's general ledger.
The general ledger account that summarizes subsidiary ledger data is called a control account.
The general ledger control accounts and subsidiary ledger accounts are shown in
A subsidiary ledger contains the details to support a general ledger control account
The general ledger account that summarizes subsidiary ledger data is called a control
account.
A special journal is used to record similar types of transactions. Examples would be all sales of
merchandise on account, or all cash receipts. The special journal a company uses depends largely
on the types of transactions that occur frequently.
Figure
General Ledger
Subsidiary Ledger
Creditor X Creditor Y
Customer A Customer C
Customer B Creditor Z
Sales Journal
The sales journal is used to record sales of merchandise on account.
Cash sales of merchandise are entered in the cash receipts journal. Credit sales of assets other
than cash sales.
An example of a control account and subsidiary ledger for XYZ WHOLESALE SUPPLY is
provided in Illustration.
WHOLESALE SUPPLY
Sales Journal SJ1
Date Account Invoic P.R Accts. Receivable Cost of Goods Sold Dr.
debited e no. Dr. Merchandise Inventory Cr.
Sales Cr.
May 2020 -3 Abbot Sisters 101 SJ1 10,600 6,360
7 Babson Co 102 SJ1 11,350 7,370
14 Carson Bros. 103 SJ1 7,800 5,070
19 Deli Co 104 SJ1 9,300 6,510
21 Abbot Sisters 105 SJ1 15,400 10,780
24 Deli Co 106 SJ1 21,210 15,900
27 Babson Co. 107 SJ1 14,570 10,200
90,230 62,190
Babson Co
Date P.R Debit Credit Balance
May 2010 3 S1 11,350 11,350
27 S1 14,570 25,920
Carson Bros.
Date P.R Debit Credit Balance
May 2010 14 S1 7,800 7,800
Deli Co
Date P.R Debit Credit Balance
May 2010 19 S1 9,300 9,300
24 21,210 30,510
GENERAL LEDGER
Accounts Receivable Account No.12
Date P.R Debit Credit Balance
May 2010 31 90,230 90,230
GENERAL LEDGER
Merchandise inventory Account No
Date P.R Debit Credit Balance
May 2010 31 62,190 62,190
GENERAL LEDGER
SALES Account No. 41
Date P.R Debit Credit Balance
May 2010 31 90,230 90,230
GENERAL LEDGER
Cost Of Goods Sold Account No.
Date P.R Debit Credit Balance
May 2010 31 62,190 62,190
The entry at cost is a debit to Cost of Goods Sold and a credit of equal amount to Merchandise
Inventory (a control account).
General ledger
Accounts Receivable $90,230
Sales revenue $90,230
(To record sales on account)
All receipts of cash are recorded in the cash receipts journal. The most common types of cash
receipts are cash sales of merchandise and collections of accounts receivable. Many other
possibilities exist, such as receipt of money from bank loans and cash proceeds from disposal of
equipment. A one- or two- column cash receipts journal would not have space enough for all
possible cash receipt transactions.
The entries in the cash receipts journal are based on the following cash receipts.
Purchases Journal
All purchases of merchandise on account are recorded in the purchases journal. Each entry in this
journal results in a debit to Merchandise Inventory and a credit to Accounts Payable.
The procedures for journalizing transactions in this journal are similar to those described earlier
for the cash receipts journal. Each transaction is entered on one line, and for each line there must
be equal debit and credit amounts.
The entries in the cash payments journal in Illustration E-15 are based on the following
transactions for XYZ Wholesale Supply.
May 1 Check No. 101 for $1,200 issued for the annual premium on a fire insurance policy.
3 Check No. 102 for $100 issued in payment of freight when terms FOB shipping point.
8 Check No. 103 for $4,400 issued for the purchase of merchandise.
10 Check No. 104 for $10,780 sent to Jasper Manufacturing Inc. in payment of May 6
invoice for $11,000 less a 2% discount.
19 Check No. 105 for $6,984 mailed to Eaton and Howe Inc. in payment of May 10
invoice for $7,200 less a 3% discount.
23 Check No. 106 for $6,831 sent to Fabor and Son in payment of May 14 invoice for
$6,900 less a 1% discount.
28 Check No. 107 for $17,150 sent to Jasper Manufacturing Inc. in payment of May 19
invoice for $17,500 less a 2% discount.
30 Check No. 108 for $500 issued to stockholders as a cash dividend.
XYZ Wholesale Supply
Cash Payment Journal
Date Amount debited Check P.R Other Acc. Payable Merchandise. Cash
no. account Dr. Dr. Inventory Cr Cr.
May 2010 Prepaid Insurance 101 14 1200 1200
1
3 Mdse. Inventory 102 13 100 100
8 Mdse. Inventory 103 13 4400 4400
10 Jasper Manuf. Inc 104 11000 220 10780
19 Eaton & Howe 105 7200 216 6984
23 Fabor and Son 106 6900 69 6831
28 Jasper Manuf. Inc 107 17500 350 17150
30 Dividends 108 500 500
6200 42600 855 47,945
General Ledger
Cash Account No: 11
Date P.R Debit Credit Balance
May 2010 31 CPJ1 53,769 53769
CPJ1 47945 5,824
GENERAL LEDGER
Merchandise inventory Account No: 13
Date P.R Debit Credit Balance
May 2010 31 Cp1 100 100
31 Cp1 4,400 4,500
31 S1 62,190 (57,690)
31 Cp1 2,930 (60,620)
31 P1 63,900 3,280
31 Cp1 855 2,425
GENERAL LEDGER
Prepaid insurance Account No: 14
Date P.R Debit Credit Balance
May 2010 31 Cp1 1200 1200
GENERAL LEDGER
Account payable Account No: 21
Date P.R Debit Credit Balance
May 2010 31 Cp1 63,900
31 Cp1 42,600 21,300
GENERAL LEDGER
Dividend Account No: 32
Date P.R Debit Credit Balance
May 2010 31 Cp1 500 500