To export to QuickBooks Online from extracted client data, match each file to the QuickBooks import built for it. Bank and card statements go through the bank account's file upload. Sales invoices, journal entries, bills and lists go through Settings, Import data. Receipts go through the Receipts upload. Each door expects its own columns.
Which QuickBooks Online import fits each client document type?
Each client document type has one QuickBooks Online import that fits it. Statements become bank transactions, sales invoices become invoices, ledgers become journal entries, receipts become expenses for review, and contact lists become customers or vendors. A file sent through the wrong door imports badly or not at all.
Intuit's US article Common questions about importing data to QuickBooks Online lists what the Import data screen accepts: bank data, bills, checks, deposits, estimates, expenses, journal entries, purchase orders, sales receipts and time activities, plus lists such as customers, vendors, the chart of accounts and products and services. The routing table below applies that list to the paper a firm actually receives.
| Client document | What to extract | QuickBooks Online import | Where it is covered |
|---|---|---|---|
| Checking or savings statement | Date, description, amount per transaction | Bank transactions, upload from file | Importing bank statements into QuickBooks |
| Credit card statement | Date, description, amount per charge or payment | Bank transactions, upload into the card account | Uploading a credit card statement |
| Client's own sales invoices | Invoice number, customer, dates, line amounts | Import data, Invoices | Importing CSV into QuickBooks |
| Vendor invoices (bills) | Vendor and line details, per the sample file | Import data, Bills (Advanced and higher), or bulk bill upload | QuickBooks receipt capture |
| Receipts | One receipt per file | Receipts upload | Uploading receipts |
| General ledger or trial balance | Journal number, date, account, debit, credit | Import data, Journal Entries | Financial statements and ledgers |
| Customer or vendor list | Display name and contact fields | Import data, Customers or Vendors | Importing CSV into QuickBooks |
Bank statements need one extra decision. The bank upload works from a file of transactions, so a client who sends PDFs raises the question of how those PDFs become that file. Whether a PDF can go in at all, and which route suits each QuickBooks version, is set out in the guide to uploading bank statements to QuickBooks.
Lists and invoices share one screen, Settings then Import data, where you pick the type. The field mapping each type expects, including which columns are required, is covered in which QuickBooks data types accept a CSV import.
Receipts are the exception to the file-of-rows pattern. QuickBooks reads the receipt image itself, so the upload is the document, not a spreadsheet. The upload paths, from the browser to the mobile app to forwarding email, are compared in how to upload receipts to QuickBooks Online.
Exporting extracted data to QuickBooks Online without an integration
Exporting extracted data to QuickBooks Online without an integration means saving it as a CSV or Excel file shaped to one QuickBooks import, then uploading that file inside QuickBooks. Nothing is pushed automatically. Someone at the firm signs in, picks the import, maps the columns and reviews the rows before they post.
That is how Schema CPA fits. Schema CPA does not export to QuickBooks Online directly and has no QuickBooks connection. It exports Excel or CSV, and the CSV goes through QuickBooks' own import screens described here. The workflow section of the homepage shows export as the last step after collection, classification, duplicate checks and statement reconciliation.
A file-based handoff has three parts, whichever tool produced the data:
- Split by destination. One extracted folder can hold statements, invoices and receipts. Each becomes its own file for its own import. A single spreadsheet mixing bank lines and invoice lines fits no QuickBooks import.
- Shape to the import's columns. Bank uploads want date, description and amount. The invoice import wants invoice number, customer, invoice date, due date and item amount on every line. Journal entries want journal number, date, account name, description, debits and credits. Rename and reorder columns to match.
- Respect each import's limits. Intuit's Common questions article says each spreadsheet must have fewer than 1,000 rows and that the first row is used for mapping, not imported. Split large files and keep a header row.
A worked example shows the split. A fictional client, Brookside Dental PLLC, sends a folder for March 2027: two checking statements (accounts ending XXXX-4821 and XXXX-7730), one credit card statement, 14 vendor invoices, 31 receipts and a general ledger export from its previous bookkeeper. All names and counts are made up. The routing produces five uploads: one bank file per checking account, one card file, the receipts uploaded as images, and a journal entry CSV built from the ledger. The vendor invoices go to the bill import if the client is on QuickBooks Online Advanced, or to the bulk bill upload otherwise.
The file-based route takes more hands-on steps, but it leaves a reviewable record. The CSV that went in can be kept beside the engagement, compared with the source PDFs and re-imported if something needs to be undone.
Can you import PDF invoices into QuickBooks Online?
PDF invoices cannot be imported into QuickBooks Online through the invoice import, which reads CSV rows, not PDF documents. The answer depends on whose invoice it is. A client's own sales invoice must be extracted into rows first. A vendor's invoice is a bill, which has its own import and its own upload page.
Sales invoices first. A PDF sales invoice becomes one CSV row per line, with the invoice number, customer and dates repeated on each row, and Intuit's Import multiple invoices at once blocks the import entirely if sales tax is set up. The columns, limits and steps are in the post on importing invoices into QuickBooks from CSV.
Vendor invoices next. The Common questions article says bill imports are restricted to QuickBooks Online Advanced and higher in the US, and points other plans to the upload multiple bills option on the Bills page. Either way, check the vendor names against the client's vendor list first, because a mismatch creates a new vendor.
Receipts are where a PDF goes in as-is. Intuit's Upload your receipts to QuickBooks article accepts PDF, JPEG, JPG, GIF and PNG files, one receipt per file. QuickBooks extracts the data and creates a transaction to review under For review, where it is matched to an existing transaction or added as new.
Before any PDF becomes a row, check what was read. Invoice totals should equal the sum of their lines, dates should fall in the engagement period, and the same invoice number from the same vendor should appear once. More on pulling line items out of invoice PDFs is in the receipts and invoices category.
Ledgers and journal entries in a QuickBooks Online export
Ledgers and trial balances go into QuickBooks Online through the journal entry import. QuickBooks has no separate import for a general ledger or a trial balance file. The data has to be reshaped into journal entry rows: a journal number, a date, an account name, a description, and a debit or credit on each line.
Intuit's US article Import journal entries gives the path: Settings, Import Data, Journal Entries. The required columns are Journal No., Journal Date, Account Name, Journal/Description, Debits and Credits. Lines for Accounts Payable or Accounts Receivable also need a Name column. The article's steps are written for a CSV file.
Three rules from the same article cause most failed journal imports:
- Subaccounts need their parent. Write the account as "Parent account: Sub Account". The subaccount name alone produces a "Line Account Invalid" error.
- Account numbers off. Intuit suggests turning account numbers off before the import and back on afterward.
- Duplicate journal numbers. If "Warn if duplicate journal number is used" is on, entries reusing a number may not import.
Account names in the CSV must match the client's chart of accounts exactly, so the account list comes before the journal file. Exporting it, and using it to map a ledger's account labels to QuickBooks names, is covered in how to export the chart of accounts from QuickBooks.
Which entries a ledger should become, and how balances should be brought forward, is an accounting decision for the firm, not a file-format question. This section covers only the format QuickBooks reads. For reading and checking ledgers and trial balances themselves, see the financial statements and ledgers category.
When exporting to QuickBooks Online should wait
Exporting to QuickBooks Online should wait while the extracted data still has gaps, duplicates or balances that do not tie. An import is hard to reverse. Intuit's Common questions article says imported contacts cannot be undone or deleted in bulk, and its products article says imports cannot be undone. Cleaning the file first is cheaper than cleaning QuickBooks afterward.
Hold the export when any of these is true:
- A month is missing from a run of statements. Importing January, February and April leaves a hole that shows up later as a reconciliation difference.
- Closing and opening balances do not carry. If March's closing balance is not April's opening balance, a page or a statement is missing, or a row was misread.
- The same document appears twice. A vendor invoice forwarded twice, or a statement downloaded and scanned, will import twice if both copies are in the file.
- Names do not match QuickBooks. Customers, vendors, items and accounts that differ from the client's lists create new records or fail.
- The client's settings block the import. Sales tax set up in the account stops the invoice import, and bills need Advanced or higher.
Schema CPA is built around the first three of these. It ties statement balances month to month, calls out a gap in a run of statements, and flags an invoice that arrived twice instead of counting it twice, so the firm sees those problems before the CSV is built. The other two checks happen against the client's QuickBooks file and stay with the firm.
A last check before upload takes a few minutes: count rows against the source documents, total the amounts against the statements or invoices, and open the CSV in a text editor to confirm the header row and column order. Then import, and review the results in QuickBooks before anything is reconciled.