🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Business & Cross-Cutting › Bookkeeping / Office Administration › Capstone Project: Integrated Bookkeeping and Office Administration › Lesson 2
BUS-BOOK55-08 · Lesson 2 · 72 clock hours · lab

Full-Cycle Bookkeeping Build: Transactions, Payroll, and Reconciliation

Objective. Students will enter all source-document transactions for the three-month simulation period into QuickBooks—including sales, purchases, cash receipts, disbursements, payroll, and adjusting entries—and reconcile every bank and credit-card account to the provided statements with zero variance.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a credentialed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Full-Cycle Bookkeeping Build: Transactions, Payroll, and Reconciliation

This lab is the culminating exercise for the program. Over three simulated months you will do every task a staff bookkeeper handles: build a company file, record all transaction types, run payroll, post adjusting entries, and reconcile every account to zero variance. The skills are tested directly on the QuickBooks Certified User exam, the AIPB Certified Bookkeeper exam, and reinforce the Excel work required for Microsoft Office Specialist.

Phase 1 – Company File Setup

Before a single transaction is posted, the file must be structurally correct. Start with the chart of accounts. Map every account on the provided trial balance to the correct account type in QuickBooks (asset, liability, equity, income, cost of goods sold, or expense). Enter the opening balance for each balance-sheet account as of the first day of the simulation period. Opening balances flow through an Opening Balance Equity account; that account should net to zero once all balances are entered and verified.

Add every customer and vendor from the scenario. For customers, enter the receivable balance owed at start; for vendors, enter any payable balance. Configure at least two payroll items—for example, a salary or hourly wage item and a health-insurance deduction item. Your instructor will check the setup against an answer key at the 8-hour mark. Do not post any transactions until you receive sign-off. This checkpoint exists because a structural error in the chart of accounts contaminates every transaction posted afterward and can cost hours of rework.

Phase 2 – Recording Transactions in Chronological Order

Work through the 90 days of source documents in date order. The major transaction types you will encounter are:

As you work, flag every transaction that requires a journal entry rather than a standard form. Common flags:

Phase 3 – Bank and Credit-Card Reconciliation

Reconcile each account for each of the three months in sequence—never skip a month and reconcile month 3 alone. The reconciliation process in QuickBooks:

1. Open the reconciliation screen and enter the statement ending date and ending balance from the bank statement PDF.

2. Check off every deposit and check that appears on the statement.

3. The difference shown by QuickBooks must reach $0.00 before you finish. If it does not, the discrepancy is either a timing item (outstanding check or deposit in transit) or an error.

4. Outstanding items are legitimate only if they appear in QuickBooks but not yet on the statement. Write a one-sentence explanation for each on the reconciliation worksheet (e.g., "Check 1042 dated 3/29 mailed to vendor; cleared on April bank statement").

5. Print or export all three completed reconciliation reports. Verify that the ending reconciled balance for cash on each report ties to the Cash line on the Balance Sheet for that date.

Data Integrity and Accuracy Standards

This lab uses a zero-variance standard because that is the standard in professional practice. A bank reconciliation with any unexplained difference is an open audit finding. The accuracy audit at the end of month 3 requires your trial balance to match the answer key to the penny and all reconciliations to show a zero difference. Fewer than five transaction-coding errors are permitted to pass; five or more require correction before you advance.

Workplace Safety Notes

Office environments carry real hazards. Keep power cords secured and away from walkways to prevent trips. If a workstation or peripheral shows signs of electrical damage—frayed cords, burning smell, sparks—stop work, do not attempt to repair it yourself, and notify the instructor immediately. Prolonged screen work requires ergonomic attention: position monitors at eye level, take brief breaks every hour, and report any repetitive-strain symptoms early. Data security is also a safety issue: never leave a client file open and unattended, log out of QuickBooks when stepping away, and follow your lab's policy on removable media.

Key terms10

