Cellwise Hire · Finance and accounting preset
Excel test for auditors
Candidates re-perform the numbers an auditor checks: due dates and an aging from an invoice list, balances open at a date, invoices inside a period, and the oldest unpaid item. Then they review a workbook someone else built and fix its errors. Every answer is checked by what it calculates, on the sheet they see and on hidden versions of it.
Create a free auditor testSee a sample task
Free for your first 3 candidates. The Finance and accounting preset is preselected for you.
The test at a glance
- Workbooks
- Invoices + Rep bonus sheet
- Tasks
- 8 hands-on tasks at the level you pick
- Levels
- Basic, Intermediate or Advanced
- Time
- You choose; 20 to 40 minutes suits most
- Grading
- By result, on the visible sheet and 2 hidden versions
Good for: External audit associates and seniors, Internal auditors, Audit and assurance interns, Controls and compliance analysts who test spreadsheets.
What auditors actually do in Excel
Auditors rarely build the numbers. They recompute them. A receivables balance arrives with an aging someone else prepared; the auditor rebuilds it from the invoice list, checks what was still open at the test date, counts what was issued inside the period and asks about the oldest items still unpaid.
The other half is reading spreadsheets other people built. A total that stops one row short, a rate typed into a formula, a lookup without an exact match: the errors that matter are the ones that still return a believable number.
- Re-performing due dates and an aging from raw invoice data
- Balances open at a date in a cell, so changing the test date is a one-cell change
- Counting transactions inside a period with a start and an end date
- Finding the oldest open item and the average days paid invoices took
- Checking totals and finding broken formulas in a workbook someone else built
What the test checks
The Finance and accounting preset uses two workbooks: Invoices (invoices sent to clients, with the date issued, payment terms in days, the amount and the date it was paid (blank if not yet)) and Rep bonus sheet (a quarterly sales and bonus sheet a colleague built. Several of its formulas are broken: find what is wrong and fix them). Here is what that covers for auditors, with the real task names and the level each one appears at.
Re-performing an aging
Due dates from the issue date plus terms, days past due as of the date in a cell (0 for paid invoices and for invoices not yet due), and each invoice in Paid, Current, 1-30, 31-60 or 60+. The full aging appears at the Advanced level.
- Due datesBasic
- Days overdueIntermediate
- Aging bucketsAdvanced
Balances at a date
Open invoices counted with a blank Paid on cell treated as unpaid, the amount past due as of a date, one client's open balance with the client in a cell, and the unpaid total more than 30 days past due.
- Unpaid invoicesBasic
- Amount overdueIntermediate
- Owed by one clientIntermediate
- Badly overdue totalAdvanced
Period cutoff
Invoices issued inside one month, which needs a start date and an end date. A single ">=" criterion also picks up the following month, the kind of cutoff error an auditor is there to catch.
- Issued in OctoberIntermediate
Oldest items and days to pay
The invoice number of the oldest unpaid invoice (the earliest issue date among open items, not the oldest invoice overall) and the average days to pay over paid invoices only. Advanced level.
- Oldest unpaid invoiceAdvanced
- Average days to payAdvanced
Reviewing a workbook someone else built
The second workbook is a quarterly sales and bonus sheet with broken formulas: a total that misses the last row, an average divided by a fixed 10, a VLOOKUP without an exact match that returns the wrong manager, a threshold typed into a formula, a MATCH without its match type, and a COUNTIF that tries to compare two columns and returns 0.
- Fix the totalBasic
- Fix the averageBasic
- Fix the manager lookupIntermediate
- Make the count follow K2Intermediate
- Fix the top repAdvanced
- Fix the target countAdvanced
Every task in this test, by level
| Level | Invoices | Rep bonus sheet |
|---|---|---|
| Basic | Due dates Paid or unpaid Total billed Unpaid invoices | Fix the bonus column Fix the total Fix "Hit target?" Fix the average |
| Intermediate | Days overdue Amount overdue Owed by one client Issued in October | Fix the manager lookup Fix the East total Fix the #DIV/0! errors Make the count follow K2 |
| Advanced | Aging buckets Badly overdue total Oldest unpaid invoice Average days to pay | Use the rate table Fix the top rep Fix the target count Fix the average |
Each test uses one level: four tasks from each workbook.
Which level to choose
- Basic · 20 minutes suggestedAudit interns and first-year associates: due dates, open items, totals and counts, and four everyday formula fixes such as a total that stops a row short.
- Intermediate · 30 minutes suggestedAudit associates and internal auditors: days past due and the amount overdue at a date, one client's balance, period cutoff, and lookup and #DIV/0! fixes.
- Advanced · 40 minutes suggestedAudit seniors and internal audit leads: a full aging, the oldest open item, average days to pay, and silent bugs such as a MATCH without its match type.
A real task from this test
This is one of the tasks in the Finance and accounting preset at the Intermediate level, on the sheet candidates see. The answers below were run through the same grader that marks real tests: on this sheet, and on two hidden versions with different data and an extra row inserted.
Sample task · Invoices · Intermediate
Issued in October (in K6). Count the invoices whose issue date falls inside October 2026, from the first of the month to the last.
| Row | A | B | C | D | E | F | G | H | I | J | K |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Invoice | Client | Issued | Terms (days) | Amount | Paid on | Due date | Days overdue | As of | Nov 15, 2026 | |
| 2 | INV-1041 | Harbor Dental | Sep 8, 2026 | 30 | $1,250.00 | Oct 2, 2026 | Oct 8, 2026 | Client | Harbor Dental | ||
| 3 | INV-1042 | Kline & Rowe | Sep 15, 2026 | 45 | $3,400.00 | Oct 30, 2026 | |||||
| 4 | INV-1043 | Bluebird Cafe | Sep 22, 2026 | 14 | $480.00 | Oct 1, 2026 | Oct 6, 2026 | Amount overdue | |||
| 5 | INV-1044 | Harbor Dental | Oct 1, 2026 | 30 | $1,250.00 | Oct 31, 2026 | Unpaid, client in K2 | ||||
| 6 | INV-1045 | Northgate Gym | Oct 6, 2026 | 30 | $2,150.00 | Nov 10, 2026 | Nov 5, 2026 | Invoices issued in October 2026 | |||
| 7 | INV-1046 | Kline & Rowe | Oct 13, 2026 | 45 | $2,900.00 | Nov 27, 2026 | |||||
| 8 | INV-1047 | Bluebird Cafe | Oct 20, 2026 | 14 | $515.00 | Nov 3, 2026 | |||||
| 9 | INV-1048 | Oak Street Vet | Oct 27, 2026 | 30 | $1,780.00 | Nov 3, 2026 | Nov 26, 2026 | ||||
| 10 | INV-1049 | Northgate Gym | Nov 2, 2026 | 30 | $2,150.00 | Dec 2, 2026 | |||||
| 11 | INV-1050 | Oak Street Vet | Nov 9, 2026 | 30 | $960.00 | Dec 9, 2026 |
| Formula in K6 | Sheet they see | Hidden checks | Result |
|---|---|---|---|
=COUNTIFS(C2:C11,">="&DATE(2026,10,1),C2:C11,"<"&DATE(2026,11,1))Both ends of the period | 5 right | Right on both | Solved |
=SUMPRODUCT((MONTH(C2:C11)=10)*(YEAR(C2:C11)=2026))Month and year checked together | 5 right | Right on both | Solved |
=COUNTIF(C2:C11,">="&DATE(2026,10,1))Only a start date | 7 wrong | Not needed: already wrong | Not solved |
=5The count typed in | 5 right | Wrong on new numbers | Not solvedRight on the visible data only |
=COUNTIF(C2:C11,">="&DATE(2026,10,1))It counts every invoice from October 1 onward, so November's invoices land in October. That is a cutoff error, and the formula looks reasonable enough to survive a quick review.=5Right on the sheet the candidate sees, because it was counted by eye. The hidden version has different invoices, so it fails there.
Grading is by result, so COUNTIFS with "<="&DATE(2026,10,31) as the end passes too. The hidden version has different invoices and a different mix of months, so only a formula that applies both ends of the period passes.
Results calculated by the Cellwise formula engine. The hidden versions stay on our server, so this page shows only whether each answer passed them.
See the screen your auditor candidates work in: try a 3-minute sample test and read the report you would get. No signup.
What the report shows
When a candidate finishes, you get an overall score and every task: solved or not, the exact formula they wrote, the time spent and the number of tries, plain-English notes, and a replay of every edit with the sheet as it looked at each step. For auditors, two things are worth a look:
- Open the cutoff and overdue tasks first. The formula shows whether the candidate set both ends of the period and compared due dates with the as-of date, or simply counted everything after a start date.
- On the second workbook, the quality notes (a number typed into a formula instead of pointing to its cell, a formula that breaks when a row is inserted) read like the findings an auditor writes about a spreadsheet. See whether the candidate fixed the cause or only the visible number.
You can also add 8 multiple-choice knowledge questions at the same level, scored separately. Candidates never see their score.
What this test does not cover
- Sampling, vouching to source documents, bank reconciliations and auditing standards are not in this test, and nor is audit or data-analytics software. For sample selection, our guide to picking a random sample without duplicates has a worked example to use in an interview.
- The invoice workbook is a receivables list. The same Finance and accounting preset powers the Excel test for bookkeepers, described from the bookkeeper's side.
Pricing
Free for your first 3 candidates, no card needed. Then Starter is $79 a month or $790 a year for 25 completed candidates a month, and Agency is $199 a month or $1,990 a year for unlimited candidates. Only candidates who complete a test count.
Founding price: locked for as long as you stay subscribed (first 10 customers)
FAQ
What Excel skills does an auditor need?
Re-performing calculations: SUMIFS and COUNTIFS with date bounds for cutoff and balances at a date, date arithmetic for due dates and days past due, nested IF or IFS for an aging, exact-match lookups to tie one list to another, and reading formulas well enough to spot a range that stops short, a typed-in number or a lookup without an exact match.
Which level should I choose for audit associates?
Basic suits interns and first-year associates. Intermediate suits most associates and internal auditors, and includes the cutoff and balance-at-a-date tasks. Choose Advanced for seniors, because the aging, oldest open item and days-to-pay tasks only appear at that level.
Does the test include audit sampling or analytics software?
No. It is plain Excel formulas on two small workbooks. If sampling matters for the role, ask the candidate to draw a random sample in the interview.
How long should an auditor Excel test take?
Each test has 8 tasks across two workbooks. We suggest 20 minutes for Basic, 30 for Intermediate and 40 for Advanced, plus about 8 minutes if you add the optional knowledge-check questions. You can set anything from 5 to 120 minutes.
Is it fair to give audit candidates an Excel test?
A short test that reflects the real work is a common part of hiring. Give every candidate the same test and time, follow local hiring law, and keep tests job-related.
Related
Looking to learn Excel yourself? Start the free Cellwise course.