cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
MariaG22
Level 1

Is there any way to view the balance after each transaction in supplier and customers statements? I do not want to see only the open balances.

 
1 Comment 1
LollyNino_C
QuickBooks Team

Is there any way to view the balance after each transaction in supplier and customers statements? I do not want to see only the open balances.

Welcome to the Community, @MariaG22

 

Allow me to chime in and guide you on how to tailor the Transactions Report. 

 

For now, QuickBooks doesn't have an option to create a vendor statement. As a workaround, we can run the Transaction List by Vendor and customize the report a bit. We can let the system generate a particular supplier as well as the paid amount and balance.

 

Let me walk you through how to do it. Here's how:

  1. Go to Reports on the left panel.
  2. In the search box, enter Transaction List by Vendor.
  3. Click the Customize button at the upper-right corner.
  4. Within the Filter section, tick the supplier you'll want to display on the report.
  5. Select BillsCheque Expense, Expense, and Bill Payment.
  6. Hit Run report. Also, make sure to set the correct dates.

We can pull up the Transaction List by Customer Report. Here's how: 

  1. Go to Reports at the top menu bar, then select Transaction List by Customer.
  2. Select the date you want to run the report.
  3. Click on the Filter icon and select Transaction Type.
  4. Click on the drop-down, then choose Payments.
  5. Click on Apply.

Once done, you should see all the payments from your customers. Also, you can get the report you need without the sale orders. You can also memorize it to save its current customization settings. It serves as your record and helps you access it for future use. 

I recommend running other reports to see if they can give you the information you're looking for. With the report customization options in QuickBooks Online, you may be able to customize something to see just what you need.

 

Reach out to me in the comment section below if you have any other issues or concerns. I'm more than happy to help. Have a great rest of the day!