Auditor skills: what to learn first, and what can wait

Audit skills stack in a clear order, and learning them out of order wastes a busy season. Get the basics that make your workpapers reviewable first, then the judgment that makes a manager trust you with an area. The things that get you promoted can wait until you've been through a full cycle.

924 open jobs
Step one

Gets you the interview

Excel for tying out schedulesYou'll spend your first months matching client schedules to the general ledger. XLOOKUP, SUMIFS, pivot tables and tick marks you can explain are what a posting means by strong Excel.
Debits, credits and the closeYou need to know where an accrual, a prepaid or a deferred revenue balance comes from before you can test it. Interviewers check this with a quick journal entry question, and freezing on it ends the conversation early.
Vouching and tracingVouching goes from the ledger back to the invoice and tests whether a thing happened. Tracing goes the other way and tests whether everything got recorded. Knowing which one proves which assertion is a classic first-round question.
Basic GAAP for the big accountsRevenue recognition, leases and inventory costing come up on almost every engagement. You should be able to say what each standard is trying to stop a company from doing.
Step two

Gets you the offer

Sampling you can defendAnyone can pull a random sample. The offer goes to the person who can explain why the sample is that size, how materiality and risk shaped it, and what happens when one item comes back wrong.
Walkthroughs and control testingHiring managers want to hear that you can follow one transaction from purchase order to payment and name the control meant to catch a mistake. Then you test whether it actually ran.
Workpapers a reviewer can follow coldA clean file states the objective, procedure, result and conclusion, with every number referenced to its source. Be ready to talk through one you built in CaseWare or your firm's platform.
Data pulls in IDEA or AlteryxRunning a full-population test on a year of journal entries beats sampling a handful by hand. Even one project where you filtered entries posted on weekends or by unusual users sets you apart from candidates who only talk about Excel.
Step three

Gets you promoted

Risk assessment that changes the planSeniors and managers decide where testing goes. That means reading the minutes, the contracts and last year's findings, then cutting work in low-risk areas and adding it where the business actually changed.
Writing findings people act onA finding has a condition, criteria, cause, effect and a recommendation someone can own. Managers who write them tightly get fewer arguments at the closing meeting and fewer rewrites from the partner.
Handling proposed adjustmentsTelling a controller their number is wrong, and holding that line when they push back, takes practice. Know your summary of unadjusted differences and when an item needs escalating.
Reviewing without redoingYour promotion depends on getting good work out of staff. Clear review notes and coaching in the moment separate a manager from an overworked senior.

Certificates worth your time

CertificateBest forEffortWorth it?
Certified Public Accountant (CPA)External auditors at public accounting firms, and anyone who wants to sign an opinionMany months of evening and weekend study across several exam sections, plus education and experience rulesWorth it if you're on the external side. Start while you're still staff, because studying gets much harder once you're running engagements.
Certified Internal Auditor (CIA)Internal auditors inside one companyA few months of steady study across the exam partsThe right pick if you've left public accounting or never plan to sign opinions. It carries real weight with internal audit directors.
Certified Information Systems Auditor (CISA)Auditors who test IT general controls, access and system changesA couple of months of focused study, plus work experience before you can hold itPays off fast if you like the systems side. IT audit teams are often short on people who can talk to both accountants and engineers.
Certified Fraud Examiner (CFE)Auditors leaning toward investigations or forensic workA few weekends to a couple of months, depending on your backgroundA useful add-on, not a first certificate. Get the CPA or CIA before this one.

Exam rules, fees and experience requirements change and the CPA differs by state, so check the certifying body or your state board of accountancy before you plan your study.

Put it on your résumé like this

Weak

Performed audit procedures and tested internal controls for various clients.

Strong

Tested 38 revenue and payables controls across 4 SOX clients, ran an IDEA journal entry analysis over 212,000 entries, and flagged a $1.4M cut-off error the client booked before year-end.

Questions people ask

Which audit skill should I learn first?

Excel tie-outs and vouching. They're what you'll do all day as staff, and a reviewer will judge you on them before anything else. Sampling theory and risk assessment make much more sense once you've tested a few areas by hand.

Do I need to know data analytics to get hired as an auditor?

Not to get hired, but it helps you get picked. Many teams run full-population tests in IDEA, Alteryx or Power BI. A single class project where you analysed a real dataset gives you something concrete to talk about in the interview.

Is the CPA or the CIA better for an auditor?

It depends on the side you're on. The CPA is the license for external audit and opens the most doors if you ever move to controller. The CIA is built for internal audit. Plenty of people hold both, but pick the one that matches your current job first.

How do I get audit experience without an audit job?

Internships during busy season are the usual route. Staff accountant roles count too, since reconciliations and close work teach the same accounts you'll later test. Nonprofit treasurer or bookkeeping work gives you real ledgers to talk about.

Got step one? Start applying. HeroApply matches you to roles that fit.

Start your trial