Keeper's Prepare 1099s report is designed to help you get everything ready for filing 1099s for your clients in January. It's an all-in-one report to:

Opening the report will show you a list of your vendors, sorted by spend, and filtered to exclude credit card transactions and vendors spend totaling less than $600.

Once in the report, you can enter all the information you need to prepare your client's 1099 filings. Once you have finished, you can click the download button in the top right-hand corner to export the list of vendors as a CSV that you can upload into your 1099 filing software.

If you need to add the Prepare 1099s report to a client's file, you can do so by click Add New in the Payee/Entity Review section and add the 1099s Report.

If you have a W9 for a vendor, you can upload it here and use it to enter in the needed information. You can also upload the document to QuickBooks as an attachment to the vendor directly from Keeper.

If you need a W9 for a vendor, you can request it from your client by clicking the Ask Client button. Doing this will add a non-transaction question to your Client Portal that is tagged as a W9 Request.

You can also request files directly from the vendor. Learn more about that here.

Some data in this report is saved back to QuickBooks, while other data is stored in Keeper. See the table below for a breakdown:

**The full Vendor EIN / TaxID cannot be requested from the QuickBooks API, so we can only show the last 4 digits.

Any TaxID updates made in Keeper will be stored in Keeper and synced back to QuickBooks.

If you need to exclude individual transactions from this report, you can do so by clicking the "Exclude" button on the right-hand side of the Transaction Detail Table. Re-running the report will update the vendor total spend amount to exclude that transaction.

If you need to re-include the transaction, you can manage your excluded transactions from the Excluded List in the top right-hand corner of the report.

Debit card transactions are excluded from 1099-NEC/1099-MISC reporting because payees receive 1099-Ks from the card networks, so they should not be included in your vendor totals.

There is no native concept of a debit card transaction in QuickBooks, however there is a workaround to filter these transactions out of your Prepare 1099s report in Keeper.

Step 1: While you're categorizing transactions in the bank feed, you can add a check number to any debit card transactions. ***

Step 2: Then, you can add that check number to your exclusion list in Keeper.

Once you've done this, any check numbers that contain those values ("debit" or "dbt" in the example below) will be excluded from your vendor totals.

You only need to do this once - after you've set up the mapping, all future transactions that contain these check numbers will be excluded.

Pro tip: we recommend choosing something short / quick to type, like "dbt".

*** If you don't see a check number option in your bank feed, make sure to enable the "Check No." setting in your bank feed.