Why it worked
The video provides a clear and practical solution to a common pain point for small business owners and self-employed individuals: managing expenses for tax purposes. The visual demonstration of the spreadsheet and the promise of automated organization likely resonated with viewers seeking efficiency and tax savings.
Summary
The video demonstrates a spreadsheet designed for tracking business expenses and tax write-offs. It shows how to categorize expenses, determine deductibility, and calculate totals, with the goal of helping self-employed individuals organize their finances for tax purposes.
On-screen text
EXPENSES & DEDUCTIONS
JANUARY
2026
Total Expenses Amount
$7,485.00
Total Deductible Amount
$4,222.00
Deductible vs Non-Deductible Expenses
$5,000.00
$4,000.00
$3,000.00
$2,000.00
$1,000.00
Total Deductible Amount
$4,222.00
$3,663.00
Non-Deductible Expenses
Date
Vendor
Description
Category
Amount
Deductible
Business %
Deductible Amount
Payment Method
Receipt
Notes
Jan 1, 25
Staples
Office paper & supplies
Office Supplies
$120.00
Yes
100%
$120.00
Cash
Yes
Office supplies for daily business operations
Jan 1, 25
Subway
Lunch with client
Meals (Business)
$50.00
Partial
50%
$25.00
Debit Card
Yes
Business lunch with potential client
Jan 2, 25
Google Ads
Online advertising campaign
Advertising & Marketing
$450.00
Yes
100%
$450.00
Credit Card
Yes
Online marketing campaign
Jan 2, 25
Zara
Casual clothing
Clothing
$180.00
No
0%
$0.00
Debit Card
Yes
Personal clothing, not business-related
Jan 3, 25
AT&T
Mobile phone bill
Phone (Mixed Use)
$140.00
Partial
50%
$70.00
Check
Yes
Mixed personal and business phone usage
Jan 3, 25
Bank of America
Monthly service fees
Bank Fees
$35.00
Yes
100%
$35.00
Zelle
Yes
Monthly business banking fees
Jan 4, 25
Amazon
Household items
Personal Expenses
$250.00
No
0%
$0.00
Debit Card
Yes
Personal household items
Jan 9, 25
WeWork
Office rent
Rent / Lease
$1,200.00
Yes
100%
$1,200.00
Credit Card
Yes
Office rent
Jan 10, 25
IRS
Fuel for personal vehicle
Vehicle Expenses
$300.00
Partial
30%
$90.00
Bank Transfer
Yes
Fuel used for business-related travel
Jan 11, 25
IRS
Federal income tax payment
Income Taxes
$1,500.00
No
0%
$0.00
Check
No
Personal income tax payment
Jan 12, 25
Adobe
Design software subscription
Software & Subscriptions
$60.00
Yes
100%
$60.00
Credit Card
Yes
Design software subscription
Jan 13, 25
Comcast
Internet service
Internet (Mixed Use)
$100.00
Partial
50%
$50.00
Zelle
Yes
Internet service used for business projects
Jan 14, 25
City Hall
Business permit renewal
Licenses & Permits
$120.00
Yes
100%
$120.00
Debit Card
Yes
Business permit renewal
Jan 15, 25
Udemy
Online business course
Education & Training
$210.00
Partial
50%
$105.00
Credit Card
Yes
Training related to business operations
Jan 17, 25
State Farm
Business insurance premium
Insurance (Business)
$850.00
Yes
100%
$850.00
Bank Transfer
Yes
Home office utility expense
Jan 19, 25
Delta Engine
Flight for business-related travel
Travel Expenses
$260.00
Yes
100%
$260.00
Check
Yes
Commercial business insurance
Jan 20, 25
Amazon
Printer for home
Repairs & Maintenance
$280.00
No
0%
$0.00
Zelle
No
Office maintenance and repairs
Jan 21, 25
Nike
Everyday shoes
Clothing
$160.00
No
0%
$0.00
Debit Card
No
Shared-use equipment for home office
How to track business
expenses and never miss
a tax write-off
START HERE & SETUP + SUMMARY
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
Copyright & Social
Expenses by Payment Method
Method
Transactions N°
Amount
Cash
4
$880.00
Debit Card
4
$1,530.00
Credit Card
3
$1,010.00
Bank Transfer
3
$2,530.00
Check
3
$1,100.00
Zelle
3
$435.00
Expenses by Payment Method
15%
20%
10%
25%
30%
Expenses by Payment Method
Method
Cash
Debit Card
Credit Card
Bank Transfer
Check
Zelle
Receipt
Yes
Yes
Yes
Yes
Yes
No
Notes
Office supplies for daily business operations
Business lunch with potential client
Online marketing campaign
Personal clothing, not business-related
Mixed personal and business phone usage
Monthly business banking fees
Personal household items
Monthly office rent payment
Fuel used for business-related travel
Personal income tax payment
Design software subscription
Internet service used for business projects
Business permit renewal
Training related to business operations
Home office utility expense
Commercial business insurance
Flight for business-related travel
Office maintenance and repairs
Shared-use equipment for home office
Personal footwear, not required for work