Cellwise Hire · Financial analysis preset
Excel test for accountants
Candidates work in a monthly P&L the way an accountant does at month-end: operating profit, variance to budget, growth on last year, year-to-date figures through a month-end date in a cell, and margins that survive a month with no revenue. Then they review a colleague's workbook and fix what is broken. Every answer is checked by what it calculates, on the sheet they see and on hidden versions of it.
Create a free accountant testSee a sample task
Free for your first 3 candidates. The Financial analysis preset is preselected for you.
The test at a glance
- Workbooks
- Monthly P&L + 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: Staff accountants, Senior accountants, General ledger and reporting accountants, Accounting managers who review month-end files.
What accountants actually do in Excel
The ledger lives in the accounting system. The month-end pack usually does not. An accountant exports the P&L and builds the schedule that explains it: actual against budget, this month against the same month last year, year to date through the month just closed. When a line moves, they are the one asked why.
Most of their spreadsheets were started by someone else. Rolling last month's file forward and checking that every formula still covers the right rows is part of the close. So is spotting the total that stops one row short before the controller does.
- Operating profit and variance to budget for every month, with one sign convention throughout
- Variance and growth as percentages, divided by budget or by last year rather than by actual
- Year-to-date totals through the month-end date in a cell, so next month is a one-cell change
- The margin for a period as total profit over total revenue, and a blank instead of #DIV/0! for a month with no revenue
- A monthly loan payment with PMT, from the amount, rate and term in cells
- Reviewing an inherited workbook and fixing its formulas without rebuilding it
What the test checks
The Financial analysis preset uses two workbooks: Monthly P&L (a company's monthly profit and loss for January to October: revenue, the revenue budget, cost of sales, operating expenses and revenue in the same month last year) 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 accountants, with the real task names and the level each one appears at.
Profit and variance, with the right sign
Operating profit down the column, variance as actual minus budget so a positive number means revenue came in ahead, and a count of months over budget where a month exactly on budget does not count. Basic, but it is where sign mistakes start.
- Operating profitBasic
- Variance vs budgetBasic
- Months over budgetBasic
Variance and growth in percent
Each month's variance as a share of budget, and growth on the same month last year. The divisor is what is being checked: the difference over budget, and this year over last year minus 1.
- Variance % vs budgetIntermediate
- Year-over-year growthIntermediate
Year to date through a month-end
A running year-to-date total with a locked start ($B$2:B2), the margin for the whole period as total profit over total revenue rather than an average of monthly margins, and revenue against budget through the month-end date typed in a cell, with SUMIFS and "<="&O1.
- Year-to-date revenueIntermediate
- Year-to-date operating marginBasic
- Year-to-date variance %Advanced
A month with no revenue
The business closed for a refit one month. Monthly margins have to show a blank there, not #DIV/0! and not 0%, because a 0 is included in any average taken later and a blank is skipped. Advanced level.
- Monthly operating marginAdvanced
Loan payment
A monthly payment from a loan amount, a yearly rate and a term in years: the rate divided by 12, the term times 12, and the sign handled so the payment shows as a positive number. Advanced level.
- Loan paymentAdvanced
Reviewing a colleague's workbook
The second workbook is a quarterly sales and bonus sheet with broken formulas: a total that misses the last row, a rate cell that is not locked with $, ">" where the rule says "met or beat", SUMIF arguments in the wrong order, #DIV/0! for reps with no target, a COUNTIF that tries to compare two columns, and an average that should skip reps with no sales yet.
- Fix the totalBasic
- Fix the bonus columnBasic
- Fix "Hit target?"Basic
- Fix the East totalIntermediate
- Fix the #DIV/0! errorsIntermediate
- Fix the target countAdvanced
- Fix the averageAdvanced
Every task in this test, by level
| Level | Monthly P&L | Rep bonus sheet |
|---|---|---|
| Basic | Operating profit Variance vs budget Months over budget Year-to-date operating margin | Fix the bonus column Fix the total Fix "Hit target?" Fix the average |
| Intermediate | Variance % vs budget Year-over-year growth Year-to-date revenue Next month forecast | Fix the manager lookup Fix the East total Fix the #DIV/0! errors Make the count follow K2 |
| Advanced | Monthly operating margin Loan payment Three-month forecast Year-to-date variance % | 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 suggestedJunior and staff accountants: operating profit, variance to budget, months over budget, the margin for the period, and four everyday formula fixes.
- Intermediate · 30 minutes suggestedStaff and senior accountants who prepare the monthly pack: variance %, growth on last year, year-to-date running totals, a next-month forecast, and lookup and #DIV/0! fixes.
- Advanced · 40 minutes suggestedSenior accountants and accounting managers who own the close: year to date through a month-end date, guarded margins, a loan payment, and silent bugs in a colleague's workbook.
A real task from this test
This is one of the tasks in the Financial analysis preset at the Advanced 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 · Monthly P&L · Advanced
Year-to-date variance % (in O2). Compare revenue with budget for the year to date, counting only the months up to and including the month-end date in O1, as a percentage over or under budget. When O1 changes, the answer has to follow.
| Row | A | B | C | D | E | F | G | H | I | J | K | L |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Month ending | Revenue | Budget | Cost of sales | Operating expenses | Revenue last year | Operating profit | Operating margin | Loan amount | $50,000.00 | ||
| 2 | Jan 31, 2026 | $84,200.00 | $80,000.00 | $33,700.00 | $38,100.00 | $76,500.00 | $12,400.00 | Annual interest rate | 6% | |||
| 3 | Feb 28, 2026 | $79,600.00 | $82,000.00 | $31,800.00 | $37,400.00 | $71,200.00 | $10,400.00 | Term (years) | 5 | |||
| 4 | Mar 31, 2026 | $91,300.00 | $88,000.00 | $36,500.00 | $39,200.00 | $80,100.00 | $15,600.00 | Monthly loan payment | ||||
| 5 | Apr 30, 2026 | $0.00 | $45,000.00 | $0.00 | $21,500.00 | $83,900.00 | -$21,500.00 | Monthly growth rate | 2% | |||
| 6 | May 31, 2026 | $95,700.00 | $92,000.00 | $38,300.00 | $40,100.00 | $86,400.00 | $17,300.00 | Months ahead | Forecast revenue | |||
| 7 | Jun 30, 2026 | $90,400.00 | $94,000.00 | $36,200.00 | $39,900.00 | $88,800.00 | $14,300.00 | 1 | ||||
| 8 | Jul 31, 2026 | $86,900.00 | $90,000.00 | $34,800.00 | $39,500.00 | $84,700.00 | $12,600.00 | 2 | ||||
| 9 | Aug 31, 2026 | $98,200.00 | $93,000.00 | $39,300.00 | $40,600.00 | $87,300.00 | $18,300.00 | 3 | ||||
| 10 | Sep 30, 2026 | $102,500.00 | $97,000.00 | $41,000.00 | $41,800.00 | $92,600.00 | $19,700.00 | |||||
| 11 | Oct 31, 2026 | $99,800.00 | $100,000.00 | $39,900.00 | $41,200.00 | $95,100.00 | $18,700.00 |
| Formula in O2 | Sheet they see | Hidden checks | Result |
|---|---|---|---|
=SUMIFS(B2:B11,A2:A11,"<="&O1)/SUMIFS(C2:C11,A2:A11,"<="&O1)-1Both totals limited to "<="&O1 | -8% right | Right on both | Solved |
=SUMIFS(B2:B11,A2:A11,"<"&O1)/SUMIFS(C2:C11,A2:A11,"<"&O1)-1"<" instead of "<=" | -9% wrong | Not needed: already wrong | Not solved |
=SUM(B2:B11)/SUM(C2:C11)-1Every month on the sheet | -4% wrong | Not needed: already wrong | Not solved |
=SUMIFS(B2:B11,A2:A11,"<"&O1)/SUMIFS(C2:C11,A2:A11,"<"&O1)-1O1 holds a month-end date, and the month ending on that date is the one just closed. "<" leaves it out, so the pack shows last month's year to date under this month's heading. The number looks believable, which is why it can get through review.=SUM(B2:B11)/SUM(C2:C11)-1It ignores O1 completely. It is only right when O1 happens to be the last month in the data, and wrong for every other close.
Grading is by result, so SUMPRODUCT and FILTER versions pass too. The hidden versions use a different month-end date and different figures, so only a formula that really reads O1 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 accountant 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 accountants, two things are worth a look:
- Open the year-to-date tasks first. Whether the candidate compared dates with "<=" or "<", and whether the running total has a locked start, tells you how their schedules will roll forward next month.
- On the colleague's workbook, the replay shows whether they read the broken formula and changed the one thing that was wrong, or deleted the column and started again. Both can reach 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
- Journal entries, reconciliations, accruals, accounting standards and your accounting system are not in this test. It tests the Excel work around the close. Our guide to the Excel test for accounting roles has reconciliation and matching tasks with checked answers, to use in an interview.
- This page and the Excel test for financial analysts use the same Financial analysis preset; that page describes it with a forecasting focus. For roles centred on invoices and receivables, the Excel test for bookkeepers uses an invoice workbook instead of the P&L.
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 accountant need?
SUMIFS and SUMPRODUCT for totals by period and account, variance in amount and percent with a consistent sign, year-to-date figures through a month-end date, margins with a divide-by-zero guard, absolute references so a schedule fills down and rolls forward, exact-match lookups, finance functions such as PMT, and the habit of checking an inherited workbook before trusting it.
Which level should I choose for a staff accountant?
Basic suits junior and entry-level staff accountants. Intermediate suits most staff and senior accountants. Choose Advanced for senior accountants and managers who own the close, because the year-to-date-through-a-date, guarded margin and loan payment tasks only appear at that level.
Does it test reconciliations or journal entries?
No. It tests the Excel around them: variance, year to date, margins, a loan payment and fixing broken formulas. If reconciliations are central to the role, add a short matching task in the interview.
How is it different from the financial analyst test?
The tasks are the same Financial analysis preset. This page explains what they show about month-end reporting and review; the financial analyst page explains what they show about forecasting. Pick the level by seniority, not by page.
Is it fair to give accounting 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.