Combining or merging QB files for the same company

Thank you!

So if I understand correctly, an accountant version of QB Desktop would allow him to merge the files instead of the other way around (me trying to merge his into my file), correct?

I need to merge my client's data - I have been maintaining the the general ledger in Desktop 2022 Premier Accountant and providing payroll service for the client. I have been successful with getting the client's data into QBO. They have only used QB for invoicing, etc. and I want to integrate it with my G/L data. Instructions will be deeply appreciated.

@Loki99 

Do you need to merge 2 QBO accounts into a single one?

I have a solution to achieve your goal, @Loki99. 

Thanks for the detailed scenario. I'll help integrate your General Ledger data into your client's QuickBooks Online account.  

You'll need to export your General Ledger report into a CSV file. Then import them into your client's account. 

Here's how: 

1. Go to the Reports menu and select Accountant & Taxes. 
2. Choose the General Ledger report.
3. Customize the Dates and Report basis. 
4. Click the Excel drop-down, then Create New Worksheet or Update Existing Worksheet. 
5. Pick Create a comma separated values (.CSV) file. 
6. Hit Export. 

For more details, see this link: Import and export data in QuickBooks Desktop.

To import, here's how: 

1. Go to the Gear icon and choose Import data. 
2. Pick a Chart of accounts, click the Browse tab, and open the CSV file you saved. 
3. Hit Next and map the data accurately. 
4. Follow the on-screen instructions.

Furthermore, check out the article below on how to manage General Ledger and reports in QuickBooks: 

• General Ledger: Meaning, Classification, and Examples
• Understand reports in QuickBooks Desktop

You can reply to this thread anytime if you have follow-up questions or other QuickBooks concerns. I'm happy to provide a solution. Keep safe always, @Loki99. 

Since this client's books have been closed for 2022 and taxes filed should I only merge the 2023 GL data to date? Also, will this cause a duplication of income for Q1?

I appreciate for getting back to us, Loki99. 

During the preceding accounting period, closed books secure financial data to prevent unwanted changes from disrupting the previous year's activities. 

That said, merging only the 2023 GL data to date is much better. Please ensure that all transactions must be dated after the closing date to avoid duplications. 

I've included the following resources to help you learn how to produce information accurately and keep the same report settings for future use:

• Customize reports in QuickBooks Desktop.
• Create, access and modify memorized reports.

Please let me know if you have any further questions. I'll continue to be here to help.

When I try to import the .csv file I am getting a message that the file length exceeds 1000 rows it's 1224 rows.

Should I try to separate it and import Balance Sheet and Income/expense accounts to reduce the file size?

I've tried unsuccessfully to follow your instructions but there are no choices in the drop down to enter lines containing transaction data - only 1 account name was imported. Is there anyway to avoid having to reenter every transaction?

I know you're putting so much effort and time into resolving your concern, @Loki99.

I'm here to ensure you get routed in the right direction of support to resolve this issue with QuickBooks Desktop. 

Since you're unable to see options when trying to enter lines containing transaction data, I recommend reaching out to our QuickBooks Desktop Support. They'll be able to access your account safely during a screen-sharing session to investigate your concern and give you a possible fix for this query.

Here's how you can reach out to them:

1. Go to the Help menu, then select QuickBooks Desktop Help.
2. Select Contact Us.
3. Please give a brief description of your issue, then select Continue, and then choose a way to connect.
   
   

You can check our available hours when contacting support to ensure we address your concern promptly.

Also, I'll share with you this article to learn how to fix data damage on your QuickBooks Desktop company file: Fix data damage on your QuickBooks Desktop company file.

Feel free to visit again in the Community if you have any other QBDT-related concerns. I'm determined to help you succeed. Keep safe always.

@Loki99 

Last resort, purchase a 3rd party service.