Updates and help

Short answers for after you buy: which file to open, how to use the tracker in Excel or Google Sheets, how to download again, and where updates are listed.

Which file do I open?

The tracker comes as three workbooks plus a Quick Start guide:

  • SAMPLE: a full year of fictional listings, bookings and expenses. Open this first to see how everything looks when it is filled in.
  • BLANK: the same workbook with no data. Use this one for your own listings.
  • RENTAL-PROPERTY-SAMPLE: sample data for a small landlord with long-term and mid-term units.

Each of the other products opens in Word, Google Docs or any PDF reader.

Open the tracker in Excel

  1. Unzip the download if it came as a .zip file.
  2. Double-click the .xlsx file. If Excel opens it in Protected View, choose Enable Editing.
  3. Start on the Start Here tab. Type only in the cream cells; the gray-green cells are formulas. The sheets are not protected, so if you type over a formula by accident, copy it back from the row above.

Supported: Excel for Microsoft 365 / 2019 or newer (Windows and Mac), and Google Sheets. Not supported: Apple Numbers and Excel 2016.

Use the tracker in Google Sheets

  1. Go to Google Sheets and open a blank spreadsheet.
  2. Choose File, then Import, then Upload, and select the .xlsx file.
  3. Choose Create new spreadsheet and open it.
  4. Check the Settings tab, then work as you would in Excel.

Formatting can look slightly different in Google Sheets. If something looks wrong, email us with a screenshot.

Download again

Lost the email? Write to [email protected] with the email address you used to buy, and we will help.

Free updates

Updates within version 1 (v1.x) are free. When a new v1.x version is released it is listed below, and you can download it again from where you bought. Bug fixes and new wording are announced here first.

Version history
VersionWhat changed
v1.0First release.

If something does not work

  • A formula shows an error: check that you are using Excel for Microsoft 365 / 2019 or newer, or Google Sheets by import. Older versions can show #NAME?.
  • Dropdowns look empty: do not delete the Lists tab; it feeds every dropdown.
  • The numbers look too low: check that the Report year on the Settings tab matches the year of your bookings.
  • Anything else: email [email protected]. We reply within 2 business days.

Stay in touch (optional)

Get the free Host Starter Sheet and short hosting tips by email. Unsubscribe any time.