Unit 1: Smart Ledger Launch
Your team represents a startup seeking angel investment. Investors will scrutinize your financial controls before writing a check. You must build a self-auditing ledger system that demonstrates you can maintain "clean books" from day one. The primary deliverable is a 4-minute investor pitch and a live Excel workbook demo showing self-auditing features.
Early-stage startup bookkeeping is often chaotic and unsustainable, creating significant business risk. This unit is designed to teach founders the importance of building a trustworthy, organized financial system ('clean books') from day one. This isn't just for investors or accountants; it's a critical tool for founders to gain clarity on their financial health, make decisions based on facts, and build confidence in their venture.
- ▶Create a professional Excel Table from manual transaction data
- ▶Build a clean, readable Excel workbook structure ready for formulas
- ▶Build SUMIF formulas to calculate account totals automatically
- ▶Create debit/credit balance checks that flag out-of-balance states
Accounting Equation
The fundamental relationship Assets = Liabilities + Equity that must always balance in double-entry bookkeeping.
Assets
Resources owned by a business that have future economic value, such as cash, equipment, or inventory.
Liabilities
Amounts a business owes to outside parties, such as loans, accounts payable, or unpaid taxes.
Owner's Equity
The owner's residual claim on business assets after all liabilities are paid; also called net worth or capital.
Debits and Credits
The two sides of every journal entry. Debits increase assets and expenses; credits increase liabilities, equity, and revenue.
Double-Entry Bookkeeping
A system where every transaction is recorded with equal debits and credits, keeping the accounting equation in balance.
Journal Entry
A record of a business transaction showing which accounts are debited and credited and by what amounts.
Ledger
A complete record of all financial transactions organized by account, used to prepare financial statements.
Trial Balance
A report listing all ledger account balances to verify that total debits equal total credits.
Chart of Accounts
An organized list of all accounts used by a business, each with a unique number and category.
T-Account
A visual tool shaped like a 'T' used to analyze debits on the left side and credits on the right side of an account.
Revenue
Money earned from selling goods or services before any expenses are subtracted.
Expenses
Costs incurred in the process of earning revenue, such as rent, wages, or supplies.
Conditional Formatting
An Excel feature that automatically changes cell appearance based on rules, such as highlighting values above a threshold.
SUMIF
An Excel function that adds cells meeting a single criterion, such as summing all debits for a specific account.
XLOOKUP
An Excel function that searches a range for a value and returns a corresponding result from another range, replacing VLOOKUP.
IFERROR
An Excel function that returns a custom result when a formula produces an error, such as showing 'Not Found' instead of #N/A.
Data Validation
An Excel feature that restricts what users can enter into a cell, such as limiting entries to a dropdown list or a number range.
Audit
An independent examination of financial records and systems to verify accuracy and compliance with standards.
Excel Table
A structured range of data in Excel with named columns, auto-expanding formulas, and built-in formatting.
Accounting Period
A defined span of time for which financial records are kept and reports are prepared, such as a month, quarter, or year.
SUMIFS
An Excel function that adds cells meeting multiple criteria, such as summing expenses for a specific department and month.
Study these terms
These 22 terms appear across this unit. Use the bilingual glossary to review them, or start a vocabulary study session to practice with flashcards, matching, and speed round.
Practice this unit's vocabulary with flashcards, a matching game, or a timed speed round. Your progress is tracked locally and can be exported.
4-minute investor pitch with live Excel demo
Ready for a confidence check? Run the Unit 1 practice test to rehearse investor questions, pull randomized items from every lesson, and track progress with built-in explanations.
Tip: Finish Lesson 10 first so you can apply Sarah's audit trail strategies while you review answers.