How to reconcile the Debtors and Creditors Control Accounts

Summary

The Debtors and Creditors Control Accounts are two of the most important accounts on the nominal ledger, as they represent money owed to you by your customers and money owed by you to your suppliers. Therefore, most companies reconcile these accounts on a monthly or yearly basis.

Resolution

TIP: For information about the aged debtors and aged creditors reports available in Sage Accounts, please refer to this guide.

How the Debtors and Creditors Control Accounts are updated
Debtors Control Account
Transaction typeEffect on control account
SIThe total value including VAT is automatically debited to this account, increasing the balance.
SR or SAThe total value is automatically credited to this account, decreasing the balance.
SCThe total value, including VAT, is automatically credited to this account, decreasing the balance.
SDThe total value is automatically credited to this account, decreasing the balance.
SPThe total value, including VAT, is automatically debited to this account, increasing the balance.


Therefore, the balance on the Debtors Control Account, is the total amount that your customers currently owe you and should always agree with the total balance outstanding on your Customers ledger.

Creditors Control Account
Transaction typeEffect on control account
PIThe total value including VAT, is automatically credited to this account, increasing the balance.
PP or PAThe total value is automatically debited to this account, decreasing the balance.
PCThe total value including VAT, is automatically debited to this account, decreasing the balance.
PDThe total value is automatically credited to this account, decreasing the balance.
PRThe total value including VAT is automatically credited to this account, increasing the balance.


Therefore, the balance on the Creditors Control Account, is the total amount that you currently owe your suppliers and should always agree with the total balance outstanding on your Suppliers ledger.

Reconcile the Debtors Control Account on a monthly basis

NOTE: Before running any of the customers reports mentioned in this article, you should ensure that there's no searches applied. For further information about this, please refer to this guide.

You can follow this process at the end of any period dictated by your business, for example, you may only need to do this at the end of a year. If you want to reconcile the Debtors Control Account on a yearly basis, you should run this procedure but check the annual trial balance figures and run the day book reports for the financial year, rather than a month.

EXAMPLE: In this example, all transactions for the month of May have been posted, you're reconciling the Debtors Control Account for May, and the previously reconciled month was April.

  1. Check the following balances:
    • Last month's Debtors Control Account balance - To find or check this figure, you should print out the trial balance report for the previously reconciled month, for example, print the trial balance report for April.
      • Nominal ledger > Trial balance.
    • The monthly movement on the Debtors Control Account - To find or check this figure you should print the Trial Balance report for the month you're reconciling, then deduct the Debtors Control Account balance for the previous month, from the Debtors Control Account balance on this Trial Balance report. For example, deduct the April Debtors Control Account balance from the May Debtors Control Account balance.
    • The totals on each of the customer day books reports for the month you're reconciling. To do this, run each of the following day book reports, using the date range for the month you're reconciling:
      ReportReport location
      Day Books: Customer Invoices (Summary)Customers > Reports > Day books.
      Day Books: Customer Credits (Summary)Customers > Reports > Day books.
      Day Books: Customer Discounts (Summary)Customers > Reports > Day books.
      Day Books: Customer Receipts (Summary)Bank accounts > Reports > Customer receipts and payments.
      Customer RefundsCustomers > Reports > Customer activity.
  2. To check the monthly movement on the Debtors Control Account, use the following formula:


    		Day Books: Customer Invoices - Total Gross Amount
    MinusDay Books: Customer Credits - Total Gross Amount
    MinusDay Books: Customer Receipts - Total Gross Amount
    MinusDay Books: Customer Discounts - Total Gross Amount
    PlusCustomer Refunds - Total Gross Amount


    This balance should then equal the monthly movement on the Debtors Control Account.

  3. To reconcile the Debtors Control Account with the Customers ledger use this formula:


    		The previous months balance on the Debtors Control Account from the Trial Balance report
    PlusDay Books: Customer Invoices - Total Gross Amount
    MinusDay Books: Customer Credits - Total Gross Amount
    MinusDay Books: Customer Receipts - Total Gross Amount
    MinusDay Books: Customer Discounts - Total Gross Amount
    PlusCustomer Refunds - Total Gross Amount

    This balance should equal the balance of the Debtors Control Account at the end of the month you're reconciling. For example, the balance on the Debtors Control Account from the May Trial Balance report.

If the above values don't agree, please refer to this guide.

Check the Debtors Control Account balance matches the Aged Debtors balance at month end

NOTE: To check that the Debtors Control Account balance matches the Aged Debtors balance at the year end, you should run this procedure using the annual Trial Balance report figures and running the Aged Debtors Analysis report to the end of the financial year, rather than to the end of the month.

  1. Check the Debtors Control Account balance at the month end, by running the Trial Balance report for the required month.
    • Nominal ledger > Trial balance.
  2. Print or preview the Aged Debtors Analysis (Detailed) report from, Customers > Reports > Aged debtors.

    When running this report, you should ensure that you use a transaction date range from 01/01/1980 to the end of the month being reconciled and select the Exc Later Payments check box.

    NOTE: When running this report, you should ensure that there's not a searches applied to the Customers module.

    Make a note of the balance from the Grand Totals line of the report.

  3. Compare the Debtors Control Account balance to the balance from the Aged Debtors Analysis (Detailed) report. They should be the same.

    If there's a difference between the two balances, check the Debtors Control Account activity for any transactions that aren't customer transactions, for example, journals. Any journals posted to the Debtors Control Account don't affect the Customers ledger and therefore cause a discrepancy between the two balances. If these journals are incorrect you should reverse them and then repost them correctly.

