How to Create 1099s in QuickBooks Desktop

To create 1099s in QuickBooks Desktop, update to the latest supported release, back up the company file, select the correct form, review contractors, verify Form W-9 details, map expense accounts, review included and excluded payments, preview vendor totals, and choose print or e-file. QuickBooks organizes the data; it does not decide worker status or prove every payment is reportable.

This guide is part of Steady’s Payroll, W-2 & 1099 library. It explains the federal workflow in practical terms, but the correct result still depends on the payment year, entity, worker relationship, filing method, and state rules.

The answer in context

Current release

Intuit states the latest update is needed for forms and boxes to process correctly.

Vendor setup

Legal name, business name, address, TIN, and tracking should match Form W-9.

Account mapping

Each expense account maps to one applicable 1099 form and box.

Payment exclusions

Card and qualifying network payments generally fall under Form 1099-K reporting.

Threshold settings

Reset stale product thresholds to the current IRS values and verify the payment year.

Step-by-step workflow

1. Update and back up. Preserve the company file and source reports.
2. Open the 1099 wizard. Choose Vendors, 1099 Forms, and the current print or e-file workflow.
3. Select the form. Prepare 1099-NEC and 1099-MISC separately when both apply.
4. Review payees and mapping. Resolve Form W-9 data and map all relevant accounts.
5. Reconcile payments. Compare included and excluded reports with the vendor ledger and payment methods.
6. Preview and approve. Check form year, payer, recipient, amounts, withholding, and states before filing.

Worked example

A studio’s vendor ledger shows $19,000, while the QuickBooks report shows $15,500. The excluded-payment report identifies $3,500 paid by credit card. The reviewer verifies the exclusion, checks Form W-9, resets current thresholds, confirms account mapping, and previews Form 1099-NEC. The reconciliation is saved with the final form and acceptance.

The example is intentionally a workflow illustration, not a conclusion for every taxpayer. A strong file connects each number on the return to a source report and records why an exception, exclusion, or classification was applied.

Records to keep

Keep the source form or worksheet, contracts or engagement records, payer and recipient identity support, the detailed payment or payroll ledger, bank and processor reconciliation, calculations, correspondence about corrections, filed copies, recipient-delivery evidence, and federal and state acceptance confirmations. Store the records by tax year and keep superseded versions when they explain a correction.

A reviewer should be able to begin with the final reported amount and trace it back to transactions without rebuilding the year. Add a short review memo for judgments such as worker status, corporate exemption, payment-method exclusion, state filing, or unusual timing. That memo is often more useful than another unlabeled spreadsheet.

Common mistakes

• Skipping the update. Old layouts and thresholds can persist.
• Using vendor display names. Use Form W-9 data.
• Mapping only obvious accounts. Review repairs, professional fees, direct costs, and reimbursements.
• Forcing totals to match. Supported payment-method differences can exist.
• Creating forms for employees. Employee wages use Form W-2.
• Assuming preview means filed. Save the acceptance.

Final review before filing

Confirm the form and revision year, taxpayer identities, dollar fields, payment categories, withholding, filing channel, recipient statement, state obligations, due dates, and approval. Compare the final output with the source reconciliation rather than reviewing the form in isolation. If software recalculates an amount after an edit, rerun the tie-out.

Keep preparation, filing, and acceptance as three separate statuses. A draft can be complete but unfiled; a transmission can be sent but rejected; a federal return can be accepted while a state return is still missing. This status discipline prevents a polished PDF from being mistaken for finished compliance work.

How to handle a discrepancy

When a source form, ledger, payroll report, or software preview disagrees with another record, stop before filing and identify which amount represents the underlying transactions. Trace the difference by vendor or employee, date, invoice or payroll run, payment channel, and account. Common causes include a payment posted to the wrong year, a void recorded after a report was generated, a card payment included with checks, a duplicate import, an incorrect taxpayer name, or a late adjustment. Record the explanation and the correcting entry or form request.

Do not erase the trail by overwriting the original report. Save the first version, the reconciliation, the corrected version, and the approval. If a third party supplied an incorrect information return, request a formal correction and retain the correspondence. If a return was already transmitted, use the current correction procedure for that form and channel. A corrected recipient copy without a corresponding agency correction can leave the records inconsistent.

Federal filing is only one layer

Federal acceptance does not settle state or local obligations. A state may use a different threshold, worker test, filing portal, account number, transmittal, or due date. Some states receive eligible information through a combined program, while others require a direct submission. Verify the jurisdictions connected with the payer, recipient, employee, work location, withholding, and business activity. Save state confirmations separately so they are not hidden behind the federal acceptance.

Make next year easier

Turn the year-end work into a monthly control. Collect identity forms during onboarding, code payment methods consistently, reconcile payroll and vendor activity each month, and flag vendors or income streams that need special treatment. Schedule a fall review of missing forms, classification questions, state registrations, and electronic-filing access. By year-end, the team should be validating a maintained file instead of reconstructing twelve months of transactions under a deadline.

Assign one owner and one reviewer to the calendar. The owner prepares the source schedule and resolves open items; the reviewer tests identities, totals, rule references, filing status, and evidence. Record the date of the official guidance used because form pages and software menus can change during the filing season. If a rule is uncertain, document the question and escalate it before the deadline rather than placing an unsupported assumption in the final file. This short control list protects both accuracy and continuity when another bookkeeper, payroll specialist, or tax preparer takes over the work. Save the checklist with the return so next year’s team can see which controls were completed and which exceptions required follow-up.

Control checkpoint

Before filing or paying, identify the taxpayer, legal entity, federal classification, tax year, effective elections, owners, states, return type, and source records. Compare the planned treatment with prior returns, agency accounts, and reconciled books. Assign a preparer and reviewer, record unresolved assumptions, and replace them with evidence before submission. Track prepared, reviewed, transmitted, accepted, furnished, paid, and corrected as separate statuses so a generated form is never mistaken for completed compliance.

Keep a permanent filing index with the source schedule, calculation version, official guidance date, authorization, submission identifier, acceptance, payment confirmation, and recipient or owner delivery evidence. If a form changes after filing, preserve the original and corrected histories and reconcile the final accepted amount back to the books. Record which next-year opening balances, carryovers, elections, basis schedules, or account settings were updated. This creates continuity for another preparer and prevents a correction in one system from leaving stale information in another.

Review the final output independently from the preparer. Recheck names and taxpayer identification numbers, form and revision year, dollar fields, due dates, payment designation, internal links, and cited sources. Save the reviewer’s sign-off and any resolved exceptions with the final package.

Use the same final amounts in the books, return workpapers, recipient or owner copies, and next-year schedules. Investigate any difference before archiving the file. Confirm that each payment, balance, and carryover agrees across the return, supporting schedules, and delivery copies. If an item does not belong on the return, document where it was reported or why it was excluded instead of forcing it into an unrelated category. Keep the final reconciliation and review notes with the accepted filing so a future preparer can understand the treatment without reconstructing the work.

For the next layer of context, see this related guide, the companion reporting article, and the connected workflow.

If the form, books, and filing status do not agree, Steady can help reconcile the source data and prepare a clean filing package through its specialist service.