cancel
Showing results for 
Search instead for 
Did you mean: 
userjcrabtree
Level 3

Expenses by Vendor Summary Report - Cash vs. Accrual Basis

I am trying to reconcile the difference between the Cash Basis and Accrual Basis for the Expenses by Vendor Summary. 

 

For Vendor A, the Cash Report Shows 48,805.72 for the year 

For Vendor A, the Accrual Basis Shows 35,960.27 for the year. 

 

Can you help me explain the difference between these two amounts? 

Why do some of the transactions show up in the Cash basis but not the accrual basis? 

 

Here is an example of what I am trying to figure out - this is specific to one of the bills 

Cash Basis Shows the full Bill amount applied to the vendor - 418.49

Accrual Basis Shows only 9.50 applied to the vendor. 

Accrual Basis does not show the remaining 408.99 applied to the vendor. 

That 408.99 is made up of products that are COGS (Inventory). 

 

Is that why I am not able to see the amounts under the Expenses by Vendor Report? 

Because they were inventory items? There was a corresponding bill sent to our client but it still does not show that the remaining COGS amount (408.99) applied to the vendor. 

 

If anyone can help me with this I would really appreciate it. 

 

3 Comments 3
Jovychris_A
Moderator

Expenses by Vendor Summary Report - Cash vs. Accrual Basis

Hi, @userjcrabtree.

 

I can share some insights about the differences between the accrual and cash base accounting methods in expenses.

 

Expenses on the accrual basis include everything you owe, regardless of whether or not you've sent a payment, while Expenses on a cash basis include only the values that you have already paid.

 

This is why Accrual Basis shows only the 9.50 applied to the vendor, and the Cash Basis shows 418.49. You can also see this in your other vendor report data. In addition, I'd like you to check with your accountant if you need more advice about how the amounts work and affect other accounts in your books. If you don't have one, you can search here.

 

Furthermore, feel free to read through these resources to learn more information about the accounting methods in QuickBooks Online and how they affect income and expense reports:

 

 

Let me know if you have other QuickBooks concerns about running reports. I'm always here to lend a hand. Take care, and more power to your business!

userjcrabtree
Level 3

Expenses by Vendor Summary Report - Cash vs. Accrual Basis

Hi Jovychris_A

 

Thank you for the reply! Here is what I am running into with that explanation. 

We already paid for this invoice, both on a cash and accrual basis. There is no balance outstanding for this transaction. That is why it is confusing to me that it does not show up as an expense to this vendor. 

 

Because we provide supplies to client's at zero cost, I had sent an invoice to the client for 0.00. 

I would think that would allow the full amount of to post on the Expenses by Vendor Summary. 

 

But I do not see it listed. It seems as though the inventory items listed do not get applied to the vendor in the cash basis of expenses by vendor summary, even if the vendor bill has been created. 

 

Does that make sense? 

JamesAndrewM
Moderator

Expenses by Vendor Summary Report - Cash vs. Accrual Basis

I appreciate you for coming back to the thread, @userjcrabtree.

 

Let's customize the date of the transactions before we run the Expenses by Vendor Summary report

 

For the Accrual method, we can check if the date is according to when the bill was created. And for the Cash method, let's make sure the date is exactly as when the payment has been made. This is to ensure that both the accrual and cash balance match. 

 

If this doesn't match the two amounts, we can check the payment applied in the cash method if it is the correct amount.

 

I'll also provide articles below to help you learn how:

 

 

Know that the Community is always here to back you up. Have a great day ahead.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us