Customizing a Statement Using Sheets

Statements, invoices, and receipts can be customized by setting up a Sheet with a Statement type. If enabled, the same custom sheet will be used for all statements, invoices, and receipts, with only the title and relevant information changing depending on which document is generated.

Enable the Preference

To use a custom sheet for all statements, invoices, and receipts, enable the preference in Account Module Preferences.

  1. In the Main Menu, click Setup, Account, Misc Account.
  2. Check the option Statements use Sheets.

The custom statement sheet listed first alphabetically will be used. For example, if there are two custom statements named Custom Statement and Walkout Statement, Custom Statement will be used because it comes first alphabetically. If there is no custom statement, the internal sheet will be used.

Uncheck the preference to use the classic statement format instead.

Set up a Statement Sheet

  1. In the main menu, click Setup, Sheets.
  2. Copy a sheet or create a new one.
    • Highlight the internal Statement sheet and click Copy. Then double click the custom statement.
    • Click New and create a new sheet with a Statement type.
    • Double click an existing custom statement to edit it.
    • Highlight an existing custom statement then click Duplicate to copy it.
  3. Change the sheet as needed.

Below is an example of a custom statement.

There are additional options that are only available for sheets with a Statement type. A few are described below.

Grids: There are five grids that can be added to a sheet.

Payment Options: When adding Static Text Fields, there is an additional 'Is Payment Options' checkbox. When checked, this designates the field for inclusion when payment information is included in a statement, invoice, or receipt. The checkbox 'Hide payment options' on the Statement window determines if payment information is included or not.


Some fields are defined here.

StatementReceiptInvoice: This field determines the title of the document based on how it is generated.

statementIsCopy: If printing a copy of an invoice the word COPY will be printed on the sheet.

statementIsReceipt: Only shows when printing receipts. The field will show KEEP THIS RECEIPT FOR INCOME TAX PURPOSES.

Return address: The Practice address, or if using Clinics, the clinic address.

Billing address: The guarantor's entire address as entered on the Edit Patient Information window. Patient vs guarantor name is determined by how the bill is generated. If via the Billing List, the guarantor name shows.

Output Fields

Some Output Text Fields are defined here.

invoicePaymentLabel: This output field is labeled Payments in the sheet. This is the sum of all the payments in the Patient Account grid, whether or not the payments are attached to a procedure.

invoicePaymentValue: This output field displays the payment amount.

invoiceTotalLabel: This output field is labeled Balance Remaining in the sheet. This is the sum of the charges minus the sum of the payments.

invoiceTotalValue: This output field displays the balance remaining amount.

ProviderLegendAUS: This output field only works for users in Australia, with language settings set to English-Australia. Adds a legend to the statement that shows all non-hidden providers.

Swiss bank routing fields do not show on the new custom statements.

Australian Provider legend must be added from the available output fields.