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!
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:
Go to the Reports menu.
Select a report.
Choose Cash or Accrual under the Accounting method.
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.
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.