{"product_id":"farm-bookkeeping-spreadsheet","title":"Farm and Homestead Bookkeeping Spreadsheet","description":"\u003cp\u003eThis farm bookkeeping spreadsheet shows which parts of your farm or homestead actually make money. Instead of one whole-farm profit figure, it works out a gross margin for each enterprise, so a losing flock cannot hide behind a good harvest.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eGross margin for every enterprise\u003c\/h2\u003e\u003cp\u003eA farm with a dairy herd, a couple of crops and a flock is several businesses sharing one bank account. The Enterprises tab separates them.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eEight enterprises in the example, with room for 20 rows, each with its own revenue, direct costs and gross margin\u003c\/li\u003e\n\u003cli\u003eMargin per acre and per head, the figure that lets you compare a wheat field with a dairy herd\u003c\/li\u003e\n\u003cli\u003eAnything under 15% is flagged, and anything losing money is named\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eRevenue that sorts itself\u003c\/h2\u003e\u003cp\u003eYou never type an enterprise's revenue. Each enterprise has its own income code, so a sale entered once in the ledger lands against the right one. Direct costs are what you spent on that enterprise alone, such as seed, feed and vet bills, which is why the result is a gross margin rather than a profit. Whole-farm overheads stay in the profit and loss, where they belong.\u003c\/p\u003e\u003ch2\u003eThe full farm books underneath\u003c\/h2\u003e\u003cp\u003eEverything recalculates from two registers, money in and money out. Nothing is entered twice and there are no pivot tables to refresh.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e1,000 ledger rows, with two years of demo data in the filled copy\u003c\/li\u003e\n\u003cli\u003eProfit and loss by category, with monthly and quarterly views\u003c\/li\u003e\n\u003cli\u003eA custom date range and a year-on-year comparison\u003c\/li\u003e\n\u003cli\u003eEvery total, margin and percentage calculated for you\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers, not static pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eFifteen connected tabs\u003c\/h2\u003e\u003cp\u003eA Start Here tab walks you through setup in a few minutes. The workbook covers setup, income, farm expenses, enterprises, monthly and quarterly views, profit and loss, sales tax, estimated tax, a custom range, the year-on-year comparison, mileage, balances and a dashboard. It is farm record keeping and homestead finance in one file, from the first load sold to the year-end figures.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eBuilt with no dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.\u003c\/li\u003e\n\u003cli\u003eNo subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: one filled with two full years of example data so you can see it working, and a blank one for your own farm spreadsheet\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan I use it in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. The download has Excel files for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions, which need only a free Google account.\u003c\/p\u003e\u003ch3\u003eHow does it work out the margin for each enterprise?\u003c\/h3\u003e\u003cp\u003eEach enterprise has its own income code, so sales attribute themselves from the ledger. Direct costs for that enterprise are subtracted to give a gross margin, shown per acre and per head as well.\u003c\/p\u003e\u003ch3\u003eIs gross margin the same as profit?\u003c\/h3\u003e\u003cp\u003eNo. Gross margin counts only the direct costs of each enterprise. Whole-farm overheads are kept in the profit and loss tab.\u003c\/p\u003e\u003ch3\u003eHow many enterprises can I track?\u003c\/h3\u003e\u003cp\u003eThe Enterprises tab has 20 rows. The example uses eight.\u003c\/p\u003e\u003ch3\u003eDoes it cover tax and mileage?\u003c\/h3\u003e\u003cp\u003eThe workbook includes Sales Tax, Estimated Tax and Mileage tabs alongside the profit and loss. It records and calculates what you enter and is not tax advice.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864337502,"sku":"OPX-077","price":27.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/farm-bookkeeping-spreadsheet-01.jpg?v=1790832368","url":"https:\/\/opxviashop.com\/products\/farm-bookkeeping-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}