Using MYOB Accounting Software

Performance reporting and analysis - or, how to get decision-making information

The example below is the recognisable format output from an MYOB generated Profit and Loss report, exported into Microsoft Excel.  The raw numbers appear are as they are generated by the MYOB system, however, performance ratios (in purple and green) have been added to the Excel spreadsheet to produce meaningful ratios to compare monthly performance. 

Key points to note about the performance of this company are:

  1. Although there has been an erratic Gross Margin swing (12% to 21% over six months), gross profit dollar growth has been through a more extensive 'swing' (51% to 145%)

  2. Expenses (apart from two major reversals in April) are in line with sales income.

  3. The erratic gross profit dollars have flowed through to deliver a worsening and unacceptable trading profit result for the last four months - the company is in trading profit difficulty which it must reverse

These performance ratios demonstrate that this company, while not fatally 'financially wounded' is struggling to maintain performance consistency AND has lost money for four consecutive months at a rate of 4% of sales income.  The report detailing the next six months performance will definitely be interesting reading!!!

Similar performance reports, including balance sheet information from MYOB, can be created to deliver an even clearer and in depth picture of trading profitability and underlying financial health.

 

Remember, profit is not cash AND cash is not profit!

 

Example MYOB Report: -

Dan Byrd Manufacturing

            

P O BOX  5134

 

            

Temora, NSW

 

            

Profit & Loss Statement

          

April 2003 through Sept 2003

            
               

 

April

May

June

July

August

September

Total

Income

  

Sales

 $97,941.47 $103,627.37 $92,517.48 $109,259.32 $92,391.86 $98,335.84 $594,073.34

Total Income

 $97,941.47 $103,627.37 $92,517.48 $109,259.32 $92,391.86 $98,335.84 $594,073.34

             

Cost Of Sales

              

Purchases & Freight

 $68,535.69 $61,900.53 $62,579.89 $70,621.04 $61,092.43 $60,874.08 $385,603.66

Purchase Rebate

 ($143.85) ($221.12) ($234.16) ($214.63) ($144.46) ($174.40) ($1,132.62)

Wages - Workshop

 $6,499.64 $13,854.58 $12,804.44 $14,955.31 $13,854.58 $16,434.83 $78,403.38

Wages - Directors

 $5,248.98 $6,261.60 $6,261.60 $7,827.00 $6,261.60 $7,427.67 $39,288.45

Total Cost Of Sales

 $80,140.46 $81,795.59 $81,411.77 $93,188.72 $81,064.15 $84,562.18 $502,162.87

             

Gross Profit

 $17,801.01 $21,831.78 $11,105.71 $16,070.60 $11,327.71 $13,773.66 $91,910.47

Gross Margin

 18.18% 21.07% 12.00% 14.71% 12.26% 14.01% 15.47%

Gross Profit Growth

   122.64% 50.87% 144.71% 70.49% 121.59%  

Expenses

              

ACC Levies

 ($3,127.99) $284.13 $284.13 $2,745.80 $284.11 $351.72 $821.90

Accounting Fees

 $0.00 $0.00 ($354.55) ($85.00) $783.33 $0.00 $343.78

Advertising-Promo

 $1,037.62 $1,339.22 $2,482.39 $3,757.96 $1,222.89 $1,806.19 $11,646.27

Bad Debts

 ($3,135.20) $96.00 $0.00 $2.86 $0.00 $0.00 ($3,036.34)

Bank  Charges

 $41.60 $91.20 $170.19 $58.80 $168.45 $207.13 $737.37

Bartercard Charges

 $22.28 $82.12 $27.17 $37.50 $28.33 $103.53 $300.93

Computer Services

 $97.50 $0.00 $500.00 $525.00 $0.00 $0.00 $1,122.50

Cleaning

 $142.40 $123.60 $290.43 $164.50 $3,354.65 $313.00 $4,388.58

Credit Card Charges

 $560.83 $796.16 $737.39 $862.70 $1,017.55 $557.10 $4,531.73

Commission

 $99.87 $219.13 $128.13 $93.73 $117.68 $93.40 $751.94

Donations

 $0.00 $0.00 $0.00 $265.00 $185.00 $0.00 $450.00

Equipment Hire

 $111.12 $111.12 $111.12 $111.12 $111.12 $111.12 $666.72

Training Fees

 $0.00 $600.00 $0.00 $0.00 $0.00 $0.00 $600.00

General Expenses

 $80.00 $400.00 $40.31 $204.53 $133.33 $920.92 $1,779.09