SmartHelping / 12-Month Financial Tracking / Excel
Side Gig P&L Tracker
Keep your side-business income, expenses and cash flow organized throughout the year. Track multiple income streams, review profit and margins, and see how business activity affects your savings.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the template in action
Follow the monthly entries through the financial summary.
Watch the walkthrough to review the income, expense and cash flow inputs. The current template also includes monthly and year-to-date net profit margin calculations, added after this video.
What the template includes
Track the year without losing the monthly detail.
Enter your side-business activity in one workbook and review the automatically calculated monthly and year-to-date results.
7 income streams over 12 months
Choose the tracking year to update the 12-month period automatically. Record up to seven income streams each month, with year-to-date totals calculated for you.
30 expense slots per month
Record business-related expenses in up to 30 slots each month. Cost of goods sold can be entered in this expense section alongside other business costs.
Profit, loss and net profit margin
Review monthly and year-to-date profit and loss, plus the added net profit margin calculations for both periods.
Income tax calculation
The template calculates an income tax estimate from year-to-date net income and the income tax rate you enter.
Cash flow and savings adjustments
Use separate inputs for depreciation add-back, loan proceeds, debt repayment and capital expenditures to track business cash flow and savings over the year.
Monthly financial visualizations
Review charts for revenue, net income after tax, cash flow and the savings balance across the 12-month period.
From profit to cash flow
See what the business earns and how cash changes.
The template tracks profit and loss, then includes separate cash flow inputs below the net income line to account for business activity that affects the available cash and savings balance.
Depreciation add-back
Use the depreciation add-back input to account for the difference between a noncash expense and the cash flow generated by the business.
Loans and capital spending
Record business loan proceeds, debt repayments and capital expenditures in their separate cash flow lines. Include business-related activity in these inputs.
Savings over the year
Review the cash flow and savings balance alongside monthly revenue and after-tax net income to understand how the side business performs over the 12-month period.
How to use the template
Keep a consistent record throughout the year.
Choose the tracking year
Enter the year you want to track so the template updates the 12-month period.
Record monthly income and expenses
Enter revenue across up to seven income streams and business expenses in the 30 available expense slots per month.
Complete the tax and cash flow inputs
Set the income tax rate and record business-related depreciation add-back, loan proceeds, debt repayments and capital spending where applicable.
Review results and start the next year
Review monthly and year-to-date profit, margins, cash flow and savings. For a new year, duplicate the Template tab, rename it for that year and enter the new year’s data.
Who this template is for
For individuals who want clearer side-business records.
Use the tracker to organize annual financial information and see the relationship between business income, expenses and cash.
Individuals with several income streams
Bring side-gig revenue and business expenses together so you can review monthly performance and year-to-date totals.
Side-business owners tracking cash
See how operating results, equipment purchases and business financing affect cash flow and savings over the year.
Also available in these bundles
Need more accounting and financial tracking tools?
This template is included in the Accounting bundle and the Super Smart Bundle.
Questions before you buy
A few useful details.
How many income streams and expenses can I track?
Track up to seven income streams and enter up to 30 expense slots per month across a 12-month period. Year-to-date values calculate automatically.
Can I reuse the template in another year?
Yes. Duplicate the Template tab, rename the copy for the new year, update the tracking year and enter the data for that year.
Is there a separate cost-of-goods-sold section?
There is no separate COGS section. Enter cost of goods sold in the business expense section along with other business-related expenses.
How does the tax calculation work?
The template uses year-to-date net income and the income tax rate you enter to calculate an income tax estimate.
Can I include equipment purchases and business loans?
Yes. Separate cash flow inputs are available for capital expenditures, loan proceeds and debt repayment, along with a depreciation add-back. Use those lines for business-related activity.
Does the current version include profit margins?
Yes. Monthly and year-to-date net profit margin calculations were added after the video walkthrough.
Keep the financial picture in view
Know what your side business earns and keeps.
Get the Side Gig P&L Tracker for $45 and organize a year of income, expenses, profit, cash flow and savings.
