cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here

Reply to message

View discussion in a popup

Replying to:
IamjuViel
QuickBooks Team

Reply to message

Hello there, @Byrd28.

 

Making sure that your suppliers' balance is accurate is essential for organized bookkeeping. Let's generate and customize your Transaction List by Supplier. This way, we'd be able to determine where the open balance is coming from.

  1. Go to the Reports menu.
  2. Scroll down to the Expenses and Suppliers section.
  3. Select the Transaction List by Supplier.
  4. Click the Customise button.
  5. Set the Report Date Range to This Year.
  6. From the Rows/Columns section, mark the following tick box:
    • Date
    • Transaction Type
    • No.
    • Memo/Description
    • Account
    • Amount
    • Open Balance
  7. Expand the Filter section.
  8. Pick the name of the supplier that displays a higher open balance than the total of Unpaid Bills.
  9. Click the Run Report button.

Also, you can look into is your list of journal entries. Do you have any journal entries tied to the supplier? This may be impacting the open balance. The journal entry must include the Accounts Payable (A/P) in the ACCOUNTS column.

 

Lastly, you can follow the suggestions shared by, @Beremp.

 

Keep me posted if you have other questions about managing your vendor's balance. I'm always here to help.