Page tree


 

 

You can use Client Accounting to record livestock movements and quantities, calculate average cost per animal and present these amounts neatly in a Livestock Trading Statement.

To help you reconcile livestock movements with your client's stocktake report, we've provided a Livestock Calculation workpaper.

The Livestock - Closing Balance workpaper available in MYOB Client Accounting allows you to reconcile values and quantities to your client's stocktake and make adjustments to bring these balances in line. These quantities and balances will be reflected in the Livestock Trading reports available in MYOB Statutory Reporter.

We've made this workpaper available to all Client Accounting users. So even if you don't have workpapers, you can still access the Livestock Calculation workpaper in the Trial Balance period under Farming in the Tasks Panel.

The Livestock Trading Statement is available in Statutory Reporter for MYOB Ledgers, AccountRight and Essentials ledgers.

If you've configured a MAS, AE Accounts or AO general ledger, use the livestock calculation functions within your MAS, AE Accounts or AO General ledger software.

1. Set up livestock accounts

The first step in setting up a ledger for livestock reporting is to set up livestock accounts. These account codes are used by Client Accounting to retrieve values and to generate journals.

We recommend setting up your chart of accounts as per the table below.

If you have more than 5 animals, you can set up additional accounts using the same number format. The second digit in the account code acts as the animal identifier and the third digit identifies the type of account.

Account DescriptionCattleSheepHorsesPigsOther
Sales100110120130140
Deaths101111121131141
Killed for Rations102112122132142
Opening Stock103113123133143 
Purchases104114124134144 
Natural Increase105115125135145 
Closing Stock106116126136146 
Stock on Hand710711712713714

AE Accounts only has a single group of accounts dedicated to recording livestock values. To differentiate between animals, you'll need to add a prefix (or "department identifier") to each livestock, profit and loss account.

This means when recording livestock values using an AE Accounts style of chart, you'll need to also need to configure department settings.

Account DescriptionAccount CodeSheepCattleHorsesOther
Header account (Livestock name)01.02.03.04.0
Opening Stock11.12.13.14.1
Purchases21.22.23.24.2
Natural Increase31.32.33.34.3
Sales61.62.63.64.6
Deaths71.72.73.74.7
Killed for Rations81.82.83.84.8
Stock on Hand10883883885886

As there is only one set of accounts to record livestock values, you need to establish departments in the configuration. Each category of livestock is a different department.

For example, using the accounts:

  • 1.6 - Cattle Sales
  • 2.6 - Sheep Sales
  • 1.2 - Cattle Purchases
  • 2.2 - Sheep Purchases

In this scenario, Cattle is department 1 and Sheep is department 2, and 6 is the account code to represent Sales and 2 represents Purchases.

If you're using an AE Accounts chart of charts you'll also need to set up department settings. See below for information.

To configure department settings
  1. From within your client's Client Accounting tab, click Edit Configuration Details.
  2. Select This ledger uses departments then click on Edit department settings. The Department Settings window appears.
  3. Select Prefix from Departments are defined by drop-down menu. Additional fields display.
  4. Select Prefix separator and enter a full stop ( . ) in the field. For example, the prefix separator in account 2.6 is a full stop ( . ) where 2 is the division number for Cattle, and 6 is the account code for Sales. In this example, the prefix separator is . which is commonly used in AE Accounts.

  5. Select Use the name of the first account in the department. In the above example, the name of the first account will be account code 2 “Name of Department 1” or 3 “Name of Department 2”.
  6. Click OK. You are returned to the Client Configuration window.
  7. Click OK. The Client Configuration window closes

Account DescriptionCattleSheepHorsesPigsOther
Sales100110120130140
Deaths101111121131141
Killed for Rations102112122132142
Opening Stock103113123133143 
Purchases104114124134144 
Natural Increase105115125135145 
Closing Stock106116126136146 
Stock on Hand710711712713714



2. Prepare the Livestock Calculation - Closing Balance workpaper (optional)

Adding the Livestock - Closing Balance workpaper

  1. Open the Workpaper period for your client and select the first livestock Closing Stock account. (For example, 106 Closing Stock - Cattle)
  2. From the TASKS bar, click Add Workpaper.
  3. Choose Livestock - Closing Balance from the Template drop-down list. You can edit the Workpaper name if you wish.
  4. Click Add. The Livestock Calculation - Closing Balance workpaper appears underneath the Closing Stock account.

Completing the Livestock Calculation - Closing Stock workpaper

There are three main sections in the workpaper:

A

In section A:

  • In the Account column, click on the grey drop-down arrow () and choose the account that matches the description (See above example). The Balance
  • In the Quantity column, enter the number of animals according to your client's stock take records. For example, if your client has bought two cows, enter 2.00 in the Quantity column.

The Average cost column is calculated automatically by dividing the account balance by the number of

B

In section B:

  • Enter the Standard cost. The Standard cost is used to calculate the balance of Natural increase. The quantity is multiplied by the Standard cost to arrive at the Balance.

The Average cost per head is calculated using the Opening stock, Purchases and Natural increase balances over the quantity.

C

The values in section C are calculated automatically.

The table compares quantities and balances entered into the workpaper against the quantities and balances in the ledger.

  • If the quantity in the workpaper differs from the quantity in ledger for the relative account, the difference appears in the Quantity variance column.
  • If an account balance in the workpaper differs from it's account balance in the ledger, the difference appears in the Balance variance column.
3. Post quantities and adjustments
  1. Click Add Journal. This is located:
    • on the top toolbar of the Livestock - Closing Balance workpaper (if you're using the workpaper to reconcile balances)
      or
    • on the TASKS bar in the the Workpapers period (if you're not using the Livestock Calculation - Closing Balance workpaper).
    The Add Journal window appears.
  2. Enter a description for the journal in the Description field.

  3. Enter your adjustment journals. If you've completed the Livestock Calculation - Closing Balance workpaper adjustment journals appear automatically in the Add Journal window. All you need to do is choose an account to balance the journal.
  4. When you've finished adding journals, click OK to close the Add journal window.
  5. Once you're ready to post journals to the ledger, click Post Journals. The ledger balances are updated.
4. Print reports
  1. From within the client's Client Accounting tab, click the Reports tab.
  2. Ensure Livestock trading statement - <type> is selected and if required, Farm income profit and loss statement.
  3. Click Preview. To print the report click the printer icon on the toolbar.