Direct Bill: Adjust Commission for Fees or Agency Bill Payable

From Agency Systems Wiki
Revision as of 15:20, 19 February 2019 by Fshriver (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Ic info black 24dp.png Required Software Version: March 2014
Related Pages
Related Categories

Adjustments to a direct bill statement can include a reduction for MVR expense, 2110 Agency Bill payable for combined statements, or other fees charged by the company.

Adjustments can now be made to direct bill commission within Commission Download or Commission Builder.

If your office has not been updated, or if you do not use download, skip to adjust direct bill commision using reconcile receivables.

Adjust Direct Bill Commission Using Download

Creating adjustments requires Security System: G/L -> Journal Transaction -> Entry.

Setup Download Options - Commission Adjustments

Adjustments created within Commission Download create journal transactions attached to invoices that are saved to single-day policies. The single-day policies are defined by the options configured below.

  1. Select Company -> Download
  2. Select Options.
  3. Select the Commissions Adjustments tab.
  4. Enter the Client, Department, Class Code, Transaction, and Producer assigned to the single-day adjustment policies.
    Example: (Note: It is recommended that a new client record be created for the adjustments, configured as type Prospect)
    Downloadoptions-commissionadjustments.png
  5. Select Ok when finished.

Add An Adjustment Using Download

  1. Select Company -> Download.
  2. Select the Pending Tab.
  3. Right-Click on the pending download and select Edit Details.
  4. Select Edit Details to open the payment details.
  5. Verify Create A New Cash Transaction is selected and select Adjust Commission Received.... (The option will not be available until the new commission adjustment download settings are configured.)
    Commissiondownload-editcash-adjustcommission.png
  6. Select Adjust payment received from company and enter the Adjusted Payment Amount. The adjustment amount will be automatically calculated.
  7. Enter the Offset GL. (Example: MVR Expense, or 2110 to reduce the amount of commission for an Agency Bill payable.)
    Commissiondownload-editcash-adjustcommission-mvr.png
  8. Multiple adjustments can be created for a single commission statement. Select Number of Adjustments to enter multiple items.
    Commissiondownload-editcash-adjustcommission-two-2110.png
    If multiple adjustments are set, the last adjustment amount is automatically calculated, while the first adjustment amounts are specified by the operator.
  9. Select Ok when finished.

When the commission download is processed, any adjustments will create journal transactions attached to invoices saved to the client configured in Download Options.

Process Adjustments Sent As Commission Line Items

Some carriers may send commission adjustments as line items with a commission download. The commission adjustments typically reference a dummy policy number, and modify the total commission for the statement.

Download-commission-cmpadjustment.png

Follow the steps below to properly remove the adjustment line items, and enter the adjustment with the payment screen.

  1. Select Company -> Download.
  2. Select the Pending tab.
  3. Right-Click on the pending download and select Convert to Commission Builder.
  4. Right-Click on the pending download and select Edit Details.
  5. Scroll down to the adjustment line and double-click to open the line details.
  6. Document the adjustment amount within the Agency Commission field. (From Example: $-120.00)
    Download-commission-editlineamount.png
  7. Edit the Agency Commission to $0.00. Select the Action tab and select Leave payment on account.
    Download-commission-leavyonaccount.png
  8. Select OK to close the line details. Repeat the process for any other adjustment lines.
  9. Select Payment.
  10. Edit the Commission value adding the total commission adjustment removed earlier back to the total. (From Example: $10,590.80 + $120.00 = $10,710.80)
    Download-commission-payment-cmadjust.png
  11. Select Adjust Commission Received... and re-enter the adjustment using the instructions above.

Adjust Direct Bill Commission Using Reconcile Receivables

If the option to adjust direct bill commission is not available within Commission Download/Builder, follow the steps below.

  1. Open the commission download/builder details.
  2. Select Edit Details….
  3. Select Do Not Make or Use cash.
  4. Select Ok.
  5. Release and process the download.

After the invoices have been created, one of the invoices will need to be adjusted.

  1. Open any invoice in Express Billing.
  2. Double-click on the invoice line to open the invoice detail screen.
  3. Select the Adjust button in the lower right-hand corner.
  4. Select Adjust With A New Journal.
  5. Select the Company check-box.
  6. Enter the fee amount as a credit in the amount field. (Example: MVR fee of 10.00, enter -10.00.)
  7. Enter the Offset GL for the fee expense. (To see a listing of available general accounts, left click "Must Enter GL Account").
  8. Enter a Description line.
  9. Select Accept, exit the invoice detail screen, and exit Express Billing.
  10. Process reconcile company receivables normally which will now include the adjustment amount.