Schema CPA
BlogSign inStart free

Ledgers and financial statements

This category covers the ledgers and statements that write-up, review and audit work runs on. Posts explain how to read a general ledger, how it differs from a trial balance, how to get both out of PDFs and QuickBooks into Excel, trial balance import and mapping, adjusting entries, financial statement extraction and spreading, and what to check when a balance sheet does not tie to the trial balance. Bank statements have their own category. Start with "General Ledger to Excel: Every Format Clients Send", which covers each file a client sends and how to turn it into a usable workbook.

  1. General Ledger to Excel: Every Format Clients Send

    How to get a client's general ledger to Excel from a PDF, a software export or a scan, with one row per posting and totals that match the source report.

    October 16, 2026general ledgerexcelpdf

  2. Trial Balance Mapping: Accounts to Statement Lines

    Trial balance mapping explained: grouping each client account into a statement line or tax line, building a reusable map, and catching unmapped accounts.

    October 16, 2026trial balancemappingexcel

  3. Cash Flow Statement From a Trial Balance, Step by Step

    Prepare a cash flow statement from a trial balance: two year-end balances, operating, investing and financing changes, and a proof cell that ties to cash.

    October 16, 2026cash flowtrial balanceexcel

  4. Multi Step Income Statement Excel Template, Row by Row

    Build a multi step income statement in Excel: gross profit, operating income and other income rows, margin formulas, and step codes on the trial balance map.

    October 15, 2026income statementexcelgross profit

  5. Balance Sheet Does Not Tie to Trial Balance? Find Why

    Why a balance sheet does not tie to the trial balance: date and basis mismatches, current-year earnings, unmapped accounts and late entries, checked in order.

    October 15, 2026balance sheettrial balancetie-out

  6. Client-Prepared Financial Statements Review, Step by Step

    How to approach a client-prepared financial statements review: tie to the ledger, test key balances, scan for omissions and document what you relied on.

    October 15, 2026financial statementsreviewgeneral ledger

  7. Trial Balance Import: From Client File to Workpapers

    Trial balance import from a client's export or PDF into Excel and workpaper tools: the columns an import needs, sign rules, and the checks to run after.

    October 15, 2026trial balanceexcelworkpapers

  8. QuickBooks Working Trial Balance in Desktop, Explained

    The QuickBooks working trial balance in Desktop: where it lives, its beginning, adjustment and ending columns, and how to post adjusting entries from it.

    October 15, 2026quickbooks desktoptrial balanceadjusting entries

  9. Trial Balance in Excel for Review Engagements

    Build a trial balance in Excel for review engagements: unadjusted, adjustment and adjusted columns, prior-year variance, tickmarks and lead sheet tabs.

    October 15, 2026exceltrial balancereview engagements

  10. Balance Sheet to Excel From a PDF or Software Report

    How to get a balance sheet to Excel from a PDF, a scan or a software report: keep the line hierarchy, the subtotals and the period columns intact.

    October 15, 2026balance sheetexcelpdf conversion

  11. Financial Statement Extraction Into Structured Rows

    Financial statement extraction turns statement pages into labeled rows: line items, periods, subtotals and the checks that prove every extracted figure.

    October 15, 2026financial statementsextractionexcel

  12. Trial Balance to Balance Sheet Excel Workbook, Step by Step

    Turn a trial balance to a balance sheet in Excel with SUMIFS on a mapping column, a retained earnings roll and a check cell that proves the sheet balances.

    October 14, 2026trial balancebalance sheetexcel

  13. Classified Balance Sheet Excel Layout, Current to Long-Term

    Lay out a classified balance sheet in Excel: current and long-term sections, the current portion of debt, working capital and subtotals from the trial balance.

    October 14, 2026balance sheetexcelworking capital

  14. Adjusting Journal Entries and the Trial Balance

    How adjusting journal entries change the trial balance: accruals, deferrals and depreciation, an adjusted column, and an entry log the client can post.

    October 14, 2026adjusting entriestrial balanceyear end

  15. Personal Financial Statement Excel Layout for Lenders

    Prepare a personal financial statement in Excel for a lender: asset and liability schedules, net worth, guarantees, and the statement behind each figure.

    October 14, 2026personal financial statementlendersexcel

  16. Retained Earnings Does Not Match Prior Year? Trace It

    Why opening retained earnings does not match the prior year: late postings, unposted adjustments, draws and conversions, traced with a rollforward table.

    October 12, 2026retained earningsequityyear end

  17. Trial Balance Software for Accounting Firms: What to Ask

    What trial balance software should do for an accounting firm: import, mapping, adjusting entries, prior-year rollforward, lead sheets and Excel output.

    September 15, 2026trial balancesoftwareworkpapers

  18. Income Statement to Excel With Periods and Subtotals

    Move an income statement to Excel from a PDF or report export: monthly and year-to-date columns, signs for expenses, subtotals and a net income check.

    September 5, 2026income statementexcelprofit and loss

  19. Financial Spreading Software or a Spreadsheet?

    Financial spreading software compared with spreading in a spreadsheet: standard templates, multi-period input, ratios, loan files and when each one fits.

    September 5, 2026financial statementslendingratios

  20. QuickBooks Trial Balance: Running and Exporting It

    How to run a QuickBooks trial balance in Online, set the dates and accounting basis, add a comparative column and export the report cleanly to Excel.

    July 31, 2026quickbooks onlinetrial balanceexcel

  21. How to Read a General Ledger, Account by Account

    How to read a general ledger report: account headers, beginning balances, debits and credits, running balances and the source columns that trace each entry.

    July 11, 2026general ledgerbookkeepingreview

  22. Write-Up Work Automation: What Software Can Take Over

    Write-up work automation for firms: which steps of monthly write-up software can take over, from reading statements to ledgers, and what still needs review.

    May 21, 2026write-upbookkeepingautomation

  23. Multi-Year Financial Statement Comparison in Excel

    Build a multi-year financial statement comparison in Excel: align line items across years, add dollar and percent change, and flag the swings worth a question.

    May 6, 2026financial statementsexcelanalysis

  24. Financial Statement OCR vs Retyping: Accuracy and Effort

    Financial statement OCR compared with retyping a scanned statement: where OCR misreads, which pages it handles well, and how to verify the figures it reads.

    January 8, 2026ocrfinancial statementsdata entry

  25. Trial Balance vs General Ledger: What Each Report Shows

    Trial balance vs general ledger compared: one shows every posting, the other one balance per account, and which one to ask a client for in each engagement.

    December 5, 2025trial balancegeneral ledgerengagements