Excel for bookkeepers on Mac: reconciliations, month close and voice help in Microsoft 365

What bookkeepers do in Excel on a Mac

Most bookkeepers treat Excel as a workbench, not a ledger. The accounting system holds the books. Excel holds the messy work around them. In a February 2026 survey of 261 mostly small U.S. and Canadian bookkeeping and accounting firms, 71% said they use spreadsheets, Excel and Google Sheets combined, to track work, clients, or processes.

On a Mac, five jobs come up again and again:

• Bank reconciliation, matching each bank line to a ledger entry.
• Month-end close, the checklist that must finish before the books are final.
• Invoice and bill logs, tracking what is open, paid, or late.
• Client trackers, one row per client with deadlines and document status.
• Cleanup of exports, fixing dates, spaces, and duplicate rows before anything else works.

Check your Excel build before you follow any steps

Menu names and features change with each Microsoft build. The latest Excel for Mac build in Microsoft's release notes is 16.114.3, dated October 27, 2026. The entries from mid-October list quality fixes and security updates only, with no menu changes.

To check yours, open Excel > About Excel. If you are behind, run Help > Check for Updates and restart Excel when it finishes.

The build before that, 16.113, dated September 16, 2026, added chat history to Copilot in Excel. On Mac, that history opens from the menu icon in the upper left of the Copilot pane.

Bank reconciliation in Excel for Mac, step by step

Reconciliation is the job bookkeepers most often do by hand. A 2016 study by Robert Half and the Financial Executives Research Foundation, as cited by Centage, found 52% of responding U.S. companies still reconcile accounts manually. The same study put the average month-end close at 8 days.

Centage does not link the original report or list a sample size, so treat both figures as a rough signal. They are not a benchmark for your clients. Start with one bank account and these steps.

1. Export the bank statement as a CSV. Export the ledger as a second CSV. Open each in its own tab.
2. Select the bank data and go to Insert > Table. Name it tblBank in the Table Design tab. Microsoft's October 2026 update says naming tables as you create them is generally available on Mac.
3. Repeat for the ledger and name it tblLedger.
4. In the first empty column of tblBank, add a Matched column. Enter =COUNTIFS(tblLedger[Date],[@Date],tblLedger[Amount],[@Amount]). A result of zero means no ledger row matches that date and amount.
5. Above the tables, add a Difference cell. Enter =ROUND(SUM(tblBank[Amount])-SUM(tblLedger[Amount]),2). Rounding stops tiny floating-point differences from showing up.
6. Filter Matched for zero. Those rows are your open items. Work them from the largest amount down.

Say the bank total is one cent away from the ledger. The usual cause is one row on one side only, a fee posted on one side, or a payment dated on the other side of the month end. Filter the unmatched rows and read them against the statement. The answer is usually in those rows.

Use the same table names every month. Formulas keep working when you paste next month's export into the table. Named tables also make formulas readable, such as tblLedger[Amount], and a reviewer can follow them without a guide.

Cleaning exports before you match anything

Most failed reconciliations start with the data, not the formula. Exports from bank portals and older accounting tools often store dates as text, leave stray spaces, and repeat rows when someone downloads the same range twice.

• Trim spaces with =TRIM(A2) in a helper column. Paste values back over the original column.
• Turn text dates into real dates with Data > Text to Columns, or with =DATEVALUE(A2) for simple formats.
• Find numbers stored as text with =ISNUMBER(B2). FALSE means the cell only looks like a number.
• Remove exact duplicates with Data > Remove Duplicates. Check the columns you select before you confirm.

Duplicates need care. Two real payments of the same amount on the same day look identical in an export. Remove a row only when every column matches, and write the count in your close notes.

Spreadsheet errors are common. A 2024 literature review in Frontiers of Computer Science reported that 94% of spreadsheets used in business decision-making contain errors, as covered by Phys.org. The review summarizes earlier studies of business spreadsheets, not bookkeeping files. Still, it is a reason to check totals twice.

Power Query on Mac has fewer connectors than Windows

Power Query is the tool for imports you repeat every month. On Mac, open Data > Get Data. Microsoft's support table lists the Mac sources: Text & CSV, Excel workbook, XML, JSON, SharePoint List, OData feed, and a blank query.

Windows supports a much longer list, including Access, Oracle, IBM Db2, MySQL, PostgreSQL, SAP HANA, Salesforce, ODBC, and OLEDB. Most of those do not appear in Microsoft's Mac table. Check the table before you plan a workflow.

For most bookkeepers, a CSV export is the reliable path on Mac. Keep the export folder in one fixed place. A query breaks when its source file moves or gets renamed.

