How to Build Your Agency Chart of Accounts in QuickBooks Online
You opened QuickBooks Online a year ago, accepted the default chart of accounts, and got back to running the agency. The books were "set up." A bookkeeper your friend recommended was categorizing transactions every month. Your P&L showed revenue and expenses and everything balanced.
And now you are sitting in QBO at 9 PM on a Sunday wondering why your gross margin number does not look anything like what your agency friends quote on podcasts, why your retainer revenue and your project revenue are smashed together in one line, why your monthly P&L shows $180,000 in revenue but you cannot make payroll without dipping into the line of credit, or why every time a client pays an upfront media budget, the books look like you had a great month, even though none of that money is actually yours.
The books are not lying to you; the chart of accounts is. The default QuickBooks Online chart of accounts is built for a generic small business that sells one or two things and pays its own expenses. An agency is none of those things.
An agency runs four different revenue streams, moves client money through its own accounts, blends W-2 staff with contractors and freelancers, and has to separate delivery work from overhead to know whether the business is actually profitable. None of that is reflected in the default setup, and no amount of careful transaction categorization will fix a chart of accounts that was never built to surface the numbers that matter.
This post is the practical companion to our pillar post on bookkeeping for marketing agencies. That post covers the why, the theory behind Agency Gross Income (AGI), and what your monthly financials should be telling you. This post covers the how. By the end of it, you will know exactly which accounts to set up in QuickBooks Online, in what order, and how they connect to produce a P&L that finally tells you the truth about your agency.
Why your default QBO chart of accounts is broken for agencies
QuickBooks Online ships with a chart of accounts built around the assumption that you are running a generic service or product business. It gives you one or two revenue lines, a basic cost of goods sold section, and a long alphabetical list of operating expenses. That setup works fine for a coffee shop or a freelance consultant. It does not work for an agency, and the reason is structural.
An agency has four distinct revenue streams that behave differently and need to be tracked separately: retainer revenue, project revenue, hourly or time-and-materials revenue, and pass-through revenue from client media and vendor spend. The default QBO setup gives you one revenue line. Which results in everything getting blended together and you losing the ability to see which side of your business is paying the bills.
An agency also moves client money through its own accounts in ways a generic business does not. When a client gives you $40,000 to run on Meta ads next month, that money hits your bank account, and if your bookkeeper records it as revenue, your books will show you had a $40,000 better month than you actually did. The same problem happens with white-label vendor work, print buyouts, production pass-throughs, and any other expense you front and bill back. Without a chart of accounts that separates pass-throughs from real revenue, your P&L will swing wildly month to month for reasons that have nothing to do with the actual performance of the business.
The third issue is that the default QBO setup mixes delivery costs with overhead. Delivery costs are the labor and tools that go into client work. Overhead is everything else: founder salary, accounting, legal, sales and marketing for the agency itself, rent, and software for the back office. These two need to be separated, because the ratio between them is one of the clearest signals of whether your agency is structured correctly. When they are blended together, you cannot see whether your delivery team is over-leveraged, whether your overhead is bloated, or whether you are pricing your work at margins that actually support the business.
The fix is not complicated, but it does require rebuilding the chart of accounts from the top.
The five sections your agency chart of accounts needs
Before opening QuickBooks Online, it helps to understand the structure you are building toward. A working agency chart of accounts has five sections, in this order on the P&L:
First, revenue. Four separate lines for retainer revenue, project revenue, hourly revenue, and pass-through revenue. The first three are real agency revenue. The fourth exists so you can subtract it later.
Second, pass-through expenses. A dedicated section that mirrors the pass-through revenue line above. This is where client ad spend, white-label vendor costs, and production pass-throughs live.
Third, AGI subtotal. Total revenue minus pass-through expenses. This is the line that matters. QuickBooks will not automatically generate this, so you will need to set it up using account groupings that produce a calculated subtotal on the P&L report.
Fourth, delivery costs. The labor and tools used to actually do client work. Payroll for delivery staff, freelancer and contractor payments tied to client work, and software like Adobe Creative Cloud, Figma, ad management platforms, and project management tools.
Fifth, overhead. This is everything not directly tied to client work. Founder salary, sales and marketing for the agency, administrative software, rent, utilities, accounting and legal fees.
Below overhead is your operating profit, which is the bottom-line agency profitability number. The Parakeeto benchmark for a healthy agency is 25 percent operating margin against AGI, with anything above 15 percent considered reasonably healthy.
Once these five sections exist in QuickBooks Online and your transactions are categorized into them, your monthly P&L will show you AGI, delivery margin, and operating margin every time you open it. Without this structure, those numbers will stay invisible no matter how clean your transaction categorization is.
Step one: setting up your revenue accounts
Open QuickBooks Online and navigate to your chart of accounts. You will find this under the gear icon in the upper right, then "Chart of Accounts" under the Your Company column. This is where you will be doing all of the work that follows.
Find your existing revenue accounts. Most agencies have one or two. You will be replacing them with four new revenue accounts.
Click "New" in the upper right of the chart of accounts page. Set the account type to Income. For the detail type, choose Service/Fee Income. Name the account "Retainer Revenue." Save it.
Repeat this process three more times, creating accounts called "Project Revenue," "Hourly Revenue," and "Pass-Through Revenue." All four should be income accounts with the same detail type. The naming matters because these labels will appear on every P&L you produce, and you want them to be unambiguous.
A few notes on each.
Retainer Revenue should capture all recurring monthly fees in exchange for ongoing service. This is your most predictable revenue line and the one most agencies want to grow. Every recurring monthly invoice for ongoing work goes here.
Project Revenue captures one-time engagements with a defined scope and end date. Milestone-based payments on fixed-fee projects go here.
Hourly Revenue captures time-and-materials work, common in consulting-heavy agencies and uncommon in modern creative agencies. If you do not invoice hourly, you can skip this account or keep it dormant for the rare exception.
Pass-Through Revenue is where client ad spend, vendor costs, and production pass-throughs are recorded when they hit your account. This line will be offset by an equal expense line below, but it has to be tracked separately so AGI can be calculated.
Once these four accounts exist, go back to your existing revenue accounts and either rename or merge them into the new ones. QuickBooks lets you merge accounts by editing the older one and renaming it to match the new one exactly. The system will prompt you to confirm the merge. This carries forward your historical data without losing it.
Step two: setting up your pass-through expense accounts
The pass-through expenses section lives in your cost of goods sold area, not your operating expenses. This placement matters because it positions pass-throughs above your AGI calculation on the P&L, which is what allows AGI to be calculated correctly.
Click "New" in your chart of accounts, and set the account type to Cost of Goods Sold. For the detail type, choose Supplies and Materials – COGS or Other Costs of Services, depending on what your QBO subscription offers. Name the account "Client Ad Spend."
Create three more accounts the same way: "White-Label Vendor Costs," "Production Pass-Throughs," and "Other Pass-Through Costs." All four should sit in cost of goods sold, not in operating expenses. This is where most agencies get this wrong, and it is the single biggest reason their P&L misrepresents the business.
The discipline going forward is that any expense you front and bill back to a client lives in one of these four accounts.
Meta ad spend on a client's account, Google Ads, programmatic buys, podcast sponsorship media buys, all of that is Client Ad Spend.
White-label work from a development shop, a video production crew you sub out to, or a paid media agency you partner with is White-Label Vendor Costs.
Print buys, prop rentals, location fees, and physical production costs are Production Pass-Throughs. Anything else you bill through is Other Pass-Through Costs.
For deeper detail on how to handle pass-through ad spend specifically, including how to invoice it cleanly to keep the offsetting entries equal, see How to Handle Client Ad Spend in Your Agency P&L.
Step three: separating delivery costs from overhead
This is the section that most agencies have set up wrong, because the default QBO chart of accounts dumps all expenses into one alphabetical list under operating expenses with no distinction between delivery work and overhead.
Delivery costs are the labor and tools used to deliver client work. Create new expense accounts for the categories that apply to your agency: "Delivery Payroll" for W-2 staff who do client work, "Contractor & Freelancer Payments" for 1099 contractors who do client work, "Delivery Software" for tools like Adobe Creative Cloud, Figma, Asana, Monday.com, ad management platforms, and any other tool that exists specifically to support delivery.
Overhead costs go into separate accounts: "Founder & Admin Salary" for owner’s payroll and administrative payroll, "Agency Marketing & Sales" for ad spend on the agency itself, sales tools, and content production, "Office & Facilities" for rent, utilities, and office supplies, and "Professional Services" for accounting, legal, and any other back-office services.
The discipline is straightforward but requires consistency. Every payroll run gets split between Delivery Payroll and Founder & Admin Salary based on what the person actually does. Every software subscription gets categorized as Delivery Software or back-office software based on whether it is used to do client work or to run the agency. Every contractor invoice gets categorized as Contractor & Freelancer Payments or another overhead category based on whether the work was for a client or for the agency itself.
This is the categorization work that pays off every month when you open your P&L and can immediately see your delivery margin and your operating margin without doing mental math.
How to migrate from your current chart of accounts without losing history
The most common reason agencies do not rebuild their chart of accounts is the fear of losing historical data or breaking ongoing reports. This concern is valid but solvable.
QuickBooks Online lets you merge accounts to preserve history, and it lets you renumber and reorganize accounts without affecting transactions already recorded. The migration process generally looks like this.
Start by creating all the new accounts described above without deleting anything from the existing chart of accounts. This adds new structure without disturbing the old one. Then go through your most recent three months of transactions and recategorize them into the new accounts, one bank feed at a time. This gives you a clean recent history under the new structure. From there, you can either go back further to recategorize older transactions or accept that older data lives under the previous structure and move forward.
For most agencies, recategorizing the trailing three to six months is enough to produce a clean P&L going forward without spending a month of nights and weekends rebuilding two years of history. The key is committing to the new structure from a specific date forward and being disciplined about categorization from that point on.
If you have ongoing financial reports or KPI dashboards built off your existing chart of accounts, you will need to update those reports to point to the new accounts. This is usually a thirty-minute job in QuickBooks Online and a similar effort in any external dashboards or reporting tools.
Common mistakes when rebuilding an agency chart of accounts
A few patterns come up over and over again when agencies attempt this rebuild on their own.
The first is putting pass-through expenses in operating expenses instead of cost of goods sold. When pass-throughs sit in operating expenses, they end up below your delivery costs on the P&L, which means AGI cannot be calculated cleanly and your delivery margin will be distorted by pass-through volume month to month. Pass-throughs belong in cost of goods sold, above your AGI calculation.
The second is creating too many revenue accounts. Some agencies try to create a separate revenue account for every service line or every client. This produces a P&L that is impossible to read and serves no analytical purpose. Stick with the four revenue lines (retainer, project, hourly, pass-through) and use class tracking or sub-customers to capture client and service line detail. Keeping the chart of accounts clean and using QBO's other features for granular tracking is the right approach.
The third is mixing delivery payroll with founder and administrative payroll in the same account. Most founders pay themselves through the same payroll run as the team, and the default categorization throws all of it into one expense line. The fix is to use payroll categorization in QBO or in your payroll provider (Gusto, Justworks, etc.) to split the founder draw or salary into a separate expense account from delivery payroll, so your delivery margin calculation is not distorted by founder compensation.
The fourth is forgetting to update the chart of accounts as the agency grows. An agency that is 80 percent retainer revenue today might be 50 percent retainer and 50 percent project revenue in two years. New service lines, new pass-through categories, and new overhead categories will emerge. The chart of accounts is not a one-time setup. It needs a quarterly or semi-annual review to make sure it still reflects how the business actually operates.
What to look for in a bookkeeper who can build this for you
If you do not want to do the rebuild yourself, the right kind of bookkeeper can do it in a week and have you on a clean monthly close cycle within a month. The wrong kind of bookkeeper will spend three months categorizing transactions into your existing default chart of accounts and produce a P&L that is no more useful than the one you started with.
A bookkeeper who can do this work well will have specific experience with marketing agencies and will be able to talk fluently about AGI, delivery margin, and operating margin without you having to explain those terms first. They will ask about your revenue mix, your pass-through volume, and your contractor versus W-2 split before quoting you a price, because those factors determine how much work the rebuild actually is. They will have a clear point of view on how to structure your chart of accounts and will push back on your existing structure rather than just preserving it. And they will be a CPA or work with a CPA, because the chart of accounts decisions you are making have direct implications for tax treatment, revenue recognition, and audit readiness.
If your current bookkeeper cannot do this work, you have two options. You can find a new bookkeeper who specializes in agencies and can rebuild from scratch. Or you can keep your current bookkeeper for transaction categorization and bring in a fractional CPA or agency accounting specialist to do the structural rebuild and oversee the monthly close. The second option is sometimes a good fit for agencies that have a tenured bookkeeper they trust but who is not built for the structural work an agency requires.
At Prophet Accounting, we work with marketing agencies, creative shops, digital agencies, and coaching businesses across the country.
We restructure your chart of accounts so AGI and delivery margin are visible every month, set up project-level tracking so you can see which clients and engagements are profitable, and deliver monthly reporting that goes well beyond the generic small business package.
If your books are not telling you the truth about your agency, schedule a consultation at prophetaccounting.com/agencies. Want a quick read on what monthly accounting would cost? Try our pricing calculator.
-
A retainer prepayment is a liability, not income, until the work is delivered. Set up an "Unearned Revenue" account as Other Current Liabilities (Detail Type: Deferred Revenue), create a "Retainer" service item that maps to that account, and record the prepayment as a sales receipt against the Retainer item. As you deliver work each month, recognize the earned portion as revenue through an invoice or journal entry.
-
Cost of goods sold. Placing pass-through ad spend in operating expenses puts it below your delivery costs on the P&L, which prevents AGI (Agency Gross Income) from calculating correctly. Some agencies prefer to use an Other Current Liability account ("Funds Held for Client Media") instead, which keeps the money off the P&L entirely until ads run.
-
No. QuickBooks Online ships with a generic chart of accounts based on whatever industry you select during setup, and "marketing agency" is not one of the prebuilt templates that captures retainer revenue, project revenue, and pass-through costs separately. You will need to build the structure yourself or have a bookkeeper who specializes in agencies do it.
-
Sub-customers are usually the better fit for agencies. They preserve the client-project relationship in invoicing, billable expense tracking, and Profit by Customer reports. Classes are better when you want to slice the entire P&L by service line or business unit instead of by client.
-
Plus is usually the right tier for agencies. It unlocks classes, sub-customers, project tracking, and billable expenses, all of which agencies need to track per-client and per-project profitability. Essentials lacks project tracking and class tracking. Simple Start does not support billable expenses at all.
