Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
#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 :)
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:
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.
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!
Ok, I will try that with the Customers problem. When I try to run the report however this is what I am running into....
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!
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here