Tabellab
Accounting Beginner

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.

20 lessons 20 labs Certificate

  • 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

  1. Client List: Monthly Fees, Payroll Add-On and Recurring RevenueLabFree
  2. Time Tracking: Minutes Logged into Hours per ClientLab Locked
  3. Bank Feed: Categorising Transactions with a Rules TableLab Locked
  4. Missing Receipts: a Chase List per Client with COUNTIFSLab Locked
  5. Monthly P&L per Client from One Ledger with SUMIFSLab Locked
  6. Sales Tax / VAT Summary: Rate Lookup and the Amount PayableLab Locked
  7. Month-End Checklist: Completion % per ClientLab Locked
  8. Invoice Batch: Fees, Extra Hours, Tax and the Batch TotalLab Locked
  9. Your Own Receivables: Due Dates, Days Overdue and Follow-Up ActionsLab Locked
  10. Client Profitability: Fee vs Hours × Target RateLab Locked
  11. Practice Dashboard: Revenue Mix, Revenue per Hour and a ChartLab Locked
  12. Clean-Up Quote: Backlog Transactions, Minutes per Line & a Fixed PriceLab Locked
  13. Client Visits: Mileage Log, Allowance per km & Rebillable TravelLab Locked
  14. Duplicate Bills: Same Invoice Number, Same Amount Within 7 Days & the Amount at RiskLab Locked
  15. Staff Expense Claims: Limits per Category, Receipts & the Approved AmountLab Locked
  16. Prepayments & Accruals: Spreading Annual Bills Over the Months They CoverLab Locked
  17. Budget vs Actual: Variances, Favourable or Unfavourable & a Two-Limit Review RuleLab Locked
  18. Annual Fee Review: Rises by Package, Rounding Up & the Effect on Recurring RevenueLab Locked
  19. Unbilled Time: Extra Hours Not Yet Invoiced, Value per Client & Billing SharesLab Locked
  20. Final Project: Practice Year Review – Revenue per Hour, Recurring Share, Receivable Days & a Combo ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy