Agent Profit Sharing

The Agent Profit Sharing report totals group sales by agent and calculates each agent’s percent of the total. It then multiplies that percent by the group profit (balance in Group Deposits and revenue accounts in the general ledger) to determine how much of the profit was generated by the agent.

For example, assume a group’s profit is $2,000 on sales of $10,000 booked by two agents. One agent booked invoices totaling $6,000 and the other agent's bookings totaled $4,000. The profit you are sharing is 10%. The first agent would get $120 and the second would get $80. (10% of $2,000 is $200; 60% or $120 goes to one agent and 40% or $80 to the other.)

This report includes records from invoices and the general ledger. Detail lines and group subtotal contain information from invoice. Agent and Report totals contain data from invoices and the general ledger.

The report includes commissions in the agent’s profit; however, a separate total subtracts them, in case your agency pays agents from another report (for example, the Consultant Production Report) that includes commissions.

Running the Report

To run the report:

  1. On the Groups submenu, click Agent Profit Sharing.

    The Agent Profit Sharing dialog box appears.

    The following table describes the fields on the Agent Profit Sharing dialog box.

    Field Description

    Group ID

    Identifier of the group for which to run the report. This field is required.

    To find and select a group ID, click the lookup () button. The Find Group screen appears. For details, see Using the Lookup Buttons and Screens.

    Agent Type

    Select Booking Agent to run the report for booking agents. Select Selling Agent to run the report for selling agents.

    Summary Only

    Runs only the summary of the report.

    Agent % of Profit

    Enter the percent of the profit to share with the agents. This field is required.

    New Page Per Agent

    Creates a new page per agent.

  2. Complete the fields as appropriate.

    Note: The Group ID and Agent % of Profit fields are required.

  3. Choose one of the following print options:

    • To print the report immediately, click PRINT.

      The Send to dialog box appears. Select a report destination. For more information, see Printing Overview.

    • To store the report as part of a batch for printing later, click BATCH.

      The Choose a Batch dialog box appears. For more information, see Batch Printing.

Report Example

Agent Profit Sharing report example

Report Notes