Learning Center
We keep you up-to-date on the latest tax changes and news in the industry.
How to Create and Use Vendor Records in QuickBooks Online
Your company counts on its supply chains to keep operations running smoothly. When it falters, you can have trouble creating and shipping products. Problems may even crop up that have a negative effect on your internal business needs.
We don’t have to tell you that COVID-19 has interrupted supply chains. The pandemic has been catastrophic for many small businesses because of this, and because income has been suddenly and sharply reduced. Some financial help is available, and we hope you’re able to take advantage of it during these extraordinarily difficult times.
It’s perhaps more important than ever to carefully track your income and expenses, and we hope you’re using QuickBooks to do so. Among the software’s financial management tools is the ability to maintain thorough records of those vendors that make up your supply chain. Let’s take a look at how this works.
Creating Vendor Records
We’ll go through the steps for creating vendor records, though you may have at least started on these already. Hover your mouse over Expenses in the toolbar and select Vendors. If you’ve already added some, you’ll see them in a list. To create a new one, click New Vendor in the upper right. Most of the form is easy to complete; it’s primarily contact information.
There are a few fields, though, that need special attention. These are:
- Cost rate/hr and Billing rate/hr. These help you track time costs for your projects. Don’t enter anything here if you pay vendors via bills or expenses.
- Terms. Due on receipt? 15 days? 30 days?
- Account no. and Business ID No. You should have these on file.
- Track payments for 1099. Put a check in this box for any 1099 contractors.
Taking Action
You can take a number of actions from QuickBooks’ Vendors screen.
You can do a lot of your work directly from QuickBooks’ Vendors page. This screen displays a list of all of your vendors, along with columns for their Phone
, Email, and Open Balance. At the end of each row is an Action column. The link there reads either Create bill or Make payment, depending on whether there is an outstanding balance.
Click on the down arrow in that column to open a list of additional options. If there is a zero balance, you can Create expense, Write check, Create purchase order, or Make inactive. If money is due, your options are to Create bill or Create expense. Icons in the upper right allow you to print the list, export it to Excel, or change the column settings.
Collecting Your Billables
Before we look at vendor records in QuickBooks, we’d like you to check a couple of settings to make sure you’re billing your customers for every expense they incur with you. Click the gear icon in the upper right corner and select Your Company | Account and Settings, then click on Expense. Among others, you’ll see these options:
If you incur expenses on behalf of customers, be sure you will be reimbursed for them by adding a Billable column on expense and purchase forms.
To add a Customer column to expense and purchase forms, click in the first box pictured in the image above. To Make expenses and items billable, click in the second box and add a default markup rate if you want. Do you want to Track billable expenses and items as income? If you’re not sure, ask us. And if you’ve set up sales tax in QuickBooks and want to add that to billable items, check that box, too. When you’ve finished with these and the other questions under Bills and expenses, click Save.
Now is the time to focus on the importance of cash flow and vendor relationships by maintaining good vendor payable records. You want to keep your relationships with your suppliers in good status. If you’re having trouble tracking cash flow or dealing with any other element of your accounting (or QuickBooks itself), please do contact us. We want to support you through this difficult period as much as we can.
Want our best tax and accounting tips and insights delivered to your inbox?
Sign up for our newsletter.
Benefits of having a business advisor
Your CFO, Reimagined as a Financial Doctor
Diagnosing root causes, prescribing solutions, and guiding your property business toward long-term wealth.
Our CFO | Advisor
Raquel is a passionate business owner. Now, she is returning to her grassroots with a twist - guiding clients with her expertise as a CPA, she can advise your company as your trusted CFO and Advisor.
-
Raquel Deodanes, MS, CPA
Co-Founder✅ CPA with Real-World Experience – I help property managers stay profitable, tax-efficient, and cash flow positive.
✅ Tax Strategist – Former advisor at California’s revenue agency.
✅ Trusted by 4,000+ Businesses – Experience across CA, FL, TX, NV, and beyond.
✅ Real Estate Investor – I understand the financial realities of property management.
✅ Entrepreneur – I’ve built businesses and know the challenges you face.
Frequently Asked Questions
-
We diagnose financial inefficiencies, treat problems like poor cash flow or rising costs, and guide you to long-term financial health. That includes cleaning up your books, forecasting cash flow, optimizing operations, and helping you grow your portfolio with confidence — just like a doctor builds a custom care plan for a patient.
-
Bookkeepers record transactions. CPAs file your taxes. We connect the dots — helping you understand your numbers, strategically improve them, and make smarter decisions throughout the year. We work alongside your existing team to drive performance, not just compliance.
-
If you're unsure where your cash is going, struggling with rising costs, planning to scale, or just tired of reacting instead of planning — now is the right time. We help you get ahead of problems, not just clean up after them.
-
Clients typically see improved cash flow, cleaner books, higher NOI, better financial reporting, and a lot less stress at tax time. More importantly, you gain clarity, confidence, and control over your business — and a partner who helps you grow it.
Pricing
Painless, transparent pricing.
Let us take away your stress and give you back your time. Choose your perfect package today.
Base
-
Dedicated finance expert
-
Bookkeeping with accrual basis
-
Includes P&L, balance sheet, and cash flow statements
Core
-
Includes everything in Base, PLUS
-
Industry KPIs and financial ratios
-
Monthly virtual 1-hr meetings
-
Monthly rolling budget forecasts
Growth
-
Includes everything in Base, CORE
-
Budget vs. actuals variance analysis and review
-
Payroll and HR Platform