Google sheets questions for business accountant hiring

To hire a business accountant, write down the work you actually need done (bookkeeping, month-end close, tax filing, or forecasting), pick a hiring model that matches that volume, then test the tools the job runs on before anyone books an interview. That last step is the one most hiring teams skip, and it is the difference between an accountant who talks fluently about reconciliation and one who can finish a reconciliation by Friday.

The market gives you a reason to be careful. The median annual wage for accountants and auditors was $81,680 in May 2024, and about 124,200 openings a year are projected through 2034, according to the U.S. Bureau of Labor Statistics. So you are competing for a candidate who has options, at a salary that makes a mis-hire expensive. Getting the evaluation right the first time matters more than moving fast.

TL;DR

• Decide what you need first. Transaction entry is bookkeeping work. Interpretation, close, tax and forecasting are accountant work, and the two roles sit at very different pay bands.
• Match the hiring model to volume: an outside firm for a few hours a month, a fractional or part-time accountant for a growing ledger, a full-time hire once the close consumes a real work week.
• A CPA licence tells you someone passed an exam. It does not tell you whether they can build a working model in Sheets or clean up an AP backlog.
• Test the day-one tool stack (spreadsheets, accounting software, accounts payable and receivable) with a short, scored assessment before the first interview.
• Use the assessment results to run the interview. Ask about the answers they gave, not the bullet points on their resume.

What does a business accountant do?

A business accountant records, checks and explains your company's money. Day to day that means closing the books each month, reconciling bank and vendor accounts, running accounts payable and receivable, preparing statements, staying ready for tax time, and turning all of it into numbers leadership can act on.

One term is worth defining up front, because the rest of this guide leans on it. The close is the monthly process of making the books final and correct, and it is the work that separates this role from data entry. The job is a bundle of skills, not one skill, and a candidate can be strong at three of them and weak at the fourth in a way no resume will show you.

Bookkeeper vs accountant: which do you need?

A bookkeeper records transactions. An accountant interprets them, closes the period and signs off on what the numbers mean. Hiring the wrong one of those is the most expensive mistake in this category, and the pay gap is why: the median annual wage for bookkeeping and auditing clerks was $49,210 in May 2024, against $81,680 for accountants.

If you are not sure which side of that line you are on, our guide to hiring a bookkeeper covers the lower tier in detail, and the accountant job description template covers this one.

When should you hire a business accountant?

Hire when the finance work has started costing you decisions. Three signals are reliable: the monthly close takes longer than the first week of the month, someone senior is doing reconciliation instead of their actual job, or you cannot answer a cash question without opening four files. Any one of those means the ledger has outgrown part-time attention.

There is a fourth signal that people miss. If your last two tax seasons involved a scramble, that is not a tax problem, it is a bookkeeping-quality problem showing up eleven months late. An accountant fixes it at the source.

The counter-case is worth naming, because most hiring guides skip it: if your transaction volume is genuinely low and stable, a full-time accountant will be underused and bored, and bored finance hires leave. An outside firm at a few hours a month is the better call, and it is cheaper to reverse.

What does hiring an accountant cost?

Budget against the BLS median of $81,680 for a full-time hire, then adjust for market and seniority. But salary is only the visible cost. The one that hurts is the cost of getting it wrong: a mis-hire in this seat means a bad close, restated numbers, and a hiring cycle you now have to run twice while somebody covers the work.

Supply pressure makes that risk worse. Accounting bachelor's and master's graduates fell to 55,152 in the 2023-24 academic year, down 6.6% year over year, per the AICPA Trends report. There is a recovery underway (undergraduate accounting enrollment data shows a 12% year-over-year rise to 266,507 students in spring 2025), but those students are years from a close cycle. For now, the pool is tight and slow hiring loses candidates.

Pro tip: price the outside-firm option and the full-time hire side by side before you post the role. An outside firm at 10 hours a month and a full-time hire at the median wage are not close on cost, and the answer flips the moment the close reliably eats more than a work week.

Core skills to assess for accountant roles

Three competencies carry almost all of the day-to-day work. Test these and you have covered the job; test around them and you have covered the resume.

1. Google Sheets or Excel proficiency

Spreadsheets are where the reasoning happens. Test formulas and functions (VLOOKUP, IF, SUMIF), pivot tables and filtering, budget tracking and reconciliation, and error checking. The tell is not whether a candidate knows the function name. It is whether their sheet still works when you change one input.

2. QuickBooks and ledger software

For small and mid-sized businesses, most of the close happens inside accounting software. Assess chart-of-accounts setup, invoice creation and payment tracking, expense categorization, and bank reconciliation. A candidate who has only ever read reports out of the system is not the same hire as one who has configured it.

3. Accounts payable and receivable

Cash flow lives or dies on AP/AR accuracy. Check that candidates can process invoices correctly, handle vendor and customer records, apply payments, and spot discrepancies. Give them a messy input on purpose. Finding the error is the skill; a clean dataset tests nothing.

Secondary skills worth checking

• Numerical reasoning: reading a report and drawing the right conclusion from it
• Attention to detail: catching an error nobody flagged
• Written communication: explaining a variance to a non-finance manager in a paragraph
• Deadline handling: keeping quality up during a close week

