{"title":"Investing \u0026 Property","description":"\u003cp\u003eSpreadsheet templates for investors and property owners, in Excel and Google Sheets. Track a portfolio, capital gains and cost basis, plan retirement withdrawals, compare mortgages, and run rental properties from rent to repairs.\u003c\/p\u003e\u003cp\u003eEvery figure is arithmetic on the numbers you enter. These are tracking tools, not investment or tax advice.\u003c\/p\u003e","products":[{"product_id":"mortgage-payoff-calculator","title":"Mortgage Payoff Calculator Spreadsheet","description":"\u003cp\u003eThis mortgage payoff calculator shows what paying a little extra each month actually buys you. It runs a thirty-year amortization schedule and recalculates the whole thing the moment you change the extra payment, so you see the new payoff date and the interest saved by each extra payment straight away.\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\u003eExtra payments, recalculated instantly\u003c\/h2\u003e\u003cp\u003eEnter each balance, rate and minimum payment once. Change the extra payment and every date in the file moves, from the month each loan clears to your final debt-free date. The dashboard keeps six live figures in view, including that date and the total interest you will pay.\u003c\/p\u003e\u003ch2\u003eSnowball or avalanche across your home loans\u003c\/h2\u003e\u003cp\u003eMost templates give you one calculator and one answer. This one runs a full month-by-month schedule for the snowball and for the avalanche, then shows the gap between them in dollars and in months, so you choose knowing what the choice costs. The snowball rolls for real: when a debt clears, its minimum payment joins the next one automatically, and that rolling amount is part of every date in the file.\u003c\/p\u003e\u003ch2\u003eTen connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eDebts:\u003c\/strong\u003e balance, rate and minimum payment, the only things you enter\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSnowball Schedule:\u003c\/strong\u003e every month and every loan until the last one clears\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAvalanche Schedule:\u003c\/strong\u003e the same schedule, ordered the other way round\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePayoff Plan:\u003c\/strong\u003e the order to pay them in and what each will cost you\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCompare:\u003c\/strong\u003e both strategies side by side, with the difference in dollars\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePayoff Calendar:\u003c\/strong\u003e the month each one disappears and what it frees up\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePayment Log:\u003c\/strong\u003e what you actually paid, split into principal and interest\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e six live figures, including your debt-free date\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eSetup and Start Here\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat this mortgage tracker works out\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eYour debt-free date, from your own numbers\u003c\/li\u003e\n\u003cli\u003eThe total interest you will pay across the whole plan\u003c\/li\u003e\n\u003cli\u003eHow many months each individual debt takes to clear\u003c\/li\u003e\n\u003cli\u003eThe payoff order under either strategy, set automatically\u003c\/li\u003e\n\u003cli\u003eChange the extra payment and every date moves with it\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA filled-in copy to learn from\u003c\/h2\u003e\u003cp\u003eYou get a worked example to click through and a blank copy ready for your own numbers, in Excel and in Google Sheets. The Payment Log splits every payment into principal and interest, so it stays useful as a home loan payoff record for years.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription needed.\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\u003eNo add-ins, no macros, no subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook, filled with a worked example\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for your own numbers\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with 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\u003eThe Start Here tab walks you through setup in a few minutes.\u003c\/p\u003e\u003cp\u003eYour files are ready as soon as payment clears. The template is for personal use on your own devices; please do not share or resell the files. 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\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel workbook runs in Excel 2016 or later on Windows and Mac, and the instruction guide has two one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eHow do I see what an extra payment saves?\u003c\/h3\u003e\u003cp\u003eChange the extra payment and the thirty-year amortization recalculates at once, moving every date and updating the total interest you will pay.\u003c\/p\u003e\u003ch3\u003eCan I include more than one loan?\u003c\/h3\u003e\u003cp\u003eYes. The Debts tab takes a balance, rate and minimum for each loan, and the workbook works out the order to pay them in under snowball or avalanche.\u003c\/p\u003e\u003ch3\u003eDoes it record the payments I actually make?\u003c\/h3\u003e\u003cp\u003eYes. The Payment Log records what you paid, split into principal and interest.\u003c\/p\u003e\u003ch3\u003eIs it hard to set up?\u003c\/h3\u003e\u003cp\u003eNo. You enter the balance, rate and minimum for each loan, and the Start Here tab walks you through setup in a few minutes.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597861027934,"sku":"OPX-018","price":15.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/mortgage-payoff-calculator-01.jpg?v=1790832025"},{"product_id":"rental-property-tracker-landlord","title":"Rental Property Tracker Spreadsheet","description":"\u003cp\u003eThis rental property tracker puts the rent that was due and the rent that arrived on the same row, so arrears are a number rather than a feeling. It is a landlord spreadsheet for anyone with one unit or twenty who wants arrears and voids measured properly.\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\u003eArrears and voids, kept apart\u003c\/h2\u003e\u003cp\u003eArrears is the gap between what was due and what came in, calculated for each unit and for the whole portfolio. A void month owes nothing and counts against occupancy instead, so a quiet month and an unpaid month never look the same.\u003c\/p\u003e\u003ch2\u003eEnter a unit once\u003c\/h2\u003e\u003cp\u003eEach unit is entered once. Every rent row, every cost and every maintenance job points at it, which is how the per-property view works without anything being keyed in twice. A unit is whatever you let separately.\u003c\/p\u003e\u003ch2\u003eEleven connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eUnits:\u003c\/strong\u003e 60 rows\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRent Schedule:\u003c\/strong\u003e 400 rows of what was owed, what arrived and the gap, a rent tracker by unit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eIncome and Expenses:\u003c\/strong\u003e 400 rows each, every line pointed at a unit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProperty P\u0026amp;L:\u003c\/strong\u003e income, costs, net, margin and yield for each unit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTenancies:\u003c\/strong\u003e a tenant tracker showing who is in which unit, on what terms and until when\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eOccupancy:\u003c\/strong\u003e let against void, per unit and per month\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMaintenance:\u003c\/strong\u003e reported, quoted, booked, done, and what it cost\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e six live figures and every unit underneath\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eSetup and Start Here\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat it works out for you\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eArrears per unit and for the portfolio, calculated\u003c\/li\u003e\n\u003cli\u003eOccupancy per unit and per month, with voids counted\u003c\/li\u003e\n\u003cli\u003eWhat void months cost you, in money\u003c\/li\u003e\n\u003cli\u003eYield per unit, against what you actually paid for it\u003c\/li\u003e\n\u003cli\u003eTax to set aside, at your own rate\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eFor a property investor comparing units, the yield figure uses what you actually paid for each one.\u003c\/p\u003e\u003cp\u003eYou get four real spreadsheet files: Excel and Google Sheets, each filled with a worked year and each blank and ready for yours. Both versions are the same build, so the file you open looks like the photos whichever one you use.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\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. The Start Here tab walks you through setup in a few minutes. The files are for use on your own portfolio; please do not share or resell them. This is a record-keeping tool, not tax or legal advice. 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\u003eDoes it run in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow many properties can I track?\u003c\/h3\u003e\u003cp\u003eThe Units tab has 60 rows, and a unit is whatever you let separately, so a house split into rooms can be several units.\u003c\/p\u003e\u003ch3\u003eHow does it tell arrears from an empty unit?\u003c\/h3\u003e\u003cp\u003eA void month owes nothing and counts against occupancy, while arrears is the gap between what was due and what came in. The two are never mixed.\u003c\/p\u003e\u003ch3\u003eCan I track repairs?\u003c\/h3\u003e\u003cp\u003eYes. The Maintenance tab follows each job from reported to quoted, booked and done, with what it cost, pointed at the unit.\u003c\/p\u003e\u003ch3\u003eDoes it work out tax?\u003c\/h3\u003e\u003cp\u003eIt works out tax to set aside at a rate you choose. It is a record-keeping tool, not tax or legal advice.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597862666334,"sku":"OPX-047","price":35.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/rental-property-tracker-landlord-01.jpg?v=1790832193"},{"product_id":"airbnb-vacation-rental-tracker","title":"Airbnb and Vacation Rental Tracker Spreadsheet","description":"\u003cp\u003eThis vacation rental tracker records nights booked, the nightly rate and what actually landed after fees. It is an Airbnb spreadsheet for hosts with one listing or several who want occupancy and short term rental income tracked properly.\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\u003eOccupancy measured the right way\u003c\/h2\u003e\u003cp\u003eOccupancy is nights let against nights available, for each unit and each month, measured against your target. Platform commission and changeover cleaning are their own expense lines rather than a single lump, so you can see what each one takes.\u003c\/p\u003e\u003ch2\u003eEvery line points at a unit\u003c\/h2\u003e\u003cp\u003eA unit is entered once. Every booking, every cost and every maintenance job points at it, which is how the per-property view works without retyping anything.\u003c\/p\u003e\u003ch2\u003eThe tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eUnits:\u003c\/strong\u003e 60 rows; a unit is whatever you let separately\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBookings:\u003c\/strong\u003e nights, nightly rate, takings and occupancy per month\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRent Schedule:\u003c\/strong\u003e 400 rows of what was owed, what arrived and the gap\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eIncome and Expenses:\u003c\/strong\u003e 400 rows each, every line pointed at a unit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProperty P\u0026amp;L:\u003c\/strong\u003e income, costs, net, margin and yield per unit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eOccupancy:\u003c\/strong\u003e per unit and per month, against your target\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMaintenance:\u003c\/strong\u003e jobs, status and cost, pointed at a unit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e six live figures and every unit underneath\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eSetup and Start Here\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat it works out for you\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eArrears per unit and for the portfolio, calculated\u003c\/li\u003e\n\u003cli\u003eOccupancy per unit and per month, with voids counted\u003c\/li\u003e\n\u003cli\u003eWhat void months cost you, in money\u003c\/li\u003e\n\u003cli\u003eYield per unit, against what you actually paid for it\u003c\/li\u003e\n\u003cli\u003eTax to set aside, at your own rate\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eRental income, costs and yield all come from the same rows, so the dashboard and the ledgers always agree.\u003c\/p\u003e\u003cp\u003eYou get four real spreadsheet files: Excel and Google Sheets, each filled with a worked year and each blank and ready for yours. Both versions are the same build, so the file you open looks like the photos whichever one you use.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\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. The Start Here tab walks you through setup in a few minutes. The files are for use on your own portfolio; please do not share or resell them. This is a record-keeping tool, not tax or legal advice. 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 Google Sheets as well as Excel?\u003c\/h3\u003e\u003cp\u003eYes. The download has Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it connect to Airbnb or other booking sites?\u003c\/h3\u003e\u003cp\u003eNo. There are no add-ins, no macros and no connections. You enter your bookings and costs, and everything else is calculated.\u003c\/p\u003e\u003ch3\u003eHow is occupancy calculated?\u003c\/h3\u003e\u003cp\u003eAs nights let against nights available, per unit and per month, and compared with the target you set.\u003c\/p\u003e\u003ch3\u003eCan I track more than one property?\u003c\/h3\u003e\u003cp\u003eYes. The Units tab has 60 rows, and every booking, cost and maintenance job points at a unit for a per-property view.\u003c\/p\u003e\u003ch3\u003eWhere do platform fees and cleaning go?\u003c\/h3\u003e\u003cp\u003ePlatform commission and changeover cleaning each have their own expense line, so neither is hidden inside general costs.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597862699102,"sku":"OPX-048","price":35.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/airbnb-vacation-rental-tracker-01.jpg?v=1790832199"},{"product_id":"investment-portfolio-tracker-spreadsheet","title":"Investment Portfolio Tracker Spreadsheet","description":"\u003cp\u003eThis investment tracker builds every holding from your trades, so the units you own are summed, never typed. It is a portfolio tracker for investors who want a record they own outright, not a dashboard that needs a login.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. You can show all accounts or pick one, and the whole page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eValue now: what your holdings are worth at the prices you entered, and what they cost\u003c\/li\u003e\n\u003cli\u003eWorth against put in, at every month end\u003c\/li\u003e\n\u003cli\u003eMoney in and out: each month's buys, and the sells that took money out\u003c\/li\u003e\n\u003cli\u003eBy account, such as an ISA or pension, largest first\u003c\/li\u003e\n\u003cli\u003eBy asset class: funds, shares, bonds and crypto, with the value of each\u003c\/li\u003e\n\u003cli\u003eGain by holding, split into gain already taken and gain not yet taken\u003c\/li\u003e\n\u003cli\u003eDividends each month against the same month a year before\u003c\/li\u003e\n\u003cli\u003eTop holdings with share, gain and return, and the latest sells costed at the average price\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEight connected tabs\u003c\/h2\u003e\u003cp\u003eBecause each holding's unit count comes out of the transaction log, the portfolio table and your trades cannot drift apart, and there is nothing to reconcile.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eHoldings:\u003c\/strong\u003e 60 rows, with units summed from your trades\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTransactions:\u003c\/strong\u003e 500 rows, the only place units are entered\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDividends:\u003c\/strong\u003e kept separate, so yield is not confused with growth\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eValue:\u003c\/strong\u003e a monthly snapshot, which is what the chart reads\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProjection:\u003c\/strong\u003e year by year on your own growth rate, with the pot you need from your own withdrawal rate\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eDashboard, Setup and Start Here\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eCost, value, gain and return are worked out per holding, and yield on cost comes from the dividend tracker tab. It works as a stock tracker for single shares and just as well for an index fund, and the value history gives you the investment side of your net worth.\u003c\/p\u003e\u003ch2\u003eNo price feed, on purpose\u003c\/h2\u003e\u003cp\u003eThere is no live price feed and no internet connection. You type current prices yourself, which is why the file keeps working offline, years from now, without anyone's API.\u003c\/p\u003e\u003ch2\u003eNot financial advice\u003c\/h2\u003e\u003cp\u003eThis is a record of what you bought and a projection of numbers you chose. It does not recommend anything, does not know your circumstances, and assumes a growth rate you type in yourself. Past returns do not predict future ones. For advice, ask someone regulated to give it.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros, no subscription and no live price feed\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\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. The files are for personal use on your own devices; please do not share or resell them. 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\u003eDoes it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to the Google Sheets versions (filled and blank).\u003c\/p\u003e\u003ch3\u003eDoes it update share prices automatically?\u003c\/h3\u003e\u003cp\u003eNo. There is no live price feed. You enter current prices yourself, and every value, gain and chart recalculates from them.\u003c\/p\u003e\u003ch3\u003eHow do I record how many units I own?\u003c\/h3\u003e\u003cp\u003eYou do not type units on Holdings. Every buy and sell goes on the Transactions tab, and the units are summed from there.\u003c\/p\u003e\u003ch3\u003eCan I track dividends separately?\u003c\/h3\u003e\u003cp\u003eYes. Dividends have their own tab, so yield on cost is kept apart from growth, and the dashboard compares each month with the same month a year before.\u003c\/p\u003e\u003ch3\u003eCan I see one account at a time?\u003c\/h3\u003e\u003cp\u003eYes. The dashboard has an account picker: choose all accounts or one, and the whole page follows.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597862731870,"sku":"OPX-049","price":27.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/investment-portfolio-tracker-spreadsheet-01.jpg?v=1790832205"},{"product_id":"early-retirement-fire-calculator","title":"Early Retirement Calculator Spreadsheet","description":"\u003cp\u003eThis early retirement calculator lays the projection out year by year, instead of handing you one number you cannot question. It is a FIRE planner for anyone running the numbers on financial independence and stopping work early who wants to see every assumption.\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\u003eEvery year on its own row\u003c\/h2\u003e\u003cp\u003eFor each year you see the opening balance, what you paid in, the growth and the closing balance. The year your pot covers your spending is flagged on the row, so you can see where the curve comes from rather than trusting it. The pot you need comes from your own withdrawal rate, and the growth rate is one you type in.\u003c\/p\u003e\u003ch2\u003eSeven connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eProjection:\u003c\/strong\u003e 32 years, opening to closing, on your own rate\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHoldings:\u003c\/strong\u003e 60 rows, the pot it starts from, with units summed from your trades\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTransactions:\u003c\/strong\u003e what you actually paid in, month by month\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eValue:\u003c\/strong\u003e a monthly snapshot of where the pot has been\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e six live figures and every holding underneath\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eSetup and Start Here\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat it works out\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eUnits held, summed from the transaction log\u003c\/li\u003e\n\u003cli\u003eCost, value, gain and return per holding\u003c\/li\u003e\n\u003cli\u003eA year-by-year projection on your own assumptions\u003c\/li\u003e\n\u003cli\u003eThe pot you need, from your own withdrawal rate\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eSo the retirement planner side and the investment tracker side use the same figures: the projection starts from what you actually hold. There is no live price feed and no internet connection, which is why it keeps working offline for years. The filled copy has three worked years of data.\u003c\/p\u003e\u003ch2\u003eNot financial advice\u003c\/h2\u003e\u003cp\u003eThis is a record of what you bought and a projection of numbers you chose. It does not recommend anything, does not know your circumstances, and assumes a growth rate you type in yourself. Past returns do not predict future ones. For advice, ask someone regulated to give it.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros, no subscription and no live price feed\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\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. The Start Here tab walks you through setup in a few minutes. The files are for personal use on your own devices; please do not share or resell them. 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. You get Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow far ahead does the projection go?\u003c\/h3\u003e\u003cp\u003eThirty-two years, with opening balance, money paid in, growth and closing balance shown for each one.\u003c\/p\u003e\u003ch3\u003eWhat growth rate does it assume?\u003c\/h3\u003e\u003cp\u003eWhatever you type in. It does not choose a rate for you, and past returns do not predict future ones.\u003c\/p\u003e\u003ch3\u003eHow does it work out the pot I need?\u003c\/h3\u003e\u003cp\u003eFrom your spending and the withdrawal rate you set, and it flags the year your projected pot covers it.\u003c\/p\u003e\u003ch3\u003eDoes it pull live prices?\u003c\/h3\u003e\u003cp\u003eNo. There is no price feed. You enter values yourself, so the file works offline.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597862764638,"sku":"OPX-050","price":27.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/early-retirement-fire-calculator-01.jpg?v=1790832211"},{"product_id":"mortgage-comparison-calculator","title":"Mortgage Comparison Calculator Spreadsheet","description":"\u003cp\u003eThis mortgage comparison spreadsheet shows why the lowest rate is not always the cheapest loan. In the demo, 4.39% costs more than 4.54%. It is for homebuyers and anyone weighing a refinance who wants to compare mortgages with every cost included.\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\u003eFour offers, every cost in\u003c\/h2\u003e\u003cp\u003eEnter up to four offers side by side with rate, term, amortization, lender fee and points. Then the sheet does two things most comparison sheets get wrong.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe same number of months.\u003c\/strong\u003e Offers with different terms are compared over the shortest term on offer. A three-year term simply has fewer payments in it; it is not cheaper.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe balance still owed.\u003c\/strong\u003e What you would still owe at the end of the term is counted. Leave it out and the answer flips.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eWhat is left is interest plus fees: the real cost. In the demo the cheapest rate on the page, 4.39%, costs 952 more than 4.54% once its mortgage points and its fee are in. Break even against the no-fee offer is 32.6 months for the winner and 46.2 for the one with the tempting rate.\u003c\/p\u003e\u003ch2\u003eWhat it works out\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eOffer comparison: four offers, every cost in, over a common horizon\u003c\/li\u003e\n\u003cli\u003eBreak-even against the no-fee offer, in months\u003c\/li\u003e\n\u003cli\u003eBalance still owed when your term ends, for each offer\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEleven connected tabs\u003c\/h2\u003e\u003cp\u003eEverything recalculates from your debt list, so nothing is typed twice. The same workbook also plans payoff for other debts:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eBoth snowball and avalanche calculated in full, month by month\u003c\/li\u003e\n\u003cli\u003eFreed minimums roll onto the next debt automatically\u003c\/li\u003e\n\u003cli\u003eA payoff date per debt, and the month you are done\u003c\/li\u003e\n\u003cli\u003e400 payments logged, split into principal and interest\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers, not pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eLender fees and points are the closing costs that most change the answer, which is why each one is entered per offer.\u003c\/p\u003e\u003cp\u003eYou get a filled-in copy as well as a blank one: a full demo you can click through and a blank ready for your own numbers, in Excel and Google Sheets. There are no dynamic arrays, no macros and no add-ins, and the Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros, no subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\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. The Start Here tab walks you through setup in a few minutes. The files are for your own use; please do not share or resell them. 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\u003eBoth. You get Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow many mortgage offers can I compare?\u003c\/h3\u003e\u003cp\u003eFour, side by side, each with rate, term, amortization, lender fee and points.\u003c\/p\u003e\u003ch3\u003eHow does it compare offers with different terms?\u003c\/h3\u003e\u003cp\u003eEverything is measured over the shortest term on offer, and the balance still owed at that point is counted, so a shorter term does not look cheaper just because it has fewer payments.\u003c\/p\u003e\u003ch3\u003eWhat does break-even mean here?\u003c\/h3\u003e\u003cp\u003eThe number of months before an offer with fees or points becomes cheaper than the no-fee offer.\u003c\/p\u003e\u003ch3\u003eWill it tell me which mortgage to choose?\u003c\/h3\u003e\u003cp\u003eNo. It calculates the figures you enter. It is not financial advice, so check the results and the terms with your lender.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864140894,"sku":"OPX-071","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/mortgage-comparison-calculator-01.jpg?v=1790832332"},{"product_id":"multi-project-tracker-portfolio-dashboard","title":"Multi Project Tracker and Portfolio Dashboard","description":"\u003cp\u003eThis multi project tracker puts every project on one row and shows whether it is truly ahead or behind. It is for project and program managers who run several projects at once and need to know which one to walk into on Monday morning.\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\u003eThe portfolio view\u003c\/h2\u003e\u003cp\u003eA project that is 40% done a third of the way through is ahead. One that is 40% done four fifths of the way through is not, and a progress bar alone cannot tell them apart. The Portfolio tab compares how much of the work is done with how much of the calendar has gone, and that gap turns a project amber before anyone has to admit it is slipping.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eEvery project on one row, with ahead or behind calculated\u003c\/li\u003e\n\u003cli\u003eFive status states driven by the numbers, not by how the week felt\u003c\/li\u003e\n\u003cli\u003eDelivery budget and annual operating impact for each project, with totals across the portfolio\u003c\/li\u003e\n\u003cli\u003eThe demo holds eight projects, 72 tasks and 478,000 of delivery budget, with exactly one project at risk, named, and the number that says why\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe full project engine underneath\u003c\/h2\u003e\u003cp\u003eBehind the project portfolio dashboard sits a complete project management workbook. Everything reads one task list and one charter, so nothing is typed twice or moved from one tab to another.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eA charter and a task register with room for 1,000 tasks and 100 projects\u003c\/li\u003e\n\u003cli\u003eA real Gantt chart drawn from your own start and end dates\u003c\/li\u003e\n\u003cli\u003eA Kanban board and an Eisenhower matrix over the same task list\u003c\/li\u003e\n\u003cli\u003eDeliverables, a risk register for risks and issues, resources, stakeholders and costs\u003c\/li\u003e\n\u003cli\u003eA single-project dashboard with a picker at the top\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eCalculated, not typed\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eEvery percentage, count, day and total is calculated for you\u003c\/li\u003e\n\u003cli\u003eCharts redraw from your own numbers, not static pictures\u003c\/li\u003e\n\u003cli\u003eFourteen connected tabs, with a Start Here tab that walks you through setup in a few minutes\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eFilled in from the start\u003c\/h2\u003e\u003cp\u003eThe filled copy opens with eight projects and 72 tasks already running, so the portfolio view is populated the moment you open it and you can see how each status is reached. The blank copy is ready for your own projects.\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\u003eNo 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\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: one with eight projects and 72 tasks already running, and a blank one\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\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eHow does it decide whether a project is on track?\u003c\/h3\u003e\u003cp\u003eIt compares the share of work done with the share of the schedule that has passed. The gap between the two drives one of five status states.\u003c\/p\u003e\u003ch3\u003eHow many projects and tasks can it hold?\u003c\/h3\u003e\u003cp\u003eUp to 100 projects and 1,000 tasks, all in one task list.\u003c\/p\u003e\u003ch3\u003eIs there a Gantt chart?\u003c\/h3\u003e\u003cp\u003eYes. A real Gantt is drawn from your own start and end dates, and the same tasks also feed a Kanban board and an Eisenhower matrix.\u003c\/p\u003e\u003ch3\u003eCan I see a single project in detail?\u003c\/h3\u003e\u003cp\u003eYes. The dashboard has a project picker at the top, and the charter, deliverables, risks, resources and costs sit in their own tabs.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864534110,"sku":"OPX-083","price":29.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/multi-project-tracker-portfolio-dashboard-01.jpg?v=1790832402"},{"product_id":"tenant-lease-tracker-spreadsheet","title":"Tenant Lease Tracker Spreadsheet","description":"\u003cp\u003eThis tenant lease tracker keeps the calendar a landlord has to follow, not just the rent. Every lease date counts down from today, and the checks that repeat, such as an annual gas safety certificate, roll forward on their own cycle for as long as the tenancy runs.\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\u003eLease events that roll forward\u003c\/h2\u003e\u003cp\u003eA certificate that is due every twelve months is not a date you type once. The Lease Events tab handles that for you.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eTwenty-six lease events across ten tenancies in the demo, every one counted down from today\u003c\/li\u003e\n\u003cli\u003eRecurring events roll forward on their own cycle: quarterly inspections, annual gas certificates, five-yearly electrical reports, deposit re-registrations and rent reviews\u003c\/li\u003e\n\u003cli\u003eEvery date comes from the tenancy start on the Tenancies tab, so changing one start date moves all of that tenancy's dates with it\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eCompliance kept apart\u003c\/h2\u003e\u003cp\u003eProperty compliance is counted separately from everything else. A fixed term that has ended and is now rolling month to month is normal. An expired gas safety certificate is not, and only that kind of overdue date turns red.\u003c\/p\u003e\u003ch2\u003eRent, money and maintenance\u003c\/h2\u003e\u003cp\u003eThe rest of this landlord spreadsheet covers the money side of each rental property. Everything recalculates from one list, so nothing is typed twice.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eA rent payment tracker: rent owed against rent arrived for each unit and month, with the gap shown\u003c\/li\u003e\n\u003cli\u003eIncome and expenses, coded to the property\u003c\/li\u003e\n\u003cli\u003eMaintenance jobs recorded against the unit they belong to\u003c\/li\u003e\n\u003cli\u003eProfit and loss for each property, not averaged across them\u003c\/li\u003e\n\u003cli\u003eEvery total, margin, percentage and date 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\u003eTwelve connected tabs\u003c\/h2\u003e\u003cp\u003eA Start Here tab walks you through setup in a few minutes. The workbook covers setup, units, tenancies, lease events, the rent schedule, income, expenses, maintenance, property profit and loss, occupancy and a dashboard, so your rental bookkeeping and your dates live in the same file.\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\u003eNo 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: a worked demo you can click through, and a blank one ready for your properties\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\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eDo I have to type every renewal date myself?\u003c\/h3\u003e\u003cp\u003eNo. Lease dates come from the tenancy start date, and recurring events such as inspections, gas certificates and electrical reports roll forward on their own cycle.\u003c\/p\u003e\u003ch3\u003eHow does it treat an overdue compliance check?\u003c\/h3\u003e\u003cp\u003eCompliance items are counted separately from ordinary renewals, and only an overdue compliance date turns red.\u003c\/p\u003e\u003ch3\u003eCan I see which tenants are behind on rent?\u003c\/h3\u003e\u003cp\u003eYes. The rent schedule compares rent owed with rent received for each unit and month and shows the gap.\u003c\/p\u003e\u003ch3\u003eDoes it give profit per property?\u003c\/h3\u003e\u003cp\u003eYes. Income and expenses are coded to each property, and profit and loss is shown property by property.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864599646,"sku":"OPX-085","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/tenant-lease-tracker-spreadsheet-01.jpg?v=1790832414"},{"product_id":"house-flip-profit-calculator","title":"House Flip Profit Calculator Spreadsheet","description":"\u003cp\u003eThis house flip calculator shows the profit on a deal, the return, the 70% rule and what happens when things go wrong, all on one screen. It is for real estate investors who want to test a fix and flip before they make an offer, not after the works have started.\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\u003eSixteen scenarios on one screen\u003c\/h2\u003e\u003cp\u003eThe Deal tab builds a sixteen-cell grid with the after-repair value down the side and the rehab overrun across the top. The whole deal is rebuilt in every cell, so you can see whether it survives a valuation that comes in light and works that run over. That is the question a flip turns on, and no printable worksheet can answer it.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e16 scenarios, ARV against rehab overrun, with the profit in every cell\u003c\/li\u003e\n\u003cli\u003eThe 70 percent rule figure, set against what you are paying\u003c\/li\u003e\n\u003cli\u003eEight inputs drive everything: change the ARV once and the profit, the return, the 70% rule and all sixteen cells move together\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe costs most calculators skip\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eHolding costs by the month, including loan interest, council tax, insurance, utilities, security and staging, multiplied by the months you expect to hold the property\u003c\/li\u003e\n\u003cli\u003eLender points on the draw\u003c\/li\u003e\n\u003cli\u003eAgent fee and seller's closing costs on the way out\u003c\/li\u003e\n\u003cli\u003eA rehab budget of thirteen lines, budget against actual, with a contingency percentage that moves with the scope\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe property books underneath\u003c\/h2\u003e\u003cp\u003eEverything recalculates from one list, so nothing is typed twice.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eIncome and expenses, coded to the property\u003c\/li\u003e\n\u003cli\u003eMaintenance jobs recorded against the unit they belong to\u003c\/li\u003e\n\u003cli\u003eProfit and loss for each property, not averaged across them\u003c\/li\u003e\n\u003cli\u003eEvery total, margin, percentage and date 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\u003cp\u003eThe nine connected tabs include a Start Here tab that walks you through setup in a few minutes, so the roi calculator and the books are ready to use quickly.\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\u003eNo 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: a worked demo deal you can click through, and a blank one for your own\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\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eWhat does the 16-cell grid show?\u003c\/h3\u003e\u003cp\u003eEach cell rebuilds the whole deal for a different after-repair value and rehab overrun, so you can see the profit if the valuation comes in light or the works run over.\u003c\/p\u003e\u003ch3\u003eDoes it calculate the 70% rule?\u003c\/h3\u003e\u003cp\u003eYes. It works out the 70% rule figure and sets it against the price you are paying.\u003c\/p\u003e\u003ch3\u003eAre holding and selling costs included?\u003c\/h3\u003e\u003cp\u003eYes. Holding costs are entered by the month and multiplied by the months held, and lender points, agent fee and seller's closing costs are included.\u003c\/p\u003e\u003ch3\u003eHow many inputs do I need to enter?\u003c\/h3\u003e\u003cp\u003eEight inputs drive the deal. Change one and the profit, the return, the 70% rule and the grid all update together.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864632414,"sku":"OPX-086","price":35.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/house-flip-profit-calculator-01.jpg?v=1790832420"},{"product_id":"capital-gains-cost-basis-tracker","title":"Capital Gains Tracker Spreadsheet","description":"\u003cp\u003eThis capital gains tracker is a record-keeping workbook for people who buy and sell stocks and funds and want every sale worked out from their own entries. Log each buy and each sale, and the file matches sales to the shares bought first and shows the cost basis, gain or loss and holding period.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003ePick any of the last eight tax years, or all years, and the whole page follows. Every figure comes from what you entered.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eNet gain or loss on your sales in the year\u003c\/li\u003e\n\u003cli\u003eWhich stocks and funds made the gains and which made the losses\u003c\/li\u003e\n\u003cli\u003eEach year's realized gain, split by how long the shares were held\u003c\/li\u003e\n\u003cli\u003eThe sales that made the most and lost the most, side by side\u003c\/li\u003e\n\u003cli\u003eProceeds against cost basis, year by year, and the share of proceeds from each holding\u003c\/li\u003e\n\u003cli\u003eGain or loss sold in each month of the year picked\u003c\/li\u003e\n\u003cli\u003eThe gain or loss on what you still own, at the prices you typed, and the lots turning long term next\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEvery sale matched, first in, first out\u003c\/h2\u003e\u003cp\u003eEach buy is logged as a lot. Each sale takes shares from the lots you bought first, and its cost basis, gain or loss and the date of the oldest lot are worked out. A sale bigger than what you held is flagged.\u003c\/p\u003e\u003ch2\u003eShort and long term, split\u003c\/h2\u003e\u003cp\u003eWhen a sale reaches into tax lots on both sides of a year, it is split, so the short-term and long-term parts are shown separately.\u003c\/p\u003e\u003ch2\u003eWhat is still held\u003c\/h2\u003e\u003cp\u003eEvery lot shows the shares left, their cost, their value at the price you typed and the day the lot turns long term. Prices are typed by you; nothing is fetched, so your stock portfolio stays private and offline.\u003c\/p\u003e\u003ch2\u003eBy tax year and by stock\u003c\/h2\u003e\u003cp\u003eThe Tax Years tab sets proceeds, cost basis, short and long term gains and losses side by side for eight years, and adds up each stock for the year. It is an investment tracker for your records only, not tax or investment advice.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Buys, Sales, Tax Years and Dashboard.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not only the dashboard, and both run on the same formulas, so you simply pick the look you prefer. Each edition comes filled with a worked example and as a blank copy, in Excel and in Google Sheets.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example (five years of buys and sales in one brokerage account), and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, 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. They are for personal and business use on your own devices, so please do not share or resell them. 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\u003eDo I need Excel, or can I use Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. You get Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eWhich method does it use to match sales?\u003c\/h3\u003e\u003cp\u003eFirst in, first out. Each sale takes shares from the lots you bought first.\u003c\/p\u003e\u003ch3\u003eDoes it fetch stock prices?\u003c\/h3\u003e\u003cp\u003eNo. Prices are typed by you and nothing is fetched or connected to a broker.\u003c\/p\u003e\u003ch3\u003eDoes it split short-term and long-term gains?\u003c\/h3\u003e\u003cp\u003eYes. A sale that reaches into lots on both sides of a year is split, and each tax year shows short and long term separately. It records your entries and is not tax advice.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Every tab is restyled with the same formulas, and both editions come with every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597876101214,"sku":"OPX-241","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/capital-gains-cost-basis-tracker-01.jpg?v=1790833305"},{"product_id":"crypto-cost-basis-tracker","title":"Crypto Cost Basis Tracker Spreadsheet","description":"\u003cp\u003eThis crypto cost basis tracker is for people who buy, sell and move coins and want a clear record of what each sell cost them. Log one row per trade or transfer, and every sell gets its cost basis worked out two ways, first in first out and average cost, with the gain beside each.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose all coins or any single coin, and the whole page follows. It fills itself from your trades.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eWhat your coins are worth at the prices you typed, against their cost\u003c\/li\u003e\n\u003cli\u003eMoney spent buying and received selling, month by month\u003c\/li\u003e\n\u003cli\u003eWhat each coin cost you and what it is worth now, with average buy price against the price now\u003c\/li\u003e\n\u003cli\u003eThe cost of the coins still held, month by month\u003c\/li\u003e\n\u003cli\u003eEvery fee you logged, and its share of what you traded\u003c\/li\u003e\n\u003cli\u003eThe value held on each exchange and in each wallet\u003c\/li\u003e\n\u003cli\u003eRealized gain each year counted both ways, and your latest sells with proceeds and gain\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eCost basis, two ways\u003c\/h2\u003e\u003cp\u003eEach row holds the date, the amount, the price in dollars and the fee. Every sell is costed first in, first out and at average cost, so you can see the crypto gains under each method side by side. Rows out of date order are flagged.\u003c\/p\u003e\u003ch2\u003eEvery coin\u003c\/h2\u003e\u003cp\u003eThe Cost Basis tab shows what you bought and sold of each coin, your average buy price, what you hold, what it is worth at your price and the unrealized gain so far. It works as a bitcoin tracker and covers every other coin in your crypto portfolio too.\u003c\/p\u003e\u003ch2\u003eEvery exchange and wallet\u003c\/h2\u003e\u003cp\u003eTransfers move coins between exchanges and wallets without touching cost, and the Exchanges tab shows how much sits where.\u003c\/p\u003e\u003ch2\u003eNothing connected\u003c\/h2\u003e\u003cp\u003eNo API keys and no logins: the file never connects to an exchange, and you type the price when you look. It is a crypto spreadsheet for your own records and a tidy crypto tax log to work from, not tax or investment advice.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Trades, Cost Basis, Exchanges and Dashboard.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not only the dashboard, and both run on the same formulas, so you simply pick the look you prefer. Each edition comes filled with a worked example and as a blank copy, in Excel and in Google Sheets.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example (three years of crypto trades across four exchanges and wallets), and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, 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. They are for personal and business use on your own devices, so please do not share or resell them. 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\u003eWill it work in Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The download includes Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it connect to my exchange or wallet?\u003c\/h3\u003e\u003cp\u003eNo. There are no API keys and no logins. You enter each trade and type the price when you look.\u003c\/p\u003e\u003ch3\u003eWhich cost basis methods does it use?\u003c\/h3\u003e\u003cp\u003eTwo: first in, first out and average cost. Every sell shows its cost basis and gain under both, side by side.\u003c\/p\u003e\u003ch3\u003eDo transfers between wallets count as sells?\u003c\/h3\u003e\u003cp\u003eNo. Transfers move coins between exchanges and wallets without touching cost, and the Exchanges tab shows how much sits where.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Every tab is restyled with the same formulas, and both editions come with every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597876166750,"sku":"OPX-242","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/crypto-cost-basis-tracker-01.jpg?v=1790833311"},{"product_id":"options-trading-journal","title":"Options Trading Journal Spreadsheet","description":"\u003cp\u003eThis options trading journal is for traders who want an honest record of how each strategy has gone. Log one row per trade, close it when it ends, and the file works out the P\/L, days held, return on premium and result, then compares your strategies side by side.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose all strategies or any one of them, and the whole page follows. Every number comes from your entries.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eNet P\/L on your closed trades\u003c\/li\u003e\n\u003cli\u003eP\/L month by month, with the running total over the year\u003c\/li\u003e\n\u003cli\u003eWhich strategies made money and which lost it, and the win rate for each\u003c\/li\u003e\n\u003cli\u003eEvery open trade, nearest expiry first, with the days left and how many expire within your warning days\u003c\/li\u003e\n\u003cli\u003eHow trades ended: closed, expired, assigned or rolled\u003c\/li\u003e\n\u003cli\u003eWins and losses by how long the trade stayed open\u003c\/li\u003e\n\u003cli\u003eThe latest closed trades, with how they ended and their P\/L\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEvery trade worked out\u003c\/h2\u003e\u003cp\u003eEach row of the trade log holds the open date, ticker, strategy, call or put, sold or bought to open, strike, expiry, contracts and premium. It handles calls, puts and spreads. Close a trade and its P\/L after fees, days held, return on premium and result are filled in. An expired trade closes at zero.\u003c\/p\u003e\u003ch2\u003eEvery strategy side by side\u003c\/h2\u003e\u003cp\u003eThe Strategies tab shows trades, win rate, net P\/L, average win and loss, days held, best and worst for each strategy you trade, using your own strategy names, from covered calls to spreads.\u003c\/p\u003e\u003ch2\u003eOpen trades watched, month by month\u003c\/h2\u003e\u003cp\u003eEvery open trade shows its days to expiry and is marked once it is inside the number of days you set. The Months tab counts trades opened and closed, win rate, P\/L and running P\/L for the last twelve months. It is an options tracker and trading journal for your own records, not trading advice.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Trades, Strategies, Months and Dashboard.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not only the dashboard, and both run on the same formulas, so you simply pick the look you prefer. Each edition comes filled with a worked example and as a blank copy, in Excel and in Google Sheets.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example (a year of option trades across seven strategies), and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, 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. They are for personal and business use on your own devices, so please do not share or resell them. 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\u003eDo I need Excel, or can I use Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. You get Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it connect to my broker?\u003c\/h3\u003e\u003cp\u003eNo. You type each trade and how it closed, and the file works out the results from your entries.\u003c\/p\u003e\u003ch3\u003eCan I use my own strategy names?\u003c\/h3\u003e\u003cp\u003eYes. Strategies are your own names, and each one gets its trades, win rate, net P\/L, average win and loss, days held, best and worst.\u003c\/p\u003e\u003ch3\u003eHow does it handle a trade that expires?\u003c\/h3\u003e\u003cp\u003eMark it expired and it closes at zero, with the P\/L and result worked out. Trades can also end closed, assigned or rolled.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Every tab is restyled with the same formulas, and both editions come with every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597876199518,"sku":"OPX-243","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/options-trading-journal-01.jpg?v=1790833316"},{"product_id":"retirement-withdrawal-calculator","title":"Retirement Withdrawal Calculator Spreadsheet","description":"\u003cp\u003eThis retirement withdrawal calculator is for people planning or living in retirement who want to see how their own numbers play out. Type your savings, age, planned spending and Social Security or pension, and the file runs it one row a year to the age the money lasts to. It is not a forecast: every rate is an assumption you choose.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003ePick any age in your plan and the cards and the year statement follow.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSavings at the start of the year picked, on your assumptions\u003c\/li\u003e\n\u003cli\u003eSavings at the end of each age, with the year picked lit\u003c\/li\u003e\n\u003cli\u003eWhere spending comes from: Social Security and pensions against what is withdrawn\u003c\/li\u003e\n\u003cli\u003eWhat If: the age the money lasts to with spending higher or lower and growth faster or slower\u003c\/li\u003e\n\u003cli\u003eSpending, income, withdrawal and growth for one year\u003c\/li\u003e\n\u003cli\u003eThe share of savings taken out at each age\u003c\/li\u003e\n\u003cli\u003eYour real balances against what the plan said, year by year\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eYear by year\u003c\/h2\u003e\u003cp\u003eEach row shows savings at the start, spending, Social Security, what you withdraw, growth and what is left. Social Security is added from the age it starts, spending rises each year by the rate you set, and the file shows the age the money lasts to and what is left at your plan age. The withdrawal rate is shown every year.\u003c\/p\u003e\u003ch2\u003eWhat If\u003c\/h2\u003e\u003cp\u003eThe same withdrawal plan is run at five spending levels and five growth rates, 25 combinations in all, each showing the age the money lasts to and what is left at your plan age. Change the growth and see how much the answer moves.\u003c\/p\u003e\u003ch2\u003eActual against plan\u003c\/h2\u003e\u003cp\u003eOnce you are drawing down, the Actual tab works as a drawdown tracker: log your real balance each January and what you took out, and see whether you are ahead or behind the plan.\u003c\/p\u003e\u003ch2\u003eYour numbers only\u003c\/h2\u003e\u003cp\u003eEvery rate is yours to type, so the retirement income picture reflects your assumptions only. It is a planning and retirement budget tool, not financial advice or a prediction of returns.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Year by Year, What If, Actual and Dashboard.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not only the dashboard, and both run on the same formulas, so you simply pick the look you prefer. Each edition comes filled with a worked example and as a blank copy, in Excel and in Google Sheets.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example (a couple three years into retirement), and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, 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. They are for personal and business use on your own devices, so please do not share or resell them. 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 Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The download includes Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it predict how my investments will do?\u003c\/h3\u003e\u003cp\u003eNo. It is not a forecast. The growth rate and the yearly rise in spending are both rates you type, and the file shows what follows from those assumptions.\u003c\/p\u003e\u003ch3\u003eCan I include Social Security or a pension?\u003c\/h3\u003e\u003cp\u003eYes. Social Security is added from the age it starts, and the dashboard sets Social Security and pensions against what is withdrawn.\u003c\/p\u003e\u003ch3\u003eCan I compare different spending levels?\u003c\/h3\u003e\u003cp\u003eYes. The What If tab runs the same plan at five spending levels and five growth rates, 25 combinations, showing the age the money lasts to.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Every tab is restyled with the same formulas, and both editions come with every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597876232286,"sku":"OPX-244","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/retirement-withdrawal-calculator-01.jpg?v=1790833322"},{"product_id":"room-rental-tracker-landlord","title":"Room Rental Tracker Spreadsheet","description":"\u003cp\u003eThis room rental tracker is for landlords who rent by the room in one or more shared houses. List every room once, then log tenants, rent and house bills, and each room shows who is in it, what it earns and whether anyone is behind.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose all houses or any one of them, and the whole page follows. It fills itself from your entries.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eRent paid this month against the rent roll of the rooms let\u003c\/li\u003e\n\u003cli\u003eRent in each month set against the house bills you paid\u003c\/li\u003e\n\u003cli\u003eRent in for each room, month by month, with the empty months showing\u003c\/li\u003e\n\u003cli\u003eEach room's twelve months: what you kept, its share of the bills and what was not collected\u003c\/li\u003e\n\u003cli\u003eTenant, rent, deposit, lease end and status for every room\u003c\/li\u003e\n\u003cli\u003eLate rent owed past the grace days, how many owe it and how many rents came in late each month\u003c\/li\u003e\n\u003cli\u003eBills by kind over twelve months, and the leases that end next\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEvery room on one row\u003c\/h2\u003e\u003cp\u003eThe Rooms tab shows each room's tenant, rent, deposit, lease end, status, days vacant and the next move-in. Rooms are marked let, vacant or ending soon, the days a room has stood empty are counted, and deposits held are totaled.\u003c\/p\u003e\u003ch2\u003eLate rent, worked out\u003c\/h2\u003e\u003cp\u003eRent is due on each tenant's move-in day, and anything owed past the grace days is counted for you. The Tenants tab and the Rent Log together make a simple rent ledger and tenant tracker.\u003c\/p\u003e\u003ch2\u003eBills shared out, occupancy per room\u003c\/h2\u003e\u003cp\u003eEach house's bills (electric, gas, water, internet and the rest) are split over its rooms, so every room shows its rental income after them. Days let and occupancy over the last twelve months are charted room by room.\u003c\/p\u003e\u003ch2\u003eSeven connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Rooms, Tenants, Rent Log, House Bills and Dashboard. It is a landlord spreadsheet built for the room-by-room way of letting.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook, filled with a worked example: three houses let room by room, with twenty months of tenants and rent\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\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. They are for personal and business use on your own devices, so please do not share or resell them. 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 Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The download includes Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I track more than one house?\u003c\/h3\u003e\u003cp\u003eYes. Rooms belong to a house, and the dashboard lets you pick all houses or any one of them.\u003c\/p\u003e\u003ch3\u003eHow is late rent worked out?\u003c\/h3\u003e\u003cp\u003eRent is due on each tenant's move-in day. Anything still owed after the grace days you set is counted as late rent owed.\u003c\/p\u003e\u003ch3\u003eCan it split house bills between rooms?\u003c\/h3\u003e\u003cp\u003eYes. Each house's bills are shared over its rooms, so every room shows what it earns after bills.\u003c\/p\u003e\u003ch3\u003eIs there a filled example?\u003c\/h3\u003e\u003cp\u003eYes. The example copy has three houses let room by room with twenty months of tenants and rent, and a blank copy is included.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597876363358,"sku":"OPX-246","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/room-rental-tracker-landlord-01.jpg?v=1790833335"},{"product_id":"airbnb-cleaning-schedule-tracker","title":"Airbnb Cleaning Schedule and Turnover Tracker","description":"\u003cp\u003eThis airbnb cleaning schedule is for hosts and co-hosts who juggle cleaners across one or more short term rental homes. Log each booking once, and the next check-in on the same rental is found for you with the hours available to clean, and same-day turnovers are marked.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose all rentals or any one, and the whole page follows. Nothing on it is typed.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCleans coming in the next seven days, and the next thirty\u003c\/li\u003e\n\u003cli\u003eThe next 14 days for every rental: check-outs, check-ins and same-day turns\u003c\/li\u003e\n\u003cli\u003eThe next cleans, with hours to clean and who is doing each\u003c\/li\u003e\n\u003cli\u003eHow many turns were same day, next day or longer\u003c\/li\u003e\n\u003cli\u003eOn time, late and missed cleans for each cleaner over the last 90 days\u003c\/li\u003e\n\u003cli\u003eCleaning fees charged against cleaner pay and supplies by month, and profit by rental\u003c\/li\u003e\n\u003cli\u003eNeeds attention: no cleaner yet, not marked done, late or missed\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEvery turnover coming up\u003c\/h2\u003e\u003cp\u003eThe Turnovers tab lists each clean soonest first with the hours to clean, the cleaner and the pay. Pick the cleaner and mark each clean done, late or missed. A turnover with no cleaner booked is flagged, so the turnover schedule never has a gap you miss.\u003c\/p\u003e\u003ch2\u003eThe next two weeks at a glance\u003c\/h2\u003e\u003cp\u003eEvery vacation rental, every day: check-outs, check-ins, same-day turns and guests staying, laid out as a cleaner schedule you can share.\u003c\/p\u003e\u003ch2\u003eEach cleaner and what cleaning costs\u003c\/h2\u003e\u003cp\u003eThe Cleaners tab shows turnovers, on time, late and missed, and pay over the last 90 days and this month. The Supplies tab logs restocks, and each rental's cleaning fees are set against cleaner pay and supplies over twelve months, so every airbnb host can see what cleaning really makes or costs.\u003c\/p\u003e\u003ch2\u003eSeven connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Stays, Turnovers, Cleaners, Supplies and Dashboard.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook, filled with a worked example: a year of stays and cleans across four rentals\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\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. They are for personal and business use on your own devices, so please do not share or resell them. 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\u003eDo I need Excel, or can I use Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. You get Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it connect to Airbnb or my calendar?\u003c\/h3\u003e\u003cp\u003eNo. You log each stay once, and the file finds the next check-in on the same rental and works out the hours to clean.\u003c\/p\u003e\u003ch3\u003eCan I manage more than one rental?\u003c\/h3\u003e\u003cp\u003eYes. Every stay belongs to a rental, and the dashboard shows all rentals or any one of them.\u003c\/p\u003e\u003ch3\u003eCan I see how reliable each cleaner is?\u003c\/h3\u003e\u003cp\u003eYes. Each cleaner's on time, late and missed cleans and pay are shown for the last 90 days and this month.\u003c\/p\u003e\u003ch3\u003eIs there a filled example?\u003c\/h3\u003e\u003cp\u003eYes. The example copy holds a year of stays and cleans across four rentals, and a blank copy is included.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597877444702,"sku":"OPX-247","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/airbnb-cleaning-schedule-tracker-01.jpg?v=1790833341"},{"product_id":"land-investment-calculator","title":"Land Investment Calculator Spreadsheet","description":"\u003cp\u003eThis land investment calculator is for people weighing up raw land deals who want their numbers in one place. Log the land that sold near you, type a parcel's asking price and your offer, and the file sets it against similar sales and runs the deal on your own estimates.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003ePick a way out, sold whole or split into lots, and the cards and costs follow.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eWhat the deal would make on your estimates, and the cash it needs\u003c\/li\u003e\n\u003cli\u003eSale price, every cost and the profit for the way picked\u003c\/li\u003e\n\u003cli\u003eThe comparable sales used, highest price an acre first, and how many feed the deal\u003c\/li\u003e\n\u003cli\u003eEvery parcel you are watching against its area's average\u003c\/li\u003e\n\u003cli\u003eSelling whole against splitting into lots, side by side\u003c\/li\u003e\n\u003cli\u003eThe average price an acre in each area, with the deal's area lit\u003c\/li\u003e\n\u003cli\u003eProfit sold whole if the price an acre comes in higher or lower\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eComparable sales\u003c\/h2\u003e\u003cp\u003eEvery land sale you log gets its price per acre worked out, and the ones that fit your deal are marked: same area, similar size and recent.\u003c\/p\u003e\u003ch2\u003eYour offer, in context\u003c\/h2\u003e\u003cp\u003eThe asking price and your offer an acre are set against the comparables' average, lowest and highest, and your offer is shown as a share of the value.\u003c\/p\u003e\u003ch2\u003eTwo ways out\u003c\/h2\u003e\u003cp\u003eClosing, holding and selling costs are added. Then the parcel is run sold whole, or split into lots with survey, road, permits and utilities, for anyone thinking of land flipping or wanting to subdivide land. Each way shows cash in, profit, return a year and the break-even price an acre, all from the figures you enter.\u003c\/p\u003e\u003ch2\u003eWhat if\u003c\/h2\u003e\u003cp\u003eProfit is shown as the price an acre and the months held move, and as your offer moves against the sale price. The Deals tab keeps every parcel you are watching. These are estimates you type, not a valuation or investment advice.\u003c\/p\u003e\u003ch2\u003eSeven connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Deal, Comparables, What If, Deals and Dashboard.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook, filled with a worked example: a 20-acre deal against 33 land sales in three areas\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\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. They are for personal and business use on your own devices, so please do not share or resell them. 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 Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The download includes Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eWhere do the comparable sales come from?\u003c\/h3\u003e\u003cp\u003eYou log the land sales near you. The file works out the price an acre and marks the ones in the same area, of a similar size and recent.\u003c\/p\u003e\u003ch3\u003eCan it compare selling whole with splitting into lots?\u003c\/h3\u003e\u003cp\u003eYes. It runs both ways out side by side, with survey, road, permits and utilities for the lots, and shows profit and break-even price an acre for each.\u003c\/p\u003e\u003ch3\u003eDoes it tell me whether to buy?\u003c\/h3\u003e\u003cp\u003eNo. It calculates from the prices, costs and estimates you type, and it is not a valuation or investment advice.\u003c\/p\u003e\u003ch3\u003eIs there a worked example?\u003c\/h3\u003e\u003cp\u003eYes. The filled copy is a 20-acre deal against 33 land sales in three areas, and a blank copy is included.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597877837918,"sku":"OPX-248","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/land-investment-calculator-01.jpg?v=1790833346"},{"product_id":"rental-maintenance-repair-tracker","title":"Rental Maintenance Tracker Spreadsheet","description":"\u003cp\u003eThis rental maintenance tracker is for landlords and property managers who want every repair on one list until it is fixed. Log one row per request with the unit, issue, priority and contractor, and the days open are counted against the target for that priority, so anything left waiting stands out.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose all repairs or one kind, such as plumbing or electrical, and the page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eRequests still open or scheduled, with emergencies counted\u003c\/li\u003e\n\u003cli\u003eEvery open request, longest waiting first, with those past target in red\u003c\/li\u003e\n\u003cli\u003eYour cost and what others paid, by the month fixed\u003c\/li\u003e\n\u003cli\u003eYour cost for each unit and for each kind of repair over twelve months\u003c\/li\u003e\n\u003cli\u003eAverage days to fix against the target for each priority\u003c\/li\u003e\n\u003cli\u003eHow fast each contractor fixes things\u003c\/li\u003e\n\u003cli\u003eRecurring jobs overdue or due soon, and the upkeep falling due in each of the next twelve months\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEvery maintenance request\u003c\/h2\u003e\u003cp\u003eThe Requests tab is your repair log and work order list: reported, scheduled and fixed dates, the unit, the issue, the priority, the contractor, the cost and who paid. Owner cost is kept separate from tenant or warranty cost.\u003c\/p\u003e\u003ch2\u003eDays open, against a target\u003c\/h2\u003e\u003cp\u003eEach priority has its own target number of days. Any request open past it is flagged.\u003c\/p\u003e\u003ch2\u003eRecurring upkeep\u003c\/h2\u003e\u003cp\u003eFilters, gutters, detectors and the rest are scheduled with the next date, and a twelve-month strip shows what is due when.\u003c\/p\u003e\u003ch2\u003eBy unit and by contractor\u003c\/h2\u003e\u003cp\u003eThe Units and Contractors tabs add up requests, emergencies, days to fix, on-target rate and cost over twelve months. It doubles as a contractor tracker and a landlord tracker for upkeep.\u003c\/p\u003e\u003ch2\u003eSeven connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Requests, Recurring, Units, Contractors and Dashboard.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook, filled with a worked example: fourteen months of repairs across eight units\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\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. They are for personal and business use on your own devices, so please do not share or resell them. 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\u003eDoes it work in Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You get Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow does it flag slow repairs?\u003c\/h3\u003e\u003cp\u003eEach priority has its own target in days. The file counts how long every request has been open and flags anything past its target.\u003c\/p\u003e\u003ch3\u003eCan I record who paid for a repair?\u003c\/h3\u003e\u003cp\u003eYes. Each request records the cost and who paid, keeping owner cost separate from tenant or warranty cost.\u003c\/p\u003e\u003ch3\u003eCan it remind me of regular upkeep?\u003c\/h3\u003e\u003cp\u003eYes. The Recurring tab holds jobs like filters, gutters and detectors with the next date, and shows twelve months of upkeep at a glance.\u003c\/p\u003e\u003ch3\u003eIs there a filled example?\u003c\/h3\u003e\u003cp\u003eYes. The example copy holds fourteen months of repairs across eight units, and a blank copy is included.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597877936222,"sku":"OPX-249","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/rental-maintenance-repair-tracker-01.jpg?v=1790833352"},{"product_id":"hoa-dues-treasurer-tracker","title":"HOA Dues Tracker Spreadsheet","description":"\u003cp\u003eThis HOA dues tracker is made for the volunteer hoa treasurer of a homeowners or condo association. List the homes once and log each payment as it arrives, and every home's year fills in, so the homes behind are plain to see.\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\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eChoose any month of the association's year, or the whole year, and the page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDues paid against dues due so far, and collected against expected each month\u003c\/li\u003e\n\u003cli\u003eEvery month's homes paid, part paid and late\u003c\/li\u003e\n\u003cli\u003eEvery home that owes the association, most owed first\u003c\/li\u003e\n\u003cli\u003eSpending so far against the budget's pace through the year\u003c\/li\u003e\n\u003cli\u003eEach category's spending against its budget, with overs in red\u003c\/li\u003e\n\u003cli\u003eThe reserve fund balance now, with this year's money in and out\u003c\/li\u003e\n\u003cli\u003eOperating and reserve accounts at the start of the year and now, and the biggest bills paid\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEvery home, every month\u003c\/h2\u003e\u003cp\u003eThe Dues by Month tab fills from the payments, oldest month first, marking each month paid, part paid or late and showing the month each home is paid through. The Payments tab is a plain payment ledger behind it.\u003c\/p\u003e\u003ch2\u003eWhat each home owes\u003c\/h2\u003e\u003cp\u003eThe Homes tab lists every home and owner with dues so far, paid, last year's balance and any special assessment, kept separate, with a status for each.\u003c\/p\u003e\u003ch2\u003eBudget against actual\u003c\/h2\u003e\u003cp\u003eThe Budget tab sets each category's spending against its hoa budget and against how far through the year you are, from the expenses you log.\u003c\/p\u003e\u003ch2\u003eThe two accounts\u003c\/h2\u003e\u003cp\u003eOperating and reserve each show the opening balance, money in, money out and what is there now, which makes the board report easy to put together.\u003c\/p\u003e\u003ch2\u003eEight connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Homes, Dues by Month, Payments, Expenses, Budget and Dashboard.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook, filled with a worked example: a year of dues and spending for a 36-home association\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\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. They are for personal and business use on your own devices, so please do not share or resell them. 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 the board share it in Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The download includes Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow does it mark late dues?\u003c\/h3\u003e\u003cp\u003ePayments fill each home's months oldest first. Each month is marked paid, part paid or late, with the month each home is paid through.\u003c\/p\u003e\u003ch3\u003eCan it handle special assessments?\u003c\/h3\u003e\u003cp\u003eYes. Special assessments are kept separate and included in what each home owes, alongside last year's balance.\u003c\/p\u003e\u003ch3\u003eDoes it track the reserve fund?\u003c\/h3\u003e\u003cp\u003eYes. The operating account and the reserve fund each show the opening balance, money in, money out and the balance now.\u003c\/p\u003e\u003ch3\u003eIs there a filled example?\u003c\/h3\u003e\u003cp\u003eYes. The example copy holds a year of dues and spending for a 36-home association, and a blank copy is included.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597877968990,"sku":"OPX-250","price":19.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/hoa-dues-treasurer-tracker-01.jpg?v=1790833358"}],"url":"https:\/\/opxviashop.com\/collections\/investing-property.oembed","provider":"OPXVIA","version":"1.0","type":"link"}