Forgot your password?

typodupeerror
Businesses Software Open Source News

Ask Slashdot: How To Run a Small Business With Open Source Software? 195

Posted by timothy
from the with-nothing-but-emacs-extensions dept.
First time accepted submitter ahree writes "I'm starting up a restaurant with my wife and a few friends and, well, I'd like to support the OS community and hope that this is a way to do it. Simply put, we need to take care of bookkeeping, accounting & payroll and I'd rather not use QuickBooks. I've heard of some options that are open source (GnuCash), some that are cheaper & simpler (WaveAccounting), but I'm wondering what your experience with them (and others) has been like."
This discussion has been archived. No new comments can be posted.

Ask Slashdot: How To Run a Small Business With Open Source Software?

Comments Filter:
  • lots of options (Score:5, Informative)

    by Trepidity (597) <delirium-slashdot AT hackish DOT org> on Saturday August 11, 2012 @11:58AM (#40957645)

    I would say most small businesses I know actually don't use any specific financial software, but do everything in a spreadsheet package. Excel rules the small-business world in a lot more ways than you might expect. You can probably do most similar things in LibreOffice. Now whether this is a good idea varies. The con is that you can end up with a sprawling spreadsheet-and-macros mess, but the pro is some flexibility in doing complex things, and simplicity in doing easy things.

    GnuCash is not a bad option either, but it works best if your processes map on cleanly to one of its default processes. It does standard double-entry bookkeeping just fine. Its documentation is pretty good, also. But if you want to be doing significant scripting or customized report-generation, I find spreadsheets easier than dealing with GnuCash scripting+reports.

    Depends on what kind of business to some extent. For example, if you need to interface with shopping-cart software or something of that sort, you may have more specific requirements.

  • SQL Ledger (Score:5, Informative)

    by colenski (552404) on Saturday August 11, 2012 @12:01PM (#40957677) Homepage
    http://www.sql-ledger.com/ [sql-ledger.com] ugly as sin but it does *everything* and it's reliable. Good community support.
  • Re:My first thought (Score:5, Informative)

    by Shoten (260439) on Saturday August 11, 2012 @12:05PM (#40957717)

    My first thought is that opening a restaurant is one of the hardest things in the world to do. If going open source helps lighten your load or costs in a significant manner and makes the restaurant launch more likely to succeed, then swell.

    If however its going to be a case where you cant get support, stuff doesn't work, and nobody is available to help bail you out when fixing your software isn't in the top 50 on your priority list...

    This is excellent advice, and I would add a bit more to it. Are you looking at Open Source because you're a Linux guru who is used to managing such types of systems, or because you want to save the money that you'd otherwise spend on QuickBooks and Windows licenses? If it's the first, then also consider how much time you'll have to be the sysadmin on top of your other non-IT duties there. If it's the second, then forget OSS. You'll save less than a thousand dollars, in exchange for which you'll have another learning curve thrown at you while trying to open your first restaurant. Restaurants have, as I recall, an 80-90% failure rate in the first year; don't give yourself more to have to deal with to save a tiny bit of money. Your IT infrastructure won't be large, but it MUST be functional and reliable.

  • Re:lots of options (Score:4, Informative)

    by UnknowingFool (672806) on Saturday August 11, 2012 @12:23PM (#40957871)
    The main problem with spreadsheets isn't that they aren't flexible; it's about time optimization. Accounting packages like QuickBooks are built for businesses so their automated functions like printing an invoice are streamlined. Not that you can't do that with LibreOffice but setting it up and maintaining it is just additional time. So either pay the extra for QuickBooks or spend XX amount of time printing an invoice. Some business owners only see cost in terms of money and not time.
  • Alternatives (Score:5, Informative)

    by LordThyGod (1465887) on Saturday August 11, 2012 @12:28PM (#40957915)
    I've been involved in the bookkeeping end of several small businesses. My suggestions .... as to payroll, do not do this in house. Its a PITA, and you will wind up either making mistakes you will come to regret, or spend more time on it that you might be able to use more wisely somewhere else. Keeping up with local tax districts, who lives where, when the govt(s) (assuming you are US) decide to make some subtle change to tax regulations. Penny wise, pound foolish to do this in house for most small businesses. As to basic accounting and booking, I am not aware of anything that does the sheer number of things that QuickBooks can do, or as well. But I haven't tried everything. This sounds to me like the kind of thing that is hard for free / open source projects to compete with. Maybe your needs are very simple? I would suggest some of the SaS products like FreshBooks. These may not meet your critieria of open source projects per se, but many of these have open API's which is a step in the right direction. Also, these are likely built with open source projects, eg Apache, Ruby, PHP, MySQL, Python and so on, so there is some second hand support of open source that way. They also free you from the local installation situation, and can be accessed via mobile or remote locations (ie work from home), with zero hassle. I have used FreshBooks for accts receivable situations, and found it very nice. Compared to QuickBooks, I would opt for FreshBooks for billing and invoicing easily. I have not looked at with acct payables or general ledger in mind though.
  • Re:lots of options (Score:5, Informative)

    by cayenne8 (626475) on Saturday August 11, 2012 @12:41PM (#40958031) Homepage Journal
    I love open source software, and try to use it myself whenever possible...where it fits and is the best tool for the job.

    However, on business financials....do NOT skimp on this. You need to track costs, billing, etc.....this is especially true at EOY when having to deal with your CPA, and the IRS. It is tough enough to have to deal with the myriad of laws and regulations the state and feds put on small businesses, go with something that is set up to help you out and accurately track finances, payroll, etc.

    I'd recommend going with Quickbooks. It is almost a 'standard'...which makes it easily portable between you and your CPA.

    Don't cheap out....get a good CPA to help keep you honest on your taxes....a good one will help you squeeze out every penny to keep for yourself legally, while being conservative enough to keep you off the IRS' radar.

    This is business...and $200-$300 invested on this....will help you out in the long run...and hey, you can write the QB purchase off on your taxes.

  • by blackC0pter (1013737) on Saturday August 11, 2012 @12:57PM (#40958171)
    Productivity:
    --Ubuntu (base OS)
    --Openoffice (office tasks)
    --Gimp (photo editing, photoshop alternative, lacks CMYK though)
    --Inkscape (vector editing, illustrator alternative)
    --Scribus (book/graphic design, vector+photos on multi pages, indesign alternative)
    --Gmail (email)
    --Google apps (professional gmail, sending from yourdomain.com vs. gmail)
    --Simple webpage for reservation system (if you take reservations)


    The biggest issue on top of this is the POS and accounting functions. I haven't researched open source tools for this and you don't want to mess these up. I'd pay for something decent in this area.
  • Re:lots of options (Score:1, Informative)

    by Anonymous Coward on Saturday August 11, 2012 @01:06PM (#40958265)

    Nowhere did they say they wanted to "cheap out" or "skimp out". They didn't say they weren't willing to pay money. They said they wanted to support the OSS community.
    If you honestly thing that Quickbooks is going to do a better job at handling the requirements for any small business than any OSS accounting software plus $300 of customization would do - that's fine. I'm sure there's plenty of people who would agree with you. But don't pretend this is about money.

  • Re:Pay for it (Score:5, Informative)

    by icebraining (1313345) on Saturday August 11, 2012 @03:04PM (#40959233) Homepage

    I may be biased, but I have to agree.

    I work for a FOSS based software company; we charge for installation, support, training and custom development of a GPL licensed ERP solution.

    Our clients get a much cheaper solution and we contribute back to the platform (bug fixes, new FOSS modules, etc).

    I won't plug my company, and the restaurant is probably not based on our country anyway, but I'd consider this approach.

  • Re:Think Ahead (Score:4, Informative)

    by oakgrove (845019) on Saturday August 11, 2012 @03:39PM (#40959429)

    You may be successful! congrats! you can now hire an accountant, they'll want QuickBooks.

    Have you ever really put this theory to the test? I called around my city and was able to compile a decent list of accountants who were familiar with and openly supported PostBooks [xtuple.com]. PostBooks is cross platform and is released under an OSI approved license.

    Of course finding that kind of thing out would require a good 20 minutes of a busy professional's precious time so I'm sure you'd be much better off just going ahead and buying Quickbooks without a second thought based on advice from a web forum rather than actual interactions with real accountants.

  • by hawguy (1600213) on Saturday August 11, 2012 @06:32PM (#40960433)

    Google Mail? It might be good, but companies better check their contracts. Since the small companies usually don't have public stock, Sarbanes-Oxley may not be an issue, but with clients is may be. To boot, not all mail providers be able to furnish documentation of SOX compliance. Come audit time, you really want that stuff ready to go when the auditor is present and requesting documentation.

    You would think that a company like Genentech with 11,000 employees would know a thing or two about whether or not their Google Apps [techrepublic.com] email solution meets all of the regulatory requirements they are subject to.

    Finally, who is the customer with Google Apps, the people using it... or the advertisers? Google might have a conflict of interest in that department. I'd rather stick with a mail provider paid for completely by the end user.

    You seem to be confusing the free version of Google mail with the paid Google Apps for Business which defaults to not serving ads. [google.com]

    Zimbra may be good enough for a college student to get their latest Facebook confirmation E-mail, but in a professional environment, it is not up to the task. This isn't to say OWA is perfect, but there are a lot of business functions that are Exchange-only:

    Zimbra has Outlook and mobile device integration, all secured by TLS/SSL

    Connectors. Yes, these are nothing more than just TLS connections with known certificates, but a lot of companies feel better when their clients are able to have a dedicated, encrypted connection.

    I don't even know what that means in the context of an email server? Are you talking about a persistant connection between Outlook and the email backend or a VPN?

    In any case, Zimbra can do more than deliver Facebook status messages, they have a pretty broad customer list [zimbra.com]

    Policies. Almost all devices work with Exchange, and fewer and fewer lie to it about capabilities. If a device went missing, triggering a remote erase will work regardless of which maker or OS is on the device. No other E-mail system has this in place.

    Data at rest encryption. Exchange can pretty much guarantee that any device touching it either lies convincingly about encryption (like earlier Android versions), or actually implements it.

    Zimbra has had remote wipe [zimbra.com] for years. Even Google Apps has remote wipe [google.com] capability. And they can also enforce encryption and other ActiveSync security policies.

    If one wants to play GSA contracts, this might be a major factor for state or Federal business.

    Maybe Google doesn't know anything about the government sector. [google.com]

    Believe it or not, there is competition in the email server market, but most companies don't bother because once they buy the CALs and build a server infrastructure to run their other Microsoft applications, Exchange doesn't add much more to their Microsoft cost. But some companies are still finding it cost effective.

"Plastic gun. Ingenious. More coffee, please." -- The Phantom comics

Working...