More tools
Lesson 63
Tables: your office spreadsheets inside Keptmarks
Keep expiry dates, contracts, quotes or keys in spreadsheet-style tables linked to homes and tickets.
- Length:
- 2 min
- Plan:
- Professional
Watch first: 21. Maintenance: tickets and what the team reports
Tables
2 min · Recorded on October 31, 2026
Step by step
- 1Tables is for what the office keeps in spreadsheets: expirations, owner contracts, quotes, expenses or key control, but inside Keptmarks and linked to your properties. There are templates to get started, with their columns ready. Tap New table and choose Expirations.
- 2It works like Excel. Tap Add row and type what expires, for example the fire insurance. With Tab you move to the next column and with Enter you edit it: the type, the property and the expiration date. You move around with the arrows, copy and paste from another spreadsheet, and Control Z undoes. Everything saves on its own.
- 3That’s how you add the rest: the fire extinguisher inspection and the city permit. The days left column calculates itself, and the status lets you mark whether it’s been renewed. There are columns of every kind: text, number, currency, date, status, person, property, file or phone, and also maintenance tickets, which show their status live.
- 4So nothing expires without a warning, in the options for the Expires column tap Edit column, turn on Remind before the date, choose how many days ahead and who gets it. The dates are checked every morning, and the reminder arrives in Keptmarks and on the phone. Tap Save.
- 5At the top you change the view: the table, the calendar with each expiration on its day, or the board by status. And with Filter and Group you set up what you need to see, for example, only insurance, or everything grouped by property.
- 6Under More actions you choose who can see it and who can edit it, and with Export you download it as Excel. Each person only sees the linked items they’re allowed to see in their module, and anything deleted can be recovered for twelve months from the trash.
The videos use a demo company with made-up data.