cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Joe2030
Level 1

Bank Registers in Quick Books

Hi! I have multiple bank accounts in QuickBooks and I want to download all the bank registers, currently i am downloading bank register individually for each bank is there any way to download all the banks register in one go from Quickbooks to excel with all the required fileds like Class,property,Reconciliaiton status etc. I will appreciate if someone can guide me in this regard. Thanks

2 Comments 2
JamaicaA
QuickBooks Team

Bank Registers in Quick Books

Good work exporting your bank register for each financial institution linked to QuickBooks, Joe2030. There's a way to get the data you need with all the required fields, and I'll share the details below.
 
You can customize the bank register to show class, property, reconciliation status, etc. Follow the steps below to export them:
 
  1. Go to the Transactions menu on the left panel.
  2. Select the Bank Transactions tab and choose the bank account.
  3. Click the Funnel icon and set the reconciliation status, transaction type, payee, and date.
  4. Tap Apply.
  5. Press the small Gear icon in the right corner.
  6. Tick the checkboxes for Class, Property, and Reconcile Status.
2.png

 

Once done, the bank register will display the columns we've added or applied. If everything's set, you can hit the Export to Excel icon.
3.png

 

However, if you're referring to incorporating all the bank registers from different financial institutions, the ability to do so is currently unavailable. I recommend sending a feature request to our Product Development Team. We're interested in your ideas to provide convenience with our processes.
 
Here's how:
 
  1. Go to the Gear icon at the top.
  2. Under the Profile column, select Feedback.
  3. Share your recommendation with the product, then click Next.

 

In the meantime, consider combining all that information into an Excel file for easier storage.
 
To learn what more you can do, check out these references:
 
 
Bookmark this material for more methods of getting your data from the program to a zip file: Export reports, lists, and other data from QuickBooks Online.
 
Your thoughts matter in the enhancement of the program. Count on us for assistance with transporting your entries. We'll be here for you.
FishingForAnswers
Level 10

Bank Registers in Quick Books

@JamaicaA  This entire thing reads like two responses blended into one, neither of which really address what the OP is asking about.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us