Monday, October 03, 2005

DIY Payroll with Excel, Part I

Microsoft Small Business Accounting Software (SBA) Excel PayrollI finally took a deeper look at the DIY payroll in Small Business Accounting over the weekend. This feature was made available in the downloadable update on 9/7 and uses Excel to perform the payroll calculations with info pulled in from SBA. If you only have a handful of employees and/or want to manage payroll on your own, this is a reasonable alternative for you.

For starters, SBA sends over all of your employees, their time entry/timesheet data (for the specified period) and a set of liability and expense accounts to enable an efficient, two-part setup.

To start the process, select the Employee->Manual Payroll->Enter Manual Payroll menu option. The result is an Excel template that opens and asks for the payroll period dates. These dates will be the basis for employee hours that are brought over from SBA's time entries/timesheets.

Setup Step 1 starts with capturing hourly wages, tax rates and other deductions. Note, if you are paying salaried employees, specify the rate per 40 hrs, or number of hours the salary is based on. Also note that the Tax Status info comes from the W4 Form. All in all, a little info about each employee and the setup is done.

After this step is complete for all of your employees, move on to the GL setup.
More on this setup in the next post...


At 11:29 PM, Blogger Jessey said...

Thanks for this trouble shooting. Last time I mange my currency rates account but i face some kinda problem. Now I manage all my accounts.

At 12:51 AM, Anonymous employee benefits las vegas said...

Hey I have got y own software with the help of employee benefits las vegas

As they provide the best software you all can check this out.

At 1:26 AM, Anonymous payrolling information said...

Payrolling information providers are held accountable for any mistakes that might be made during the process.

At 3:46 AM, Anonymous Anonymous said...

You can also use expanded features and can save time and money against huge sales.Click here "Payroll Business Software" automatically upgrades and updates and the job directly done by company provider.

At 3:48 AM, Anonymous Anonymous said...

This comment has been removed by a blog administrator.


Post a Comment

<< Home