How to Import PDF Invoices into Wave Accounting

Wave has no native PDF invoice import. Learn how to extract supplier invoice data from PDFs and import it into Wave using Wave Connect or manual entry.

Published
Updated
Reading Time
10 min
Topics:
Software IntegrationsWavePDF conversionsupplier invoice import

Wave does not have a native way to import PDF invoices. Its receipt scanning feature is designed for expense receipts, not supplier bills, and its transaction import tools pull in bank feeds rather than invoice data. If you need to import PDF invoices into Wave, the practical path is to extract the invoice data into a spreadsheet using an AI extraction tool, then bring that data into Wave through Wave Connect or manual bill creation.

That workaround matters more than it might sound. U.S. small business owners spend an average of 22 hours a month on financial management, according to a 2026 Xero study. Manually retyping vendor names, invoice numbers, line items, and totals from PDF supplier invoices is one of the most time-consuming parts of that load. If you process invoices from even a handful of vendors each month, the hours add up fast.

Wave users tend to be cost-conscious by nature. You picked Wave because it offers real accounting software without a monthly subscription, and any solution to this PDF invoice gap should respect that same logic. You shouldn't need an enterprise accounts payable platform with a four-figure annual contract just to stop retyping data from supplier PDFs into your small business bookkeeping workflow.


What Wave Receipt Scanning, Wave Connect, and Transaction Imports Actually Do

Wave offers three ways to bring external financial data into your books. Each one solves a real problem, but none of them do what you actually need: take a PDF supplier invoice and turn it into a structured bill entry. Here is what each feature does and where it stops.

Receipt Scanning

Wave's receipt scanning is a paid add-on ($8/month) that uses OCR to read photos or uploaded images of receipts and create expense transactions. The key word is expense. Receipt scanning records what you already spent. You snap a photo of a coffee shop receipt or an office supply purchase, and Wave pulls the vendor, amount, and date into an expense entry.

A supplier invoice is not a receipt. When a vendor sends you a PDF invoice for $4,200 in consulting services due in 30 days, that is a payable, not an expense you have already paid. Receipt scanning sits on the wrong side of the accounting workflow entirely. It captures backward-looking spend confirmation, not forward-looking obligations. Even if you upload a supplier invoice PDF to the receipt scanner, you will get an expense transaction instead of a bill entry, with no line-item detail, no due date tracking, and no accounts payable record.

Wave Connect

Wave Connect is a Google Sheets add-on that lets you bulk-upload structured data into Wave. It supports customers, products, invoices, transactions, and journal entries. For getting large volumes of data into Wave without clicking through forms one by one, it is genuinely useful.

The limitation is straightforward: Wave Connect requires data that is already organized into spreadsheet columns. It cannot read a PDF. It cannot parse an invoice image. It has no OCR capability. You need to hand it clean, formatted rows with the right column headers before it can do anything.

This matters because Wave Connect is actually the right import mechanism for supplier invoice data once that data is structured. If you had a spreadsheet with vendor names, invoice numbers, line items, amounts, and due dates, Wave Connect could push that into your books. The feature itself is not the bottleneck. The missing step is everything that happens before Wave Connect: extracting structured data from the raw PDF.

Transaction Imports

Wave connects to your bank and credit card accounts to pull in transaction feeds automatically. You can also manually upload OFX, QFX, or QBO files exported from your financial institution. These imports exist for bank reconciliation, matching transactions that have already cleared your accounts against entries in your books.

Transaction imports deal with bank-side data: dates, amounts, and payee names as your bank records them. They carry no invoice numbers, no line-item breakdowns, no payment terms, and no vendor bill references. Importing a bank feed tells you that $4,200 left your account on March 15. It does not tell you which supplier invoice that payment covered, what the line items were, or whether the amount matched what was billed.

The Actual Gap

None of these three features perform Wave invoice OCR on a supplier PDF. The gap is specific: there is no built-in path from a PDF supplier invoice to a structured bill entry in Wave. Receipt scanning captures the wrong document type. Transaction imports capture the wrong data layer. Wave Connect can handle the import, but only after the PDF data has been extracted into structured columns first.


How to Extract Supplier Invoice Data from PDFs

Before anything reaches Wave, your supplier invoices need to be converted from static PDFs into a structured spreadsheet — either Excel (.xlsx) or CSV (.csv). That structured file is what Wave Connect will consume in the import step. AI-powered extraction has made this conversion fast, accurate, and affordable enough for freelancers and small teams.

The workflow is three steps:

  1. Upload your PDFs. Drag in a single invoice or a batch of up to 6,000 mixed-format files (PDF, JPG, PNG scans). If a supplier emails you a 30-page PDF containing multiple invoices, the tool handles that too.
  2. Tell the AI what to extract. Write a plain-language prompt describing the fields you need. No templates to configure, no field-mapping UI to wrestle with.
  3. Download the spreadsheet. You get a clean Excel or CSV file with one row per invoice, values correctly typed, and a source reference back to the original file and page number for verification.

A prompt tailored for Wave bill entry might look like this:

"Extract invoice number, invoice date, vendor name, net amount, tax, total. One row per invoice."

Those six fields map directly to what you'd fill in manually on Wave's bill-entry screen. The AI reads each PDF — whether it's a native digital document or a scanned image — and pulls the relevant values into the columns you specified.

