cancel
Showing results for 
Search instead for 
Did you mean: 
LMO88
Level 1

How to categorize a bank transfer from another bank account for the same business

This is a real estate franchise that uses 2 separate business bank accounts to process transactions per franchise guidelines; Operating account and Commissions account. I am using Quick-books Online and using bank feed (thankful for this feature).

 

Transfer 1:

Sometimes, agent commission is deposited to the Operating account because it includes a transaction fee which is income to the Brokerage. I split income between Transaction Fee Income and Commission Income then record the commission amount as a transfer from Operating account to Commissions account. I match the transfer in the Commissions account. Should I perform this differently? Everything balances but I'd like to get a second opinion.

 

Transfer 2:

There are multiple transactions to 1 commission. Sometimes, the real estate agent does not charge the transaction fee described above so it is deducted from their commission as well as any reimbursed expenses paid by the brokerage. These funds create a transfer to the Operating account. How do I perform this transfer and have the ability to categorize this income. Performing a transfer I am unable to categorize income. I cannot split this from the original deposit of the commission because it has not been accounted for like example above, it has to be taken from the agents commission split.

 

I hope I've explained this the best way possible without confusion. 

Thank you in advance!

Laura

6 Comments 6
JessT
Moderator

How to categorize a bank transfer from another bank account for the same business

Hi Laura!

 

Yes, you've explained everything in detail, and I appreciate your effort. I'm also glad to know that you like the online banking feature! I personally like it as well because it's a time-saver.

 

You do a great job of making transfers for the Transfer 1 situation. I have nothing to add to your process.

 

In the Transfer 2 situation, you can do the same thing, but you'll want to determine how much is for the transaction fee and the reimbursement, so you can do the split. If you really can't, you can deposit the whole amount as commission. Then, do a journal entry to move the sum of the transaction fee and the reimbursement to the Operating account later on, instead of doing transfers. Please have an accountant check your entries.

bank deposit (2).PNG

transfer.PNG

 

You can check the Profit and Loss and Balance Sheet reports after.

 

Let me know if you need more help with your bank transactions. You can comment anytime. We're just around 24/7.

LMO88
Level 1

How to categorize a bank transfer from another bank account for the same business

So I have to split the deposit and specify each income account at the same time, ok. What if the gross commission is a transfer from the Operating account which includes these "expenses to the agent" that are income to the brokerage, this is the 2nd transfer I'm trying to figure out.

LMO88
Level 1

How to categorize a bank transfer from another bank account for the same business

If I can't split this income at the deposit and instead create a journal entry for each "transfer" to categorize each item, what do I do with the transfers coming from the Commission Account?

Angelyn_T
Moderator

How to categorize a bank transfer from another bank account for the same business

Thank you for getting back to us here on the Community page, @LMO88.

 

If you'll be creating a journal entry to categorize each item accordingly, you can delete the transfer/s recorded from the Commission Account to avoid duplicated records.

 

  1. Locate the transfer transaction from the Search field.
  2. Click on Advanced Search.
  3. Select Transfer beside Search then hit the search button beside Add Filter.
  4. Look for the transaction, then click it to open.
  5. Tap Delete from the More button to fully remove it.

a9 1.PNGa9 2.PNGa9 3.PNG

 

For more information about creating transfers or journal entry in QuickBooks Online, check out these articles:

Keep in touch with me if you still need more help with this. I'll be here. Have a good day!

LMO88
Level 1

How to categorize a bank transfer from another bank account for the same business

Hi Angelyn, if I delete this transfer from the Commission Account. How will I be able to reconcile this account? 

ReymondO
Moderator

How to categorize a bank transfer from another bank account for the same business

Thanks for getting back to this thread, @LMO88.

 

You're can still reconcile this account in a usual process. Since you're creating a journal entry, we need to delete the Transfer that you made. This is to make sure that there aren't any duplicate transaction when you reconcile the account.

 

Also, deleting it will not affect the entire reconciliation process. The journal entry that was created will replace the Transfer, so the amounts are still correct.

 

Here are the steps on how to record journal entries in QuickBooks Online:

 

  1. Click + New.
  2. Select Journal entry
  3. Fill out the fields to create your journal entry.
  4. Select Save and new or Save and close.

 

I also recommend reaching to your accountant for further advice on what entries you should use to properly record the payment.

 

In addition, you can run the Account QuickReport to review your account in QuickBooks. This way, we can make sure that all of your transactions are accurate before reconciling the account. Just go the Accounting menu and select Chart of Accounts. Then, click the account's drop-down arrow under the ACTION column and select Run report.

 

Don't hesitate to tag my name in the comment section below if you have other concerns or questions. I'm always ready to help.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us