Wednesday, July 9. 2008Time for an Australian OSS based Accounting & Payroll program
Ask any small business owner in Australia what drives them craziest running their business.
More often then not the answer will be their accounting software. Why? It's not because they are unable to understand the principles of double-entry accounting or even the tax system imposed on them. No, its the lack of a decent, flexible and affordable solution. The two most popular business accounting packages for the SME is either MYOB and QuickBooks. Both have huge hurdles, and it's not uncommon for users to find that they spend more time attempting to work the software than the software working for them. I have previously blogged about the issue when talking about how Linux is difficult for many Aussie SMEs to take up. (Mainly due to their critical accounting software only available under Windows, though it is possible to run them under WINE if required). Though getting these Windows programs running under Linux doesn't actually solve the problem, it just migrates it. You are still stuck attempting to drive these frustrating accounting packages. The Australian market is crying out for an alternative! It's something I've pondered over for some time. An OSS based accounting and payroll system that put the source code directly in the hands of the users would be appealing to many. I like the idea of a browser-based accounting system. It means end-users aren't restricted to one operating system platform, and in theory it doesn't need to be restricted to just a computer. (3G Accounting anyone?). Accounting isn't fun, in fact it's dead-pan boring. I've looked at programs like SQL-Ledger and LedgerSMB, though both didn't 'fit right' for an Australian environment. SYMBOL was promising. But unfortunately has been abandoned. As such, I've decided to look at writing my own. This is purely selfish, as I would like to ditch MYOB come the 2009-2010 financial year. That gives me just under a year to get something up and running. The big choice now is from what components should I build it? I think PostgreSQL is probably the most solid OSS database to use, though writing something that can also talk to MySQL (due to it's popularity) is probably also wise. End-users can then elect to run whichever they feel most comfortable for their backend. I considered many languages, but I'm leaning towards PHP for a few reasons:
I'm interested to hear people's feedback with their thoughts. Do you think a PHP application (backended by your choice of MySQL or PostgreSQL) for your business accounts is feasible? (Obviously if 'approved' by the ATO as compliant). Do SMB owners prefer the option of paid software with support packs? (like offered by MYOB and Quicken) they can fall back on? Would you not trust your business books to an OSS based accounting package? What other hurdles do you envisage if you used OSS accounting software? Monday, June 23. 2008Firefox 3 - What The?!It's always interesting to see some of the organisations that made it possible! Tip: Click on the image to see a larger version. Tuesday, June 17. 2008Firefox 3 - Come break a world record! At 3:00am AEST on Wednesday 18th of June will herald the release of Firefox 3.It's a big jump ahead from the heady days of Firefox 1 and Firefox 2 days. The guys over at SpreadFirefox are attempting to set a world record, with the most downloads in a given 24 hour period. You too can be part of it! I'm currently running one of the Release Candidates, and I've found it brilliant, all my favourite add-ons are now working flawlessly in it. So help spread the world, Australia has around 30% of it's Internet users using Firefox these days. So people do understand and utilise the crazy fox based browser. Moving more people off Internet Explorer will also ensure that Australian websites that wish to remain 'visible' will also start writing websites that are browser agnostic and follow the W3C standards (something IE only websites break heavily). Microsoft claim that they are going to be moving fully to standards compliance with IE8, but don't hold your breath. We've been hearing that for years. As long as nasty ActiveX still hangs around like a bad fart in a crowded elevator it's not going to be compliant (or safe for that matter). And yes, IE8 will ship with ActiveX. So hop to it! Pledge to download Firefox 3 on Wednesday, and become a World Record Holder! Saturday, June 14. 2008Stop whining about Wine printing!
Wine is a way to run native Windows applications without Windows.
The Wine project have been able to replicate the APIs required to run quite a number of applications under their environment. It's one way you can run your legacy Windows applications under your Linux desktop. I daily run Wine for a number of applications for business:
Here's the blurb off their website: Friends, vintners, penguins, lend me your ears:I recently blogged about how hard it is for many small businesses to move off Windows. One way they can (particularly those that are on pre-Vista desktops and don't wish to go to Vista) is to utilise Wine for those legacy business Windows applications that need to run. This way they can keep their functionality, but move to a more secure, less restrictive (licensing) operating system and a better and more richer computing experience in my opinion. I recently attempted to see if I could run MYOB under Wine. Currently Pauline is stuck on Windows, due to her requirement to run MYOB to do our company books. MYOB ran under Wine without a hitch. Well... until I went to print. It went off to the dark printing gods and spat out an empty plain page -- no matter what I printed. And thus is the reason for this blog post. — – — – — If anyone does business accounting, you realise printing is a key feature. Many hectares of forests from the Amazon are destroyed each year keeping up with the legal requirement of keeping financial records. (Personally we print a lot to PDF -- but still, under Wine this was failing for us!). Scroll through many Linux forums/help sites and you'll hear people whining and complaining about printing under Wine. It seems to have also increased with the introduction of CUPS. From what I could see people where having problems printing to a physical printer most of the time, even though their CUPS printers correctly are represented and available in Wine. (This is exactly what I was seeing -- just blank pages printed). Unfortunately this was going to be a show-stopper. Without a way to print (paper or electronically) for MYOB the idea was dead in the water. I didn't want to run Windows XP in a virtual machine (more on that in my next post over the following days). I decided to sit down and take a bit of a fiddle (that's a technical term!) Really -- if CUPS-PDF didn't work, nor did my native printers attached; even a Postscript file would be sufficient (I could then feed that into ps2pdf or something similar if I really wanted it in PDF format for Emailing, or just print the Postscript file directly to the printer). I found that within the printing application I could create a virtual printer that printed a postscript file directly to a file in Linux. Okay, that works fine under Linux... Now the big test, did it print fine with MYOB running under Wine? I could see the printer fine (as I could with all the other CUPS printers previously). I bit my bottom lip and hit print. Low and behold... a working report! Even better I could link the Postscript printer to the CUPS-PDF printer and it would convert it auto-magically into a PDF for me. I since tested a range of applications under Wine and they all seem to be printing. So if you need to print in Wine and don't want a headache, try the local Postscript virtual printer hack. It works well. For those that want to replicate it, here is a series of pictures showing the Postscript printer properties. And if you still don't believe.... here is some sample print jobs:
So have fun and happy printing from within Wine. Wednesday, June 11. 2008Improving the Gnome terminal
I've been hearing ramblings on a few blogs about a little app called Terminator. (No it isn't Arnie hitting ya desktop), but in fact a terminal program that can do split screens and a bunch of other funky stuff.
Here's the blurb straight from the Terminator website: Terminator is an attempt to maximise useful space on a given desktop for terminals. I’m a sysadmin by trade, so I live in ssh sessions and thus terminals. An extra line here and there over all those hours seems like it’s worth trying for. It can be found in the Ubuntu 8.04 (Hardy) repositories, and the Debian Sid repositories. If you're running those distros, you can just click here to install terminator Those still stuck on Ubuntu 7.10 (Gutsy) can also install it. Just add the following lines your /etc/apt/sources.listfile: Monday, June 9. 2008Visit Disney World - in the luxury of your own home We all enjoy a good holiday. Getting the time to take one always seems to be the problem for me however. If you're like me you grew up watching The Wonderful World of Disney at 6:30pm every Sunday. Here we marveled at cartoons of Mickey, Goofy and other great Disney characters. (So much so, many the hostnames on my home network are now named after Disney characters! It also introduced us to classic 'childrens' movies like Herbie, 101 Dalmatians, Mary Poppins and Alice in Wonderland. It's probably the dream of every child to visit the magical place of Disneyland or DisneyWorld. With the help of Google you can now explore DisneyLand without leaving your chair! Google has produced a 3D interactive representation of Disneyland inside Google Earth. If you've got Google Earth installed try the following:
It's nearly as good as being there! Just think - no more queues for rides, no long-haul flight getting there, and the park is now open 24 hours for you. Have fun exploring! Sunday, June 8. 2008The difficulty of Aussie small businesses adopting Linux
There are many reasons people are stuck on Windows.
For small businesses the main reason is their accounting software. Like it or not, since the introduction of GST and BAS the days of the shoe-box accounting have disappeared. Every business that wants to keep accurate financial records requires an computerized accounting system. In Australia, The introduction of GST and BAS has made it difficult for these same people to move over to Linux. The two most popular Small Business Accounting packages are MYOB and QuickBooks. Both products support the Australian market and handle submissions to the ATO. Many small businesses look for software that can handle base accounting (less then 25 invoices a week) and an integrated simple payroll module that can pay their employees (1-5 typically). Both QuickBooks and MYOB operate as closed-source commercial software that runs on Windows (and on Mac - in the case of MYOB). They also integrate heavily into Microsoft Office. Both business models expect customers to fork our between $500 - $800 for the initial purchase, and anywhere from $200- $500 annually to get 'updates'. For any small business this is a hefty investment just to keep up with the legal requirements of running their business. Calling for support can also attract additional fees on top of the yearly retainer. As such, many are fearful to move on, but have a love-hate relationship with their accounting software provider. They feel cheated and ripped off (and rightly so). This duopoly has created a handsome cash-cow for both software makers. The current extortion model used by MYOB and Quicken is best explained by Turbo Cash's explaination (a GPL Windows Accounting package). Unfortunately TurboCash is Windows software and contains no Australian payroll module. Unfortunately, I am yet to see an OSS Linux accounting software that handles all the features required for an Australian business:
There is both Ledger-SQL and LedgerSMB (a fork of the former) that handle accounting and can be customized to handle GST. Yet, they don't do anything to address BAS reporting/lodging or have a payroll module. As such, both are unsuitable for the Australian SMB market without further heavy lifting. Their is commercial software like SAGE AccPac available, yet it's quite expensive and more geared towards a medium sized business and thus out of the price range for most small businesses. One OSS project that did look indeed promising was SYMBOL (Surf Your Money Books On Line). It was written by an accountant from Western Australia and licensed under the BSD license. I have been in Email discussion with the developer Edward Metcalfe, but it appears he has now moved on from the project and as such the project has stalled. Looking at the CVS repository the last update was unfortunately 13 months ago. However, the software is indeed functional and delivers on the two items listed above (Australian Taxation/Payroll). Whilst you would need to update the PAYG tax tables (no real show-stopper), it should do the job admirably. ComputerWorld actually ran an article on SYMBOL in Februrary 2007. Those interested in SYMBOL, will find it is a web-based application so accounting can be down via a regular browser (making it suitable on either Mac/Windows/Linux clients) It runs on a PostgreSQL backend and uses Perl/CGI for the front-end. It also is multi-user based. (One thing software like MYOB and Quicken charge an arm and a leg for!) The fear of running SYMBOL though in it's current form is that it is unmaintained. It's likely the current government or subsequent ones will indeed look at overhauling the payroll and corporate tax systems (as opposed to just an implementation of the Goods and Services Tax). This would mean that any software a small business adopts would need to address these modification. The ATO has worked to provide great documentation on the complex tax scheme we have in Australia for software developers. Their Software Developers Website gives test case scenarios and formulas to write compliant and competing software. I'm in two minds:
Ideally I would love to see a AJAXed based web-version of the application with a modern interface using either the Yahoo UI or the Dojo Toolkit's Dijit and DojoX interfaces. Either solution would provide an excellent interface and provide the user with an experience that matched a local fat client. Using a web framework like Django and a PostgreSQL database underneath, would make for a solid backend. I think there is a market for an excellent OSS product to capture the market and knock off this duopoly. However I suspect it will take some committed individuals to pull it off. From the grumblings you hear frequently from small business owners there is a ready market to ditch their over-priced software once a viable and supported solution arises. Here are some interesting facts about the Australian Small Business Market:
I suspect a lot of OSS developers do a fair amount of moon-lighting and as such require a way to invoice for their work. (Consulting may be your day time job also to pay for the bills, and OSS coding your passion and after hours work!). So what are your thoughts? Is there enough interest in getting up an OSS Accounting+Payroll solution for Australian small businesses? Wednesday, June 4. 2008Sourceforge mirror now on Internode
On Tuesday, Internode announced that they are now mirroring Sourceforge.
This is fantastic news for all OSS lovers down here in Australia. Whilst we have had the up and down again service from Optus for some time, it's great to have an alternative. Even better, customers of Internode will actually get those downloads for free now. (Whilst I don't download Gb's of data each month of Sourceforge, I do grab things regularly off it! -- and every little bit helps.) More importantly, having a speedy mirror to grab code off is what counts. It's great to see Internode -- a company that uses a lot of OSS software in their service delivery give back to the community that makes it happen. Their range of free mirrored content is quite appealing. They run their own download mirror site and for a Linux lover there is a huge selection of distros, and updates mirrored. Even better it supports rsync so you can grab your updates quickly and easily! Add to it, now Sourceforge and MajorGeeks (for Windows software lovers). I regularly make use of their free streaming radio content. They have stuff also for gamers (who's got the time ?! The Sourceforge content is hosted here: http://internode.dl.sourceforge.net/ but you'll need to use the Sourceforge website to pick a download, then select Adelaide, Australia from the list of download options. (The direct link to the Internode mirror isn't browsable). — — — After reviewing this post, it does sound like an advert for Internode! Having said that, I've used a bunch of ISPs over the years, and I haven't been happier than I am now with Internode. The service is always faultless, 13-NODE (Tech support) is answered always promptly by someone who actually understands technical details (and not a messenger service for a tech team). I've even had technical staff diagnose and fix routing issues whilst I've been on the phone with them! So if you're in the market for a new ISP, give them a go. Sure, they aren't the cheapest ISP going around, but they are probably the best technical ISP and have some real added bonuses for OSS fans. Tip: For those that do wish to sign up with Internode, one way to pickup an ongoing discount of 15% is to register as a SAGE-AU member. Get the benefits of being a SAGE-AU member -- and cheaper Internet access. For me, the cost of the SAGE-AU membership is less than the discount.. so I come out ahead! Saturday, May 31. 2008Forget Microsoft Office Documents forever!How many times do you get sent MS-Word, MS-Excel or MS-Powerpoint files? Whilst OpenOffice does an excellent job opening them all, I would prefer them all in an open format natively. It appears the Dutch may come to the rescue and make that dream a reality. Reading through IDABC website it appears that the Dutch Council of State are going to open-source an application they have written that allows you to convert flawlessly between Microsoft Office <-> Open Office. It can also convert -> PDF. At present, the only minor hiccup is images generated to PDF are a little 'darker'. Really, I am happy to just get MS Office -> OpenOffice. Really the European approach to OSS is a beacon of light that hopefully is adopted across all regions. The days of proprietry file formats are quickly disappearing. For future generations and long term storage Open Standards in file formats in mandatory. History will look back at the stand the EU has made against Microsoft and show that their stance was the under swell that pushed many in that direction. It's great to see South Africa has also filed their appeal against the OOXML becoming an ISO standard. It does show there are some people left within ISO that still have a back-bone and conscience. South Africa challenges the validity of the final vote that we contend was based upon inadequate information resulting from poorly conducted BRM. Moreover, we challenge the validity of a process that, from beginning to end, required all parties involved to analyze far too much information in far too little time, involved a BRM that did not remotely provide enough time to perform the appointed purpose of that procedure, and for which an arbitrary time limitation was imposed to discuss and resolve a significant number of substantial responses, despite the Directives for not requiring any such limitation as to duration.Let's hope this appeal isn't squashed in a face-saving exercise by ISO. The entire ISO process surrounding the adoption was flawed from the start with many unethical breaches of conduct undertaken during the whole voting process. |