Overview
QuickBooks Online has a built-in report scheduling feature that most business owners never discover. With a 5-minute setup, you can have your monthly P&L, Balance Sheet, and Cash Flow Statement emailed automatically to yourself, your business partner, or your accountant — every month, no manual export required.
Before you start
- QuickBooks Online Plus or Advanced (Essentials supports basic scheduling)
Step-by-step guide (4 steps)
Build your custom P&L report
In QuickBooks, go to Reports > Profit and Loss. Set your preferred comparison period (vs. last month, vs. last year). Customize columns and groupings to match how you think about your business.
Save the custom report
Click 'Save customization' and name it 'Monthly P&L — Auto.' This saved report is what you'll schedule.
Schedule the report
On the saved report, click the dropdown arrow next to 'Run Report' and select 'Schedule email.' Set frequency to Monthly, day to 1st, time to 7am.
Add recipients
Add your email, your accountant's email, and any business partners. Set the format to PDF and Excel for maximum flexibility.
What you'll get
Consistent financial visibility without any effort
Accountant always has current numbers
Build a historical record of monthly financials
Forces you to actually review your P&L regularly
Common mistakes to avoid
Not customizing the report before scheduling — default P&L may not match your chart of accounts
Forgetting to update recipients when your accountant changes
Frequently asked questions
Do I need coding experience to set up this QuickBooks automation?
No coding is required. This guide walks you through everything using QuickBooks's built-in features and Zapier's visual interface. If you can follow a recipe, you can follow this guide.
How long does this automation take to set up?
Most users complete this setup in 30–60 minutes on their first try. Once set up, it runs completely automatically with zero ongoing effort.
What happens if the automation fails?
Zapier and Make both have error notifications and task history, so you'll know immediately if something goes wrong. We cover troubleshooting steps in the guide above.
Can I customize this automation for my specific business?
Absolutely. The guide includes notes on common customizations. Most automations have multiple variation points — timing, conditions, notification recipients, and more.