The Debtors screen is used to manage debtors. You can:

  • display customer balance information with various selection options and print the results
  • print a statement for a selected customer
  • do the end-of-period processing at the end of the accounting period
  • generate the statements at the end of the accounting period
  • re-print previously generated statements

For background information, see Concepts|Accounting. See also the note on statement detail at the bottom of this page.

How to summary:

  • for month (or accounting period) end processing
    • set the Statement Date to the end of the period (eg end of previous month)
    • press the End Period button to do the period end processing for all customers
    • press the Send All button to generate the statements for the selected customers
    • if you did select customers (say those with 60 days overdue balances so that you can include a payment request note in the envelope with their statement), then clear the selection conditions and press Send All again to process the other customers. The 60 day overdue customers' statements will not be reprinted (unless you use the reprint option).
    • Note that you do not have to generate statements for all customers. If say you have two customer account types, Normal and Staff, you could choose to only print statements each month for Normal customers and never for Staff.
  • for debtor management
    • set the Statement Date to the required date
    • enter the other selection criteria
    • press the Find button
    • optionally press the Report button
      for debtor management
  • for account enquiries (if a customer wants a current statement)
    • set the Statement Date to today
    • set the Customer From and To to minimise the number of customers selected (ie 'sm' to 'smz' if the customer is named Smith)
    • press the Find button
    • click the line containing the customer and press the Print button
    • Note that the resulting statement will only include finalised transactions prior to the statement date - ie it will not show today's finalised invoice.

This is a standard select screen. The selection fields are:
Customer Account Type - this allows you to select customers by their account type
Overdue From & To - use these to select overdue accounts. They are entered as the number of days after the statement date, ie 30 and 60 will select accounts that are between 30 and 60 days overdue. They are both optional. If you enter bad data, it is ignored. Hence:

From To Meaning
30   more that 30 days overdue
30 xxx same as above (bad To value ignored)
  60 up to 60 days overdue
xxx 60 same as above (bad From value ignored)

Customer From & To - this allows you to select customers by name. For this to work as expected you need to set both the From and To entries and the To value must be greater than the From.  If you get this wrong, eg search from 't' to 't', no error will be reported, you will just get 'No results to display'.
Statement Date - the date of the end of the accounting period. Normally this will be the last day in the previous month if you are doing end-of-period and statement printing. However, if you are doing debtors management, then this should be set to the current date so that you can see the current situation.
Balances - you can select All, Current or Overdue. 'Current' selects those customers who do not have an overdue balance, 'Overdue' just those who do have an overdue balance.
Exclude Credit - uncheck the box if you also want to include customers with credit balances. Note that irrespective of any of the selection settings, customers with zero balances are never displayed.

The column headings are:
Customer Name - these have been intentionally blurred in the above picture. Each is a link to the customer.
Balance - the balance of the account as at the Statement Date.  (If you think that the amounts shown above are high, it's because they are in Hong Kong dollars.)
Overdue Balance - the overdue balance, see below
Credit Balance - if the account is in credit the amount will be shown here (as well as in the Balance column)
Unbilled - the amount that is unbilled, ie the total of any in-progress, on-hold, or completed transactions
Last Payment Date & Amount - the date and amount of the last payment
Last Invoice Date - the date of the last invoice

The Buttons are:
Send All - generates the statements for the selected customers.  This will display a confirmation window - which will also allow you to request the reprint of statements of previously printed statements (which would otherwise not be reprinted).
Note that you normally use Send All only after you have used End Period, and you should keep the same Statement Date for both.
The statements generated will be emailed to the customer (rather than printed) if the customer has an email address with the purpose 'Billing'.
The document template used for the statements will be that with the type 'Customer Statement' - and this MUST have something present in the Email Body text (eg 'See attached statement') - see Administration|Templates.

Print - prints a statement for the currently selected customer

Report - prints a Debtors report for the accounts of the customers shown on the screen - ie only those customers who match the current selection criteria. Note that this report does not show the selection critera. The document template used for the Debtors report will be that with the type 'Customer Account Balance'.

End Period - initiates the end-of-period processing for all customers (not just those selected). A confirmation window will be displayed. It has a 'Finalise Completed Invoices' checkbox - you should normally leave this ticked. However, if your practice has a policy that all invoices should be manually finalised by the accounts department, then you should untick this. In this case the completed/not finalised ones will be held over and not included in the closing balance.
Note that you use End Period before you have used Send All, and you should keep the same Statement Date for both.


Overdue calculation
The overdue date, ie the date at which an account becomes overdue is calculated as:
   overdue date = statement date - customer's account type payment terms

If the customer doesn't have an account type, then the overdue date is the statement date.

A balance is overdue if it's unpaid or part paid, and has been so since prior to the overdue date.


Statement Detail
The standard statements generated by the system use a document template that is written so that whether or not the statement contains line item detail depends on whether or not the invoice (or credit note, etc) has been printed. If it has, no line item detail is displayed; if it has not been printed, then line item detail is show.

Syndicate content