PDF Financial Statement to Google Sheets

How to get income statements, balance sheets and cash flow statements out of PDF reports and into a spreadsheet

Answer in brief

Annual reports, filings and management accounts publish their financial statements as PDFs. To analyse them, compare years or build a model, you need the figures in a spreadsheet. Converting a PDF financial statement to Google Sheets turns each line item and each year's figure into rows and columns you can calculate with.

The Convert PDF to Google Sheets™ add-on by Easy Image to Text does this inside Google Sheets: upload the report, pick the statement pages, and the tables are written straight into your sheet.

Why financial statements are tricky to convert

  • Several figure columns. Most statements show the current year next to one or more prior years, and sometimes a notes column as well.
  • Indented line items and subtotals. The structure is shown by indentation and bold totals, which a plain copy loses.
  • Negatives in brackets. Losses and outflows are usually printed as (1,234) rather than -1,234.
  • Dashes for zero. A dash often means nil, which spreadsheets can't treat as a number.
  • Units in the header. Figures are often in thousands or millions, stated once at the top of the table.
  • Long documents. The statements may be a few pages inside a report of a hundred pages or more.

For how extraction rebuilds the table structure in general, see PDF table extraction.

For the pros and cons of each conversion route, see PDF to Google Sheets conversion methods.

How to convert a financial statement PDF to Google Sheets

  1. Install the Convert PDF to Google Sheets™ add-on from the Google Workspace Marketplace.
  2. Open a Google Sheet and launch the add-on from the Extensions menu.
  3. Upload the report PDF. Use its table of contents to find the pages with the income statement, balance sheet and cash flow statement.
  4. Select just those pages, up to 5 at a time.
  5. Click Extract Data. Each page is written to its own sheet, usually within 10 to 40 seconds.

Each successfully extracted page uses 1 credit, so picking only the statement pages keeps the cost low. For more on long reports, see multi-page PDF to Google Sheets. Older reports that were scanned from paper work too; see scanned PDF to Google Sheets.

What you get in the sheet

Each line item becomes a row, and each year or period becomes its own column, following the statement's headers. Figures are written as plain text, exactly as printed, so brackets, dashes and footnote markers are kept rather than guessed at.

Indentation and bold formatting are not copied, so subtotal rows such as Gross profit or Total current assets appear as ordinary rows. Keep this in mind when you add up a column, so that you don't count the same amounts twice.

Turning the figures into numbers

To calculate with the figures, convert them to numbers in a helper column. This formula turns brackets into minus signs, removes thousands separators, and treats a dash as zero:

=IFERROR(VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2, "(", "-"), ")", ""), ",", "")), 0)

Fill it down next to each figure column. It assumes commas are used as thousands separators. If your report uses commas for decimals, adjust it first. Because the formula also turns any unreadable value into zero, scan the results for unexpected zeros.

If the statement says figures are in thousands or millions, multiply by 1,000 or 1,000,000 when you need full amounts, or simply note the unit in your column header.

Checking the converted statements

Financial statements have built-in checks:

  • Balance sheet: total assets should equal total liabilities plus equity.
  • Income statement: recompute the subtotals, such as gross profit and operating profit, from the lines above them.
  • Cash flow statement: opening cash plus the net change in cash should equal closing cash.

If a check fails, compare the rows around the difference with the PDF, especially where a line item wraps onto two lines or a table continues on the next page.

What people use converted statements for

  • Financial analysis: calculating margins, growth rates and ratios.
  • Comparing companies or years: putting several reports side by side in one sheet.
  • Building models: using historical figures as the starting point for forecasts.
  • Audit and due diligence: checking figures and tracing them through the statements.
  • Lending decisions: reviewing a borrower's results and balance sheet.

Looking for transaction lists rather than company accounts? See PDF bank statement to Google Sheets.

Frequently asked questions

Which financial statements can I convert?

Any statement laid out as a table, including income statements, balance sheets, cash flow statements, statements of changes in equity and the tables in the notes.

Are negative figures in brackets kept?

Yes. Figures are written exactly as printed, including brackets. Use a helper formula to turn them into negative numbers when you need to calculate.

Will comparative years stay in separate columns?

Yes. Each year or period shown in the statement becomes its own column, using the statement's own headers.

Do I have to convert the whole annual report?

No. Select only the pages with the statements you need, up to 5 per run. Each successfully extracted page uses 1 credit.

Does it work with scanned or older reports?

Yes. Scanned PDFs work too. Clear, straight pages give the most accurate results.

Is the indentation of line items kept?

No. The rows and columns are kept, but visual formatting such as indentation and bold totals is not copied.

Ready to analyse the numbers instead of retyping them? Try the Convert PDF to Google Sheets™ add-on by Easy Image to Text: install it free from the Google Workspace Marketplace, or learn more about PDF to Google Sheets conversion.

Last updated: 2026-11-09