Tracking blog income and expenses does not need to become a complicated accounting project. A simple monthly spreadsheet can show where your revenue comes from, what publishing costs, and whether the blog is producing a profit. This guide provides a repeatable blogging income spreadsheet structure, category definitions, formulas, reconciliation checklist, and worked examples you can adapt to your own publishing setup.
Overview
A blog profit and loss view answers three practical questions:
- How much money did the blog earn during the period?
- How much did it cost to operate and publish?
- What remained after those costs?
Keep the spreadsheet focused on business activity. Personal spending, transfers between your own accounts, and money set aside for taxes should not be mixed with ordinary blog revenue or operating expenses. You can track tax reserves separately, but labeling them clearly prevents them from being mistaken for a publishing cost.
A useful workbook can contain four tabs:
- Transactions: one row for each income receipt or expense.
- Monthly summary: totals by month, revenue channel, expense category, and profit.
- Invoices and payouts: expected payments, invoice dates, payout dates, and status.
- Reference: your category list, payment accounts, and notes about unusual transactions.
Use the transaction tab as the source of truth. A suggested column layout is: date, month, type, category, description, counterparty or platform, payment account, amount, currency, invoice or receipt link, cleared status, and notes. Record amounts consistently, such as positive numbers for income and positive numbers for expenses, then let the summary formulas separate them by type.
For broader monetization planning, pair this financial record with your monthly blog SEO report. Traffic and search visibility explain potential changes in revenue, while the spreadsheet shows what those changes mean financially.
How to estimate
Start with a monthly profit formula:
Net blog profit = total received income − total paid business expenses
For a simple spreadsheet, create separate totals for each revenue and expense category. If your transaction sheet uses column C for type and column H for amount, a summary cell could use a formula such as:
=SUMIF(Transactions!C:C,"Income",Transactions!H:H)
An expense total could use:
=SUMIF(Transactions!C:C,"Expense",Transactions!H:H)
Then calculate profit with:
=TotalIncome-TotalExpenses
To summarize one month, add a month column containing a consistent value such as 2026-11. You can then use SUMIFS to filter by both month and type. For example:
=SUMIFS(Transactions!H:H,Transactions!B:B,"2026-11",Transactions!C:C,"Income")
Use the same method for expense categories such as software, hosting, contractors, and promotion. If your spreadsheet application uses different separators or date formats, adjust the formula to match its conventions.
For channel comparisons, calculate each revenue source as a share of total income:
Channel share = channel income ÷ total income
This helps you distinguish a blog with several modest revenue sources from one that depends heavily on a single platform or partner. It also makes planning more concrete. Instead of asking whether the blog is “doing well,” you can ask whether affiliate income, advertising, sponsorships, or products is growing, stable, delayed, or declining.
Track both cash received and income earned but not yet received when that distinction matters to your records. A sponsorship may be agreed or invoiced in one month but paid later. An affiliate dashboard may show an estimated commission before the network confirms or pays it. Label these figures separately rather than combining estimates with cleared cash.
Inputs and assumptions
The quality of your blog bookkeeping depends more on consistent definitions than on elaborate software. Create a short category guide before entering transactions.
Income categories
- Advertising: display advertising or other ad placements.
- Affiliate commissions: commissions attributed to tracked referrals.
- Sponsorships: sponsored articles, newsletters, videos, or other agreed placements.
- Digital products: ebooks, templates, courses, memberships, or downloads sold through the blog.
- Services related to the blog: only if you intentionally include these in the same business records.
- Other income: use sparingly and explain the transaction in the notes column.
Expense categories
- Hosting and domain: hosting, domain registration, and related infrastructure.
- Software and tools: email, design, analytics, scheduling, security, and productivity tools used for publishing.
- Content and production: photography, graphics, audio, video, or other direct production costs.
- Contractors: payments to people who contribute to editing, design, development, or other publishing work.
- Marketing and promotion: newsletter promotion, events, or paid distribution connected to the blog.
- Payment processing: transaction fees withheld or charged by payment providers.
- Education and research: costs you choose to track as business-related learning or research.
- Other operating costs: occasional items that do not fit elsewhere, with an explanation.
Do not force every purchase into a business category. If an item has mixed personal and publishing use, record only the portion you can reasonably support under the rules that apply to you. Keep receipts, invoices, payout statements, and agreements in an organized folder, and link to them from the spreadsheet when possible.
Payment timing also needs an explicit assumption. You might track income when money reaches your account, when a platform confirms the amount, or according to another accounting method. Choose a method appropriate for your records and apply it consistently. Because tax treatment and record-keeping requirements vary by jurisdiction and business structure, ask a qualified accountant or tax professional for advice before relying on this spreadsheet for a filing.
Worked examples
Assume the following illustrative monthly transactions. These amounts are examples for demonstrating the method, not benchmarks or expected earnings.
| Type | Category | Amount |
|---|---|---|
| Income | Advertising | 400 |
| Income | Affiliate commissions | 275 |
| Income | Digital products | 325 |
| Expense | Hosting and domain | 45 |
| Expense | Software and tools | 80 |
| Expense | Contractors | 150 |
| Expense | Payment processing | 25 |
Total income is 1,000. Total expenses are 300. The spreadsheet therefore shows an operating profit of 700 before any separate tax provision or owner withdrawal. The revenue mix is 40% advertising, 27.5% affiliate commissions, and 32.5% digital products. That mix gives you a useful starting point for deciding what to review, but it does not by itself indicate which channel deserves more effort.
Now compare the spreadsheet with your actual accounts. Confirm that each cleared payment appears once, that fees have not been deducted without explanation, and that a payout has not been recorded both as an estimated commission and as a cash receipt. If a platform pays several months together, record the payout clearly and retain the statement showing how it was calculated.
For affiliate publishers, a monthly link review can help explain changes in commissions. Use the affiliate blog link management checklist alongside your revenue report, especially when links, programs, or product availability change.
When to recalculate
Update the spreadsheet at least once each month, even if the blog has little or no revenue. A quiet month still provides useful information about fixed costs, unpaid invoices, and the cash required to keep publishing.
Use this monthly reconciliation checklist:
- Export or review statements from each bank account, payment provider, affiliate platform, advertising platform, and product store.
- Enter every new income receipt and expense, using the same categories as previous months.
- Match cleared transactions to statements and mark them as reconciled.
- Separate estimated, invoiced, pending, and paid amounts.
- Check for duplicate entries, missing fees, refunds, chargebacks, and currency conversions.
- Compare totals with the previous month and explain material changes in the notes column.
- Save receipts, invoices, contracts, and payout reports in a dated folder.
- Review the summary before making spending or monetization decisions.
Recalculate when a platform changes its payout terminology, reporting format, fee structure, or payment schedule. Also update the workbook when you add a revenue channel, launch a product, hire a contractor, change hosting, or move from a personal workflow to a formal business process. Pricing inputs and rates can change, so review any recurring assumptions rather than copying them forward indefinitely.
Every three to six months, review your category list and ask whether the summary still answers your decisions: which channels earn money, which costs are necessary, which invoices remain outstanding, and how much cash is available for future publishing. If the spreadsheet becomes difficult to reconcile, consider bookkeeping software with transaction imports, receipt storage, category rules, invoice tracking, and reporting. Software should reduce repetitive work, not replace your review of the underlying records.
Finally, keep this guide as an operating routine rather than a one-time setup task. Reconcile the month, record the explanation behind unusual changes, and use the resulting profit view to plan the next publishing cycle. For related workflow improvements, see the time-boxed blog writing workflow and the blog content distribution workflow. For jurisdiction-specific tax, accounting, or deductibility questions, consult a qualified professional.