Stock Inventory, Sales and Purchases
A monthly stock reconciliation (opening stock + births + purchases - deaths - sales = closing) with a physical count check and a stock-by-class valuation. Sales and purchase registers add automatic totals, average prices and price per kilogram.
2 files to download
- XLSXExcel workbook (.xlsx)
- PDFPrint-ready PDF (A4)
Downloads unlock on your private order page as soon as payment is confirmed, and a link is emailed to you.
A monthly stock reconciliation (opening stock + births + purchases - deaths - sales = closing) with a physical count check and a stock-by-class valuation. Sales and purchase registers add automatic totals, average prices and price per kilogram.
What is included
- Excel workbook (.xlsx) with 4 data sheets (Monthly Stock Count, Stock by Class, Sales, Purchases), an Instructions sheet and a Lists sheet that feeds the drop-downs. Opens in Excel 2010 or later, LibreOffice and Google Sheets.
- Print-ready A4 PDF (landscape) with GBAZ branding, ruled rows, an instructions panel and a notes box on every page.
- Farm details block, yellow input cells, drop-down lists, data validation, frozen headers, filters and print titles on every sheet.
Monthly Stock Count
Type the opening stock for January; every later month starts with the previous closing stock. Enter births, purchases, deaths, sales and other movements each month. Closing stock is calculated. Count the goats physically at month end and type the count: any difference points to an unrecorded birth, death or theft.
Columns: Month, Opening stock, Births, Purchases, Transfers in, Deaths, Sales, Slaughtered / home use, Transfers out / lost, Physical count, Notes. Calculated: Opening stock, Closing stock, Difference, Mortality %.
Summary cells: Births this year; Deaths this year; Sold this year; Annual mortality %; Latest closing stock.
Stock by Class
Use this sheet at the annual (or quarterly) count. Enter the opening number, movements in and out, and the physical count per class, then your estimate of value per head to get the herd valuation used in the gross margin.
Columns: Class, Opening, In (births, purchases, transfers), Out (deaths, sales, transfers), Physical count, Value per head (USD). Calculated: Closing, Total value.
Summary cells: Count date (you enter); Total goats counted; Herd value (USD); Does as % of flock.
Sales
One row per sale (one buyer, one price). Number sold times price per head gives the total; add the live weight to see the price per kilogram you achieved. Keep the movement permit number from the Department of Veterinary Services or police clearance for every goat that leaves the farm.
Columns: Date, Buyer (name, phone), Tag ID(s), Class, Number sold, Total live weight (kg), Price per head (USD), Payment, Paid in full?, Movement permit / receipt no., Notes. Calculated: Total, Price per kg.
Summary cells: Goats sold; Sales income (USD); Average price per head; Average price per kg; Unpaid sales.
Purchases
One row per goat bought. Record the seller, permit and whether the animal was isolated for 21 days and dosed and vaccinated on arrival: bought-in goats are the commonest way diseases and resistant worms enter a flock.
Columns: Date, Seller (name, phone, farm), Tag ID, Breed, Class, Age (months), Weight (kg), Price (USD), Payment, Movement permit no., Quarantined 21 days?, Vaccination / dosing on arrival, notes. Calculated: Price per kg.
Summary cells: Goats bought; Purchase cost (USD); Average price per head; Not quarantined.
Formulas
Closing stock = opening + births + purchases + transfers in - deaths - sales - slaughtered - transfers out; each month opens with the previous closing; difference = physical count - closing; mortality % = deaths / opening. Sales total = number x price; price per kg = total / live weight; averages and unpaid counts use SUM, SUMIFS and COUNTIF.
Benchmarks and good practice
- Reconciliation rule: opening stock + births + purchases + transfers in - deaths - sales - slaughtered - transfers out = closing stock. A physical count that differs from the book figure must be explained.
- Movement of goats between districts needs a permit from the Department of Veterinary Services; keep permit numbers with the sale or purchase.
- Sell by weight where you can: goats are often underpaid when sold by the head. Weigh and record the price per kg to compare buyers.
- Isolate new animals for at least 21 days, dose, dip and check FAMACHA before mixing them with the flock.
Layouts follow the record books recommended by extension services (FAO, ILRI, Heifer International Zimbabwe, Cornell Small Farms, Uganda MAAIF and WormBoss guidance), adapted for Zimbabwean goat breeders by GBAZ.
Goat Breeders Association of Zimbabwe
Sold on the GBAZ platform on behalf of Goat Breeders Association of Zimbabwe, who delivers the product.