QuickBooks

How to Run a 1099 Report in QuickBooks Online (Before You Get Anywhere Near Filing)

Go to Reports, search for 1099, and open either the 1099 Summary report, which totals each vendor by 1099 box, or the 1099 Transaction Detail report, which lists every individual payment behind those totals. Run either one anytime through the year to check vendor payment totals, separate from the Prepare 1099s wizard you'd use when you're actually ready to file.

The full walkthrough

1. Go to Reports and search for 1099. Both the Summary and Transaction Detail versions show up; you don't need to be inside the Prepare 1099s flow to reach either one.

2. Set the date range to the full tax year. 1099 reporting runs on a calendar year, so make sure the range covers January through December, not whatever default period the report opens with.

3. Run the 1099 Summary first. It shows one line per vendor, with the total mapped to the relevant 1099 box (Nonemployee Compensation, rent, and so on), filtered to vendors you've flagged as 1099 vendors.

4. Check which accounts feed which box. The report's settings let you review which expense accounts map to which 1099 category. If a payment's landing in the wrong box, that's usually an account mapping issue, not a problem with the vendor's data.

5. Drop into Transaction Detail for anything that looks off. If a vendor's total looks wrong, this report lists every individual payment behind it, so you can spot a duplicate, a miscategorized transaction, or a payment that should have been excluded.

6. Note who's missing, not just who's listed. A vendor who should hit the $600 threshold but isn't showing up usually means they were never marked as a 1099 vendor, which is worth catching now rather than during the actual filing crunch.

Why checking this early beats checking it once a year

Most businesses only look at this report once, in January, as part of getting ready to file. By then, any mapping error or missing vendor flag has been quietly compounding for twelve months, and fixing it means reconstructing what should have happened all year instead of catching one bad transaction as it happens.

Running the Summary report a few times through the year, a quarter close, a monthly review, catches the same issues while they're still small: one miscategorized payment instead of forty, one vendor missing a 1099 flag instead of discovering it with three weeks left before the filing deadline.

The report itself is accurate the moment you run it; the problem is always that nobody looks at it until filing season forces the issue.

What we've built on top of QuickBooks 1099 reporting

A standing check instead of a January scramble

The 1099 Summary report gets pulled and compared against the prior run on a schedule, flagging a vendor whose total just crossed the threshold or whose mapping changed, instead of everything surfacing at once in January.

Vendor flags set at the point of first payment

A new vendor gets checked against 1099 eligibility the moment they're paid for the first time, so the flag and tax ID are already correct well before the report ever gets run for filing.

When's the last time anyone actually looked at your 1099 numbers?

If the honest answer is 'last January,' tell us what the review currently looks like and we'll tell you if it can run itself on a schedule instead.

Let's talk

Only checking your 1099 numbers once a year, right before filing?

Tell us how your vendor payments actually flow through QuickBooks, and we'll tell you whether a standing check through the year could catch problems before they pile up. 1099 reporting is one example of something that gets reviewed too rarely; we automate that same kind of gap wherever it shows up in a business.

Let's talk

Frequently Asked Questions

Where do I find the 1099 report in QuickBooks Online if I'm not ready to file yet?+
Search 1099 directly from the Reports menu rather than going through Prepare 1099s. Both the 1099 Summary and 1099 Transaction Detail reports are standalone reports you can run anytime, independent of the annual filing wizard.
What's the difference between the 1099 Summary and 1099 Transaction Detail reports?+
Summary shows one total per vendor per 1099 box, useful for a quick check of who's close to or over the threshold. Transaction Detail lists every individual payment behind those totals, which is what you need when a vendor's number looks wrong and you have to find out why.
Why is a vendor missing from my 1099 report even though I paid them?+
Usually because they were never marked as a 1099 vendor on their profile, or their payments were made by credit card or a third-party processor, which get excluded from 1099-NEC reporting entirely since the processor handles that reporting instead.
Can I run a 1099 report for a prior year in QuickBooks Online?+
Yes, as long as the date range on the report is adjusted to that prior calendar year. The underlying transaction data doesn't disappear once a year closes, so historical 1099 totals stay available to pull up later.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.