Session four
Bottom Line3 tasks

Session 4: revenue allocation

This example uses the MyBakery data which is provided with the software. If you have not loaded the MyBakery data file, open the file before you continue.

Introduction

Input of revenue follows the same steps as input of expenditure. This time you are being asked for your revenue account instead of your expenditure account. The right-hand columns are now revenue items, and you have to allocate these to the industries, listed in the left-hand sector column, that your organisation sold its products to.

Revenue allocation

For example if you sold cakes to a Warringah Mall fast food outlet the corresponding revenue would be allocated to the ABS product group Retail trade. If you sold your pies to people visiting your shop, these earnings would be allocated to Private final consumption. If you sold bread to the Newtown café strip these earnings would be allocated to Hotels and licensed clubs, cafes and restaurants.

Note that, assuming that your expenditure and revenue account are balanced, fields B5 in Expenditure and Sales show identical figures. If your accounts are slightly out of balance, then this is probably because profits or losses are excluded in your balance sheets. But don’t worry – the ISA software will automatically allocate all:

• profits to Gross Operating Surplus; and
• losses to Private Fixed Capital (assuming you’ve covered losses through a loan financed by private capital)

Inputing data

Input of revenue follows the same steps as input of expenditure. This time you are being asked for your revenue account instead of your expenditure account. The right-hand columns are now revenue items, and you have to allocate these to the industries, listed in the left-hand sector column, that your organisation sold its products to.

For example if you sold cakes to a Warringah Mall fast food outlet the corresponding revenue would be allocated to the ABS product group Retail trade. If you sold your pies to people visiting your shop, these earnings would be allocated to Private final consumption. If you sold bread to the Newtown café strip these earnings would be allocated to Sector Group: Trade and product group Hotels, clubs, restaurants and cafes.

* Assuming that your expenditure and revenue account are balanced, Expenditure and Revenue show identical figures. If your accounts are slightly out of balance, then this is probably because profits or losses are excluded in your balance sheets. But don’t worry – the ISA software will automatically allocate all :

• profits to Gross Operating Surplus; and
• losses to Private Fixed Capital (assuming you’ve covered losses through a loan financed by private capital)

Next Next: Margins and taxes

 

 
Top of pageTop
   
 
Planning
Methodology
Software
Input data
Output data
Reporting
TBL implementation