Course home / Templates & Resources

Templates & Resources

The templates referenced throughout the course, ready to download. CSV files open directly in Excel or Google Sheets — adjust columns and categories to fit each client.

Client Onboarding Checklist

The new-client setup list from Module 1 — dashboard health check, customer import, items, chart of accounts, bank connections, and settings.

CSV · first used in Module 1
Download

Customer Import Sheet

A clean template matching QBO's customer import columns, for bulk-importing or cleaning up a client's customer list.

CSV · first used in Module 1
Download

Chart of Accounts Mapping Sheet

Track each account's type, purpose, and what to do with it (keep, rename, merge, or deactivate) when cleaning up a client's chart of accounts.

CSV · first used in Module 1
Download

Collections Tracker

One row per overdue invoice: amount, due date, days past due, last contact, and the next action — pulled from the A/R Aging report.

CSV · first used in Module 2
Download

Month-End Close Checklist

The ten-step close sequence from Module 5, with status and notes columns so nothing gets missed from one month to the next.

CSV · first used in Module 5
Download

Reconciliation Discrepancy Log

Document every reconciliation difference you find: the statement amount, the QBO amount, the cause, and the fix applied.

CSV · first used in Module 4
Download

Client Report Cover Note

A short fill-in-the-blanks email template for delivering a month-end reporting package, summarizing net income, A/R, and any open items.

Text template · first used in Module 5
Download