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.
ShannonSNichols
Level 2

Exporting checks and other lists

HI, 

 

We were previously using Desktop and then migrated over to Online Advanced and after speaking with several consultants, Online is just not for us and our business.   We are going to go back to our Desktop version but have 2.5 weeks worth of checks and deposits to get back into the Desktop version.  Is it possible to export those two activities lists and then import them into Desktop?  I am inclined to say yes, right away, becuase we used to use the batch entering feature in Desktop all the time, my uncertainty is the Online version

Solved
Best answer January 12, 2022

Best Answers
JonpriL
Moderator

Exporting checks and other lists

I'll be here to help export your list of transactions, @ShannonSNichols.

 

Let's pull up and customize one of the transaction detail reports to see a list of check or deposits and export it. I'll show you how.

 

  1. Go to Reports.
  2. Under For my accountant, select Transaction Detail by Account.
  3. Click Customize.
  4. On the Filter menu, select Account and Transaction Type.
  5. Below the Account menu, select the bank account where the checks or deposits are recorded.
  6. Select Check or Deposit on the Transaction Type selection to export the file showing only one list of entries.
  7. Click Run report.

 

Here's the articles you can read to learn more about customizing and exporting your report:

 

 

From here, open the Excel file and remove certain columns to match it with the required columns in entering a batch transaction in QuickBooks Desktop.

 

I've also included this reference helpful with the steps needed to identify how stable is your business's financial status: Create and Manage Reports in QuickBooks Desktop.

 

You can always leave a comment below if you have follow-up questions with this or start a new thread if you have any other concerns. I'll be here to lend a hand. Stay safe!

View solution in original post

1 Comment 1
JonpriL
Moderator

Exporting checks and other lists

I'll be here to help export your list of transactions, @ShannonSNichols.

 

Let's pull up and customize one of the transaction detail reports to see a list of check or deposits and export it. I'll show you how.

 

  1. Go to Reports.
  2. Under For my accountant, select Transaction Detail by Account.
  3. Click Customize.
  4. On the Filter menu, select Account and Transaction Type.
  5. Below the Account menu, select the bank account where the checks or deposits are recorded.
  6. Select Check or Deposit on the Transaction Type selection to export the file showing only one list of entries.
  7. Click Run report.

 

Here's the articles you can read to learn more about customizing and exporting your report:

 

 

From here, open the Excel file and remove certain columns to match it with the required columns in entering a batch transaction in QuickBooks Desktop.

 

I've also included this reference helpful with the steps needed to identify how stable is your business's financial status: Create and Manage Reports in QuickBooks Desktop.

 

You can always leave a comment below if you have follow-up questions with this or start a new thread if you have any other concerns. I'll be here to lend a hand. Stay safe!

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

Need to get in touch?

Contact us