Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 3

1099-MISC cash basis errors

We have vendors to whom we pay interest each year, so we issue them a 1099-INT. Some of these interest payments must be paid by December 31, so they often don't clear the bank until January of the following calendar year. But when I run the 1099-MISC report (since QB doesn't have a 1099-INT category, but the form is the same), even though it is on a cash basis, those payments do not appear. Has anyone else run into this problem? I end up having to make a fake expense entry just for the purpose of the 1099s and then deleting it, but that is obviously less than ideal. It seems like a programming issue as a check that hasn't cleared the bank is not an expense in cash accounting. This is driving me nuts!

2 Comments
QuickBooks Team

1099-MISC cash basis errors

Good day, edenwillow.

 

The accounting method used affects your reporting in QuickBooks Online. If it's a cash basis, your report counts it as an expense when the amount is paid. Otherwise, the payment won't show if it's not yet cleared by the bank.

 

Aside from that, payments to 1099 vendors that are made via credit card, debit card, or third party system will be excluded.

 

In case you'd like to change the method used on an individual report, I suggest following these steps:

 

  1. Go to the Reports menu.
  2. Select a report.
  3. Choose Cash or Accrual under the Accounting method.
  4. Click on Run report.

 

Additionally, I've added an article that'll help personalize the details you'd to see in the report: Customize Reports.

 

Let us know if there's anything else you need. We're always here to help.

Level 3

1099-MISC cash basis errors

Thank you for your response - yes I understand this and made my own 1099 reports on a cash basis. However there are two problems:

 

1) I am trying to prepare and print the 1099s through Quickbooks, and when I click on the total vendor 1099 amount (in the "Check that the payments add up" window), the transaction detail report that opens is an accrual basis report. I don't see a way to change that.

 

2) Even on my cash basis 1099 reports, checks that were written in the year in question but have not cleared in that year still appear, and checks that *did* clear in that year but were written in the previous year do *not* appear. This definitely seems incorrect, since the funds don't leave our account until the check clears.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us