Getting statements directly from QuickBooks

QuickBooks stores your checking account transactions in your company file, and you can export them as a statement in several formats. The fastest route is to use the Account QuickReport or Transaction List by Account feature, which pulls all transactions for a specific checking account and lets you save it as a PDF or Excel file. You do not need to log into your bank separately — everything is already there if you have connected your account to QuickBooks.

The exact steps depend on whether you use QuickBooks Online or QuickBooks Desktop, since the menu locations differ. Both versions let you filter by date range, so you can pull statements for a single month, a quarter, or a full year in one download.

If you have not yet connected your checking account to QuickBooks, you will need to do that first through your bank's website or through QuickBooks' bank connection setup. Once linked, transactions download automatically, and you can then generate statements from within QuickBooks without logging back into your bank.

Key Takeaways

  • QuickBooks Online users can export checking account transactions by going to Reports, selecting Account QuickReport, choosing the checking account, and downloading as PDF or Excel.
  • QuickBooks Desktop users access the same reports through Reports menu, then Company & Financial, then Account QuickReport.
  • You can filter statements by date range before exporting, so you can pull one month or multiple months at once.
  • If your bank account is not yet connected to QuickBooks, you will need to set up the connection through your bank's website or QuickBooks' linking feature first.
  • Exported statements show all transactions QuickBooks has recorded for that account, including deposits, checks, transfers, and fees.

Steps for QuickBooks Online

Open your QuickBooks Online company file and click the Reports tab at the top left. In the search box, type "Account QuickReport" and select it from the results. A list of all your accounts will appear — find your checking account and click on it.

The report will load showing every transaction in that account. At the top, you will see a date range selector — change the dates to match the period you want to cover. Once the dates are set, look for the Export button (usually a down arrow or download icon in the top right corner). Click it and choose either PDF or Excel, depending on what you need. The file will download to your computer.

If you want a more detailed view that includes transaction memos and categories, use Transaction List by Account instead. This report shows the same data but with additional columns for reference numbers and account categories, which can be useful if you need to reconcile or audit the account.

Steps for QuickBooks Desktop

From the menu bar, click Reports, then hover over Company & Financial, and select Account QuickReport. A dialog box will appear asking which account you want to report on — select your checking account from the dropdown menu.

The report will display all transactions for that account. To narrow the date range, click the Dates button at the top of the report window and enter your start and end dates. Once the report shows only the transactions you need, click the Export button (or use File > Export) and save the file as PDF or Excel.

Desktop users can also print the statement directly to PDF by clicking File > Print, then selecting "Print to PDF" as the printer. This method works well if you just need a one-time copy for your records.

Connecting your bank account if you have not already

If your checking account is not yet linked to QuickBooks, you will need to set up the connection before you can pull statements from within the software. In QuickBooks Online, go to Settings (gear icon), then Linked Accounts, and click Link Account. Select your bank from the list, and you will be directed to your bank's login page. Sign in with your online banking credentials, and QuickBooks will ask which accounts to connect. Select your checking account and authorize the connection.

In QuickBooks Desktop, the process is similar but accessed through Banking menu > Online Banking Setup. Follow the prompts to select your bank and log in. Once the connection is complete, QuickBooks will begin downloading transactions automatically, usually within a few hours.

Some banks require you to set up a separate online banking login or enable third-party access before QuickBooks can connect. If you run into an error during setup, log into your bank's website directly and check your security settings or third-party app permissions.

What to do if transactions are missing or incorrect

If you export a statement and notice transactions are missing, the most common cause is that your bank connection has not downloaded all the data yet. Bank connections typically sync once per day, usually overnight. Wait 24 hours and try exporting again.

If a transaction appears in your bank account but not in QuickBooks, check whether it has been categorized or recorded as a transfer to another account within QuickBooks. Transfers between your own accounts sometimes appear differently in reports depending on which account you are viewing. You can also search for the transaction by amount or date using QuickBooks' search function to locate it.

If the statement shows a transaction that should not be there, or if the amounts are wrong, verify that the transaction was recorded correctly when it was entered into QuickBooks. You may need to edit or delete the entry and re-enter it. For transactions downloaded automatically from your bank, contact your bank to confirm the transaction is correct on their end before making changes in QuickBooks.

Exporting statements for tax or audit purposes

When you need a statement for tax filing, loan applications, or audits, export the full year's transactions rather than individual months. Set the date range from January 1 to December 31 of the year you need, then export as Excel. Excel files are easier for accountants and auditors to work with because they can sort, filter, and cross-reference the data.

If your accountant or auditor asks for a "bank reconciliation report" rather than a simple transaction list, that is a different report. In QuickBooks Online, go to Reports and search for "Reconciliation Report." In Desktop, it is under Reports > Banking > Reconciliation Report. This report shows which transactions have been matched to your bank statement and which are still pending, which is what most professionals need for verification.

Keep exported statements organized by year and account in a folder on your computer or cloud storage. Label them clearly with the account name, date range, and export date so you can find them quickly if you need them again.

Frequently Asked Questions

Can I export statements from multiple checking accounts at once?

No, QuickBooks generates one account report at a time. If you have multiple checking accounts, you will need to run the Account QuickReport separately for each one. However, you can export all of them in the same session and save them with different filenames to keep them organized.

What file format should I use if my accountant needs the statement?

Ask your accountant first, but Excel is usually the safest choice because it preserves all the data in a format they can sort and filter. PDF works if they just need to view and print it, but Excel gives them more flexibility if they need to analyze the data.

Do exported statements include pending transactions?

Yes, QuickBooks includes all transactions in the account, whether they have cleared the bank or are still pending. If you need to see only cleared transactions, you can filter the report by status before exporting, or your accountant can do that in Excel after you send it.

How far back can I pull statements from QuickBooks?

You can pull statements as far back as your QuickBooks company file goes. If you have been using QuickBooks for five years, you can export statements from any month in those five years. The date range selector lets you choose any start and end date within your file's history.

What if my bank connection stopped working and I have missing transactions?

Log back into your bank connection settings in QuickBooks and check the status. You may need to re-authorize the connection or update your login credentials if your bank changed its security requirements. Once reconnected, QuickBooks will download any transactions it missed, usually within 24 hours.