LIMITED TIME 90% 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.
India123
Level 1

Splitting a bank account I've had for a while in Desktop

Hi

The company I work for has a checking account they have used for a number of years.  A couple of years ago We received money donated for a sister company and deposited into the checking account.  The amount has been reducing and we have a separate class to show where expenses are posted to (which company).  Now my manager wants me to split the account in Desktop so that the account reflects the remaining balance of the sister company.  Please can you tell me the easiest/simplest way to do this (without having to undo 2 years of transactions) so that they can have this going forward.

 

thank you so much

5 Comments 5
NerbynMaeI
QuickBooks Team

Splitting a bank account I've had for a while in Desktop

Managing multiple entities is crucial specifically separating the sister company's remaining balance without disrupting your existing financial history, India123. I'm here to help you maintain your accurate financial tracking.

 

Before finalizing any changes, I recommend consult your accountant to ensure the methods meet your financial reporting needs and maintain record accuracy.

 

To proceed, let's set up a new checking account specifically for the sister company in QuickBooks Desktop. This account will be used to reflect the current balance and any future transactions related to donations and expenses for the sister company.

 

For detailed steps, here's how;

 

  1. Access your QuickBooks Desktop company.
  2. Go to the Accountant menu, and then select Chart of Accounts.
  3. Below, click the Account and then choose New.
  4. Tick the Radio button beside Bank, and then click Continue.
  5. Enter all the necessary information.
  6.  Click Save & Close.

 

Once done, determine the amount that corresponds to the remaining balance for the sister company within the original checking account. Then record a transfer of this amount from the original checking account to the new one. This step will effectively move the funds while preserving the integrity of previous transactions.

 

Additionally, ensure that you continue to use the existing class tracking for identifying expenses related to both companies. This will keep financial records organized and allow for better reporting. 

 

Moreover, I'll provide these resources to help you maintain accurate financial records and address common reconciliation issues. These resources will help you troubleshoot issues and ensure a smooth reconciliation process.

 

 

Accurate financial records are essential for effective business management, and our goal is to prevent discrepancies. The Community team is always available to assist you with any QuickBooks issues you may encounter. Just Reply to this thread, and I'll be available to provide you with the assistance you need.

India123
Level 1

Splitting a bank account I've had for a while in Desktop

Thank you so much NerbynMael!

I will try this tomorrow.   I am confused how two separate accounts can be reconciled to one bank statement as the totals will not be the same.  Or will they be together in the desktop recon as one is a main and one is a sub account?

 

Thank you!

LouiseG
QuickBooks Team

Splitting a bank account I've had for a while in Desktop

Reconciling your account seems essential in your business right now, India123. Let me tackle some details to make you understand regarding reconcile separate accounts using one bank statement.

 

To achieve a precise reconciliation, it is essential to acquire two distinct bank statements, each corresponding to one of the banks involved in the accounts. This ensures that all transactions are accounted for accurately in their respective accounts. When reconciling two separate accounts in QuickBooks Desktop (QBDT) using a single bank statement isn't available.

 

If the account structure includes both a parent account and a sub-account, the total balance from the sub-accounts will automatically be consolidated into the parent account. This arrangement simplifies the accounting overview by aggregating all sub-account balances into the main parent account.

 

In addition, it is crucial to ensure that each transaction within the accounts is recorded with precision to maintain accurate financial records. As for any remaining balance that'll appear, it can be adjusted by recording a transfer or making a journal entry. This step is necessary to ensure that the displayed balance reflects the correct amount in the accounts.

 

Furthermore, I suggest seeking advice from your accountant. They can offer valuable insights into the best practices for financial management and reconciliation procedures.

 

Moreover, I've attached these articles for reference regarding troubleshooting reconciliation errors and if you need to view and export your reconciliation reports in the program: 

 

Please remember, accuracy in recording each transaction is vital to the integrity of your financial data. Should you have more questions regarding reconciliation, feel free to reach out. I am always here, ready to provide you with the information and assistance you need.

leigh2
Level 1

Splitting a bank account I've had for a while in Desktop

HI

 

I have split the account but I need to know how to reconcile with my bank statements now as the sub account does not show up.

Thanks so much in advance for your help

 

KimberlyS
QuickBooks Team

Splitting a bank account I've had for a while in Desktop

Reconciling your bank statements will depend on how transactions appear on the parent account, leigh2. The discussion below ensures you're all set with the reconciliation process to maintain the accuracy of your record.

 

There's no direct feature to split a transaction from the parent account to the subaccount in QuickBooks Desktop. If it appears as two separate entries in the parent account, reconcile the parent and subaccount individually. Otherwise, only reconcile the parent account.

 

To proceed with the reconciliation process, consider reviewing your opening balance if it's your first time. Also, ensure all financial activities from your bank statements are accurately entered in QuickBooks.

 

Here's how to reconcile your accounts:

 

  1. In the Banking menu, then select Reconcile.
  2. Choose the bank or credit card account in the Account field.
  3. QuickBooks will automatically fill in the Statement Date and Beginning Balance. If necessary, update the date to ensure it matches your bank statement.
  4. Fill in the Ending Balance, Service Charge, and Interest Earned based on your bank statement. If charges are already entered in QuickBooks, you no longer need to enter them here.
  5. Review each of the fields carefully, then click Continue.

 

QBDT_Reconciliation process.jpg

 

After that, scroll down to Step 4 in this article for complete guidance on matching your bank statements with QuickBooks: Reconcile an account in QuickBooks Desktop.

 

Whenever you want to close your books for the current fiscal year, this material will help you prepare for the next year: Year-end guide for QuickBooks Desktop.

 

Please add a reply below to stay in touch with us for other queries about account reconciliation and troubleshooting related issues in QuickBooks Desktop. We're here to provide all the data you need, ensuring you can continue your accounting tasks simultaneously.

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

Need to get in touch?

Contact us