Export 1099 Data From QuickBooks: Map First to Build One Clean CSV

The fastest way to get 1099 data out of QuickBooks is to run Prepare 1099s so payments map to the right boxes, then run the 1099 Transaction Detail Report and export it to Excel or PDF. Pull the Vendor Contact List too if you need EINs and addresses. When you need machine-readable forms, state filings, or actual e-filing, hand the data to an IRS-authorized e-file service.

---

TL;DR:

• Finish Prepare 1099s and map every expense account to the correct form box; reports omit unmapped payments and place misassigned amounts in the wrong columns.
• QuickBooks has no report combining payment totals, tax IDs, and addresses; export the transaction detail and vendor contact reports separately, then match records by vendor.
• Use the $2,000 reporting threshold for payments after 2025, and verify the applicable payment year because inflation adjustments may begin in 2027.
• QuickBooks PDFs can serve as records or recipient copies, but they do not meet IRS specifications; use official forms or an authorized filing service.

---

How do you prepare QuickBooks so 1099 data shows up in reports?

Nothing exports cleanly until the mapping is right. QuickBooks only fills its 1099 reports after it knows which vendors are 1099 recipients and which ledger accounts feed which form boxes. According to a QuickBooks Community thread, you have to run the Prepare 1099s flow and map the correct accounts before the 1099 Transaction Detail Report will populate. Skip this step and you get an empty report, which is the single most common complaint we see.

Work through this checklist before you export anything:

• Confirm your company name, legal name, address, and EIN in company settings.
• Open each contractor or vendor record and check the Track payments for 1099 box.
• Make sure every 1099 vendor has a legal name, tax ID, and mailing address on file.
• Start the Prepare 1099s wizard (steps below for QuickBooks Online and Desktop).
• Map each expense account to the right form box.
• Finish the wizard, or cancel it once the mapping is saved, so the reports populate.

Where to find Prepare 1099s in QuickBooks Online

In QuickBooks Online, go to the Expenses menu, then Vendors, and select Prepare 1099s. If you use the Workers or Contractors area, you can reach the same flow from the contractor list. QuickBooks explains that its Prepare 1099s flow lets you auto-prep or manually map accounts, preview 1099-NEC and 1099-MISC forms, and then e-file or print and mail them, with fees that may apply.

You do not have to use the filing options. For export purposes, you only need the wizard to record your account mapping.

Where to find Prepare 1099s in QuickBooks Desktop

In QuickBooks Desktop, open the Vendors menu, choose Print/E-file 1099s, then select Prepare 1099 Forms. Desktop walks you through a short series of screens: confirm your company information, select the vendors to include, and apply the account mapping. Review each screen. Desktop will only count payments from accounts you mapped, so an unmapped account means missing dollars.

Choosing between 1099-NEC and 1099-MISC boxes

The form box you assign controls where each dollar lands. Fees paid to independent contractors for services generally belong on 1099-NEC, while rent, prizes, and certain other payments belong on 1099-MISC. If you are unsure which form fits a payment, our guide to 1099-NEC vs 1099-MISC explains the difference in plain terms.

Mapping has a direct effect on your reports. An account mapped to the wrong box puts the amount in the wrong column of the Transaction Detail Report, and an account left unmapped drops out entirely. Map once, carefully, and write down the choices. The IRS publishes box-by-box rules in its instructions for Forms 1099-MISC and 1099-NEC, and those instructions are the final word if QuickBooks defaults look off.

Why you should finish or cancel the wizard

Opening the wizard is not enough. The mapping is saved when you move through the flow, and the reports read from that saved mapping. If you are only exporting, you can step through to the review screen and then exit without filing anything. Do not leave the wizard half-done on the first mapping screen and expect reports to fill in.

Pro Tip: Before you export, open a few vendor records at random and check the legal name, tax ID, and address. Finding a bad EIN now is easier than finding it after filing. Found after filing, it costs you a correction.

Need to get this filed? You can e-file Form 1099-NEC online with TaxFormHero, which is IRS-authorized and charges per form, not per month.

Which 1099 reports can you run and export?

QuickBooks does not hand you one tidy “1099 export” button. It gives you several reports, each with a different job. Knowing which to run saves a lot of cleanups later.

QuickBooks support documents describe how to run the 1099 reports, including the 1099 Summary, 1099 Detail, and 1099 Transaction Detail, and how to find which contractors need a 1099 using the Track 1099 setting and report filters.

