Fix Missing Vendors in QuickBooks Online with Uncat

Let’s say you have a bunch of transactions in QuickBooks Online (or QuickBooks Desktop or Xero) that are missing vendors. You want to see a list of these transactions so that you can assign the right vendors and/or create new vendors where necessary. And for many if not all of these transactions, you could use the help of your client since they’re the most likely to know who the vendor was for a particular transaction.

You can use Uncat to identify and enter missing Vendors and sync with QuickBooks Online, QuickBooks Desktop, or Xero. Meow!

1.

First, go to Client Settings and click the drop down menu for Sync All Transactions Missing a Field and choose Vendor and click Save.

2.

Second, if you don’t want to see some of the transactions that are missing a vendor because the transactions are in certain accounts, you can exclude those accounts from syncing to Uncat in the Hide Transactions from Accounts menu.

3.

Third, if you want your client to help identify the vendors that should be assigned to the transactions, you can activate the toggle switch for the Client Superpower setting and then make the Vendor field Visible and Editable. You can Require that your client choose a vendor if you’d like. And you can optionally enable your client to Create new vendors in QuickBooks Online. You’ll also want to make sure that Show as Table Column for Vendor is set to enabled. That way, you and your client will see a Vendor column in your Uncat dashboard without having to expand each transaction individually to see the Vendor field.

4.

Finally, you’re ready to assign vendors for transactions in your Uncat dashboard. You can select from your existing Vendors, or click the + button to create a new vendor in QuickBooks Online.

Bonus:

What if you want to assign the same Vendor to multiple transactions in Uncat? You can do it in Bulk. Simply select the transactions then click the Actions drop down menu and click Select Vendor and then choose a Vendor from the second drop down menu.

Previous
Previous

9 Movies Accountants and Bookkeepers Must Watch

Next
Next

8 Accounting/Bookkeeping YouTube Channels We Can’t Get Enough Of