Accounting
      Back to home
      1. Legacy
      2. Accounting

      Commissions - Setup/Configuration


      Before you start: Set up the commissions GL accounts
      The default commission expense and commission payable accounts are set up using the Accounting Defaults screen.

      1. Open the Accounting Defaults screen (Administration > Accounting > General Setup > Accounting Defaults).

      2. Open the Accounts Payable tab.


       

      3. Default Commission (EXPENSE) - This GL account is debited when commissions are marked as paid in Step 5.


      4. Commission(LIABILITY) - This is the commission payable account. This GL account is credited when commissions are marked as complete in Step 5.


       


       

      5. Click 'OK' when complete.



      Setting Up Commissions:

      Step 1: Add a new commission period
      Use the New Commission Period screen to create a new Commission period. The commission period is used to track employee commissions, and it determines the payable date of the commissions. For example, if you pay out commissions every month, you can create a commission period titled July Commissions and give it a payable date of 08/01.


       

      1.  Open the New Commission Period screen (Administration > Sales > Commission Tracking > Add Commission Period).
      • You can also click Add on the Commission Period Search screen (Administration > Sales > Commissions Tracking > Search Commission Periods).

      2. Name - Enter the name of the commission period, e.g. June Commissions, or July Bonuses.


      • Employees can view their commissions by commission period using the My Commissions button on the Employee tab on the main menu.

      3. Payable - Date the commission expense will post to the General Ledger once the commissions period is marked as paid.


      • See Posting Overview for information on posting.

      4. Click Save and Add Transactions to save the new commission period.


      • The accounting period for the payable date selected is closed - You must create a new Accounting Period before adding a new Commission period.

      • Once the commissions period is created, you can add transactions to the period using the Search Commission Periods option (Administration > Sales > Commissions Tracking > Add Commission Period > Select a period and click the Edit Transactions button).

       

      Step 2: Select the transactions
      Once the commission period is created, select the transactions to pay commissions on. These transactions are added to the commission period that you just created.
      You can perform this step at any point as long as the commission period has not been paid.


       

      1. Open the Commission Period Search screen (Administration > Sales > Commission Tracking > Search Commissions Periods).

      2. Double click on a commission period. The Commission Period screen appears.

      • You created the commission period in Step 1: Add a new Commission period.

      • All of the transactions added to the commission period display on the Commission Period screen.

      • Transactions appear in a blue text if commissions have already been calculated. Commissions are calculated after the transactions are selected in Step 3.

      3. Click Search for Transactions. The Commission Request Search screen appears.


      4. Use the filters to search for the invoices you want to record commissions on.


      • Just Closed Invoices: Check this box if you only pay commissions on orders that have been invoiced and closed.

      • Invoice Interest: Filter by marketing interest, e.g. stoves, spas, pools or chemicals.

      • Employee: You can use this field to record the commissions on one employee at a time.

      • Invoice Total: This field is helpful if you only pay commissions on invoices greater than a specific dollar amount. For example, enter $500 if you only pay commissions on invoices greater than $500.

      • Store/Department: You can use this field to record commissions one store/department at a time.

      • Exclude Invoices Older Than: Use this field to exclude invoiced older than a specific date.

      5. Click Refresh. The invoices that match the filter criteria appear in the screen.

      • Only transactions that have not already been added to a Commission period are displayed.

      6. Select the transactions you want to record commissions on.


      7. Click Move To Commission Period.

      • The selected transactions are removed from the screen and added to the commission period.

      • You can add additional transactions to the commission period, or proceed to Step 3.



      Step 3: Calculate commissions on the selected transactions
      Once you select the transactions, you can either use the system or an MS Excel spreadsheet to calculate commissions.

      • Simple calculation: Use the application to calculate commissions by applying a percentage to the item total, invoice total, or profit.

      • More complex calculations: Use an MS Excel spreadsheet to perform more complicated commission calculations, e.g. a graduated commissions scale.

       

      Option A - Use the application to calculate commissions (simple calculations)
       

      1. Open the Commission Period Search screen (Administration > Sales > Commission Tracking > Search Commission Periods).


      2. Double click on a commission period. The Commission Period screen appears.


      • You created the commission period in Step 1: Add a new Commission period.

      • All of the transactions that you added to the commission period are displayed in the Commission Period screen.

      • Transactions appear in a blue text if commissions have already been calculated. Commissions are calculated after the transactions are selected.

      3. Click Simple Commission Calculation. The Simple Calculation screen appears.


      4. Select the transactions you want to include in the calculation.


      • Transactions appear in a blue text if commissions have already been calculated. Commissions are calculated after the transactions are selected.

      5. Click 'Calculate'. The Commission Calculation Parameters screen appears. Select what amount you want to apply the Commission percentage to.

      • The Item Total and Profit both appear on the Simple Calculation screen. Just click Cancel to return to the Simple Calculation screen.

      • Double click on a transaction on the Commission Period screen to view the Invoice Total. Just click Cancel, and then Close to return to the Commission Period screen, and then double click on a transaction.

      6. Enter the Pay Percent.


      7. Click Calculate. The Commission Questions screen appears.


      8. Select the GL Account.


      The following journal entry is created when commissions are marked as paid in Step 5. The post date is the payable date set up on the commissions period.

       

      Debit

      Credit

      Commission Expense

      Commission Amount

       

      Commission Payable
      Administration > Accounting > General Setup > Accounting Defaults > Accounts Payable tab > Commission (LIABILITY)

       

      Commission Amount
      9. Select a Category or enter a new commission category.

      • You can use commission categories to group transactions, e.g. Regular Commissions, or Bonuses.

      • You can use commission categories to filter the commissions that appear on the Commission Report.

      10. Click 'Continue'. The system calculates commissions on the selected transactions.

      • The calculated commission amount is displayed in the Commissions column on the Simple Calculation screen.

      • Click Close to return to the Commission Period screen.

       

      Option B - Calculate commissions using an MS Excel spreadsheet (for more complicated calculations)
      If you want to perform more complicated commission calculations, follow the steps below to export the transactions to an MS Excel spreadsheet, calculate the commission amount using your own formulas, and then import the commissions back into the application.


      Export

      1. Open the Commission Period Search screen (Administration > Sales > Commission Tracking > Search Commission Periods).
      2. Select the commission period.
        1. You created the commission period in Step 1: Add a new Commission period.
      3. Click Print/Export.
      4. (optional) Use the filters to limit the transactions included in the MS Excel spreadsheet.
        1. By default, the spreadsheet includes all of the transactions that you added to the commission period in Step 2: Select the transactions.
        2. Commission Category: A commission category is added to the transactions when a GL commissions expense account is selected.
      5. Select 'Directly to Excel' on the Output tab. Click Preview Report.
        1. Enter the calculated Commission amounts in a spreadsheet
      6. Open the exported spreadsheet.
      7. Enter the commission amounts in the Commission Amount column. For example, apply your customized formula to the columns on the spreadsheet and populate the Commission Amount column with the commission amounts.
      8. Skip the Commission Category and GL Account fields.
        1. The Commission category and Commission expense account is selected when the commissions are imported
      9. Save the updated MS Excel spreadsheet.

        Import
      10. Open the Commission Period Search screen (Administration > Sales > Commission Tracking > Search Commission Periods).
      11. Select the commission period.
      12. Click 'Import'.
      13. Click 'Yes'.
      14. Select the spreadsheet and click Save. The Import Data screen appears.
      15. Select the transactions you want to import.
      16. Click Import Transactions. The Commission Questions screen appears.
      17. Select the GL Account.


      The following journal entry is created when commissions are marked as paid in Step 5. The post date is the payable date set up on the commissions period.

       

      Debit

      Credit

      Commission Expense

      Commission Amount

       

      Commission Payable
      Administration > Accounting > General Setup > Accounting Defaults > Accounts Payable tab > Commission (LIABILITY)

       

      Commission Amount

       

      1. Select a Category or enter a new commission category.

      • You can use commission categories to group transactions inside a commission period, or group commission adjustments together.

      • You can use commission categories to filter the commissions that appear on the Commission Report.

      1. Click 'Continue'.

      • Success displays in the Import Status field if the import was successful. The transaction also appears in blue text.

      1. Click 'Close' or import additional transactions.


      Step 4: (optional) Adjust the commissions
      There are two ways to manually adjust the calculated commissions:

      1. Update the commission on an existing transaction - Manually adjust the commission calculated on an existing transaction. For example, use this option if you want to manually increase or decrease the commission calculated on a transaction. You can also use this option to change the commission category, commission expense account, or change the transaction to Non-Commissionable.

      2. Manually create a new commission - Manually create a new commission using the Manual Adjustments tab on the Commission Period screen.


      Option A - Update the commission on an existing transaction

      1. Open the Commission Period Search screen (Administration > Sales > Commission Tracking > Search Commission Periods).

      2. Double click on the commission period.

      • You created the commission period in Step 1: Add a new commission period.

      1. Double click on a transaction. The Commission Request screen appears.

      2. Commission - Enter the Commission amount.

      3. Non-Commissionable - Check this box if a commission should not be calculated for this transaction.

      4. Category - The commission category was added to the transaction in Step 3.

      • You can use commission categories to filter the commissions that appear on the Commission Report.

      1. Accounting - Select the commission expense account.


      The following journal entry is created when commissions are marked as paid in Step 5. The post date is the payable date set up on the commissions period.