The Livestock Schedule in Cimplico Workpapers is designed to help you track and report movements in livestock across different categories, including purchases, sales, deaths, and natural increases. It automatically calculates key totals and ensures a consistent format for compliance and reporting.
This guide outlines key tips, known limitations, and a step-by-step process to complete the schedule.
General Tips
✅ Do not override greyed-out areas. These are automatically calculated and designed to protect the integrity of the worksheet.
✅ Ensure all required input fields are completed. Missing data may cause the schedule to return incomplete or incorrect figures.
✅ Enter figures as positives.
Limitations
⚠️ You cannot add multiple rows to reach a combined figure (e.g. total sales for the year). If you need to break down a number, use the Other Information section at the bottom of the worksheet to add any supporting calculations or context.
Step-by-Step Approach
Step 1: Add the Livestock Schedule to your workpaper
Add the Calculation template to a workpaper from either within the Other SChedules section or within a worksheet directly.
Step 2: Create a new livestock type schedule
Click + New to create a new livestock list. Each livestock type (e.g. cattle, sheep) should have its own schedule. All individual schedules are then summarised in the Summary tab.
Step 3: Record natural increase, deaths and rations
Fill out the fields under ‘Natural increase, deaths and rations’:
Input increases in stock (e.g. births)
Record any reductions (e.g. deaths, rations)
The final field, ‘Net natural increase/decrease in stock (qty)’, will auto-calculate.
Step 4: Complete opening stock, purchases, and sales
In the ‘Opening stock purchases and sales’ section:
Enter the opening quantity and value
Record purchases (quantity and total dollar amount)
Record sales (quantity and total dollar amount)
Do not enter per-head values – all entries should be total figures.
Step 5: Review the Closing Stock Summary
The worksheet will calculate closing stock values based on your inputs.
If you wish to report using market value:
Market value of stock per head (optional) – enter cost per head at market value.
Method of valuation of stock – override this field to ‘Market value’.
Step 6: Review the final livestock reporting figures
The final reporting section summarises all movements and stock values across your livestock types.