Income+Summary+2012



The purpose of this document is to display the total income I would have earned in one year at my job (amounts have been changed). I put the percentage of how much taxes is being deducted from each paycheck. I figure out how much is being taken out for Medicare, Social Security and the New York State Tax. After finding these totals, I Add them together using SUM. Then I display the total of taxes being paid per month in a Pivot Table. I am left with my total income after all the deductions have been made, once I subtract the deductions from my original income. This allows me to have all the information in one worksheet to see how much money I am losing from each paycheck to taxes.