Difference between revisions of "Report: Invoice Register"

From Agency Systems Wiki
Jump to navigation Jump to search
(initial save)
 
(→‎Client Volume: added step to change report by option)
Line 25: Line 25:
  
 
#Select '''AR -> Invoice Register'''.
 
#Select '''AR -> Invoice Register'''.
 +
#Select '''Report By -> Client Number'''.
 
#Select '''Start Date -> 01/01/2013'''.
 
#Select '''Start Date -> 01/01/2013'''.
 
#Select '''End Date -> 12/31/2013'''.
 
#Select '''End Date -> 12/31/2013'''.
Line 37: Line 38:
  
 
#Select '''AR -> Invoice Register'''.
 
#Select '''AR -> Invoice Register'''.
 +
#Select '''Report By -> Client Number'''.
 
#Select '''Start Date -> 01/01/2013'''.
 
#Select '''Start Date -> 01/01/2013'''.
 
#Select '''End Date -> 12/31/2013'''.
 
#Select '''End Date -> 12/31/2013'''.

Revision as of 16:34, 8 January 2014

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