7-2 Project: Company Accounting Workbook And Summary Report

Mastering the 7-2 Project: Building a Company Accounting Workbook and Summary Report

The 7-2 project is a cornerstone experiential learning task in many accounting and business curricula, designed to bridge the gap between theoretical knowledge and practical application. At its core, this project requires students to simulate the complete accounting cycle for a fictional or model company over a specific period, typically a month or a quarter. The deliverable is twofold: a meticulously detailed company accounting workbook and a synthesized summary report. The workbook serves as the raw, transactional engine, recording every financial event, while the summary report interprets this data, presenting the final financial statements and providing crucial analysis. Successfully completing this project is not merely an academic exercise; it is a foundational simulation of the real-world responsibilities of an accountant, bookkeeper, or financial analyst, demanding precision, logical sequencing, and clear communication.

The Anatomy of the Accounting Workbook: Your Digital Ledger

The accounting workbook is the project's heart, usually created in a spreadsheet program like Microsoft Excel or Google Sheets. It is a structured collection of tabs or sheets, each representing a specific step in the accounting cycle. Its integrity is paramount; errors here cascade into the final report.

Step 1: Chart of Accounts and Initial Setup

Before any transaction is recorded, you must establish the Chart of Accounts (COA). This is a categorized list of all accounts the company uses, typically organized as:

• Assets (Cash, Accounts Receivable, Inventory, Equipment)
• Liabilities (Accounts Payable, Notes Payable)
• Equity (Common Stock, Retained Earnings)
• Revenues (Sales Revenue, Service Revenue)
• Expenses (Rent Expense, Salaries Expense, Utilities Expense)

Each account is assigned a unique number (e.g., 101 for Cash, 201 for Accounts Payable) and a type (Asset, Liability, etc.). This numbering system is critical for organizing the general ledger, which is the complete record of all account activity. Your workbook’s first tab should be this clearly formatted COA.

Step 2: Recording Transactions in the Journal

Using a list of provided business transactions (e.g., "Purchased inventory on account for $5,000," "Paid $1,200 for December rent"), you record each event as a journal entry. This is the book of original entry. For every transaction, you apply the double-entry accounting system: total debits must equal total credits. Your journal entries should include the date, accounts debited and credited, amounts, and a brief description. This step requires understanding which accounts are affected and whether they increase (debit or credit) based on their normal balance.

Step 3: Posting to the General Ledger

Once journalized, each entry is posted to the corresponding individual accounts in the general ledger. This involves transferring the debit and credit information from the journal to the T-accounts or ledger pages for each specific account (e.g., Cash, Accounts Receivable). The running balance after each posting must be calculated. This step consolidates all activity for a single account in one place, providing a continuous balance.

Step 4: The Unadjusted Trial Balance

At the end of the accounting period (e.g., month-end), you prepare an Unadjusted Trial Balance. This is a list of all ledger accounts with their ending balances, separated into debit and credit columns. The primary purpose is to prove that total debits still equal total credits before any adjusting entries are made. If they don’t balance, you must return to your journal and ledger to find and correct errors—a critical debugging process.

Step 5: Recording and Posting Adjusting Entries

This is where accrual accounting principles are applied. Adjusting entries ensure that revenues are recorded in the period they are earned and expenses in the period they are incurred, regardless of cash flow. Common types include:

• Accrued Revenues: Revenue earned but not yet billed (e.g., services performed on account).
• Accrued Expenses: Expenses incurred but not yet paid (e.g., wages owed at month-end).
• Prepaid Expenses: Assets paid for in advance that are now being used up (e.g., insurance).
• Depreciation: Allocating the cost of a long-term asset (like equipment) over its useful life.
• Unearned Revenue: Cash received before revenue is earned (a liability that decreases as service is performed).

You record these as journal entries and post them to the ledger, just like regular transactions.

Step 6: The Adjusted Trial Balance

After posting all adjusting entries, you prepare a new Adjusted Trial Balance. This list reflects the updated, period-end balances for all accounts. This balance sheet is the direct source for creating the financial statements. At this stage, debits must equal credits. If they do not, the adjusting entries contain errors.

Step 7: Preparing the Financial Statements

From the Adjusted Trial Balance, you prepare the final reports:

1. Income Statement: Lists all revenues and expenses for the period, calculating Net Income or Net Loss. (Revenues - Expenses = Net Income). It covers a period of time.
2. Statement of Retained Earnings: Starts with beginning retained earnings, adds net income (or subtracts net loss), and subtracts dividends to arrive at ending retained earnings.
3. Balance Sheet: Presents the accounting equation: Assets = Liabilities + Equity at a specific point in time. It uses the ending balances from the adjusted trial balance.
4. Statement of Cash Flows (if required): Categorizes cash transactions into Operating, Investing, and Financing activities. This often requires a separate