Open topic with navigation

> Suppliers / Supplier workspaces and enquiries / Creditors reconciliation enquiry

Creditors reconciliation enquiry

About the creditors reconciliation enquiry

Use the Creditors Reconciliation Enquiry to reconcile your purchase ledger accounts with the nominal ledger. The reconciliation enquiry shows any discrepancies between the creditor's control nominal account opening balance (plus net change for the period) and the closing balance.

Where there are discrepancies we suggest you check any opening balance invoices against the opening balance on the Creditors Control nominal account. You should also check for any journals posted to the Creditors Control nominal account.

See Investigate differences between ledgers for more information on how to investigate any differences.

The enquiry only works with open item purchase ledger accounts.

Note: You can only reconcile transactions entered in Sage 200 v4.0 or later versions. If you have migrated transactions from earlier versions, these transactions are not included in the reconciliation enquiries.

Before you begin

You must:

To use the creditors reconciliation enquiry

Open: Purchase Ledger > Purchase Enquiries > Creditors Reconciliation Enquiry.

  1. Select an accounting period and click Display to display the reconciliation information for the period.

    2. Creditors Opening Balance

    This shows the balance on the creditor's control nominal account at the start of the period.

    Select this to show in the Drilldown Details the value for each account nominated as a creditor's control account.

    Invoices, Credit Notes, Payments and Receipts

    These show the total of the original base currency value of all purchase ledger transactions that are posted to the nominal ledger for the selected accounting period.

    Select the transaction type to show in the Drilldown Details the value of each transaction.

    Opening Balances

    This shows the total net value of opening balances dated in the selected period is shown.

    Opening balances do not update the Nominal Ledger and so do not carry an accounting period. However, opening balances are included on the aged credit reports.

    The incorrect use of opening balances can cause discrepancies, so these details are shown to help you identify possible problems with this.

    Currency Adjustments

    Currency adjustment transactions that update the Nominal Ledger in the accounting period are shown.

    Select the line to show in the Drilldown Details the value of each currency adjustment transaction.

    Net Change

    The value of net change for the accounting period is shown.

    Creditors Closing Balance

    This shows the balance on the creditor's control nominal account at the end of the period.

    Select this to show in the Drilldown Details the value for each account nominated as a creditor's control account.

    Discrepancy

    Any discrepancy between the creditor's control nominal account opening balance (plus net change for the period) and the closing balance is shown here.
  2. When you have finished viewing the details, click Close.
See also

What do you want to do?

Reconciliation enquiry settings

Investigate differences between ledgers

Overview

Reconciling sales and purchase with nominal ledger

Other tasks

Supplier reports

Reference

Default nominal accounts

 

Go to top