MYOB Greentree

HideShow

  • Contents
  • Index
  • Search
 
Display results with all search words

 

Statement Report


This report prints customer statements. The report opened from this menu uses the default statement form selected on the Accounts Receivable Module Control form.

The statement prints this information:

Header Details

  • Company name
  • Company address
  • Company phone
  • Customer code
  • Customer name
  • Customer address
  • Period end date
  • Currency

Note: The statement address selected in Accounts Receivable Module Control determines the address that prints on the statement header.

Line Details

The details displayed on the statement include:

  • Opening balance
  • One line for each transaction that occurred during the period, up to the period end date specified. This information displays:
    • The transaction type.
    • The reference of the transaction.
    • The transaction date and value.

A closing balance and the statement message (if you entered one in the report parameters) display at the bottom of the statement.

The statement is designed to print on pre-printed stationery, and includes a remittance section that the customer can separate from the statement to send back to you with their payment.

Outstanding amounts are separated into the overdue period to which they apply, and display at the base of the statement form. If the option to Print overdue messages on statements is selected for the customer, these messages prints on the statement. These messages are set up on the Overdue Interest Code Maintenance form.

Select the report Profile to determine the sort order you want the statements to print out in:

  • Customer code
  • Branch/Customer code
  • Customer name
  • Branch/Customer name
  • Salesperson/Customer code
  • Salesperson/Customer name
  • Currency/Customer code
  • Currency/Customer name
  • Calendar/Customer code
  • Calendar/Customer name
  • Parameters

Parameters

You can set these parameters for the report:

Period End Date

Enter the end date of the period for which to generate the report.

From Customer Name

Enter the name of the first customer in the range of customers to include in the report.

To Customer Name

Enter the name of the last customer in the range of customers to include in the report. To include only one customer in the report, enter the name in the From Customer Name field and leave this field empty.

From Customer Code

Enter the first code in the range of customer codes to include in the report.

To Customer Code

Enter the last code in the range of customer codes to include in the report.

Print by Parent Account

Select this option to sort the entries in the report by the customers' parent accounts.

Print Since Paid

Select this option to include all customer invoice that have been paid since the Period End Date in the report.

Statement Message

Enter a short message that displays at the bottom of each page of the report.

Print Credit Balance Statements

Select this option to include all credit balance statements in the report.

Print Zero Balance Statements

Select this option to include all zero-balance statements in the report.

Open/Outstanding Items Only

Select this option to include only open or outstanding items in the report.

From Branch

Enter the code for the first branch in the range of branches to include in the report.

To Branch

Enter the code for the last branch in the range of branches to include in the report. To report on a single branch, enter a code in the From Branch field and leave this field empty.

Leaving the Branch Code From field empty and entering zzzzzz in this field includes all branches in the report.

From Salesperson

Enter the name or code of the first salesperson in the range of salespeople to include in the report.

To Salesperson

Enter the name or code of the last salesperson in the range of salespeople to include in the report.

From Currency

Enter the code for the first currency in the range of currencies to include in the report.

To Currency

Enter the code for the last currency in the range of currencies to include in the report. To include a single currency code in the report, enter a code in the From Currency field and leave this field empty.

Leaving the From Currency field empty and entering zzz in this field includes all currencies in the report.

Note: If you are using parent/child accounts, and the option to Print by Parent account is selected in the parameters, the standard method used to sort the statement transaction output is to first print all outstanding parent transactions in date order, then each child account's transactions in date order.

You can also have Greentree Desktop combine both parent and child transactions in a pre-sort, so that they are printed in combined date order.