Examples of Preparing Reconciliation Statements
In this section, we will provide you with examples of how to prepare reconciliation statements. These examples will help you understand the process and improve your skills in preparing reconciliation statements.
Example 1: Schedule of Trade Receivables
Let’s assume you are working for a company that sells products to various customers on credit. The following table shows the details of the sales made during a specific period:
| Customer | Sales | Discount | Amount Receivable |
| Customer A | £1,000 | £100 | £900 |
| Customer B | £2,500 | £250 | £2,250 |
| Customer C | £3,500 | £350 | £3,150 |
To prepare the schedule of trade receivables, you need to list all the customers, their respective sales, discounts, and the amount receivable. The total of the amount receivable column will give you the total trade receivables for the period.
Example 2: Schedule of Trade Payables
Now, let’s consider the example of a company that purchases goods from various suppliers on credit. The following table shows the details of the purchases made during a specific period:
| Supplier | Purchases | Discount | Amount Payable |
| Supplier A | £2,000 | £200 | £1,800 |
| Supplier B | £3,500 | £350 | £3,150 |
| Supplier C | £4,500 | £450 | £4,050 |
To prepare the schedule of trade payables, you need to list all the suppliers, their respective purchases, discounts, and the amount payable. The total of the amount payable column will give you the total trade payables for the period.
Example 3: Revised Control Account
After preparing the schedules of trade receivables and payables, you need to update the control account. The control account summarizes the balances of individual customer and supplier accounts. The following table shows a simplified example of a revised control account:
| Account | Debit | Credit | Balance |
| Trade Receivables | £6,000 | £0 | £6,000 |
| Trade Payables | £0 | £5,000 | (£5,000) |
| Net Receivables/Payables | £6,000 | £5,000 | £1,000 |
The revised control account reflects the updated balances of the trade receivables and payables. The net receivables/payables column shows the difference between the two, which represents the overall financial position of the company.
Example 4: Reconciliation Statement
Finally, you need to prepare a reconciliation statement to ensure that the revised control account balances agree with the balances in the individual customer and supplier accounts. The following table shows a sample reconciliation statement:
| Account | Balance as per Control Account | Balance as per Individual Accounts | Reconciliation |
| Trade Receivables | £6,000 | £6,000 | Agree |
| Trade Payables | (£5,000) | (£5,000) | Agree |
The reconciliation statement confirms that the balances in the control account match the balances in the individual customer and supplier accounts, ensuring the accuracy of the financial records.
By practicing these examples and understanding the process of preparing reconciliation statements, you will be able to report on the outcome of control accounts accurately and effectively.
Schedule of Trade Receivables
In the previous section, we discussed the importance of reconciliation statements and how to prepare them. In this section, we will focus specifically on the schedule of trade receivables and its significance in the reconciliation process.
The schedule of trade receivables is a document that provides a detailed breakdown of all the outstanding amounts owed to a business by its customers. It is an essential tool for monitoring and managing the company’s accounts receivable.