Bookkeeping and P&L Spreadsheet for Consultants

Consulting revenue mixes projects, retainers, hourly advisory and expenses you re-bill to clients, while travel, subcontractors, insurance and memberships add up. You need your effective billing rate and the share of re-billed expenses you actually recovered.

This workbook is set up for consultants. It has 6 income categories (Project fees, Monthly retainers, Hourly advisory, Workshops & training, Speaking fees, Reimbursed client expenses) and 12 expense categories (Travel (air, hotel, car), Client meals & entertainment, Subcontracted consultants, Software & research subscriptions, Professional liability (E&O) insurance, Professional memberships, Home office & coworking, Accounting & legal, Marketing & website, Phone & internet, Training & certifications, Re-billable client costs), each with a note on what goes there, plus spare lines for your own. Fees kept by your card processor or platform are entered next to each sale and reported as their own expense line (payment & invoicing fees).

The Monthly P&L totals every category by month, then shows net profit, margin, a tax set-aside at the rate you choose and your monthly billable hours. The Dashboard compares any month with the year to date and tracks 5 trade KPIs against your targets: effective billing rate; retainer share of revenue; expense recovery rate; subcontractor % of revenue; travel % of revenue. The Annual Summary gives quarterly totals, your best month, the largest cost and the receipts still missing.

Included: a worked-example copy filled with a fictional consulting practice year, a blank copy, and a 6-page quick-start guide in US Letter and A4 (category map, KPI guide, worked example, tips for the trade). 7 sheets, 6,710 formulas, room for 1,000 income and 1,500 expense entries a year.

General information, not tax or accounting advice.