Is this general ledger correct and how can where can I add accrual of vacation time, and payment of tax liabilities
I want to create general journal entries for the employee and employer side, payment of wages, accrual of vacation time, and payment of tax liabilities.
- All of the 10 employees are paid on a weekly basis on Friday. total regular hours 316
- This project will focus on payroll for the dates ending 01/15/20 and 01/24/2020.
- All employees earn 3 hours of vacation each pay period.
- For all voluntary benefits, there is a 50/50 cost sharing agreement
-
-
Date | Account and Description | Debit | Credit |
2020 | | | |
1/24/2020 | | | |
1. | Wage expense | 7,308.00 | |
| Social security payable | | 453.10 |
| Medicare payable | | 105.97 |
| Federal withholding payable | | 537..00 |
| State withholding payable | | 293.64 |
| Accident Insurance | | 7.000 |
| Health Insurance Payable | | 111.00 |
| Union Dues Payable | | 5.00 |
| Dependent Education Fund payable | | 5.00 |
| 401(k) Payable | | 93.00 |
| Salaries Payable (Net Pay | | 5,698.62 |
| To record employer's payroll Tax | | |
2. | Payroll tax expense | 1,538.34 | |
| Social security payable | | 453.10 |
| Medicare payable | | 105.97 |
| Federal unemployment payable (FUTA= 0.08*7308.00= 584.64 | | 584.64 |
| State unemployment payable SUTA=0.054*7308.00=394.63 | | 394.63 |
this all information
this all information
Employee ID Employee Name Hourly Wage Filing Status Payme S 1 2. 3 4 5 6 7 8 Applie, Suzie Banana, Tim Catalope, Cheri Dill, Sadie Eggplant, Bill Fort, Kyle Gould, Matt Hamm, Mason Igloo, Alice Jasper, Alex Total 17.00 17.00 19.00 15.00 17.00 17.00 18.00 16.00 16.00 18.00 170.00 Single married Married Married Head of Household Single Married Single Married Single H H H 9 10 Rate : AVER TIME RATE. 15 Filing Status Payment Method Federal Allowance Regular Hours Worked Vacation Hours 0 3 3 3 3 3 Single married Married Married d of Household Single Married Single Married Single Hourly Hourly Salary Salary Hourly Hourly Salary Hourly Hourly Hourly 1 3 3 0 0 4 1 2 2 36 31 35 37 36 37 35 36 33 35 3 3 3 3 3 316 30 Vacation Hours Sick Hours Overtime Hours Regular Time Pay Over Time Pay 3 Regular Hours Worked 36 31 35 37 36 37 35 36 33 35 316 3 3 3 3 3 3 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 15 10 $663.00 $578.00 $722.00 $600.00 $663.00 $680.00 $684.00 $624.00 $576.00 $684.00 $6,474.00 $0.00 $0.00 $0.00 $0.00 $0.00 $204.00 $0.00 $0.00 $360.00 $270.00 30 Social Security Tax Medicare Tax Percentage 1.45% State Tax Percentage Benefit 6.20% 4.00% Gross Social Earnings Security Tax Medicare Tax State Tax 401(k) $663.00 $578.00 $722.00 $600.00 $663.00 $884.00 $684.00 $624.00 $936.00 $954.00 $7,308.00 $41.11 $9.61 $35.84 $8.38 $44.76 $10.47 $37.20 $8.70 $41.11 $9.61 $54.81 $12.82 $42.41 $9.92 $38.69 $9.05 $58.03 $13.57 $59.15 $13.83 $453.10 $105.97 $26.52 $23.12 $28.88 $24.00 $26.52 $35.36 $27.36 $24.96 $37.44 $38.16 $292.32 Insurance Deduction (Dollars) $0.00 $20.00 $8.00 $21.00 $0.00 $0.00 $37.00 $10.00 $0.00 $15.00 $111.00 $0.00 $14.00 $12.00 $12.00 $0.00 $15.00 $15.00 $0.00 $15.00 $10.00 $93.00 Fedral W/H Net Pay Dependednt Union Accident Total Education Deduction Insurance Deduction Fund $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $34.00 $5.00 $0.00 $0.00 $25.00 $0.00 $5.00 $7.00 $45.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15.00 $0.00 $0.00 $0.00 $52.00 $0.00 $0.00 $0.00 $10.00 $0.00 $0.00 $0.00 $15.00 $0.00 $0.00 $0.00 $25.00 $5.00 $5.00 $7.00 $221.00 $68.00 $517.76 $28.00 $448.66 $26.00 $586.89 $14.00 $471.10 $68.00 $517.76 $101.00 $665.01 $11.00 $541.31 $53.00 $488.30 $69.00 $742.96 $99.00 $718.86 $537.00 $5,698.62 Employee ID Employee Name Hourly Wage Filing Status Payme S 1 2. 3 4 5 6 7 8 Applie, Suzie Banana, Tim Catalope, Cheri Dill, Sadie Eggplant, Bill Fort, Kyle Gould, Matt Hamm, Mason Igloo, Alice Jasper, Alex Total 17.00 17.00 19.00 15.00 17.00 17.00 18.00 16.00 16.00 18.00 170.00 Single married Married Married Head of Household Single Married Single Married Single H H H 9 10 Rate : AVER TIME RATE. 15 Filing Status Payment Method Federal Allowance Regular Hours Worked Vacation Hours 0 3 3 3 3 3 Single married Married Married d of Household Single Married Single Married Single Hourly Hourly Salary Salary Hourly Hourly Salary Hourly Hourly Hourly 1 3 3 0 0 4 1 2 2 36 31 35 37 36 37 35 36 33 35 3 3 3 3 3 316 30 Vacation Hours Sick Hours Overtime Hours Regular Time Pay Over Time Pay 3 Regular Hours Worked 36 31 35 37 36 37 35 36 33 35 316 3 3 3 3 3 3 3 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 15 10 $663.00 $578.00 $722.00 $600.00 $663.00 $680.00 $684.00 $624.00 $576.00 $684.00 $6,474.00 $0.00 $0.00 $0.00 $0.00 $0.00 $204.00 $0.00 $0.00 $360.00 $270.00 30 Social Security Tax Medicare Tax Percentage 1.45% State Tax Percentage Benefit 6.20% 4.00% Gross Social Earnings Security Tax Medicare Tax State Tax 401(k) $663.00 $578.00 $722.00 $600.00 $663.00 $884.00 $684.00 $624.00 $936.00 $954.00 $7,308.00 $41.11 $9.61 $35.84 $8.38 $44.76 $10.47 $37.20 $8.70 $41.11 $9.61 $54.81 $12.82 $42.41 $9.92 $38.69 $9.05 $58.03 $13.57 $59.15 $13.83 $453.10 $105.97 $26.52 $23.12 $28.88 $24.00 $26.52 $35.36 $27.36 $24.96 $37.44 $38.16 $292.32 Insurance Deduction (Dollars) $0.00 $20.00 $8.00 $21.00 $0.00 $0.00 $37.00 $10.00 $0.00 $15.00 $111.00 $0.00 $14.00 $12.00 $12.00 $0.00 $15.00 $15.00 $0.00 $15.00 $10.00 $93.00 Fedral W/H Net Pay Dependednt Union Accident Total Education Deduction Insurance Deduction Fund $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $34.00 $5.00 $0.00 $0.00 $25.00 $0.00 $5.00 $7.00 $45.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15.00 $0.00 $0.00 $0.00 $52.00 $0.00 $0.00 $0.00 $10.00 $0.00 $0.00 $0.00 $15.00 $0.00 $0.00 $0.00 $25.00 $5.00 $5.00 $7.00 $221.00 $68.00 $517.76 $28.00 $448.66 $26.00 $586.89 $14.00 $471.10 $68.00 $517.76 $101.00 $665.01 $11.00 $541.31 $53.00 $488.30 $69.00 $742.96 $99.00 $718.86 $537.00 $5,698.62