Section 5: Deal Walkthrough

introduction and objectives in this section, we will explore the send/receive payments page in realdesk and its integration with quickbooks online (qbo) via a comprehensive walkthrough of a sample deal you will see how deposits, excess funds payments, commission payments, and intra brokerage transfers, are recorded in qbo the walkthrough also demonstrates how the deal fully balances once completed, and provides tips on how to ensure that this is the case learning objectives for this section understand how the send/receive payments page in the realdesk platform records and displays the deposits and payments associated with a deal understand how each realdesk deposit or payment translates into various qbo accounting entries understand how a deal is considered balanced once all transactions have been recorded, and how to verify via use of the qbo trial balance that this is the case recognize the importance of maintaining balanced accounts in qbo for accurate financial reporting the send/receive payments page in realdesk let’s look at a sample deal in realdesk, and the associated accounting entries in qbo this brokerage uses trust, commission trust, and general accounts the conveyancing flows are based on british columbia practice, in which excess funds are paid to the lawyer, and in which the buying brokerage receives its commission from the lawyer if not holding a deposit in other provinces, realdesk automatically adapts its payment flows, as well as its qbo integration, to the applicable standard practices send/receive payments in realdesk step 1 deposit this is a buying deal, in which our brokerage was holding a $50,000 deposit this is created in qbo as a dep journal entry, which debits the trust bank account, and credits trust liability step 2 excess funds payment to lawyer realdesk calculates that we only require a total of $14,175 ($13,500 gross commission + gst) to pay our commission, including the referral accordingly, it generates an excess funds payment of $35,825 to the buying lawyer this is created in qbo in two parts first, as a bill (representing the creation of the cheque), debiting trust liability and crediting accounts payable the associated bill payment (representing the payment of the cheque) debits accounts payable and credits the trust bank account step 3 external commission payment to referring brokerage when the agent entered the commissions for this deal into the commission calculator, he included a 10% ($1,350 + gst) referral payment to an agent at another brokerage, sutton 1st west this requires a few different entries in qbo first, we create a ci journal entry that debits trust liability and credits commission income note that since commission income is considered to be sales, the appropriate tax code (gst / 5% in bc) is applied to the credit side of this journal entry next, the payment itself is created as a bill , debiting commission expense (cost of goods sold) and crediting accounts payable note that commission expense is also tax eligible, therefore the gst collected from our previous ci entry is offset by the gst paid out here finally, the associated bill payment debits accounts payable and credits the trust bank account step 4 transfer to commission trust account having made all the required payments from the trust account, we’re ready to transfer the balance of $12,757 50 to commission trust this requires two entries to be created in qbo first, a transfer entry accounts for the movement of cash from the trust bank account to the commission trust bank account second, a txfr journal entry debits trust liability and credits commission trust liability at the conclusion of this step, we should now see in qbo that our trust bank account balance, as well as our trust liability balance, is down to zero where this deal is concerned a key element of maintaining clean books is ensuring that trust and trust liability always balance each other; if these balances get out of sync, this is a sign to investigate further step 5 internal commission payment to realtor the commission payment to our agent is the most complex part of our deal accounting, because of the brokerage’s ability to offset a commission payment with deductions and expenses we’ll break down each aspect of this process to explain how all of these transactions and entries fit together the first order of business is to ensure that, since we’ll soon be disbursing our $12,757 50 balance from the commission trust account, that we also clear off our commission trust liability to do this, we create a ci journal entry that debits commission trust liability and credits commission income note that since commission income is considered to be sales, the appropriate tax code (gst / 5% in bc) is applied to the credit side of this journal entry for the actual realtor payment, let’s first look at how it was created and calculated in realdesk we know that the agent’s gross commission is $13,500, but we already paid out 10% of this as a referral in a previous step this leaves a balance of $12,150 + gst for a total of $12,757 50, which matches our current commission trust balance this amount is offset by two additional transactions a 10% deal fee deduction ($1,215 + $60 75 gst); and an expense reimbursement ($50 + $2 50 gst) for business cards these two transactions total to $1,265 + $63 25 gst ($1,328 25), which will be our brokerage payment in the final step this leaves a net payment of $10,885 + $544 25 gst ($11,429 25) to the agent this payment is created as a bill the bill’s first line debits commission expense (cost of goods sold) note that commission expense is tax eligible, therefore the gst collected from our previous ci entry is offset by the gst paid out here the second line of the bill pertains to the 10% deal fee deduction and credits (or rather, creates a negative debit to) deal fee income, which was the qbo income account to which this deduction was mapped when it was created in realdesk’s deduction manager the third and last line of the bill pertains to the $50 expense this line credits (negative debits) undeposited funds, which would initially seem inconsistent as the qbo income account matching this expense is billable expense income why would this line not credit billable expense income? it’s because a qbo invoice has already been created for this expense; this occurs as soon as the expense is created and becomes active (outstanding) in realdesk that invoice has already credited billable expense income; therefore doing so again in the bill would over report our income crediting undeposited funds allows us to pay off the associated invoice without any income duplication as with all other bills, accounts payable represents the credit side for internal commission payments, a co journal entry is used to pay off the bill, that debits accounts payable and credits the commission trust bank account step 6 payment to brokerage (transfer to general account) our final step is quite simple as we’ve already dealt with our liability, income and expense balances we simply need to reflect the transfer of the cash for the brokerage payment from commission trust to general, with a transfer entry in qbo checks and balances part 1 qbo trial balance now that we’ve seen all the individual entries, let’s make sure that everything balances out the way it should first, we can check our trial balance in qbo key elements to validate here include trust and commission trust bank account balances are zero trust liability and commission trust liability are also zero accounts payable is zero commission income (top line revenue) and commission expense (cost of goods sold) match each other (this is important to ensure the tax collected and paid will offset each other) general bank account balance reflects the payment to brokerage deal fee income and billable expense income reflect the credited amounts from the deduction and expense, respectively gst/hst payable should be consistent with the brokerage’s net income ($1215 + $50 = $1265) multiplied by the tax rate (5%), which is correct at $63 25 checks and balances part 2 individual chart of accounts balances we can also click on each of these individual accounts to see how we got to our final result for example, we can see that trust liability was increased by $50,000 when we received the initial deposit and was subsequently debited by $35,825 from the excess funds payment, a further $1,417 50 from the referral, and the remaining $12,757 50 with the transfer to commission trust we close our deal with a trust liability balance of zero, which both makes intuitive sense, and matches our trust bank account balance from the trial balance above summary by thoroughly understanding the send/receive payments page in realdesk and its integration with quickbooks online (qbo), you can ensure precise and efficient financial management for your brokerage this walkthrough of a sample deal highlights how deposits, payments, and transfers are accurately recorded and balanced in qbo understanding and applying these principles will help you maintain clean and balanced accounts, streamline your financial processes, and support the smooth operation of your brokerage