Creditors reconciliation enquiry

Use the Creditors Reconciliation Enquiry to help you 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.

For more information on how to investigate any differences, see Investigate differences between ledgers.

The enquiry only works with open item purchase ledger accounts.

Before you can run this enquiry you must have set up the default nominal account for the enquiry in the Nominal Ledger.

You must:

  • Select the debtor and creditor control nominal accounts you want to see in the report in the Reconciliation Enquiry Settings.

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

Supplier workspaces and enquiries

Other tasks

Supplier reports

Reference

Default nominal accounts