IamjuViel
QuickBooks Team
QuickBooks Team
‎December 08, 2020 12:28 PM

Other Questions

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.

Reply