How do you evaluate accountant candidates?

Evaluate against evidence, not against years. Sackett and colleagues reanalyzed decades of selection data in a 2022 meta-analysis and placed structured, job-relevant methods among the strongest predictors of job performance, while general years of experience and years of education landed among the weaker ones. Researchers still argue over the exact coefficients. The ranking is the part that holds.

Applied to this role, that is the Testlify Competency-to-Evidence Matrix: map the role to the competencies that matter, then connect each competency to a piece of measurable evidence through assessments, work tasks, structured interviews and reviewer feedback. The point is that every competency has to produce something you can look at.

Two caveats, because this approach has edges. A long assessment costs you candidates in a tight market, so keep it under about 45 minutes end to end. And a test score is an input to a decision, never the decision itself. AI and automated scoring can rank and summarize the evidence; the hiring call stays with your team.

How to hire a business accountant in 6 steps

1. Define the work. List what the person will own in month one: close, AP/AR, tax prep, reporting. If you cannot write it down, you are not ready to hire it.
2. Pick the model. Firm, fractional, or full-time, based on the hours that work actually takes.
3. Write the role around competencies. Name the tools, the close cadence and the reporting line. Vague postings attract vague candidates.
4. Assess before you interview. Put a short scored assessment right after the application, so the skills assessments do the first filter instead of a resume scan.
5. Interview the results. Walk through what they did on the assessment and why. This is where a structured interview earns its keep.
6. Check references on the close. Ask a former manager one specific question: what happened the last time the numbers were wrong?

Placing the assessment at step four is deliberate. Insert it any later and you have already spent interview hours on candidates who cannot do the work, which is exactly the waste this hiring process guide is built to remove.

Where do you find business accountant candidates?

Referrals from your own finance network convert best, and they are the first place to look because the person vouching for the candidate has usually watched them close a month. After that: professional association job boards, local accounting programs for junior roles, and the general boards for volume. An outside firm is also a sourcing channel, since a good one will tell you honestly when you have outgrown them.

Whatever channel you use, apply the same assessment to every candidate. A referral who skips the test is a referral you know nothing measurable about, and unequal processes are exactly where bias creeps into a shortlist.

What questions should you ask in the interview?

Ask questions that have a wrong answer. Good ones for this role: walk me through your month-end close, step by step. What is the first thing you check when a bank reconciliation does not balance? Tell me about a time you found an error after the books were closed, and what you did next. How do you decide what goes in a report to a non-finance leader?

Then ask about their assessment. If a candidate scored 68% on the AP/AR task, ask what they would do differently now. The answer tells you more about how they think than any hypothetical will, and it keeps the interview anchored to observed work rather than rehearsed stories.

Why does this matter at enterprise scale?

One bad accounting hire in a 50-person company is painful. In a large organization, the same hire sits inside a workflow that dozens of people depend on, and the error surfaces at quarter close in front of an audit committee. That is why large teams standardize on scored assessments: every candidate for the same role gets measured the same way, and the shortlist you hand a hiring manager means the same thing every time.

Across the finance teams we work with, one pattern keeps showing up. Teams that assess before interviewing spend fewer interview hours per hire and argue less about who to advance, because evidence settles the disagreement early instead of seniority settling it late. It also makes the decision explainable if anyone later asks why one candidate advanced and another did not. That is the real reason building a finance team at scale starts with measurement, not with the interview panel.

Assess accountant skills before the first interview

Testlify's test library covers the tool stack this role runs on. That includes advanced accounting and accounting clerk assessments alongside spreadsheet and AP/AR tasks, scored so your hiring team can compare candidates on the same terms. Book a demo to see where the assessment step fits in your current process.

Key takeaways

• Define the work before the role. Bookkeeping and accounting are different jobs at different pay bands ($49,210 against $81,680 at the May 2024 medians), and hiring up when you needed a bookkeeper wastes budget while hiring down leaves nobody accountable for whether the numbers are right.
• Match the model to the hours. An outside firm, a fractional accountant and a full-time hire solve different volumes of work. Pricing all three before you post the role is the cheapest hour you will spend on this hire, and it is reversible in a way a full-time offer is not.
• Credentials are a filter, not a signal. A licence proves someone passed an exam. It says nothing about whether they can build a working spreadsheet or clear an AP backlog, so treat it as a minimum bar and put the real evaluation elsewhere.
• Test the tool stack before the interview. Spreadsheets, ledger software and AP/AR carry the day-to-day work. A scored assessment under 45 minutes, placed right after the application, filters on ability instead of on how a resume was written.
• Interview the evidence you collected. Structured questions tied to a candidate's own assessment answers beat hypotheticals, because you are probing observed work. That is also what makes the decision explainable later.
• Run the same process for everyone, referrals included. A consistent assessment is what makes a shortlist comparable and a hiring decision defensible, and it is the part that breaks first when a team is in a hurry.
• Move quickly once the evidence is in. With graduate supply still tight, a slow final stage loses the candidate you already proved can do the job.

FAQs