Workbook Templates

Start with a working workbook

Copy a template to your Drive, connect your QuickBooks company, and every report inside fills with your numbers — then stays current with automatic refreshes.

A
B
C
D
Jan
Feb
Mar
Income
84,210
91,406
97,152
Cost of Goods Sold
31,948
34,102
35,880
Gross Profit
52,262
57,304
61,272
Expenses
38,115
39,842
41,030
Net Income
14,147
17,462
20,242
P&L Dashboard
Profit & Loss
Accounts
Synced with QuickBooks

Profit & Loss Dashboard

A ready-made P&L dashboard built on a live Profit & Loss report — revenue, margins, and expense trends that refresh from QuickBooks on your schedule.

Use this templateFree — preview it, then copy to your Drive
A
B
C
D
Jan
Feb
Mar
Opening Cash
182,410
198,914
204,102
Cash In
64,208
61,882
70,415
Cash Out
-47,704
-56,694
-61,225
Net Change
16,504
5,188
9,190
Closing Cash
198,914
204,102
213,292
Cash Dashboard
Cash Flow
Balance Sheet
+4 more
Synced with QuickBooks

Cash Dashboard

Cash position and runway at a glance — built on live Cash Flow, Balance Sheet, and General Ledger reports, with A/R aging to show what’s coming in.

Use this templateFree — preview it, then copy to your Drive
A
B
C
D
Current
1–30
31–60
Acme Landscaping
4,800
2,150
Brightside Dental
12,400
1,975
Cedar & Stone LLC
3,300
870
Total A/R
20,500
3,020
1,975
Dashboard
AR Aging Summary
AR Aging Detail
Synced with QuickBooks

A/R Aging

See who owes you and how overdue it is. Customer balances bucketed by age, with a detail tab of the underlying invoices — always current with QuickBooks.

Use this templateFree — preview it, then copy to your Drive
A
B
C
D
Current
1–30
31–60
Northwind Freight
6,120
1,480
Bluebird Utilities
2,340
410
Summit Office Supply
1,895
625
Total A/P
10,355
2,105
410
AP Dashboard
AP Aging Summary
AP Aging Detail
Synced with QuickBooks

A/P Aging

Track what you owe and when it’s due. Vendor balances bucketed by age, with bill-level detail behind every number — refreshed automatically.

Use this templateFree — preview it, then copy to your Drive

How templates work

  1. 1

    Copy a template

    Pick a workbook below — browse the full preview, then click “Use template” to copy it to your Google Drive.

  2. 2

    Connect QuickBooks

    Install the Runbook add-on from the sidebar prompt and connect your QuickBooks company.

  3. 3

    Reports fill with your numbers

    Runbook adopts every report in the workbook and refreshes it from QuickBooks on your schedule.

Ready to Get Started?

Install Runbook from the Google Workspace Marketplace, or book a demo to see it in action.

Intuit App Partner — SilverAvailable on Google Workspace MarketplaceAvailable on the QuickBooks App Store