# How to audit tickmarks in Excel workpapers on Mac: legends and cross-references, 2026

> Set up a tickmark legend and cross-references in Excel on Mac. Build the index, link each mark to its workpaper, and check for broken references.

URL: https://www.lazur.app/for/accountants/problems/audit-tickmarks-excel-cross-reference
Updated: 2026-11-08

To audit tickmarks in Excel workpapers on Mac, define each mark once on the index sheet. Then link every mark to the workpaper that holds its evidence. A tickmark says what you did. A cross-reference says where the proof is filed.

## Quick answer

- Put one tickmark legend on the index sheet, and define every mark there once.
- A tickmark records the procedure. A cross-reference records where the evidence sits.
- Use letter codes and a Data Validation list fed by a named range, so typos get caught.
- Run a break check before sign-off for unknown codes, unused codes and dead links.
- Caseware Working Papers lists Windows only in its requirements, so check your firm's setup first.

## What building tickmark legends and cross-references costs you

- **Hunting for meaning at review.** When a mark has no legend on the page, the reviewer stops and searches. They check the index, an older file or a colleague. Each lookup delays sign-off, and the questions come back as review notes. The guide behind this page says a tick mark without a legend is decoration.
- **Long hours in busy season.** BLS says overtime hours are typical at certain periods of the year, and it cites quarterly audits and tax season as examples. Distinct Recruitment's 2025/26 survey found 78% of respondents worked more than 50 hours a week. Clerical rework lands in those same weeks, so every avoidable fix matters.
- **Stress that outlasts the season.** Distinct reports that 57% called busy season somewhat or extremely stressful. Among respondents who received useful tools, 38% called it stressful, against 78% of those who received no practical support. That is an association from a survey with no stated sample size, so do not treat it as proof.
- **Rework after a missed link.** A broken cross-reference sends the reviewer to the wrong workpaper. They open the file, find nothing, then message the preparer. A link checked once before sign-off costs far less than that loop of messages and reopened files.

## Why it happens

1. **The legend is written last.** Many preparers add the legend after the file is full. By then the marks have grown in different directions. Writing the legend first forces one set of definitions before the work starts. Adding it at the end means guessing what each mark meant at the time.
2. **Excel does not know what a mark means.** Excel stores the letter T the same way whether it means traced, tested or total. The software cannot check a mark against a legend unless you build that check. Without a validation list or a count formula, a wrong code stays in the file until someone reads it.
3. **A mark and a reference do different jobs.** The tickmark records the procedure. The cross-reference records the file location. Teams often merge the two into one combined code, so the procedure and the location blur together. Keeping them apart lets each one stay short and checkable.
4. **Workpapers get renamed and moved.** Tabs get renamed, sheets move and files get saved under new names. A HYPERLINK formula stores its target as text, so it keeps pointing at the old name. Links break quietly, and nobody notices until a reviewer clicks one.
5. **Several people, several habits.** Each preparer brings a habit. One uses a letter, another uses a symbol, and a third writes the meaning in a comment. Without one legend on one index page, the same file holds three conventions at once.

## How to fix it

- **Put one legend on the index page.** Define every mark once, on the engagement index sheet. The guide behind this page recommends one engagement-level legend in that place. Reviewers then have one place to look, and preparers have one list to follow.
- **Use a fixed code list.** Name the code column, then point a Data Validation list at that name. New entries must match a code from the legend. Existing entries are not checked, so run a count check across the whole mark column before sign-off.
- **Number your exceptions.** Use exception references such as E-1 that point to an exception log, instead of bare marks or cell comments. The log holds the difference, the explanation and the resolution. One line in the file then carries the whole story.
- **Point cross-references at the workpaper number.** Cross-reference by the workpaper number, not by file name. Add a link if you want one-click access, but keep the number as plain text beside it. A link can break, and the number still tells a reviewer where to look.
- **Run one break check before sign-off.** Check for unknown codes, unused codes and links that fail. Use a count formula, a workbook search and one click on each link from a clean copy. Write the date of the check on the index so the reviewer knows it was done.

