Showing posts with label Spreadsheets. Show all posts
Showing posts with label Spreadsheets. Show all posts

Wednesday, November 25, 2009

Business Intelligence

A good Business Accounting System will help you accurately record your business transactions such as revenues and expenses, assets and liabilities. You do this to ensure that all your income is properly invoiced and collected and you maintain control over your expenses.

You also have a statutory responsbility to accurately calculate profits for tax purposes and keep track of withholdings from your employees to remit to the Government.

In the process of running your business and recording all these transactions, wouldn't it be nice to analyse your past activities to alert yourself of potential problems and identify opportunities to improve your business profitability?

A Business Intelligence ("BI") system will help you make sense of your business activities and transactions by:

  • Presenting results into easily understood tables and graphs
  • Calculating Key Performance Indicators ("KPIs") that highlight inefficiencies with inventory, customers, suppliers and other areas of your business
  • Categorising your customers, products and services and comparing the results achieved by sales representatives over time and across similar categories to identify potential opportunities

A good BI tool will work with disparate business systems in your organisation and eliminate the need to rekey information into Spreadsheets.

The ultimate aim of BI is to make more informed business decisions.

More information: Axsapt

Thursday, November 05, 2009

Can you Personalise your Accounting System?

There's nothing wrong with buying an off the shelf accounting, payroll or CRM system if it meets most of your current needs. If, however you feel your business will grow over the next few years, you should consider the configurability of your business system to avoid the high changeover cost.

There are varying levels of business systems out there from rigid entry level systems like Quickbooks and MYOB to fully customisable packages such as Sage CRM and Sage Accpac ERP.

Typically all small to mid size systems will be relatively quickly to implement provided you accept a best practice template, but as a business evolves, it's needs may result in inefficiencies in processing day to day activities.

For instance, you may need to record aspects of attributes of customers that just won't fit in any of the available fields within your CRM system. Some systems anticipate common expansion requirements by preallocating an number of "unused custom fields". The better systems allow you to define your own fields and map them to screens without much effort. Custom workflow can also be defined that controls when these variables appear and alerts others of required activities when concern conditions are met.

These sorts of systems are often more cost effective than performing manual external processes with spreadsheets for instance or rekeying duplicate information across disparate systems.

More information: Axsapt