Trust Liability
Since most deals in real estate close at month-end, the situation can arise where you have more money in your trust account (G/L acct #'s 10002 & 10005 in default chart of accts) than you have in your trust liability account (G/L acct #21300).
This situation arises because when the deal closed, Lone Wolf relieved the trust liability as part of the accounting entries, but the trust funds aren't affected until you actually write the cheque to transfer the funds.
So at the moment that you close the deal, the trust funds are still in the trust bank account but the liability no longer exists. The fact that you have more money in trust than in the liability is not necessarily wrong; this is simply a matter of timing. If this occurs at year-end, most accountants will include the excess as part of your cash balance on your financial statements. No entry is required because it will bring itself back into balance when you write the trust cheque transferring the trust funds.
If you find that this problem has arisen without you noticing, you should print the "Analysis of Deposits" report for the date of your most recent trust bank reconciliation report from the Trust Menu (3.A.). This report can be compared, deal by deal to the trust ledger on your bank reconciliation (3.8). Once you identify the differences, you must then review the trust and G/L activity for that deal (F.3) to determine the cause. You can also send that deal to the support department by attaching it to a Support Request Form located in the HELP drop-down menu in the Realty Management System.
The Trust S/L column on the 3.A report represents the balance in the trust sub-ledger. The Amount column represents the balance in the liability account (#21300), for this trade. The Trust Funds Held section of this report lists all the trades with funds still in the Trust sub-ledger and the associated liability.
The No Funds Remaining section lists entries with no funds in the trust sub-ledger, but outstanding liability. This can include deals where trust was kept instead of refunding, journal entries, or any other entry posted against 21300. In the example above, the liability for this deal has been corrected using a journal entry, you can apply that J/E to a deal, by going into 3.A and clicking on the Assign Trans/Trade button, this will show the MISC entries with no deal associated and allow you to edit and assign the deal. This will clean up the items at the bottom of the 3.A report.
|