Creditor Balances

The Creditor Balances screen is accessed via menu Creditors > Accounting > Balances. Values on this screen show the outstanding creditor balances by the age of the balance.

Display modes are available which will display:

  • Outstanding Balances by Currency
  • Outstanding Balance Total in base currency

In addition, balances as they were aged in prior periods can also be viewed. Once a currency has been selected, the Month-to-Date, Year-to-Date and Last Cheque Amounts are also displayed.

Creditor Balances Screen

When a creditor has multiple currencies attached, those currency descriptions plus a base currency description display. For multi-currency creditors, on initial entry to this screen the base currency value displays. The base currency is the final accounting currency of the system. The amounts in base currency which display are the sum of all amounts in any other currencies which are attached to the creditor. Where only one currency is attached, and that currency is the same as the base currency, then only the one currency displays.

About the Creditor Balances Screen

This screen comprises four sections:

Currency Section

This section lists the currencies which are attached to the supplier. Clicking on a currency name will display the balances in that currency.

Period Section

This shows the current creditors accounting period at the top of the list, with all previously closed periods below it. To view the ageing in prior periods, click the accounting period required.

Aged Balances Section

This section displays the balances by age.

The Base Currency balances are the total amount owed, in all currencies in the Base Currency of the system.

The Ageing is broken down into seven periods:

  • Overdue 4+: The total value of all transactions in the selected currency whose age periods are 4 periods or more older than the current accounting period.
  • Overdue 3: The total value of all transactions in the selected currency whose age periods are 3 periods older than the current accounting period.
  • Overdue 2: The total value of all transactions in the selected currency whose age periods are 2 periods older than the current accounting period.
  • Overdue 1: The total value of all transactions in the selected currency whose age periods are 1 period older than the current accounting period.
  • Current: The total value of all transactions in the selected currency whose age periods are the same as the current accounting period.
  • Total Due: The total in the selected currency of Overdue 4+ through to Current Period fields.
  • Future Aged: The total value of all transactions in the selected currency whose age periods are in advance of the current accounting period.
  • Future Entered: The total value of all transactions in the selected currency whose transaction date is in advance of the current period ending date.
  • Total: The Total Due value, including the Future Aged and Future Entered values in the selected currency.

Analysis Section

The Analysis panel will not display until a currency other than Base Currency has been selected.

The Analysis section is broken down into four sections:

  • Month-to-Date: Total value of payments to the creditor in the selected currency for the current month.
  • Year-to-Date: Total value of payments to the creditor in the selected currency for the current financial year.
  • Last Cheque: The value of the last cheque in the selected currency.
  • Last Cheque Date: The date of the last cheque in the selected currency.