Bookkeeper Excel test practice
Practise the Excel tasks bookkeeper job tests ask for: bank reconciliations, receivables ageing, vendor lookups, expense summaries and payroll.
Also for: Bookkeeping clerk, Accounts clerk, Bookkeeping assistant
Bookkeeping interviews often include a short spreadsheet test. These practice tests use realistic (fictional) company records and are marked automatically, so you see exactly which skills need work.
What the tests cover
- Reconcile a bank export and total uncleared items
- Age unpaid invoices against a cut-off date
- Summarise expenses by category across sheets
- Look up vendor details and payment terms
- Calculate gross pay with overtime and rounded tax
Excel skills you’ll use
Available tasks
26 tasks in 5 workplace scenarios: 10 beginner, 10 intermediate, 6 advanced.
Questions
Are these the real questions employers use?
No. They are original practice tasks in the style of common bookkeeping tests, built on fictional data.
Can I use a different formula from the model answer?
Yes. Answers are marked on the result in the answer cell, so any correct formula counts (unless a task asks for a specific function).
Is there a time limit?
No. Practice mode gives hints while you work; assessment mode shows your results after you submit.
Practice tasks in the style of common bookkeeper tests, on fictional data. Not any employer’s real test.