Skip to main content
S
ShannonSNichols
January 12, 2022
Solved

Exporting checks and other lists

  • January 12, 2022
  • 1 reply
  • 0 views

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

Best answer by JonpriL

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!

1 reply

J
JonpriLAnswer
January 13, 2022

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!

Terms & ConditionsAccessibility statement