Adjusting a deal if an Agent has been overpaid or underpaid commissions

Adjusting a deal if an Agent has been overpaid or underpaid commissions

There are times when an Agent is paid out on a deal and we get information after that fact that means the Brokerage either needs to recover funds back from the Agent or need to pay the Agent a little more. The good news is that you don’t necessarily have to remove and redo all those transactions. In most cases you can make a quick adjustment to the allocations or deductions and Loft will record the difference in order to update the deal and your financial platform. 

In this video, we go over the different underpay/overpay scenarios and how to fix them

An Agent underpayment can happen in three ways; 

  • You deducted a fee that you shouldn’t have 

  • You charge them more than you should have for a specific fee

  • You recorded lower commissions than what they actually received

*When fixing underpayments, Loft will create a second bill payable to the agent if they were underpaid.

An Agent overpayment can happen in three ways; 

  • You forget to deduct a fee 

  • You charge them less than you should have

  • You recorded higher commissions than what they actually received 

*When fixing overpayments, Loft will add an invoice for an agent if the agent was overpaid 

UNDERPAYMENT

Rather than unreconciling transactions and reposting the original payout you will want to make a quick adjustment to the deal in Loft and post the updated payout. 

You’ll need to record an additional payout to the Agent if you’ve already paid them. In short, the Brokerage owes the Agent money. Loft created a new payout which will post an additional bill to the Agent in your accounting platform. 

If the underpayment was a result of overcharging the deductions, follow these instructions for making the adjustments. 

The agent had $3,000 of commission, two fees deducted for a net pay of $2,100.00. We are going to reduce the split fee as the agent should have been charged  $300 rather than the $500 that was deducted. The net pay to the agent then should have been $2300. 

Before: (please note, the deductions may vary on your deal, this is an example only) 

After:

By Adding a new fee called "split fee'' (you will need to add the deduction that was overcharged on your deal, this is an example only) we can adjust that fee to be -200 to reduce the $500 we had taken before which, after a save, makes the net that should have been paid $2,300

Head to the Payout Commission page to see that Loft has created a second payout which will post a second Bill to the Agent. If you haven't cut a check on the initial bill you can group both payout together to combine into one check or you can pay them out individually. 

Make sure you are paying from the bank account that is currently holding funds to avoid any transfer issues between accounts.




Instructions when the underpayment is a result of recording too little commission. 

  1. Increase the amount of commissions on the commission page and the allocation should adjust to the correct amount. If the allocation has been manually overridden you can manually override to the correct amount. 

  2. Head to the Payout Commission page which will show a payout for the difference as the commission is more than what was originally paid. Posting this will post a second invoice to the Agent. 

OVERPAYMENT

Rather than unreconciling transactions and reposting the original payout you will want to make a quick adjustment to the deal in Loft and post the updated payout. 

You’ll need to recover those funds from the Agent if you’ve already paid them. In short, the Agent owes the Brokerage money. Loft created a negative payout which will post an invoice to the Agent in your accounting platform. This amount becomes part of their accounts receivable balance. 

If the overpayment was a result of the deductions, follow these instructions for making the adjustments. 

The agent had $3,000 of commission, two fees deducted totalling $900 for a net pay of $2,100.00. 

Before:

We are going to increase the Office Split to $700 rather than the $500 that was deducted. To do that we simply add another fee of the same type. We want to increase the total amount of the fee by $200.00

After: The  “Office Split” total is now $700 and the net pay is now $1,900.00. 




Head to the Payout Commission page, you can see that Loft has created a negative payout which will post an invoice to the agent in Xero. You can collect cash from them or deduct their Accounts Receivable balance off their next commission payout!  To reconcile the invoice against the payment in Xero, follow these instructions here.


Instructions when the overpayment is a result of recording too much commission. 

  1. Adjust the amount of commissions on the commission page and the allocation should adjust to the correct amount. If the allocation has been manually overridden you can manually override to the correct amount as well. 

  2. Head to the Payout Commission page which will show a negative payout since the commission is less than what was originally paid. Posting this will also post an invoice to the Agent.


    • Related Articles

    • Reversing Agent Payouts

      IMPORTANT, please read! Fixing deals are easy but there are a few key things you have to keep in mind. One, make sure you always follow what happens at the bank level. If you fix your deal but have changed any of the amounts that have cleared your ...
    • Making changes to commissions or deductions after the payout to the agents

      In this sample deal, the transaction is closed and payments have been made out of Xero.  Scenario 1: Agent Overpayment - Agent owes the Brokerage funds In scenario 1, either the original commission and allocations can be adjusted down which creates a ...
    • Partial Payout

      To partially pay a deal, head to the payout commissions page and expand the line item to override the commissions and fees. Once you pay it out Loft will create a new payout line for the balance owing.  * Important, if you're backdating your partial ...
    • Paying Out a Deal

      When a deal closes and you receive the final funds and are ready to payout you need to ensure that you Deposit funds to the correct bank account - Once you have Deposited funds are into the correct Account you will see the balance appear under the ...
    • Adjusting your Deductions for Tax Reporting

      Determining How you will Report Whether you're reporting Gross, Full or Partial NET Commissions, you will have to adjust each deduction accordingly to how you will be reporting.  Here's the definitions for all three ways to report: Gross Commissions ...