Numbers for accountants on Mac: client trackers, formulas and filters in Numbers 15.4

Most accountants on a Mac use Numbers for a short list of jobs. They keep client trackers, log income and expenses, build budgets and draft invoices. Some also keep simple balance sheets for small clients. The work is mostly tables, totals and filters, and Numbers handles those well. The harder questions are about version, Excel compatibility and file size.

Check your Numbers version before you follow any guide

Apple changed how Numbers gets new features, so the version on your Mac matters more than it used to. On January 28, 2026, the older Numbers app was updated to version 14.5. That update said it will no longer receive new features of any kind. New features now arrive only in Apple Creator Studio, which ships as Numbers 15.1, according to MacRumors.

Check the version before you trust a feature list. Numbers 14.4 added more than 30 functions, including LET, LAMBDA, FILTER, SORT and UNIQUE. It also brought better Excel import and export compatibility. Numbers 15.4 added trigonometry, statistics and logic functions, such as PEARSON and XOR. A copy older than 14.4 will not have FILTER at all.

Creator Studio costs $12.99 per month or $129 per year in the US, according to MacRumors. Premium templates, Content Hub and AI image tools sit inside that subscription. If your current copy opens your files and runs your formulas, you do not need to switch just to get the basics. Check Apple's site for current prices before you buy.

Start from a template, not a blank sheet

Apple's guide says it plainly: all spreadsheets begin with a template. Pick the template closest to your job, then change the columns to match your clients. Starting blank adds work you do not need, especially for tracking that repeats every month.

To keep your own layout, choose File > Save as Template. To install a template someone sent you, double-click the .nmbtemplate file and choose Add to Template Chooser. Custom templates appear under My Templates and sync through iCloud Drive if you have it turned on.

Two limits matter. You cannot delete templates that came with Numbers. You also cannot rearrange custom templates. Give each saved template a clear name, since you cannot sort them into your own order.

Free accounting templates from third parties are easy to find. I did not check their quality or their accounting accuracy. Before you use one with client data, enter a small set of figures whose totals you already know. Then compare the output with those totals.

• Save one template for each client type, such as sole traders and small companies.
• Keep an unedited copy of every template you download.
• Test each formula on known figures before the first real client file.
• Name custom templates by job, so you can find them quickly in My Templates.

Build a client tracker with sheets, tables and header rows

A client tracker works best as one sheet per client or per year, with a table on each sheet. Each sheet gets its own tab. Since Numbers 15.3 you can hide or show individual sheets and color the sheet tabs. Use colors to flag clients who are still waiting on documents.

Tables have limits you should know. Apple's guide says a table can have up to five header rows and five header columns. Footer rows are capped at five. Apple gives no overall cap on body rows or columns, so test a large file before you rely on it.

Header rows matter for filters and sorting. Mark the top row with column names as a header, so the names stay visible as you scroll. Read how to add header rows in Numbers for the Format sidebar steps. The table basics page covers styles and resizing.

Here is a layout that works for document tracking. Columns are Date, Client, Document, Status and Amount. Status is a drop-down with a short list of values, such as Waiting and Received. Each row is one document, so a client update changes one cell. You can set that up with a drop-down list in Numbers.

A common mistake is to type a running total under the data in the same table. A later filter can hide that total or count it twice. Put totals in a footer row or in a separate area of the sheet, where a filter cannot touch them.

Formulas accountants use most in Numbers

Numbers ships with hundreds of built-in functions, according to Apple's support page. The basics are SUM and AVERAGE, which Apple's guide uses as its formula examples. Use SUM for totals and AVERAGE for a typical amount across a period. Add IF when a row needs a flag, such as Waiting or Received.

Newer functions help with long lists. LET names an intermediate value, so a long formula stays readable. FILTER returns only the rows that match a rule. SORT puts results in order. UNIQUE removes repeats from a list of client names. These arrived in Numbers 14.4.

Statistics functions arrived in Numbers 15.4. PEARSON measures how closely two series move together. XOR returns true when exactly one of two conditions holds. Most client work will not need them, but a reviewer may ask how a figure was built.

Check each formula against a number you can prove by hand. Pick one result, trace it back to a source document and confirm the figure. A wrong formula copies its error into every row that uses it.

• Choose one total and trace it to a receipt, invoice or bank line.
• Look for text that looks like a figure, since Numbers may treat it differently from a real number.
• Check negative amounts that were entered as positive values.
• Recalculate after any import, then check the result again.

