Is it possible to run a report in QBO that lists each cash payment by vendor that went out during a month? So it would include bills paid (could be a bill from a prior period) as well as expenses paid that month.
Hello there, @mtestoni2.
Yes, you can use the Transaction List by Vendor Report so that you can see the each Bill Payments paid. Then, customize it to show the month's transactions with the vendors including the expenses.
I've added some snapshots for additional reference about the process:
You may consider checking this article that has multiple ways on how to manage your business reports to the next level: Run reports in QuickBooks Online. This contains sub-articles such as payroll reports and memorize reports.
Do you have other questions in mind? You can always post it in the comment section or create a new thread to be assisted. Enjoy the rest of your day!
This does not list payments that are "cash" expenses recorded, ie, not hitting Accounts Payable.
I want a list of all cash payments made, which would include bill payments and expenses paid without recording a bill first, including credit card charges.
It's also possible that we have paid entities that are not vendors. A refund to a customer or a due to shareholder payment would not be captured, for example.
Again, what i'd like is a list of cash outflows in a given period of time.
Hi there, @mtestoni2.
I appreciate you for getting back to us and adding more details. I'm here to help you run the report you need in QuickBooks Online.
I recommend using the Transaction List by Date report to show the complete list of transactions. To ensure the details you want will show, please review and make the necessary changes to the filters.
For more information about running reports, like how you can personalize them based on your needs, as well as some tips on tracking your cash flow, I recommend the following articles:
Keep us posted if you need anything else regarding the report. I'll be happy to help you some more.
This does not capture all outflows.
For example, our payroll is recorded using a journal entry with a credit to our bank account. Those cash outflows are not showing in this report, even when I include journal entry as a transaction type.
In fact, all of the journal entries are shown at the bottom of the report, with no dollar amounts.
This really seems like it should be a simple ask: List of outflows for each cash account for a given period of time.
Allow me to join this thread and share some details about the report you need.
You'll want to pull up the Transaction Detail by Account instead. Then, we just need to filter and customize it the same way as mentioned by my colleague.
Also, here's the list of reports included in your QuickBooks Online subscription and how to customize them.
Leave a reply again if you need anything else. Take care!