The Author Revenue Dashboard consolidates every royalty, ad dollar, affiliate payment, and speaking fee into one AI-powered Google Sheets template — with built-in tax estimates and a 12-month trend view.
🔒 Secure checkout via Stripe
You spend more time hunting down numbers than actually understanding them. By the time you've assembled everything, the month is over.
You hand your accountant a mess of screenshots and bank statements. Last year it cost you $400 in prep fees — and that was before you paid the actual tax.
You're guessing which platform to double down on. Without a trend view, every decision is a coin flip.
Untracked affiliate links, forgotten bonus tiers, missed payment thresholds. It happens when you don't have a system.
Real sample data. What you'll see on Day 1 — just with your numbers.
| Revenue Stream | Jan | Feb | Mar | Apr | May | Jun | Q2 Total | YTD Total | % of Revenue | MoM Change | |
| 2 | KDP Royalties (US) | $1,240 | $1,380 | $1,520 | $1,490 | $1,710 | $1,850 | $5,050 | $9,190 | 38.2% | +8.2% |
| 3 | KDP Royalties (Intl) | $312 | $298 | $341 | $405 | $389 | $421 | $1,215 | $2,166 | 9.0% | +8.2% |
| 4 | Amazon Associates | $487 | $523 | $511 | $602 | $589 | $644 | $1,835 | $3,356 | 13.9% | +9.3% |
| 5 | Google AdSense | $218 | $241 | $229 | $267 | $312 | $298 | $877 | $1,565 | 6.5% | -4.5% |
| 6 | Course Sales (Teachable) | $890 | $720 | $1,140 | $980 | $1,260 | $1,450 | $3,690 | $6,440 | 26.7% | +15.1% |
| 7 | Speaking Fees | $0 | $1,500 | $0 | $2,000 | $0 | $1,500 | $3,500 | $5,000 | 20.7% | — |
| 8 | Freelance Writing | $350 | $350 | $700 | $350 | $700 | $700 | $1,750 | $3,150 | 13.1% | Stable |
| 9 | TOTAL REVENUE | $3,497 | $5,012 | $4,441 | $6,094 | $4,960 | $6,863 | $17,917 | $30,867 | 100% | +38.4% |
| 10 | — Expenses (tools, ads, software) | -$312 | -$298 | -$341 | -$287 | -$356 | -$389 | -$1,032 | -$1,983 | ||
| 11 | — Est. Tax (25% SE rate) | -$796 | -$1,178 | -$1,025 | -$1,452 | -$1,151 | -$1,619 | -$4,222 | -$7,221 | ||
| 12 | NET TAKE-HOME | $2,389 | $3,536 | $3,075 | $4,355 | $3,453 | $4,855 | $12,663 | $21,663 | +40.6% |
↑ Sample data shown. Your numbers populate automatically from the monthly input tabs.
10 tabs, zero complexity. Built so you can update it in 15 minutes a month.
KDP (US + Intl), AdSense/Mediavine, Amazon Associates, speaking fees, course sales, freelance, and a custom field — all in one view.
Revenue minus expenses minus estimated taxes = real take-home pay. Updated the moment you enter a number.
SE tax rate auto-applied. Know your Q1–Q4 estimated tax payments before the IRS comes knocking.
Visual line charts for each income stream. See what's growing, what's stalling, what needs attention.
Pre-written ChatGPT prompts for revenue analysis, platform strategy, pricing optimization, and more.
Software, ads, design, equipment — categorized for Schedule C. Export-ready at tax time.
Set yearly income targets per stream. Watch the progress bars fill as you hit milestones.
One-click sheet export for your accountant. Print-friendly P&L summary included.
Track when each platform pays (KDP: end of month + 60 days, AdSense: 21st, etc.). Never miss a threshold.
No hidden formulas, no locked cells, no dependencies. Customize every field for your business.
You have 2–8 books on KDP, a blog with AdSense, and an Amazon Associates link in your bio. Every platform has its own dashboard and nothing adds up cleanly. This fixes that.
You earn from live events, a Teachable course, and a newsletter. Irregular income makes financial planning impossible. This gives you a system — even for lumpy months.
You juggle client work, royalties, and affiliate income. You've been meaning to "get organized" for two years. This is the tool that actually makes it happen.
10-tab template, pre-built formulas, sample data included. Works in Google Sheets (free) and exports to Excel.
15 plug-and-play ChatGPT prompts for revenue analysis, platform decisions, pricing strategy, and tax prep Q&A.
Step-by-step instructions to populate the dashboard with your data. No spreadsheet experience required.
20-minute screen recording showing every tab, formula, and use case. Watch once, use forever.
When platforms change their payment structures, we update the template. You get the new version at no charge.
It's a Google Sheets file. After purchase, you'll get a link to make your own copy — it's in your Google Drive in under 60 seconds. It also exports to Excel (.xlsx) if you prefer.
None. If you can type numbers into cells, you can use this. The formulas do all the math. The setup guide walks you through every step.
Yes. Every cell is unlocked. Rename platforms, add new income categories, change tax rates — it's your template to own and modify.
30-day no-questions-asked refund. If the template doesn't work for you, email steve@bevoza.com within 30 days and you'll get a full refund. No hoops.
Yes. The tax estimator uses US SE rates by default, but you can change the percentage to match your country. Revenue tracking works globally.
This was built specifically for author and creator income — KDP payment cycles, affiliate thresholds, seasonal royalty patterns, and the specific expense categories that matter at tax time. Generic templates miss all of that.
One template. 15 minutes a month. Total clarity on your author income.