Difference between revisions of "Report: Invoice Register"

From Agency Systems Wiki
Jump to navigation Jump to search
(added infobox)
(→‎Report Examples: moved reports to stand-alone pages)
Line 43: Line 43:
  
 
== Report Examples ==
 
== Report Examples ==
Use the filters below for the 2013 calendar year.  Adjust the date range or date type as desired.
+
[[Report: Invoice Register: Premium Volume by Client - Highest to Lowest|Premium Volume by Client - Highest to Lowest]]
  
=== Client Volume ===
+
[[Report: Invoice Register: Agency Commission Volume by Client - Highest to Lowest|Agency Commission Volume by Client - Highest to Lowest]]
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.
 
 
 
#Select '''AR -> Invoice Register'''.
 
#Select '''Report By -> Client Number'''.
 
#Select '''Start Date -> 01/01/2013'''.
 
#Select '''End Date -> 12/31/2013'''.
 
#Select '''Date Type… -> GL Dates'''.
 
#Select '''Sort By -> Inv Amt, % of Total'''.
 
#Deselect '''Include Non-premiums'''
 
 
 
[[File: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.
 
 
 
#Select '''AR -> Invoice Register'''.
 
#Select '''Report By -> Client Number'''.
 
#Select '''Start Date -> 01/01/2013'''.
 
#Select '''End Date -> 12/31/2013'''.
 
#Select '''Date Type… -> GL Dates'''.
 
#Select '''Sort By -> Agy Amt, % of Total'''.
 
#Deselect '''Include Non-premiums'''
 
 
 
[[File:Invreg-cltnum-summary-agyamt.png]]
 

Revision as of 20:10, 26 August 2014

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

Premium Volume by Client - Highest to Lowest

Agency Commission Volume by Client - Highest to Lowest