If there are no journal entries on the Debtors Control Account, please refer to this guide.

Reconcile the Creditors Control Account on a monthly basis

NOTE: Before running any of the suppliers reports mentioned in this article, you should ensure that there's no searches applied. For further information about this, please refer to this guide.

You can follow this process at the end of any period dictated by your business, for example, you may only need to do this at the end of a year. If you want to reconcile the Creditors Control Account on a yearly basis, you should run this procedure but check the annual trial balance figures and run the day book reports for the financial year, rather than a month.

EXAMPLE: In this example, all transactions for the month of May have been posted, you're reconciling the Creditors Control Account for May, and the previously reconciled month was April.

  1. Check the following balances:
    • Last month's Creditors Control Account balance - To find or check this figure, you should print out the Trial Balance report for the previously reconciled month, for example, print the trial balance report for April.
    • The monthly movement on the Creditors Control Account - To find or check this figure you should print the Trial Balance report for the month you're reconciling, then deduct the Creditors Control Account balance for the previous month, from the Creditors Control Account balance on this Trial Balance report. For example, deduct the April Creditors Control Account balance from the May Creditors Control Account balance.
    • The totals on each of the supplier day books reports for the month you're reconciling. To do this, run each of the following day book reports, using the date range for the month you're reconciling:
      ReportReport location
      Day Books: Supplier Invoices (Summary)Suppliers > Reports > Day books.
      Day Books: Supplier Credits (Summary)Suppliers > Reports > Day books.
      Day Books: Supplier Discounts (Summary)Suppliers > Reports > Day books.
      Day Books: Supplier Payments (Summary)Bank accounts > Reports > Supplier payments and receipts.
      Supplier RefundsSuppliers > Reports > Supplier activity.
  2. To check the monthly movement on the Creditors Control Account, use the following formula:


    		Day Books: Supplier Invoices - Total Gross Amount
    MinusDay Books: Supplier Credits - Total Gross Amount
    MinusDay Books: Supplier Payments - Total Gross Amount
    MinusDay Books: Supplier Discounts - Total Gross Amount
    PlusSupplier Refunds - Total Gross Amount


    This balance should then equal the monthly movement on the Creditors Control Account.

  3. To reconcile the Creditors Control Account with the Suppliers ledger use this formula:


    		The previous months balance on the Creditors Control Account from the Trial Balance report
    PlusDay Books: Supplier Invoices - Total Gross Amount
    MinusDay Books: Supplier Credits - Total Gross Amount
    MinusDay Books: Supplier Payments - Total Gross Amount
    MinusDay Books: Supplier Discounts - Total Gross Amount
    PlusSupplier Refunds - Total Gross Amount

    This balance should equal the balance of the Creditors Control Account at the end of the month you're reconciling. For example, the balance on the Creditors Control Account from the May Trial Balance report.

If the above values don't agree, please refer to this guide.

Check the creditors Control Account balance matches the Aged creditors balance at month end

NOTE: To check that the creditors Control Account balance matches the Aged creditors balance at the year end, you should run this procedure using the annual Trial Balance report figures and running the Aged creditors Analysis report to the end of the financial year, rather than to the end of the month.

  1. Check the Creditors Control Account balance at the month end, by running the Trial Balance report for the required month.
    • Nominal ledger > Trial balance.
  2. Print or preview the Aged Creditors Analysis (Detailed) report from, Suppliers > Reports > Aged creditors.

    When running this report, you should ensure that you use a transaction date range from 01/01/1980 to the end of the month being reconciled and select the Exc Later Payments check box.

    NOTE: When running this report, you should ensure that there's not a searches applied to the suppliers module. 


    Make a note of the balance from the Grand Totals line of the report.

  3. Compare the Creditors Control Account balance to the balance from the Aged Creditors Analysis (Detailed) report. They should be the same.

    If there's a difference between the two balances, check the Creditors Control Account activity for any transactions that aren't supplier transactions, for example, journals. Any journals posted to the Creditors Control Account don't affect the suppliers ledger and therefore cause a discrepancy between the two balances. If these journals are incorrect you should reverse them and then repost them correctly.

If there are no journal entries on the Creditors Control Account, please refer to this guide.


Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.

Leave your details

Image

Solution Properties

Solution ID
200427112155930
Last Modified Date
Wed Mar 23 14:23:50 UTC 2022
Attributes
Product Details
Modules: Customers
Modules: Suppliers
Modules: Contact Management
Views
0