An audit schedule in Google Sheets, with email before the date
List the reviews your team already plans, name an owner, and email that person before a date on the schedule.
An audit schedule is a list of dates you already decided
An audit schedule in a spreadsheet is the list of reviews a team intends to do, and when. It might be an internal walkthrough, a vendor review, or a check that repeats. The sheet says what it is, when it is, and who owns it.
It is not the audit plan, the staffing plan, or the file of evidence. Those can live wherever you already keep them. The schedule's job is to make the date visible, and to email someone before that date if you turn the reminder on.
What an audit schedule should include
Start with name, date, owner, and recipient. Add the other columns when they change how someone prepares.
| Field | What it stores | Why keep it | Reminder |
|---|---|---|---|
| Name | The review, in words your team uses | So the email and the sheet name the same thing | Map this as the name |
| Type | Internal, vendor, operational, or another label you choose | Lets you filter the schedule without a second workbook | Sheet only |
| Department or location | Where the review applies | Useful when sites or teams own different rows | Sheet only |
| Owner | The person accountable for the date | The schedule should show who acts, not only when | Sheet only |
| Scheduled date | The visit, review, or due date you want watched | The usual date to email about | Map this as the date |
| Preparation date | An earlier date, if the team chooses to track one | A prep date and a visit date need separate rows if both should email | Map this only on the row whose date it is |
| Reminder email | Who should get the email | Often the owner, sometimes a shared inbox | Map this as the recipient |
| Status | Planned, preparing, done, or your own words | A person updates this after the date. The add-on does not | Sheet only |
| Folder link | A link to files you already store | The email can include it. The add-on does not open or manage the folder | Optional mapped link |
| Notes | Scope in a sentence, or who else is involved | Context for the owner. Not an audit program | Sheet only |
Dates a team might put on the schedule
These are examples of rows, not a required audit program. If your team does not do one of them, leave it off the sheet.
An internal review
A date the team set to look at its own process. Owner is whoever runs that review. Status changes when they say it is done.
A vendor review
A date to look at a supplier you already work with. The row can name the vendor in the title and point at a folder. It does not collect vendor documents by itself.
An operational check
A safety walk, a site visit, or another recurring look. Department or location tells you where. The date is whatever you scheduled.
A repeating date
When the visit is over, edit the row and type the next date if there is one. The add-on does not create the next cycle.
One date per reminder
A review can have a preparation date and a later visit date, or a visit date and a date the notes are due. Those are only separate emails if you store them as separate dates.
Put each date that should send mail on its own row. Give the rows the same name if they belong to one review, and use the type or notes column to say which date it is. You do not have to track a preparation date or a report date. Add them only when your team already uses them. This page does not describe an audit methodology.
How to create the schedule in Google Sheets
1. Write down the reviews you already intend to do
Start from the calendar, the whiteboard, or the list a manager already keeps. One review can be one row until a second date needs its own email.
2. Give every row a type and a place
Type and department are for filtering. Use the same few labels so the sheet does not turn into free text.
3. Put the date you want watched in the date column
If preparation and the visit both matter, make two rows and name the date in notes. Map the column that holds the date for that row.
4. Name the owner and the inbox
Owner is who is responsible. Reminder email is where the message goes. Use a shared address when a team watches the date together.
5. Link the folder you already use
Paste a URL if the working files live in shared storage. The schedule points at that folder. It does not become the folder.
6. Set the email, then keep editing the sheet
Choose 30 days before, 7 days before, 1 day before, and/or the date itself. After the review, change the status and the next date yourself.
Example: a short quarterly schedule
Fictional. The safety walk has a preparation row and a visit row because those are two dates. The other reviews have one date each.
| Review | Type | Where | Owner | Date | Which date | Status | Reminder email |
|---|---|---|---|---|---|---|---|
| Safety walk | Operational | Plant A | Facilities | 1 Apr | Preparation | Planned | facilities@example.com |
| Safety walk | Operational | Plant A | Facilities | 8 Apr | Visit | Planned | facilities@example.com |
| Vendor review | Vendor | Procurement | Sam Ortiz | 22 Apr | Visit | Planned | sam@example.com |
| Access review | Internal | IT | Jordan Lee | 6 May | Visit | Preparing | it@example.com |
| Cash handling check | Operational | Retail | Priya Shah | 19 May | Visit | Planned | priya@example.com |
| Policy spot check | Internal | HR | Alex Kim | 2 Jun | Visit | Planned | alex@example.com |
Status is typed by the owner. A folder link can be another column. These rows do not certify a result.
Checking the schedule yourself, or getting the email
The sheet remains the schedule either way. The email only changes who has to remember to open it.
Without a reminder
- Someone maintains the date list
- They open it on a cadence they hope to keep
- A date in a busy week waits until the next look
- Preparation starts late, or not at all
With a date email
- The same person maintains the list
- The mapped date approaches
- The address on that row gets the email
- The owner runs the review they already planned
A spreadsheet is a fit for a lightweight schedule. Audit-management software is a better fit when you need the system to hold evidence and workpapers, record findings, route approvals, or run the audit itself. Date & Email Reminders does not do those things. It emails someone about a date already in Google Sheets. A broader list of obligations belongs on the compliance tracking spreadsheet.
Questions
The audit or review name, the date you want watched, the owner, and the email that should be reminded. Type, location, a preparation date, status, a folder link, and notes are useful when the team will actually look at them.
Yes, if you choose to track more than one. A visit date and a report date are different dates. Put each date that needs its own email on its own row. This page does not require a particular audit method.
Whatever your team already plans to put on a calendar: an internal review, a vendor review, an operational check, or a recurring visit. The sheet records the date. It does not define what the audit must contain.
Yes. Map that date and a recipient. Choose 30 days before, 7 days before, 1 day before, and/or the date itself.
No. The schedule stays the list. The email tells the recipient a date is close. Evidence, findings, and sign-off stay in whatever process you already use.
No. Copy the columns into the Google Sheet you already use. This page does not provide an Excel, Word, or PDF audit program.
No. Licenses, insurance, and document expirations already have their own pages. This schedule is for audit dates you choose to store. Compliance tracking spreadsheet
Related pages
Due dates in general, and broader compliance lists, are different pages.
Keep the schedule in the sheet you already update
Install Date & Email Reminders and map the date column and the recipient when you want the email. There is no schedule file to download.