United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more
Mae_1234
Level 1
posted
‎August 14, 2020 12:25 AM
last updated ‎August 14, 2020 12:25 AM

Possible Report to Generate in Quickbooks

Hi,

 

I would like to ask if it is possible to generate a report that will shows a supplier balance.

Example:

In a construction company we have subcontractor and there contract price amounting to 1,000,000.00. We would like to know the following details through the report that I have ask.

Total Contract Price - 1,000,000.00

1st Progress Billing - 100,000.00 w/ Expanded Tax

2nd Progress Billing - 200,000.00 w/ Expanded

Also, Please see uploaded file for your reference.

 

 

We already tried to explore quick books and the only thing that we have found that the same to the report that we wanted is Transaction List by the Supplier Only.

 

Reply
1 Comment 1
Rea_M
Moderator
Moderator
‎August 14, 2020 02:42 AM

Possible Report to Generate in Quickbooks

You're on the right track in generating the report that'll show your supplier balance in QuickBooks Online (QBO), @Mae_1234. Let me provide further details about this.

 

Yes, you're right. Currently, it's the Transaction List by Supplier report that'll provide you the supplier balance as well as the progress billing information amounts based on your description above. You can customize the said report to display the available open balance amount for your supplier. Here's how:

  1. Go to the Reports menu.
  2. Type in Supplier in the search box, then choose Transaction List by Supplier.
  3. Set the report date in the Report period field.
  4. Go to the Gear icon above the report, then select the Show More option.
  5. Click the box beside Open Balance.

 

I've attached a screenshot of the outcome after performing the steps above.

 

After customizing, you can memorize the report to save its current settings. For the detailed steps, kindly check out this article: Memorise reports in QuickBooks Online. It also contains instructions on how to set a schedule and email information for a memorized report or group.

 

I'm also adding this article for the complete list of available reports based on your QBO version: Reports included in your QuickBooks Online subscription.

 

Please let me know if you have other concerns. I'm just around to help. Take care always.

Reply