
Preview: 11 accounts made for marketing & creative agencies
On top of the standard core accounts every business needs (bank, payroll, taxes, equity).
| # | Account | QBO type | Detail type |
|---|---|---|---|
| 1110 | Unbilled Receivables (WIP) | Other Current Assets | Other Current Assets |
| 2175 | Client Retainers / Deferred Revenue | Other Current Liabilities | Other Current Liabilities |
| 2178 | Client Media Funds Held | Other Current Liabilities | Other Current Liabilities |
| 4000 | Retainer Fees | Income | Service/Fee Income |
| 4010 | Project Fees | Income | Service/Fee Income |
| 4020 | Media Management Fees | Income | Service/Fee Income |
| 4030 | Pass-Through Media Billings | Income | Service/Fee Income |
| 5000 | Freelancers & Contractors | Cost of Goods Sold | Cost of labor - COS |
| 5010 | Pass-Through Media Costs | Cost of Goods Sold | Other Costs of Services - COS |
| 5020 | Production Costs | Cost of Goods Sold | Other Costs of Services - COS |
| 6670 | Creative Software & Stock Assets | Expenses | Dues & subscriptions |
Setup tips included
Recommended tracking: Use Classes for service line (Creative / Paid Media / Web) and Projects for each client
- Report agency gross income (revenue minus pass-through media) - it is the true size of the agency.
- Keep client media money in a liability account if you hold it before paying platforms.
- Track freelancer cost by project for project margins.
How it works
Buy securely. Checkout is handled by Stripe.
Download. Your link arrives by email right after payment.
Import. In QuickBooks Online go to Settings > Import data > Accounts and upload the CSV.
Report. Enter balances in the workbook and your statements are done.
Questions
Can I import this chart of accounts into QuickBooks Online?
Yes. Upload the included CSV in QuickBooks Online under Settings, Import data, Accounts. Every account already has a valid QuickBooks Online account type and detail type.
Does it include financial statements?
Yes. The pack includes a fill-in workbook: type your balances once and the Income Statement, Balance Sheet, Cash Flow Statement and key ratios build themselves, with balance checks.
Will it overwrite my existing accounts?
No. Importing adds accounts. Review the list in Excel first and delete any rows you do not need before you upload.
How do I get the files?
Checkout is handled by Stripe. Your download link arrives by email right after payment.
Other industries
Need it set up for you? Book a QuickBooks Advisory session.
Independent templates by Stephennohga. Not affiliated with, endorsed or sponsored by Intuit Inc. QuickBooks and QuickBooks Online are trademarks of Intuit Inc. General bookkeeping guidance, not tax, legal or audit advice.