Bend in the Weather (Entries tagged as accounting)

Internet Usage Monitoring - conky style!

mbottrell@gmail.com (Matt) — Mon, 19 Jan 2009 03:18:00 +1100

In Australia Internet users are limited to the amount they may download. Each Internet Service plan normally involves a speed and download limit. Failing to keep an eye on this and exceed your limit normally effects the user in question either by:

Paying exorbitant excess fees that can be as much as $150/GB!
Being 'throttled' by your ISP, in effect turning your lovely xDSL/Cable connection into something slower than dial-up.

As you can image, most people wish to avoid these. As a result ISPs provide a usage meter normally on their site, however you have to remember to view it, which unless you're diligent in doing so, you can still run over your quota.

Previously I've relied on the fabulous Firefox extension NetUsage, however this meant you had to have a browser open. This isn't always the case, and I found it frustrating to have to load a browser just to check my usage. (I could just login to the ISP's usage meter if I had a browser open).

I've seen others produce mrtg graphs and even Cacti graphs to display their usage; however they too also rely on having a browser open.

Ideally, I want to have my usage available, when I wanted, and without loading a browser.

I use conky on my desktop to display a range of information. It seemed a logical step would be to integrate a meter into my conky setup.

As you can see from the graph in the picture to the left, it displays a raw percentage of what has been used, as well as a visual bar graph. Below that is the raw data, showing exactly how much I've downloaded (~11.5GB), what my ISP believes my quota to be (55GB in this case), and when this billing period ends (the 13^th of every month).

I can now view my current Internet usage at a glance, without the need to load any additional program.

So how did I achieve it? Like many ISPs, my ISP provides an interface to the raw data. This is used by 3^rd party utilities like NetUsage and others to parse and generate the information. Internode (my ISP) has such an interface.

A quick and dirty script and I was able to spit out the graph in a format conky liked. Whilst this works directly with Internode, similiar ISPs have such interfaces and you will be able to hack the script to suit your own environment.

Below is the simple bash shell script used to generate the data:
#!/bin/bash # Get usage information from Internode's web page. # Setup to run once every half hour. # # Set the username and password Username=INTERNODE_USERNAME Password=INTERNODE_PASSWORD # Grab the details Temp=`wget -q -O - --post-data "username=${Username}&password=${Password}" --user-agent="Conky ISP Quota Grabber 0.1" https://customer-webtools-api.internode.on.net/cgi-bin/padsl-usage` # Generate the percent used. echo $Temp|gawk '{print $1/$2*100}'> /tmp/node-graph.txt Percent=`cat /tmp/node-graph.txt` echo $(printf %.0f $Percent) > /tmp/node-percent.txt # Break up the values into their respective parts Values=($Temp) echo "Used: $(printf %.0f ${Values[0]})MB Quota: ${Values[1]}MB Period Ends: ${Values[2]}" > /tmp/node-text.txt # Time to leave. exit

Sure it's not the most secure script (It stores your username/password in plain text). For me, the script sits on my desktop machine... and is protected by file permissions. The password I use for my ISP I also don't consider highly sensative. (It's important to note that most people throw around their password in clear-text across the Internet when picking up their mail with POP3! ). It does however do the job.

The above shell script I run every 30 minutes from cron.

It is then up to your ~/.conkyrc file to display the results. Here is the snippet of the appropriate code for the ~/.conkyrc file that will do that for you:

${color orange}INTERNET USAGE ${hr 2}$color ${execi 900 cat /tmp/node-percent.txt}% ${execibar 900 cat /tmp/node-graph.txt} ${execi 900 cat /tmp/node-text.txt}

There you have it, a simple ISP usage meter sitting right on your desktop.
It's not the most elegant or complicated program, however it serves it's purpose extremely well. YMMV.

Time for an Australian OSS based Accounting & Payroll program

mbottrell@gmail.com (Matt) — Wed, 09 Jul 2008 00:49:00 +1000

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. It is however a required evil if you wish to be paid and be compliant with the taxation law. (Particularly GST, BAS reporting and PAYG).

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. fiveDASH, I played with for several hours, though I found it quite primitive and in it's infancy... it's one that at least has some promise, but it will need to progress quite some way to make it in any real production system for a business.

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. I'll run a dummy book up til the time, by running MYOB in parallel to ensure all is working as required. The ATO also has some excellent test suites/scenarios to assist in testing an application.

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:

Most SMB that have a Linux server for File and Print serving also have a LAMP environment already setup.
Writing the system using say the Zend Framework ensures a lot of the ground work is already done. Working within their coding standards also ensures the code is reasonably clean and readable (and thus maintainable).
Python was also considered, but it's more likely a SMB has a Apache/PHP environment over an Apache/Python setup
I already have quite a number of generic PHP libraries that will mean I can get moving much faster. My Python libraries are no-where as extensive.
A Java-based web app would be an overkill and likely to confuse many small business owners. (ie: Install a Java Application Server, etc.)
SugarCRM is already popular in many SMBs. It would be quite easy to have an Accounting + Payroll package integrate into SugarCRM. Sugar is written in PHP, so it would make the job much easier if they both spoke the same language.

I haven't commenced any coding to date, and am still in the embryo stage of getting something up off the ground.

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?

The difficulty of Aussie small businesses adopting Linux

mbottrell@gmail.com (Matt) — Sun, 08 Jun 2008 12:29:00 +1000

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:

Handles Australian Taxation - including GST and BAS reporting/lodging
Handles Australian Payroll - including PAYG and Superannuation

The introduction of both these two options would see thousands migrate off Windows (it's often the only reason cited for not running Linux), and adopt a new accounting package.

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:

Do I run SYMBOL and either start maintaining it or fork it?
Do I use a lot of the program logic, and spawn a completely new project?

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:

There are about 1.2 million small businesses in Australia employing around 3.3 million people.
During the past decade, small businesses have created an estimated 660,000 new jobs.
42% of all goods exporters are small businesses.
25% of the Australian GDP (estimated in 2006 at $1 trillion dollars) comes from small business.

That's a lot of potential users of an OSS product!

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?