File Reviews
Prepare 1099s
8min
heads up ! keeper docs is now deprecated, and this page is not maintained please visit keeper's help center at help keeper app for the latest docs and guides 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 find out which of your client's vendors need 1099s, track vendors with missing w9s, request w9s from your client through the client portal, and export the report as a csv that you can upload to your 1099 filing tool of choice how it works to add the prepare 1099s report to a client's file, click add new in the payee/entity review section and add the 1099s report 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 credit card transactions are filtered out by default because vendors paid by credit card receive a 1099 k from the card network rather than a 1099 misc from your client vendors with total spend less than $600 are filtered out by default because that is the threshold where businesses are required to file 1099s 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 managing files and file requests 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 file requests if you need a w9 for a vendor, you can request it 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 what is saved in keeper vs quickbooks some data in this report is saved back to quickbooks, while other data is stored in keeper see the table below for a breakdown data stored in vendor name quickbooks email quickbooks address quickbooks ein / taxid keeper and quickbooks 1099 needed? keeper and quickbooks 2021 filed keeper w9 on file keeper chat / comments keeper files keeper, but can be uploaded to quickbooks 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 tips and suggestions once you have started marking vendors as 1099 needed = no, filter the table for yes and unknown vendors only if vendors do not require a 1099, leave a comment to indicate why (e g , "they're a corporation ") once you are finished filing 2021 1099s, keep checking this list in future months to prevent year end work from piling up in 2022! đ note the ytd spend total does not include journal entries adding this report to add the prepare 1099s report, click add new in the payee / entity review section