Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
GabeFleming
Level 1

Main/Sub Bank accounts and reconciling

I'm currently facing an issue with my reconciliation process in QuickBooks, and I'm hoping someone here can provide some guidance.

 

As a rep-payee, I recently received permission from the SSA to utilize a collective account to manage funds for multiple individuals. In QuickBooks, I have set up a Parent bank account with several Child bank accounts attached to it to keep track of each individual's ownership.

 

Here's where I'm encountering a challenge: I made a deposit for two different individuals, and I forgot to request the teller to split them up. So when the bank statement arrived, I was unable to correctly match the 1 transaction with the 2 transactions that were displayed in the parent account.

 

Ideally, I would like the deposit to show as a single deposit in the Parent account, while also being split up into the respective Child accounts for each individual in QuickBooks. For example, if I made a $200 deposit for 2 different people, I want the parent account to show $200, while the child accounts show $80 and $120 respectively. This was my reconciliation will look clean, and I can also keep track of how much money each person has in the child accounts. 

 

I'm wondering if anyone has experience with a similar situation or if QuickBooks has a feature that allows for such transaction splitting. Any advice or workaround suggestions would be greatly appreciated.

Thank you in advance for your help!

4 Comments 4
ShyMae
QuickBooks Team

Main/Sub Bank accounts and reconciling

I've got the information you need, GabeFleming. I'm here to help you achieve your desired outcome. 

 

Currently, QuickBooks Desktop does not have a direct feature to split transactions from a parent account to different sub-accounts. However, there's a workaround that can help you achieve the desired outcome.

To address this issue, the best approach would be to exclude the bank transaction first. After excluding the transaction, you can create separate deposits for each of the sub-accounts. While this process may involve additional steps, it will enable you to maintain clean reconciliation records and ensure accurate tracking of funds for each individual.

Here's how:

 

  1. Go to Banking, then select Make Deposits.
  2. In the Deposit To column, select the sub-account you want to put the deposit into
  3. From the Received From column, choose your customer. 
  4. Enter the date you deposited at your bank.
  5. Once done, tap Save & Close.
     

Repeat the process for the second sub-account. 

 

Once done, follow these steps to mark the transactions as cleared in the register manually:
 

  1. Go to Lists, then select Chart of Accounts
  2. Find the account you want to review.
  3. From the ✔ column, click the blank space until the ✔ is visible. It means that the transaction is now cleared. 
     

I'm adding this article for you to have a guided when you reconcile your account in QuickBooks Desktop: Reconcile an account

 

You can reach out again if you require additional help or clarification regarding your transactions. I'm always here to help you. Best wishes!

GabeFleming
Level 1

Main/Sub Bank accounts and reconciling

Thanks for the reply!

 

But I don't actually see how this fixes the issue that I am having. When I go to reconcile, I reconcile the parent account, not the child accounts. Following the process that you are describing, this will still show up as two separate transactions instead of one. 

GabeFleming
Level 1

Main/Sub Bank accounts and reconciling

Thanks for your reply!

 

But I don't see how this is supposed to fix my problem. When I go to reconcile the parent account, this will still show two separate transactions instead of one. 

SirielJeaB
Moderator

Main/Sub Bank accounts and reconciling

I'm glad you returned to the discussion and provided more clarifications. I'll offer additional details regarding this query.

 

I understand the importance of being able to carry out QuickBooks activities efficiently. Please be aware that the feature to split bank balances between child accounts, reconcile them individually, and show them as one reconciliation in your Parent account is not supported in QuickBooks Desktop (QBDT) because it is a designed function of the program.

 

You may consider following the steps provided by my colleague above for your workaround.

 

You can also find information and monitor your bank transactions in QBDT by running banking reports and personalizing their data.

 

I'm always prepared to get back to you if you have further questions when handling your transactions within the program. Simply keep me posted by commenting below or reposting the Community section. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us