Share this
5 Things You Need to Know About Vendors in QuickBooks
by Patty Carr on November 10, 2020
3 MIN READ
We field a lot of questions from advisors about how to handle vendors in QuickBooks. We get it. There’s a lot to keep track of and you signed up to be a financial advisor, not a bookkeeper. Well, that’s partly true. As an independent financial advisor, bookkeeping comes with the territory (along with marketing, compliance, sales, and everything in between). Lucky for you, we know a thing or two about QuickBooks here at FABC, where bookkeeping is our bailiwick.
Below, we offer answers to the five most common questions we get about vendors.
1. Do I need to enter vendor names?Yes, we highly recommend you enter a vendor name for every transaction. When you do this, you can easily track all expenses paid to that vendor.
Plus, QBO will pick up the vendor name in the review section of the bank feed and apply the same categorization to that expense. It’s a huge timesaver.
2. How do I see which transactions don’t have vendors?These transactions will show up as “Not Specified” on the Expenses by Vendor Summary Report.
- Go to Reports
- Enter Expenses by Vendor Summary in the search field
- Set the date and click Run Report
- At the bottom of the list you will see “Not Specified” if you do have transactions not connected with a vendor
If you want to add a vendor to those transactions, click on the dollar amount in the Not Specified section. Then, open each transaction and enter a payee. Click on Save and Close.
3. How do I add a vendor name?There are a few ways to add a vendor. The easiest way is to add it while you’re reviewing the transactions from your bank feed. If there is an expense from a new vendor, it will look something like this in QBO:
Click on that expense to open it. You will see this:
Type in "Spectrum". A new screen will appear.
Hit Save and Spectrum is now a Vendor. When you hit Save, it will take you back to the bank feed. From there, you simply add the expense to the register.
A second way to add a Vendor is to:
- Select Expenses in the left menu and go to the Vendors tab
- Click the New Vendor button on the top right
- Enter Vendor name and Save.
4. What else do I need to know about vendors?
You can edit a Vendor by selecting Expenses, then Vendors, select the Vendor you need to Edit, select Edit, make the necessary changes, then hit Save
If you realize that you have one vendor with two entries in QBO (ie. "RIGHTCAPITAL" and "Right Capital", you can Merge those Vendors. Select Expenses and then Vendors, Click on the vendor that you want to change (let’s say ‘Right Capital’), then select Edit. Change the title from "Right Capital" to "RIGHTCAPITAL". You will see this screen:
Hit Yes to confirm.
If you are no longer using a Vendor, you can make that Vendor inactive by selecting Expenses, then Vendors, and then selecting Make Inactive in the drop-down menu beside the Vendor that you want to make inactive
5. How do I set up vendors for 1099 tracking?**THIS IS IMPORTANT**
QBO will track your expenses to Independent Contractors, but that contractor/vendor must be set up correctly. This is how you do it:
- First, you will need to request a W-9 from that contractor
- In QBO, go to Expenses and then Vendors
- Using the information from the W-9, fill in the Vendor Information
- Check the box that says ‘Track payments for 1099’
- Fill in the Contractor's EIN or Social Security #
- Attach the W-9
- Hit Save
That’s it for today. Still feeling like you're in over your head with bookkeeping? Get in touch and we'll gladly throw you a life preserver.
About the Author
Patty Carr is an account specialist (aka Bean Counter) with FABC. She owned and operated a successful restaurant in Bozeman, Montana, selling it after 20 years of business. Patty's goal—in addition to keeping excellent books, of course—is to make a personal connection with her clients, and ultimately to make bookkeeping "cool."
Share this
- Bookkeeping (60)
- Financial Advisors (60)
- Financial Planning (60)
- XYPN Books (60)
- Outsourcing (45)
- Accounting (28)
- Small Business Owner (23)
- Taxes (15)
- Tech Stack (12)
- Tax Preparation (8)
- Expenses (4)
- Automation (3)
- Deducting Expenses (3)
- Financial Statements (3)
- Balance Sheet (2)
- Banking (2)
- Chart of Accounts (2)
- Financial Education (2)
- Reading Financial Statements (2)
- Recordkeeping (2)
- Staffing & HR (2)
- Budgeting (1)
- CARES Act (1)
- Cash Flow (1)
- Cash Flow Planning (1)
- Charitable Donations (1)
- Costs (1)
- Depreciation and Amortization (1)
- Donations (1)
- How to Choose a Bank (1)
- Industry Trends & Insights (1)
- Investing (1)
- Launching a firm (1)
- Mental Health (1)
- Opportunity Funds (1)
- Opportunity Zones (1)
- Payroll Service Provider (1)
- Per Diem Reimbursement (1)
- Productivity (1)
- Profit and Loss (1)
- RIA Operations (1)
- Receipts and the IRS (1)
- Review Your Books (1)
- Review Your Financials (1)
- Section 105 Plan (1)
- Spending (1)
- Split Transactions (1)
- Tracking Assets (1)
- Tracking Liabilities (1)
- Vehicle (1)
- Vendors (1)
- Virtual Advisor (1)
- June 2022 (1)
- April 2022 (1)
- March 2022 (1)
- February 2022 (1)
- January 2022 (1)
- September 2021 (1)
- August 2021 (1)
- June 2021 (1)
- May 2021 (1)
- April 2021 (1)
- January 2021 (1)
- November 2020 (1)
- September 2020 (1)
- August 2020 (1)
- June 2020 (1)
- May 2020 (1)
- April 2020 (1)
- March 2020 (1)
- February 2020 (1)
- January 2020 (1)
- December 2019 (1)
- November 2019 (1)
- October 2019 (1)
- September 2019 (1)
- August 2019 (1)
- July 2019 (2)
- June 2019 (2)
- May 2019 (2)
- April 2019 (3)
- March 2019 (2)
- February 2019 (2)
- January 2019 (1)
- December 2018 (2)
- November 2018 (2)
- October 2018 (3)
- September 2018 (2)
- August 2018 (1)
- July 2018 (2)
- June 2018 (1)
- May 2018 (2)
- April 2018 (1)
- March 2018 (1)
- February 2018 (1)
- January 2018 (1)
- December 2017 (1)
- November 2017 (1)