How to Import Invoice Data into QuickBooks, Xero, or Google Sheets

You've extracted data from your PDF invoices. Now you need to get that data into the software you actually use: QuickBooks, Xero, Google Sheets, or another accounting platform.

Each system has its own import process and format requirements. This guide covers the specific steps for the most popular platforms so you can go from PDF invoice to working data in minutes.

General Workflow

Regardless of your destination software, the process follows the same pattern:

1. Extract invoice data → Get CSV from ConvertMyInvoice
2. Prepare the file → Adjust columns to match your software's requirements
3. Import → Use your software's import function
4. Verify → Check that data imported correctly

The preparation step varies by platform. Some accept CSV files directly; others need specific column names or formats.

Importing to Google Sheets

Google Sheets is the easiest destination—CSV files open directly with no configuration needed.

Method 1: Direct Open

1. Go to Google Drive
2. Click New → File upload
3. Select your CSV file
4. Once uploaded, right-click the file → Open with → Google Sheets

The data appears immediately in spreadsheet form. Each column from the extracted data becomes a column in your sheet.

Method 2: Import into Existing Sheet

1. Open your existing Google Sheet
2. Go to File → Import
3. Click Upload and select your CSV
4. Choose import location:
   • Replace spreadsheet: Overwrites everything
   • Insert new sheet(s): Adds as a new tab
   • Append to current sheet: Adds rows to existing data
5. Click Import data

Formatting Tips for Google Sheets

After import, you may want to:

• Format currency columns (Format → Number → Currency)
• Add filters for sorting (Data → Create a filter)
• Add a totals row with SUM formulas
• Create a pivot table for analysis

Importing to Microsoft Excel

Excel handles CSV imports natively, but formatting sometimes needs attention.

Method 1: Direct Open

1. Locate your CSV file in File Explorer/Finder
2. Double-click to open in Excel
3. If columns look wrong, use Method 2 instead

Method 2: Import with Text Import Wizard

1. Open Excel
2. Go to Data → Get Data → From File → From Text/CSV
3. Select your CSV file
4. In the preview window:
   • Verify delimiter is set to Comma
   • Check that columns look correct
   • Adjust data types if needed (especially for numbers with decimals)
5. Click Load

Handling Number Format Issues

If your invoices use European number formatting (comma as decimal separator), Excel might misinterpret values:

• 1.234,56 (European) might import as text or incorrectly
• Fix by: Data → Text to Columns → Delimited → adjust settings

Importing to QuickBooks Online

QuickBooks Online accepts CSV imports for bills and expenses, though the process requires column mapping.

Preparing Your CSV

QuickBooks expects specific column names. Rename your extracted columns to match:

Add required columns that aren't in the extraction:

• Vendor: The supplier name
• Bill Date: Invoice date
• Due Date: Payment due date
• Bill No: Invoice number

Import Steps

1. Go to Settings (gear icon) → Import Data
2. Select Bills
3. Click Browse and select your prepared CSV
4. Map columns: Match your CSV columns to QuickBooks fields
5. Click Next and review the preview
6. Click Import

After Import

• Verify bill totals match original invoices
• Assign expense accounts/categories if not mapped during import
• Check that vendor names matched existing vendors (or create new ones)

Importing to Xero

Xero's import process works through bank statement or bill import features.

Preparing Your CSV for Xero Bills

Xero requires these columns for bill import:

Import Steps

1. Go to Business → Bills to pay
2. Click Import (or New → Import)
3. Select your prepared CSV file
4. Review the field mapping
5. Fix any errors flagged in preview
6. Click Complete Import

Tips for Xero Import

• Account codes must match your Xero chart of accounts exactly
• Date format must be consistent (YYYY-MM-DD works best)
• Test with a small batch first before importing many bills

Importing to FreshBooks

FreshBooks supports expense import via CSV.

Preparing Your CSV

FreshBooks expects these columns:

Import Steps

1. Go to Expenses
2. Click Import Expenses
3. Download the template to see exact format requirements
4. Map your extracted data to match the template
5. Upload your prepared CSV
6. Review and confirm import

Importing to Wave

Wave offers free accounting software with CSV import capabilities.

Preparing Your CSV

Wave requires:

• Date (YYYY-MM-DD format)
• Description
• Amount
• Account (must match Wave account names)

Import Steps

1. Go to Accounting → Transactions
2. Click Import CSV
3. Select your file
4. Map columns to Wave fields
5. Select the account for imported transactions
6. Review and complete import

Common Import Issues and Solutions

Issue: Numbers Import as Text

Symptoms: Amounts show left-aligned, SUM formulas don't work Solution:

• In Excel/Sheets: Select column → Format as Number
• Before import: Remove currency symbols and extra spaces

Issue: Dates Format Incorrectly

Symptoms: Dates show as numbers or wrong format Solution:

• Standardize to YYYY-MM-DD before import
• Or use your software's date format settings to interpret the format

Issue: Duplicate Imports

Symptoms: Same invoices appear multiple times Solution:

• Check for existing records before import
• Use invoice numbers to identify duplicates
• Some software detects duplicates automatically—review prompts carefully

Issue: Column Mapping Fails

Symptoms: Software can't match columns, or matches incorrectly Solution:

• Rename CSV columns to exactly match expected names
• Remove extra columns software doesn't need
• Check for hidden characters or extra spaces in headers

Best Practices for Regular Imports

Create a Template

Set up a template spreadsheet with:

• Correctly named columns for your software
• Formulas to transform extracted data if needed
• Consistent formatting

Paste extracted data into the template, then export for import.

Batch by Vendor or Period

Rather than importing invoices one at a time:

• Collect a week's or month's worth
• Process all extractions
• Combine into one import file
• Import once with all data

This reduces import overhead and makes reconciliation easier.

Verify After Every Import

Always spot-check imported data:

• Do totals match original invoices?
• Are dates correct?
• Did categories/accounts map properly?

Catching errors immediately is faster than fixing them later during reconciliation.

Frequently Asked Questions

Can I import directly from PDF to my accounting software?

Most accounting software doesn't accept PDF imports directly. You need to extract the data first (PDF → CSV), then import the CSV. ConvertMyInvoice handles the extraction step, giving you CSV files ready for import.

What if my accounting software isn't listed here?

Most accounting platforms support CSV import. Check your software's documentation for:

• Required column names
• Date format requirements
• Import location (usually Settings or a dedicated Import menu)

The general process is the same: prepare your CSV to match requirements, then use the import function.

Do I need to import line items or just invoice totals?

It depends on your needs:

• Line items: Better for expense categorization, detailed reporting, job costing
• Totals only: Faster, simpler, sufficient for basic bookkeeping

For most small businesses, importing totals is adequate. Import line items if you need to categorize expenses at the product level.

How do I handle invoices with multiple tax rates?

Extract the line items first, then add tax information in your spreadsheet before import. Most accounting software lets you specify tax codes per line item during or after import.

Can I automate this import process?

For regular automation, you'd need:

• API access to your accounting software
• A workflow automation tool (Zapier, Make, custom scripts)
• Higher volume needs than the basic process serves

For most businesses, manual batch import weekly or monthly is efficient enough that automation isn't necessary.

Got invoice PDFs that need to reach your accounting software? Start by extracting the data with ConvertMyInvoice. Upload your PDF, download the CSV, and follow the import steps above for your specific platform. Free to use, no account required.