Saving prompts for recurring vendors

Most small businesses receive invoices from the same handful of suppliers month after month. Those invoices rarely change format. With a platform like Invoice Data Extraction, you can extract invoice data from PDFs automatically and save the prompt to a prompt library for reuse. Set up the extraction prompt once for a vendor like your web hosting provider or your wholesale supplier, and every future batch from that vendor is upload-and-go — no re-configuration needed.

If you're evaluating free invoice scanning tools for small businesses, this is worth noting: many OCR tools force you to reconfigure extraction templates for every document layout. A prompt-based approach adapts to any invoice format with a single reusable instruction.

Invoice Data Extraction includes 50 free pages per month with no credit card or subscription required. Additional credits are pay-as-you-go, and the cost per page drops with larger bundles. For a freelancer processing 10 to 20 supplier invoices monthly, the free tier alone covers the workflow.


Importing the Extracted Data into Wave

With structured invoice data in a spreadsheet, the final step is getting it into Wave as recorded bills. You have two paths: Wave Connect for batch imports, or manual entry using the spreadsheet as your reference. Choose based on volume.

The Wave Connect Import Path

Wave Connect bridges Google Sheets and your Wave account, letting you push structured data directly into Wave without re-keying anything. Here is the step-by-step process:

1. Prepare your extracted file. Open the Excel or CSV output from the extraction step. Verify that each row represents one invoice and that your columns include invoice number, date, vendor name, amount, tax, and total. Fix any obvious extraction errors now — it is far easier to correct a cell in a spreadsheet than to edit a bill inside Wave after import.

2. Upload to Google Sheets. Wave Connect operates through Google Sheets, so you need your data there. In Google Sheets, go to File > Import, upload your CSV or Excel file, and select Replace spreadsheet. Confirm that dates, currencies, and numbers rendered correctly — CSV imports occasionally misformat date columns depending on your locale settings.

3. Map columns to Wave Connect's required format. Wave Connect expects a specific column structure. Your extracted data likely will not match it exactly out of the box. Rename column headers to match Wave Connect's expected fields, and rearrange columns if needed. Common adjustments:

  • Renaming "Vendor" to "Contact Name"
  • Splitting a combined tax column into the tax rate and tax amount fields Wave expects
  • Ensuring dates follow the format Wave Connect requires (typically YYYY-MM-DD)

If you are unsure of the exact column names, open Wave Connect in Google Sheets and generate a blank Bills template from the add-on. That template shows the required headers you need to match. This mapping step takes a few minutes the first time. Save the formatted sheet as a template for future imports.

4. Push data into Wave via Wave Connect. Open the Wave Connect add-on in Google Sheets, authenticate with your Wave account, select your business, and choose the Bills import type. Map your sheet columns to the corresponding Wave fields, then execute the import. Wave Connect will create bill entries in your account for each row.

Review the imported bills in Wave under Purchases > Bills to confirm totals and vendor details match your source PDFs.

Manual Entry from the Spreadsheet

If you process only a handful of supplier invoices each month, Wave Connect invoice data import may be more setup than it is worth. The extracted spreadsheet still eliminates the core problem: you are no longer squinting at PDF layouts trying to locate line items, tax amounts, and invoice numbers.

Open the spreadsheet alongside Wave. For each row, create a new bill in Purchases > Bills, copying the structured values directly. Reading from organized columns is substantially faster and more accurate than interpreting each PDF individually. For five or fewer invoices a month, this manual path is perfectly practical.

Making This a Recurring Workflow

Most supplier invoices arrive on a predictable cycle. Once you have run through this process once, it becomes a standard monthly routine:

  1. Collect the month's PDF supplier invoices in a single folder
  2. Batch extract using a saved prompt to produce a consolidated spreadsheet
  3. Upload the spreadsheet to Google Sheets
  4. Run Wave Connect to import bills into Wave

The extraction step handles the heavy lifting — identifying vendors, parsing line items, matching totals. The Wave import becomes repetitive and quick. Save your Google Sheets column template so you skip the mapping step entirely on repeat runs. If you also manage clients on other platforms, the same extraction-to-import approach applies to importing invoices into FreshBooks and other accounting tools — only the final import step changes.

For Wave specifically, the combination of a free extraction tier and free accounting software means you can run this entire workflow at zero cost for typical small business invoice volumes.

About the author

DH

David Harding

Founder, Invoice Data Extraction

David Harding is the founder of Invoice Data Extraction and a software developer with experience building finance-related systems. He oversees the product and the site's editorial process, with a focus on practical invoice workflows, document automation, and software-specific processing guidance.

Editorial process

This page is reviewed as part of Invoice Data Extraction's editorial process.

If this page discusses tax, legal, or regulatory requirements, treat it as general information only and confirm current requirements with official guidance before acting. The updated date shown above is the latest editorial review date for this page.

Continue Reading

Extract invoice data to Excel with natural language prompts

Upload your invoices, describe what you need in plain language, and download clean, structured spreadsheets. No templates, no complex configuration.

Exceptional accuracy on financial documents
1–8 seconds per page with parallel processing
50 free pages every month — no subscription
Any document layout, language, or scan quality
Native Excel types — numbers, dates, currencies
Files encrypted and auto-deleted within 24 hours