How can I print a YTD report of payments to 1099 vendors in QBO

lindab2810 · ‎October 15, 2018

I need to print a YTD payments report for all 1099-identified vendors. How can I do this in QBO?

IntuitLeleth · ‎October 15, 2018

If these vendor payments were from last year, you can follow these steps on generating the year-to-date report:

Click Expenses on the left navigation panel.
Select Vendors tab and click Prepare 1099s.
Click the Continue your 1099s button.
Follow the on screen instructions until you reach the Review 1099 vendors and payments window.
Click the Print Information Sheet button.

If this is for the current year’s vendor payment, there isn’t a way to generate a report to show the payments made to your 1099 vendors. However, you can customize the Transaction List by Vendor report.

Here’s how:

Click Reports on the left navigation panel.
In the search field, type in Transaction List by Vendor.
Click the Customize button.
Select your preferred date on the Report period drop down arrow.
Select Filter and click the Transaction Type drop down arrow.
Put a checkmark in the Payment box.
Put a checkmark in the Vendor box and click the drop down arrow to select your 1099 vendors.
Click Run report.

Don’t hesitate to get back to me if you have further questions about customizing the report.

View solution in original post

IntuitLeleth · ‎October 15, 2018

Hello there lindab2810,

If these vendor payments were from last year, you can follow these steps on generating the year-to-date report:

Click Expenses on the left navigation panel.
Select Vendors tab and click Prepare 1099s.
Click the Continue your 1099s button.
Follow the on screen instructions until you reach the Review 1099 vendors and payments window.
Click the Print Information Sheet button.

If this is for the current year’s vendor payment, there isn’t a way to generate a report to show the payments made to your 1099 vendors. However, you can customize the Transaction List by Vendor report.

Here’s how:

Click Reports on the left navigation panel.
In the search field, type in Transaction List by Vendor.
Click the Customize button.
Select your preferred date on the Report period drop down arrow.
Select Filter and click the Transaction Type drop down arrow.
Put a checkmark in the Payment box.
Put a checkmark in the Vendor box and click the drop down arrow to select your 1099 vendors.
Click Run report.

Don’t hesitate to get back to me if you have further questions about customizing the report.

lindab2810 · ‎October 15, 2018

Thank you for your reply.  I had already discovered that the Information Sheet under Prepare 1099's would only list last year's 1099 recipients.  That report was helpful for historical purposes.
I did the customization per your instructions for the Transaction List by Vendor.  The only change that I needed to make was that "payment" needed to be changed to "Bill Payment(Check)", since payment is specifically for Customer payments received.
We have hundreds of vendors, so selecting the 1099 vendors was somewhat a process.  In addition, the Transaction List does not total the payments.

My work-around was this:  I ran the Vendor Contact List, and customized the columns to include "Track 1099" ( I really had to do some searching for that).   I deleted the columns that I did not need for this report, and saved the customized report.  I exported it to Excel and re-sorted to only include the vendors that were Tracked for 1099's.
Then I ran the Expenses by Vendor Summary (which has totals), and used my list from the previous report to filter the vendors that were tracked for 1099's  Using that list made it easier to identify the correct vendor from the very long selection list.

This gave me a report for total YTD amounts paid to our 1099 vendors!

Quite a process for something that should be so simple.

My suggestion would be to add a filter to the Vendor Summary List to "Track 1099."  That simple option would have saved me having to customize and run two separate reports.
Better yet, why not just have a dedicated report for a 1099 summary?

Thanks for your help......it actually got me on the track for dong the work-around above.

IntuitLeleth · ‎October 15, 2018

Hi there @lindab2810.

Thanks for responding and for sharing your workaround. This will definitely help other posters that may have the same problem. For your suggestion regarding the addition of filter to the Vendor Summary List, I would recommend sending us feedback to include this enhancement in the future.

Here's how:

1. Go to the Gear icon next to your company name
2. Select Feedback
3. Follow prompts to submit feedback.

We look forward to hearing your feedback. Don’t hesitate to drop a comment below if you have further questions.

radically_simple_accounting · ‎October 15, 2018

I agree, this really needs to be fixed. It's a routine accounting task..

We need a report of 1099 vendors, (any vendors with the 1099 box checked off), amounts paid to date (including checks, expenses and bill pay), limited to 1099 accounts or all accounts, and total for each vendor.

Plus, total of that report.

Referring to earlier post, I don't see the "print" option any longer under 1099's at all. Is it still there, and I'm missing it?

I'm going to try and create a report that works, or if anyone else does it first, please do tell.

lindab2810 · ‎October 15, 2018

Good to see another user who recognized the absolute need for this simple report! We don't need a "work-around that has to be tweaked every time it is run." We just need a basic report EXACTLY like the one that can be produced in QB Desktop in a matter of seconds. I can't imagine any valid reason that this cannot be done in QBO. Even if you are using the automatic filing in QBO, you still need an easy report to verify total payments.