Chart of AccountsA complete numbered list of all accounts a business uses to record financial transactions, organized by account type (asset, liability, equity, income, expense).
Opening Balance EquityA temporary QuickBooks account that absorbs the offsetting entry when asset and liability opening balances are entered; it should net to zero after all balances are correctly recorded.
Undeposited FundsA holding account in QuickBooks where customer payments accumulate until they are grouped into a bank deposit that matches the actual bank deposit slip.
Payroll RegisterA spreadsheet listing each employee's gross wages, all withholdings (federal income tax, Social Security, Medicare, and voluntary deductions), and net pay for a single pay period.
Accrued Wages PayableA liability representing wages employees have earned by month end but that will not be paid until the next payroll run; recorded with a journal entry to match expense to the correct period.
Bank ReconciliationThe process of comparing a company's cash book balance to the bank statement balance, identifying and explaining all differences, so the adjusted balances agree.
Outstanding CheckA check recorded in the company's books that has not yet cleared (been paid by) the bank and therefore appears in the company records but not on the current bank statement.
Adjusting Journal EntryA journal entry made at period end to record items such as depreciation, accruals, and prepaid adjustments that are not captured by routine transaction forms.
Zero-Variance StandardThe professional requirement that a completed bank reconciliation show a $0.00 unexplained difference between the adjusted book balance and the adjusted bank balance.
Gross-to-Net CalculationThe payroll computation that begins with an employee's gross wages and subtracts all required and voluntary withholdings to arrive at the net pay amount issued on the paycheck.

Worked examples4

1. Employee Maria earns a weekly salary of $900.00. Federal income tax withheld this period (per IRS Circular E tables for her filing status and allowances) is $72.00. Social Security tax (employee share) is 6.2% of gross wages. Medicare tax (employee share) is 1.45% of gross wages. She has a voluntary health-insurance deduction of $35.00 per week. Calculate her net pay.
  1. Step 1 – Identify gross wages: $900.00
  2. Step 2 – Calculate Social Security tax: $900.00 × 0.062 = $55.80
  3. Step 3 – Calculate Medicare tax: $900.00 × 0.0145 = $13.05
  4. Step 4 – List all deductions: Federal income tax $72.00 + Social Security $55.80 + Medicare $13.05 + Health insurance $35.00 = $175.85 total deductions
  5. Step 5 – Subtract total deductions from gross: $900.00 − $175.85 = $724.15
Answer: Maria's net pay is $724.15.
2. At month end the QuickBooks bank account balance is $8,342.60. The bank statement ending balance is $8,715.40. A deposit of $520.00 made on the last day of the month is not yet on the bank statement (deposit in transit). Check #2087 for $892.80 is outstanding (in QuickBooks but not cleared the bank). Reconcile and confirm the adjusted balances agree.
  1. Step 1 – Start with the bank statement balance: $8,715.40
  2. Step 2 – Add the deposit in transit: $8,715.40 + $520.00 = $9,235.40
  3. Step 3 – Subtract the outstanding check: $9,235.40 − $892.80 = $8,342.60 (adjusted bank balance)
  4. Step 4 – The QuickBooks book balance is already $8,342.60 with no book-side adjustments needed.
  5. Step 5 – Compare: adjusted bank balance $8,342.60 = book balance $8,342.60. Difference = $0.00.
Answer: The reconciliation balances with a zero-dollar difference. The adjusted balance is $8,342.60.
3. A business purchased a one-year insurance policy on January 1 for $2,400.00, recorded as Prepaid Insurance. Prepare the adjusting journal entry needed at January 31 to record one month of insurance expense.
  1. Step 1 – Calculate the monthly portion: $2,400.00 ÷ 12 months = $200.00 per month
  2. Step 2 – Identify the accounts: debit Insurance Expense (increases an expense) and credit Prepaid Insurance (decreases an asset).
  3. Step 3 – Record the entry: Debit Insurance Expense $200.00 | Credit Prepaid Insurance $200.00
  4. Step 4 – Write the memo: 'To record one month of prepaid insurance expired (January); $2,400 ÷ 12 = $200.'
