Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Download every QuickBooks transaction to either an Excel Spreadsheet or a Word document so I can compare the transaction to the reconciliation statements?

I can not reconcile my bank statement and quickbooks bank account, I need to track every  transaction to find my error.

2 Comments
Level 15

Download every QuickBooks transaction to either an Excel Spreadsheet or a Word document so I can compare the transaction to the reconciliation statements?

open the chart of accounts from the gear menu

find the bank account and use the selector arrow far right Run report
set the date range

at the top right of the report is an export icon

 

If you want every transaction regardless of the account source, then log in as the accountant user and export the general journal for the date range you are interested in.

 

QBO data handling capability for reporting is not adequate, if there is more than 5K records it times out and reports that you have too much data. You will have to do a journal report in date range segments, like Jan-Feb, Mar-Apr, etc etc.
How many months you can span per report is a guessing game since the report can not deal with more than 5K transactions.

Level 1

Download every QuickBooks transaction to either an Excel Spreadsheet or a Word document so I can compare the transaction to the reconciliation statements?

Thank all of you that read my question and thank you for the quick reply.  I encountered the data limit and started the process of capturing all transactions for each account.  Thanks  CCOANB - Glen

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us