Docs/1099 report
Tax reportContractorsPublic guide

Run the 1099 report

The 1099 report shows what you paid each payee in a tax year, which payees are ready, and which still need details.

Open the report

  1. Click Reports in the sidebar.
  2. On the Reports page, click the 1099 Report card.

The page is titled 1099 Preparation. Every payee above the threshold appears in one table.

Tax rules still require judgment

LeedBooks shows what it can see in your books. A tax professional should decide the final treatment when a case is unclear.

Year and threshold

Two controls sit at the top of the page.

  • Tax Year. Pick the year from the list. It opens on the current year. In January it opens on the year before.
  • Min Amount ($). A payee appears when the total paid to them in that year is at or above this amount. It starts at 600, the IRS 1099-NEC threshold. Only payees marked as 1099 candidates are counted.

Changing either control reloads the table and changes what the downloads contain.

Read the report

The top of the page shows four totals: Payees above threshold, Ready to file, Missing info, and Grand Total.

Each payee has a row with these columns:

  • Payee. The name, with the business name under it when it is different.
  • TIN. The last four digits only.
  • Form. The form type for the payee. It shows 1099-NEC unless the payee is set to another form.
  • Status. See below.
  • Payments. How many expense payments to the payee count toward the total in that year.
  • Total. The amount paid in the year.
  • Profile. Opens that payee's Profile tab.

The status tells you what is left to do. These are the same status words you see on the Payees page and on the payee profile:

  • Ready to file. The payee has a TIN, a legal name, a full address, and a W-9 date.
  • Missing info. The payee is missing one or more of these: TIN, legal name, address, or W-9 on file. The missing items are listed under the status, as Missing: followed by the items.
  • Exempt. The payee is marked exempt from 1099 reporting.
  • Under $600. The payee's total for the year is below the threshold.
  • Not a 1099 payee. The payee is not marked as a 1099 candidate.

When a W-9 date is on file, it shows under the status.

To fill in what is missing, click Profile on the payee. The payee's profile opens. Use the 1099 / W-9 details section to add the missing information.

Download

The report has three ways to get the information out.

Export CSV

Click Export CSV to download a spreadsheet of every payee on the report, including payees that still need details. The columns are Payee, TIN (last 4), W-9 received, Form, Status, Total, and Payments.

The file name includes the tax year. The button is greyed out when the table is empty.

Download IRIS CSV

Click Download IRIS CSV to get a file that matches the IRS IRIS portal format for 1099-NEC. This file holds only the payees that are Ready to file. Payees that are missing details, exempt, or set to a form other than 1099-NEC are left out.

  1. Click Download IRIS CSV.
  2. Enter your account password. The box warns that the file contains full Social Security numbers and tax IDs.
  3. Click Confirm & Download.

When the download starts, a message shows how many payees were included and how many were skipped. The file name includes the tax year.

If the password is wrong, the box shows an error and nothing downloads.

The button is greyed out when no payee is Ready to file yet. Hover over it to see the reason.

Print worksheets

Click Print worksheets to open a print-friendly worksheet in a new tab. It shows your business as the payer, the tax year, the threshold, and each payee above the threshold with the payments and total. Click Print / Save PDF to print it or save it as a PDF.

Steps at a glance

01
Set the year

Pick the tax year and the minimum amount.

02
Fill the gaps

Click Profile on each payee marked Missing info and add the missing details.

03
Check the totals

Make sure Ready to file and Missing info match what you expect.

04
Download

Use the IRIS CSV for ready payees, or Export CSV for the full list.

Who can see it

Anyone who signs in to your business's LeedBooks account can open the 1099 report and download the CSV files. The IRIS CSV also asks for the account password before it downloads.

Next step

1099 readiness

Keep contractor payments and W-9 details current through the year.

Read 1099 readiness