Agent Billing Reports Enhancements

Above, previous version Agent Billing Reports menu.

Below, reorganized menu in version 14.4.

The Agent Billing Reports are now organized into “Current” and “History” groups. The current, or not posted, billed items, cash receipts (agent payments), and recovery deductions from commission checks are reported within the “Current (Not Posted) group.  Reports for agents, by billing items, as well as invoice reprints and balance summaries for invoiced (posted) reports are accessed within the “History” area.

In addition, a number of enhancements suggested by customers have been implemented.

With the  “Total Balances” button, the current billing balances print and preview are combined within the new command button.

The “Total Balances” report has been changed significantly to reflect the enhancements in balance display within the agent record and the pay commissions check writer. Report columns:

• ·    Agents and Office ID:  shows the agent name (last, first) and the office the agent is assigned to (in parenthesis). The report is now sorted by agent last name.

• ·    Balance Forward: displays the agent’s balance forward as of the last invoice/current log posting (move to history).

• ·    NEW COLUMN: Payments.  This is the total the agent has paid plus all agent recoveries deducted from checks in the current billing log. These payments and recoveries have been taken after the last invoice/current log posting. (Note that “Payments” does not include amounts that may be within a check batch that has not been printed).

• ·    NEW COLUMN: AdjBalanceFWD.  This is the adjusted balance forward or amount still unpaid of the balance forward. This is equal to the “Balance Forward” column less the “Payments” column.

• ·    NEW COLUMN: Items: this is the net of all new billed items in the current log.

• ·    Current Balance: is the agent’s account balance. It is calculated by “AjdBalanceFWD” plus the “New Items”. 

NEW: To view the details for an agent in “Preview”, use the drill down feature. Move the cursor over the agent name and double click when the magnifying glass is displayed:

Above – sample drill down showing agent current balance details from the current log. Each detail row is either a payment or new item billed (or a reversal or credit of either). Detail columns include:

• ·    The entry date of the payment or billed item

• ·    The item description. Note (a payment description starting with “CR RE…” is an agent recovery from a commission check. A payment description starting with “R – CR RE…” is a reversal of an agent recovery from a commission check that was voided.)

• ·    The item ID, e.g. “NEWSAD”.  (for payments this is always “CASHRECP”)

• ·    The Payment, Adjusted Balance Forward, New Items amount, and Current Balance. Note that the adjusted balance forward and the current balance amount are running totals.

The “Agent Invoice Balances”  report (above)  has been changed:

• ·    to indicate the Beginning Balance and Balance Forward of each invoice

• ·    sort the agent records by agent last name

• the invoice date range of the report is now indicated in the bottom of the report. The second date indicates the “as-of” date of the receivable (see above).

 Want Everyone in your Company to Run it Like a Business? run REAL/Easy 1-800-REALEASy (1-800-732-5327)