Answer: Debit Insurance Expense $200.00; Credit Prepaid Insurance $200.00. Prepaid Insurance balance reduces from $2,400.00 to $2,200.00.
4. A payroll period runs from March 28 through April 3; payday is April 5. Total wages earned by employees from March 28 through March 31 (four days of a seven-day week) amount to $1,400.00. Prepare the March 31 accrual journal entry for wages.
  1. Step 1 – Confirm the amount to accrue: wages earned in March but unpaid = $1,400.00.
  2. Step 2 – Identify accounts: debit Wages Expense (expense incurred in March) and credit Accrued Wages Payable (liability—owed but not yet paid).
  3. Step 3 – Record the entry: Debit Wages Expense $1,400.00 | Credit Accrued Wages Payable $1,400.00
  4. Step 4 – Write the memo: 'To accrue wages earned March 28–31; will be paid on April 5 payroll.'
Answer: Debit Wages Expense $1,400.00; Credit Accrued Wages Payable $1,400.00.
In class: Set up the QuickBooks company file from scratch: create the chart of accounts from the trial balance provided in the scenario, enter opening balances, add customer and vendor records, and configure at least two payroll items; instructor spot-checks the setup against an answer key at the 8-hour mark before students post any transactions. · Work through 90 days of source documents in chronological order—sales invoices, customer payments, vendor bills, checks, expense receipts, and two complete payroll runs including gross-to-net calculations verified manually on a payroll register worksheet in Excel—flagging any transaction requiring a journal entry (depreciation, accrued wages, prepaid adjustments) and posting those entries with a memo explaining the debit/credit logic. · Perform a bank reconciliation in QuickBooks for each of the three months using the provided bank statements; for any outstanding item, write a one-sentence explanation on the reconciliation worksheet; print or export all three completed reconciliation reports and verify that ending reconciled balances tie to the Balance Sheet.
Materials: QuickBooks Desktop or Online (student trial), scenario source documents (printed or PDF), blank payroll register worksheet in Excel, bank statement PDFs (instructor-prepared), calculator, AIPB Bookkeeping Volumes 1–6, IRS Circular E (Employer's Tax Guide) for payroll reference
Check: Instructor runs a structured accuracy audit: checks that the QuickBooks trial balance at the end of month 3 matches the instructor answer key within $0.00, all three bank reconciliations show a zero difference, and the payroll register net-pay figures match QuickBooks paycheck totals. Pass = zero-dollar variance on reconciliations and fewer than five transaction-coding errors on the audit; errors above five require correction before the student advances.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

QuickBooks Certified User – Company setup and chart of accounts
1. When entering opening balances for a new QuickBooks company file, what is the purpose of the Opening Balance Equity account?
QuickBooks Certified User – Accounts receivable and banking
2. Which QuickBooks workflow correctly records a customer payment received on a bill that was previously invoiced?
AIPB Certified Bookkeeper – Payroll
3. An employee has gross wages of $1,200.00 for the week. Social Security tax (employee share) is 6.2% and Medicare tax (employee share) is 1.45%. Federal income tax withheld is $110.00 and a voluntary 401(k) deduction is $60.00. What is the employee's net pay?
AIPB Certified Bookkeeper – Banking and reconciliation
4. A bank reconciliation is complete. The adjusted bank balance is $5,210.00 and the adjusted book balance is $5,285.00. What should the bookkeeper do?
AIPB Certified Bookkeeper – Banking and reconciliation
5. Which of the following best describes a deposit in transit on a bank reconciliation?
AIPB Certified Bookkeeper – Adjusting entries
6. At December 31, a business has a prepaid advertising balance of $3,600 representing a 12-month campaign that began December 1. What adjusting entry is needed on December 31?
QuickBooks Certified User – Accounts payable
7. In QuickBooks, what is the correct method to pay a vendor bill that was previously entered through the Enter Bills screen?
Microsoft Office Specialist – Excel formulas and functions
8. Which Microsoft Excel feature is most appropriate for organizing and totaling a multi-employee payroll register that must calculate gross pay, each withholding category, and net pay automatically?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →