- Site menu:
- Latest Discussions
- Latest Newswire
- Archives
- Submit Story
- Story HOWTO
- Syndicate
- E-mail Alerts
Punching the Clock with GNU/Linux
A Brief Case StudyA small business in Charlotte, North Carolina is contemplating a move from Windows to GNU/Linux. The business is in excellent position to take advantage of the opportunity. They have only a handful of computers. Their only data consists of forms in Microsoft Word format. Their Windows-based accounting software is barely used. The money they save over the long haul, in licensing fees, malware defense, and unplanned downtime, will more than make up for the costs of a migration. There is only one hitch. They need to make sure their timeclock can plug into the manager's computer - the same one that let's her create documents and connect to ADP's hosted payroll application service. Although ADP's local technical services partner has explained that they do not support GNU/Linux, and it does not appear that the SaveTime 2000 series timeclock from Control Module, Inc.will work with GNU/Linux systems, there are a couple of options. One is to test the utility program under WINE, or install WindowsXP as a VM on the GNU/Linux host. Another is to exchange the timeclock hardware for hardware that supports GNU/Linux. Finally, the manager could manually enter the payroll data into a web-based application, something this particular manager prefers to avoid. Surveying the GNU/Linux Payroll LandscapeIf you want to manage payroll with GNU/Linux, you'll need to use either GnuCash (expenses only), SQL Ledger, or software distributed by the likes of Treshna Paymaster (for N.Z., U.S.). PayThyme is available for U.K. businesses. TimeTrex offers "Time and Attendance" which works with GNU/Linux. Then there's the fairly obscure PayrollBash that needs only enough RAM for Bash to run, and can integrate with OpenOffice.org 2.1 and even Apache. Finally, there is the patented Journyx TimeSheet software, which users can install locally or use as a hosted service. Among the complete accounting solutions are Fitrix and MyBooks. Since the non-libre Fitrix starts at $6500 for 5 users, smaller businesses will appreciate outsource vendors like SurePayroll and PayCycle. Appgen's MyBooks is comparable to QuickBooks, but is multi-platform and offers the sourcecode for a separate fee. MyBooks is used fairly extensively in retail environments. Before you can decide which of these to use, you'll need to understand how each works with any timeclock hardware you've deployed. The test business is using a SaveTime 2000 series timeclock with a serial-to-USB dongle attached to a Windows PC, from which the time punches are sent to ADP's web-based payroll management service.
Kronos offers a timeclock system compatible with Unix and Oracle and, according to some users, GNU/Linux as well. Control Module, Inc. offers the Genus line of timeclocks based on GNU/Linux. According to the company's website, the Genus PC even allows employees to schedule time off right from the timeclock. The timeclock functionality is in place. Using GNU/Linux-based and compatible timeclocks with outsourced payroll vendors' systems is where things get tricky. It's possible, but not guaranteed. Some Vendors Willing to Work With the FOSS CommunityThe single most repeated response to LXer was to the effect that vendors don't get but one or two phone calls about GNU/Linux support. Even so,SurePayroll's Product Manager, Steve Kania, expressed an interest in making sure their hosted services work with GNU/Linux-based accounting software, but is not sure about what software exists or how to proceed. PayCycle is another outsource payroll vendor that offers an OS-agnostic, web-based payroll system. Paycycle Spokesperson, Julie McHenry, explained that their system works with any web browser. If these vendors were to combine efforts with hardware vendors like CMI, it would be a simple matter to provide Free/open Source Software integration with commonly-used timeclock hardware. One of the major barriers to GNU/Linux adoption among businesses is accounting software, despite the Novell poll touting Photoshop. That poll is not indicative of business users, especially given that business managers and accountants, who were likely under-represented in the poll, tend not to use photoshop to manage their businesses. According to one expert in the industry, even Novell seems to lean toward hosted Quickbooks solutions, such as that offered by e-Accounting, despite working with vendors such as Appgen. Thus, offering GNU/Linux-based timeclock drivers and accounting applications is a great first step for timeclock manufacturers. In a phone conversation with LXer, Jimmy Bianco, Vice-President of Sales and Marketing for Control Module, Inc., Bianco expressed an interest in releasing the Unix-based source code for the SaveTime 2000 clock to the GNU/Linux community under a Free/Open Source Software license so that the community of FOSS developers can write drivers and utility software for GNU/Linux. Bianco said he would have his developer team begin work on releasing the source code in Mid-April. He openly expressed an interest in making the code availabe via Sourceforge. CMI's Genus line of timeclocks are Linux-based. Other Windows-based timeclocks were not discussed. However, CMI customers who express an interest in connecting other timeclocks to their existing or planned Linux systems may find CMI responsive. Simply releasing drivers and launching community-based projects, however, is simply not enough. Timeclock manufacturers need to make sure they work with outsource payroll vendors, accounting software vendors and customers to raise awareness of the GNU/Linux functionality. Businesses will not know that they can choose GNU/Linux unless the vendors make them aware of all their options. Ultimately, knowing what the options are helps businesses make better decisions. Additionally, Control Module, Inc. will need to work with business parnters to ensure they can communicate effectively with their customers the benefits of FOSS licensing and GNU/Linux functionality. At the bottom line, accounting and payroll solutions for GNU/Linux do exist. In cases where native solutions are not suitable, GNU/Linux users can still use hosted webservices to manage payroll. Since around 60% of the SMB relies on outsource payroll vendors, the key to helping these customers migrate to GNU/Linux will be for hardware manufactures and outsource payroll vendors to work together to make the software available and, beyond that, to promote it as another option for their customers. Meanwhile, businesses using or migrating to GNU/Linux will be best served working through webhosted services. Additionally, businesses also need to communicate with their accounting and payroll vendors that they expect GNU/Linux support. LXer is interested in hearing from GNU/Linux users how they handle payroll, and what challenges they have had had to overcome. References |
|
Comments (15)
You may want to call Ernie Ball http://www.ernieball.com/ They've been a Linux shop for quite a few years now.
In Linux, knoda with a mysql or postgres back end would (at least theoretically) handle about any size and complexity. It's not really 'difficult' to develop and link the database, queries, forms, and reports. Those databases will easily handle the calculations, and knoda uses python to extend the capabilities. The problem is that it takes many many hours to do it, and someone who knows what they're doing in both sql and python. Of course the advantage is that you get something specifically tailored to your operation.
Sorry.
http://www.linuxcanada.com
It has more features than QuickBooks Enterprise, the interface is similar to (though not exactly like) QB, and it's written in C++ using QT so that the graphical clients are available for Linux or Windows. The server requires Linux and supports Firebird, Sybase, and Postgres database servers.
It is GPL, though support contracts are available.
Quasar does not have payroll. I have thought about writing some Python extensions to support this, but I don't want to be liable for errors with something that has as many potential legal issues as Payroll (and taxes, and workers comp, etc). Plus, this would only work with companies that have all employees in one locality, because multiple localities mean multiple tax districts (and different tax rules), and tax information costs $$.
ALC, I'm using a one-off version of vTiger CRM to propose a new ticketing system for my company. This includes allowing employees to keep track of time spent on each ticket, to the 1/4 hour. To track costs etc in my own free time for my own personal projects (not work related), I had planned to connect vTiger to Quasar so that I could keep track of my tasks, what kind of tasks they are (because in IT, tasks have different accounting rules depending on if they are break fix {expenses} or new development {capitalization}), and how much they cost in $$. You could do this, too, except you still wouldn't have payroll.
Cheers, -JC
Actually Appgen *did* go under - back in 2002. They've been resurrected under some very curious circumstances and basically screwed their VARs over.
But from what I understand, this was not the first time for that to happen with this product.
I'd be very careful making any kind of new business using any of the "new" Appgen product line.
That said, there is still "MoneyDance" which had a short affiliation with the Appgen people, has none now.
1) I could not find the specific set of features I wanted in a single offering, 2) The closest I found I believe was created for the South African market and would have been difficult to convert for use in the US, 3) After that, the next closest product was no longer under active development 4) Next one had so many competing branches (derivatives of the same project) it all became confusing
That's pretty much where I stopped the search and kept with my manual ledgers. I have no employees (I hire subcontractors per project and issue 1099s at the end of the year.) I did a follow up about six months ago and I think Compiere came up first on my list. My only issue with them was they were tightly integrated around Oracle and I wanted an Open Source database. The license costs to 10g alone would probably eat up several months of profits. There was some efforts to support open source databases but the support did not appear robust nor long term.
I will probably follow up once more in the next few months....
Dave
Post a comment
A free account is needed to post. Write your comment here first: your text is kept in this browser while you sign up or log in, and is waiting for you when you come back.
Your message:Sign up and post (it is free) or Log in and post
D.C. Parris Editor-in-Chief