TraciPW · ‎October 15, 2018

Agreed--how has this been overlooked by the development team for so long?

vision2014 · ‎October 15, 2018

radicalaccountin,
I would like this too!
I'm not sure if this is what you meant, but I am also looking to see DETAIL of transactions included on the 1099 report. I have suspicions that it is including "bills" in the totals for the 1099 but I can't be clear. I want to review closely what I am submitting to the IRS and not just take QB word for it.

radically_simple_accounting · ‎October 15, 2018

Yes, of course, it needs to be a detailed report.

Not sure what you're saying? I think it doesn't matter if you paid via bill/bill payment, check, or bank account expense, it's all the same to the 1099 Detail Report. (Except if you paid with a credit card, then it's not included.)

Haven't figured out how to get this report yet? I don't see "print" off the 1099 process. Is it still there?

vision2014 · ‎October 15, 2018

I haven't seen the QB Desktop report so I wasn't sure what that report was like.

Actually it does matter if bills are included (not referring to "bill payments").  We are an accrual not cash based organization.  Our bills are not necessarily paid in the same year they are entered.  A 2017 December "bill" is paid in January 2018.  That "bill"should not be included in the 1099 for the calendar year 2017.  However our financial statements will recognize a bill in the month  in which it was entered.  That expense would show on the December 2017 financial in our books.

I believe the totals in the 1099 filing may include some of these bills but I can't be sure because I can't find a report to review the detail.

Also - We have consultants turning in original receipts for reimbursement (per Federal contract invoicing requirements).  We do not want these expenditures included in the consultants'1099.

The 1099 "process"reports show a name and the total included in Box 7.  There is no review detail.  That was where I was referring to and I assume is what you were referring to.

QBO makes you back-flip for the easy stuff.

radically_simple_accounting · ‎October 15, 2018

Absolutely. We need to review the details.

I take it for granted that all reports are cash or accrual and didn't connect that to you saying bills.

I figured out how to do a vendor detail report on QB Online that exists in QB Desktop. I don't know if I can post a link to my blog here, so I cut and pasted it. This might help.

The Expenses by Vendor Detail Report is one of the most useful reports in QuickBooks desktop, but it does not exist in QB Online. QB Online does have a vendor report, but it doesn't provide me with totals for one thing. So I figured out how to get this report in QB Online. If you can get Accountant Access to QB Online, you can do it too. Here are the instructions:

Under Accountant Reports
Select Transaction Detail by Account
Customize it the following way
Rows/Columns –> Group by Vendor
Filter -> Select Distribution Account = All Expense Accounts
Change Columns -> Uncheck the following boxes: Name, Adj, Split, Balance; then Add the following: Account (I like to move Account up to the space before the Memo. I think the report looks better this way).
Header/Footer -> Report Title= Expenses by Vendor Detail

Viola!

vision2014 · ‎October 15, 2018

Thanks! However QB JUST (this morning) created a new report that works for me and may work for you. Look in Reports category "Review Expenses and Purchases". There is a new 1099 transaction detail report!! You can filter by threshold or 1099 Box #.

radically_simple_accounting · ‎October 15, 2018

Thanks for the alert, very helpful.

Do you see a way to filter for "1099 box checked" in the vendor field?

Almost nothing is working on that report right now in one of my client's databases, so I get the sense the programmers are working on it. Hopefully they'll add this filter asap.

RuthO · ‎November 28, 2018

Thanks for sharing your work around. Have any suggestions for extracting out reimbursements that should not go on their 1099? Desktop had a way to remove payments that were not taxable income. I am regretting moving from Desktop to Online. I whole heartedly agree with you on your report suggestions!

edenwillow · ‎November 30, 2018

This is helpful - however I would note that this method also includes expense reimbursements in the totals, which should not be included in the 1099s, so it is still not what I need!

edenwillow · ‎November 30, 2018

The problem with this report is that it is on an accrual basis, not cash, which is what I need to file 1099s. So close! And yet so far...

Charies_M · ‎November 30, 2018

Hi there everyone.

Thank you for taking the time to join this thread. I'm here to help you prepare your 1099s in QuickBooks Online (QBO).

If you wish to exclude the expense reimbursements in the totals for 1099s, you have the option to remove it so it will not show on the 1099 report. I'd be glad to walk you through the whole steps:

Go to Expenses.
Click the Vendors tab.
Click the Prepare 1099s.
If you've already started preparing Prepare 1099s, just click Continue your 1099s.
Click Next until you reached the step 2 for Accounts.
Under Box7: Nonemployee Compensation, click the drop down and make sure to remove the check mark for Reimburse.
Click Next, until your Finish preparing 1099s.

On the other hand, you can customize the 1099 Transaction Detail Report to Accrual basis instead of Cash basis.

Here's how:

Go to Reports on the left menu.
Under Expense and Vendors, click the 1099 Transaction Detail Report.
Fill in the radio button for Cash under Accounting method.
Click Run report.

