Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
O
orenmarciano
February 15, 2020
Question

Present Report of Bills to Pay to Owner for approval

  • February 15, 2020
  • 1 reply
  • 1 view

I am new to Quickbooks and trying to analyze if I can use it with my hotel in Costa Rica. 

 

My question is related to how my treasurer type employee, whose responsibility in this case to present me with a weekly report of all bills to paid to our different suppliers. We may be paying upwards of 20 suppliers in a week and currently he manually presents me with a list of the specific bills that we should pay to each provider based on when these bills become due. 

 

I am hoping there is a simple report he can create where he can filter which providers to consult and based on our internal rules of when to pay (related to due date for that provider) decide which bills he believes we should be paying, for my approval. Then I will somehow approve the list he presents (or possibly request changes based on my needs as business owner) after which he will load the payments to providers into our online banking portal (this process will happen separately from Quickbooks) for me to then approved the actually payments on the online banking site. 

 

At this point I am just testing out quickbooks to see if it can replace our current system of working. 

 

Thanks!

1 reply

S
SarahannC
Level 9
February 15, 2020

We can run the Vendors Balance Detail in your book, orenmarciano.

 

The Vendors Balance Detail report generates all bills to your different suppliers. In the Transaction Type column, you'll see the bills that you may need to pay. However, we can only filter it by the current week and the previous week.

 

What we can do is customize the report by the unpaid bills and select either the current week, next week and the previous one on the reporting period. Then, export it to Excel. This way, you can have these transactions by week through exporting them.

 

I'll guide you how:

  1. Go to Reports on the left panel and enter Vendor Balance Detail in the search box.
  2. Click the Customize button at the upper-right corner. Then, select the Filter section.
  3. Put a check inside the Vendor and A/P Paid boxes. For the Vendor side, select Specified so the report will populate by vendors. And for the A/P Paid, select Unpaid to see all the bills you may need to pay to your suppliers.

 

In the reporting period, you can filter the dates you want QuickBooks to populate. Then, export this report by clicking the Excel icon next to the small gear icon. Then, select Export to Excel. 

 

You'll want to make the report more personalize by checking out this article. 

 

Please get back to me if you have additional questions about QuickBooks Online reports. I'll be around anytime to assist you further! Take care!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement