Intermediate
How to generate financial reports on QuickBooks
Quick Answer
Generate financial reports in QuickBooks by navigating to the Reports menu, selecting your desired report type, customizing the date range and filters, then running and exporting the report. QuickBooks offers standard reports like Profit & Loss, Balance Sheet, and Cash Flow statements.
Prerequisites
- Active QuickBooks subscription
- Company file set up with chart of accounts
- Transaction data entered for the desired reporting period
- Basic understanding of financial statements
1
Access the Reports Menu
Click on the Reports tab in the left navigation panel of your QuickBooks dashboard. This will open the Reports Center where you can browse all available report categories including Company, Customers & Receivables, Sales, and Expenses.
Tip
Use the search bar at the top of the Reports page to quickly find specific report types.
2
Select Your Report Type
Choose the appropriate report category and select your desired report. For standard financial reports, go to Company section and select:
- Profit and Loss for income statement
- Balance Sheet for financial position
- Statement of Cash Flows for cash flow analysis
- Trial Balance for account balances verification
Tip
Hover over report names to see a preview description of what each report contains.
3
Set the Report Period
In the report customization panel, click the Date Range dropdown and select your desired period such as This Month, This Quarter, This Year, or choose Custom to enter specific start and end dates. The report will automatically update to reflect your selection.
Tip
Use comparative periods like 'This Year vs Last Year' to analyze trends and performance changes.
4
Customize Report Settings
Click the Customize button to modify report parameters:
- Select Display tab to choose columns and formatting options
- Use Filter tab to include/exclude specific accounts, classes, or locations
- Adjust Header/Footer settings to add company information or custom text
Tip
Create different memorized versions of the same report with various filters for different stakeholders.
5
Generate and Review the Report
Click Run Report to generate your financial report. Review the data for accuracy and completeness. You can drill down into specific line items by clicking on amounts to see the underlying transactions that make up each balance.
Tip
Always verify that your report includes all expected accounts and that the date range captures the full period you intended.
6
Export or Print the Report
To save or share your report, click the Export dropdown and choose your preferred format:
- Export to Excel for further analysis
- Export to PDF for professional presentation
- Print for hard copies
- Email to send directly to recipients
Tip
When exporting to Excel, choose 'Create new worksheet' to maintain formatting and enable advanced data manipulation.
Troubleshooting
Report shows zero balances or missing data
Verify that transactions are properly categorized and posted to the correct accounts. Check the report date range to ensure it covers the intended period. Run a Verify and Rebuild Data utility from the File > Utilities menu to fix data integrity issues.
Report takes too long to generate or times out
Reduce the date range to a smaller period or apply filters to limit the data being processed. Close other applications and browser tabs to free up system resources. Consider upgrading your QuickBooks plan if you frequently work with large datasets.
Exported report formatting is incorrect or corrupted
Try exporting in a different format (PDF instead of Excel). Clear your browser cache and cookies, then attempt the export again. Ensure you have the latest version of the target application (Excel, PDF reader) installed on your computer.
Cannot find specific accounts or classes in the report
Check that the accounts are active in your Chart of Accounts and have transactions in the selected date range. Review filter settings to ensure you haven't accidentally excluded certain account types or classes. Verify that you have proper user permissions to view all accounts.
Ready to get started with QuickBooks?
Put this tutorial into practice. Visit QuickBooks and follow the steps above.
Visit QuickBooks →