Welcome to the Small Business Ideas Forum! We are a community of over 100,000 small business folks with over 163,000 posts for you to browse. We pride ourselves on being the friendliest forum you will find and we'd love to have you as a member of our community. Please take a moment and register for a free account. If you need any help, please contact Chris Logan.

Small Business Ideas Forum

Small Business Ideas Forum

A friendly place to share small business ideas and knowledge, ask questions, find help and encourage others that are involved in the small business industry. Topics include small business marketing, generating revenue and small business computing.

Go Back   Small Business Ideas Forum > Small Business Computing > Computer Software
Register Search Today's Posts Mark Forums Read

Thread Tools
Old 20th May 2010, 10:04 AM   #1

Join Date: Jul 2008
Location: Calaveras County California
Posts: 78
Default Spreadsheet Hell! Do You Need An HRIS?

It is not all that uncommon even in medium sized organizations to see all the HR Data managed in Excel spreadsheets. A spreadsheet for basic information, one for pay information, one for evaluations, the list goes on and on and the data never seems to match up perfectly between spreadsheets. John Smith is in this spreadsheet, so why wasn’t he added to the other one. Why is the name spelled one way in one spreadsheet and another way in the other. Oops! There was a typo on Mary’s employee number, so it is different in that spreadsheet.

I call this Spreadsheet Hell! While spreadsheets are a great place to look at and manipulate data, they are not meant to take the place of a relational database. Spreadsheets are prone to human error and make storing related data very difficult.

HRIS Systems using a relational database as a foundation are designed to ensure “referential integrity”. This means that related data is tied together by keys and it is not possible to have a compensation record for Johnny if he does not have a parent record with his base information. The two are tied together. An HRIS system also utilizes dropdowns and programming logic to ensure data accuracy and consistency.

If you still love to look at your data in spreadsheets, most HRIS Systems can export specified data to Excel where you can analyze it and play with it while the data remains safely stored in the HRIS’s database.

Aside from tying all the data together and ensuring referential integrity, the HRIS allows you to run a number of predefined or adhoc reports and filter data to get at exactly what you need whether it is as simple as a birthday listing or summarizing data into an EEO Analysis by Department.

A simple Google or Yahoo search for Small Business HRIS will get you on the road to better organized data and more efficient business operations.

Mark - Software Developer
hrdatamanager is offline   Reply With Quote
Register or log in to remove this ad.
Old 25th February 2014, 09:39 AM   #2

Join Date: Feb 2014
Posts: 1

Hi, Well put up in the form people work with spreadsheets but advantage of spreadsheet are also there like you dont need to learn to perform your task and in software's sometime there are dependencies. But yes of course managing HR information with a software's are easier. You can try HR Cube which is a small software and you can easily download it from the internet, this will help you in keeping your employee records and documents

jordann is offline   Reply With Quote
Old 28th February 2014, 11:32 AM   #3
VIP Contributor
fairdoes's Avatar

Join Date: Dec 2004
Location: Cornwall UK
Posts: 365

I use the spreadsheet that comes free with Linux (Ubuntu). A database has limitless possibilities, but needs a web server and knowhow. A spreadsheet is portable and easy. I expect there's a way to have the same data in both applications

fairdoes is offline   Reply With Quote


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tweepi: Twitter Management for the Spreadsheet Afficianado Small Business Brief Small Business Brief Archives 0 25th February 2010 04:30 PM
Should My Small Business Have HRIS Software? hrdatamanager Computer Software 0 4th December 2008 12:20 PM

Thread Tools

Get Updates
RSS Feeds:
RSS Feed for Computer Software RSS for this Category Only: Computer Software

RSS Feed for Small Business Ideas Forum RSS for Entire Forum
Forum Rules

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Small Business Ideas Forum

At Your Business - Small Business Directory
Free Business Forms - Prewritten Documents
Search Engine Guide
Small business guide to search marketing

Small Business Brief
Fetching the Best Small Business Info

Free Links - Free Advertising
Free Guide - Online Directory

Advertise your business here
Contact us for more details!

Semantic Juice
Register now to access free Quick SEO service!

Rocket Lawyer
Sign up for free 7 day trial. Boost your biz!

Buy UPC Codes
Get your products listed online!

All times are GMT -5. The time now is 07:50 AM.

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004 - 2018 - Privacy