Reading a GL Extract: Literacy Before Formulas | Excel & Power BI S1 Ep2

📂 Download the AtlasParts dataset (used across all 12 episodes): https://github.com/GoCelesteAI/excel-powerbi-for-finance Episode Two of *Excel & Power BI for Finance* — and the first episode where we open the actual file. No formulas yet. No pivot tables. Before any of that, you have to be able to *read* a general-ledger extract. You open the gl_journal.csv file your ERP just produced. There are twenty-two thousand rows. Each row has a date, a four-digit account code, two columns of dollar amounts called Debit and Credit, a terse description, and a reference like SO-01284 or REC-RENT-04. Where do you start? Most "Excel for finance" tutorials skip this question entirely. They jump straight to SUMIFS and pivots, assuming you already know what you're looking at. We don't skip it. The half-step that separates a junior analyst from someone who knows what they're doing is being able to look at any row, any journal entry, and tell a coherent story about what happened in the business. We work through real journal entries from AtlasParts Corp's fiscal year 2025: the opening balance sheet, a sales transaction (SO-01284 to customer CUST-007), the cost-of-goods-sold mirror entry, a recurring monthly rent payment. We cover the rule that explains everything — every journal entry's debits and credits sum to zero, always — and the trial balance check that tells you whether the file you've been given is honest. By the end you can read any line of any GL extract from any ERP, anywhere in the world. What You'll Learn: - The nine-column shape every GL extract has: journal_id, line_id, posting_date, account_id, debit, credit, description, source_doc, cost_center - Double-entry bookkeeping — the rule that every journal entry's debits equal its credits, the same idea Italian merchants invented in the fifteenth century - The unit of meaning is the *journal entry*, not the row — a single row by itself is half a sentence - How to read a real opening-balance entry and explain what the company owns, owes, and has earned - How a sales transaction produces TWO journal entries — one for revenue, one for cost — and why you always read them as a pair - The chart of accounts: 1xxx assets, 2xxx liabilities, 3xxx equity, 4xxx revenue, 5xxx COGS, 6xxx-7xxx OpEx, 8xxx-9xxx other - The trial balance — the most basic sanity check in accounting, and what to do if it fails - The source-doc column — how SO/INV/REC tags connect every GL line back to the original business event and form your audit trail Timestamps: 0:00 - Intro — Reading a GL Extract 0:30 - What's in this episode 0:58 - The empty grid — 22,000 rows, no idea where to start 1:48 - The shape of every row — nine columns 2:58 - Double-entry: every journal entry balances 3:58 - Worked example — the opening balance sheet 5:08 - Worked example — a sales transaction (and its cost-side mirror) 6:18 - The chart of accounts — what those four-digit codes mean 7:23 - The trial balance — proof the file is honest 8:13 - Source documents — the breadcrumbs back to the business 9:08 - Recap — three takeaways 9:45 - Up next · Episode 3 Key Takeaways: 1. The unit of meaning in a GL extract is the journal entry, not the row. A single row is half a sentence; you read by `journal_id`. Once that clicks, the file stops looking like noise and starts looking like a sequence of business events. 2. Every journal entry balances. Debits equal credits. Always. If a journal entry doesn't balance, the file is broken; if the whole file's debits and credits don't match to the cent, stop before doing any analysis. 3. Source documents connect the GL back to the business. SO-, INV-, REC-PAY-, REC-RENT-, JE-OPEN- are the patterns. Once you know them, you can scan a thousand rows and tell which are sales, vendor payments, or monthly accruals. No source doc, no audit defense. 4. A sales transaction usually produces two journal entries — one for revenue (debit AR, credit Sales) and one for cost (debit COGS, credit Inventory). Read them as a pair. 5. The chart of accounts is structured the same way everywhere — 1xxx assets, 2xxx liabilities, 3xxx equity, 4xxx revenue, 5xxx COGS, 6xxx-7xxx OpEx. Once you've read one chart of accounts, you can read any of them. Next episode: *Lookups for Finance.* SUMIFS, XLOOKUP, INDEX/MATCH. We finally write a formula and turn 22,000 rows of journal lines into a one-page P&L by product category and customer country. Taught by CelesteAI. #exceltutorial #powerbi #financetraining #financeprofessionals #generalledger #doubleentry #financialreporting #financemodels #excelforaccountants #powerbiforbeginners #cfo #excelandpowerbi #excelforfinance #financialanalysis #atlasparts #glextract #trialbalance