1099 Report Shows on Accrual but not Cash Basis

Hello, @Victoria_M.

Thank you for reaching us here in the Community. I'll provide information about the amounts shown on your 1099 report.

It might be that the transactions on bills are still unpaid, which explains why they show on an accrual basis.

Follow the Accounts Payable (AP) process in paying bills to show cash basis transactions. Reports must fall within the date range when the bills have been paid.

You may also check the filter and make sure to modify the required details before running the report.

For more information about your 1099 report concerns, please refer to these articles:

• Set up contractors and track them for 1099s in QuickBooks
• Get answers to your 1099 questions

If you have any other questions about running your 1099 reports, let me know by adding a comment below. Have a great day.

There are payments made through "Expense" and via Bills. I understand why accrual shows the billed amount. I don't understand why Cash basis doesn't show amounts paid via "Expense".

Hello there, @Victoria. Thank you for getting back to the thread. Let me add some details about the accruals and cash basis and how it will affect the reports.

If you're using the Accrual method, you'll record the income and expenses when you send the invoice or receive the bill. In the reports, the accrual method counts income and expenses regardless of if the invoice or bill was paid or not. Then the income or expense amount will show on the report even if the money hasn’t changed hands yet.

On the other hand, if you're using the Cash method, you'll record income and expenses at the time you actually receive a payment or pay a bill. And in the report, will only count income and expenses once you get a payment or pay a bill. So if you sent an invoice or got a bill but the money hasn’t changed hands yet then, the income or expense amount will not b included on the report.

You can refer to this article for more details: Choose between cash and accrual accounting methods in QuickBooks Online.

I've also added the following articles for more details about customizing and running reports in QuickBooks Online:
 

• Customize reports in QuickBooks Online
• Run reports in QuickBooks Online
   

Feel free to post a reply if you have clarification or additional information about the accounting method or if you have any other QuickBooks-related concerns. I'll be here for you. Keeps safe!

Thank you, I understand how cash and accrual basis work. I think there is something with QBO reporting.

I've created a new test vendor, marked "track 1099". I've created an Expense for $700 (the only transaction for this vendor).

I ran 1099 report on a cash basis. The report has no data, see attached.

I've read somewhere that you need to click "process 1099" to activate reporting. 

However, the option is not available with the message "you can begin preparing your 1099 soon".

It's my pleasure to assist you today, @Victoria_M.

Before we report this issue to our engineers, I need to ask if you did some initial troubleshooting to fix the problem. Have you tried opening your account and opening the report in a private web browser?

Unexpected issues in QuickBooks are sometimes associated with the amount of data stored in the cache. This is because a regular browser will constantly overwrite itself and will not remove history unless done manually.

Private browsing will not save any history, so it's a great place to identify issues in the browser. Use these keyboard shortcuts to launch a new private window:

• Google Chrome: press Ctrl + Shift + N  
• Mozilla Firefox: press Ctrl + Shift + P
• Safari: press Command + Shift + N

You may try a different browser too, and see if the problem persists there. If you can use the feature in QuickBooks without any issues using the workaround, clear the cache to start with a clean slate. 

If you keep getting the same problem, I highly recommend contacting our QuickBooks Online Care Team this time. They can check if there are similar reports from other users and help open an investigation on this unexpected behavior. 

Follow these steps to reach out to a live agent:

1. Go to the Help menu then choose the Search tab.
2. At the bottom click on Contact us.
   
3. Enter the keyword Account Management and Billing in the What can we help you with? box.
   
4. On the next screen, scroll down to How would you like to connect with us section.
5. Choose Chat with us to initiate a discussion with a live agent.
   
6. Enter you account contact information then press Get a chat.
   
7. When using this option, make sure to enable pop-up windows. The chat box will appear at the bottom right section of your monitor, and an agent will be with you shortly after. See this:

When you're connected, provide all the information about your concern or request a viewing session when needed. 

Post here again if you have other concerns with the features in QuickBooks. I'll be right here if you need further assistance. Have a nice day.

Hello,  We just upgraded to QB 2022.  The vendor 1099 summary and detail reports do not populate with vendors now.  Why is this?

Hello there, LegalS.

You may be experiencing some data issues. Thus, the lists of vendors don't populate on the report. You can resolve this by running the recommended troubleshooting steps.

To start with, open the 1099 report on a private window. This page doesn't store cache history, thus helps the browser to load faster. You can use these keys to open one:

• Google Chrome: Ctrl + Shift + N  
• Mozilla Firefox:  Ctrl + Shift + P
• Safari: Command + Shift + N

If it works, clear the cache to start with a clean slate. 

If you're still unable to see the vendor's name, you can browse this article for other troubleshooting steps: Fix missing contractors on the 1099s report.

I've also added the following articles for more details about customizing and running reports in QuickBooks Online:
 

• Customize reports in QuickBooks Online
• Run reports in QuickBooks Online

Keep me posted as to how things work on you end. I'll be around to ensure everything works well.