If you have Commission Agreements set up, you can reconcile the payments to the employee within the black module.
View a recording on the reconciliation (14.30 Minutes) of Employee Commissions here: Employee Commissions Reconciliation.
To start this process, go to black, Reconciliations, Employee Reconciliation.
Select + Add New.
The Add Reconciliation screen will open and you will have two fields to complete.
- Employee
- Accounting End Date
Complete the name of the Employee whos commission you want to reconcile.
Select the Accounting End Date (this is the date that you want to pull through the transaction up to).
Once these two fields are completed the Commission Agreement will sit in the overview screen, like this:
As you can see in the above image, the reconciliation is sat in the Unreconciled section.
Next, use the Actions icon to open the menu.
Select Edit.
Selecting Edit will open the reconciliation up.
Selecting the Action icon again, will offer the following options:
- Reconcile
- Adjust
- Remove
Reconcile
- Select reconcile if you are happy to continue.
- The Balance $ at the bottom of the page will update with the total to be reconciled
Adjust
- You can select the icon if you decide that was the wrong percentage, input the correct amount and it will show the New Employee Commission amount.
- You can select a reason for this adjustment.
- This gives you a preview of the amendment, before you accept.
- The transaction overview will show the correction of the transaction and be replaced with the new, correct, one.
View a recording (2 minutes) on this feature : Adjust Employee Commission transaction
Remove
- This will only remove it from the current reconciliation and will pull it back into the next one you create.
- If you had a negative amount on this reconciliation and you did not want to claw this back from the employee you can remove it and it will put back in next time.
View a recording (1 minute) on this feature: Remove transaction
To continue with the Reconcile, select Reconcile next to each transaction OR select Reconcile All icon at the top of the screen. The status will change to green.
Then select Complete.
This moves the reconciliation to the Complete - Unpaid tab. Shown here:
Select the Action icon again.
The menu provides the following options:
Review
Pay
Move to In Progress
- Review provides you with the ability to see the transactions listed and compare to what was showing on these tabs without having to move them back to In Progress.
AND while in this Review mode, you will only be able to use the existing functions of Export and Filtering (nothing else functions, it is READ only).
- If you select Pay, it will move from this section to Paid.
- Move to In Progress will move the list of transactions back to Part 2 - In Progress (back to the previous step).
Select Pay to complete the reconciliation.
Pay screen opens with the following fields:
Answer the fields as you require it to be completed and Submit.
This now put the reconciliation in the Paid tab - DONE!!!
You can still use the Action menu to perform actions on the reconciliation. The options here are:
Review
Void
Review
Provides you with the ability to see the transactions listed and compare to what was showing on these tabs without having to move them back to In Progress.
AND while in this Review mode, you will only be able to use the existing functions of Export and Filtering (nothing else functions, it is READ only).
Void Deposit
Selecting Void deposit - returns to Complete - Unpaid tab, and unravels the journal entries that you did to get there. Pay again but in a different method etc.
Disputed payments are those that are disputed by customers or the bank/financial institute, after it is shown as Paid in the platform. See article : Disputed Payments.
They are not impacted by changing a payment to disputed as Employee Commissions are calculated when the the 'transaction' occurs and NOT when the customer pays.
There are 3 accounts that will display to recognize the Employee Commissions feature, therefore when a reconciliation is complete, the Pay button is the trigger for these to integrate into QBO:
Employee Commission Due
Employee Commission Payable
Employee Commission Expense.
More information is available in the QBO article here: QBO