How To Track Your Income & Expenses & Calculate Your Quarterly Estimated Taxes Yourself using Excel | Desarie Anderson | Skillshare

Playback Speed

• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x

# How To Track Your Income & Expenses & Calculate Your Quarterly Estimated Taxes Yourself using Excel

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

### Lessons in This Class

15 Lessons (1h 42m)

1:33

0:55

5:38

7:15

2:07

2:17

3:13

4:43

4:42

2:15

4:17

4:41

20:56

36:13
• ### 15. 15 Final Message Regarding Future Updates

1:37
• --
• Beginner level
• Intermediate level
• All levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

304

Students

--

Project

What you will learn in this class:

1) Who is required to pay estimated taxes and why?

2) Calculating your quarterly estimated taxes

3) When are your quarterly estimated taxed due?

4) All the different ways to pay your estimated taxes

5) What are the penalties for not filing your estimated taxes?

6) A hands-on demonstration on how to use Excel to calculate your estimated taxes.

The spreadsheet functions as a simple bookkeeping system and a quarterly tax estimated calculator.Â  You will be able to not only record and keep track of your income and expenses, but you will also be able to calculate your federal quarterly estimated taxes.

If you already use an outside bookkeeping system, like Quickbooks Online, but the system you use is not able to calculate your quarterly estimated taxes, you can use the spreadsheet as a calculatorÂ ONLY.Â  You do not have to use the spreadsheet to track your income and your expenses in order to use it to calculate your quarterly estimated tax payments.Â

The spreadsheet is set up to track your income and expenses from 2017 through 2024.Â  Each year has its own sheet.Â

You can also use the spreadsheet to project future growth rates using built-in growth rate percentages

The spreadsheet is limited to the following people:

1) Your tax filing status at the end of the year is single, and you make \$157,500 or less a year

2) Your tax filing status at the end of the year is Married Filing Separately, and you make \$157,500 or less a yearÂ

3) Your tax filing status at the end of the year is Married Filing Jointly and together you both make \$315,000 or less a yearÂ

4) Neither You nor your spouse if you are Married Filing Jointly, receive W2 income from an employerÂ

5) Your income can only be derived from self-employment or investment income

### Desarie Anderson

Cash Flow Management

Teacher

I am originally from London, England but currently live in Atlanta, GA with my husband David.

I always joke that I have had the distinct pleasure of using both the left and right side of my brain. I owned and operated a hair salon for over 17 years (Right side), and now I own a small Tax and Accounting practice (Left side). So you can get your hair cut & colored and get your taxes done all in one visit.

I graduated from Georgia State University with a BA in Accounting. I am a Georgia CPA and an IRS Enrolled Agent. I am also a certified QuickBooks online Pro advisor.

In addition to providing small businesses with bookkeeping and accounting services, I am passionate about helping small businesses manage their cash flow. No business can survive without proper c... See full profile

## Class Ratings

Expectations Met?
Exceeded!
• 0%
• Yes
• 0%
• Somewhat
• 0%
• Not really
• 0%
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects