Statement Types and Extracted Structure
Financial statements come in three primary forms, each with different structural requirements. Zera Books handles all three and preserves the hierarchical structure that makes them useful for analysis — not just the raw numbers.
| Statement Type | Key Fields Extracted | Structural Notes |
|---|---|---|
| Profit & Loss (Income Statement) | Revenue categories, cost of goods, gross profit, operating expenses by category, EBITDA, net income | Section hierarchy preserved (Revenue → Gross Profit → Operating → Net). Subtotals flagged with row type indicator. |
| Balance Sheet | Current assets, long-term assets, current liabilities, long-term liabilities, equity accounts, totals per category | Assets / Liabilities / Equity section separation maintained. Account codes extracted where present. |
| Cash Flow Statement | Operating activities, investing activities, financing activities, net change, opening/closing cash position | Activity type preserved as separate column. Inflows and outflows maintained with sign convention. |
| Trial Balance | Account code, account name, debit balance, credit balance, net balance | Debit and credit columns maintained separately. Zero balances included. |
Multi-Period Comparative Format Handling
Comparative financial statements present 6, 12, or more periods across the top as columns — a format that most generic PDF extractors flatten incorrectly. Zera Books identifies column boundaries from the header row and maintains each period's values as a separate data column in the output.
A 12-month P&L with revenue and 40 expense categories becomes a clean spreadsheet with 40 rows and 12 numeric columns — not a single jumbled column of 480 mixed values.
Monthly Comparatives
12-column monthly P&L reports extracted with each month as a separate data column. Period labels extracted from header row as column names.
Year-over-Year
Comparative reports showing current year vs prior year extracted with correct period attribution. Variance columns (where present) extracted as separate columns.
Budget vs Actual
Budget and actual columns extracted separately, with budget amounts and actual amounts in distinct output columns. Variance percentages extracted where shown.
Year-to-Date
YTD summaries alongside period columns extracted correctly. Cumulative and period columns distinguished by header label.
Financial statements extracted. Analysis-ready.
P&L, balance sheets, and cash flow reports converted to structured Excel — with hierarchy and multi-period columns preserved. Part of the $79/month unlimited plan.
Try for one weekCommon Use Cases for Financial Statement Extraction
Financial statement extraction serves different needs than bank statement conversion. The most common workflows:
Who Extracts Financial Statements and Why
Output Formats
Financial statement data is output in formats designed for analysis, not just import. Unlike bank statements that have a clear import target (QuickBooks, Xero), financial statement data is often used in Excel models, reporting tools, or working paper templates.
Excel (XLSX) — Primary Output
Structured rows with account name, account code, row type (header/detail/subtotal/total), and one column per period. Formatting preserved for readability.
CSV — For Data Pipelines
Clean CSV with consistent column names. Useful for feeding financial data into analysis pipelines, BI tools, or custom import scripts. See PDF to CSV specs.
Note on accounting software import: Financial statement data extracted by Zera Books is primarily for analysis and reporting — not for journal entry import. For entering historical financial data into QuickBooks or Xero, use the Excel output as a source for manual journal entries or consult the import guides.
Frequently Asked Questions
What types of financial statements does Zera Books process?
P&L (income statements), balance sheets, cash flow statements, and trial balances. Single-period and multi-period comparative formats both handled. See zerabooks.com/products/financial-statements.
Can Zera Books handle multi-column comparative statements?
Yes. Monthly, quarterly, and annual comparative formats with up to 24 columns are handled. Each period's values are extracted as a separate column in the output.
Does Zera Books extract account codes?
Yes, where present in the source document. Account codes are extracted as a separate field alongside the account name. If codes are absent, account names are extracted and can be mapped to codes in your accounting software.
Are financial statement outputs suitable for QuickBooks import?
The Excel/CSV output is designed for analysis and reporting. For QuickBooks or Xero import, use the extracted data as a source for journal entries. See import guides for step-by-step instructions.