Difference between revisions of "Producer Payables: Include Producer Commission in Payroll Check"

From Agency Systems Wiki
Jump to navigation Jump to search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
[[Category:Checks]][[Category:Payables]]
 
[[Category:Checks]][[Category:Payables]]
 
<table class="infobox" cellspacing="5" style="background-color: #FFFFFF; width:27em; text-align:left; border-spacing: 2px; line-height:1.5em;">
 
<table class="infobox" cellspacing="5" style="background-color: #FFFFFF; width:27em; text-align:left; border-spacing: 2px; line-height:1.5em;">
 +
<tr>
 +
    <td>[[File:Ic_info_black_24dp.png]] Required Software Version: [[:Category:Release Notes|September 2015]]</td>
 +
</tr>
 +
<tr>
 +
    <td>[[File: Ic_settings_backup_restore_black_24dp.png]]  Legacy Instructions Available: [http://wiki.agencysystems.com/mediawiki/index.php?title=Producer_Payables:_Include_Producer_Commission_in_Payroll_Check&oldid=2053 Click Here]</td>
 +
</tr>
 
<tr style="background-color: #bdbdbd; text-align: center; font-weight:bold;">
 
<tr style="background-color: #bdbdbd; text-align: center; font-weight:bold;">
 
     <td>Related Pages</td>
 
     <td>Related Pages</td>
Line 8: Line 14:
 
<ul>
 
<ul>
 
<li>[[Bank Profile]]</li>
 
<li>[[Bank Profile]]</li>
<li>[[Non-Policy Related Checks]]</li>
 
 
<li>[[Reconcile Producer Payables]]</li>
 
<li>[[Reconcile Producer Payables]]</li>
 
<li>[[Training 6: Accounting]]</li>
 
<li>[[Training 6: Accounting]]</li>
 
<li>[[Vendor Profile]]</li>
 
<li>[[Vendor Profile]]</li>
 +
<li>[[Voucher Transaction]]</li>
 +
<li>[[Voucher Transaction: Sample Voucher Templates]]</li>
 
</ul>
 
</ul>
 
</td>
 
</td>
Line 27: Line 34:
 
</tr>
 
</tr>
 
</table>
 
</table>
The process below outlines all steps required to include producer commission on an [[Non-Policy_Related_Checks#Employee_Salary_Payroll_Check_Template|employee payroll check, including any non-policy related general ledger deductions]].  
+
The process below outlines all steps required to include producer commission on an [[Voucher_Transaction:_Sample_Voucher_Templates#Employee_Salary_-_Payroll_and_Commission|employee payroll check, including any non-policy related general ledger deductions]].  
  
 
== One-Time Setup ==
 
== One-Time Setup ==
 
==== Create a New Bank Profile ====
 
==== Create a New Bank Profile ====
 
Create a new [[Bank Profile]], number '''999''', named '''Producer Payable Bank'''. ''(Any bank code can be used, other than the operating and trust accounts)''.
 
Create a new [[Bank Profile]], number '''999''', named '''Producer Payable Bank'''. ''(Any bank code can be used, other than the operating and trust accounts)''.
 
:[[File:Profiles-bank-producerpayable999.png]]
 
  
 
==== Create a Vendor Profile For Each Producer ====
 
==== Create a Vendor Profile For Each Producer ====
 
Create a '''[[Vendor Profile|Vendor Code]]''' for each [[Producer Profile|Producer]].
 
Create a '''[[Vendor Profile|Vendor Code]]''' for each [[Producer Profile|Producer]].
==== Create an Employee Payroll Check Template For Each Vendor ====
 
[[Non-Policy_Related_Checks#Employee_Salary_Payroll_Check_Template|Create and store payroll check template for each vendor code created above]]. 
 
 
In addition to the payroll distributions, include an '''addition distribution: GL 1100 sub GL 999 for 0.00'''.
 
:[[File:Ap-nonpol-payroll-add999.png]]
 
 
After selecting '''Accept''', verify the distribution is added to the list, and select '''Store'''.
 
  
:[[File:Ap-nonpol-payroll-add999-store.png]]
+
==== Create an Employee Payroll Voucher Template For Each Vendor ====
 +
[[Voucher_Transaction:_Sample_Voucher_Templates#Employee_Salary_-_Payroll_and_Commission|Create and store payroll check template for each vendor code created above]]
  
 
== Part 1: Clear Producer Payables Using Reconcile Producer Payables ==
 
== Part 1: Clear Producer Payables Using Reconcile Producer Payables ==
 
The first part clears the Producer Payables balance (GL-2120) on invoices and records the [[:Category:Checks|wire check]] to [[Bank Profile|bank 999]].  
 
The first part clears the Producer Payables balance (GL-2120) on invoices and records the [[:Category:Checks|wire check]] to [[Bank Profile|bank 999]].  
#Select '''AP -> Reconcile Payables'''.
+
#Select '''Producer -> Reconcile Producer Payables'''.
#Select '''Producer Payables'''.
 
 
#Enter the '''Producer's Code'''.
 
#Enter the '''Producer's Code'''.
 
#Enter the desired '''Start Date''' and '''End Date''' for the invoices to be paid. Select '''OK'''.
 
#Enter the desired '''Start Date''' and '''End Date''' for the invoices to be paid. Select '''OK'''.
#:[[File:Ap-reconcileproducer.png]]
+
#:[[File:producer-reconcilepayable.png]]
 
#'''Right Click -> Pay All Trust Amount''' to pay all invoices listed, or select individual invoices to '''Pay this Invoice Trust Amount'''.  
 
#'''Right Click -> Pay All Trust Amount''' to pay all invoices listed, or select individual invoices to '''Pay this Invoice Trust Amount'''.  
#:[[File:Ap-reconcileproducer-payalltrust.png]]
+
#:[[File:producer-reconcilepayable-payalltrust.png]]
 
#Select the '''Payment Details''' button at the bottom of the screen.
 
#Select the '''Payment Details''' button at the bottom of the screen.
 
#*Change '''Bank Code to 999'''.  
 
#*Change '''Bank Code to 999'''.  
Line 61: Line 59:
 
#*Enter a '''Description'''.
 
#*Enter a '''Description'''.
 
#*'''Write down Total Amount shown''' on the bottom-right corner of this window.  This amount will be needed for the payroll check. Select '''OK'''.
 
#*'''Write down Total Amount shown''' on the bottom-right corner of this window.  This amount will be needed for the payroll check. Select '''OK'''.
#:[[File:Ap-reconcileproducer-payalltrust-paymentdetails.png]]
+
#:[[File:producer-reconcilepayable-payalltrust-paydetails-New.png]]
 
#Select '''Perform Reconciliation'''.
 
#Select '''Perform Reconciliation'''.
 
#The system will display '''"Check Number 999-WXXXX has been created."'''. Select '''OK'''.  
 
#The system will display '''"Check Number 999-WXXXX has been created."'''. Select '''OK'''.  
#:[[File:Ap-reconcileproducer-payalltrust-createdcheck.png]]
+
#:[[File:producer-reconcilepayable-payalltrust-createdcheck.png]]
 
#The system will display '''"Reconciliation complete"'''. Select '''OK'''.
 
#The system will display '''"Reconciliation complete"'''. Select '''OK'''.
 
See: [[Reconcile Producer Payables]] for more details.
 
See: [[Reconcile Producer Payables]] for more details.
  
 
== Part 2: Include Producer Payables Commission on Employee Payroll Check ==
 
== Part 2: Include Producer Payables Commission on Employee Payroll Check ==
The second part will create a non-policy related payroll check using the [[Vendor Profile|vendor code]] and [[Non-Policy_Related_Checks#Employee_Salary_Payroll_Check_Template|employee payroll check template]] created in the [[#One-Time Setup|one-time setup above]].
+
The second part will create a voucher using the [[Vendor Profile|vendor code]] and [[Voucher_Transaction:_Sample_Voucher_Templates#Employee_Salary_-_Payroll_and_Commission|employee payroll voucher template]] created in the [[#One-Time Setup|one-time setup above]].
#Select '''AP -> Check Transaction -> Non-Policy Related'''.
+
#Select '''Vendor -> Voucher Transaction'''. ''(Requires Security System: '''AP -> Voucher Transaction -> View''')''
#Enter the '''[[Vendor Profile|Vendor Code]] for the producer'''. ''(The previously stored check template details will load.)''
+
#Enter the '''[[Vendor Profile|Vendor Code]] for the producer'''.
#Enter '''GL code 1100, Department GA, and Sub GL 999'''. Enter reconcile payable '''[[#Part 1: Clear Producer Payables Using Reconcile Producer Payables|amount from Part 1]]'''. Select '''Modify'''.  
+
#Select the '''Voucher Template''' from the next drop-down.
#:[[File:Ap-nonpol-payroll-modify.png]]
+
#Modify '''GL code 1100 - Sub GL 999'''. Enter reconcile payable '''[[#Part 1: Clear Producer Payables Using Reconcile Producer Payables|amount from Part 1]]'''.  
#Continue to Modify GL distributions on the template until the check total equals the amount of the employee's payroll check.  To edit an existing '''Check Disbursement Amount''', enter the matching '''GL Code''' and '''Department'''.  Enter the new '''Amount''', and select '''Modify'''.  
+
#Continue to Modify GL distributions on the template until the voucher total equals the amount of the employee's payroll check.  
 
#When finished, select '''Save'''.
 
#When finished, select '''Save'''.
 +
#When prompted, [[Voucher_Transaction#Voucher_Transaction:_Payment|Select to Pay Now, or Pay Later]] to pay the voucher with a physical or wire check.

Latest revision as of 16:50, 6 August 2020

Ic info black 24dp.png Required Software Version: September 2015
Ic settings backup restore black 24dp.png Legacy Instructions Available: Click Here
Related Pages
Related Categories

The process below outlines all steps required to include producer commission on an employee payroll check, including any non-policy related general ledger deductions.

One-Time Setup

Create a New Bank Profile

Create a new Bank Profile, number 999, named Producer Payable Bank. (Any bank code can be used, other than the operating and trust accounts).

Create a Vendor Profile For Each Producer

Create a Vendor Code for each Producer.

Create an Employee Payroll Voucher Template For Each Vendor

Create and store payroll check template for each vendor code created above.

Part 1: Clear Producer Payables Using Reconcile Producer Payables

The first part clears the Producer Payables balance (GL-2120) on invoices and records the wire check to bank 999.

  1. Select Producer -> Reconcile Producer Payables.
  2. Enter the Producer's Code.
  3. Enter the desired Start Date and End Date for the invoices to be paid. Select OK.
    Producer-reconcilepayable.png
  4. Right Click -> Pay All Trust Amount to pay all invoices listed, or select individual invoices to Pay this Invoice Trust Amount.
    Producer-reconcilepayable-payalltrust.png
  5. Select the Payment Details button at the bottom of the screen.
    • Change Bank Code to 999.
    • Change Check Type -> Wire Check.
    • Enter a Description.
    • Write down Total Amount shown on the bottom-right corner of this window. This amount will be needed for the payroll check. Select OK.
    Producer-reconcilepayable-payalltrust-paydetails-New.png
  6. Select Perform Reconciliation.
  7. The system will display "Check Number 999-WXXXX has been created.". Select OK.
    Producer-reconcilepayable-payalltrust-createdcheck.png
  8. The system will display "Reconciliation complete". Select OK.

See: Reconcile Producer Payables for more details.

Part 2: Include Producer Payables Commission on Employee Payroll Check

The second part will create a voucher using the vendor code and employee payroll voucher template created in the one-time setup above.

  1. Select Vendor -> Voucher Transaction. (Requires Security System: AP -> Voucher Transaction -> View)
  2. Enter the Vendor Code for the producer.
  3. Select the Voucher Template from the next drop-down.
  4. Modify GL code 1100 - Sub GL 999. Enter reconcile payable amount from Part 1.
  5. Continue to Modify GL distributions on the template until the voucher total equals the amount of the employee's payroll check.
  6. When finished, select Save.
  7. When prompted, Select to Pay Now, or Pay Later to pay the voucher with a physical or wire check.