Filters, categories and pivot tables for summaries

Filters show only the rows you need, such as one client or one quarter. Read how to filter table rows in Numbers for the steps. Categories summarize a table by group, which suits expense totals by type.

Pivot tables arrived with Numbers 11.2. Apple's What's new page lists them in its feature history. A pivot table reads your table and builds a grouped summary. It does not change the source rows, so you can rebuild it after you fix the data.

A third-party article says pivot work in Numbers will probably be frustrating. It cites no test, dataset or source for that claim, so treat it as an opinion. Build a small pivot table from a copy of your real data, then judge it yourself.

Charts come after the summary. Apple's guide covers 2D and 3D charts. For client reports, a plain 2D bar chart is usually easier to read than a 3D one.

Excel files: import, export and formula breaks

Numbers can open Excel files and export back to Excel, CSV and PDF, according to Apple's support page. Apple's What's new page says Numbers 14.4 improved Excel import and export compatibility. Better compatibility is not the same as perfect compatibility.

Imports are where things break. A 2023 Apple Community thread describes a SUM(IF) array formula that failed on import. Numbers replaced it with the last calculated value, and the user saw a message saying the array formula could not be imported. The cell then held a fixed value, so it would not update.

Use this order for any Excel file that feeds client work. Open the file. Check every array formula against the original. Fix or rebuild the ones that failed. Export only after those checks pass. Keep the original Excel file as the reference. You can read how to open an Excel file in Numbers and how to export to Excel from Numbers for the steps.

A PDF is a snapshot. Use it for the copy the client receives, and keep the Numbers file for edits. The PDF export guide covers the steps.

Mistakes that cost accountants time in Numbers

Deleting rows is the first trap. Normally a row can only be deleted when its cells are empty. To delete rows and columns that hold data, you must Option-drag the Add or Remove Rows and Columns handle, as Apple's guide describes. Make a copy of the file before you do it.

The second trap is file size. A Spreadsheeto article says Numbers either slows down significantly or crashes with large data sets. The article does not show a test or name a source for that claim. Test with a copy of your largest client file on your own Mac.

The same article gives a limit of 65,535 rows by 256 columns per table. Apple's pages I opened do not state an overall cap, so treat that figure as unverified. Your own test will tell you more than either source.

The third trap is version drift. A colleague may send a file built in a newer copy of Numbers. Your older copy may lack the function, and the cell can show an error or a stored value. Ask which version they use before you start.

Sharing files with clients and staff

Numbers supports real-time collaboration, according to Apple's guide. Apple's support page also lists Numbers for iCloud for editing in a browser. Use the sharing options to invite people or send a link. The share a spreadsheet guide covers both paths.

Apple marks a 4GB collaboration file limit as a Creator Studio feature. If your shared file is large, check which edition your team uses before you plan a shared project.

Client files often hold tax numbers and bank details. Share only with people who need them. Check the access list each time you send a new link, and remove anyone who no longer works on the file.

Where Lazur fits while you work in Numbers

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ to ask about anything on screen, and Lazur answers out loud. It does not click buttons or edit your file. You make every change in Numbers yourself.

Use it in these ways. 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. Ask why a formula failed, and Lazur reads the screen and explains it out loud.

Hold fn to dictate clean, formatted text at the cursor in any app. That helps when you write a note beside a client row or draft a cover message. Dictation is included, and it is not the headline feature. Snippets, a personal dictionary and clipboard slots help with wording you repeat.

Lazur keeps a memory of what you asked and did, on your Mac. It 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.

Lazur is not a plugin or add-in for Numbers or any other app. It has no partnerships with app makers. See the pricing page for plans and the free trial, and the download page for the Mac app.

A checklist before you send a Numbers file to a client

1. Confirm the Numbers version your client uses, and check that each function exists in it.
2. Check every array formula that came from Excel against the original file.
3. Trace one total to a receipt, invoice or bank line you can verify by hand.
4. Check hidden sheets, since Numbers 15.3 can hide them from view.
5. Send a PDF copy when the client needs a fixed version, and keep the Numbers file for edits.
6. Review the sharing list, and remove anyone who no longer needs the link.

Next steps for your Numbers setup

Start with one client tracker built from a template. Add the formulas you use most, then add filters. Test every imported Excel formula against the original file. Once that works, try a pivot table on a copy. When you want the steps for a formula, read how to add a formula in Numbers.