Excel for Freelance Bookkeepers: Clients, Bank Feeds, Monthly P&L & Practice Profit
20 hands-on labs for self-employed bookkeepers: client fees, time tracking, bank feed rules, missing receipts, client P&L with SUMIFS, sales tax summary, month-end checklist, invoice batch, your own receivables, client profitability and a practice dashboard – then clean-up quotes, mileage and rebillable travel, duplicate bill checks, staff expense claims, prepayments and accruals, budget vs actual, an annual fee review, unbilled time and a full practice year review.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course gives self-employed bookkeepers 20 hands-on Excel labs built around one fictional one-person practice. You set up client fees and recurring revenue, turn time logs into hours per client, categorise a bank feed with a rules table, build a missing-receipts chase list, pull a client P&L from one ledger with SUMIFS, prepare a sales tax summary, track a month-end checklist, run an invoice batch, follow up your own receivables, test client profitability and build a dashboard. Part 2 adds a fixed-price clean-up quote, a mileage log with rebillable travel, a duplicate bill check, staff expense claims against a policy, prepayments and accruals, budget vs actual with a review rule, an annual fee review, unbilled time and a full practice year review with a combo chart. Fictional data; not tax advice.
Lessons
- Client List: Monthly Fees, Payroll Add-On and Recurring RevenueFree
- Time Tracking: Minutes Logged into Hours per Client Locked
- Bank Feed: Categorising Transactions with a Rules Table Locked
- Missing Receipts: a Chase List per Client with COUNTIFS Locked
- Monthly P&L per Client from One Ledger with SUMIFS Locked
- Sales Tax / VAT Summary: Rate Lookup and the Amount Payable Locked
- Month-End Checklist: Completion % per Client Locked
- Invoice Batch: Fees, Extra Hours, Tax and the Batch Total Locked
- Your Own Receivables: Due Dates, Days Overdue and Follow-Up Actions Locked
- Client Profitability: Fee vs Hours × Target Rate Locked
- Practice Dashboard: Revenue Mix, Revenue per Hour and a Chart Locked
- Clean-Up Quote: Backlog Transactions, Minutes per Line & a Fixed Price Locked
- Client Visits: Mileage Log, Allowance per km & Rebillable Travel Locked
- Duplicate Bills: Same Invoice Number, Same Amount Within 7 Days & the Amount at Risk Locked
- Staff Expense Claims: Limits per Category, Receipts & the Approved Amount Locked
- Prepayments & Accruals: Spreading Annual Bills Over the Months They Cover Locked
- Budget vs Actual: Variances, Favourable or Unfavourable & a Two-Limit Review Rule Locked
- Annual Fee Review: Rises by Package, Rounding Up & the Effect on Recurring Revenue Locked
- Unbilled Time: Extra Hours Not Yet Invoiced, Value per Client & Billing Shares Locked
- Final Project: Practice Year Review – Revenue per Hour, Recurring Share, Receivable Days & a Combo Chart Locked
Learner reviews
Be the first to review this course.