Operations
Reconciliations, vendor follow-ups, contract renewals and the reports that keep a business running.
Purchase order approval process for a small business
Use one request route, approval limits by amount, a backup approver, and separate approving, receiving and paying roles. Adapt it for a tiny team.
-
Write a process document for a one-person task
Record the expert doing the task while narrating, interview them for the why, have someone else write it up, then test it with a person who has never done it.
-
Write a weekly status update from Jira tickets
Pull the week's resolved and still-moving tickets with two JQL filters, then write a short headline, a status, wins, blockers and next steps.
-
Keep a running action item list across weekly meetings
Keep one action list per meeting series, with an owner, a date and a one-line outcome on every item, and one named tracker between meetings.
-
Find duplicate invoices in a payment list in Excel
Add a COUNTIFS helper column on invoice number and amount, filter for results above 1, then review each flagged pair before you delete anything.
-
Track vendor contract renewals so nothing auto-renews
Put every contract's notice deadline, not its end date, in one register with a named owner and staged alerts, and negotiate the renewal terms.
-
Chase vendors who haven't confirmed their delivery
Flag orders where the vendor has not stated a date and quantity, send a first reminder after a threshold you choose, then a second in a later window.
-
Pull data from a folder of invoice PDFs into Excel
Use Excel's Get Data > From File > From Folder to combine the PDFs with Power Query, which reads the tables in each file into one sheet. Best on text PDFs.