Skip to content
Tutorials Center
My learning

Topics

Lesson 34 of 36 ยท Projects and Practice

Project: Books for a Small Service Business

Work through a month of bookkeeping for a small design studio: invoices, bills, payroll, bank rules, reconciliation and reports, with a runnable ledger to check your numbers.

This project ties the course together. You will keep the books of an imaginary design studio for one month, deciding which QuickBooks feature handles each event, and then check your results with a ledger you can run here. It works as a paper exercise or as a guided practice in the free QuickBooks sandbox company or a trial file.

QuickBooks cannot run on this site. The TryIts are JavaScript stand-ins; the studio and its numbers are invented, and tax amounts are illustrative.

The business: Pixel Harbor Studio

Pixel Harbor is a two-person design studio using QuickBooks Online on the accrual basis. On March 1 it has these balances:

Account Balance
Checking 12,000
Accounts Receivable 2,500 (invoice 2001 to Oak Cafe, due March 10)
Equipment 4,000
Accounts Payable 0
Owner's equity 18,500

(Assets 18,500 = Liabilities 0 + Equity 18,500.)

The month's events

  1. Mar 3: Invoice 2002 for 3,200 to Lin Repairs, brand design, due Mar 30.
  2. Mar 5: Oak Cafe pays invoice 2001 (2,500) by bank transfer.
  3. Mar 6: Rent bill from the landlord, 1,400, due Mar 15.
  4. Mar 8: Software subscription charged to the company card, 90.
  5. Mar 12: Pay the rent bill from checking.
  6. Mar 15: Pay a freelance illustrator 600 from checking (a 1099 contractor).
  7. Mar 20: Invoice 2003 for 1,800 to Harbor Foods, due Apr 19.
  8. Mar 31: Owner takes a draw of 1,000.

Your task, step by step

Setup. Which account types do you need? At minimum: Checking (bank), Credit Card (liability), Accounts Receivable and Payable, Sales (income), Rent, Software, Contractors (expenses), Owner's Draw (equity). Add the illustrator as a vendor and track payments for 1099 with a W-9.

Record events. For each event, decide the QuickBooks form:

  • Events 1 and 7: Invoice.
  • Event 2: Receive payment applied to invoice 2001, then Bank deposit (or an automatic deposit if you skip Undeposited Funds).
  • Event 3: Bill. Event 5: Pay bills.
  • Event 4: Expense against the card account. (The card is not paid this month, so it remains a liability.)
  • Event 6: Expense or Check to the contractor, categorized as Contractors.
  • Event 8: a Transfer or Expense to the Owner's Draw equity account, never an expense.

Bank rules. Create a rule for the software subscription (description contains the vendor name, money out, category Software) with auto-add off, and a rule for card payments to transfer.

Reconcile and report. Reconcile the checking account to a statement that shows the cleared items, then run the P&L and balance sheet for March, and the A/R aging as of Mar 31.

flowchart LR
    A["Invoices 2002, 2003"] --> B["Accounts Receivable"]
    C["Bills and card charges"] --> D["Expenses"]
    E["Receipts and deposits"] --> F["Checking"]
    B --> G["Balance sheet"]
    D --> H["Profit and Loss"]
    F --> G
    H --> G

All events flow into the two statements.

Check your answers with a ledger

Run this stand-in; it posts each event as a balanced entry and prints the March results. Compare them with your QuickBooks reports.

JS Pixel Harbor Studio: March ledger

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Why does the equity line add netIncome? On the balance sheet, current-year profit appears in equity, while the P&L accounts themselves are not equity accounts.

JS A/R aging as of March 31

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Reflection questions

  • Net income is 2,910 but checking fell by 500 over the month. Explain the gap. (Hint: receivables grew, the owner took a draw, and a card charge is unpaid.)
  • What would the P&L look like on a cash basis? Which invoices disappear?
  • Which events need a document from the other party (W-9, bill, statement)?
  • What would you check before setting a closing date for March? See Month-End Close Checklist.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. How should the owner's 1,000 draw be recorded?

    Draws reduce equity; they are not business expenses.
  2. 2. Why is the credit card charge not a reduction of Checking?

    A card charge increases a liability. Checking drops when you pay the card, as a transfer.
  3. 3. On the accrual basis, what is March income?

    Accrual records invoices 2002 and 2003 as earned in March; the 2,500 paid for invoice 2001 was income in an earlier period.
  4. 4. Which report confirms who owes the studio money at March 31?

    A/R aging lists open invoices by customer and days past due.

Summary

  • Match each event to the right QuickBooks form: invoice, payment, bill, expense, transfer.
  • Owner draws are equity, card charges are liabilities, and invoices create receivables.
  • A ledger check (debits equal credits, assets equal liabilities plus equity) validates your work.
  • Reports then tell the story: P&L for performance, balance sheet for position, aging for follow-up.

Next: Project: A Retail Month with Inventory