Organize Your Personal Taxes in Excel: Income, Deductions, Receipts & Year-End Summary
20 hands-on labs that turn a year of paperwork into one tidy tax organizer: income by source, a deductible-expense log, a receipts checklist, mileage and donations logs, medical costs against a threshold, side-income profit, a quarterly set-aside, a document checklist, a year-over-year check and a year-end summary, then payslip tie-outs, foreign-currency income, childcare costs with a cap, a receipt file index, data health checks, a tax calendar, retention dates, month-by-month totals and an adviser-pack dashboard. Record keeping only, not tax advice.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course turns a year of paperwork into one tidy tax organizer in 20 interactive Excel labs. You summarise income by source with SUMIF, log deductible expenses with a business share, check receipts with COUNTIF, keep mileage, donations and medical logs, calculate side-income profit and a quarterly set-aside, track year-end documents, compare with last year and build a year-end summary. Then you tie monthly payslips to the annual statement and find the missing month, convert foreign-currency income with a rate table, total childcare costs per child with an example cap, name receipt files with TEXT and find duplicates, run health checks for wrong years and text amounts, plan a tax calendar with WORKDAY, work out retention dates and month-by-month totals, and finish with an adviser-pack dashboard. Record keeping only, not tax advice.
Lessons
- Income Summary by Source: Salary, Side Business, Interest & DividendsFree
- Deductible-Expense Log: Business Share and Category Totals with SUMIF Locked
- Receipts Checklist: Found, Missing and What to Chase with COUNTIF Locked
- Mileage Log: Odometer Readings, Work Kilometres and the Claim Locked
- Charitable Donations Log: Cash, Goods and Receipts above a Limit Locked
- Medical Expenses: Out-of-Pocket Total against a Threshold Locked
- Side-Income Profit: Monthly Result, Chart and Loss Months Locked
- Quarterly Set-Aside for Estimated Tax: Rate Cell, MAX and What Is Still Open Locked
- Year-End Document Checklist: Completion % and Pending Items Locked
- Year-over-Year Comparison: Changes, Change % and Items to Double-Check Locked
- Year-End Summary Sheet: Totals, Deduction Chart and Highlights Locked
- Do the Payslips Add Up? Monthly Payslips against the Annual Statement and the Missing Month Locked
- Foreign-Currency Income: A Monthly Rate Table, XLOOKUP and the Converted Total Locked
- Childcare Costs: Own Cost after Subsidies, Totals per Child and an Example Cap with MIN Locked
- A Receipt File Index: Standard File Names with TEXT and &, Folders and Duplicate Checks Locked
- Year-End Health Check: Dates Outside the Year, Unknown Categories and Amounts Stored as Text Locked
- A Tax Calendar: Days Left, Status Labels, Working-Day Reminders and the Next Task Locked
- How Long to Keep It: Retention Years per Document Type, Shred-From Dates and a Keep List Locked
- Month by Month: Totals with MONTH and SUMPRODUCT, a Running Total and a Column Chart Locked
- Final Project: The Adviser Pack Dashboard – Proof per Log, Open Items, Money at Risk and a Ready Check Locked
Learner reviews
Be the first to review this course.