Here is what each report does for you:

• 1099 Transaction Detail Report: lists each reportable payment by vendor, with date, transaction type, and amount. This is your main export for an accountant.
• 1099 Summary or 1099 Detail: rolls payments up by vendor and form box so you can see totals at a glance.
• Transaction List by Vendor: shows every payment to every vendor, including ones that are not reportable. Useful for spotting payments that should have been mapped.
• Vendor Contact List: holds the tax ID, legal name, and address fields. This is where your EINs live.

Why the single-report approach does not work

A QuickBooks Community answer on this exact problem says there is no single QuickBooks Online report that includes vendor, amount paid, tax ID, and address together. The practical workaround is to export the Vendor Contact List for tax ID and address, export the Transaction List by Vendor for amounts, and merge the two in Excel. We cover that merge in the next section.

Step-by-step: run the reports in QuickBooks Online

1. Go to Reports and search for “1099” in the report search box.
2. Open the 1099 Transaction Detail Report.
3. Set the date range to the tax year you are reporting, for example January 1 through December 31.
4. Check that the report is pulling vendors with Track payments for 1099 turned on.
5. Use Customize to add or remove columns. Add Vendor, Date, Type, Num, Memo, Account, and Amount if they are not already showing.
6. Run the report and scan for payments that look wrong or missing.
7. Go back to Reports and run the Vendor Contact List. Use Customize to add the tax ID, address, and email columns.
8. Run the Transaction List by Vendor for the same date range if you want to compare it against the 1099 report.

Step-by-step: run the reports in QuickBooks Desktop

1. Open the Reports menu and choose Vendors & Payables.
2. Select 1099 Detail, then set the date range to the tax year.
3. Click Customize Report and confirm the columns you need appear, including Name, Date, Type, Account, and Amount.
4. Run the report and review each vendor total.
5. Return to Reports, choose Vendors & Payables, and open Vendor Contact List.
6. Customize the columns to include the tax ID and address fields.
7. Run Transaction List by Vendor from the same menu to compare against the 1099 detail.

Finding vendors who need a 1099 and spotting gaps

To see who needs a form, filter by vendors flagged for 1099 tracking and look at their year-to-date totals. Compare each total to the reporting threshold. According to Carnegie Mellon’s tax office, the general threshold for Form 1099-NEC and 1099-MISC is $600 as of 2026, rising to $2,000 for payments after 2025, with possible inflation adjustments starting in 2027. For the full context on that change, see our explainer on the 1099-NEC threshold shift from $600 to $2,000.

The IRS repeats the thresholds and lists common reportable payments in its page on Form 1099-NEC and independent contractors, which also points to official filing resources. Check the threshold that applies to the payment year before you decide who gets a form.

When you scan the Vendor Contact List, sort by the tax ID column. Blank cells float to the top, and those are the vendors you need to chase.

How do you export the reports to Excel, CSV, or PDF?

Once the report looks right, exporting takes a few clicks. The merge afterward is where the real work happens.

Export commands in QuickBooks Online

In QuickBooks Online, run the report, click the Export/Print dropdown in the top right, and choose Export to Excel. QuickBooks notes that exported files may open in protected view in Excel until you click Enable Editing. If you customize a report first, you can also export it to Excel, Google Sheets, PDF, or CSV, although the options vary by report and edition.

One caveat matters here. A QuickBooks Community answer confirms that QuickBooks Online does not export generated 1099 forms to CSV directly. The recommended workaround is to run the 1099 Transaction Detail Report and export that to Excel or PDF. That thread dates to early 2021, so check that the menu labels still match your version, but the underlying approach has held up.

Export commands in QuickBooks Desktop

In Desktop, run the report and use the Excel dropdown at the top of the report window. QuickBooks documents that Desktop can export reports as Excel workbooks, CSV spreadsheets, or PDFs, and covers what to do if you see a too-many-columns message or need to choose worksheet options. A separate support page on Desktop export steps explains how to change the default export file type in report preferences.

Merging amounts and vendor details into one file

Your goal is one row per vendor with name, tax ID, address, and total paid. Here is a conservative way to get there.

