cancel
Showing results for 
Search instead for 
Did you mean: 
AnnaSroka
Level 2

vendor view

Hi. Is there a chance you can change vendors view? At the moment, bill and expense/payment are both shown as a positive number giving the false total balance. You cannot clearly see what is the vendor balance. Even more, once you categorise the bank payment as A/P, it will appear in vendor's ledger as "expense", not as a payment and the status shows it was paid! You cannot see what payment wasn't allocated. Appreciate any advise.

5 Comments 5
ZackE
Moderator

vendor view

Hi there, AnnaSroka. Thanks for reaching out to the Community.

 

You can change the view of your vendors screen by accessing a vendor's profile, then using your filter options.

 

Here's how:

  1. In the left navigation bar, go to Expenses, then Vendors.
  2. Click a vendor's name.
  3. Use your Filter ▼ drop-down list.
  4. Choose an appropriate type and date range.
  5. Select Apply.

 

Another way to change the view of vendor profiles is utilizing your Gear (⚙️) icon and editing the way columns and rows are set up.

 

I've also included a detailed resource about working with vendors which may come in handy moving forward: Manage vendors

 

Please don't hesitate to send a reply if there's any questions. Have an awesome day!

AnnaSroka
Level 2

vendor view

thanks for the replay, although here is my point. On the attached pic, we have listed expense as a payment and bill - both as a positive numbers. And suddenly open balance shows negative amount. How? It is not logical.

LollyNino_C
QuickBooks Team

vendor view

You came into the right place for help, @AnnaSroka

 

Let me show you how to turn a negative number in an expense transaction into a positive number. 

 

The negative numbers on the accounts indicate that the company owes a credit balance, causing it to pay more than expected. This can be fixed by making a Journal Entry credit to the impacted accounts. The balance will be zeroed out in this manner. Before doing so, I recommend reaching out to your accountant so they can guide you on which accounts to choose. 

 

Here's how to create a journal entry:

 

  1. Go to + New icon.
  2. Select Journal entry.
  3. On the first line, select an account from the Account field.
  4. Select the other account you're moving money to or from on the following line.
  5. Check the amounts - you should have the same amount in the Credit column on one line and the Debit column on the other. This means the accounts are in balance.
  6. Enter information in the memo section to know why you made the journal entry.
  7. Choose Save and new or Save and close

 

To learn more about Journal entries click on this article: Create a journal entry in QuickBooks Online. In case you want to review the entries made, you can pull up or print a report for Journal. 

 

You  might also want to check out these articles that can give some insight into reconciling process: 

 

If there's anything else that I can help you with aside from understanding the negative balance of your customer, please let me know in the comments below. I'll be here ready to lend a helping hand. Have a good one! 

AnnaSroka
Level 2

vendor view

thanks, unfortunately that doesn't solve my question.

 

Could you please let me know how can I see which payment hasn't been allocated on the vendor ledger? All payments/expenses have status "paid". thanks

Candice C
QuickBooks Team

vendor view

Welcome back, @AnnaSroka

 

I appreciate you responding and letting us know how those steps went. 

 

Let's try reviewing some reports to get the information you need within your QuickBooks Online account. Running a Vendor Balance Summary may help in this case. Here's how to run the report: 

 

  1. Go to the Reports tab on the left-hand menu bar. 
  2. Click the Standard section of the page. 
  3. Scroll down and locate the Vender Balance Summary report. 

 

You can also customize it to your liking. It's that easy! 

 

I hope this helps. If not, don't hesitate to reach back out. Have a great day! 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us