- US median pay$50,670 a year2All industries, BLS May 2025
- One-time fee$2,5001On the start day, only if you hire
- Free replacementWithin 180 days1One per placement, fee paid, role, hours and pay unchanged, no refund
What Excel is for in this role
Excel is the spreadsheet small businesses still use for reports, lists, budgets and everything their other software doesn't cover. For a bookkeeper it is the checking tool next to the accounting system: reconciliations, fixed asset and accrual schedules, and report packs.
What Excel work looks like for a bookkeeper
- Turn each export into an Excel table, so formulas and pivot tables pick up new rows on their own
- Match payouts, invoices or card lines to the bank with XLOOKUP and list every row without a partner
- Summarise ledger exports in pivot tables by account, vendor or month to spot miscoding
- Build prepayment, accrual and fixed asset schedules where every figure traces to a formula and a source line
- Clean the same monthly export with Power Query steps that refresh, instead of repeating manual edits
- Lay out each workbook as raw data, workings and result, so your accountant can follow the trail
What knowing Excel really means
- Matches two exports with lookups and shows what does not match
- Summarises a ledger export with a pivot table
- Builds a clear schedule with formulas, not typed-in numbers
- Keeps a clean audit trail: raw data, workings, result
Interview questions about Excel
- When do you reach for XLOOKUP, and when for a pivot table? A strong answer: xLOOKUP matches one record to another, such as a payout reference to a bank line. A pivot table summarises many lines, such as spend by vendor. A reconciliation often needs both.
- A lookup finds no match for a line you can see in the other file. Why? A strong answer: extra spaces, numbers stored as text, different date formats or rounding. They fix the data rather than typing the answer in.
- The same messy export arrives every month. How do you handle it? A strong answer: builds a Power Query once and refreshes it, or at least writes down the steps. Pasting values by hand each month is the weak answer.
A short practical test
Give a payout export and a bank export of a few hundred lines with some mismatches. Allow forty minutes. Ask for a reconciliation listing each difference. Open the file and read the formulas, not only the total.
What to check in the result
- Each difference has a reason column, such as timing, fee or missing line, not only an amount
- Matched and unmatched rows add up to the line counts of both exports
- Totals tie to the bank and payout figures through formulas, with no pasted values in the workings
Red flags in a bookkeeper who says they know Excel
- Types numbers into formulas, such as subtracting a fee keyed in by hand
- Overwrites the raw data while cleaning it
- Emails copies around and loses track of the current version
- Runs macros from files nobody has checked
The first week in Excel
- Share the workbooks through OneDrive or SharePoint, with edit rights only on files they will maintain
- Protect sheets that hold formulas or final figures, and keep the master copy yourself
- Remove pay details and personal data from exports when the job does not need them
- As a first job, rebuild last month's payout reconciliation from the raw exports with differences listed
- Open the file together and ask them to explain one formula and one pivot table
What access to give. Share only the files needed, through a shared folder with a named account and not by email attachments. Keep a master copy and protect the sheets with formulas. Remove personal or pay data from extracts where the job does not need it. Never ask someone to run macros from files you have not checked.
How long a smart hire needs to learn it
Basic lookups and pivots take a couple of weeks of daily use. A bookkeeper without them after several years is unlikely to be a strong one, so test it.
Our rule of thumb from how the work breaks down, not a study.
Available now
No published bookkeeper profile lists Excel on Stafka today. Send the brief, we reply within one business day with a yes or a no.
Choose a country: your hours on their clock
Put your hours in the brief: the partner agency gets them with your request and confirms the schedule with candidates before you interview. Bookkeeping has deadlines rather than shifts. A weekly rhythm and a fixed month-end date matter more than shared hours, apart from a short regular call with whoever approves payments.
Your 9–17 in local time today3456; the gaps move by an hour when the US or Europe changes its clocks. Check your own office.
What it costs
We do not publish a pay band for bookkeepers yet: where a profile lists a monthly rate, that is what the person asks for. The BLS figure of $50,670 a year is for Bookkeeping, Accounting, and Auditing Clerks2 across all industries: we have no separate figure for this niche. Paying through Deel adds $49 a month7; Wise and Payoneer also work.
See also: bookkeeper pay in the US, by state · pricing and replacement terms.
How hiring through Stafka works
Send the brief or post the job free. Name your accounting software, your country's tax setup, monthly transaction volume, and the accountant who reviews the books. Within 5 business days you get 3 profiles with English levels (B1–C2), or a plain no; you interview and contract the person directly. Candidates never pay.
Questions
What is advanced Excel for a bookkeeper?
Reliable lookups, pivots and clean structure, before anything fancy. Macros and Power Query are a plus if you have large repeating files, but a tidy, checkable workbook matters more.
General information for small employers, not legal or tax advice: check contracts, tax and data rules for your country with a qualified adviser. Tool names belong to their owners; we are not affiliated with them. Spotted a mistake? Write to hello@stafka.com.