Cellwise Start free

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.

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
Every task in the Finance and accounting preset, by level and workbook
LevelInvoicesRep bonus sheet
BasicDue dates
Paid or unpaid
Total billed
Unpaid invoices
Fix the bonus column
Fix the total
Fix "Hit target?"
Fix the average
IntermediateDays 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
AdvancedAging 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

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.

RowABCDEFGHIJK
1InvoiceClientIssuedTerms (days)AmountPaid onDue dateDays overdueAs ofNov 15, 2026
2INV-1041Harbor DentalSep 8, 202630$1,250.00Oct 2, 2026Oct 8, 2026ClientHarbor Dental
3INV-1042Kline & RoweSep 15, 202645$3,400.00Oct 30, 2026
4INV-1043Bluebird CafeSep 22, 202614$480.00Oct 1, 2026Oct 6, 2026Amount overdue
5INV-1044Harbor DentalOct 1, 202630$1,250.00Oct 31, 2026Unpaid, client in K2
6INV-1045Northgate GymOct 6, 202630$2,150.00Nov 10, 2026Nov 5, 2026Invoices issued in October 2026
7INV-1046Kline & RoweOct 13, 202645$2,900.00Nov 27, 2026
8INV-1047Bluebird CafeOct 20, 202614$515.00Nov 3, 2026
9INV-1048Oak Street VetOct 27, 202630$1,780.00Nov 3, 2026Nov 26, 2026
10INV-1049Northgate GymNov 2, 202630$2,150.00Dec 2, 2026
11INV-1050Oak Street VetNov 9, 202630$960.00Dec 9, 2026
Answers to the sample task, what each returns on the visible sheet, and the hidden checks
Formula in K4Sheet they seeHidden checksResult
=SUMIFS(E2:E11,F2:F11,"",G2:G11,"<"&K1)SUMIFS with the date criterion joined to K1 $5,165.00 right Right on bothSolved
=SUMIF(F2:F11,"",E2:E11)Every unpaid invoice $11,175.00 wrongNot needed: already wrongNot solved
=SUMIFS(E2:E11,F2:F11,"",G2:G11,"<K1")The cell reference inside the quotes $0.00 wrongNot needed: already wrongNot 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:

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

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)

Create a free bookkeeper testCompare plans

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.