Project Kickoff, Scenario Analysis, and Work Plan

What Is the Capstone Project?

The capstone project is the final, integrating assignment of your Bookkeeping and Office Administration program. Instead of practicing one skill at a time, you now apply everything — accounting, software, correspondence, payroll, records management, and professional judgment — to a single simulated client over a 90-day operating period. The scenario packet you receive is the starting point for all work through the end of the program.

Think of yourself as a bookkeeper brought in by a small retail and service business that needs its books set up, its transactions recorded, its payroll processed, its financial statements prepared, and its office records organized. Every deliverable you produce will mirror real work that employers expect — and each one maps directly to a credential exam domain you are preparing to sit.

Reading and Understanding the Scenario Packet

The 12-page scenario packet describes the fictitious client: its legal structure, chart of accounts, employee roster, vendor relationships, customer base, and 90 days of source documents such as invoices, receipts, bank statements, and payroll records. Before you touch QuickBooks or Excel, you must read and annotate the packet carefully.

Annotation means actively marking the text. Use a highlighter or margin notes to flag every transaction type (cash sales, credit purchases, payroll runs, adjusting entries), every entity detail (legal name, federal employer identification number format, state of incorporation), and every deliverable trigger — the moment in the scenario that signals a required output is due. Missing a trigger early can cause you to skip an entire deliverable, which fails the checklist.

After annotation, write a one-page business summary of the client. Include the business structure, its industry, the accounting basis it uses (cash or accrual), the payroll frequency, and any special features such as sales tax obligations or inventory tracking. This summary forces you to synthesize the details before you build anything.

Why the Deliverables Checklist Matters

The deliverables checklist is your contract with yourself and your instructor. It lists every required output:

• QuickBooks company file — set up from scratch using the scenario's chart of accounts and opening balances
• Payroll register — summarizing each pay period for all employees
• Accounts receivable and accounts payable aging reports — generated from QuickBooks at period end
• Correspondence set — professional business letters and emails produced using Microsoft Word
• Records binder — organized hard-copy or digital file following the course records management reference guide
• Excel financial statements — income statement and balance sheet formatted and verified in Microsoft Excel

For each deliverable, the checklist maps it to the credential exam domain it most directly covers. For example, setting up the QuickBooks company file is the core of the QuickBooks Certified User domain for company setup and navigation. Preparing adjusting entries falls under the AIPB Certified Bookkeeper domain for adjusting and correcting entries. Formatting multi-sheet Excel workbooks with formulas, named ranges, and print areas aligns with the Microsoft Office Specialist (Excel) domains for workbook management and data presentation.

This mapping is not busywork. When you sit each exam, the checklist reminds you exactly which project tasks gave you hands-on practice in that domain. Gaps on the checklist mean gaps in your preparation.

Get your instructor's signature on the checklist before you open QuickBooks. An unsigned checklist means you may be starting on a misunderstood scope of work.

Building Your Personal Work Plan in Excel

A work plan is a living schedule that keeps you on track through a complex, multi-week project. Your work plan must include:

• Every major task, broken down small enough that you can complete each in one or two work sessions
• Estimated hours for each task, totaling no more than your remaining program hours
• Due date for each task, working backward from the final submission deadline
• A risk note for any area where an error in one task will cascade into later tasks

Cascading errors are the most important concept in project planning for bookkeepers. If you enter incorrect opening balances in QuickBooks, every subsequent report — the trial balance, the aging reports, the financial statements — will be wrong. Identifying these high-risk tasks early lets you build in a review step before moving on.

Bring your draft work plan to a 10-minute check-in conference with your instructor. Come prepared to explain your timeline and your biggest risk item. Your instructor may spot unrealistic time estimates or a missed deliverable. Adjust the plan before Lesson 2 begins.

Safety and Confidentiality Protocols

Even though the client is fictitious, your program treats all scenario data as if it were real. Two protocols apply from the very first day:

Data confidentiality. The scenario packet contains simulated employee names, wages, Social Security number formats, and customer account details. Do not post scenario data on social media, share files outside the classroom network, or leave printed documents unattended. Treat the packet the way you would treat a real client's records — locked away when not in use, and returned or shredded at program end per your instructor's direction. These habits transfer directly to employment, where mishandling client financial data can have serious legal consequences.

Digital file safety. Back up your QuickBooks company file and Excel workbook at the end of every work session to the designated secure drive or cloud folder. A lost file cannot be recreated quickly, and a failed backup can derail your entire timeline. Label each backup with the date and version so you can restore a prior version if data becomes corrupted.

No physical hazards such as electrical equipment or chemical exposure apply to this lesson. However, ergonomic best practices — correct monitor height, keyboard position, and regular breaks — apply during extended computer sessions.

The Instructor Check Before You Proceed

Lesson 1 ends only when your instructor reviews and approves both documents: the deliverables checklist and the work plan. Every deliverable must be listed, every deliverable must be mapped to at least one credential domain, and your timeline must be feasible within your remaining hours. A complete, approved set of documents is your green light to begin the hands-on work in Lesson 2.