Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI'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!
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:
Repeat the process for the second sub-account.
Once done, follow these steps to mark the transactions as cleared in the register manually:
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!
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.
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here