Influencer campaign budget template: the sheet layout, the formulas and a filled example

An influencer campaign budget template is one spreadsheet with five tabs: inputs, creator lines, other costs, a summary and a tracker. Every creator deliverable gets its own line with quantity, fee, rights, exclusivity and GST status, and the summary adds the management fee, GST, other costs and a reserve. This post gives the columns and formulas, then fills the sheet for a 13-creator campaign so you can see where the total lands.

Our influencer marketing cost guide lists what creators charge, and influencer marketing budget planning shows how to decide how much to spend. This post is the sheet you build after that decision, one level below it. For the bigger picture, read the complete guide to influencer marketing in India.

Tab 1: Inputs

Store every rate once. If a creator's rights uplift changes, you change one cell.

The 35% and 40% are the add-on values our cost calculator uses. The 20% fee sits in the middle of the published 15% to 25% band, which comes from one agency's pricing guide. Replace all five with the figures in your quotes.

Tab 2: Creator lines

One row per creator or group of creators who share a fee and an add-on.

Put the GST flag on every creator, not one rate on the whole sheet. Registration is required above ₹20 lakh of annual turnover, or ₹10 lakh in special-category states (CBIC), so many small creators will not charge it.

Optional: a scenario switch

Before quotes arrive, you only have ranges. Add three columns to the right of the lines: M for the floor fee, N for your planning fee and O for the ceiling fee, taken from the published range for each tier and format. Change column E to =CHOOSE(Inputs!$B$8,M2,N2,O2), with Inputs!B8 holding 1, 2 or 3. Flip the cell and the whole sheet shows the budget at floor, plan or ceiling. When a quote arrives, overwrite column N with it.

Run on the example below, the switch gives ₹2.96 lakh at the floor, ₹6.74 lakh at the planning fees and ₹20.62 lakh at the ceiling, because the add-ons and fee scale with the base. That spread is why a budget set before quotes should be a range, and why you should collect three quotes for each line before you fix the ceiling.

Tab 3: Other costs

Keep ad media here as its own line, never inside the creator total. One agency guide puts media at typically 2x to 4x the fee of a whitelisted post, so it can outweigh the fees, and finance should approve it as a separate decision. See influencer whitelisting cost in India.

Tab 4: Summary

The multiple of base fees is the number to read first. It tells you how much of the bill sits outside the Reel price.

A filled example: 13 creators

This is a hypothetical campaign, not a past one. Fees are planning figures inside the ranges behind our rates guide. The first six micro creators post Reels and Story sets, and six nano creators post Reels. One mid-tier creator posts a Reel with both rights and exclusivity.

Other costs are 22 product units at ₹400, 13 for the creators and 9 for seeding (₹8,800), courier at ₹100 each (₹2,200) and ₹5,000 for tracking and a landing page, a total of ₹16,000. Ad media is not in this campaign.

Base fees are ₹3,23,000, so the total is 2.09 times the Reel prices. Cost per creator is about ₹51,900 and per deliverable about ₹35,500. The mid-tier creator's add-ons alone are ₹93,750, which is more than the micro lines' add-ons and GST combined (₹55,020). That is the line to question first, not the micro creators.

Tab 5: Tracker

The summary is the plan. The tracker is what protects it. One row per line from Tabs 2 and 3.

Commitment is the column most sheets lack. By the time an invoice arrives, the money is spent. A creator who is promised a second round, a rush slot or extra rights has cost you something the moment you agreed. Record every add-on as a new line before the work starts. Pay on a written schedule, with half on booking and half on go-live on our typical terms, and match each invoice to its line using our invoice template and payment terms guide. On TDS, section 194R of the Income-tax Act 1961 applies 10% to a kept product once benefits to one person pass ₹20,000 in a year (TaxGuru), and the Income-tax Act 2025 applies from 1 April 2026, so confirm the current section. This is general information, not legal or tax advice.

Lines to add for your kind of campaign

The sheet bends to the campaign. These additions come from the work, not the rate cards.

The note that goes with the sheet

Finance reads the summary tab and one paragraph. Write it in this order: what the budget buys, what it is judged on, the total, the multiple of base fees, what is outside it, and what you would cut first. For the example it reads:

The cut named in the note is arithmetic: 40% of ₹1,25,000 is ₹50,000. Stating it in advance lets approvers see that you have already thought about trade-offs.

Before you send it for approval

1. Every percentage is read from the inputs tab and none is typed into a formula.
2. Each creator line states its GST status and its add-ons separately.
3. Ad media, product and shoots sit on the other-costs tab, not inside fees.
4. The summary shows the multiple of base fees and the headroom.
5. The tracker exists on day one, with committed spend.
6. A short note says what the budget is judged on, and what will be cut first if money runs short. How to reduce influencer marketing costs lists the levers in order.

To fill the sheet, you need quotes. Our campaign brief template gets comparable quotes from creators, and our influencer cost calculator does the arithmetic for a quick check. For a creator plan with named creators, quotes and our fee on its own line within 48 hours of the brief call, send us a brief. The pricing page explains how we invoice, and our influencer marketing strategy service builds the plan the sheet prices.