cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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.

Highlighted
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

Need to get in touch?

Contact us