• Export the 1099 Transaction Detail Report (or Transaction List by Vendor) as Sheet 1.
• Export the Vendor Contact List as Sheet 2.
• On Sheet 1, build a vendor-level summary using a PivotTable or SUMIF, so each vendor appears once with a total.
• Clean the vendor names on both sheets with TRIM and PROPER so extra spaces and capitalization differences do not break the match.
• Join the summary to the contact list using XLOOKUP or VLOOKUP on the vendor name.
• Check for unmatched rows. Any #N/A means the names differ between the two reports.
• Remove duplicates and fix any vendors that appear under two spellings.

Power Query does the same join with less manual work. Load both tables, merge them on the vendor column, and expand the columns you need. It also remembers the steps, so next year you refresh instead of rebuilding.

Saving the file for your accountant

Save the final sheet as CSV so any tool can read it. Accountants typically want these columns:

• Vendor legal name
• Business name or DBA, if different
• Tax ID (EIN or SSN)
• Street address, city, state, ZIP
• Total reportable payments
• Form type (1099-NEC or 1099-MISC)
• Email address, if you plan to deliver recipient copies electronically

Also keep the original, untouched QuickBooks exports in a separate folder. If a number is questioned later, you can trace it back.

Pro Tip: Name your files with the tax year and the export date, such as “1099-detail-2025-exported-2026-01-12.csv”. Dated copies show exactly what the data looked like when you handed it off.

Can you download or print 1099 PDFs from QuickBooks?

Yes, when you have generated the forms through the Prepare 1099s flow. The reports above give you data. The PDFs give you the forms themselves.

• Open Prepare 1099s and move through the mapping screens to the review step.
• Use the preview option to see each form as QuickBooks built it.
• Choose the print or download option to save the PDFs to your computer.
• Check each form for the right name, tax ID, address, and box amounts before you do anything else with it.
• Save the PDFs in your dated records folder.

Keep one thing in mind about what these PDFs are. The IRS says forms downloaded from the internet must not be used for filing because official machine-readable forms have precise specifications. You can order official forms or use an authorized e-file service for filing. A printed PDF copy is fine as a record or as a recipient copy, but the IRS filing copy has to meet its own rules.

Getting copies for prior years

Older forms can be harder to reach. A QuickBooks Community thread explains that QuickBooks Online may not let you generate 1099s for certain prior tax years inside the product. If you filed through QuickBooks’ e-file service, you can log into the 1099 e-file portal and retrieve copies there. If not, export the reports for that year and recreate the forms, or request copies from the IRS. That discussion is from 2021, so confirm the current behavior in your account before relying on it.

What causes missing or wrong data, and how do you fix it?

Most export problems trace back to a handful of causes. Check these in order.

• Journal entries. A QuickBooks Community answer says journal entries are not expense transactions and do not appear on 1099 forms. Record payments as bills, checks, or expenses so they show up in the 1099 reports. If you have old journal entries, re-enter them as proper vendor transactions.
• Unmapped accounts. If an expense account is not mapped to a 1099 box, its payments will not appear. Reopen Prepare 1099s and check every account.
• Vendor not flagged. If Track payments for 1099 is off, the vendor will not show on the report at all, even if you paid them thousands.
• Wrong date range. Reports default to a period that may not match the tax year. Reset the dates.
• Payments made by card or processor. Payments made through a payment card or a third-party network are generally reported by the processor, not by you. That can leave your QuickBooks totals higher than what you owe on a 1099, so confirm which payments are yours to report using the IRS guidance linked earlier.
• Threshold mismatch. Vendors below the threshold may not appear. Check the threshold setting and the year you are reporting.

Fixing missing EINs and addresses

Run the Vendor Contact List, sort by tax ID, and list every blank. You can type the data in yourself, but it is safer to collect it directly. QuickBooks lets you send W-9 invites to contractors to collect missing name, EIN, and address data, and when a contractor completes the W-9 online, their information updates in QuickBooks automatically.

If your vendors are scattered across several payer entities, keep each payer’s data separate. Mixing them is a quiet source of errors later.

Resetting threshold and mapping settings

If numbers still look wrong, go back into Prepare 1099s and review the threshold and account mapping from scratch. Do not assume the defaults are correct for your situation. Compare any vendor near the threshold against the figure you confirmed from the IRS or the university guidance cited above, and note the result.

For guidance on who counts as a contractor and which payments qualify, our article on paying contractors with 1099s walks through the basics.

Pro Tip: After fixing a mapping, rerun the Transaction Detail Report and compare the vendor totals to your pre-fix export. If the totals did not change, your fix did not take.

