Investigate the deals
The goal here is to either determine why you’re holding funds and if necessary release the funds. So, check the Transaction’s page to view the financials of the deal to see if a Deposit was recorded but not released, and why.
In the case of a forgotten release, read more on how to handle that here
In the case of a deposit being transferred from one deal to another here, read more on how to handle that here
*Sometimes funds are held because the sale of a property has been disputed, in that case, note this in comments so you know why you’re holding funds.
Clicking Payout Remaining will redirect you to the deals page with these preset filters
This view will show all deals with payouts remaining but if you're looking to clean up your deals, use the Closed with Payouts remaining preset filter on the dashboard instead.
You will be redirected to this preset filter on the deal’s page
Clicking that link will redirect you to this preset filtered deal’s page
This one can be a bit more complicated to solve, our suggestion is to tackle the deals that appear easier to solve, for example deal 3-2019-0066 (the excess looks like a possible commission payable amount).
In the deal’s main menu page, at first glance, it appears that an extra $5000, over the total commission amount, has been recorded.
Let’s dive deeper and head to the deal’s transaction’s page to see if the theory is correct.
Here it appears that $5000 has been recorded in the Trust/Escrow account but the Commission trust account balances to $0. You will have to investigate why the $5000 was recorded and determine if it was purposeful or a mistake. Our suggestion is to first check your bank statements to see if there was a $5000 deposit made, you may have to dig into past dates as the Trust deposit may have been recorded for the wrong date. If that is the case and you did receive $5000 on an earlier date, reopen the deal, remove the deposit and add it back recording the correct amount. Hopefully you haven’t made a manual reconciliation of this deposit in Xero/QuickBooks Online, if this is the case, you will know as you will not be able to remove the deposit in the deal and will have to unreconcile that deposit and in remove the manual transaction you created to manually reconcile the deposit. After you add back the deposit with the correct date, batch over to your accounting software and reconcile correctly. However, this does NOT fix why you have an excess of $5000, so you will have to determine if this needs to be returned back to the depositor, the Seller, or the Title Co/Lawyer to clear out this excess, to learn more about releasing funds, read here