As a certified QuickBooks engineer I have been on the lookout for a good, reliable alternative to QuickBooks that could cover budget-strapped companies’ accounting needs. I finally found FrontAccounting, which offers tons of possibilities, is simple to install, is completely web-based, and best of all is free. The application might seem a bit overwhelming to anyone looking for a simple money management tool, but for those looking to take control of the company accounting and standard ERP, this tool has it all.
- Purchase Orders
- Goods Receivable Notes
- Supplier Invoices/Credit Notes
- Accounts Payable
- Items and Inventory
- Sales Orders
- Customer Invoices/Credit Notes
- Accounts Receivable
- General Ledger with Budget
- Multiple Companies
You can install FrontAccounting on any server that meets these requirements:
- A working HTTP web server (e.g., Apache, IIS)
- PHP installed on the web server
- A working MySQL server with innodb tables enabled (see notes below)
- PDF Viewer (for viewing the PDF reports)
Follow these steps to install FrontAccounting:
- Create a database called frontacc. (I like to use the MySQL Workbench tool for this.)
- Download the archive from Sourceforge.
- Move the archive into the document root of the web server.
- Unpack the archive in the document root.
- Give the newly created directory write permissions for user, group, and other. (You might want to revisit this step to tighten security after installation is complete.)
- Point your browser to http://ADDRESS_TO_SERVER/frontaccounting/ and begin the simple web-based installer.
Once you’ve reached the web-based installation, you are home free. Simply fill out the necessary sections, and FrontAccounting will do the rest. You should make note of the admin user/password because that will be the only way to enter the site.
The first task, upon authentication, will be to go to the Setup tab (Figure A) and walk through the setup of the company, users, taxes, and more.
This is where many users might be put off from FrontAccounting. (Click the image to enlarge.)
Although it might seem overwhelming at first, you should go through each section of the setup. When it’s complete, you will have an incredibly powerful accounting tool that will work wonders for your small business and/or non-profit.
I won’t get into accounting best practices, though I will point out that it is critical to the function of your accounting and your installation of FrontAccounting to make sure this tool is used properly with respect to accounting. But, unlike QuickBooks (or QuickBooks Point Of Sale), you won’t be checking in inventory against a Purchase Order to update inventory quantities; this is handled through the Inventory Adjustments section. Although FrontAccounting is an outstanding accounting package, it should not be used as a point of sale system.
Before diving into FrontAccounting, I highly recommend reading the FrontAccounting ERP Wiki, so you can get up to speed on how to use the tool. Unless you get a proper start with the tool, you’ll wind up having to make some possibly serious corrections down the road. Those corrections will take up precious time and potentially lead to data loss. You can avoid this altogether by making sure you know what you’re doing before you start using the system.
FrontAccounting offers plenty of maintenance. The most important aspects of maintenance for the administrator will be these options, which you can find by going to Setup | Maintenance:
- Backup and Restore
- Create/Update Companies
- Install/Update Languages
- Install/Activate Extensions
- Install/Activate Themes
- Install/Activate Chart of Accounts
- Software Upgrade
An automated backup cannot be created within the tool. Since the backup tool only does a dump of the database (which you will need to download), it will also be necessary to back up the frontaccounting directory (which can be automated). With the help of cron or the Windows Task Scheduler, it would be possible to create an automated backup of the system.
As you can see in Figure B, the backup system is fairly rudimentary. It does, at least, offer the simple means of uploading a database dump back. So if the site went belly up, the worst case scenario is you re-install the site and then upload your backed up database with this tool.
If you view the backup, it will download the backup as a php file called backups.php, which can be viewed through a browser or an editor. (Click the image to enlarge.)
FrontAccounting might seem too robust for a small business, but the more help that can be offered for accounting and ERP, the better. FrontAccounting is an incredible way to manage your business. Give it a try and up your DIY cred!