An audit file carries two kinds of marks. A tickmark is a short letter or symbol that says what you did to a figure. A cross-reference points to the workpaper where the evidence is filed. The guide behind this page says good workpapers usually use both, and trouble starts when one of them is missing or unclear.

## What a tickmark and a cross-reference each record

A tickmark answers one question: what procedure was performed? You might mark a cash balance as agreed to the bank statement. A cross-reference answers a second question: where is the proof? It is usually a workpaper number, such as C-1. Keep the two answers apart. If the mark says agreed but no reference follows, the reviewer has to guess where to look.

- **1,595,200** accountant and auditor jobs in 2025, per the BLS Occupational Outlook Handbook ([source](https://www.bls.gov/ooh/business-and-financial/accountants-and-auditors.htm))
- **78%** of busy-season respondents worked more than 50 hours a week (sample size not stated) ([source](https://www.distinctrecruitment.com/us/resources/blog/busy-season-2026-trends-in-workload-stress-support-across-public-accounting/))
- **57%** called busy season somewhat or extremely stressful in the same survey ([source](https://www.distinctrecruitment.com/us/resources/blog/busy-season-2026-trends-in-workload-stress-support-across-public-accounting/))

Busy season makes this harder. Distinct Recruitment's 2025/26 survey reports that 78% of respondents worked more than 50 hours a week. The page does not state its sample size, and the publisher is a recruiter. Read the figure as a warning sign, not a measurement. A clear legend takes less time to write than the questions it prevents, and you can check that on your own files.

![Accountant at a laptop reviewing audit tickmarks in Excel workpapers](https://images.lazur.app/content-images/problem/audit-tickmarks-excel-cross-reference/audit-tickmarks-in-excel-workpapers-1-79d7d2.jpg)

## Build the tickmark legend on the index sheet in Excel for Mac

Put the legend on the index sheet, the first tab a reviewer opens. Do not repeat it on every workpaper. The guide behind this page recommends one engagement-level legend on the index page, and it says a mark with no legend is decoration. The steps below use features in Excel for Mac in Microsoft 365.

1. Rename the first tab to Index. Keep it at the front of the file.
2. In column A, type each code exactly as it will appear. Use letters such as T, F, C or AN.
3. In column B, write the meaning in one plain sentence, such as agreed to bank statement.
4. In column C, write the workpaper number where the evidence is filed, such as C-1.
5. Select the code cells in column A. Choose Formulas > Define Name, and name the range Codes.
6. Right-click the Index tab and choose Tab Color, so reviewers find it fast.

> **Letters beat glyphs:** Check marks and boxes can look different across fonts, printers and PDF exports. Letter codes are easy to type and easy to search. If your firm insists on a symbol, press ⌃⌘Space to open the Character Viewer, then test the file on a second computer.

Next, lock entry to the list. Select the mark column on your working sheets. Go to the Data tab, choose Data Validation, set Allow to List, and type =Codes in the Source box. Anyone who then types a code outside the legend sees an error.

## Add cross-references that open the workpaper

A cross-reference can be plain text, a link, or both. Plain text survives every copy, archive and export. A link saves a click during review. Microsoft's support page on Excel links gives three routes: select a cell and choose Insert > Hyperlink, right-click the cell and choose Hyperlink, or press Ctrl+K. Those screens come from Windows. On a Mac, ⌘K is the likely shortcut, but Microsoft's page does not say so. Confirm it in your copy.

- Same sheet: =HYPERLINK("#A10","Go to Cell A10") jumps to cell A10 on the active sheet.
- Different sheet: put the sheet name in single quotes, such as =HYPERLINK("#'C-1 Bank'!A1","C-1").
- Another file: type the full path. The link breaks when the file moves or gets renamed.

Sheet names matter more than people expect. A HYPERLINK formula stores its target as text. Rename the tab and the formula keeps pointing at the old name, while ordinary cell references update themselves. Settle the sheet names before you build links, and avoid renaming tabs once review starts.

## A worked example: one cash balance traced end to end

Take a cash balance on the Cash sheet. The tickmark T on that row means agreed to the bank statement. The cross-reference C-1 names the workpaper that holds the bank confirmation. The legend on the Index tab defines T. Three records now tell one story, and each one does a different job.

Now suppose the bank statement shows a difference. The balance no longer agrees, so T does not apply to that row. Add the exception mark E-1 on the same row instead. E-1 points to the exception log, which holds the amount, the explanation and the resolution. The reviewer reads one row and follows one trail.

![Audit documents on a desk, ready for tickmarks in Excel workpapers](https://images.lazur.app/content-images/problem/audit-tickmarks-excel-cross-reference/audit-tickmarks-in-excel-workpapers-2-8cef11.jpg)

## Check for broken references and unused codes

A legend is only useful if it matches the file. Run these checks before you send a file for review. Excel will not run them for you.

- Unknown codes: in a spare column next to the marks, enter =COUNTIF(Codes,A2)=0 and fill it down. TRUE means the mark is not in the legend.
- Unused codes: press ⌘F and search the workbook for each code in the legend. A code with no marks may be stale, so remove it or explain it.
- Broken links: follow each link once from a clean copy of the file. A failing link shows an error or opens nothing.
- Missing references: check that every procedure mark has a cross-reference in the next column.

These checks are manual. A clean result shows the file is consistent. It does not show the evidence is correct, which still needs a reviewer.

## Common mistakes people make with tickmark legends

- Defining a mark on one page only. The reader on another page cannot decode it.
- Typing codes by hand, so AN and A/N both appear in the same file.
- Linking to a file name instead of a workpaper number. A rename breaks the trail.
- Putting exception notes in cell comments instead of an exception log. Comments can be easy to miss when a file is printed or exported.
- Changing a meaning mid-engagement without updating the legend. Older pages keep the old meaning.

Each of these feels fast on the day and slow at review. The legend takes longer at the start and saves the back and forth later.

## Where the vendor docs stop for Mac users

If your firm uses Caseware Working Papers, its requirements page lists Windows 10 and Windows 11 (64-bit). It does not list macOS or ARM. Ask your IT team what your firm supports rather than guessing from a menu.

Microsoft's Excel link page is the other gap. It shows Windows screenshots from Excel 2016 and gives no Mac steps. That is why this page marks the ⌘K shortcut as unconfirmed. Test it once on your own copy before you write it into a team guide.

> **One example, not a standard:** The tickmark set in this page comes from a 2026 practitioner guide, and that guide says firms use different standard sets. Replace these codes with your firm's list before you share the file.

## Keep client data inside your firm's rules

A legend holds no client data, but the workpapers around it do. They carry client names, balances and bank details. Follow your employer's rules on client data before you paste, screenshot or describe any of it to an AI tool.

If you use Lazur, know what leaves the Mac. Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models.

> **Ask first, then hold the key:** If your firm does not allow client files in outside AI tools, do not hold the shortcut over client workpapers. Build the legend from the rules on this page and keep client content out of any prompt.

![Spreadsheet rows on a computer screen for audit tickmarks in Excel workpapers](https://images.lazur.app/content-images/problem/audit-tickmarks-excel-cross-reference/audit-tickmarks-in-excel-workpapers-3-088043.jpg)

## Where Lazur helps and where it stops

Lazur is a voice assistant for the Mac. Hold ⌥⌘ to ask about anything on screen. Ask where something is, and Lazur draws a circle and a label around it. Ask how to do something, and Lazur guides you one click at a time, waiting for each click.

It does not click buttons, edit files or operate other apps for you. Use it to find the Data Validation button, check what a mark means, or walk through a menu path. You still make each change in the file yourself.

Hold fn to dictate clean text at the cursor in any app. A personal dictionary can hold IPE and AN, so dictation spells your codes the way your legend does. Snippets can store the exception sentence you reuse on every file.

## Next steps for your next engagement file

Build the Index tab on your next file, then run the break check before the reviewer sees it. For broader Excel habits on Mac, read [Excel for accountants on Mac](https://www.lazur.app/for/accountants/excel). When you want the voice side, the [download page](https://www.lazur.app/download) has the Mac app. The Pro trial is three days, needs no credit card, and starts when you first open the app.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where is the tickmark legend on this sheet?”: Lazur draws a circle and a label around the legend block on screen, so you can find it at once. (Points at it)
- “Where is the tickmark legend on this sheet?”: Lazur draws a circle and a label around the legend block, so you find it without scrolling through every tab.
- “What does this tickmark mean on the bank row?”: Lazur reads the marks on screen and answers out loud, so you can check a row without leaving the file.
- “Walk me through adding a Data Validation list.”: Lazur guides you one click at a time and waits for each click. It does not make the click for you.
- “Hold fn and dictate the exception note for this row.”: Dictation types clean text at the cursor in any app. A personal dictionary can hold IPE and AN, so they are spelled correctly.
- “Draft a one-line legend entry for the AN mark.”: Lazur drafts the sentence for you to read and place in the legend. You decide what goes into the file.
- “Remind me to run the break check before sign-off.”: Lazur adds an Apple Reminders item by voice, so the check is on your list before sign-off.

## A plan you can start this week

- **Day 1: Define the codes.** Open the Index tab. Write the code list in column A and the meaning in column B. Keep codes to letters. Name the code range Codes, so a validation list can read it. Stop when every mark used so far has a line.
- **Day 2: Set up validation and links.** Apply a List validation to the mark column, with Codes as the source. Add a cross-reference beside each mark, with the workpaper number as text and a link where it helps the reviewer.
- **Day 3: Trace one balance end to end.** Pick one balance, such as cash. Follow its mark, its reference and any exception entry across the file. Fix each step where a reviewer would have to guess what you meant.
- **Day 4: Run the break check.** Add a count formula for unknown codes. Search the workbook for each code to find stale ones. Follow each link once from a clean copy, then write the date of the check on the index.
- **Day 5: Agree the legend with the reviewer.** Send the Index tab to the reviewer before the busy weeks start. Ask them to challenge any mark they cannot decode. Update the legend, then keep that convention for the next file.

## FAQ

### Should I use symbols or letters for tickmarks in Excel on Mac?

Use letters or short codes such as T, F, C or AN. They type fast, search cleanly and do not depend on a font. If your firm uses symbols, press ⌃⌘Space to open the Character Viewer, then test the file on a second computer.

### Does Excel stop me from typing a code that is not in the legend?

Only for entries made after you set up Data Validation with a List source. Existing cells keep whatever they hold, and pasted values can overwrite the rule. Run a count check across the mark column before sign-off.

### Can a cell comment replace a legend?

No. A comment explains one cell and can be easy to miss when a file is printed or exported. Keep the meaning of each mark on the index page, and use a comment only as a short note.

### Is there one standard tickmark set I should copy?

No. The guide behind this page calls its list an example, not a standard, and firms use different sets. Start from your firm's own list. If it has none, write one and keep it on the index sheet.

### Does Caseware Working Papers run on a Mac?

Not according to Caseware's own requirements page. It lists Windows 10 and Windows 11 (64-bit), and it does not list macOS or ARM. Check the current page, or ask your IT team what your firm supports.

### Will Lazur write the legend or the links into my file?

No. Lazur points at things, explains what is on screen, guides you one click at a time and drafts text. It does not click buttons or edit your file, so you do the building yourself.

### Does Lazur send my client workbook to an AI service?

Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Follow your employer's rules on client data before you hold the shortcut over client work.

## Sources

1. [Busy season 2026: Trends in workload, stress & support across public accounting](https://www.distinctrecruitment.com/us/resources/blog/busy-season-2026-trends-in-workload-stress-support-across-public-accounting/), Distinct Recruitment, checked 2026-11-08
2. [Accountants and Auditors: Occupational Outlook Handbook](https://www.bls.gov/ooh/business-and-financial/accountants-and-auditors.htm), U.S. Bureau of Labor Statistics, checked 2026-11-08
3. [Audit Tick Marks That Mean Something: A Standard Set With Usage Examples](https://internalauditguide.com/2026/09/audit-tick-marks/), internalauditguide.com, checked 2026-11-08
4. [System requirements – Working Papers](https://www.caseware.com/docs/en/desktop/working-papers/setup/installation/system-requirements), Caseware International, checked 2026-11-08
5. [Work with links in Excel](https://support.microsoft.com/en-us/excel/work-with-links-in-excel), Microsoft Support, checked 2026-11-08