Report: Invoice Register

From Agency Systems Wiki
Revision as of 20:02, 26 August 2014 by Mlively (Talk | contribs) (added infobox)
Jump to navigation Jump to search
Related Pages
Related Categories

The invoice register provides a number of report formats based on agency or direct bill invoices. There are a number of different category sort options and detail levels depending on the reporting needs. In addition, a Microsoft Excel export to a spreadsheet is available.

Access and Window Options

The invoice register can be opened by selecting A/R -> Invoice Register.

Access to the invoice register is controlled through the security system A/R -> Invoice Register -> View setting.

Invreg-default.png

Report Window Options

Export to Microsoft Excel

To enable the export option to Microsoft Excel, select Detail Level -> Detail.

Invreg-detail-export.png

Report Examples

Use the filters below for the 2013 calendar year. Adjust the date range or date type as desired.

Client Volume

The default output for client volume will either be sorted by client number, or alphabetically. The report format will change depending on the detail level selected.

In addition, the summary report can be sorted by premium volume, or agency commission, with the highest volume clients listed first.

Premium Volume by Client - Highest to Lowest

The total invoiced premium for your agency can be broken down by client, ordered from highest to lowest.

  1. Select AR -> Invoice Register.
  2. Select Report By -> Client Number.
  3. Select Start Date -> 01/01/2013.
  4. Select End Date -> 12/31/2013.
  5. Select Date Type… -> GL Dates.
  6. Select Sort By -> Inv Amt, % of Total.
  7. Deselect Include Non-premiums

Invreg-cltnum-summary-invamt.png

Agency Commission Volume by Client - Highest to Lowest

The total agency commission for your agency can be broken down by client, ordered from highest to lowest.

  1. Select AR -> Invoice Register.
  2. Select Report By -> Client Number.
  3. Select Start Date -> 01/01/2013.
  4. Select End Date -> 12/31/2013.
  5. Select Date Type… -> GL Dates.
  6. Select Sort By -> Agy Amt, % of Total.
  7. Deselect Include Non-premiums

Invreg-cltnum-summary-agyamt.png