I'm still here if you have other questions while working with 1099s in QuickBooks Online. Feel free to keep in touch.

kelleherk · ‎December 11, 2018

How can you select all the accounts to be included in the 1099s? Do you have to do them one by one? Will the information on the 1099 Detail Report only show up if you go through the Prepare 1099 process?

MichaelDL · ‎December 11, 2018

Hey there, @kelleherk.

I have some insight to provide you regarding your 1099 forms. While the accounts do need to be selected one by one, the good news is, QuickBooks will remember your selections for as long as you're filing these forms in QBO. Try the steps below to accomplish this:

Mapping accounts for the 1099-MISC

From QuickBooks Online, navigate to the Expenses tab and the Vendors section.
Click Prepare 1099's. Select to Begin (or Continue) your 1099's.
Depending on where you left off, either follow the on-screen instructions or click Back until you're on Step 2.
Check the box for the account you're filing through, and in the dropdown menu (▼) select each account you need to include on your 1099 forms.

This information is also available from our guide on assigning accounts to the 1099 as well the video tutorial here:

As you suggested, doing this populates these account's information onto the 1099 Transaction Detail report. This way you can stay informed about the amounts you're filing. Please keep in touch with me here should you have any additional questions or concerns, I'm always up to talk QuickBooks. Thanks for coming to the Community and have a great day.

radically_simple_accounting · ‎December 12, 2018

Working with a client again to help her get all the tax ID #'s and addresses for 1099 clients. The client may have these, but identifying what data QB needs. I have a couple of ideas.

1. For reimbursements vs real payments, consider making 2 vendors, one for Jones - Repair Service and one for Jones - Reimbursement. That's how I do it, because I find it's much clearer, and one can have an many vendors as one wants. It would also help you with 1099's, since the reimburse vendor would not be checked off for 1099's.

2. The 1099 report is buggy as all get out. First of all even though it says "ALL" boxes, it does not include the rent or attorney vendors. Second, it does not include addresses. That's what is needed (and what that astute Excel user was getting for herself). Third, when I try to remove columns I don't want the entire report goes blank. Any one else getting this bug?

3. Another work around. I actually printed a screen shot of the 1099 screen that clearly showed a few vendor missing address or account #'s, and am sending that to the client. It's pretty easy for a programmer to fix a report, so let's all send in feedback and hope they do it asap.

Still checking this thread for other work arounds and good news.

Plinkr · ‎January 11, 2019

I keep seeing this "Group By" - running Pro2018 and do not have that option - unless I am missing it...???

AldrinS · ‎January 11, 2019

Thanks for bringing your question to the Community, Plinkr.

I'm here to provide some additional clarification on your question regarding the Group By option.

The reason you can't see this option is that it is for QuickBooks Online. Rest assured, I'll show you the counterpart for QuickBooks Desktop and how to pull up this report:

From the Reports menu, select Accountant & Taxes.
Choose Transaction Detail by Account.
Click the Customize button.
From the Total By drop-down menu, select Vendor.
In the Columns field, uncheck the Name, Adj, Split, and Balance options.
Still in the Column field, search for the Account option and check it.
Go to the Filters tab.
From the Account drop-down menu, choose Expense and other expense accounts.
Go to the Header/Footer tab.
Change the Report Title to Expenses by Vendor Detail, then click OK.

There you go. With these steps, you should be able to pull up a report in QuickBooks Desktop similar to what they're using in QuickBooks Online. You can also check out our guide on how to customize vendor reports for additional information.

Please keep me posted here on your progress with this, I want to make sure you're taken care. Thanks for reaching out, wishing you all the best.

Plinkr · ‎January 11, 2019

....never noticed the "QBO', my bad! :-/ I did find my solution though to produce a report for VENDOR "BILL payments" only. Just didn't have the time to try and figure out how to segregate the 1099 payments from the regular vendors. Doing it the way it was done served a purpose though, to ensure all of the Vendors are entered into QB correctly. THANKS SO MUCH! :) Enjoy your weekend!

AlcaeusF · ‎January 11, 2019

Hello Plinkr.

I appreciate your quick response and for getting back to us about the Transaction Detail by Account report in QuickBooks Desktop.

On behalf of my colleague @AldrinS, I'd like to say that we're happy you found the response helpful. In fact, he's actually behind me right now.

Please know we're always available here to help you succeed with QuickBooks. Just post a response and the Community will be sure to get back to you.

Thanks for coming, wishing you a safe and productive week ahead.

sb123 · ‎January 16, 2019

Hi Charles, thanks for the response. I am trying to make sense of the Cash version of the 1099 Transaction Detail Report. There are still Bills listed on this report............are we to assume that these are only the Bills that have been paid during the year? I think it would be clearer if this report only included bill payments and checks to 1099 vendors if it is cash basis.

Topics

Training

Community

Resources

How can I print a YTD report of payments to 1099 vendors in QBO