Cellwise Hire · Finance and accounting preset
Excel test for bookkeepers
Candidates work in a real invoice list: due dates from payment terms, what is unpaid, what is overdue as of a date, balances by client and aging buckets. Then they fix a colleague's broken workbook. Every answer is checked by what it calculates, on the sheet they see and on hidden versions of it.
Create a free bookkeeper 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: Bookkeepers, Accounts receivable and payable clerks, Accounting assistants, Office managers who keep the books.
What bookkeepers actually do in Excel
The accounting software holds the ledger. Excel is where a bookkeeper checks it. They export open invoices to see who owes what, work out which bills are past due as of month-end, total a client's balance before a call, and explain a number to an owner who asks "why is this so high?".
They also inherit spreadsheets. Last year's bonus sheet, a predecessor's commission calculator, a client's own tracker. A good bookkeeper spots the total that stops one row short before it goes into a report.
- Due dates and status from an invoice export, filled down a whole column
- Unpaid and overdue totals as of a date in a cell, so month-end is a one-cell change
- Balances by client and by month with SUMIFS and COUNTIFS
- Aging buckets (Current, 1-30, 31-60, 60+) and average days to pay
- Reading someone else's formulas and fixing them without breaking the rest
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 bookkeepers, with the real task names and the level each one appears at.
Due dates and paid status
An issue date plus terms in days, and a status from whether the Paid on cell is blank. Simple, but the formula has to fill down ten rows correctly, and blank cells have to be treated as unpaid rather than as zero.
- Due datesBasic
- Paid or unpaidBasic
- Unpaid invoicesBasic
Overdue as of a date
Days past due and the amount overdue, measured against an as-of date in a cell rather than TODAY(). Paid invoices and invoices not yet due must not count. This is where a candidate shows whether they think like a bookkeeper.
- Days overdueIntermediate
- Amount overdueIntermediate
- Badly overdue totalAdvanced
Balances by client and period
What one client still owes, with the client name typed in a cell, and how many invoices went out in a month. Criteria in cells and date ranges with ">="&DATE(...) are the skills being checked.
- Total billedBasic
- Owed by one clientIntermediate
- Issued in OctoberIntermediate
Aging and days to pay
Each invoice in an aging bucket, the oldest unpaid invoice, and the average days paid invoices took. These appear at the Advanced level only.
- Aging bucketsAdvanced
- Oldest unpaid invoiceAdvanced
- Average days to payAdvanced
Fixing an inherited workbook
The second workbook is a quarterly sales and bonus sheet someone else built, with broken formulas: a total that misses the last row, a rate that is not locked with $, SUMIF arguments in the wrong order, #DIV/0! on new rows, and rates typed into a formula instead of read from a table.
- Fix the totalBasic
- Fix the bonus columnBasic
- Fix the East totalIntermediate
- Fix the #DIV/0! errorsIntermediate
- Use the rate tableAdvanced
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 suggestedAP or AR clerks and accounting assistants: due dates, status, totals and counts, plus four everyday formula fixes.
- Intermediate · 30 minutes suggestedFull-charge bookkeepers: overdue amounts as of a date, balances by client, invoices by month, #DIV/0! and lookup fixes.
- Advanced · 40 minutes suggestedSenior bookkeepers who own month-end: aging buckets, oldest unpaid invoice, average days to pay, and subtle formula bugs.
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
Amount overdue (in K4). Total the unpaid invoices that were already past their due date on the as-of date in K1. Column G holds each due date; a blank Paid on cell means unpaid.
| 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 K4 | Sheet they see | Hidden checks | Result |
|---|---|---|---|
=SUMIFS(E2:E11,F2:F11,"",G2:G11,"<"&K1)SUMIFS with the date criterion joined to K1 | $5,165.00 right | Right on both | Solved |
=SUMIF(F2:F11,"",E2:E11)Every unpaid invoice | $11,175.00 wrong | Not needed: already wrong | Not solved |
=SUMIFS(E2:E11,F2:F11,"",G2:G11,"<K1")The cell reference inside the quotes | $0.00 wrong | Not needed: already wrong | Not solved |
=SUMIF(F2:F11,"",E2:E11)It totals invoices that are unpaid but not due yet. That is the "how much is outstanding" number, not the overdue one, and mixing the two up in a collections email is a real problem.=SUMIFS(E2:E11,F2:F11,"",G2:G11,"<K1")Inside quotes, K1 is just the letters K and 1, so nothing matches and the total is 0. The fix is "<"&K1. It is an easy SUMIFS mistake to make.
Point at the as-of date instead of typing it, and next month's report is a one-cell change. The hidden versions use a different as-of date and different invoices, so only a formula that really reads K1 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 bookkeeper 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 bookkeepers, two things are worth a look:
- Open the overdue tasks first. The formula shows straight away whether they compared due dates with the as-of date, or just totaled everything unpaid.
- On the fix-it workbook, the replay shows whether they found the bug by reading the formula or rewrote the whole column by trial and error. Both can end in the right answer; you can see which happened.
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
- Bank reconciliation, matching two lists and rounding pennies are not in this test. Our guide to the Excel test for accounting roles has those tasks with checked answers, to use in an interview.
- It does not test accounting software, journal entries or accounting knowledge. It tests the Excel work around them.
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 a bookkeeper need?
The everyday ones are SUMIFS and COUNTIFS for totals by client, date and status, date arithmetic for due dates and days overdue, IF for status and aging, a lookup such as XLOOKUP or VLOOKUP with an exact match, and the habit of pointing formulas at cells (an as-of date, a client name) instead of typing values in. Reading and fixing other people's formulas matters as much as writing new ones.
Which level should I choose for a bookkeeper?
Basic suits AP and AR clerks and accounting assistants. Intermediate suits most full-charge bookkeepers. Choose Advanced if the job includes month-end aging, because the aging-bucket and days-to-pay tasks only appear at that level.
How long should a bookkeeper 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.
Does it test bank reconciliations?
No. The bookkeeper test covers invoices, due dates, overdue balances, aging and fixing broken formulas. If reconciliation is central to the role, add a short reconciliation task in your interview.
Is it fair to give bookkeeping candidates an Excel test?
A short test tied to the work the job really involves is a common part of hiring. Give every candidate for the role 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.