Difference between revisions of "Report: Invoice Register"

From Agency Systems Wiki
Jump to navigation Jump to search
(→‎Client Volume: added step to change report by option)
(updated how to access only)
 
(5 intermediate revisions by one other user not shown)
Line 1: Line 1:
[[Category:Reports]][[Category:Invoiced Premium]]
+
[[Category:Reports]][[Category:Invoiced Premium]][[Category:Invoice Register]]
 +
<table class="infobox" cellspacing="5" style="background-color: #FFFFFF; width:27em; text-align:left; border-spacing: 2px; line-height:1.5em;">
 +
<tr style="background-color: #bdbdbd; text-align: center; font-weight:bold;">
 +
    <td>Related Pages</td>
 +
</tr>
 +
 
 +
<tr>
 +
<td>
 +
<ul>
 +
<li>[[Invoice: Create An Invoice]]</li>
 +
<li>[[Training 6: Accounting]]</li>
 +
<li>[[Training 7: Management]]</li>
 +
</ul>
 +
</td>
 +
</tr>
 +
 
 +
<tr style="background-color: #d3d3d3; text-align: center; ">
 +
    <td>Related Categories</td>
 +
</tr>
 +
 
 +
<tr>
 +
<td>
 +
<ul>
 +
<li>[[:Category:Reports|Reports]]</li>
 +
<li>[[:Category:Invoiced Premium|Invoiced Premium]]</li>
 +
<li>[[:Category:Invoice Register|Invoice Register]]</li>
 +
</ul>
 +
</td>
 +
</tr>
 +
</table>
 
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.
 
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.
 +
 +
== Report Examples ==
 +
[[Report: Invoice Register: Premium Volume by Client - Highest to Lowest|Premium Volume by Client - Highest to Lowest]]
 +
 +
[[Report: Invoice Register: Premium Volume by Company - Highest to Lowest|Premium Volume by Company - Highest to Lowest]]
 +
 +
[[Report: Invoice Register: Agency Commission Volume by Client - Highest to Lowest|Agency Commission Volume by Client - Highest to Lowest]]
  
 
== Access and Window Options ==
 
== Access and Window Options ==
The invoice register can be opened by selecting '''A/R -> Invoice Register'''.  
+
The invoice register can be opened by selecting '''Reports -> Invoice Register'''.  
  
 
Access to the invoice register is controlled through the [[Security System| security system]] '''A/R -> Invoice Register -> View''' setting.
 
Access to the invoice register is controlled through the [[Security System| security system]] '''A/R -> Invoice Register -> View''' setting.
Line 13: Line 49:
  
 
[[File:invreg-detail-export.png]]
 
[[File: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.
 
 
#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]]
 

Latest revision as of 17:43, 6 March 2019

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.

Report Examples

Premium Volume by Client - Highest to Lowest

Premium Volume by Company - Highest to Lowest

Agency Commission Volume by Client - Highest to Lowest

Access and Window Options

The invoice register can be opened by selecting Reports -> 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