When is an Excel export enough, and when should you use an e-file service?

An export is a handoff tool. It is not a filing method.

An export is the right answer when you want to:

• Review payments internally before deciding who needs a form.
• Send clean data to your accountant or bookkeeper.
• Make small manual corrections before the data goes anywhere else.
• Keep a dated record for your files.

An e-file service becomes the right answer when you need to:

• File machine-readable forms that meet IRS specifications.
• File many forms at once without retyping each one.
• Handle state filings alongside the federal return.
• Verify recipient TINs before submitting.
• Print and mail recipient copies, or send them by encrypted email.

The reason is simple. The IRS states that forms downloaded from the internet cannot be used for filing, and it points filers to official forms or an authorized e-file service. Your QuickBooks PDF is useful for your records, but it is not a substitute.

If your data sits in QuickBooks, our QuickBooks 1099 guide explains how vendor data can be imported for e-filing.

What formatting does the exported file need before filing?

Whatever platform you use, a few rules keep imports from failing:

• One row per recipient, with consistent column headers.
• Format tax IDs consistently in every row.
• Full legal names with no stray characters or trailing spaces.
• Use consistent state and ZIP code formats.
• Dollar amounts as plain numbers without currency symbols.

How do we file after exporting from QuickBooks?

Once your CSV is clean, you do not have to retype anything. At TaxFormHero, we are an IRS-authorized e-filing platform, and we let you import records in bulk from an Excel template, manage multiple payer accounts, and verify each recipient’s TIN before you submit. Federal returns go to the IRS through IRIS A2A, and recipient copies can go out by encrypted email or USPS First-Class Mail.

Our pricing is pay-per-form with no subscription, signup fee, or annual contract. For 1099 forms, the price starts at $1.99 per form, and the rate steps down at higher volumes, with each tier applying only to the forms inside it. Optional add-ons are priced per form on our pricing page: state filing at $0.99, print and mail at $1.69, encrypted e-delivery at $0.19, and TIN matching at $0.49 per check.

If you have exported your vendor data and want to move straight to filing, our 1099-NEC filing page is the place to start. You bring the CSV, and we handle the rest.

What is our recommended QuickBooks workflow?

Do the boring work first. Map your accounts, confirm every vendor’s name, EIN, and address, and only then export. Most “QuickBooks export problems” are really mapping or vendor-data problems that surface at export time. Fixing them upstream saves hours downstream.

Treat the export as a handoff, not a deliverable. The Transaction Detail Report and the Vendor Contact List give your accountant what they need, and a merged CSV makes their job faster. But the file itself is not a filing, and nobody should treat it like one. When it is time to file, use a service built for it.

Two habits are worth keeping every year. First, save a dated copy of every export you hand off, along with the untouched originals. Second, write down your account-to-box mapping in a short note. If a number is ever questioned, that note and those files help explain the records. Auditors and accountants both appreciate a paper trail that explains itself.

Last, remember that the threshold is changing. Know which year’s rule applies to the payments you are reporting before you decide who gets a form.

— Nazrul

FAQ

Can you get a 1099 from QuickBooks?

Yes. Run the Prepare 1099s flow, map your accounts, and preview the forms. QuickBooks can generate 1099-NEC and 1099-MISC forms from the data in your account, and you can print or download them as PDFs.

How do you export 1099 data from QuickBooks to Excel?

Run the 1099 Transaction Detail Report after completing Prepare 1099s, then use the Export/Print dropdown and choose Export to Excel. QuickBooks Online does not export the finished 1099 forms to CSV directly, so the report is the standard workaround.

Why is my 1099 Transaction Detail Report empty?

The most common cause is that Prepare 1099s was never completed, so no accounts are mapped to 1099 boxes. Other causes include vendors not flagged for 1099 tracking, payments entered as journal entries, and a date range that does not match the tax year.

Where can you find a 1099 form to file?

Use official forms from the IRS or an IRS-authorized e-file service. The IRS says forms downloaded from the internet should not be used for filing, so a QuickBooks PDF works as a record or recipient copy but not as your filing copy.

Recommended

• QuickBooks 1099 Integration | Import Vendors and E-File
• Printing 1099 Forms: Skip Copy A Printer Calibration With Print and Mail
• Avoid 1099 Rejections: 8 Compliance Checks for U.S. E Filing Software