Payroll calculator mi excel free download

This Employee Payroll Register spreadsheet was designed for small businesses that choose to use an accountant or online payroll service like Intuit. I've kept this spreadsheet fairly basic, so depending on your business and policies, you may find that you need to add more columns. The Employee Payroll Information worksheet is where you would record information like name, ID, address, sex, occupation, hire date, salary or wage basis, exempt status, federal allowances, and other information about current deduction and contribution elections.

The Payroll Register worksheet is where you can keep track of the summary of hours worked, payment dates, federal and state tax withholdings, FICA taxes, and other deductions. Depending on how you are keeping your records, you may want to add information to the payroll register, or remove it.

There may be specific record-keeping requirements that apply to you, so check with your accountant to make sure that you are keeping appropriate records.

In the Payroll Register worksheet, columns E-K Daily Hours Worked are hidden by default, because if you are keeping a record of employee timesheets elsewhere, you may not want to duplicate that information in the register. If you want to record payroll payments broken down into regular pay, overtime pay, and reimbursements, you can unhide Columns R-T and then make the Gross Pay column a formula.

When we first opened Basics Payroll , Excel's Compatibility Checker listed components that are disabled or reduced in functionality in earlier versions of Excel, with recommendations for fixes. Basics Payroll's white font and green-on-black look don't resemble the typical Excel sheet, but everything's clearly laid out and labeled, including buttons at the top of the template for quickly opening the Data Sheet, viewing and printing checks, entering general information, and returning to the Menu.

Clicking Help opened a sheet of instructions with individually printable sections. We could also go directly to the tax tables or a particular timesheet. Since we didn't yet have any saved data, we started by entering our General Information in Step 1 and moving on to Step 2, Payroll Input.

We could center checks for neat printing, too, though we didn't have genuine check paper to test-print checks. Basics Payroll 's simple, three-step process and familiar Excel format make for a short learning curve, and also make quick work of the payroll process. And it's free, if you answer these questions three!

By entering data such as employee name, state and federal tax rates, and hours worked, charts are automatically generated displaying all employee tax data, all calculated payroll costs, and individual employee payroll tables.

All charts are formatted in organized, easy-to-read spreadsheets. All data is easily edited once merged to Excel. Excel or higher required.