GBAZ
Template by Goat Breeders Association of Zimbabwe

Income and Expense Ledger with Gross Margin

A simple cash book for the goat enterprise: every income and cost by category with a month-by-month summary. An automatic gross margin statement adds income and stock value change, subtracts variable costs and shows gross margin per doe and net margin after fixed costs.

Income and Expense Ledger with Gross Margin
What you get

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 simple cash book for the goat enterprise: every income and cost by category with a month-by-month summary. An automatic gross margin statement adds income and stock value change, subtracts variable costs and shows gross margin per doe and net margin after fixed costs.

What is included

  • Excel workbook (.xlsx) with 3 data sheets (Ledger, Gross Margin, Monthly Summary), 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.

Ledger

Enter every receipt and payment on its own row. Choose the Type (Income, Variable cost or Fixed cost) and a Category from the drop-down: these drive the Gross Margin and Monthly Summary sheets. Variable costs change with the number of goats (feed, medicines, transport); fixed costs do not (permanent labour, repairs, subscriptions).

Columns: Date, Type, Category, Description, Quantity, Unit price (USD), Amount (USD), Payment, Paid to / received from, Receipt no., Notes. Calculated: Month.

Summary cells: Entries; Total income (USD); Variable costs (USD); Fixed costs (USD); Cash surplus (USD).

Gross Margin

All figures come from the Ledger and the yellow inputs. Gross margin = income + (closing stock value - opening stock value) - variable costs. Net margin = gross margin - fixed costs. Gross margin per doe is the figure to compare year on year and with other breeders.

Lines: income by category (SUMIFS from the Ledger), opening and closing stock value, change in stock value, variable costs by category, gross margin, number of does, gross margin per doe, gross margin as a percentage of income, fixed costs by category and net margin.

Monthly Summary

Month by month cash position taken from the Ledger. Use it to plan when to sell and when to buy feed and medicines.

Columns: Month. Calculated: No., Income, Variable costs, Fixed costs, Net cash, Cumulative.

Formulas

Totals by type use SUMIFS on Type and Category; monthly figures use SUMIFS on MONTH(date); gross margin = income + (closing stock value - opening stock value) - variable costs; gross margin per doe = gross margin / does; net margin = gross margin - fixed costs; cumulative cash adds each month to the last.

Benchmarks and good practice

  • Gross margin = enterprise income (sales, home consumption at market value and the change in stock value) less variable costs. It is the standard figure for comparing enterprises and years (MLA, extension gross-margin budgets).
  • Express the result per doe and per hectare of grazing. A commercial meat-goat flock should cover its variable costs at least twice over.
  • Value home-slaughtered goats and manure at market price so the enterprise is not under-stated.
  • Keep receipts for every entry; GBAZ and lenders will ask for twelve months of records when you apply for finance or stud status.

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.

Seller

Goat Breeders Association of Zimbabwe

Sold on the GBAZ platform on behalf of Goat Breeders Association of Zimbabwe, who delivers the product.

More from the shop

WhatsApp support