Taking Stock of Your Accounts

Most accounting systems can handle general business needs without too much fuss. As long as your business sells straightforward products using a simple pricing model, then it's probably OK to stick with a run of the mill accounting system.

But what if your products have:

• multiple units of measure
• serial and lot tracking with expiry dates
• different costs at each location
• more than one stock keeping bin location in each warehouse
• barcodes for each packaging unit
• the need to track costs by FIFO, Weighted Average Cost and Standard Costs
• more than one dimension such as Colour, Size, Season, Width and Depth and the pricing varies for each of these attributes
  
• Volume Pricing or Discounts by date range for both Sales and Purchases
• Complex cost calculations that include foreign and local freight charges, agent handling fees, duty, warehousing fees, insurance all allocated on the basis of weight, value or cubic volume
  

If you're using a run of the mill accounting system and your business has complex stock requirements, you're probably using spreadsheets and word processing and many error prone manual procedures just to get your invoices out the door.

More information: Axsapt

Are Your Manual Systems Up To Spec?

Changing over to a new accounting system is often considered a good way to improve cash flow and profitability. For example, tighter stock control and better forecasting will result in lower stock holding costs as just enough stock is held to avoid stock outs and reduce the incidence of stock shrinkage.

Great in principle, but before implementing a new software system, you should ensure there are adequate internal controls in your manual systems to complement the software systems. Examples include:

• Transport registers and security checkpoints at the warehouse gates
• Cheque and cash received registers

Segregation of duties is also important with medium to large organisations. This is where the custody of assets (stock, cash, debtors, fixed assets etc) is a separate function to the authorisation of transactions involving these assets. Examples include:

• sales order takers and stock control
• cash receipts and sales invoice/credit
• cash payments and creditors control
• payroll and human resources

Other areas that will reduce risks include:

• Providing "blind" Stocktake Sheets and Cash Count Sheets i.e. without expected values
• Surprise cash counts of random tils and petty cash
• Random stock counts of specific product lines or location.

Axsapt Business Software Consultants can help you identify the potential risks within your business and recommend appropriate changes to your systems (both manual and computerised) to reduce those risks.

More information: Axsapt

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