Month-end close with a checklist tab

The close is where spreadsheets tend to fail. In the Financial Cents survey, 28% of firms managed month-end close with spreadsheets they maintained by hand. Another 20% kept a checklist in a document or notes app. Neither option gives you an owner or a date by default.

Build a close tab with four columns: Task, Owner, Status, and Done on. Add one row for each task, such as bank reconciliation, accounts receivable aging, accrual review, and the payroll journal.

Add Data > Data Validation with a list for Status, such as Not started, In progress, and Done. That keeps the words consistent, so a filter on Done returns the right rows.

Give each review step its own row with a name and a date. Unowned tabs are easy to miss at the end of a long close.

Free accounting templates for Excel on Mac

Microsoft publishes free accounting templates. Its page lists 30 templates. They include Monthly bank reconciliation, Check register ledger, Check register with spending summary, Petty cash log, Balance sheet, Profit and loss statement, Statement of account, Finance charge invoice, and Fixed asset record with depreciation.

The list also includes non-accounting designs and several invoice layouts. Read the names before you pick one. The template links point to a web viewer, which suggests they open in Excel for the web. The page does not say that, so check the title bar after you open one.

Treat a template as a starting layout. Your chart of accounts and bank export will not match the sample. Rename the columns to fit your ledger before you build formulas on top of them.

Shortcuts that save time on a Mac

• ⌘ Z undoes your last change. Press it again to go back further.
• ⌘ F opens Find, which helps when a client name sits on several tabs.
• ⌃ ⌘ V opens Paste Special, so you can paste values without formulas or formats.
• ⌘ ⇧ ↓ extends the selection to the last filled row, which speeds up checks on long ledgers.

Lazur can tell you a shortcut out loud. Ask what a key does while your hands stay on the keyboard.

Where bookkeepers lose time, and what the numbers do not say

The largest group of Financial Cents respondents, 39%, re-enter information between tools a few times a week. Another 20% do it several times a day. Add the firms that re-enter data once a day, and the total is 67%.

Financial Cents says 70% re-enter data at least a few times a week. Its own breakdown adds to 67, so this page uses 67. The sample is small and mostly U.S. and Canadian, so read the figure as a signal, not a rule.

Intuit's 2024 survey of U.S. small businesses with 10 to 99 employees reported 25 hours a week spent on manual data entry or reconciling data. That group is owners and executives, not bookkeepers. It shows the scale of the problem, not your own hours.

Mistakes bookkeepers make in Excel on Mac

• Hardcoded totals. A typed number in a total row stops updating when rows change.
• Ranges that stop short. =SUM(A2:A40) misses row 41 after the export grows.
• Dates in two formats. Day and month can swap in some exports, so an item lands in the wrong month.
• Pasting over formulas. Use Paste Special to paste values only when you mean it.
• Matching on amount alone. Two bills with the same amount can match by mistake, so add a date or a reference.

Each fix above takes little time once you know it exists. Keep this list in your close checklist and tick it off each month.

How Lazur helps in Excel without touching your file

Lazur is a voice assistant for the Mac. It lives in the notch. Hold ⌥ ⌘, which is Option and Command together, to ask about anything on screen. Lazur answers out loud. Ask where a cell 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. It waits for each click before it gives the next step. You do every click. Lazur does not click buttons, edit files, or operate other apps for you.

Hold fn to dictate clean, formatted text at the cursor in any app. That helps when a reconciliation note needs a full sentence. Snippets, a personal dictionary, and clipboard slots are also included.

Privacy works the same in Excel as in other apps. Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer and are not stored. Content is never used to train AI models.

Asking Lazur good questions in Excel

Short, specific questions get faster answers. Name the tab, the column, or the cell. Compare 'where is the difference cell' with 'help me with this sheet.' The first gives Lazur a target. The second gives it nothing to point at.

What Lazur does not do in Excel

• It does not click buttons, edit cells, or change formulas for you.
• It is not a plugin or add-in for Excel or any other app.
• It does not watch your screen unless you hold the shortcut.
• It runs on macOS, on Apple silicon and Intel Macs. Windows is planned, not available.
• It does not check your numbers. You still review every total and formula before a close is posted.

Next steps for your Mac

If most of your work is reconciliation, start with the table setup and the Difference cell. Test the setup on last month's file, not the live close. Once it works, add the close tab and the cleanup steps.

For role-specific help, read Excel help for accountants on Mac or Excel for accountants on Mac. For month-end summaries, see how to make a pivot table in Excel on Mac. To try the voice helper, download Lazur and start the free trial. Pricing details are on the pricing page.