google sheets monthly household budget template Â£

Using the attached Excel Spreadsheet tabs, complete the payroll register for Oct., Nov., and Dec. Employer's portion of the Medical Premiums is twice what the employee pays.** **Employer will match 401K contributions up to 500. Spouse makes the same as her (checked step 2 on W4) Nancy - Has50/pay deducted for 401K, 350/pay deducted for Medical Premium insurance, and400 withheld for FSA. Martha - Has 50/pay deducted for 401K,200/pay deducted for Medical Premium insurance, and 150 withheld for FSA. Keagan - Has 300/pay deducted for 401K,250/pay deducted for Medical Premium insurance, and 150 withheld for FSA. Larry â€“ Has 450/pay deducted for 401K,500/pay deducted for Medical Premium insurance, and 400 withheld for his Flexible Spending Account (FSA). ***All Medical Premium Insurance and Flexible Spending are part of a cafeteria plan*** SUTA rate = 3.5%.Įmployee Gross Wages Marital Status Recent Termination per check Hire date Assume this is an Indiana company and use the Indiana withholding rates. The employees are paid monthly (last day of the current month) and were last paid on Sept. Their necessary payroll information is listed below and in the Excel spreadsheet for the current year. SOLVED: As the accountant for Veneskey Son's, you have been hired to prepare the payroll and everything that goes along with it for Ol'Fashion Industries, which has 4 employees.

Google sheets monthly household budget template Â£