Office Manager Task Tracker — Free, Built from a Sheet

Your Tuesday, probably: the third-floor AC is making a noise someone described as "haunted," the coffee vendor's contract auto-renews in nine days, two monitors need ordering before next week's new hires arrive, the holiday party venue wants a deposit, and the CFO just walked past your desk saying "quick thing —" which has never once been quick.

Office management is the everything-job. Nothing you own shares a deadline rhythm: facilities requests arrive by ambush, contracts renew on annual clocks, events build for months and detonate in a day. And because every request enters through a different door — Slack, hallway, forwarded email, sticky note — you are the only person in the building who knows the status of anything. That's job security of the worst kind: the kind you can't take a vacation from.

The standard advice is to buy project software — Asana, Monday, or ClickUp at about $10 per person per month — but those assume a team sharing a backlog, and this backlog is a department of one. You likely already keep a sheet to survive. The upgrade isn't a migration; it's giving that sheet a front door for requests and a dashboard for you. AI builds both, and the sheet stays exactly where it is.

Step 1: Start With Your Everything Sheet

One row per request or task, whatever the category:

Facilities, vendors, supplies, and events all belong in the same sheet; the Category column keeps them sortable, and one sheet means one place to look.

Step 2: Sign Up Free

Accounts at lovespreadsheets.com are free, and free covers both the build and everyday use — paid features like colleague logins and your company's domain on the URL are optional later.

Step 3: Describe the Chaos, Precisely

Start from the Project Tracker template and spell out how requests actually cross your desk:

• "Requests come from anyone in the company; every one needs a requester, a category, and a status, even if the status is just New."
• "Vendor rows carry contract renewal dates — those are the dates that cost money when missed."
• "Waiting on quote, waiting on approval, and waiting on delivery are different kinds of stuck, and I need to see them separately from things I can act on right now."

Then make three asks:

• A request intake form — a link you post in Slack; submissions become rows in the sheet automatically, timestamped, requester attached. The hallway ambush becomes "drop it in the form."
• Renewal reminders — an email 30 days before any vendor contract renews, so auto-renewals become decisions instead of surprises
• A what's-stuck view — everything sitting in a Waiting status for more than a week, which is your chase list, pre-written

Let AI Optimize sharpen the description, field any follow-ups the AI sends back, and the build wraps in about twenty minutes.

Step 4: The Office, on One Screen

What lands in your browser: open requests grouped by status, a calendar showing due dates and renewals, category filters for budget conversations, and the intake form quietly funneling new work in. Anything you update on screen writes straight into the sheet; anything typed into the sheet appears on screen. Same data, two doors.

When the CFO asks about the AC now, the answer is a link, not a memory test.

Why Office Managers Keep the Sheet

Budget season is already solved. Every cost you logged all year filters by category and exports in seconds — the spend report assembles itself from rows you created in passing.

Handoffs stop being oral history. Vacation coverage, a new assistant, your own promotion: the next person opens the tracker and knows what's pending, what's stuck, and which vendor still owes a quote.

No procurement request to track your procurement. The irony of buying software to manage vendor spend is lost on no one. This costs nothing and carries no contract with a renewal date of its own.

Common Questions from Office Managers

Will people actually use the intake form? They will when it's the fastest way to get helped — and you can enforce it gently: form requests get statuses and updates; hallway requests get "put it in the form."

Can requesters check on their own request? Yes — ask for a requester view where anyone can see their submissions and current status, which ends the "any update on…?" pings.

Can my backup cover for me without breaking anything? Add a second login with edit access on the paid tier, or simply share the sheet — either way the statuses, notes, and vendor contacts are all there waiting.

Build Yours

Open the sheet that's been holding the office together — or spend one interrupted afternoon typing up the eight columns above — then visit lovespreadsheets.com and describe a week of your job. Twenty minutes of build later, the everything-job finally comes with the thing it never includes: a single screen where everything actually is.