Balance Letter Wizard

This functionality is only available to customers who have purchased Campus Point of Sale as add-on functionality.

PATH: Point of Sale > Reports > Balance Letter Wizard

The Balance Letter Wizard allows you to create a letter that includes the patron’s POS account balance. It offers basic demographic information, an account balance and the mailing address. Letters can be saved for quick retrieval and generation at future dates.

The Balance Letter does not work for students that are end dated. To send an account balance letter to guardians of end dated students, use the Patron Balance Report.

Balance Letter Wizard

Creating a POS Account Balance Letter Template

  1. Select the New Letter button located underneath the Balance Letter Templates area.
    The Trigger Criteria screen displays.
  2. Use the information in the following table to complete the fields on this screen.




    This name should be representative of what the letter contains. For example, if the letter is only for students that have a reduced eligibility, the template might be named “Patron Balance – Reduced.”

    Max Balance

    Enter the maximum balance of the accounts that should be returned. This balance is limited to six digits – four places before the decimal point, two places after the decimal point (


    Select which patron eligibility statuses you want to return.

    D ate Type

    Select one of the following options: Transaction Date or Post Date.
    Transaction Date is the date the meal was purchased. Post Date is the date the transaction is listed on the account. These dates are often the same.

    Print Options

    Mark this checkbox to print letters with the blank header.

  3. Click the Letter Format button.
    The WYSIWYG editor, where text for the letter is entered, displays.
  4. Type the text of the letter in the Format section.


    • Use the standard formatting buttons to emphasis important items.
    • Note the last two icons of the WYSIWYG editor. These are the Field Properties and Sub-Report Properties. Select items from these ad hoc fields to pull data connected to the letter. 
    • To return the POS Account Balance, you must select the POS Account Balance from the Sub-Report Properties. Do NOT select the POS Account Balance from Field Properties. The Field Properties return static data contained in Campus and Sub-Report Properties return the most current calculated balance for the patron when letters are printed. Since the POS Account Balance can change throughout the course of a day, the Sub-Report Properties are required.
  5. Select the Organized To dropdown list to assign the letter to a certain user group.
  6. Click the Save Format button.

Generating the POS Balance Letter

  1. Select the Balance Letter Wizard from the POS Index.
  2. Select the letter to generate from the Balance Letter Template area.
  3. Select which Grades to include on the report. All students in the selected school can be selected, as well as individual grade levels. Alternatively, the user may select an Ad hoc Filter to use when generating the report.
  4. Enter an Enrollment Effective Date. This date will not include students who have ended enrollment as of this date.
  5. Enter a Summary Date. This date will capture the account balance as of that date. This is a required field and will be defaulted to the current date.
  6. Select the Sort Option for the letter.
  7. Click the Print Letter button. The report will generate, displaying the elements included in the report.

Editing or Deleting POS Balance Letters

To make changes to a letter, select the letter from the Balance Letter Templates area and select the Edit button. Follow the instructions for modifying criteria and save the changes.

To delete a letter, select the letter from the Balance Letter Templates and select the Delete button.