(continued from Debtors Application)

Debtor Balances

The Balances Screen displays the outstanding debtor balances by the age of the balance. Display modes are available which will display:

In addition, balances as they were aged in prior periods can also be viewed. Once a currency has been selected, the Credit Limit amounts, Month to Date, Year to Date and Last Payment Amount fields are also shown (in the Analysis Section ) with those values in the selected currency displayed.

Screen Shot 20: Agent Balances Screen – Base Currency

When a debtor has multiple currencies attached, initial entry to this screen is the "Base Currency" display. The Base Currency is the final accounting currency of the system.

This screen is in 4 sections:

Agent Currencies Section

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

Prior Periods Section

This shows the current debtors accounting period at the bottom of the list, with all previously closed periods above it. To view the aging in prior periods, click the accounting period required.

Aged Balances Section

This section displays the balances by age.

The Base Currency balances as shown in Screen Shot 20 Agent Balances Screen – Base Currency are the total amount owed, for all currencies—i.e., the sum of all New Zealand Dollar and United States Dollar transactions.

The Aging 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 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 plus the Future Aged and Future Entered valuesin the selected currency.

Analysis Section

If the debtor has multiple currencies showing in the Supplier Currencies panel (), on entry to the balances screen, the 'Base Currency' values are displayed which are made up of the sum of transactions in all currencies attached to the debtor, expressed in base currency. The Analysis panel will not display until a currency other than Base Currency has been selected.

Month-to-Date

Total revenue for the agent in the selected currency for the current period month.

Year-to-Date

Total revenue for the agent in the selected currency for the current financial year.

Total Credit Limit

The value of any credit limit set against this currency under the Debtors Application .

Credit Remaining

The credit limit value remaining. This is calculated as Credit Limit minus Total Balance Due.

If a debtor does not have a credit limit set, the Credit Remaining field will display a negative amount as in Screen Shot 21 Agent Balances Screen – USD Currency.

Last Receipt Amount

The value of the last receipt posted in the selected currency.

Last Receipt Date

The date of the last receipt in the selected currency.

Screen Shot 21: Agent Balances Screen – USD Currency

Screen Shot 21 Agent Balances Screen – USD Currency is displaying balances in USD in the left hand column, and Base Currency (NZD) in the right hand column.

Note that there is only one accounting period (the current period) displayed in the Prior Periods panel. This is because the only USD transaction has been entered in this period.

Screen Shot 22: Agent Balances Screen – NZD Currency

(continued in Debtors Transactions)