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

How to fix? Vendors imported into customers list and i need a report showing categorized invoices each check run

#1 all of my VENDORS imported as CUSTOMERS and it shows they all owe a balance - how do I get this off?  It will not let me make them inactive. 

 

#2 I need a report showing the categories of each invoice each week when i write checks - all it shows is Accts payable.... I need to see what went to inventory and resale etc.

 

Thanks in advance :) 

5 Comments 5
Rose-A
Moderator

How to fix? Vendors imported into customers list and i need a report showing categorized invoices each check run

I'm here to help you sort things out, TessaT.

 

For us to inactive the imported customers (vendors), we need to zero out their balances. To do that, we can receive the payments and associate them with a dummy bank account.

 

Here's how to create a dummy account:

 

  1. Click the Gear icon and choose Chart of Accounts.
  2. Select New.
  3. Under Account Type column. Under the Name field, type in Dummy Bank.
  4. Hit Save and Close.

 

After that, we can record the payment through the Receive Payment option and deposit the payment to the Dummy Bank.

 

Or, we can delete transactions one at a time. Just open the invoice or bill, and click More at the bottom, then hit Delete. See the sample screenshot below.

z.PNG

 

Once done, we can go back and re-import your vendors. We can go through this article for your reference: Import customers or vendors from email contacts to QuickBooks Online.

 

On the other hand, we can generate the Transaction Detail by Account report to show all the invoices you need together with their corresponding categories.

 

 

I recommend customizing the report to get the specific details you need. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use. 

 

Should you need more help, please let me know, TessaT. I'd be more than willing to lend you a hand. Have a great rest of your day!

TessaT3773
Level 2

How to fix? Vendors imported into customers list and i need a report showing categorized invoices each check run

Ok, I will try that with the Customers problem.  When I try to run the report however this is what I am running into....

AbegailS_
QuickBooks Team

How to fix? Vendors imported into customers list and i need a report showing categorized invoices each check run

Thank you for the prompt response, @TessaT3773

It seems that you are trying to send us a screenshot for some clarification. However, no attachment that included. 

To further assist,  you can get back to us and attach the screenshot to provide you with the best resolution.

Keep me posted if you need further assistance with your books. I’ll get back as soon as I can. Stay safe!

TessaT3773
Level 2

How to fix? Vendors imported into customers list and i need a report showing categorized invoices each check run

It shows Accts Payable where I need it to show the actual category splits....   Do i need to enter my invoices differently?

Capture.PNG

Charies_M
Moderator

How to fix? Vendors imported into customers list and i need a report showing categorized invoices each check run

I appreciate the screenshot you provided, TessaT3773.

 

Let me continue to help you see the actual category splits of bills on your Transaction Detail by Account report.

 

Here's how:

 

  1. Go to Reports and find Transaction Detail by Account.
  2. Click the Customize button.
  3. Under the Filter drop-down, check the box for Transaction Type and select Bill.
  4. Check the box for Distribution Account and choose Accounts Payable (AP).
  5. Click Run report.

This will show the category details of the split transactions. 

 

Also, you can access all your pre-existing reports available within QBO through the help of these articles. This will help you know more about managing a wide range of reports in QBO without posting a question to the support page:
 

To help you with future tasks and tips when using QBO, you might want to visit our Help Articles.

 

The Community is always open if you have other questions managing transaction reports. I'll be around to help. Wishing you a great day ahead!

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

Need to get in touch?

Contact us