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

You don't need to know everything an accountant knows to get hired as a bookkeeper. You need a short list of skills that make an owner trust you with their bank login, and then a second list that makes you hard to replace. Here's the order worth learning them in.

28 open jobs
Step one

Gets you the interview

Double-entry basicsYou should be able to say which side a customer payment, a loan payment or an owner draw lands on without opening the software. Screeners ask this early, and a shaky answer ends the call.
QuickBooks Online day-to-dayKnow bank rules, the undeposited funds account, receive payment versus a plain deposit, and how to fix a transaction the bank feed matched wrong. That's most of what a small shop needs on your first Monday.
Excel lookups and pivot tablesOwners export everything to a spreadsheet. XLOOKUP and a quick pivot of vendor spend let you answer their questions in minutes instead of scrolling through reports.
Chart of accounts sensePlenty of small companies have a messy chart with duplicate expense accounts. Showing you can spot that and suggest a cleaner setup tells a hiring owner you think about the books, not just the data entry.
Step two

Gets you the offer

Payroll through a serviceMost bookkeepers feed hours into Gusto, ADP or Paychex and then book the journal entry that splits wages, employer taxes and withholdings. If you've done that cleanly, you can cover a job that most candidates can't.
Sales tax setup and filingGetting the tax rates right in the software and filing on schedule keeps the owner out of trouble with the state. Rules differ by state, so say you'd confirm the filing schedule with the accountant.
Accrual adjustmentsPrepaid insurance spread across the policy term, a bill for work done this month that hasn't arrived, a depreciation entry for a new truck. These separate a full-charge bookkeeper from someone who only codes transactions.
Bill pay and approval workflowsTools like Bill.com or Ramp route vendor bills for approval before money leaves. Knowing how to set approvers and match bills to receipts shows you can protect cash, which is what the owner is really paying for.
Step three

Gets you promoted

Cash flow forecastingA rolling weekly cash forecast in a spreadsheet answers the question owners actually lose sleep over: can we make payroll and still pay the supplier. This is the skill that moves you into an office manager or controller conversation.
Job costing or class trackingContractors, agencies and restaurant groups want profit by job, client or location. Setting up classes or projects so each one shows its own margin turns you from a recorder into someone the owner asks for advice.
Year-end handoff to the tax preparerA clean trial balance, a fixed asset list, loan statements and contractor payment totals, all delivered before the CPA asks. Accountants remember bookkeepers who do this, and they send work your way.
Internal controls for a small teamSeparating who approves bills from who pays them, locking closed periods, and reviewing user access in the software. It's dull, and it's the thing that catches theft in a small business.

Certificates worth your time

CertificateBest forEffortWorth it?
QuickBooks Online Certified ProAdvisorAnyone applying to small businesses or bookkeeping firms that run QuickBooksa couple of weekendsGet this first. It's free through Intuit's ProAdvisor program and answers the software question before an owner asks it.
Xero Advisor CertificationBookkeepers near firms or clients that use Xeroa weekend or twoWorth it only if Xero keeps showing up in postings near you. The ideas carry over from QuickBooks, so it goes quickly.
Certified Bookkeeper (AIPB)Experienced bookkeepers who want a credential beyond softwarea few months of study alongside workA solid signal once you have the experience it asks for. It covers adjustments, payroll and controls, which are exactly the offer and promotion skills above.

Requirements, costs and exam formats change, so check the current details directly with Intuit, Xero or the AIPB before you sign up.

Put it on your résumé like this

Weak

Handled payroll, bills and reports using QuickBooks.

Strong

Ran biweekly Gusto payroll for 28 employees and booked the payroll journal entries in QuickBooks Online, set up class tracking for 4 restaurant locations, and built a 13-week cash forecast the owner used to time a $60K equipment purchase.

Questions people ask

Which bookkeeping skill should I learn first?

Double-entry basics. Software changes its menus all the time, but if you understand why every entry has two sides, you can figure out any program and explain your work to an accountant.

Do I need to know payroll to get a bookkeeping job?

Not for every role, but it widens your options a lot. Many small businesses want one person who handles the books and payroll together. Learning to book payroll entries from a service report is a good place to start.

Is Excel still important if I know QuickBooks?

Yes. Reports come out of QuickBooks, but the analysis, forecasts and one-off answers for the owner usually happen in a spreadsheet. Pivot tables and lookups are the two features you'll use most.

How do I practice these skills without a job?

Intuit and Xero both offer free sample companies you can play with. Set one up, enter a month of made-up transactions, reconcile it, run payroll entries and close the month. Then do it again with accrual adjustments.

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

Start your trial