This text offers a detailed guide to using QuickBooks Desktop 2022. It covers a wide range of functions, including setting up company files, customizing the user environment, and managing customers and vendors. The text further explains handling inventory, creating invoices, managing bills, and generating financial reports. It also provides guidance on setting up users, managing payroll, and using the income tracker, aiming to help users optimize their QuickBooks experience. The guide walks users through detailed tasks like creating invoices from estimates, entering bills against inventory, and applying vendor credits.
QuickBooks Online/Desktop Study Guide
Quiz
Answer each question in 2-3 sentences.
- What is the purpose of setting a start date when creating a new bank account in QuickBooks?
- Explain the difference between a fixed asset and a liquid asset.
- Why is it recommended to create “big bucket categories” for assets instead of listing each asset individually?
- What is a liability in the context of accounting and QuickBooks? Give an example.
- Why should a business owner think about organizing expenses into sub-accounts?
- What does “net 30” mean in the context of customer invoicing?
- What is a sub-customer in QuickBooks, and why might a business use them?
- Why can’t you delete a customer in QuickBooks Online?
- Explain the purpose of “undeposited funds” in QuickBooks.
- What is a customer statement and what information does it typically include?
Quiz Answer Key
- The start date is used to begin tracking the money in the account and helps when reconciling with bank statements. It’s best to choose a date that corresponds with the beginning of a bank statement period to ensure accurate records.
- A fixed asset is something a business owns and plans to keep long-term, like a vehicle or property, whereas a liquid asset is something more easily converted to cash, like inventory. Liquid assets are meant to be sold or used quickly.
- Creating big bucket categories for assets keeps the chart of accounts organized and prevents it from becoming overwhelming. It simplifies financial reporting and makes it easier to understand the overall asset picture of the business.
- A liability is something a business owes to others, such as a loan from a bank. It represents an obligation to pay money or provide goods/services in the future.
- Organizing expenses into sub-accounts allows for more detailed tracking and reporting of specific expense types, such as fuel being a sub-account of car and truck expenses. This enables better analysis of where money is being spent and helps identify areas for potential cost savings.
- “Net 30” means that the full payment for an invoice is due 30 days from the invoice date. It’s a common payment term used to grant customers a specific period to settle their outstanding balance.
- A sub-customer is a way of adding a level underneath a main customer; it can be a specific job, project, or location associated with that customer. Businesses use sub-customers to track revenue and expenses for individual projects or locations related to a single client.
- QuickBooks Online doesn’t allow customer deletion to maintain data integrity and prevent the loss of historical transaction information. Instead of deleting, customers can be made inactive, which hides them from most lists but preserves their data in the system.
- “Undeposited funds” is a temporary holding account in QuickBooks for payments that have been received but not yet deposited into a bank account. This allows you to accurately record when money was received versus when it was actually deposited, especially when combining multiple payments into a single deposit.
- A customer statement is a summary of a customer’s account activity, typically sent at the end of each month, to remind them of any outstanding balances. It includes a listing of invoices, payments, credits, and the total amount due.
Essay Questions
- Discuss the importance of setting up a well-structured chart of accounts in QuickBooks. How does it impact financial reporting and decision-making for a business? Provide specific examples of how different account types (assets, liabilities, equity, income, expenses) contribute to a clear financial picture.
- Explain the accounts receivable workflow in QuickBooks. From creating a customer to receiving payment, outline each step and discuss the key features and reports available to manage and track customer balances effectively.
- Describe the differences between using sales receipts and invoices in QuickBooks. In what scenarios would each be most appropriate, and what are the implications for accounting and financial tracking?
- Discuss the process of managing vendor relationships and accounts payable in QuickBooks. How can QuickBooks help a business track bills, schedule payments, and manage vendor credits effectively?
- Explain the purpose of the tags feature in QuickBooks and how it can be used to improve financial tracking and reporting. Provide specific examples of how businesses can leverage tags to gain insights into their revenue and expenses.
Glossary of Key Terms
- Account Type: A classification within the chart of accounts that defines the nature of a financial element (e.g., asset, liability, equity, income, expense).
- Asset: Something a business owns that has economic value (e.g., cash, accounts receivable, inventory, equipment).
- Liability: Something a business owes to others (e.g., accounts payable, loans).
- Equity: The owner’s stake in the business, representing the residual value of assets after deducting liabilities.
- Income: Revenue generated from the sale of goods or services.
- Expense: Costs incurred in the process of generating revenue.
- Chart of Accounts: A structured list of all the accounts used to record financial transactions in a general ledger.
- Sub-Account: An account that falls under a main account, providing more detailed categorization and tracking.
- Accounts Receivable: The money owed to a business by its customers for goods or services sold on credit.
- Invoice: A bill issued to a customer for goods or services, requesting payment within a specified timeframe.
- Sales Receipt: A record of a sale where payment is received at the time of the transaction.
- Customer: An individual or business that purchases goods or services from another business.
- Vendor: An individual or business that supplies goods or services to another business.
- Credit Memo: A document issued to a customer to reduce the amount they owe, often due to returns, allowances, or errors.
- Undeposited Funds: An account used to temporarily hold customer payments before they are deposited into the bank.
- Statement: A summary of a customer’s account activity, including invoices, payments, and outstanding balance.
- Tags: Customizable labels that can be assigned to transactions to categorize and track specific aspects of a business’s finances.
- Purchase Order: A document issued to a vendor, authorizing the purchase of goods or services.
- Inventory Part: A physical item that a business buys, stocks, and sells.
- Service Item: A non-physical service that a business provides.
- Cost of Goods Sold (COGS): The direct costs associated with producing goods or services that a company sells.
- General Ledger Number: A unique number assigned to each account in the chart of accounts for identification and organization.
QuickBooks Account, Customer, and Inventory Management Guide
Okay, here’s a briefing document summarizing the key themes and ideas from the provided source, including relevant quotes:
Briefing Document: QuickBooks Account Setup, Customer Management, & Inventory
Overview:
This document reviews key aspects of setting up and managing accounts, customers, and inventory within QuickBooks. It covers topics ranging from chart of accounts configuration to managing customer invoices and payments, as well as utilizing features like “Tags” for enhanced reporting. It covers both online and desktop versions of Quickbooks.
Key Themes and Ideas:
1. Chart of Accounts Setup:
- Account Types: The document emphasizes selecting the appropriate account type (e.g., Bank, Asset, Liability, Equity, Income, Cost of Goods Sold, Expense) when creating new accounts. “First thing you’re going to do is pick the account type in this case it will be bank but notice all the other types we’re going to be talking about.”
- Naming Conventions: Flexibility is offered in naming accounts. “When you name your account you can name it anything you want.” Examples include naming bank accounts by bank name or using descriptive names like “Operating Account” or “Payroll Account.”
- Start Dates and Balances: The importance of using accurate start dates and beginning balances is highlighted to ensure accurate financial tracking. “Just try to make it correspond to the start date of your bank statement.”
- Sub-Accounts: The briefing details the use of sub-accounts for more granular tracking within a main account. “See how fuel looks like it’s indented a little bit that’s a sub account and there’s going to be a lot of these you’ll want to add.” Examples include fuel and insurance under auto, and accounting/attorney fees under legal and professional fees.
- Assets: Differentiates between fixed assets (long-term, like vehicles or property) and liquid assets (like inventory). Emphasizes using “big bucket categories” for assets rather than listing each item individually.
- Liabilities: Differentiates between short term and long term liabilities. “When you think about your liabilities there to the new option in the top right of your screen here you are going to create a new account and it has to be the same type as the main account so that means this one has to be an expense account and in this case it is Auto and I want to name this one fuel”
2. Customer Management (Accounts Receivable):
- Customer List Navigation: Explains how to access and navigate the customer list, emphasizing alphabetical organization by last name for easy searching.
- Customer Information: Details the information that can be stored for each customer, including company name, contact details, billing/shipping addresses, and email addresses.
- Sub-Customers (Jobs/Projects): Describes how to set up sub-customers to track different jobs or projects for the same customer. This enables detailed reporting at both the customer and project levels. “A sub customer is basically going to be a way of adding a level underneath your main customer if you have different jobs that you work on for a particular customer you can actually separate those jobs by actually creating sub customers then you can look at reports for the entire customer but also per sub customer”
- Inactivating Customers: Explains how to make customers inactive rather than deleting them, particularly if they have a history of transactions. “Inactive customers actually will not show up when you’re working in other areas of QuickBooks but if you wanted to actually turn them back on you could go and activate them again”
- Importing Customers: Details the process of importing customer lists from Excel or CSV files.
3. Sales and Invoicing:
- Sales Receipts vs. Invoices: Clarifies the distinction between sales receipts (for immediate payment) and invoices (for future payment). “…the difference in a sales receipt and an invoice is that on a sales receipt the customer is standing right there”
- Creating Sales Receipts: Explains how to create sales receipts, including selecting products/services, quantities, prices, payment methods, and deposit accounts (including “undeposited funds”).
- Invoicing Customers: Details how to create and send invoices, including customizing invoice templates, adding line items, and applying customer discounts.
- Receiving Payments: Describes the process of recording customer payments against open invoices. Explains the function of undeposited funds.
- Deposits: “Now that we’ve made a sale for our business we’ve actually invoiced a customer in this case we got paid and now we want to take that money and put it in the bank and that’s where the make deposits option comes in”
- Credit Memos: Explains how to issue credit memos to customers, either to correct errors or to provide refunds.
- Statements: States that “…a statement is basically a gentle reminder to your customers that they owe you some money typically statements are sent at the end of each month and they show the activity that happened during that month you don’t have to send out statements but it’s a nice little feature to keep your customers abreast of what’s going on with their account”
- Customer groups “This is a newer tool designed to help small business owners with one of the hardest problems that they have and that’s actually getting your customers to pay you”
4. Inventory Management:
- Item Types: Explains the various item types available in QuickBooks (Service, Inventory Part, Non-Inventory Part, Other Charge, Subtotal, Group, Discount, Payment, Sales Tax Item, Sales Tax Group).
- Inventory Parts Setup: Describes how to set up inventory parts, including defining purchase and sales descriptions, costs, prices, preferred vendors, and initial quantities on hand.
- Purchase Orders: Details the process of creating purchase orders to track inventory orders.
- Vendor credits “Sometimes a vendor will issue you a credit that you need to apply to a bill or it could be you want to apply it to your account and use it in the future but I want to show you how to handle those once the vendor sends them to you”
5. Quickbooks Preferences
- “The preferences in QuickBooks control how QuickBooks is set up and that way it matches your business needs” *You can change how different features are set up in the Quickbooks Desktop Version.
6. Users
- You do not have to set up users in Quickbooks but it is higly suggested.
- Setting up users will allow you to set up different permissions for different people who use Quickbooks
7. Tags:
- A brand new feature in Quickbooks online that will allow you to create words that will appear on a drop down list when you are in different transactions.
8. Jobs
- “For example, you might want to keep track of how profitable it was to remodel the kitchen versus building an addition”
Conclusion:
This document provides a high-level overview of setting up and managing critical business functions within QuickBooks. By following these guidelines, businesses can establish a solid foundation for accurate financial tracking and efficient customer relationship management.
QuickBooks Online and Desktop: Common Accounting Tasks
QuickBooks Online and Desktop FAQ
- How do I set up a new bank account in QuickBooks? First, select the bank account type. Then, name the account (e.g., “Checking,” “Operating Account”). An optional description can be added. Select a start date for tracking money; using the beginning of the fiscal year or month is recommended. Enter the ending balance from the prior period’s bank statement as the starting balance. Remember this impacts opening balance equity. Bank accounts can also be set up for PayPal, Square, etc.
- What are assets in QuickBooks, and how should I categorize them? Assets are items your business owns that add value. They are divided into fixed assets (long-term, like vehicles or property) and other current assets (more liquid, like inventory). Create broad categories for assets (e.g., “Vehicles,” “Furniture and Fixtures,” “Equipment”) rather than listing each item separately. Aim for 7-10 categories. An accountant can help you decide categories and values, including depreciation (which QuickBooks does not automatically handle).
- How do I create sub-accounts in QuickBooks, and what are they used for? When creating a new account, choose the “sub-account of” option and select the main account. Sub-accounts provide more detail within a broader category, such as “Fuel” as a sub-account of “Car and Truck.” This helps organize expenses and other categories for detailed reporting.
- What is Accounts Receivable, and how do I manage customers in QuickBooks? Accounts Receivable represents money owed to your business by customers. To manage customers, navigate to the “Sales” section, then “Customers.” You can view open invoices, overdue amounts, and payment history. The customer list displays names, phone numbers, and balances. Customers can be added manually or imported from Excel.
- How do I add a new customer and a sub-customer (job) in QuickBooks? To add a customer, click “New Customer” and enter company and contact details, billing/shipping addresses, and payment settings. Display names can be customized. To add a sub-customer, click “New Customer” again, enter the sub-customer’s name and details, and choose the parent customer under the “Is sub-customer” option. This allows you to track income and expenses related to specific projects or jobs.
- What is the difference between a sales receipt and an invoice, and how do I create each in QuickBooks? A sales receipt is used when a customer pays immediately, while an invoice is used when a customer will pay later. To create a sales receipt, select “Sales Receipt” from the “+” menu. Choose the customer, payment method, products/services sold, and deposit account. To create an invoice, select “Invoice” from the “+” menu, enter customer details, billing address, payment terms, and products/services.
- What are “undeposited funds” in QuickBooks, and how do I use them when recording payments and making deposits? “Undeposited Funds” is an account used to temporarily hold payments received before they are deposited into a bank account. When receiving a payment, deposit it to “Undeposited Funds.” When you make a bank deposit, group all the payments included in that deposit from “Undeposited Funds” into a single transaction, so the deposit matches your bank statement.
- How can I track different aspects of my business using “Tags” in QuickBooks? Tags are a new feature that allows you to categorize transactions with custom labels. You can create tags for different aspects of your business, such as “Fountains,” “Landscaping,” or “Pest Control,” and assign them to invoices, expenses, and other transactions. This helps you to run reports and analyze your business performance based on specific categories.
QuickBooks Live Bookkeeping: Collaborative Accounting Solution
QuickBooks offers a Live Bookkeeping service where you can pay Intuit for a bookkeeper to manage the books. With this service, both you and the bookkeeper have logins to the company file, facilitating collaboration and the ability to have live conversations.
QuickBooks will soon offer a Cash Flow Center to provide insights into your cash accounts, such as checking accounts. The Cash Flow Center will allow you to monitor the flow of cash in and out of your accounts. You can join a wait list to receive updates and information about the Cash Flow Center when it becomes available.
The gear icon is located in the top right-hand corner of the QuickBooks dashboard and provides access to various lists and tools within QuickBooks. It allows customization of the company file.
The gear menu provides access to:
- Tools
- Company options (such as address)
- Profile menu for the Intuit account
- Chart of accounts
To customize the company file, navigate to the gear icon and then to Account and Settings. This area allows you to:
- Add a company logo.
- Edit the company name.
- Input an Employer Identification Number (EIN) or Social Security number.
- Select the tax form used when filing taxes.
- Manage company and customer-facing emails.
- Enter the company phone number and website.
- Manage company addresses.
The gear icon should not be confused with the “new” option that is used to create a new transaction.
QuickBooks can send payment reminders to customers with outstanding invoices. If this feature is desired, it can be set up to prompt at a certain time of day, and can be set up daily or weekly.
To set up customer invoice reminders:
- Go to Edit then Preferences.
- Go to Payments.
- Choose to send reminders to customers that have payments that are due.
- Set the time of day to prompt.
- Choose daily or weekly prompting.
The Chart of Accounts is a listing of different areas where you might spend or receive money and is the backbone of all accounting. It is the most important thing in QuickBooks, and every single thing in QuickBooks will flow through it. Every transaction in QuickBooks runs through one of the accounts in the Chart of Accounts.
Here’s what the Chart of Accounts includes:
- Lists of different areas where you might actually spend money
- Different areas where you might receive money
The Chart of Accounts screen includes:
- The name of the account.
- The type of account.
- The detail type, giving more information about the type chosen.
- The QuickBooks balance.
- The bank balance, if downloading transactions from the bank.
Here are some important points regarding the Chart of Accounts:
- When setting up the Chart of Accounts, name the accounts in a way that makes sense.
- When looking at the list, the names are alphabetical.
- If you want to close them, you have to go to the Advanced section in Account and Settings.
- If you want to turn on general ledger numbers, you have the option to do that.
- You can access the chart of accounts by going through the gear icon.
- You can access the chart of accounts by going to the left and clicking on Accounting.
- Everything in QuickBooks will run through the chart of accounts.
- Make sure information goes into the correct categories so that when reports are run, the information is accurate.
- There is a part two to the chart of accounts.
To customize the company file, navigate to the gear icon and then to Account and Settings.
The Original Text
foreign [Music] says subscribe and click on the Bell icon to receive notifications we’ve made a downloadable transcript of this tutorial available as a free study tool just click the link below in the video details to get this hello welcome to QuickBooks Online my name is Cindy mceugan and I’m going to help walk you through this series of videos I wanted to take a few moments in this introduction video and just give you a little bit of information about what to expect as you go through the course and also let you know a little bit about myself and my background I’ve actually been a software trainer for about 20 years I teach a lot of different types of software QuickBooks being one of those I’m also a QuickBooks consultant I work with both the desktop and the online version I’m going to be able to relay some information about both as we go along but more importantly we’re talking about the online version here the online version has an advantage and that is that you’ll be able to access your company file from anywhere you happen to be that has internet access if you work out in the field for example you might have your laptop with you or need to access it through your phone and these are great reasons to sign up with a subscription for the QuickBooks online service we’re going to actually take this from the very beginning I’m not going to assume you know anything I’m going to actually start off showing you how to go online and pick the correct subscription we’ll talk a little bit about working with QuickBooks online and mobile devices and then we’ll take it from there and start actually setting up our company file we’re going to work with customers that side of things is called accounts receivable you’ll need to know how to create invoices what to do when the customer pays you how to actually put that money in the bank we’re also going to talk about the flip side which is your accounts payable that’s anything that has to do with the bills that come in the mail that you have to pay you’ll want to track those so that you know at any time how much you owe we’re going to be going through and talking a little bit about products and services those are physical things and sometimes they’re a service you provide but sometimes you buy products and you also sell products and we need to know how to set those up properly we’ll be looking quickly at payroll there’s a lot of other things we’ll look at but I want you to have a really good foundation for building your company file from the very beginning when you watch these videos make sure you watch them in order they won’t make very much sense if you get them out of order make sure you watch them all and make sure you watch them till the very end because a lot of times there’s a really good piece of information right at the very end of one of these videos if you have questions as we go along feel free to shoot us an email and we’ll get right back to you and answer your questions with that being said let’s go ahead and get started we’re going to flip over to section two and talk about the different subscriptions that you have available when you decide to go with QuickBooks Online thanks for coming back we are just getting started and the very first thing you’ll need to do before you start using QuickBooks is actually sign up with one of their subscription Services it is not free to use the QuickBooks Online you do have to pay for it monthly and they have four different subscriptions that you can subscribe to I want to go ahead and pull up the website so that you can actually look and compare the different ones with me as we go through this all right what you’ll want to do is make sure you navigate to quickbooks.intuit.com and you’ll see this screen right here which will give you a lot of different information on their subscription services one thing I want to point out is that they do have a try it free for 30 days for each of these that way you can see if you like it before you actually jump in and make a purchase I want to scroll down here because you’ll notice that this is where they have the different subscriptions listed and I want to compare these with you the pricing that you see here may change depending on when you watch this video you’ll notice for each of these that they have a monthly fee and right now you can save 50 off if you sign up for this three months at a time The Simple Start is the really basic one that you’ll want to start with if you’re a brand new business and you don’t have a lot of customers maybe not a lot going on with your business yet it’s great to start with this one and then you can always upgrade as you need more of the features let me go ahead and go through some of these features with you you’ll notice for The Simple Start that you can only have one user and that basically means that only one person can log in with that username and password if you need more you’ll notice that if you look at the essentials you can have up to three users uh the plus has up to five and then you can have up to 25 if you’re actually using the advanced let me scroll down a second because I want to show you that there are a lot of really good things about the Simple Start you’ll see for example that in addition to multiple users you can track your income expenses they’ll all let you do that all of these will help you maximize your tax deductions they’ll all have mileage invoicing and accepting payments they’re all going to have reports as well but you’ll notice that the Simple Start and the one that’s to the right of it only give you the basic reports where if you need some more advanced reporting then you’ll want to go with these two over here which are the plus and the advanced and even with the basic reports you’re going to have a lot of reports QuickBooks is really good about reporting you can do estimates in all of these if you think about a construction company you would want to actually estimate a job before you actually start doing the work and getting paid for it and that’s a really great feature they all have let me see scrolling down here you’ll notice that you can track sales and sales tax in all of these you can capture and organize your receipts meaning you can scan them in you can also manage 1099 contractors in all of these and that’s real important because those are what you call your subcontractors and you need to know how to properly handle those you’re going to be able to actually manage the bills if you go with the essentials the Plus or the advanced so notice that if you have the Simple Start you can’t handle the bills in QuickBooks and to me that’s really important because you want to track everything you owe because you’re going to need to really stick to your budget when you first start your business you cannot track time if you have Simple Start or you can’t do what they call tracking job profitability in The Simple Start even though like I said this is great for a new business starting out you’ll quickly want to upgrade to one of the others moving on to the essentials the essentials just doesn’t have the inventory feature the job tracking profitability you can kind of see the things here it does not have you can’t send batch invoices and really if you don’t do a lot of these it may not be important to you the one that sometimes people want is the inventory feature and you would have to upgrade to the Plus or the advanced to get that you’ll notice that the plus is the most popular one and it does not have the options for importing and sending batch invoices it doesn’t have the business analytics and insights options but you may not need these if you do want all of that you’ll want to go up to the advanced subscription here the other thing I want you to know is that you may go back and forth with these subscriptions because it could be that you add users like we saw earlier and you need to have maybe four people accessing your QuickBooks so there’s a lot of different things you need to think about and you can always call them if you’re really not sure which one would work best for your business I wanted you to be aware of that because the next thing you’ll have to do is actually start with one of these and you can actually choose to go ahead and buy now or like I showed you earlier you can go up to the top of the screen and you can actually try free for 30 days and that’s where I want to stop right now we’re going to go through and talk about setting up your company file after you pick a subscription over module two but before we do that I want to briefly talk to you a little bit about how QuickBooks Online works with mobile devices over in section three I’ll see you there shortly before we go ahead and wrap up module one I wanted to briefly talk to you a little bit about some things QuickBooks does with the online version and how mobile devices actually work with QuickBooks Online the first thing I want you to know is that your online version is constantly evolving you might log in one time and be used to where a particular option happens to be and the next time you log in it may not be there at all or maybe in a different location or look different when they roll out the changes they do not roll them out across the board for everyone at the same time that’s why your friend may have a version and he or she does not see the updates that you see but you’ll eventually get there the other thing I wanted to mention is that you have the ability to use different mobile apps for QuickBooks and they sync with QuickBooks depending on if you have an Android or an iPhone you can just go into your Play Store or go into the App Store in your iPhone and just look for the QuickBooks apps and you’ll notice that if you download one of them you’ll be able to take it out in the field with you and for example if you need to create an invoice out in the field you can do it right there on your phone and it will sync with your actual online version now the apps will not have all of the options that are available but they will have the basic most common ones that you would want to use go ahead also and look in your app store and see if there are other software apps that aren’t made by Intuit but would work well with QuickBooks and it might be something that you might need in your business so there’s all kind of apps that work with QuickBooks I just want to make you aware of that and if you ever wanted to just get a handle on what some of the changes are that they’re making in your version you can actually log into quickbooks.intuit.com forward slash blog and then you’ll be able to see all of the changes and stay on top of what’s new that’s going to wrap up module one let’s go ahead and jump into module two and start talking a little bit about working with the company files that you have to set up in QuickBooks we’re starting to work in module two now and this is where we’re going to talk a little bit about the QuickBooks company files anytime you create a file in QuickBooks it is called a company you can have as many companies as you would like often what you will see is a small business owner might set up one company with his personal information and another company that has the business information Company files do not talk to each other you don’t have to worry about the data getting mixed up and like I said you can have as many as you’d like in QuickBooks you have to either create a brand new one which we’ll do in section three you might already have the desktop version of QuickBooks and you want to upload your file to the online version we’ll look at that in section two but real quick what I want to talk to you about here is the fact that you do have the availability of a sample file that you can go in and play with as much as you want you do not have to sign up with a subscription or anything like that to access the sample file all you have to do is head on over to Qbo Dot intuit.com forward slash r-e-d-r forward slash test drive and the company file you’re going to be working with here is Craig’s design and landscaping services it is a service based business let’s go ahead and head on over there and we’ll check out Craig’s design and landscaping services the first thing you will have to do is just verify your real person I’m going to check the box I’m not a robot and then in this case it asks me to pick all the bicycles I’m going to go through the list and make sure I got them all and I’ll hit verify now it knows a real person and I can access Craig’s design and landscaping services now while this is pulling up let me just mention a couple of other things about the sample file every day they update the date so you’ll see that date change you’re actually going to be working in the year 2021 in the practice exercise so just kind of know that when you go in here and this is what QuickBooks looks like when you first open it up now I do want to go through the screen and get you familiar with everything but I want to do that over in section four before we actually go through this I want to show you how to upload your data if you wanted to bring your desktop file over or in Section 3 talk about creating a new file so we’ll come back to Craig’s design and landscaping services a little bit later right now I want you to head over to section two and let me show you how to upload your QuickBooks desktop files to the online version okay we’ve already looked at some of the sample files that QuickBooks has we now need to talk about how do you actually go through and set up your new QuickBooks online account all we’re going to do is navigate to where we looked at the different online subscriptions over module one and then we’ll go ahead and decide which of those subscriptions we’d like to sign up with or we can sign up with the 30-day free trial let me go ahead and flip over and we will sign up for that 30-day free trial to show you how this works all right as you can see I’ve navigated back to quickbooks.intuit.com I think I’ll take advantage of the free 30-day trial I’m going to use this link right here if you see a pop-up that asks you if you’d like to sign up with the 30-day free trial you can use that option as well what I’m going to have to do here is create an Intuit account and I can do this a couple different ways I can actually sign up with Google and if I have multiple Intuit products then I can go ahead and use that one login for all of them I might also choose to use an email address and sign up that way I think I’ll go ahead and do that and use one that I just set up for this and it’s got my name here also it asks you to plug in your mobile number that’s recommended but you don’t have to and the reason that you may want to go ahead and do that is if you happen to forget your username or your login information and to it can help you recover that information by looking at your telephone number that you’ve plugged in you will want to create a password and make sure it’s something that you’re going to remember but hard enough that someone else can’t actually try to get into your account remember a good password anywhere in your computer will have at least eight to twelve characters you’re going to have a combination of capital letters small letters you might have special characters I’m going to go ahead and choose a sign up with email once I’m done and this is going to create my Intuit account I do get the option to skip the trial and go ahead and purchase my subscription but I think I’ll go ahead and continue with the trial for now what’s going to happen now is it’s going to start setting up what we call our company file each file in QuickBooks is called a company you can have as many companies as you like in QuickBooks you this is going to launch us through What’s called the easy step interview where it’s going to ask us some questions and based on how we answer those questions it will set up all the options in our company file for us first we’ll see some basic information it wants to know what is the name of your business I’m going to call mine a b c services and then the next thing it will ask us is to describe the type of business you do now if you start typing in things like Plumbing electrical things like that then it’s going to start pulling from a drop down list and looking for those first few characters there and if you see something close to what you do on the list just choose it there’s no wrong answer here just choose something close to what you do I’m going to pick for example services and you’ll notice that there are several types of services that it thinks I may want to choose from I’ll just pick Professional Services in this case another thing that you have an option to do is if you’ve been using the desktop version of QuickBooks and you’d like to bring that data into your online version you have the ability to do that you can check this box and then it will take you into your computer so you can find that file we are going to talk over in Section 3 about how to prepare that desktop file so that you can pull it into your QuickBooks Online file I’m going to leave it unchecked for now and click next the next thing you want to know is what would you like to do in QuickBooks and you might want to do a lot of these different things you might want to send and track invoices organize your expenses manage your inventory if you have retail sales you’ll want to choose this if you don’t you may want to leave that alone maybe track your bills track your sales tax pay your employees and track your hours so you can see that you can choose a few of these or all of these I’m going to click next at the bottom and now it says what is your role at the business are you an owner are you the bookkeeper maybe the employee usually the owner of the company is the one that sets up the file or it could have been that the accountant set it up for the owner whichever person set it up is actually going to be the admin or the administrator of the file meaning that you’ll actually own it I’m going to go ahead and choose owner in this case and if I scroll down a little bit you’ll see that it says do you have an accountant or bookkeeper right now and you don’t have to say yes even if you do have one it’s just asking you this because it’s going to set up some of the options as we go down the road for the accountant if you happen to have one I’m going to say right now that I’m just going to do all by myself and I’m going to say all set at the bottom and now what you have is a basic setup for your QuickBooks company file there’s still a lot we have to do because it’s really a blank company file right now but at least we have the file set up so that we can work on it if you wanted to go through a 30-second tour to help you get down to business on QuickBooks you can do that I’m going to go ahead and close that out and then that is what it looks like when you first log in you are on What’s called the dashboard right now and the dashboard is just a quick way to see an overview of how different areas of your company happen to be doing now I do want to take time and go through this whole what we call user interface here I want to do that over in section four so right now let me show you how to log out and then where to go to log back in if you notice in the top right hand corner of your screen you have a gear icon and you can use the sign out option right here and that will go ahead and take you back to the screen now let me navigate away from this and then we will come back and you will see how to log back in so I’m at Google Now and when you’re ready to log in you want to go to QuickBooks dot intuit.com which is where we were earlier when we first created our account and this time you want to go over here where it says sign in notice that you’ll sign up with the particular one that you actually subscribe to if you haven’t subscribed and you’re still using that 30 day free trial just use the QuickBooks online option which is the first one and then that’ll take you back in and you’ll be able to log in right over here and that’s all you need to know right now as far as setting up your company file well let’s go ahead now and talk real quick over in section three about how to actually go ahead and upload your QuickBooks desktop file if you wanted to bring it into your online account if you happen to have been using the QuickBooks desktop version and now you’d like to pull that data into the online version there’s a little process you need to go through and once you go through the process then you’ll want to run some reports to make sure that all your data pulled in let me go ahead and show you how this process works what you want to do is open up your company file in the desktop version and then go to your menu and click on company and down near the bottom you will see export company file to QuickBooks Online if you don’t see that option what it means is that you have some updates that you need to do in this version of QuickBooks before you can export this in order to do those updates just go to help and you’re going to see It’ll say update QuickBooks right here now go through that update process and when you’re finished close the company file then open it back up and when you do you should see the option to export your company file to QuickBooks Online now what’s going to happen here is it’s going to ask you to log into your online account once you click Start Your export here’s where you have to log in so I’ll go ahead and put in my email address again gmail.com and I’ll go ahead and put in my password and I’m going to sign in now what’s going to happen here is if it doesn’t recognize you then it’ll want to send a code to your email to confirm your account if you had plugged in your phone number when you set up your account then it could send you a text that way I’m going to go ahead and tell it to confirm and I’m going to flip over to my email and get that six digit code and I’ll be right back I’ve got my code now I’m going to go ahead and plug it in and then I’m going to hit continue at the bottom it’s going to ask me a couple of quick things before it can actually pull it up to the online version this particular one says do you want to bring over your inventory if you say yes you want to go ahead and select a date that you want to go ahead and pull it in from I’m going to go ahead and say I’ll pull it in from January of 2020 and I’ll go ahead and hit continue the next thing is it wants me to choose my existing QuickBooks Online company file now if I have more than one you’ll see them all listed here and I just choose the one that I want and then I’m going to go ahead and hit continue at the bottom and now it’s preparing my company file which is Larry’s landscaping and Garden Supply here this process could take a while what will happen is you will actually get an email from Intuit once this process is complete once it is complete what we’ll want to do is go ahead and open both the desktop version and the online version and run some reports now this one finished pretty quickly I’m going to go ahead and click on okay and now I should get an email from Intuit remember if you don’t get that email it’s not finished yet it might look like it’s frozen but it’s really not you’ll get it eventually now let me show you the reports that you want to run to compare your data in either version it doesn’t matter which one you do first you’re going to run a profit loss and a balance sheet in the desktop version you’ll go to reports company and Financial profit and loss standard now when the report comes up there’s a couple things that you need to do make sure the dates are all that way you capture everything in your company file also make sure you’re running this on an accrual basis right up here you’re going to want to run that one then you’re going to want to run the balance sheet you’re going to go back to reports company and financial and run a balance sheet standard make sure that you pick all dates you’ll have to scroll up to the top for that and make sure you’re running it on a cruel basis even if in real life use the cash basis for this report run it on accrual so that you can make sure you’ve got everything here now I’m gonna go flip over to the online version and show you where to go in there to pull those same reports back into online version the way you run your reports is if you notice on the left hand side over here you’ll see it says reports and then you’ll notice that both the balance sheet and the profit loss are already set under your favorites you can run either one first doesn’t really matter I’ll just start with the profit and loss and if you get screens like this that says customize go ahead and just close that out for now and what you’ll want to do is make sure that you choose all from the top of the list here and then make sure you hit run report and you can see there’s the data now you’ll do the same thing with that balance sheet you’ll go back to reports over here on the left you’ll run the balance sheet make sure that you’re running this on a cruel basis and also make sure you’re looking at the dates all at the top you’ll want to make sure accrual is chosen right there like I said and then run your report now print those out and compare those two if all the data is the same on both of those then you’ve got everything but if one’s different than the other then it didn’t actually export all your data and pull it up to the online version and you may want to try it again and that’s how you’re going to pull your data from your desktop version into your online version let’s go ahead now and move over into section four and I’m going to give you a quick overview of how the screen looks we call this your user interface okay what I’d like to do in section four is go ahead and give you a quick overview of what the user interface looks like basically the screen when you pull it up what is it you’re seeing and how do all those pieces and parts work let’s flip over to QuickBooks and I’ll give you a quick overview when you first log into your company file you’re going to be on what we call the dashboard right here and basically the dashboard is just a quick overview of how the different areas of your company are doing a couple things you’ll notice you have the ability to add your logo you can just click here search your computer for your logo and Pull It in there are some things over here that it asks if you’d like to start doing you can click there so if you wanted to start invoicing for example you could choose that option you can also go ahead and set up some payments send your first invoice and swipe cards in person with your mobile app if you happen to have that set up now some of these things are not free they are fee based meaning that Intuit will sell these to you so for example if you’d like to be able to accept credit cards then they can set you up with the merchant services account you’ll notice down here are all of your invoice options so think of this as your accounts receivable this would be the amount of invoices that you have outstanding they have not yet been paid over here your expenses those would be the bills that you’ve put in you would be able to see any of those you had not paid yet as well so think of this area as accounts receivable and this as accounts payable here where it says profit and loss that is the most important report in QuickBooks because it will tell you if you’ve made money or if you’ve lost money and then over here you’ll just see all of your bank accounts and if you wanted to click on one you could let’s say for example I wanted to go to my checking account this one here is called checking if I double click and open it up that’ll take me directly to the checkbook register now I’m going to close this message real quick we’re going to spend some time in the register a little bit later but that’s a quick way to get into the register now if I wanted to go back to the dashboard all I have to do is come back over to my navigation pane which is what this is called and click on the dashboard and I’ll be back to where I just was this is called the navigation pane on the left if you went down to banking you would see all of your banking options I’m going to click on banking here and what this is going to show me is how to actually set up my account so that it is connected to the bank and I can pull in my transactions now I’m going to talk about this a little bit later but you don’t always want to do this if you are actually using the invoicing feature in QuickBooks like you should and receiving payments or if you’re using the bill feature and paying the bills correctly then you don’t want to enter information twice so you can set it up but you’re not always going to want to pull in data from the bank now if you had a credit card it would work perfectly now I know that probably doesn’t make sense yet but we will talk about some of that stuff a little bit later on over under expenses here expenses are things that you have to pay out you had to enter some bills you wrote some checks to pay those maybe use the purchase order system you can kind of see all that right down here the next thing is your sales these are the things that you actually sell to your customers you’ll notice that under sales I can look at invoices I can also look at my customer list as an example and I’ll just show you what that looks like real quick this is going to be a list of all of your customers and you can see that they’re set up alphabetical in this case by last name we’re going to spend time on customers a little bit later but that’s how you get to the customer list you also have different projects that you might work on in the desktop version they call these jobs in here they’re called projects you might have a particular customer you’re working with but you might have multiple jobs or projects going for that customer under the workers option this is where you’re going to find your payroll options there’s a ton of reports we’re going to be looking at a little bit later you’ve also got a place where you can go in and look at your sales tax and also payroll taxes if you’re doing payroll through QuickBooks you’ve got an option for mileage where you can go in and plug in which vehicle you drove which job you went to which customer you worked with those types of things accounting now this is going to be the one thing you want to remember how to get to because this is very important this chart of accounts is the backbone of all accounting when you spend money what did you spend the money for if you receive money was it a sale you made from your business you’re going to have to tell QuickBooks where all the money connects to in what we call the chart of accounts we are going to be going through the chart of accounts over in module three notice also this is where you would reconcile if you wanted to reconcile your credit card accounts or your bank accounts you do that right there you’re going to see my accountant which is the next one here if you actually have signed up with Intuit to use one of their QuickBooks bookkeeper accountant people that they have available then this is where you would go to actually find that person and invite them to be a partner with you as they call it there’s also some apps that work with QuickBooks you’ll see that right down here they’ve got a list of some of the more popular ones some of the trending ones or if you wanted to look through some of the different apps down here at the bottom and pick one that you might want to use you can do that down here where it says live bookkeeping this is actually where we were just talking about a few moments ago you could actually go to my accountant and have an accountant partner with you they also have what they call live bookkeeping where you can actually pay into it and you get a bookkeeper that will take care of your books for you and both of you have logins to your company file so you can both get in there and do your work and you can also have conversations so you’ll be able to talk to them live as well and then the last thing here is what we call a cash flow this is something new that will be coming to QuickBooks very soon it’s called the cash flow Center and you can see that it’s going to let you know what all is going on with your cash accounts meaning with your checking account and things like that and you get a screenshot over here if you want you can join the wait list and when the actual cash flow Center is ready to go then they will send you an email just give you some more information about it now one thing to keep in mind I did tell you Way Back in the beginning that if you happen to log in tomorrow and let’s say for example this new button here is not there look for it or look for the options that were underneath it already because they’ve just moved them somewhere else and that’s just something they did recently actually is they used to have those options right over here and then they moved them here recently now just to tell you what the new is anytime you want to create something new like a new invoice or maybe add a bill those types of things you’ll see that in this list and you’ll notice that where it says money in all of these options are your accounts receivable anything having to do with customers wears money out is your accounts payable and then where it says other these are just some other things that you can create new transactions in QuickBooks if you click on one of these particular options the other thing I want you to be aware of is what we call the gear and you’re going to see that right over here in the top right of your screen and we’re going to go through the gear options over in module three I just want to give you a quick overview of how this whole user interface looks and how it works now that you have a quick overview let’s head over into module three and that’s where I want to spend time talking to you about customizing your QuickBooks files we’re starting module 3 now and I want to start off this module by briefly just talking to you about the gear menu there’s going to be a lot of places in QuickBooks where you can customize things to make it work a little bit better for you but let’s go ahead and start there so that you can see what some of the options are and where you would go to make some changes to your company file the gear option is in the top right hand corner of your dashboard right here and you’re going to see that when I click on this it’s going to give you some lists that you can look at it’s going to give you some of the tools that are in QuickBooks you’re going to have access to some of your company options that you might want to go in and change like maybe the address things like that and also it’s got what they call a profile menu for your Intuit account right over here when you’re looking in here you want to get really really really familiar with a couple of these specifically this chart of accounts right here we’re going to spend more time on that later in this particular module specifically in section four we’ll get started with that but everything in QuickBooks will run through the chart of accounts that’s why it’s so important that you know where that is don’t confuse the gear icon with this new Option way over here this is where you’re going to click if you want to create a new transaction maybe you need to create an invoice maybe you need to create a bill maybe you need to do something like track your mileage those are all new transactions you could create just recently they’ve moved this new button over here and renamed it it used to be right up here and everyone got confused between the gear icon and this now they’ve moved it way over here so that you don’t get confused anymore and it says new meaning new transaction that’s really all I want you to know about the gear menu right now what I want to do now is take you over into section two where we’re going to use the gear icon to go ahead and customize some of the options for your company file hey welcome back let’s go ahead and finish up talking about customizing your company file this is actually part two of section two let’s go back down to reminders I’m going to click the pencil icon there’s a couple of options that you want to be familiar with in here you have the ability to set up invoice reminder emails for an example if your customer is late paying an invoice or you just need some reason that you want to remind your customer to pay that invoice then you can go ahead and either use the standard message or you can go ahead and edit the one that you see down here and you’ll see it just basically says this is a reminder we haven’t received your payment yet you do have the ability to insert a placeholder which basically means that anywhere in here you can put in the company name or the invoice number and that would actually be a merged transaction is what they call it it’ll pull from QuickBooks that information you can email yourself a copy and you can go ahead and save this when you’re done you also have options for online delivery down here at the bottom you’ll see these are email options for all of your sales forms your options for this will be when you actually email your sales form over to your customer do you want to have a short summary show up in the email or show the full details in the email you can also attach it as a PDF right here and some additional options you have is if it’s an online invoice you can actually set it up for edge2ml or if you want it to show up in plain text but you probably want to leave it online invoice and then click save and the last one I want to mention at the bottom here are statements and I’ll go ahead and show you those options a statement goes out at the end of the month and basically it starts with the balance from the prior month it shows all of the transactions that month and then what the customer owes at that point it’s really a gentle reminder for your customer to go ahead and pay you statements are not mandatory but they certainly do help when you’re trying to collect money you’ll notice that when you print statements you have an option to list each transaction on a single line or List each one including all the details on that particular one you can also show the Aging table at the bottom of the statement and what that means is it will have a field that says one to Thirty Days another one says 31 to 60 and another says 61 to 90 and that way your customer will know where they fall in that particular aging table I’m going to go ahead and hit save and those are your options that happen to be under the sales let’s look at the options for expenses expenses are things you have to pay bills that come in the mail that you have to pay for example your options are to show item table on expense and purchase forms you can track expenses and items by customer make expenses and items billable and default bill payment terms make expenses and items billable let me just tell you what that means real quick if you have to purchase a product or service and you want to make sure that you invoice your customers so you can get reimbursed for it instead of just manually putting those receipts in the car or keeping them on your desk QuickBooks will remember those expenses and when you’re ready to invoice the customer you can just pull them in you also have the ability to use the purchase order system so if you don’t use purchase orders you might decide to turn this off also you have this option called messages at the bottom this is a default message that will be sent when you send purchase orders I’ll go ahead and open that one so you can see the default message you can also edit this to say anything you’d like and then make sure you save it when you’re done the next tab on the left says payments this would be customers paying you there’s a couple things you can do one is if you want you can sign up with QuickBooks to receive payments quicker by going through this little service QuickBooks has that’s very similar to the way PayPal or Zell might work you just sign up for it if you want to learn more you can click here and that way you can actually email an invoice to a customer for example they can click a button right there and pay you right then and there QuickBooks will automatically be updated once you’re paid from your customer if you already have some sort of existing account with Intuit for example they have something called GoPayment or merchant services you can connect it to your QuickBooks as well right here and this is where you connect and the last option says Advanced there’s several things here I’ll just mention briefly if you want to have the first month of your fiscal year start maybe in September you can actually go ahead and change this it’s going to default to January make it correspond with your real existing start of your fiscal year you might have a different date for the beginning of your income tax year so you can go in and change those your accounting method is set for accrual when you run reports you can run them on accrual basis or cash basis accrual basically means that as soon as you invoice it shows up as income where their customers paid you or not as soon as you enter a bill it will show up as an expense whether you’ve paid it or not if you change this to what they call Cash basis you will only show the income once you receive the money from the customer or you’ll only show the expense once you actually spend that money I want to mention closing the books as well because this is an option that you’ll want to think about in real life accounting what happens is you close the books at the end of the month and you close the books at the end of the year and what that means is if you want to make a change in a closed period you can’t do it you need to make an offsetting entry in the current period your books are not closed automatically in QuickBooks it doesn’t remind you anything so if you want to close them you have to come here you’ll be able to go in and you’ll be able to tell QuickBooks that you do want to close the books and then you can set a closing date let’s say you set it for December 31 of 2019 that means that after you are working in the next year but you see a change you want to make in 2019 prior to December 31 you’re not going to be able to change it I’m going to go ahead and cancel out at that we talked a little bit about tax forms earlier you want to make sure you keep that one also the chart of accounts I know you haven’t seen it yet but basically everything in QuickBooks will run through this chart of accounts and currently they do not have general ledger numbers they’re just a list alphabetical per each type if you want to turn on general ledger numbers you can turn them on right here also you have some options for the markup income account and we’ll address that a little bit later let me mention real quick the track classes and the track locations locations means if you have different physical locations for your business you can turn this option on and every transaction that you work in you can choose which location you want that to go to classes is very similar except it’s not really locations think about this let’s say that you happen to have two different divisions of your company you might use those for your class list and everything you do make sure you pick the correct option from the list there’s some things about forms where you can have it pre-filled automatically automatically apply payments things like that you might want to look through that at some point a project would be like a job related activity you’ll notice that you have the ability to organize all of those job related activities in one place and that is turned on you’re also viewing QuickBooks in the business view there is an option to go ahead and also see this in what they call the accountant View time tracking if you want to be able to track the time that you or your employees spend working on different projects or jobs you have the ability to do that you can also come down and change the currency there’s some date options and things like that all the way down here that means there’s a lot of options in here that you can go through and set you’re going to want to look through these you don’t have to get them all right away but at some point if you want to set these you just come back in and make all these changes I’m going to go ahead and close that with the X at the top right and that’s going to take me back to the dashboard let’s go ahead and now move over to section three and I’ll show you how to manage users in section one we got familiar with the gear menu there were lots of different options in there that you can use to customize how your company file works and I want to take you into the gear menu now and into some of those options and show you how to customize some of those different things so that your company file works best for you let me go ahead and flip over to QuickBooks and we will Dive Right In I’m going to click on the gear icon and I want to start over in the First Column underneath where it says your company you’ll see an option that says account and settings these are going to be like preferences or options that you can turn on or off or edit in QuickBooks as we go down the tabs on the left and we’ll start with company if you want to change anything in these different sections just go over to the right and click on the little pencil icon and that will take you into the edit option you’ll notice here that I can add my company logo just by clicking the plus sign and that will let me navigate through my computer to find my logo I could edit the name of the company if I like also you might want to put in your EIN number or your social security number you’re going to use your social if you’re a sole proprietor and you really don’t have payroll if you do have payroll you’re going to have to have your EIN number in here so that QuickBooks can use it to help you with your payroll I’m going to hit save and that’s going to save that little section the next little section says company type and you’ll notice the first thing is the tax form and then the industry I’m going to click over on the pencil icon here and I want you to notice that you have the ability to add whatever type of tax form that you actually file when you do your taxes at the end of the year you can add that here now let me just make a little Point here you do not have to pick anything here as a matter of fact if you do not file your own taxes if you have an accountant then I would pick other or none every single time your accountant will know what type of tax form that you file if you pick any of these options what will happen is when you’re working in different places in QuickBooks there will be an extra field that says Which tax line on the tax form would you like to put this on you’re not going to have a clue if you’re not an accountant and you’ll just get stuck there every single time so why see that field and get yourself stuck I’m just gonna pick not sure other or none and the other thing is you have an industry you chose when you first set up your company file I chose Professional Services you can change that if you want but I’m going to leave that and hit save the next little section you’ll see here has to do with your company email you’re going to have your customer facing email the difference is that the company email is the private email that you like different things sent to from Intuit for example the customer facing email is the one you want the customer to see and that can actually be redirected to your company email if you don’t want to have to open 15 different email accounts you can always have as many email accounts as you want and redirect them to the one you’d like to funnel everything into there’s a place to put in your company phone and your company website here again you would edit that over on the right and the company address down at the bottom same thing you can have a company address that’s seen on the back end and then one that’s called customer facing meaning that’s the one that the customer actually sees let me go down on the left here to billing and subscription this is where you’re going to be able to go in and upgrade your existing subscription if you’d like you’ll notice that you can subscribe right from here and you can see all of the options and we’ve talked a little bit about these before so I’m not going to spend much time on that the next one on the left is usage there are some limits to some of these different subscriptions for example when you’re using the QuickBooks Online plus and you need more room you’ll want to go ahead and upgrade your subscription for example the one that I’m using only allows me one user if I want to add a user I may need to upgrade my subscription there is a number of items you can put in the chart of accounts as an example it’s 250. just a little FYI the desktop version allows you to have 14 500. if I need 251 then I need to upgrade my subscription and then down here where it says classes and locations you can have up to 40 and if you need more then that’s another reason you would want to upgrade your subscription I’m going to go over to sales on the left and there’s several things in here that you may want to go ahead and work with now later on we’ll look at customizing the look and feel of your different forms for example if you have an invoice and you want to add your logo or something like that but these are some things you can turn on or off right here in your forms for example let’s say that you like to invoice your customers and you want the customers to automatically have terms of Net10 for example well currently they’re net 30. let me go ahead and click on the pencil icon and show you some of these here’s where I could change this to one of these other preferred invoice terms if you’re not familiar with the ones that say one percent Net10 like these three and there’s two percent knit ten and eight basically what that means is the customer invoice will be due in 30 days but if they paid in 10 days they can take one percent off it’s a way to get your customers to pay you early if you have a preferred delivery method you can choose it right here do you like to print things now or would you like to send things later I’m referring to an invoice as an example here where it says shipping if you don’t ship anything then you can go ahead and uncheck this and this will say off if you do ship things then you had some options down here where you can have sales reps and put in purchase order numbers things like that these are custom fields you can also turn those off if you don’t need them if you want PO number not sales rep for example just uncheck the sales rep option you can have custom transaction numbers and that basically means that if you want to put in your own transaction numbers you can go ahead and set that series up you can have a service date field you can also have fields for the discounts deposits or tips or gratuity if you use that you can just go in and turn these on or off I’m going to hit save right there the next thing you’re going to see is products and services right over here and you’ll see there are several different options related to that that you can turn on or off for example if you don’t track inventory you can actually turn off this inventory option right here I’m going to go ahead and cancel that there’s also some options for late fees there’s also some for Progress invoicing and let me just mention what that is just so you’ll know if you estimate jobs construction is a prime example you’re going to want to take that estimate and turn it into an invoice at some point so that your customer can pay you you do not have to pull everything from the estimate into an invoice you can pull in 30 percent for example or maybe you want to pull in certain items that were on that estimate into an invoice if you do estimates you will want progress invoicing there’s a couple more options here let me scroll down there is an option for messages when you actually email a form so let’s say it’s an invoice for example or what they call a sales form you have the ability to email it directly to your customer you can set the default message and I’ll go ahead and click on that one so we can see you can say dear or you can say two notice you can have a merge field if you want to have their full name their last name first name and you can use the standard message that you see right here below when you’re actually sending out that email you can also have a copy email to yourself every time if you’d like I’m going to go ahead and hit save down at the bottom a couple more things I want to point out you’ll notice there is an option for reminders and I want to briefly tell you how reminders work but before we do that I think we’ll go ahead and stop the video right here let’s go over into the next section and I’m going to talk to you a little bit more about some of these other options here for account and settings one of the things that you will want to do is make sure that each person that is using QuickBooks has their own login you’ll give each person their own username and their own password only the administrator can add edit or delete users you can have up to five users in your QuickBooks file if you need additional ones you can think about upgrading your subscription or purchasing those additional ones that you might need the reason you want to have these additional users set up is because if you want to track down errors then you’ll want to know who was logged in at the time that that particular transaction was changed you can run an audit Trail to see a report on which user was logged in with the transaction used to look like and what it looks like now you also will be able to limit the user’s access to certain areas of QuickBooks let’s go ahead and flip over and I will show you how to manage the users keep in mind that the administrator has to be logged in in order to work with the users I’m going to go up to my gear icon in the top right hand side of the screen and in the First Column you’ll see an option that says manage users the first thing I want to point out is that normally if you’re using one of the basic subscriptions then you only have five what they call billable users in your plan and like I mentioned earlier you do have to upgrade if you want to have additional users the admin is considered one of the five users and you can see here is the admin name if you wanted to edit the admin information you can choose the edit over on the right and then come over here to edit user settings typically when you first set up QuickBooks you’re going to see the email address that you signed up with right here under the first name field and there won’t be anything where it says last name you could come up here and change those like I did I’m going to go ahead and hit save at the bottom if you want to add a user just come over to the right here and click on add user your user that you’re setting up can have what they call Standard rights which means that you can choose to give them full rights but you can also choose to limit their access to certain areas or you can give them company admin rights which means they have access to everything these options up here count towards your five user limit we discussed these here don’t because you might have someone you want to be able to log in just to run reports or maybe just to do time tracking I’m going to go ahead and choose standard user at the top and click next in the bottom right hand corner of the screen the first thing it asks me is how much access do I want to give this user now if you say all notice it will include payroll and it will check that and you can see all the different things they have access to over here if I go ahead and uncheck that you’ll notice that the things they don’t have access to do or down at the bottom they can’t add or edit employees in this case or delete payroll transactions it could be that I say none I don’t want them to have rights to any of these accounting features but they can still manage other things in QuickBooks like submitting their own timesheets things like that I can also give them limited access meaning if I want them to be able to do things with customers you can see the choices here or if I want them to do things with vendors or both you can see I can check both and you’ll see all the options here as well I’m going to go ahead and click next and now it asks me do you want this user to add edit and remove users we’re going to say no and I wouldn’t change that because you want the administrator to have rights to everyone if you start giving everyone full rights to change users and that sort of thing then what’s the point in even setting those up notice that you can also give this person permission to edit the company info or if you want them to manage the subscriptions you have the ability to do that as well I’m going to go ahead and click next at the bottom then it says we’ll invite them to create a QuickBooks account and password for each to access the company file what you’re basically going to do here is the new user you’d like to set up you’re going to put in their first and last name here put in their email and they will actually get an email saying that the administrator would like them to become a user they would accept and then they can set up the username and password make sure that the administrator knows that information you wouldn’t want to have an employee that has their own username and login information and the administrator doesn’t know what it is and can’t have access to what they do that’s going to be very important for you I’m going to go ahead and just X out of this because at this point what would happen is once they accept it then you would see their name down here as a user and that’s really how the users will work I do want to show you the audit trail report but we’ll do that when we get over to reports a little bit later let’s go ahead and wrap up this section and let’s talk over in section 4 about the chart of accounts we’re getting ready now here in section four to talk about the chart of accounts the chart of accounts is probably the most important thing in QuickBooks every single thing in QuickBooks will flow through the chart of accounts somewhere the chart of accounts is basically a listing of different areas where you might actually spend money or you might receive money as well and you want to make sure that your information goes into the correct categories that way when you run reports you have accurate information there is a part two to the chart of accounts make sure you watch both parts so that you have a really good understanding of how the chart of accounts Works let’s go ahead and flip over to QuickBooks and we’ll get started there are a few different ways to get to the chart of accounts one way is to go through the gear icon and in the First Column you will see the chart of accounts another way is just go over to the left and click on accounting and there you will see the chart of accounts as well and this is what your chart of accounts looks like remember that every single thing in QuickBooks runs through one of these that’s why it’s so important that this is set up correctly but let me quickly give you a quick overview of how the screen looks you’ll notice the First Column is the name of your account when you’re setting these up you can pretty much name these accounts anything you’d like but make sure that you name them something that makes sense to you or whoever happens to be looking at your reports the second column is the type and notice that it’s currently sorted by type we’re going to be going through all the different types so that you will know which ones you need to set up to make sure that you have everything you need I want you to notice also that when you’re looking down this list and you see the type for example income notice that the names are alphabetical and that will be true of each of these types if you look at the expenses here then these are alphabetical if you want to turn on general ledger numbers you have the option to do that and let me show you what it will look like if you do you’ll actually go up to your gear icon then you’re going to go into account and settings then you’ll want to choose Advanced on the left hand side and under Advanced you’re going to see an option that says enable account numbers right here currently they’re off if I choose on just by clicking there and choose enable account numbers notice that turned it on and I can show account numbers and then save and I’ll show you what this looks like now let me go ahead and close this and you’re going to see now that you’ll have a new column at the beginning here where you can actually go through and put in your own account numbers there will not be in here automatically you have to add them the way you would add them is the way you would edit any of these accounts just come over to that line that the account you want to edit is on you’ll see a down arrow and you’ll choose edit and in this window you have the opportunity to add your new account number right here I’m going to go through this screen in a minute so I’ll just close that for now and I’m going to go back and turn those account numbers off for just a moment account and settings it’s going to be the advanced option on the left and I’m going to go ahead and turn off enable account numbers just by clicking that word on and I’ll uncheck these and save that now let’s go back and finish going down our list here the next column that you’re going to see next to the type is going to be the detail type and that’s just telling you a little bit more information about the type that you chose there’s also the QuickBooks balance and the bank balance the QuickBooks balance would be if you had entered some transactions in QuickBooks what is that balance for that account the bank balance column will allow you if you pull in your entries from the bank that’s called downloading your transactions then you’ll see what that balance is as well and you can see that you can match those up and see if you’re in sync here and we’ll be getting into that a little bit later but right now what I want to do is start talking to you about the different types of accounts you’d want to add and then we’ll add a few so you can get a feel over how this works the first type that I want to talk about are bank accounts you’ll notice there are no bank accounts at the top of this list that means that right now you do not have a checking account you don’t have a savings account any kind of bank account you have the ability to add these you’re going to be doing this by clicking over here where it says new and the
first thing you’re going to do is pick the account type in this case it will be bank but notice all the other types we’re going to be talking about where it says detail type right here just go ahead and pick the option from the list that closely matches the account type you’ve chosen over here is the name of the account when you name your account you can name it anything you want if you want to call it your bank name you could do that if you want to call it operating account and maybe another one called payroll account you can do that just whatever you like to name it I’m going to go ahead and leave it on checking for now description is totally optional and there’s not a sub account right now but later on I’ll talk to you about how sub accounts work the other thing you want to think about is a start date to start tracking the money in this checking account now what you want to do is if it’s the beginning of the year like it is currently then you probably want to go back to January 1 or the beginning of your fiscal year and put in all the entries if that’s the case then you can choose beginning of this year you might decide if it’s later in the year and you’re starting your QuickBooks file to go ahead and start with the beginning of that current month you can also pick other the reason you might want to pick other is what if you have a bank statement that cuts off in the middle of the month that would be an option where you can tell it a specific date to start with it really doesn’t matter what date you start with just try to make it correspond to the start date of your bank statement I’m going to go ahead and say beginning of this year and I’m going to go ahead and put in the balance the ending balance on 12 31 of 2019 would be the exact same number as the beginning balance of 1 1 2020. you’ll want to get that number from your bank statement I’m going to go ahead and say it was 250.62 and I’ll go ahead and hit save and close at the bottom and now you’ll see at the top you have a checking account and you have a balance of 250 and 62 cents you also have the ability to view the register I just want to show you that real quick if I come over here to view register then this is what the checkbook register actually looks like I’m going to close this this is just some information on what a register looks like and what it’s supposed to do anytime you want to go back to the chart of accounts you’ll notice right up here it says back to chart of accounts and that’s going to take me back to the screen now I also want you to notice something that happened anytime in accounting you do something like this then you will have a debit and a credit for that transaction you’ll notice that in this case the flip side the money went to an account called opening balance equity and that’s the way it should be you can’t change that just know that whenever you have a starting balance which could be a minus number if you have a loan but this is going to be an actual picture what your books look like so don’t freak out if you see a negative number there it’s an accurate picture of your books let’s go ahead and talk about some other bank accounts you obviously would have savings money market accounts things like that but think about do you have PayPal do you accept Square those are bank accounts as well so if you do accept those then you want to set this up as bank accounts what would eventually happen is you would transfer money from PayPal or square into your checking account or sometimes you go the other way but those are just Bank transfers the next type I want to talk to you about are your assets and you’ll see there are a couple of these here an asset is something that your business owns that makes it more valuable you’re going to have equipment you’re going to have chairs desk lamps Vehicles property assets fall into one of two types there are fixed assets which are things you plan to keep long term like the vehicle or the property then there are what we call more liquid assets or QuickBooks calls them other current inventory is a great example of that because I’m worth more right now because I have inventory in the back room but my goal is to sell it and get it out the door now what’s going to happen with assets is you’re going to set up big bucket categories and what I mean by that is instead of listing each vehicle the business owns you’re going to have a category called vehicles and they’ll all dump into that one category you don’t want to have a hundred different categories for your assets because no one wants to sit there and look at that just have big buckets maybe seven to ten good ones some of the common ones that I see are Vehicles you might have one called furniture and fixtures you might have one called property if you have a lot of property you might have equipment but again they’re just big buckets this is where the accountant’s going to be very helpful to you because the account is going to help you decide which categories to set up and also when you start talking about the money part then the account that’s going to help you plug in how much the vehicles were worth and depreciation and things like that QuickBooks does not do depreciation and that’s because there are multiple ways to do it if you had 10 accountants they might all tell you a different way they want it done so just know you want to have the account set up so that if you go to the bank to get a loan for example the bank will know that you do have some assets we’re going to move down the list but before we do I want to go ahead and stop the video here and have you go over into part two and we will continue talking about the different types that you’ll need to set up we’re in section four and we’ve just talked a little bit about how to start setting up some of the accounts in your chart of accounts I want to go ahead and finish telling you how to set up the rest of those accounts so let’s flip over to QuickBooks and we’ll keep going the next type that I want to talk to you about are what we call your liabilities a liability is something you owe now I’m not talking about the monthly payments you have to pay for the electric bill things like that what I’m talking about is a loan you’ve taken out of the bank when you think about your liabilities there are really two types there are what we call long term which are things that you’re going to pay on for more than 12 or 13 months and then there are short term which is under a year basically and QuickBooks calls them other current liabilities when you set up your liabilities you want to set up a separate one for each loan that you have and when I say loan it could be a car loan it could be you as the owner decide to set up a loan where you put money into the business and you want to get paid back you might have borrowed from the bank those are all different liabilities you want to set up and each one should be set up separately let’s set up a car payment so you can get an idea of how you would set up these accounts I’m going to click on new and the first thing it asks me is to pick the account type here you’re going to see your other current which is the short term and your long-term liabilities which is what I’m going to choose in this case another thing to notice is that where it says detail type if you see notes payable that’s just an accounting term for a loan basically over where the name goes this is where you’re going to pick the name that you want for your loan I’m going to call mine the bank of any City but you can call this anything you want sometimes what I’ll see people do is put the last couple digits of their account number here just so that they can see which loan they’re looking at when they have it pulled up in front of them description is totally optional this is where you might say that this is my 2019 Jeep Cherokee loan or you can leave it blank and then we’re going to have to pick a start date now remember if we’re starting our company the beginning of the year what you’ll want to do is for your beginning balance here find out what the amount you owed as of in this case January 1 was so that you can plug that in it’s not the amount you started with when you purchased the vehicle two years ago it’s the amount you owed as of the start date of your company file I’m going to put fifteen thousand dollars in here and then hit save and close at the bottom and now what you’re going to see is that you have a loan right here notice it says Bank of any City and the balance is fifteen thousand dollars every time you make a payment on the loan this is the account you want to put it to your car payment is not an expense to the business do not set it up as an expense account it is a loan and you want to know when you’ve paid off the loan you’ll also be able to on each individual check that you write you’re going to be able to put in how much is principal and how much is interest there the other thing I want you to notice here is look at your opening balance Equity it’s a negative number and that’s because I said that when you owe something it’s a negative number and this is an accurate picture of what your books look like let’s talk about credit cards a little bit and I’m talking about credit cards that your business uses to purchase items for the business this has nothing to do with accepting customer credit cards you want to set each credit card account up separately so that you can track each one I’m going to go ahead and set up a new one for you the type is going to be credit card I’m going to name my card I’ll just call it visa and I’m going to pick the start date of my company file the beginning of this year and the starting balance would be the starting balance from my January bank statement if you don’t have your January bank statement then you can grab your December of 2019 and plug that number in I’m going to say it was twenty five hundred dollars and I’ll save and close and now what you should see is that you have a credit card and you owe 2500 when you make a payment towards the credit card you’re going to actually put it to this account always do not try to break it up that so much is gas and so much was meals because there is another way to do that in QuickBooks all the payments go directly to the credit card account going down the list the next type that I want to mention is where you see Equity Equity basically means equal if you think about it you’re the owner of the company when you take money out that’s considered an owner draw when you put money in it’s considered an owner contribution now they’ve got some other terminology you’ll notice owner investment is when the owner puts money into the business and owner pay and personal expenses is when the owner takes money out of the business what I don’t want you to do is make a deposit from your personal account and consider it income it is not income to the business it’s considered equity the next type that I want to talk to you about are your income accounts I’m going to scroll down just a little bit here you’re going to see that there is one called sales income and typically when you make a sale for your business this is the account that you want your sales to dump into you can have a few extra ones added if you’d like maybe you have different areas that you do business in and what I mean by that is in your company maybe you have different things that you do and you’ll want to actually set those up so you can see how much income you’re getting from each one that’s certainly okay keep that list pretty short though no one wants to Read 50 different lines of income accounts but sales is normally where you’ll see most of that go into the next thing I want to mention is your cost of goods sold think about the things that you have to buy to make a product or service in your business you have to buy materials you’re going to need subcontractors sometimes maybe you have Freight that’s part of that anything that you have to buy to make a product or service in your business is considered a cost of goods sold and you want it to show up on a profit loss as being deducted from your total income the largest grouping that you’re going to see are your expense accounts and you’ll see there are a ton of these here you’ll also add a lot of these let me show you how to add some sub-accounts so you’ll see how this works let’s use car and truck as an example we have the main account here but I want to add a sub account called gas and maybe another one called repairs and maintenance all you’re going to do is go back up to the new option in the top right of your screen here you are going to create a new account and it has to be the same type as the main account so that means this one has to be an expense account and in this case it is Auto and I want to name this one fuel what I’m going to do is check it’s a sub account of and then from this list here what I’m going to end up picking is car and truck so see how the fuel is a sub account of car and truck and when I click save and close at the bottom I want to show you how sub-accounts look see how fuel looks like it’s indented a little bit that’s a sub account and there’s going to be a lot of these you’ll want to add when you’re going down this list think about insurance you might have general liability you might have auto insurance those would be sub-accounts of insurance going down under legal and professional fees often what I’ll see is accounting and the attorney will be sub accounts of legal and professional fees and you can just come down and make this list look any way you want there’s utilities at the bottom you’ll want to have telephone underneath gas electric any of the utilities that the business pays that’s going to give you a quick overview of setting up your chart of accounts make sure you spend some time on this and get it set up the way you want it you want it to be as detailed as you need it to be to get your numbers but don’t make it so detailed that no one wants to read it you can always set up accounts later as you go along as well because you’re not going to catch them all right away well that’s going to wrap up the chart of accounts let’s go ahead now and move over into module 4 and we’re going to talk a little bit about working with accounts receivable and we’ll start with learning how to set up customers foreign we are getting ready to start talking a little bit about the accounts receivable portion of QuickBooks if you’re not familiar with that term anything happen to do with customers in your business that’s called accounts receivable customers are people or businesses that buy from you you’re typically going to make a sale and that’s going to be income to your business we need to talk first of all about how the customer list is set up and then once we do that we’ll go into the second section and I’ll show you how to add some customers to this list the way you’re going to get to a list of your customers is to go over to your navigation bar on the left point to sales and then you’ll see customers in the list at the very top of your customer list here you can see the dollar amount for any of these categories you can see that for open invoices I have 35 810 these are invoices that have been created and the customer has not paid them even if they owe a penny if you had any of this amount that was overdue you would see that over here and overdue means that if you had set specific terms on an invoice let’s say net 30 meaning that invoice was due in 30 days and the customer has not paid you by then then some of this moves over into the overdue category you can also see how much was paid in the last 30 days in this case nothing there’s also a dollar amount for what we call unbilled activity and for estimates sometimes you will get little messages like you see here right above your actual customer list you can close this with the little X in the right hand corner and then you can actually see the list the customer list is set up alphabetical by last name you’ll notice that when you look down this list the list is set up by last name comma first name you’ll want to do that because it’s a lot easier to find someone when you’re looking for them if it’s set up that way obviously a business like Adam’s candy shop would not have a last name and a first name so it just sorts the first letter which is a in this case with the A’s in the list if you see a little envelope to the right of some of your customers that means that if you click there you can actually send that customer an email if their email address was set up when you actually set up the customer then it would pull it like you see here if not you’re going to notice that there’s no envelope meaning that you have not put in a customer email address in the customer information these are what we call sub customers sometimes they’re called jobs sometimes they’re called projects and the online version the technical term is a sub customer they’re both sub customers of in this case Mike ballick you can also see the customer’s phone number and the open balance meaning how much money that customer owes you there’s also a column for actions if you happen to be on this screen and you’d like to take one of these actions related to this customer you could do that for example you could go ahead and create a statement or an invoice right from here just know that you’re not always going to be on this screen when you want to do those things so there are other ways to do those actions notice you can also search for a customer right up here so if you want to look for Mike ballick for example you can start typing the last few characters of their name and then you’ll see that it pops up in the list over on the right hand side you have the ability to print a list of your customers you can also export this list to excel if you’d like and there’s also some settings and I want to click on those for a moment because I want to show you that these are going to be the columns that you see up here if I’d like to see their email address I just choose that and notice now I have a column for email or if I’d like to see their address I can click on that and now I see their address as well it’s just how do you want to actually look at this list another thing I’ll mention way back over on the left where it says batch actions if you have multiple customers selected from the drop down list you can actually email all three of these customers or you can make them inactive an inactive customer is a customer you’ve used in the past therefore you can’t to delete them but if you haven’t seen them in a long time and you just want to hide them from the list you can make them inactive that’s a quick overview of the screen itself here what I’d like to do now is take you over into the second section and show you how to add a customer to the customer list now that you’ve gotten a quick overview of what the customer list looks like and how it works we need to start adding some customers to this list let’s go ahead and flip over to QuickBooks and I will show you how to add your first customer if you’re in your customer list you’ll notice in the top right hand corner there’s an option to add a new customer there’s also a down arrow to the right of that because you can also choose to import customers what if you have a list of customers already set up in Excel you can just import those so that you don’t have to set them up one at a time we are going to talk about importing customers from Excel over in Section 5 of this module for now I’m going to click on new customer we’re going to put in some customer information on this screen and you’ll notice the first thing it asks for is the company name remember that a customer can be a company a customer can also be an individual that works for a company or it could just be an individual and there’s no company in that case you wouldn’t put anything in the company name field but I’m going to go ahead and put in this customer’s company it’s BRC supplies and you’ll notice that because I’ve typed a b it starts pulling down a list of different companies that it’s found and their addresses so if I want to just choose one of these I could but since I’m typing this in from scratch I’m going to go ahead and just click over to the side somewhere and then I can come back over and finish filling this out this customer’s name is Tom Allen and notice it now has a display name as Tom Allen you can change that display name to show as the company name or last name comma first name display name means the way you see it in the list over here remember we talked about the easiest way to find customers is to type it in last name comma first name just be consistent with however you decide to do it it’s also going to use the display name as the same way it’s going to put their name on checks it looks kind of funny if I write a check to Alan comma Tom I’m going to uncheck the box and then I’m going to put in Tom Allen and that way that’s how his checks will appear when we put his name in there over on the right you see I can type in an email I’ll just say Tom Yahoo you can also put in Tom’s phone number Tom’s mobile fax other end website also if this is a sub customer I can check the box and choose the customer that he is a sub customer of we’re actually going to do that over in section four now notice I’m on the address Tab and this is where I’m going to put in the billing address I’m going to go ahead and say he’s at one two three and we’re going to say this is Billings Road this is going to be in the city of Bayshore California States California and the zip code is 94326 the country we’ll just say USA now you’ll notice that the shipping address is the exact same as the billing address if you don’t ship anything you don’t have to worry about that but if you do they may want their invoices going to one address and the actual things you’re shipping going to a different address you can uncheck the box and change that information if you need to I’m going to go ahead and hit save and let’s see if Tom Allen is in the list he should be in here’s Alan comma Tom and he is you can see it right over here now I want to mention a couple of things when you’re in this list if you have a customer that you accidentally put in you cannot delete that customer the online version of QuickBooks lets you make a customer inactive meaning you hide them from the list but you cannot delete them now what you’re going to see is all the information you had set up about Tom Allen notice a couple of things you can add some notes if you want to this customer’s record I’ll just click add notes just to show you let’s just say that we can put in here this is a new customer for the year 2020. and that’s a note that’s all you have to do there and now that will show up anytime you want to see that notice also there is a tab for the transaction list down here and obviously we have no transactions yet but as we start creating invoices receiving payments that sort of thing they’ll show up right down here the projects these are going to be the jobs that we actually do for these customers there aren’t any set up yet here we can also see customer details this is where we’ve got all of the information we had just set up for this customer and then also if there were any late fees you would see that listed here as well and that’s how you set up a new customer I’m going to hit this customers link here in the top left and that’ll take me back to the list of customers and notice Tom Allen has an envelope to the right because we did put in an email address for Tom Allen that’s pretty much how you put in a new customer what I want to do now is take you over into section three and I’m going to show you how to add a sub customer now that you know how to add a customer let’s talk about how to add sub customers a sub customer is basically going to be a way of adding a level underneath your main customer if you have different jobs that you work on for a particular customer you can actually separate those jobs by actually creating sub customers then you can look at reports for the entire customer but also per sub customer in the desktop version of QuickBooks they actually call these jobs sometimes they’re called projects here like I said the terminology is a sub customer let me show you how to set those up to create a sub customer we’re still going to use the new customer button because it is a new customer we’re setting up they’re just a sub of another one we already have existing when this comes up all you want to do is put in the display name you can see in their case they’re using street addresses I’m going to make up one 124 and this will be Scottsdale Drive and the only other thing you want to do is come over here where it says is sub customer and underneath it pick the customer that you want to apply this to you can also see it says bill with parent over on the right and you do want to keep this together you can also build this customer individually we’re going to leave it on build with parent and you’ll see that it actually pre-populated all of this information from Tom Allen’s setup we don’t need to change any of this unless it happens to be different we’re just going to hit save and then that’s going to be our next level we’ve created you can see it right over here and that’s all there is to creating a sub customer now a couple things you need to know if you’re using the sub customer feature you want to use it consistently throughout QuickBooks if you don’t let’s say that you’re working on some transaction and instead of picking 124 Scottsdale I picked Tom Allen it’s still going to go to the right main customer but on reports you’ll see other and you’ll go what’s going on you want to make sure that you put it to the correct sub customer if you’re using the sub customers option not every business will use the sub customer option but it’s really great if you need to break out different projects like I said or maybe you have different locations for a particular customer things like that that’s really all there is to working with sub customers let’s go ahead now and move over into section four and I will show you how to edit an existing customer once you have a few customers set up you’re going to realize that you need to edit some of the information maybe you actually set up the information wrong or it could be that the customer information has changed maybe they’ve moved they have a new address you want to add a website you can always go in and edit the information about your customers and it’s a pretty easy process so let me show you how that works if you want to edit a customer’s information make sure you click on your customer over on the customer list and then come over here and choose this edit option let’s say that Tom’s email really includes his last name I’m going to go ahead and add Alan and let’s say that when we set this up we did not look at any of these tabs so let’s go through those real quick so that you’ll know what other types of information you might want to set up when you’re setting up your customers we’ve looked at the address tab now let’s take a peek at notes this is where you can add any notes you would like pertaining to this customer the best thing to do is just drop down after the previous node pop in the date and then pop in any notes that you might have pertaining to this particular customer the third tab over says tax info this has to do with collecting sales tax from your customer if you sell physical items and you charge sales tax you need to tell QuickBooks that this customer is taxable and what the default tax code is we’re going to talk about sales tax later on but just to give you a heads up what you’re going to have to do is where you’re setting up the items or the different things you sell they actually call them products and services in here then what’s going to happen is you’re going to set up each sales tax you need to collect and then you’ll group them together to create one big tax so that you’re charging the customer correctly and that’s where you would put that tax code let’s say that it happens to be the San Domingo we’ll choose that and now what will happen is when we invoice a customer it’ll pull that tax code automatically the next one is payment and billing a lot of this is just information for you first of all the preferred payment method does this customer usually like to pay you with cash check barter MasterCard you can kind of see the list there if you need to add a new way that the customer can pay maybe PayPal Square you can just hit add new right here and then you can actually type in the name of that new payment method and then hit save and now PayPal will be on the list since I just added it it does not mean that the customer pays you with PayPal every time it just means that’s their preferred way they typically like to pay you preferred delivery method how do they like to have their invoice sent to them do they like to have them printed and you can print them later or do they like to have them sent via email where you can send those later or do they not have a preference terms you can have different due date terms per customer if you have a really good customer you might have net 30. if you have a customer that’s brand new you might say do a pen receipt now let me tell you why you have this opening balance field here as of the start date of your company file how much money did this customer owe you let’s just say it was a thousand dollars you could plug that in there and the accounting would be correct but you would not have a way to go back and see that that was actually three separate invoices you sent them that total eight thousand dollars I’d like to go back and put each invoice in that the customer still owed me for and not fill this in But whichever way works for you would be fine as long as the numbers come out correctly and then of course if you did put an opening balance you would put in the date that that would be as of which would really be the start date of your company file the next tab over says language this will default to English but if you’d like to send your invoices to the customer in French Spanish Italian you can see the list there you can also have attachments for this customer what this would be is let’s say that you had some sort of file that you actually created or it could be a bill that you received something related to this customer instead of having to get out of QuickBooks and search your computer for that file you’ll be able to open it right here from QuickBooks because it will be attached if I click on attachments here it will allow me to search my computer and find that file and attach it here the last tab says additional info you might have different ways you like to categorize your customers you’ll notice they have commercial customers and residential customers but you can set up this list any way you like it and that’s going to be how those tabs work right there all you have to do when you’ve changed all the information is hit save and that information is now saved in QuickBooks now one quick thing I want to mention to you especially about sales tax if you have a customer you have set up where you charge a certain tax and later you go back and edit the information and change it it’s not going to go back to any prior invoices and change that sales tax it’s only for any new ones you create from this point forward well that’s how you’re going to edit your customers let’s go ahead now and move over into section five and I’ll talk to you a little bit about making customers inactive one of the things you can do in QuickBooks is with any list you’re working in whether it be customers chart of accounts vendors it doesn’t matter if you have an item on that list that you’d like to temporarily hide from the list you can make it inactive inactive customers actually will not show up when you’re working in other areas of QuickBooks but if you wanted to actually turn them back on you could go and activate them again let me go ahead and show you how to make a customer inactive and then you’ll know how to do it when you’re working in other lists and QuickBooks as well let’s say that I want to make Edward Blackwell inactive notice that Edward still owes me 1 125 I wouldn’t want to make him inactive because I’m going to be using this customer he’s going to make a payment and I’ll need to be able to apply money typically you make a customer inactive if you haven’t seen them for a while or maybe it was someone you set up and you never used those would be reasons to make a customer inactive let me show you what happens if you try to make Mr Blackwell inactive and he still owes you money I’m going to go ahead and click on edit and here’s where you go to make a customer inactive now this message is telling me that Edward still owes me money he has a non-zero balance if I say yes and make him inactive then QuickBooks will create an adjusting entry so that he doesn’t owe me money anymore I’m going to click yes and notice there’s a little error message and that’s because this customer has what’s called a recurring template that’s being used anytime you have something recurring you have to actually delete the recurrence of that whatever it is before you can go in and delete the customer in this case I’m going to go ahead and hit cancel at the bottom and let’s use a different customer Tom Allen because he doesn’t owe us any money we just set him up I’m going to go ahead and click on Tom Allen and then click edit on the right make inactive and now it tells me that Tom has a sub customers or projects making him inactive will also make all his sub customers and projects inactive and that’s what you want I’m going to click yes and now you’ll notice it says Tom Allen is deleted just a little FYI QuickBooks does not have a feature to delete anything from a list in this case a customer if you wanted to quote delete them you’d have to make them inactive and they’re still not really deleted because they show up in the list they’re just hidden so you can always activate them again now if you notice over here it says make active that’s how I go back and activate my customer again I’m going to click make active and now you’ll see over here it does not say deleted but notice the sub customer does you’ll want to repeat that process with your sub customer select them from the left and make them active and that’s a quick overview of how to make your customers inactive well let’s move on we’ve got one more thing to cover in this particular module I want to talk to you in section 6 about importing an existing list of customers that you might already have into QuickBooks thank you the last thing I want to talk to you about in module 4 is how to import your customers into QuickBooks you might already have a list of your customers in Excel for example or in a CSV file and it’d be really nice to be able just to import them into QuickBooks instead of having to enter them one at a time you will need to set them up a certain way I want to go ahead and pull up the Excel file that I have so you can see how it’s set up and even if you don’t have the feels the exact same you can map them once you go through this import process but let me go ahead and pull up the Excel file and show it to you and then I’ll pull up QuickBooks and we’ll go through and import those customers here I have a list of three customers I’d like to pull in from this Excel spreadsheet into QuickBooks and you’ll notice that I’ve got them set up by name company name email phone you can see the list here those are the names of the fields that are in QuickBooks that you want to pull the information into if you can set it up this way that’s the best way to do it but you can also map the fields if you want once you get inside QuickBooks but I wanted you to see this so that you would know exactly how to set it up and make sure you save it somewhere that you can pull it in pretty easily when you go to look for it let me go ahead and flip over to QuickBooks and we’ll pull in John Ellen and Doris all you need to do is make sure you’re on your customer list and go up to the down arrow next to new customer and choose import customers here’s where you’re going to select your Excel or your CSV file that you currently have your customers in mine’s called customer list and I’ll just choose that and you can see it brought that file in now all I have to do is Click next at the bottom and here I can map my fields to the fields that are in QuickBooks you’ll notice the First Column are the names of the QuickBooks fields and over here will be the names of the fields you had in your file if the names don’t match exactly like this one says name but maybe in your Excel spreadsheet this one said first name for example then you would choose it from the down arrow if there’s not a match like company for example when I look in my Excel sheet I did not have one called company then I’ll just say no match and it won’t be able to pull anything in the ones with the check mark that you see are the ones that actually have a match to the QuickBooks fields that sees the exact same name that it sees over in your Excel spreadsheet in this case once you’re finished going through that list you want to go ahead and click next at the bottom and you’ll see that there are three customers now that are ready to be imported if I had a lot of these I could go in and search for these by filtering and typing in the name of that customer it’s going to be pulling in the ones that have the check mark next to them I’m going to go ahead and import all three of those I’ll just choose import at the bottom and now you’ll see that it’s brought in those three customers let’s look first of all for Mr Stewart we’re going to go down the list here and you’ll notice that here is Jon Stewart he was the first one on our list it has now imported all the information within that Excel spreadsheet well that’s going to wrap up module 4 where we’ve talked a lot about customers now that we have our customers in we can move over to module 5 and talk about sales transactions using these customers hey there we’re working now in module five and in this module we’re looking at all the different types of sales transactions that can occur when working with customers these are going to be things like are you invoicing customers are you receiving payments from those customers maybe making deposits credit memos things like that before we get started over in section one I want to go through very quickly with you the sales tab that’s in QuickBooks and show you an overview of how it works and what type of information you can get out of it let’s go ahead and flip over to QuickBooks and we’ll look at the sales yeah let’s go over to our navigation bar and point to sales and then I’m going to click on overview this is just a quick overview of your income over time you can see that I’ve got 220 dollars that it looks like I made this month and I made that the week of February 16th through 22nd notice I can actually point right up here as well and see that information if I wanted to change this and see how much I’d made this month this quarter for example you can see last year this year you’ve got different choices here I’m going to go ahead and choose last month and it looks like last month we brought in over seven thousand dollars and you can see the high points of when you brought in the most money in this case January 19-25 down here I can see how many invoices are overdue and also the ones that I’ve already sent out that are not due yet and that’s 3976 dollars I might also have some money I’ve received that’s not deposited yet and you can see that here and also I can see the amount that I actually did deposit over on the right here these are some things that you can opt to set up with QuickBooks and some of these are paid subscriptions but if you want to set these up you’ve got different ways customers can pay you that would be Apple pay if you want them to be able to pay you direct deposit things like that you can set those up with into it you can also set up to get paid anywhere so if you have an app you’ve downloaded to your phone you can accept payment right there or you can send out an invoice to your customer that they can pay online they can actually click that invoice and then pay you right then and there like I said some of these are paid you will want to look into those before you sign up with one of those subscriptions if you’re interested in learning how the QuickBooks payments allow you to get paid online or in person you can watch this video here and then they have some shortcuts to some of the things we’re going to be talking about as we go along right down here but this is a quick overview of your accounts receivable now notice the next tab over will show all of your sales here you’ll see all the information on any sales transactions you can see all the transactions listed at the bottom so you’re going to see invoices payments credit memos if you look down the list here’s a Time charge there’s a sales receipt or refund any transaction that happened with your customers going to be on this list you’re going to see all the information about the transaction the balance the total and all the way over on the right you can take an action related to that particular transaction if you click the down arrow notice that you can either copy this you might want to delete it you might want to send a reminder you can kind of see your choices there the next tab at the top that you’re going to see are your invoices these are just invoices that are not yet paid you’ll notice it shows you all the information about each of the invoices the balance the total if it’s overdue maybe not sent or if it’s partially paid you can see some of these and then of course here’s your actions again if you want to take one of these actions related to one of these invoices the tab that’s next is your customer Tab and we’ve spent a lot of time on that and the last tab says products and services products and services are things that you either buy or sell to your customer they can be a physical item it could even be inventory or just a service you provide and you can see for all of these that you can look at all kinds of options related to whatever is underneath that particular tab that gives you a quick overview of how to use the sales option what I want to do now is take you back and let’s go ahead and get started looking at how to actually create sales receipts for those customers that want to go ahead and buy something and pay you at the same time foreign to a customer there are a couple different ways to record that sale one way is to create what’s called a sales receipt this is almost like point of sale if a customer comes in makes a purchase and gives you the money right then you can put all of that on one transaction and send them on their way with a receipt the other way that we’re going to talk about in section three is actually invoicing customers and that’s where you send out an invoice and the customer pays you after the fact but right now let’s focus on sales receipts let’s flip over to QuickBooks and I’ll show you how to enter sales receipt you want to start by going to your customers list look down the list and find your customer and the sub customer that you’d like to send a sales receipt to if you’re using sub customers always pick the sub customer if you just pick the main customer what will happen is you’ll look at reports and you’ll see other and you won’t know what that refers to so just make sure you always choose the sub customer notice when I go all the way to the right here and click the down arrow I have an option to create a sales receipt the first thing you’ll notice is that it brought in the customer and the sub customer you chose if you want to change those you can actually pick those from the drop down list the next thing you’ll see is a place to put in the email if you want to email this to more than one email address notice that you can type them both in here but just separate them with a comma and if you need the CC or BCC some additional email addresses you’ll see those here there’s also a check box that says send later that’s because you have the ability to set up the sales receipt and not actually send it right now it could be that you’re not really sure of the quantity but you want to go ahead and get this set up and saved you could do that you’ll see it brought in the billing address and it also has the sales receipt date which would be the current date if you want to change this date you can just click the little calendar like I did and change the date now in this case they’ve customized this sales receipt to have an additional field that says crew number if you wanted to plug something in there you would just type in the number for that crew or not use it at all now we’re going to come back to the payment method in a moment let’s go down to product service if you click your mouse in the first area there you’ll see that there’s a drop down list of all the products and services that you sell your customer if I go down this list you’ll see there are rocks these are garden rocks and if I choose that it will bring in a description and I can edit that description or add to this as much as I like I can go over to the quantity and put in how many of these the customers purchasing and the rate we’ll say we sell these for 25 dollars notice when I tab through it it’ll do the calculation three of these at 25 cost 75 dollars and this is subject to sales tax typically physical items are but Services you provide are not the little trash can that you see at the end would allow you to delete this line now let’s say I’m going to add one more to this I’m going to go down and pick a service let’s say that we have Design Services and I’ll just put this over in the description and then I’ll say the quantity is 1 and we’re going to charge a hundred dollars for this and notice this one is not automatically subject to sales tax I do have a third line available if I want to put something else in here if you don’t see an available line click where it says add lines and that’ll give you a line to type in notice you can also clear out all the lines if you wanted to do that right underneath it you have a message that will be displayed on the sales receipt it currently says thank you for your business and have a great day but you can put anything you like in there and also if you wanted to put a message and have it displayed on statements you could put that in here and just type it in over on the right you’ll see it shows us our subtotal you can see that 75 dollars of it is subject to sales tax and in this case they’re using a sales tax called California and it’s eight percent six dollars in this case if you want to give your customer a discount you can get them a percentage discount or a value meaning a dollar amount let’s say I want to give them 10 percent I’ll just type in 10 with a percent sign and notice it deducts 18 cents and if I scroll down it’ll show me the amount received and the balance due now remember because this is a sales receipt we’re going to put on this the payment amount they’re assuming we’ve received all of the payment back up here is where I can choose the payment method if they pay me with Visa or if they pay me with a check I can pick any option I like and there’s a little place for a reference number now if you had a Visa card you wouldn’t have a reference number with a check that would be a check number the next thing you’ll see is deposit two and it says undeposited funds your other choices would be to go ahead and deposit this to maybe a checking account for example you can see the list let me explain undeposited funds for just a moment in your chart of accounts you will have an account called undeposited funds this is a place where money sits that you’ve collected but you have not yet taken to the bank a customer came in paid you with a check you want to show QuickBooks the sales receipt is paid so you’ll choose deposit two undeposited funds but it might be that you’re going to collect all the monies you receive today and make them all one big deposit that’s when you choose undeposited funds if you knew this was the only thing that was going to be in this deposit you could choose checking and skip the next step of making a deposit I’m going to go ahead and leave it in undeposited funds and when you’re finished down the bottom you’ll want to either just save this or you can choose save and send which will email it or from the down arrow you can say saving close we’re going to close this and now that transaction has been completed you’re going to notice when we look at this that was Tom Allen 124 Scottsdale does not owe us any money however if we go over to the all sales and look here we should see Tom Allen’s sales receipt right here for a hundred and eighty dollars and 82 cents and it says it’s paid here’s where we could go and actually print this I want to view or edit this you’ll see here that this is your sales receipt where you can make that change if you need to I’m going to go ahead and get out of this I’m going to hit the X and cancel it and that’s how you would go in and actually create a sales receipt that money is now sitting in undeposited funds I want to take you over to your chart of accounts which happens to be over here under accounting and show you that account so that you can see the money there let’s see our chart of accounts and here’s undeposited funds now you can see it has 2 243 dollars in there but if I view the register over here you’ll see the transaction that we did and also which is right here any others that were already sitting in undeposited funds so hold that and when we talk about making deposits in section five you’ll see how this all comes into play but one way to keep a check on yourself is if you know everything’s been deposited then there shouldn’t be any money in undeposited funds okay let’s go ahead now and go over into section three and talk about invoicing customers we’ve talked a little bit about sales receipts and now let’s talk a little bit about sending out invoices to your customers remember the difference in a sales receipt and an invoice is that on a sales receipt the customer is standing right there you’re going to put in the line item they purchased you’re going to put in they made a payment the invoice is where you’re going to send an invoice to your customer and wait for payment at a later date sometimes you email these sometimes you mail them really doesn’t matter you’re going to receive the payment at a later date let me show you how to create invoices for your customers it’s very similar to the sales receipts but I want to show you where to go to get started creating invoices there are a couple different ways to get started creating an invoice you’re going to head over to the navigation Pane and point to sales you can either use the invoice option here or the customers if you choose the invoices option here you’re going to see a list of all of your invoices that you currently have and if you want to create a new one you can choose new invoice from right here if you started with the customers you would just come back to sales and go to customers this way then what would happen is if you had a customer you want to create an invoice for you could check them off head all the way to the right under the action column and then you can create an invoice this way either way would work whatever works for you ‘ll notice this way because I had a customer selected it pulled in all that customer’s information now if I wanted to change that I just click the down arrow and choose the new customer from the list remember I told you that if you’re using sub customers always always always pick the sub customer you want to go with the lowest level so that when you look at reports you don’t see other on your reports I’m going to start with Freeman Sporting Goods I’ll choose 55 twin Lane and now you’ll see it’s changed the customer email and the billing address if you didn’t have an email set up in your customer setup then you could physically type an email here you can also choose to BCC or CC someone just by choosing this option and putting their email addresses in here I’m going to hit cancel you can also send this later if you have this checked that means that you can create this invoice and then save it and then create another one and check the same box if you’ve done that you can email both of them at the same time that’s called sending a batch or emailing a batch if you happen to see that something’s changed with the billing address go ahead and change it here it’ll prompt you when you go to save it and ask if you want to save this permanently in their record because we had terms of net 30 set up in the customer setup you’ll notice the invoice date is 212 but the due date is 313 which is 30 days from the invoice date if I change this to Net10 you’ll see the due date is 10 days just make sure the due date is the date that you want the invoice to actually be due to you the crew number is a field they custom set up for this particular exercise you can go ahead and plug in some number just to keep it consistent there and then you can pick a product or service from the list to invoice your customer I’m going to choose installation and let’s say that I’m going to charge them a quantity of one at two hundred dollars remember a service is non-taxable so you will not see a green check mark there if you happen to see one just uncheck it and if you have a second line you’re just going to type on the second line whatever information you want to invoice the customer for here’s where you have your message that will appear in your invoice automatically you can type in there and change that to anything you like also when you’re sending out a statement to your customer then you can have a message on that statement appear as well whatever you typed in here you’ll notice that you can also put in an attachment let me scroll down just a little bit so you can see that if you happen to have some sort of file that was already saved in your computer you could attach it here an example might be if I’m installing landscape design I might have hired a subcontractor to do that and maybe the subcontractor has already sent me a bill and I want to attach that to this invoice over on the right if you’re going to give your customer a discount you can give them a percentage discount or a value discount I’ll choose value and give them 25 dollars and you’ll see it will deduct it from my 200 so now that the balance due is 175. couple things at the bottom you’re going to be able to do you can print or preview this right here you can also make it recurring and what recurring means is if this is something that happens on a regular basis then you can set QuickBooks up to automatically just put this in whenever you’ve told it to let’s say once a month it inserts this invoice automatically and then you can customize this a little bit if you want to do things like they added the crew number you’d be able to add Fields like that at the bottom you have an option that says save you have your save and close and if you wanted to create a new one you could click the arrow and choose save and new I’m going to choose save and close though and you’ll see now that our invoice has been completed if I wanted to go back and look at this I could actually come up here to invoices and then I can look down this list and find the one I’m looking for and that’s how you’re going to create an invoice for a customer let’s go ahead and move on into section four and I’ll show you how to record the payment once a customer actually pays you now that you’ve created your first invoice the customer is going to mail you a payment at some point now it doesn’t matter how the customer paid you you’re going to record their payment the same exact way we’re going to go in and tell QuickBooks how much the customer paid the date they paid all the pertinent information and when we’re done we’ll see that the invoice will show as being paid if they’ve paid the full amount if they haven’t it’ll show the balance or if it’s an overpayment it will show that as well let me show you how to record a customer payment for me before we receive our first payment I’d like to take you over to the reports section QuickBooks just head over to your navigation bar click on reports and the reports from the sub menu and this is all the reports that are in QuickBooks we are going to take some time in a later module and look through the different reports but right now I’d like you to head down to a section that says who owes you these are your accounts receivable reports if you head over to the second column you’ll see the second one is called the open invoices report and you can just click to run that one now these are all of the invoices that you’ve sent out that have not yet been paid even if the customer owes you a penny if you remember in the previous section we actually created an invoice for Freeman sporting goods and we did one for 25 Twin Lake and here it is right here 175 dollars I want you to notice that in any report if you want to go to that particular transaction you can see this is a link and you can just click anywhere and actually open up that invoice I wanted to show you this first because once we receive our payment this invoice will actually disappear if it’s paid in full or you will see this invoice and the balance is owed right over here not the 175 dollars that it originally was invoiced for now that you see that let’s head back over to our customers we’ll go to sales and we’ll go down to customers now let’s go down find our customer we’re going to receive the payment for and this is going to be Freeman Sporting Goods 55 Twin Lake you’ll notice over in the action column that you can receive a payment this is the receive payment window and the first thing you’ll notice is it pulled in my customer and my job I don’t need to change that unless I happen to want to pick a different customer and job I can look for an invoice by invoice number if I want to I can click there just type in the invoice number and hit find and it will search for it for me the next thing is the payment date I’m going to say this was received on February the 28th and here’s the payment method now here’s where you can pick the way that the customer actually paid you did they pay you with cash did they pay you with MasterCard Visa PayPal if you happen to take other payment methods you’d like to add like venmo or Square or even Bitcoin just come up here to add new and all you have to do is type in that new payment and then just hit save and from now on that payment method will actually be on the list there now I’m just going to say in this case it was a check though and I’ll put in the reference number that would be the check number and then just notice the money is going to go to an account called undeposited funds now hope that for a moment we’ll come back I want to finish the rest of this and explain this part to you now over here it assumed that my customer paid me the entire balance they owe for all of their invoices and we know that’s not always the case here I’m going to put in the amount that the customer did pay me let’s say the customer paid me 179 dollars now if you notice down at the bottom these are all of the invoices that are still open even if the customer owes me a penny you’ll notice what QuickBooks does is assumes the customer is paying all of the first one the rest of the money goes to the next one and then the balance of the money goes down to the next one all the way down now that’s not always how the customer has asked you to apply their payments let’s say in this case they’re not paying the first one they’re paying 175 dollars on this last one and they’re going to pay the four dollars on this one and that’s why it was 179 dollars always make sure that you have the correct invoices checked off and the correct amount over here that the customer is paying towards each of the invoices a couple of other things to notice when you look down at the bottom there’s going to be 179 dollars worth of money that’s applied and there’s no credit memos right now but if you had one you had issued for this customer then you could apply that credit memo to one of these invoices that would be open here if you want to clear the payment you could that would let you start all over filling this form out and then notice at the bottom there’s a place for a memo over on the left and there’s also a place for any attachments if you wanted to add something here and that’s all you need to do to receive payments it’s pretty easy process but I do want to go back up to this right here where it says deposit two and talk to you about what your options are currently if you receive payments the money’s going into this account called undeposited funds I’m going to go ahead and save this real quick and then I want to show you where undeposited funds is and then we’re going to come back in a second so I can show you where the other options are now if I close the receive payment window and head back to the chart of accounts I’m going to go down here to accounting chart of accounts you’ll notice that if I go down the list there’s this account called undeposited funds currently there’s two thousand two hundred and forty one dollars and fifty two cents in that account this is where money sits that you’ve received but have not yet deposited into the bank a good way to keep a check on yourself if you know that everything’s been deposited this should be zero let’s look at this for a second and see if we can figure out what money happens to be sitting in here notice you can click to view the register over on the right and what you’re going to notice is that right now it looks like there are three payments sitting in undeposited funds one of them is being the one that we just received none of these three are in the checkbook yet because they have not yet been deposited okay so let’s head back over to our payment that we just looked at I’m going to go to sales and go back to customers and let’s go down and find our customer Freeman Sporting Goods 55 Twin Lake and I’m just going to click on that for a moment and here you will see the payment that we just received I’m going to go ahead and click on that just to open it back up here were your other choices I could go ahead and put the money right in the checking account and this will skip the next step that we’re going to do but let me tell you why you may or may not want to do this if the 179 dollars is the only thing that’s going to be in that deposit then you can click checking hit save and close at the bottom and you are done with the whole process
but if you think you might receive another payment possibly from another customer and this one and the new payment are going to be together in the same deposit that’s when you want to pick undeposited funds and this will make more sense once we go through and make the deposit over in the next section but I’m going to go ahead and click save and close at the bottom here and let’s see if that invoice shows that it’s been paid when I go down the list and look at the invoice for 175 dollars it does show that it’s been paid in full if there was one penny left it would not say paid right here that’s how you receive a payment for a customer when you’ve sent out an invoice the next step in the process would be to actually take that money and make a deposit why don’t we head over into section five and I’ll show you how to make deposits foreign now that we’ve made a sale for our business we’ve actually invoiced a customer in this case we got paid and now we want to take that money and put it in the bank and that’s where the make deposits option comes in it’s always going to be the last step in this process no matter how you receive the payment whether it was a Visa card cash a check you’re going to have to make deposits and you want to make sure that your deposits in QuickBooks match what actually happened at the bank let’s go ahead and flip over to QuickBooks and talk about the make deposits option the easiest way to record that deposit is to click the new button right here and over on the right here under other you’ll see bank deposit this one down here is going to be your actual deposit slip a couple things you’ll want to double check on is make sure you have the correct bank account chosen here it’s very easy to have the bank account that you last use show up in that field and then you can’t find your deposit notice that the balance in the checking account is one thousand two hundred and one dollars and this is the date of the deposit let’s say I’m going to make this deposit on March the second now down at the bottom these are the three sets of monies that we saw that were sitting in undeposited funds what you’re going to do is check off all of the ones that are going in this deposit if all three are going to be in this deposit you check them all off if maybe the first two were going to be in that deposit and then maybe this last one was in a separate deposit do them separately because you want these to match what actually happened at the bank let’s say in this case though all three are going to be deposited a couple of things when you’re looking at this list here you can go and change the payment type if you didn’t do it when you were actually receiving the payment you’ve also got a place for a memo if you’d like to fill that in and then you can see there’s the reference number column and then the amount column over on the right my deposit will be 2241.52 cents now right down here it says cashback goes to If you happen to have a business bank account you’re not going to be able to get cash back but as a sole proprietor you could if you’re going to keep some cash then you would say cash back goes to this account and you would pick whichever account this went to you would also be able to have a memo and if you were going to keep 20 bucks you could type that in and it would deduct it from this total right up here there’s also a place to add funds to this deposit if I click this little arrow it’s going to open up this part here and I can add some additional monies now this could be something like maybe you got a rebate from Staples you could type that in if that was the situation it would say received from Staples the account would be office expenses or office supplies pick whichever account you actually use when you purchased the items for that rebate and put it back to the same account you’ve got a place for description the method and the amount of money it could be you’re also going to put some personal money into the business if that’s the case then the account you want to choose is that owner Equity if your members talking about that in an earlier module but remember that everything that goes into a deposit is not always income to the business so make sure that this goes back to the correct account if you’re adding additional funds notice if you need more than the two lines you could add additional lines and have as many lines as you’d like here you can also add a memo to this deposit if you’d like or add an attachment down at the bottom and that’s all you need to do as far as making a deposit now a couple just other options you could print this deposit out down at the bottom or make it recurring it could be that you have a customer set up on automatic draft where they actually pay you a thousand dollars a month let’s say and this would be that deposit lots of different scenarios there I’m going to go ahead and hit save and close now at the bottom and at this point the money is actually going to be in my checking account remember it’s 2 000 240 152. now that whole process of invoicing a customer receiving a payment and making that deposit has been taken care of now let’s go look in the checking account and see if we can find it it just so happens that on the overview right over here where we are the checking account is here that is one way to link to it to look at the balance another way would be going down to accounting to our chart of accounts and just opening it that way any of this would work I’m going to go ahead and view the register when I look in the register you’ll notice that there’s my deposit right there notice it says split because it’s split amongst multiple line items in this case we had three different transactions that went on the deposit itself I’m going to go ahead and cancel that and that’s the process of actually making a deposit the next thing I want to do is take you over into section 6 and show you how to set up credit memos for customers there are times when you will want to issue a credit memo to an invoice let’s say you have a customer that just isn’t happy with your services and they refuse to pay one of your invoices you can actually leave it on the books for a while if you’d like but eventually you might want to credit that off let me go ahead and show you how to create a credit memo the first thing that you want to do is look up the original invoice and see what it is that you charge them for to begin with I’m going to look at Red Rock Diner and you’ll see there’s an invoice for seventy dollars here I’ll just go ahead and open it up and you’re going to notice that we charge them for Pest Control it looks like probably two hours at 35 dollars an hour for a total of seventy dollars now let’s say the customer just wasn’t happy with us and we’re going to just credit that invoice when we create the credit memo we need to use the exact same product or service that we charge for to begin with the way you’re going to create the credit memo is come up here and click on new underneath customers you’re going to see credit memo plug in the customer’s name in this case it is Redrock Diner you’ll see it populates their email their billing address and it’s going to have the current date for the credit memo date just make sure you put the date that you would like we’re going to be looking at tags over in section 9. let’s just hold that for a moment and let’s go down to product or service here’s where we’re going to put in Pest Control remember you want to credit the same product or service that you invoice for to begin with we’re going to choose the quantity of 2 at 35 and that’s going to give us a total of 70. all we have to do now is go ahead and go down to save and close now that the credit memo has been created I want to show you two things that happen on your customer’s account notice here’s the credit memo and it says it’s closed and then there’s a payment that wasn’t there before now this payment is where you’re going to go to actually apply the 70 dollars to the correct invoice because see how the invoice is still open over here I’m going to click on the payment now if it sees an exact match it will go ahead and check it often but if it doesn’t come down and choose the correct invoice and then notice the credit memos at the bottom so you want to make sure those two are checked so they apply to each other so you’ll notice down here the amount to apply is seventy dollars and that’s all we have to do we’re going to save and close at the bottom and because this transaction is linked to others it will ask us if we’re sure we want to modify this and the answer is yes and now when we go back and look we’ll see that the credit memo is closed the payment is closed and the invoice is actually paid so remember this is a two-step process you have to create the credit memo then go back to the payment and actually apply that credit memo to the correct invoice now that you know how to create credit memos I want to show you over in section 7 how to actually give your customers a refund there are times when you want to issue a refund to a customer and that would be if a customer has purchased something and paid in full and you want to actually give them their money back that’s the difference in a refund and a credit a credit usually sits in their account until you just credit the money off of your books whereas refunds you actually give customers the money back let me go ahead and show you how to create a refund we’re going to create a refund receipt but before we can do that we need to go ahead and look up our customer and see what it is that we’re actually going to refund them for this is Duke’s basketball camp if you notice they have an invoice here for 460.40 that is paid in full I’m going to click on invoice to actually open this up and you’ll see that the second line are some Garden rocks that they purchase from us they purchased six of them at twelve dollars and let’s say that they’re going to return three of them at 12 because they didn’t need all six of these we’re going to go ahead and close this now and now we’re going to create our refund receipt we’re going to go over to the new option on the navigation pane we’re going to come down to refund receipt here we’re going to pick our customer’s name in this case it’s going to be Duke’s basketball camp you can see it pulls in their email and their billing address and we just need to make sure we have the correct refund receipt date down here where it says payment method this is how the customer actually paid you they wrote us a check let’s say and we’re going to refund them from our checking account if you’re going to actually print them a check then it’s going to let you print this later or if you want to go ahead and print it from here you could leave that check number now let’s go ahead and put in the correct product or service and we decided that this was Garden rocks and so we’re going to go ahead and choose that and remember they’re returning 3 at 12 and that makes 36 dollars if the item was subject to sales tax when the purchase was originally made then QuickBooks will automatically choose the tax option to give them their tax back as well you’ll notice this equates to 36 dollars the total amount refunding will be 38.88 I’m going to go ahead and hit save and new at the bottom and now that refund receipt is done I’m going to click OK here when it says it was successful and now let’s go back and look at their account if I’m looking at Duke’s basketball camp you’ll see here’s the refund right here and you’ll notice that it says it is paid now if you want to actually go ahead and print a check then all you have to do is over here it says print check and you’ll notice that it automatically has Duke’s basketball camp and a check waiting to be printed for 38.88 just double check that you have the correct checking account at the top and make sure you have the correct check number that your check is going to be now if you were giving them cash you would have chosen cash from the option back over in the refund receipt and then that would have just been done that’s really all you have to do at this point you can actually go down and you can preview and print this and then that will be the end of it there’s the preview you would hit print and it would print out and that’s how you create a refund for a customer it’s called a refund receipt let’s go ahead and take a peek now at creating statements for your customers one of the things you have the ability to do in QuickBooks is send statements to your customers a statement is basically a gentle reminder to your customers that they owe you some money typically statements are sent at the end of each month and they show the activity that happened during that month you don’t have to send out statements but it’s a nice little feature to keep your customers abreast of what’s going on with their account let’s go ahead and flip over to QuickBooks and we’ll see how statements are created when you’re ready to create statements for your customers just go to your navigation Pane and choose the new option over here where you see other if you look down you’ll see statement the first thing you have to do is pick a statement type you can choose a balance forward any open items for the last year basically and then you can also choose a transaction statement I’ll choose balance forward for the statement date you generally want to pick the end of the month that means that in this case the start date would be January 1 and the end date would be January 31. for the customer balance status you can choose all open or overdue I’m going to choose all and then apply and these are all of my customers who met the criteria they call this the recipients list if you’re looking down this list and you see one that you don’t want to send a statement to just come over here and uncheck the Box now when you’re ready you can print or preview these down here in the middle I’m going to click on print or preview so that we can see what a statement looks like now I’m going to have one here for each customer you’ll see as I go down the list there you go and for each one you’re going to be able to see all of the activity for January 1 through January 31. the first thing you’ll always see is the balance forward from the previous month notice up here tells you the total do and there’s a place where the customer can actually send you a check and if they want to type in the amount closed or write it in right there they can do that and then down at the bottom of the statement it shows you how much of this is in the currently due category how much is in each of these categories and then again the total over on the right and that’s what a statement looks like you can pick any date range you like when you’re creating statements if you just want to send one to one customer you can do that but that’s an overview of what statements look like and how they work I’m going to go ahead and close this and you really don’t need to save or save and send this once you’ve printed these out you can go ahead and just X out at the top and then it’s ready and you can print them the next time well let’s go ahead now and look over in section 9 and talk a little bit about how a new feature of QuickBooks called Tags is going to work there is a brand new feature in QuickBooks online that they’re rolling out right now called Tags and what tax will allow you to do is create certain words that will appear on a drop down when you’re in different transactions in QuickBooks and you can choose those and later you can use those to search for things or to run reports based on those tags if you’re familiar with Gmail we’ve got something similar in there where we can create a list and tag different emails and then search for anything that would have that particular tag we’re looking for this is still in beta right now if you happen to not see it when you open up your QuickBooks Online just know it’s coming they’re just rolling out in stages right now and you may not have all the options related to tags to get but just know it will be coming somewhere down the line let me give you an example of how you might use this feature currently we have a feature in QuickBooks called classes and we’ve kind of been using that in the way that tags will work but let’s say that you have an attorney’s office and you have four different attorneys in that office you might want to run reports on the company as a whole but you might also want to run reports on each attorney if you had this list of classes set up you could just pick from the drop down list in each transaction you’re in which attorney that this should be tagged to and we’re going to use tags in the exact same way I don’t know if they’re going to get rid of classes down the road somewhere but tags are going to be a really nice feature so let me flip over and show you what’s in there now and like I said if you don’t see these options or you see something new down the road it’s because they’re rolling it out it’s still in beta the way you’re going to access your tags option is through the gear icon on the top right hand side of your screen and underneath the list right here you’ll see tags now currently we don’t have any tags set up but once we do set up our first tag you’re going to see the top of the screen change and you’ll see a section that says money in and money out let me give you an example of what we’re going to do with our tags this is a company called Craig’s design and Landscape Services they actually do two different things they do design work and they do Pest Control and as part of their design work they have three different areas they focus on they focus on fountains landscaping and sprinklers if I wanted to put my tags in a group then I could do that as well and you will see the groups listed right here along with the tags but let’s start with just a tag I’m going to come over here and under new I’m going to choose tag and let’s say that I use fountains as my first tag if I wanted to put it in a group I could but I don’t have any groups set up yet so right now I’m just going to hit save at the bottom and now you’ll see my first tag called fountains and notice it’s ungrouped is not part of a group now here’s what I would say in a second ago about the money in and money out once I start applying these tags to different transactions I can come here and see the money in or out based on those tags I have now let me go ahead and create a group to show you how this works I’m going to create a tag group and I want to create a group called design and I’m going to create another one in a minute called Pest Control now you’ll notice that from this screen here if I wanted to add a tag I could do it right from here without having to go back out and hit new tag I’m going to add two more because I have fountains and I want to add Landscaping and we’re also going to add sprinklers and I’ll just hit add tag there now let me go ahead and click done at the bottom and now what you’re going to see is design is a group and notice the down arrow in order to see the two tags in there I click the arrow and then I see those two now fountains are still ungrouped if I wanted to add it to this Design Group I can come over here where it says edit tag and then I can select the group I’d like it to belong to in this case design and when I save it now you’ll see design has three tags underneath now let me create one more tag group I’m going to create one called Pest Control and let’s say under pest control that I’m going to create two tags I’m going to create one for residential and one for commercial customers I’ll add that one and come back and ADD commercial and then add that and now I’m going to say done at the bottom and now you can see at the bottom I’ve got two different tags I’ve got one that’s pest control and one that’s design now the other thing is notice the color blue I can leave it like this but if you want each tag group can have a different color scheme going on if I come over here to edit the group you’ll notice that here I can change the color maybe this one can be this yellow color and I can save that and notice it also made all the tags below it that same color and that way they just stand out a little bit when I’m looking at different reports of things now let me show you where you’re going to use these tags or tag groups this will be in any transaction let’s say that I go over and I create a new invoice you’ll notice that in here you have an option that says tags you can choose from the drop down list and you can choose more than one if you need to this might have fountains and it might also have some pest control and there’s your two tags that we’re going to be using now I will be able to look up reports based on the product or service but I can also look at the reports based on fountains or commercial now let me just go ahead and set something up here so you can see how this works I’ll pick Tom Allen we’re going to go down and pick for a product or service we’re going to go ahead and say this is gardening and we’re going to say one at fifty dollars and then let’s say for the next one here we pick fountains we’ll do a rock film and that one was 275. now let’s say also we’re going to do some Pest Control around this rock Fountain so that we don’t have bugs in there and now we’ve got a couple of different products and services here now when I go ahead and click save and close here we’re going to go back to our tags and see if we have any money that’s in or out of these and now you’ll see that there’s 382 dollars money in because remember QuickBooks considers at the time you create the invoice it to be part of your income when you actually write a check use your credit card that sort of thing that will be on the money outside so if you had to actually buy some materials related to one of these and you tagged those transactions you would see the money out show up over here and that’s basically how tags are going to work it’s going to be a great new feature that’s really going to help you drill down a little bit deeper than you can now to see where your money is coming in or money is going out let’s go ahead and do one more thing in this module we’re going to look at some of the reports that have to do with your customers and sales QuickBooks has a ton of different reports related to your customers and your sales and I want to take you through and show you some of these different ones that you will want to run on a regular basis to see how your company is doing in these different areas let me go ahead and flip over to QuickBooks and I will show you a couple of these different reports I’m going to head over to the navigation Pane and I’m going to click on reports there were several different categories of reports here but I want to focus right now on the one that says who owes you and then below it are your sales and customers underneath who owes you probably one of the most common reports is the open invoices right here which you’ve seen before and this is just a list of all of your customers who still owe you money even if they owe you a penny you’ll notice that it shows you all the information you need about the transaction like the dates you can see the amount and if you’re on that line and you just point to any of these pieces of information you’ll see that you can click and actually go to that transaction if you actually change that transaction and then get out of it when you come back here as long as you save the transaction the report will be updated another one I’m going to go back to reports that you’ll want to look at is going to be under who owes you customer balance detail this report will show you all the transactions that occurred for each customer and each job or sub customer when you first come in it might look like you’re just looking at the invoices anything open what you need to do is go up to the top right and choose customize come down to where you see filter and you’ll notice that where it says AR paid it says unpaid right now go ahead and choose all from the list and then run the report at the bottom and now you’ll see each transaction that happened for each customer sub customer and or job here I’m going to go ahead and go back to reports we’ll look at a few more here back down to who owes you there are some other ones that you might want to look at for example you might want to run a collections report this one is going to show you all of the information about the customer this time you’ll notice there’s a phone number here as well so if you needed to make some phone calls and call some of these people you’ve got that information right here on this report I’m going back to reports some other ones just to notice you do have the ability to run an accounts receivable aging detail and an aging summary anytime you see a summary and a detail this summer we will show you the line item and one total whereas the Aging detail will show every single option that made up that category or that line item that you would normally see you can see an invoice list here if you like you can see a terms list there’s a statement list just all kinds of things you can look at underneath who owes you now done under sales and customers here’s where you can run things like a customer contact list this is just going to give you each customer their phone number their email that sort of thing you can also go in and look at estimates by customer you might want to see if you have any income by customer you might want to see all your payment methods product lists and services your sales you can look at those by customer you can look at them by product and you can also look at them by time or activities so just know that there’s a lot of different reports under those two options right there now most of your reports can be customized if you happen to run for example a sales by customer detail you’ll notice that you can come up here and change the report period I can look at all dates and then I can hit run the report and I’ll see all of the information for each customer I can group these by customer I can group them by product I’ve got all different kind of ways I can group this report and also something else to notice is that all of your reports are automatically run on a cruel basis not a cash basis and you can change it per report if you need to accrual basically means that as soon as you invoice a customer it’s going to show as income to your business and QuickBooks whether they’ve paid it or not if you had any expenses let’s say you entered a bill it would show it as an expense whether you paid that bill or not we’re going to see how this really works when we look at a profit and loss a little bit later but let’s go ahead and just kind of wrap this up I just want you to see the reports that were available for customers and for your sales and most of them will be under these two headings let’s go ahead now and move over to module 6 and talk a little bit about products and services okay we’re just starting module 6 now and in this module I want to talk to you about how products and services work in QuickBooks a product or service is something that you either sell your customer or sometimes you purchase those products and services as well and you want to set those up and make sure you set them up correctly so that you have accurate reports as far as inventory or as far as some of your profit loss those types of things let’s go ahead and flip over to QuickBooks and start talking a little bit about how products and services work I’m going to give you a quick overview and then I’ll take you into section two and show you how to add some of those products and services to get to a list of your products and services go to the gear icon on the top right of your screen then underneath the list you’ll see products and services this is a list of all the products and services that you have set up remember that sometimes you buy these and sometimes you sell these and there are different types of products and services you can create you’ll notice currently mine are sorted by type if I wanted to sort by any of these other columns I would click on the name and just sort by that column you’ll see there are Services you provide like Landscaping trimming you’ll see that there are different Pest Control those are all services you provide when you get past the service items you’re going to see that there are actual inventory items as well inventory means that you actually sell physical products and you count how many you have for example when I look at Rock Fountain you’ll notice that it looks like I have two on hand and I can buy more and add to my inventory or I can sell these and that will take it out of my inventory there are other types of items that you can have as well you can have non-inventory items those are actually items that you don’t want to check how many you have in the back but they’re physical items that you either buy or sell you’ll notice when you’re looking at this list that you can see the name of the item if you’re using SKU numbers and you’ve got those set up you’d be able to see that here the item type a description and this is the description that automatically appears when you pull that item onto an invoice or some sort of form in QuickBooks you’ve got the sales price if there’s one set up sometimes it’s different for every customer so they just don’t set up a price you just do it when you’re actually invoicing the customer or if you happen to buy this whenever you’re purchasing it if this item is subject to sales tax you would see that here if it’s inventory we saw that you can see the quantity on hand and the reorder point that basically means that when you get down to a certain number that QuickBooks will pop up and tell you you need to order some more and you can see that they did not set that up in this exercise the last column that you see is the action column here’s where you can edit to one of these items if you need to make it inactive adjust the quantity that you might have on hand those types of things but this is where your list of products and services is going to live what I want to do now is show you how to set up some of these products and services so let’s head on over to section two so you can see how to do that now that you’ve had a quick overview of what the products and services screen looks like I want to take you in and show you how to create your own products and services some of you may only have six or seven in your business other businesses might have thousands it just really depends on what your business does let’s go ahead and flip over and talk about how to add those new products and services the way you’re going to add a new product or service is head up to the new option in the products and services window the first thing you need to tell QuickBooks is what type of product or service is this that you’re adding is it going to be inventory inventory means that you want to keep some on hand and then have QuickBooks remind you when you get down to a low number so you can order some more that’s called true inventory you can check how many you sold and how many you purchased sometimes you don’t want to keep any in the back room and that’s what we call non-inventory it might be a physical product that you buy or sell but you just run reports when you need to to see how many you bought or sold you don’t really need to keep any in the back room a service is a service you provide and then you have the option to take any of those three and put them into what’s called a bundle the example they use here is a gift basket of fruit cheese and wine you might actually add something else to that gift basket like a spoon or a cup or something like that and you can actually set those up as one of these three types and then you can create a bundle which includes those three items let’s go ahead for now and say that we’re going to set up a service the first thing we’re going to do is go ahead and give our service a name and I’m just going to call this maintenance you have the ability if you have SKU numbers for your products and services to put that number in here and also you can add a picture of that particular product or service from over here where this little pencil is this would have to be a picture that’s already in your computer that you can go and grab and pull in you can also put your products and services in different categories there’s a few already created for the exercise but if you wanted to add a new category you could do that by hitting the add new Option and creating a category like you see here they’ve got design landscaping and pest control as categories the next thing is the description when you actually put this on an invoice which means you’re selling this to your customer what is the description that appears let’s say that it says quarterly maintenance and then the next thing is going to be the sales price if you have a flat rate you charge for this then you can type that in and it will pre-populate for you but if it’s different every single time then you’ll want to just leave this blank nothing happens here it’s only when you buy or sell the product or service that numbers play into your reports but let’s just say that we have a flat rate of 250 a quarter we charge for this and then the next thing which is the most important thing on this screen is the income account that you want this money to go back to when you put this on an invoice in this case they’ve got it automatically going back to Services income which is where I would probably leave it but if you wanted to put this in any other account feel free it’s just it needs to be an income account now if you don’t pick an income account QuickBooks will not say anything to you about it but you’ll look at reports and they’ll be really wrong and you can’t figure out why look at the word the word is income meaning it needs to go to an income account if this was a particular product or service that you were going to charge sales tax on then here’s where you tell QuickBooks this is a taxable product or service or non-taxable product or service typically Services you provide are non-taxable and physical items you sell are taxable now if this happens to be a particular product or service that you buy from a vendor that you like you can check the box and put in the vendor information but I’m going to go ahead and uncheck that and click save and close at the bottom and now you’ll notice that I have a new service in my list here it’s called maintenance and you can see all of the information all the way across now if I needed to edit that information I can click on edit here that will take me back to this screen and I can change whatever I need to and save and close again and then it will be updated you do have a couple of other actions you can take under this drop down arrow here you can make this service inactive if you need to you can also run a report on this service or you can duplicate it and that’s a quick way to go ahead and set up your new products and services now that you know how to set up a service let’s go ahead and look at setting up an inventory product that way you can see how to tell QuickBooks how many you currently have on hand and then you can see how inventory is added to or deducted from that number now that you know how to add new products and services in QuickBooks let’s talk specifically about adding inventory products true inventory means that you want to keep a count on how many of these products you have in your office you want QuickBooks to let you know when you get low so you can order some more you’ll want to actually know how many you have on hand when you first set up your new inventory product and once you’ve done that then as you invoice customers that is how your products will get out of inventory and as you purchase them that’s how your products will get back into inventory let’s go ahead and flip over to QuickBooks and I will show you how to add an inventory product you’re going to add an inventory product the same way we added the new products and services over in section two go to the top of your products and services list and choose the new option this time we’re going to choose inventory the first thing you’re going to do is give your inventory a name I’m going to call this one sprinkler clamps and then we’re going to give it a skew I’ll call this one 55 and then we’ll choose a category and let’s say in this case that we’re going to put it under Landscaping now here’s where you put in the initial quantity on hand this means you’re going to do a count before you set up your product and if you have 10 in the back room you’re going to put that in here and that gives it a starting number you also want to have a date to start this with and let’s just say in this case that I want to go back to the beginning of February reorder Point what this means is what number do you want to get down to before QuickBooks pops up and tells you that you need to order some more let’s just say in this case when we get down to three the next thing you’re going to see is inventory asset account now do not change this this is the account that the value of the inventory will actually go into in your chart of accounts remember that inventory is an asset to your business you are worth more because you have it right now but your goal is to sell it and get it out the door this is the asset account the inventory will sit in and then we’re going to put in a description now I would put in the same thing we’ll put a new sprinkler clamps and then if you have a set rate that you charge for this you’ll want to type this in if you don’t have one that’s different every single time then you can just leave it blank let’s say that we sell it for 2.75 you don’t want to change this either because this is the income account that this will go into when you make a sale when I put sprinkler clamps on an invoice and I sell this it will go into the sales of product income account if this is a taxable product you want to make sure that this says taxable and now we have the purchasing information this was the selling information up here this is when you purchase it down here the first thing it asks for is a description when you order this from whatever company you order them from what is their description and sometimes it’ll be the same other times it might have a part number at the end there’s just all kinds of different things that this could say what is the cost and this means on average what do you buy it for it does not mean that the last time you purchased this it was 1.75 let’s just say on average though it is a dollar seventy five and it will go to an expense account called cost of goods sold if you have a preferred vendor then you can pick them from the list here it could be that you like to get these from Hicks Hardware and that’s all you need to tell it I’m going to go ahead and click save and close at the bottom and now I should see my sprinkler clamps right here you can see the SKU number we typed in the sale price the cost there’s 10 of these currently and when we get down to three it’s going to pop up and ask us if we want to order some more don’t forget you have some options over here under your action column if you wanted to go and adjust the quantity maybe you discovered there’s really only nine in the back room you’ll be able to do that you also have the ability to adjust the starting value and that’s really all there is to adding inventory products let’s go ahead now and move over to section four and talk a little bit about purchase orders if your company buys a lot of products you might want to create a purchase order system for your business when you do this it’s a way of actually tracking everything you’ve ordered and that way you can see what’s come in if there’s anything back ordered that sort of thing and this is also going to be a way to start the process of receiving your items into inventory let me go ahead and show you how to create a purchase order before we get started there’s a couple things that you need to know first of all if you’d like to use the purchase order feature in QuickBooks you have to be enrolled in the QuickBooks Online plus Edition that’s the addition that actually handles purchase orders the other thing is you’re going to have to actually turn on the purchase order feature in the account settings let me show you where to go for that you go up to the gear icon you’re going over to account and settings make sure you’re clicked on expenses and here’s where you see purchase orders if this is not on just come over here to this pencil and then make sure you check the box here to use purchase orders as long as that’s good then you should be fine I’m going to go ahead and close with the X and let’s go and look real quick at our products and services because I want to show you how we’re going to order some more and put it into our inventory I’m going to click on the gear icon under the list the second column I’m going to click products and services if you remember we talked about some of these being inventory and one of these that I want to talk about right here is going to be this rock fountain now let’s say we have two of these but we’re getting ready to do a new job and we need to order two more to have a total of four this is what we’re going to order create a new purchase order I’m going to go to the navigation bar and click on new I’m going to go down in the second column and click on purchase order and the first thing I need to do when creating a purchase order is to pick my vendor I’m going to go down the list here and we’re going to pick Hicks Hardware if you had Hicks Hardware’s email it would be pulled in right here you can see there’s the mailing address and then let’s talk about the ship too for a second if you want to have Hicks Hardware ship these directly to your customer you can choose your customer from here if not then it’s just going to come to your office you don’t need to choose anything there here’s the date of your purchase order and in this case they’re using the crew number field so we’re going to plug something in there you can also set a ship via which would say USPS FedEx you can also set a sales rep if you had those as well now looking down the list you want to use the item details not the category details here and remember we’re getting ready to order some more rock fountains now let’s take the other ones out of the list we’re just going to go ahead and click the little trash can over on the right and I want to get two of these so that I have a total of four when I’m done again if it’s related to a particular customer you’ll want to plug that information in right here if you were ordering other things as well you can go ahead and put all of these in here you have a place to put a message to your vendor a memo and at the bottom some attachments once this is done you’re going to go ahead and send this over to your vendor I’m going to go ahead and say save and close and that’s how that works if you had the vendor’s email address you could have emailed this directly to them other than that maybe you call them on the phone and ordered it but you do have your PO in here now so that whenever you go to receive these items you have something to receive it against that’s how you actually create a purchase order the next step in the process is that your products actually come in and you’re going to go in and receive those products into your inventory let’s go ahead and head over to section five so I can show you how that works now that you’ve created a purchase order you can actually receive the items into your inventory The Logical process is that once you order the items from your vendor they’re going to come in the next week 10 days probably and you’re going to want to receive them into your inventory let’s go ahead and flip over to QuickBooks so I can show you how that process works let’s head back to our products and services for a moment I want to show you that if we go down and look at Rock Fountain we still just have two and that’s because all we’ve done at this point is order two more once we get through going through this receiving products into inventory feature then you’re going to notice that this number will go up to four all you have to do is head over to the navigation bar and click on new and we’re going to create a new bill the first thing I’d ask you is who is your vendor and this is where I’m going to pick Hicks Hardware and you’ll notice as soon as I do that that this little window pops up over on the right and this is letting me know that I have an open purchase order if you want to actually add the items on this purchase order to this bill just click add and if you look down here it’s added the rock fountains it’s added two of them and it’s got a rate amount and everything we talked about here because this is an actual bill from the vendor we want to make sure that the rate and the amount and all of that is correct if there happen to be a sale and that’s why we had ordered two of these we would change the rate and of course the amount would change in that case going back up to the top you’ll see that it pulled in our mailing address for Hicks Hardware we’re going to want to choose the terms that are on that bill we’re going to say net 30. here’s the bill date meaning the date that it was actually printed and the due date meaning the date it was actually due we’ll also want to plug in our bill number over here and that’s really all we need to do there’s a place for a memo down on the bottom left we can add attachments if we want and when we’re finished we’re going to save and close now let’s go see how many we have in inventory now and if we’re looking at Rock Fountain we have four of those and that’s one of the ways that things get into inventory through a purchase order now we’ll be looking at some other ways things get into inventory it could be you’ve written a check it could be that you’ve actually gone in to use your debit card but this is a way of creating an order and then receiving that order all right hey there welcome to QuickBooks desktop 2022 my name is Cindy mceuken and I’m going to be your instructor and help walk you through this course I wanted to take a few moments and just give you a quick introduction and also tell you a little bit about what to expect as you go through this series of videos I’ve actually been a QuickBooks instructor for over 20 years I’ve worked with all the different versions of QuickBooks I’ve actually taught large classes I work with individuals and anything in between what we’re going to do in this course is we’re going to start the very beginning I’m not going to assume you know anything I want to make sure that you have a really good foundation and you set up your QuickBooks file the correct way we’re going to start by going through the screen itself getting you familiar with what you’re looking at and then we’ll jump right in and start creating what we call the chart of accounts we’ll spend some time in there because that’s going to be the most important part of QuickBooks because all of your money will flow through one of these accounts we’re going to see we’ll look at the accounts payable section of QuickBooks we’re going to look at the accounts receivable section we’ll be looking at sales tax payroll and pretty much anything you would need to get your business set up the correct way in QuickBooks you might want to get out of pen and paper so that you can take notes feel free to go through these videos as many times as you need to and if you have any questions feel free to just shoot us an email and we’ll be more than glad to get back with you we want to make sure you’re well set up and on your way to getting your QuickBooks desktop file set up the correct way so you can have success in the future well let’s go ahead now and get started I’ve got a few things in this first module that I just want to talk to you about so we’ll talk next about what’s the difference in the desktop and the online version and then really in module two we’ll start jumping into how to get this company file set up and go in the correct way well let’s go ahead now and flip over to the next video and we will just talk about the desktop versus the online version of QuickBooks in two it makes both a desktop version of QuickBooks and an online version of QuickBooks and I wanted to take a moment and just talk to you about the differences in the two hey this is Cindy again and we’re actually in module one working in the second video the reason I wanted to actually show you the online version is because at some point you may want to take your data from your desktop version and upload it to the online version or vice versa maybe you’re currently using the online version and you prefer to go to the desktop version if that’s the case you’ll need to ask Intuit to actually grab your data file for you and then they’ll send it to you and you can upload it into your desktop version either way I just want you to be familiar with both so that you make an informed decision when you’re working with QuickBooks now a couple things to know as of the 2022 version of QuickBooks desktop it is now subscription based just like the online version one of the things that desktop users really liked was the fact that they didn’t have to go out and purchase the desktop version every single year now you have to if you do not update your subscription every year it will actually stop working now the online version has always been subscription based most people will actually pay for it by the month some people will pay for it by the year the advantage of working with the online version is that you have the ability as long as you have internet access to log in anywhere in the world that you happen to be and access your data now you can’t really do that with the desktop version unless you have some sort of software that will allow you into your actual computer let’s go ahead and take a peek at what each one of these looks like briefly so that you can see some of the differences visually here I went ahead and put these side by side so that we could get a good visual this side is the desktop version and this is the online version and the first thing you’ll notice is that they don’t really look alike it’s a little bit harder to work with the online version because it doesn’t really have the home screen set up the way the desktop version does on this home screen you’ve got different sections and you have a flow chart that really tells you what to do next where you don’t really have that over on the online version one thing that a lot of people just assume is that the online version allows you to download all your transactions from the bank and that is true but you can also do that in the desktop version as well a lot of times people will choose the online because they assume that’s the only one that will download their transactions and that’s not really the case the other thing is you’ll notice that you have a menu over here on the left just like you have here but again they’re set up differently so you really just have to learn your way around when you’re working with the online version of QuickBooks if you’re currently using the desktop and you’d like to try out the online they do have a free 30-day trial that you can go and try it out if you’d like if you go to the website go to intuit.com and you can look for the online version and they’ll have all the different subscriptions that they sell and you can look for the one that would fit your budget and that would have all the options that you want in that particular version if you don’t like it you can always come back to your desktop version so I just wanted to give you a quick feel for that and let you know that you have that option available if you want let’s go ahead now and flip over to the third video in this module and I’ll talk to you a little bit about some of the differences in the different versions of the desktop that into it has available for you hey there welcome to module two this is the module where we’re going to talk about getting started with QuickBooks hi this is Cindy I’m your instructor and we’re working in this first video now in module two where we’re going to talk about how to set up your company file each file you create in QuickBooks is called a company you can have as many Company files as you like and neither one talks to the other so if you have a need to keep them separate this is the perfect way to do it sometimes you might want to keep your business separate from your personal it could be if you’re a bookkeeper you have multiple customers you can have each one of those set up with their own company file let me go ahead and take you over to QuickBooks right now and I’ll show you how to get started setting up that company file when you first load QuickBooks you’re going to see a screen that looks like this in this area here if you’ve previously opened any company files you would see them listed so that you could double click and go to that particular file here’s where you would create a new company file you can also open an existing one that may not be on the list or if you’ve actually created a backup and you want to restore that backup you could do that here and there’s also some sample files there’s always a product base and a service based one here that you can work with what we’re going to do is we’re going to hop on over to the next video and talk a little bit about using What’s called the easy step interview we’ll create a new company and that will launch us right into that easy step interview before we can start using QuickBooks we have to go through and actually set up our company file and we’re going to do that by using something called the easy step interview hi this is Cindy I’m your instructor and we’re actually working in module two now the getting started module we’re on the second video using the easy step interview part one the easy step interview is going to ask you different questions and based on how you answer the questions it’s going to set up your company file for you let’s go ahead and flip over to QuickBooks and we’ll get started using the easy step interview to get started creating your new company file you’re just going to click right here and this will launch you into the easy step interview you’re going to get a screen like this that asks you who you’re creating your company file for for yourself or for someone else you’ll want to go ahead and choose myself let me just mention down here where the other options are you do have the ability if you happen to be using quick and now you can convert that data into QuickBooks or if you’ve got another accounting software you’d like to use you can convert it from here notice there’s also an advanced setup and that’s typically where I suggest you start with because even though it’s going to take you a little bit longer to get through it this is the easy step interview and it will ask you most of the questions you will need to get the company file set up correctly so take a little bit of extra time and fill this out this first screen asks a little bit of information about the company itself I’m going to go ahead and say this is ABC Plumbing this is just a fictitious company and notice as you’re going through here the only thing that you have to put in is the company name now I do suggest that if you’re going to send out correspondence to customers or vendors then you go ahead and fill out the rest of this information that way you don’t have to come back and do it later if you don’t have a different legal name you don’t have to put that in there there’s also a feel for the tax ID now feel free to type this in if you like but just so you’ll know you don’t really need this unless you’re going to be printing some 1099s or doing payroll or something where it needs that tax ID number the next thing you’ll want to do is put in the street address or if you have a PO box and you’d like to use that for mailing you can put that in as well I’m going to go ahead and make up a city and state here you’ll notice the country populates with us so if you happen to be in a different country you can go ahead and choose that from the list the next thing you’ll want to put in is the phone number now the reason that you do want to put the phone number here is because remember if you’re actually going to send correspondence out to customers or vendors you probably want that phone number on those invoices or anything you’re sending out there’s a place for a fax number as well and an email address and a website I’m going to click on next now this page asks you to select your industry you can see as you’re looking through the list of different Industries there’s pretty much an industry for everything but if you can’t figure out which one works best for you at the bottom of this list is a general product and a general service based business I’ll just go ahead for now and pick the general product based business and click next this next screen asks you how is your company organized you can see there are different choices here there is the sole proprietor option you might be an LLC an S corp but honestly if you have an accountant that does your taxes I’d probably pick other or none from the list and here’s why what’s going to happen is when you start setting up different accounts in the chart of accounts it’s going to have an extra field that will ask you which line in your text forms you’d like to put this to you’re not going to know because you’re not an accountant the reason that you want to use those is if you were doing your own taxes and you were using a software like TurboTax for example it would have to know where to pull each line onto that tax form but since you’re not doing your own taxes pick other or none and it won’t even ask you that question I’m going to click next and that would ask me to select the first month of my fiscal year now this will default to January unless you have a different fiscal year then I would go ahead and leave that on January and click next and now it’s asking us about setting up our administrator password now let’s take a few minutes and talk about this as soon as you open QuickBooks it will launch you directly into the last company file that you had open if you would like QuickBooks to ask for a username and password before it launches you into that company file then you’ll want to go ahead and set up that password right here for the administrator this is very highly suggested that you do this you do have the ability to also set up different passwords for different people who will be using QuickBooks and that way you can limit their access to certain areas and we’ll talk about that a little bit later but right now let’s go ahead and set up a password a really good password will have 10 to 12 characters it’s going to have capital letters It’s going to have numbers it’s going to have special characters but make sure it’s something that you’ll remember because if you lose your password it’s very hard to find it I’m going to go ahead and click on next and now it will say creating your company file you’ll want to go ahead and save this somewhere so that you know where to find it I’m going to go ahead and just stick this on my desktop real quick you’ll see it’s now creating my new company file for me you can actually see right back here that it has my company name and you can see over here the icon bar now we could actually go ahead and leave at this point but let’s go ahead and finish the easy step interview I’m going to click next and this section we’ll talk a little bit about what I have that I sell in my business so you can see it ask me do I sell Services only products only or both there’s no wrong answer here if you currently sell services but you’re thinking that later down the road you might want to sell products go ahead and turn them both on you’re actually just turning icons on or off on the screen when you choose these different options I’ll choose both and click next this question asks if I’d like to create estimates in QuickBooks construction is a prime example of an estimate if I want to have my kitchen remodeled I’m probably going to ask for a quote or an estimate for the job before I actually hire someone to do the work I’ll just go ahead and say Yes here this screen asks me about using statements in QuickBooks if you have customers that you invoice you may want to send statements at the end of the month those statements will actually be a summary of everything that happened that month with that customer it will show each invoice any payments they’ve made any credits and it’s a gentle reminder to your customer that they owe you money I’m going to go ahead and turn those on and now it asks me about progress invoicing now this question really goes with that estimate question because if you estimate jobs then you have the ability to turn those estimates into an invoice so that you can receive money from your customer you may not always want to invoice everything that’s on that estimate maybe you want to pull 50 percent maybe you want to pull certain items you have the ability to do that if you use progress invoicing I usually suggest if you are estimating jobs that you do want progress invoicing I’m going to click next and now it asks about managing the bills that I owe you know a lot of people actually just receive a bill and they throw that bill on their desk in a basket and then when it’s time to pay bills they’ll look through the bills and decide which ones to pay that’s certainly okay however if you want to really make good use of QuickBooks go ahead and enter all of the bills whether you receive them in the mail or if they’re just ones that are electronically withdrawn just enter all of those in QuickBooks as bills and that way you can track all of the bills that you owe you’ll be able to run reports to see who you owe if any of it’s over 90 days that sort of thing if not you won’t be able to run any reports on accounts payable I’m going to go ahead and say Yes here and click next and now it asks me if I’d like to track inventory now before I answer this question this video is getting a little bit long so why don’t we go ahead and look over at part two and we will continue talking about how to use the easy step interview hey there welcome back it’s Cindy again we started talking about how to use the easy step interview over in part one now let’s go ahead and finish that video this is part two of using the easy step interview now we’re going to talk a little bit about tracking inventory this screen asks if we’d like to track inventory in QuickBooks true inventory means that you sell physical
products and you need to know at any time how many you might have in the store room you might want to run reports to see how many of a particular product you’ve sold so you can order some more if you track inventory you will want to say yes to this question in QuickBooks let me also mention here that it could be that you don’t really track inventory you might sell physical products but you don’t need to track how many you have in the store room if that’s the situation you still want to say yes here because you probably use purchase orders anytime you use the purchase order system in QuickBooks you will want to have this option set to yes so that the purchase order options show up on your home screen I’m going to choose yes there and click next this screen is asking us about tracking time in QuickBooks now there are a couple different ways you can use this feature if you actually work on different projects for customers and you want to track the time that you spent working on that project then you’ll want to turn this option on you can also track the amount of time that your employees or your subcontractor spend working on a particular project or job if you’re wanting to track time just go ahead and say Yes here and then click next this question asks do you have employees now I want you to make sure that you don’t confuse employees with 1099 contractors because they’re totally different so this question can be very misleading if you tell it yes here then you’re telling QuickBooks that you do want to track payroll in QuickBooks we’ll talk about payroll in a later module because payroll is a subscription you’ll want to sign up for it’s not free the other thing we’ll talk about a little bit later is your 1099 contractors if you want to send 1099s there’s a certain way you have to set them up and they’re not set up in the employee section of QuickBooks if you just want to turn on the option for payroll you would say yes or you can leave it on no I’m going to leave it on now and click next now we’re getting ready to get into this last little section here this is just saying that we’re going to talk a little bit about using accounts and QuickBooks QuickBooks has to have a date to start tracking your finances you can either choose the beginning of your fiscal year or you can choose today’s date or Tuesday date of your choice I suggest that if you’re just purchasing QuickBooks for the first time and let’s just say it’s towards the end of the year you might want to go ahead and start with maybe the beginning of this month and just put in enough information to finish this year and this could practice for you and then next year you can have a full Year’s worth of information now if you really want to go back and put a full year in that’s certainly your prerogative to do and even if you put in a date whether you choose it or you choose the beginning of the fiscal year you can still enter something prior to that date it just needs a date to start with I’m just going to say the beginning of this fiscal year and click next now we’re almost at the end here it’s asking us to review our income and expense accounts now we’re going to talk more about this in a later module this is what we call your chart of accounts anything you do in QuickBooks runs through one of these now if you happen to be looking through here and you say you know I don’t use a particular one that’s here or maybe there’s one I do want to use let’s say I do want to use business licenses and permits you can go ahead and check those and turn them on here or you can wait until you get into the actual chart of accounts itself and then you’ll be able to add or delete ones you do or don’t want to use so I’m just going to go ahead and click next at this point and it’s going to say congratulations and you can now go to the button that says go to setup right here at the bottom if you get a screen that looks like this it’s asking you if you want to go ahead now and add the people you do business with those would be your customers or your vendors you can add your products and services you sell or your bank accounts it doesn’t hurt to add them here but we’re going to go through these in a later module so if you want to go ahead and click the X in the top right of that window to close it then that will be fine for now now you’re on what we call the home screen in QuickBooks well that’s going to wrap up part two of using the easy step interview let’s head on over now to video four and talk very quickly about the place where you go if you want to actually change the information about the company like the name the address the phone number that’s in a section called my company and we’re going to look at a quick overview of that welcome back to QuickBooks desktop 2022 my name is Cindy and we are actually walking through module 2 right now this is the fourth video and we’re going to talk a little bit in this video about a little option called my company when you actually set up your company file and you went through the easy step interview the very first screen asked you to go ahead and set up the information about your company you set up the name the legal name you set up the address the website the phone number things like that well where would you go if you needed to edit that information you would actually go into this option called my company and that’s where I want to take you right now let’s head on over to QuickBooks and I’ll show you where this option is and we’ll go ahead and make a few changes to that company information you set up when you went through the easy step interview one of the questions I get asked often is how do you go back to the easy step interview if someone’s asking me that question it means that they want to go back and make a change to something they originally set up most of those changes are going to be made under the preferences in QuickBooks now we’re going to look at those preferences in module 3 it’ll be the first and second video but if you want to make a change to the company address the company phone number any of that information you set up on the very first screen when you went through the easy step interview you have to do it this way if you go to your menu and click on company you’ll see an option that says my company here you’ll see the address information that you set up when you went through the easy step interview you’ll notice both of these will be the same unless you happen to have changed some information on the legal name if you want to edit any of this all you have to do is click on this little pencil where it says edit and now you can make any changes you want let’s say that you’d like to add your phone number right underneath your city state and zip all you have to do is type it in and anytime you actually work in QuickBooks and you want to actually pull in the address block now we’ll pull all of this instead of pulling these as two separate blocks we’ll talk more about that in a later module when we talk about customizing your invoices we’ll work with the layout designer and you’ll see what this comes into play I could also go down and add this information if I’d like notice if I want to change the legal information I’ll click over here and edit that information I can change the company identification that’s going to be the federal ID number if you wanted to go ahead and put that in there’s some information on reporting if you want to change your fiscal year and then also some payroll tax information here if you just want to put in a contact for the person who’s signing the payroll tax forms things like that I’m just going to go ahead and click OK here and it will always tell you that you didn’t update your legal address if you didn’t do that and you will have a chance to go back and do that but I’m just going to go ahead at this point and say no I don’t want to go back to the legal address because I’ve already decided that’s correct I’ll click no and now you’ll see that it’s actually added my phone number right here but notice it’s not over here and that’s because I told it I didn’t want to update the legal name and address now I want to point out a couple of other things on this screen that will be very helpful to you look over on the right hand side because sometimes you will have to have this information maybe you’re placing a phone call for some support here is the version of QuickBooks that you have there’s your license number and product number you can also see this has been activated and if you want to view the owner you could do that there’s also some apps that work with QuickBooks some of these are subscription-based services and you can see some of these down here if you wanted to use these you could actually click these options right here and go ahead and sign up with any of these you’d like one I want to mention is this payroll we’re going to talk about payroll in a later module but payroll is not free it is subscription based and these are other things that Intuit can actually sell you if you would like to have a merchant services account with into it you could do that by choosing this option you can order checks from them if you’d like by choosing this option and something to keep in mind is you don’t need to order checks from QuickBooks from Intuit you can order them from wherever you’d like but I just want to give you a quick overview of this my company option here I’m going to go ahead and close that and that will wrap up this video here let’s go ahead now and move over into the next video which is number five and that is where we’re going to talk about how to identify all the components of your home screen here in the QuickBooks environment hey there welcome back this is Cindy again we are working now in module two and we’re talking about getting started with QuickBooks this is video five identifying the components of the QuickBooks environment what I basically want to do is just go over the home screen with you so that you will know what types of options are there and where to go when you get started actually using QuickBooks let’s go ahead and flip over now and we’ll start talking about how to identify those different components of the QuickBooks environment this is what we call your home screen in QuickBooks when you open your company file it will automatically show you the home screen first if you happen to be somewhere else in QuickBooks and you don’t see this screen the easiest way to get back to it is you’ll notice on the left you have a home option right here that you can just click on and it will take you back to this screen now before we start working with this home screen I wanted to show you two quick things that you will want to do to make your home screen work a little bit easier for you you might have noticed there is an icon bar here on the left certainly okay to keep it that it’s a matter of personal preference but I’ll just show you another option that will free up some room on your screen for you if you go to your menu and you click on view you’ll see there’s an option that says top icon bar if you click on that notice now your icon bar is moved to the top up here the next thing you’ll want to do is you’ll want to go ahead and go back to view and click on the first option that says open Windows list and that will appear on the left hand side of your screen and just to tell you what this is every time you click one of these icons you’re going to open that window so if I clicked here for example I would open this window and this is where I would go to enter any bills I want to track in QuickBooks now you’ll notice I have two options over here if I don’t want to close this bills window I can click on home and go back to the home screen or back to enter bills and I’ll be back on the bill screen now if I close this bill screen just by going to the top right and clicking the X not the one at the very top that’ll close QuickBooks but the one right under it will close that window and now you can see it’s gone over here because that window is closed let’s take a few moments and see how this home screen is actually set up there’s actually five sections here this first section at the top where it says vendors this is your accounts payable section anything having to do with the people or businesses that you buy from those are called vendors you’re going to be able to enter the bills you receive from your vendors you’re going to be able to track inventory things like that in this section this next section here where it says customers this is your accounts receivable anything having to do with your customers these would be people that buy from you and you can see that sometimes you invoice customers you might want to receive payments from them send them a statement so this section here is all about your accounts receivable this third section at the bottom where it says employees this is your payroll at the top right you’ll see a section that says company these icons don’t really have anything to do directly with the customers or vendors but they have to do with the file itself and I want you to get really familiar with this one right here the chart of accounts this is your most important part of QuickBooks because everything will flow through there and we’re going to spend more time talking about that over in module three notice there’s also items and services those would be physical products that you might sell or Services you provide this is where you could set those up the last section I want to point out here is called banking think about things you would do at the bank you would make a deposit you could actually open your check register from here maybe print checks from here these are considered banking functions and you’ll find those in this section when you’re looking at your home screen you’ll notice there’s a flowchart and you want to always follow the flowchart from the beginning to the end for example with customers you may or may not estimate jobs in your business but let’s say that you do the next thing you would do is create an invoice then you would receive the money from the customer at some point and then you would actually record that money and put it in the bank so follow the flowchart from the beginning to the end for every one of these and you’ll have no problem with whatever you’re doing now I do want to point out a couple things on the very right hand side of your screen first of all where it says account balances once you start setting up your accounts your checking accounts Savings credit cards all of those accounts in the chart of accounts you will see them here and you’ll also see the balance and a quick way to go to one of those accounts is to click on it from here and open it up this section here really has to do more with things that Intuit can sell you for example they have merchant services accounts available if you accept credit cards if you want to order checks and supplies from them you can if you don’t want to see this section here just hit this little arrow and it will kind of hide that section for you and then notice this backup status one of the things that happens with the QuickBooks desktop version is you will need to back it up on a regular basis and one of the ways to do that is to choose this backup now option another option you have is for a fee into it we’ll back it up for you and you can sign up with that right here online by going to this link here but again if you don’t want to see this just hit the little arrow and that will hide it so you don’t have to keep looking at it that’s a quick overview of the home screen itself you’ll want to get very very familiar with it let’s go ahead now and look at the last video in this section I want to talk to you before we leave about how to convert your QuickBooks desktop data to the online version if you ever decide that you want to actually move all of your information to the cloud so you can access it from anywhere in the world hey welcome back it’s Cindy again we are wrapping up module two the getting started module we’re actually on video number six now I want to show you how to convert your QuickBooks desktop data to the online version you might decide at some point that you want to try the online version because that way you could have access to your data wherever you happen to be as long as you have internet access you can actually convert that data now you can’t go the other way you can’t have the online version and then download it to QuickBooks desktop in two it has to do that for you but it’s pretty easy to go the other way so let’s flip over to QuickBooks and I’ll show you how to convert that desktop data to the online version the first thing I suggest you do is back up your company file if you want to jump ahead go down and look at module 17 it’s video number 10 where I show you how to backup your company file once you’ve done that go ahead and click on file from your menu come down to utilities and then you’ll see an option that says copy company file for QuickBooks Online QuickBooks does have to close all the windows before it exports your company file just go ahead and choose OK here and then you can save your file anywhere you like I’m going to save mine to this QuickBooks desktop data file folder I set up notice it’s a DOT OE file go ahead and click on Save and now it’s actually exporting your data and you can see that didn’t take very long it says you’ve successfully exported your company file all you have to do at this point is Click ok the next thing you need to do is go online and get a subscription for your QuickBooks Online there will be an option in there where you can actually upload your data file that you just exported and that’s all you have to do to convert your QuickBooks desktop data to the online version well that’s going to wrap up module 2 getting started now we’re going to go into module 3 and talk a little bit about customizing the QuickBooks environment foreign we’ve made it all the way down to module 3 now and we’re going to talk in this module about different ways to customize the QuickBooks environment I wanted to start off in this first video which is the preferences and talk to you a little bit about the options that you can change that make working with QuickBooks a little bit easier a lot of these options we’re going to talk about in this preferences section are going to be options that you told it in the easy step interview you did or did not want to turn on or off there are two parts to this so make sure you watch both parts so that you get a full idea of all the preferences that are available for you to work with let’s go ahead and start now with preferences part one when you first set up your company file you went through the easy step interview in that easy step interview it asked you a series of questions and based on how you answer those questions it turned icons on or off on your home screen for example if you told it that you do not estimate jobs you wouldn’t have this estimates icon here you can turn most of these on or off in the preferences along with some other things you’re going to see that will make QuickBooks a lot easier for you to use let’s head on over to the preferences we’re going to click on edit from the menu and come down to preferences you’ll notice there are several options on the left that you can click on each of these will have a tab that says my preferences or company preferences when you click on them let’s start at the top with accounting and we’ll work our way down you’ll notice under accounting there are no options under my preferences I’ll go ahead and click on company preferences and there are a few here that you’ll want to know about let’s take a peek at this first one use account numbers this has to do with using general ledger numbers in your chart of accounts I’m going to cancel this for a moment and just go over to the chart of accounts right here just to show you what it currently looks like this is what we call your chart of accounts it’s the most important part of QuickBooks we’re going to spend more time talking about this in videos four five and six in this module but for now what I want you to notice is that there are different types of accounts and if you have a type that’s the same like these fixed assets there are two of these then you’ll notice the names of these two are in alphabetical order Once you turn on the general ledger numbers they’re going to be in numerical order I’m going to head back to edit and back to preferences under company preferences I’m going to check the box next to use account numbers and click ok and now you’ll see next to each of these you have general ledger numbers you can edit these numbers but for now you’ll see the generic ones that QuickBooks decided to use notice they’re in numerical order based on the type I’m going to head back to edit and head back to preferences same place back under accounting I’m going back to the company preferences here’s another one that you may want to use not every type of business will use this class feature but if you need it it’s a really great option here’s some examples of how this would work let’s say that your business has three locations and you would like to track your reports based on location you could have a class list set up that would list each of the locations and each time you create a new transaction you can choose the location that that transaction goes to and that’s a great way to run a report on the whole company or if you want to use it to run a report just on those different locations you can do that as well if you start entering transactions that are 90 days in the past as far as the data is concerned or in the future you will see that it will pop up and warn you and if you don’t want it to do that maybe you’re entering a lot of things that are over 90 days old then you can just come in and uncheck these I did also want to mention this date through which the books are closed in real life accounting you close the books at the end of every month and you close the books at the end of the year if you had closed the books through the end of the month and you see a mistake in a prior closed period you would make an offsetting entry in the current period to adjust for that QuickBooks will not automatically close your books it’s not going to warn you it’s not going to say anything if you want to close the books you have to come here you would set a date and a password for example this might say December the 31st of 2021 and then of course you would have a password Here what would happen is if someone went to make a change in that closed period it would pop up and say you’ve closed the books through such and such date do you still want to make that change and if you knew the password you could do that let’s jump down on the left to the general option and I’m going to click on the my preferences tab this very first one I always suggest that you turn on it says pressing enter to move between the fields if you do not have this on what will happen is you will be working in a form let’s say you’re in an invoice for example and you’re thinking that by hitting the enter key you’re going to move to the next field what will actually happen is you will save and close and your screen will disappear and you’ll wonder what happened if you turn this on you can use the enter key or the Tab Key to move between your fields there are several other options you might want to just take a peek at right up here I do want to mention this one here automatically recall last transaction for this name this is a good one because it will save you some work and keep your accounting consistent let’s say that you had previously filled out a check for your electric company what would happen is the next time you went to write a check and you put in that vendor name it will automatically fill all the information from the last time you use that vendor name and all you would really need to do is change the amount of money and save it save you a lot of time here’s another one that you probably want to turn on use today’s date as default if you don’t turn this on then whatever the last date you entered on one of your transactions that’s going to use the same date when you go to the next transaction let’s look now at items and inventory there are no options under my preferences I’ll click on the company preferences tab if you remember one of the questions in the easy step interview asked if you actually track inventory if you had said no none of these options would be checked and they wouldn’t show up on your home screen here by checking all of these you’re going to see options for purchase orders and you’ll also be able to enter invoices and you’ll be able to track inventory as well the next one down says jobs and estimates if you happen to work with different jobs in your business construction being a prime example then you may have different terminology for these you can go in and change that terminology if you want and here’s the question about estimates do you create estimates yes or no and over here is the progress invoicing question if you create estimates you probably do want progress invoicing the next one down I want to mention is payments and you’ll notice sometimes when you make a change that it will pop up and ask you if you want to save your changes I’m going to say yes here and sometimes it will have to close all the windows to make this change I’ll just click ok and now we’re on the payments option one of the things QuickBooks will do is when you receive a payment for a customer and you want to enter that payment you’re going to see in that payment window a list of invoices you’ll see the oldest on down and QuickBooks will automatically apply the payments to the oldest ones you may not want it to do that you may want to manually apply the payments to those invoices the other thing it will do is it will automatically put that payment in an account in your chart of accounts called undeposited funds if you don’t want to do that then you can uncheck that here and we’ll talk about that a little bit later you’ll see here that your customers can pay you online you can actually send them an invoice you can send it through email and it will have a button where the customer can click to pay you automatically their credit card or bank transfer and you can actually set that up with Intuit also down here where it says payment reminders if you wanted to send reminders to your customers that they have payments that are due you can do that and it will prompt you at a certain time of day and also if you want to prompt your daily or weekly you can set that up as well right here now let’s go over to payroll and employees if you’re going to be using payroll through into it you would have to actually set that up with Intuit it is not free it is subscription based but if you’re going to use that here’s a couple of preferences if you’re going to use the full payroll option you’ll click here and that will turn on some options on your home screen so that you can go ahead and set up some of your payroll if not you can leave it on no payroll you also have some options over here for pay stubs for workers comp and sick and vacation time down here at the bottom you can display your employee list by first name last name and you’ll see there’s some other options here that you may want to just look at if you decide you’re going to run your payroll through QuickBooks the next option I want to look at over on the left are your reminders notice I made a change in the payroll section so it asked me if I want to save those changes I will say yes here and then you’ll see some options pop up about reminders this is a list of different items that QuickBooks can remind you of reminders do not show up automatically where they show up is when you first open the company file if you’ve told QuickBooks to remind you you will see a window that pops up that will have those reminders in that window once you close it again you don’t see that until the next time you open QuickBooks you can see here that there are checks to print there’s overdue invoices options to be reminded about inventory reorder money to deposit you can see the options there you can have QuickBooks show you in that window a summary of all the checks to print for example you might want an individual list of each of the checks to print or you can say don’t remind me at all if you have told it to remind you of some of these options then you can go next each one of these and tell it how many days before or after that you want it to remind you of that option so you just go through here and set all of your choices for reminders go ahead and stop the video right here I want to go ahead and look at part two and we’ll continue talking about the remainder of these preferences hey there welcome back to QuickBooks desktop 2022 my name is Cindy and we are working through module 3 where we’ve been looking at different ways to customize the QuickBooks environment we just finished looking at the very first video which is part one of the preferences I want to go ahead and continue that now and just take up where we left off after part one if you got out of the preferences window you can go back to it by clicking on edit from the menu and coming down to preferences let’s go ahead and start where we left off after part one we’re going to actually click on the left where it says reports and graphs there’s one thing in particular that I really want to point out here and that’s under the company preferences tab when you run reports in QuickBooks they’re automatically run on an accrual basis you can choose to run them on a cash basis now we’ll talk more about reports in module 11 but just to tell you what this means when a report is run on a cruel basis that means when you’re looking at your income that number would include any invoices you created that have not yet been paid also as far as expenses go if you’ve entered any bills that you haven’t yet paid they would show up in this report as well as expenses versus if you use the cash option it’s only going to show invoices you’ve actually received money for that you’ve been paid for and it’s also only going to show expenses that you actually spent the money for already and that’s going to be the difference you’ll see when you’re on a report you can also change it as a one-time thing there but just know that your reports are automatically run on an accrual basis you can see there are other options here as well that you might want to look at as far as reports are concerned let’s go down to sales and customers on the left and talk about a few things here I’m going to the my preferences tab one thing I want to point out is there is an option to prompt for time slash cost to add there’s an option in QuickBooks that we’re going to talk about in a later module that will let you take any expenses you’ve accumulated that might go towards a job you’re working on and you can actually pull those expenses into an invoice and that way you can get reimbursed from your customer now if you want QuickBooks to prompt you for those you can choose this option here to do that under the company preferences tab there are a few things that you might want to look at for example if you create sales forms which we’ll talk about in a later module you might have a particular shipping method that you like to use automatically you can choose options like that let’s go look at sales tax if your company collects sales tax from your customers you’ll want to set up those sales tax items now you can do that here but we’re going to talk later when we look at the items list at how to set them up there because you’ll have several different ones you’ll want to set up and you need to make sure you do it the correct way but here you can tell QuickBooks that you do charge sales tax or you don’t and then you can also choose your most common sales tax if you’ve already set it up if you haven’t set it up yet then you’re going to need to wait until you get it set up before you can choose your most common sales tax here this little section here what will happen is if you had items that are taxable and some that are non-taxable you’re going to see that you can have this code right here that says tax or you can create a new one and the same thing for non-taxable I usually just leave those but some people prefer to have different wording for those and you can set that up also items that are taxable will have a t all the way to the right of that line item when we get into the invoicing section you’ll see more about how that works let’s go down on the left and look real quick at send forms you have the ability in QuickBooks to send a form and an example of that would be an invoice you create an invoice and instead of printing it out and mailing it you can actually send it right from QuickBooks if you do that there’s going to be a default template that goes with that you can see they’ve got one already set up here called basic invoice I’ll just edit to show you what that looks like you can see here it would have the customer’s name it’s going to have the invoice number thank you for your business you can see this if you want to edit this you can do this right here so that it pulls the new template I’m going to go ahead and cancel that you can also add a new one if you want in this particular window you’ll see it’s not just for invoices there are other forms as well there’s credit memos there are pay stubs and if you want to edit any of those or create a new one you can do it right from here I’m going to scroll down a little bit on the left here and we see a couple more I want to look at spelling if you’ve made a change to your send forms preferences you’ll want to go ahead and say Yes here I didn’t make any changes but I’ll go ahead and say Yes anyway now under spelling here on the left I’m going back to the my preferences tab you’ll see that it will always check your spelling before it prints or sends any forms it’s a very good idea to spell check any forms that you sent out so that you look professional but if you don’t want that you can uncheck that there are also some options down here for 1099s you’ll want to click on the company preferences tab here’s where it just asks you do you file 1099 forms yes or no and then one last thing I’ll mention on the left under time and expenses you have an option in QuickBooks to track your time now there are a couple of different ways that can be used it could be if you’re in a business where you invoice your customers based on the time you spend working on their projects then you can turn on a timer in QuickBooks and have it track that time for you and then pull it into an invoice it could be that you’re just trying to track the time that your subcontractors worked on a job or your employees so you could turn that option on here if it’s not on and also look at the first day of your work week it’s currently set to Monday but you can choose Sunday through Saturday that’s really the most important options that I think you’re going to work with here in QuickBooks you might want to take time and look through the other ones just go through it anytime and go ahead and make these changes and once you’ve made those go ahead and click OK and now you’ve finished the preferences now that we’ve looked at all of the preferences in QuickBooks let’s go ahead and move over to video number three and talk about how to work with different users in QuickBooks hey there welcome back it is Cindy again we are working in QuickBooks desktop for version 2022. this is video three of module three I want to talk to you a little bit in this video about how to work with the users option in QuickBooks when you open QuickBooks if you’d like to have that user type in a username and password you would need to set up those users in order to be able to do that this is not something you have to do in QuickBooks but it is very highly recommended setting up users will allow you to set up different permissions for different people who use QuickBooks you can actually set it up so they can access certain areas and maybe not access others let’s go ahead and flip over to QuickBooks and I’ll show you how to set up those users you do not have to set up users in QuickBooks but it’s very highly suggested when you set up users that means that when you double click to open your company file each time it will ask whoever’s using it to put in their username and their password in order to allow them access to your company file you do have to be the administrator in order to actually work with the users make sure that administrator is logged in what you’ll want to do is go to the menu and click on company and then you’ll see an option that says set up users and passwords and in the sub menu choose setup users if you did have a password set for the administrator maybe you set it up when you set up your company file through the easy step wizard it would ask you to go ahead and log in and then you just click OK and now you’ll see the user list here you can see the admin is logged in you can add up to five users in QuickBooks each one will have a different login as the administrator you’ll want to be the one to set up these users so that you can write down their username and password and if that user leaves the company go ahead and delete them over here or if you want to edit the user that was there previously you could do that but make sure you have the current user set up let’s say that we’ve hired a new employee and that employee is going to come in a couple days a week and just pay the bills and we just want to give them access to those areas I’m going to click on add user and we’ll put in the user’s name let’s say the name is Carol and we’ll set up a password for Carol you’ll want to make sure you type it in twice and then you’ll want to click next the first thing QuickBooks ask is what do you want this user to have access to notice you can give Carol access to all areas of QuickBooks selected areas which we’re going to choose and I also want to point out this last option for the external accountant if you have an accountant that you want to have access to your QuickBooks file you can give them their own username and password they won’t have access to what we call sensitive customer data credit card numbers things like that I’m going to choose selected areas and click next the first area it asks about is sales and accounts receivable now this has to do with invoicing our customers I’m going to leave that on no access and click next this next question asks about purchases and accounts payable this is what I hired Carol to do I’m going to give her full access notice I could give her selected access where she can only do these three items that you see here but I’ll go ahead and give her full access to accounts payable the next option is checking and credit cards I don’t want her to go in and make deposits and enter credit card charges things like that so I’ll just say no access this screen asks about inventory I’m not going to give her access to inventory not going to give her access to time tracking or payroll this option asks about sensitive accounting activities those are things like do you want Carol to be able to make journal entries in QuickBooks do you want her to have access to online banking functions again I’m going to say no and sensitive financial reporting those are the reports that go with that previous screen now it asks me do I want Carol to have the option to change or delete transactions I usually leave this where it defaults the first option asks do I want Carol to have the ability to change or delete transactions in the area she has access to of course what if she enters a bill twice and needs to delete one of them this option says do you want Carol to be able to change or delete transactions recorded before the closing date if you remember in the preferences there was an option to close the books if you use that function you may not want Carol to go in and make changes in those closed periods this last option just gives me a summary of all of the options I chose I’m going to hit finish and now you’re going to see that our new user Carol has appeared on this list if I ever want to edit her I can come over to edit or delete her I’m going to close this window I want to show you how this option actually works each time you are finished using QuickBooks you want to go ahead and log out you want to click on file and the go down to where it says close company and log off if you do not do this you’re still logged in and the next person that comes in will be logged in as you sometimes QuickBooks will ask you if you want to back up your data we’ll talk about that a little bit later I’ll just say no here and that’s actually going to take me back to this screen that you’re going to be very familiar with where you’re actually able to open an existing file our new user is coming in to work the new user is going to double click on the company file ABC Plumbing in this case and it’s going to bring up a window where Carol has to put in her name and her password notice it has the last username that was logged in I’m going to put in Carol and I’m going to go down and put in her password now Carol has access to this company file you might notice that the icon bar is back on the left hand side again any preferences that are changed are per user now I want to show you how QuickBooks will allow Carol to access areas she should be in and not allow her into other areas we gave Carol permission to work with bills so she will definitely be able to enter bills like this okay let me close that I did not give her access to work with accounts receivable that’s this area down here I’m going to click on create invoices and notice gives me a warning and says that you need sales and accounts receivable permission to perform this action I’m going to go ahead and click OK and that’s how the users work in QuickBooks let me go ahead and log off here I’m going to close company log off and I’ll log back in as the admin again and go ahead and put in the admins password I had set up see how it says Carol I’m going to put in admin and I’ll put in that password again and go ahead and click OK and now I will be back in QuickBooks and I’ll be able to access everything because I am the admin that’s how you’re going to set up users in QuickBooks remember you have to be logged in as the administrator in order to make any changes to the users let’s go ahead now and wrap up this video we’re still in module three I want to go down now to video number four we’re going to talk about working with the chart of accounts in the next few videos video number four is called what is the chart of accounts hey there welcome back to QuickBooks desktop 2022 my name is Cindy and we are walking through module 3 customizing the QuickBooks environment we’re all the way down now to video number four where I want to talk to you about the chart of accounts the chart of accounts is the most important part of QuickBook it’s very important that it’s set up correctly if it’s not then you’re going to run reports and the data will not be accurate and you’ll wonder why let’s go ahead and flip over to QuickBooks and we’ll start talking about how that chart of accounts works the easiest way to access the chart of accounts is from the home screen you’ll see an icon right here that says chart of accounts this is a listing of all the different accounts that are in this company file this list was created based on how you answer the questions when you set up the company file you might look at a different company file that has some of the same accounts but it might have some different accounts and both are correct initially you’ll want to go through this list and add any accounts that you know you’re going to want to use you will want to delete ones you know you’ll never use and if you need to edit the name of some of these you can do that as well it’s very important when you set up this list that you’ve got the types set up correctly over in this column and we’re going to go through each one of the types before we do that I want to point out that currently the list is set up by type and the accounts are set up alphabetically so there are two fixed asset accounts you can see we’ve got accumulated depreciation and furniture and Equipment there you’ll notice also that the general ledger numbers are not on automatically and this is a preference you do not have to use them but if you want to here’s how you turn them on if you go up to edit on the menu come down to preferences make sure on the left you’re clicked on accounting and choose the company preferences tab in here is a check box that says use account numbers you’ll want to make sure that’s checked and then just click OK and now you’ll see you have general ledger numbers over on the left hand side these can be edited if you want to use them but you want a different number you could just edit these just right click and choose this edit option and that will let you go in and edit any of the information that you have set up as far as this account is concerned I want to go through the different types with you now just to make sure you’ve got those set up correctly the first thing you’ll notice is we don’t have any bank accounts here they’re usually set up as the first type here if I wanted to actually enter a debit card transaction I couldn’t do it because I don’t have a bank account set up yet let’s go ahead and add a bank account you can just right click anywhere in this list to access this new option the first thing QuickBooks will ask you is what type of account is this this is a bank account and notice it gives you a couple of examples of what a bank account would be bank accounts are any checking accounts that the company has any savings accounts any money market accounts if you have PayPal you would want to set that up as a bank account if you have a lot of cash expenditures for your business you would want to set one up to have a place to put those those are examples of bank accounts I’m going to click continue at the bottom and the first thing you’ll notice is that if I happen to have chosen the wrong bank account on the previous screen I can go here and actually edit that now the next thing you’ll notice is a place to put the general ledger number I’m just going to add one here and then you put in the name of the account now you can name your accounts anything you like I’m going to call this one checking often I’ll see them referred to as operating account or payroll account you might have your bank name in there as long as you know that it’s a checking account then you’re good this is not a sub account of another one we’ll talk about that in a little while you don’t really need a description unless you want to put something in there someone would have to be on this exact screen to see the description the bank account number and the routing number and I wouldn’t put the bank account number or the routing number in here QuickBooks does not needed what you would need to do though is enter the opening balance as of the start date of your company file what was the balance in this checking account I’m going to say that I had fifteen hundred dollars and I’m going to put the statement ending date as January the 1st of 2022 in this case there’s also an option here that says remind me to order checks when I reach a certain check number it will just pop up there and let you know it’s time to order checks and ask you if you’d like to order them from into it I’m going to hit save and close and now you’re going to see that we have a bank account set up called checking if you get this message they’re asking you if you want to set up your bank feeds we’ll talk about that in a later module for now I’m just going to say no and it will close that window you’ll notice now that you have a bank account and you have fifteen hundred dollars in that account every transaction has a debit and a credit the good thing for you is you don’t have to know the flip side of the transaction because QuickBooks did that for you notice there’s an account here called opening balance equity and it now has fifteen hundred dollars that’s the flip side of your transaction let’s go ahead and set up another one I’m going to right click and choose new I’m going to make this a bank account again this will be a savings account this time I’ve got bank account here I’m going to say savings and I’ll go ahead and open that with a five thousand dollar balance as uh the first of 2022. you can also click this calendar if you want to pick from this list I’m going to click ok and then saving clothes and now you’ll notice that I have five thousand dollars back here in a savings account now notice something that happened here you’ll notice that my checking account had a general ledger number but my savings account did not I want to edit that I’ll just right click on savings and go ahead and edit that account notice it takes me right back to the screen and I’ll go ahead and put in 11 000 and go ahead and save and close and now you’ll see that I’ve got my checking and my savings and they’re both bank accounts with the balance in each notice that the opening balance Equity account now has sixty five hundred dollars if you had a loan where you owe the money then this would be a negative number possibly and don’t freak out when you see that because it’s an accurate picture of your books the next type of account I want to mention are your asset accounts right here an asset is something that your company owns that makes it more valuable you might have furniture desk lamps you might have inventory in the back those assets can fall into one of two categories you can have fixed assets like you see here for furniture and fixtures or you can have what QuickBooks calls other current other current assets are assets that you have right now that make the company more valuable but your goal is to sell those and get them out the door they’re more liquid that’s an other current asset this is the one place where your accountant is going to be very helpful because you’re not really going to know what numbers to plug into your asset accounts when you set up your asset accounts you want to have maybe seven to ten you don’t want to have a ton of asset accounts and they’re going to be more generic you’re going to have asset accounts like furniture and fixtures that you see here you’re going to have one that might be called Vehicles you might have one that’s called equipment those are just big buckets that you’re going to be able to plug those numbers that relate to assets into and this is where your accountant will become very helpful because he or she will help you figure out which accounts to set up and which numbers to plug into those accounts the next one I want to point out here is one that says accounts payable accounts payable is an account where all of the bills you’ve entered will show up if they’re not paid they’ll show up in the accounts payable balance you see right over here once you’ve entered a bill and you’ve paid that bill it will not be part of your balance anymore it’s not considered accounts payable you’ll also have one called accounts receivable that will show up down here once you create your first invoice invoices that have not been paid will show up in the balance of the accounts receivable account once they’ve been paid they will not show up in that balance anymore and we’ll see some of those as we move into one of our sample files in a later module the next thing I want to point out are your liabilities a liability is something that the business owes like a loan for example each loan or liability should be set up separately in accounting you have short-term liabilities and long-term liabilities a short-term liability is something you’re going to pay off in 12 13 months and a long-term liability is something that you’re going to pay off long term maybe five years down the road let me show you how to set up a loan I’m going to right click and choose new you’ll notice that QuickBooks has the loan option here and this is a short-term liability if you’re looking for the long-term liability option they’ve got it listed here under other account types I’ll just choose long-term liability and click continue the first thing I want to do is make sure I have the name of my account set up and again you can name these anything you want I’m just going to say car loan it’s not a sub-account of another if I want a description I could add one maybe the make and model of the car if I want to add the account number I could but QuickBooks doesn’t need it I do need an opening balance however as at the start date of my company file how much did I owe on that loan let’s just say it was twelve thousand dollars and that would be as of the first of this year and I’m going to click OK and then save and close now you’ll see that I’ve got my long-term liability my car loan and I owe 12 000 on that loan now you’ll notice again I don’t have a general ledger number so I’m just going to edit to that I’m going to right click and choose edit and put in a general ledger number now I can click save and close and you’ll see there it is and again I owe twelve thousand dollars on that loan now something super important to know when you make a payment on the vehicle always always always the principal amount goes back to this account you should not set up a car loan as an expense in this list it’s not an expense to the business it is a liability you’ll notice also that the opening balance Equity now has a negative number like I mentioned earlier that’s because you owe more than the actual equity in the business right now that’s an actual accurate picture of what your books look like you can’t change that you want to go through and set up each loan separately so that you can track the balance you owe at any given time let’s go over to video number five working with the chart of accounts part two hey there welcome back it’s Cindy again we’re still working in QuickBooks we’re in desktop 2022. we’re going to go ahead and finish talking about the chart of accounts this is video number five in module three where we’re customizing the QuickBooks environment we’re back in the chart of accounts here when we left off in part one we had just set up a long-term liability we had set up a car payment remember a long-term liability is something you owe and you’re going to pay on it long term the other type of liability is a short-term or other current as QuickBooks calls them and you’ll see an example of one right here sales tax payable when you collect sales tax you are actually going to have to forward that money to the appropriate entity typically that’s done once a month it could be more but it’s on a short-term basis and that’s why those are set up as other current liabilities if you do collect sales tax you won’t have to set this account up because QuickBooks will set it up for you automatically and the balance that you see here will be the balance that is accumulated from all the invoices you’ve created and you have it forwarded those sales tax payments yet let’s talk about Equity accounts you’ll see there are a few here already set up here’s your opening balance Equity we’ve mentioned a few times but a really popular one that you’ll want to think about is owner equity think about the word Equity meaning equal if you own the company and you decide to take one hundred dollars out that would be an owner draw or owner Equity as it’s called if you decide to put that same one hundred dollars into the business that’s called an owner contribution if you’re not Incorporated the way you would pay yourself as a small business owner is by taking draws once you incorporate yourself you want to think about setting up actual payroll where you’re deducting taxes but I want to go ahead and set one up for you just to show you how you would set up an equity account and also this will show you how to set up sub-accounts we’re going to set up one for the owner draws and one for the owner contributions the first thing you want to do is right click and choose new and you’ll want to set up an equity account for the main account which we’re going to call owner all you have to do is put in the account name you really don’t need any of this other information right now there’s probably not going to be an opening balance instead of me saving and closing and then having to create another one I’m going to choose save a new you can see this took me to a blank screen it already has Equity filled in up here now what I’m going to do is create an account for owner draws I’m just going to call this one draws but notice it will be a sub-account of in this case owner and I’m going to save a new and create one more I’m going to create the contributions account remember this is when you put money into the business as a small business owner and this will be a sub account again of owner now I’m going to save and close and you can see all three of these are right here and you’ll notice how contributions and draws look like they’re indented underneath owner that’s because they’re sub-accounts QuickBooks will let you have as many levels as you need typically if you need more than three you’re going to get yourself confused so stay stay with two or three and you’ll be fine you’ll sometimes see other terminology for these sometimes you will see the contributions referred to as shareholder equity there’s many different terms that you might see for that so just set that up however you’d like to see it on reports the next type I want to talk to you about are your income accounts when you actually make a sale in your business that’s considered income you can have just one income account if you like or you can have multiple the next one I want to talk about is a cost of goods sold type anytime that you have to spend money to buy product or buy a service to make a product or service for your business that’s considered a cost of goods sold some examples would be if you buy a lot of materials for your job you might have one called job materials set up if you use subcontractors you might have one set up for subcontractors let’s set up a couple of these so you can see how this works I’m going to right click and choose new you’re going to have to go to where it says other account types and drop the list down and from here I’m going to choose cost of goods sold then I’m going to hit continue and I’m just going to call this one job materials and this would be any time that you have to buy any type of material at all to create that product or service for your business I’m going to hit save and close and you can see now it says job materials if I wanted to go back and add a general ledger number I could do that I could just right click and edit and I’m going to save and close and now you can see it has a general ledger number let’s talk a little bit about setting up one for subcontractors if you have a lot of subcontractors you deal with go ahead and set up the main account called subcontractors and then the sub-accounts can be the different types if you want to break it down that way I’m going to go ahead and right click here I’m going to go back to the other account types and choose cost of goods sold and hit continue I’ll call this one subcontractors and then I’ll go ahead and click save and close and you can see it’s on the list here now let me go ahead and edit that one and give it a general ledger number and then we’ll add some sub-accounts below that now let’s go ahead and add a couple of sub-accounts I’m going to right click and choose new I’m going to choose cost of goods sold I want to call this first one HVAC and we’re going to say it’s a sub-account of and in this case it’s going to be subcontractors now I’m going to hit save and close and you can see how it shows up underneath subcontractors I don’t have a general ledger number again so I’m going to right click and add one here and then I’m going to save and close and you can see that it’s indented underneath subcontractors indicating that it is a sub-account the next type you’re going to see are your expenses down here at the bottom and you can see there are quite a few expenses here I’m going to go ahead and stop the video and let’s go ahead and move over to part three and we will continue setting up your chart of accounts hey it’s Cindy again welcome back to QuickBooks desktop 2022 we’ve been working in module 3 where we’re talking about customizing the QuickBooks environment this is going to be part three of working with the chart of accounts you want to make sure you watch part one and two and then you can go on and watch part three to make sure you have a full understanding of how to set up this entire chart of accounts let’s go ahead and flip over to QuickBooks and we’ll keep going with the chart of accounts we’re back in the chart of accounts now and I want to take a look at your expense accounts here you’re going to add quite a few expense accounts to this list you’ll probably also add quite a few sub-accounts let’s just look at a few of these just so you get an idea of what types of accounts are here and which ones you might want to add the first one you’ll see here is advertising and promotion this is typically where you’re going to add any advertising that you do whether it’s social media advertising whether you do print maybe you do some TV advertising and if you want to have sub accounts below to break that out you could do that I want to point out automobile expense right now you could dump your gas in here you might actually add any repairs and maintenance to your vehicles but if you wanted to run a report on gas you wouldn’t be able to do that because you have it all in one account let me just add a couple of sub-accounts here just again to refresh your memory on how to do this I’m going to right click on automobile expense and I’m going to add a new account when you add a sub account it has to be the same type as the main account so this will be an expense I’ll hit continue and I’ll just call this one gas you want to make sure that it is a sub account of in this case automobile expense if you want to add your general ledger number make sure you do that here and then go ahead and save and close and now you’ll see gas is a sub-account under automobile expense next you’ll see Bank service charges typically this is where you’re going to put your 14 a month to have the account you’re going to put NSF fees maybe you wire some money you have a fee for that you might
also put your PayPal charges in here looking down this list you’ve got your business licenses the permits charitable contributions computer and internet expense this is where you’re going to put your monthly cable bill for the internet or if you have to have the computer fixed you might put that expense here let’s say that you don’t use Continuum education all you have to do is right click on that account and just delete it if you’ve used this account before it will not let you delete it and it will give you a message telling you that if you see this one that says are you sure you want to delete that means you’ve never used it and you can click OK and go on here’s Insurance expense some people put their automobile insurance under this one some people put it back under automobile expense it’s not wrong either way it’s just how would you like to see it when you run a report looking down this list you’ll see interest expense there are two that you’ll want to add underneath this one you’ll want to add loan interest and credit card finance charges let me just add those two so that you can see these here I’ll just right click and new this will be an expense I’ll hit continue and the first one I’ll add is finance charges and this is going to be finance charges related to credit cards typically I’ll go ahead and make that a sub-account of interest expense and I’m going to add the other one here so I’ll say save a new and this one here will say loan interest any loan interest will go to this account now I’m going to hit save and close and you’ll see I’ve added those there and you can go back and add a general ledger number if you want I want to talk to you next about payroll expenses quite often I will see that businesses actually Outsource their payroll usually when that happens you’re going to want to add three accounts as sub-accounts underneath payroll expenses you’re going to add one for the admin fee you’re going to add one for the total of the net checks and another for the total of the net taxes you’ll see Postage and delivery and then professional fees typically under professional fees you’ll see one for the accountant and you’ll see another sub-account for attorneys fees looking down this list I want to point out that there is utilities here and telephone expenses right above it here if you wanted to move telephone expense under utilities all you have to do is right click on Telephone expenses edit that account and make it a sub account of utilities you’ll also see one at the bottom that says ask my accountant if you ever have a situation where you don’t know where to put one of the lines on the transaction you’re entering then you can go ahead and add it to this ask my accountant and later you can go back and move it this gives you a really good idea of how to set up this chart of accounts remember it’s super important that it’s set up correctly from the beginning because if you don’t have the correct type then what will happen is you’ll run reports and they will not be accurate let’s go ahead now move over to video number seven and we’re going to talk real quick about some of the different sample files that are in QuickBooks if you happen to be working in one of your company files you’ll want to go ahead and close that company just go up to file on the menu and then come down to the closed company slash log off option when you’re on this window you’ll notice there’s an option here to open a sample file the down arrow will give you a list of the sample files that are loaded into your version of QuickBooks you can see there’s a product based business which is a construction company and there’s a service based business which is a landscaping company you probably want to use the product based business because here you can see everything the way it should be set up the proper way you’ll be able to go in and actually see how things were done and anytime you’re using the sample file it will just give you this message and you can see that it’s letting me know that once I get in the date will be set to December 15th of 2023. all you do is Click OK and then you’ll be inside the sample file you’ll be able to look up anything you’d like if you’re having an issue setting up an account in the chart of accounts for example just go over to the chart of accounts and look and see how it was set up here and set Yours up the exact same way well I just want you to know where those two files are they’re going to be very helpful for you when you have questions about different things as far as setting up your company file well let’s go ahead and move over to video number eight and I want to quickly just talk to you about how to use the company file search option in QuickBooks hey there welcome back we are wrapping up module three we’re here in video number eight we’re going to talk a little bit about how to use the company file search option in QuickBooks for desktop 2022. there are many ways to search in QuickBooks but if you just need to search quickly for something there’s a search box you can just type things into and it will pull up any data that meets your search criteria let’s flip over to QuickBooks and I’ll show you where that file search option happens to be we’re here in one of the sample files this is the sample product based business the first thing you’ll notice is your icon bar is still on the left hand side I wanted to point this out because we’re going to talk about a search box that should appear right up here that way if you’re looking for an amount of money or a name you can just type it in but since there’s not one let me show you how to actually get it to show up if you remember we can actually put the icon bar at the top I’ll click on view from the menu and then choose top icon bar once you do that you’ll see over here now we have a search box let’s say I want to search for a payment for two thousand dollars I can just quickly put in 2000 here and then once I go ahead and hit the enter key you’ll see it pulled up this search history here and you’ll see that it’s got exactly and it’s looked up everything for two thousand dollars so if I happen to be here and I see that I’m looking for this particular payment down here let’s say this one and I want to open it up I can just click open here and go right to that particular transaction in this case it’s a payment while we have the search box open let me just show you a couple of things you’ll see over on the left here that we’re looking through transactions there were 13 that met my criteria I could actually click that Arrow that’s to the left of transactions and it will show me that three of those happen to be bills five of those happen to be payments you can see that list I could be looking just through customers or just through vendors you can see when I click on these that I can put in some criteria down in this section right here where it says amount I had typed in 2000 so it was looking for an exact match but I could be looking for anything greater than 2000 or less than or a range which allows me to put in two different numbers I might be looking for anything between 1 000 and 2000. notice I can also put in a date range down here all of these options make searching really easy in QuickBooks remember that it starts with this search box here you can put text in here too if you’d like it doesn’t have to be just numbers and it will search for any text that you’ve typed in there are other ways to search in QuickBooks we’ll talk about a lot of those down in module 17 but for now I just wanted to see that quick way to search for something in QuickBooks well that’s going to wrap up module 3 where we talked about customizing the QuickBooks environment let’s go ahead and move now over to module 4 and we’ll go ahead and get started with the first video where we’re going to talk about working with customers and jobs hey there welcome back it is Cindy we’re working in QuickBooks desktop 2022 and we’ve made it all the way down now to module 4. this is the module where we’re going to talk about working with customers and jobs you can actually call this accounts receivable we’re going to talk about setting up customers in this module invoicing we’re going to talk about estimating receiving payments anything having to do with accounts receivable we’re going to cover in this module this is the first video where I want to start helping you set up your customers and your jobs there are two parts so make sure you watch part one and two to make sure you have your customers and jobs set up correctly let’s go ahead and flip over to QuickBooks and we’ll get started working with those customers and jobs a customer is a person or a business that buys from you a customer might have different jobs that you’re working on for them as well I want to take you into the customer center and show you where the list of customers and jobs is and how to work with that list before we do that remember that this section here is your accounts receivable section and this is where you’re going to do most everything related to customers the easiest way to access the customer center is to click right here but before I do that let me just point out you can also access the customer center from your icon bar or you can go up to customers on the menu and choose the first option the customer center and I’ll go ahead and do that this is a listing of all of the customers and jobs that you have already set up in QuickBooks before we get started looking at the list let me just tell you a little bit about how this screen is actually set up you’ll notice here on the left you’re seeing every one of your customers last name comma first name and they’re in alphabetical order these that look indented these are jobs for that customer this is the balance the customer owes you and this column over here would allow you to create an attachment and actually attach a file to that customer and that way you don’t have to get all the way out of QuickBooks if you’re looking for something specific that you’ve already attached if you’re clicked on a customer you’ll see that because there’s information right over in this section you can see all of their information as far as their address their phone number their email and over on the right you’re going to see some reports for this customer or job this section here allows you to look at different transactions for that customer maybe you want to look at contacts to Do’s notes or send emails and we’re going to go through all of this but I want you to get just familiar with the screen itself let’s go ahead and add a customer so that you can see all of the information needed when you’re creating customers and jobs the easiest way to do this is you’ll see an option right here that says new customer and job when you click the down arrow you’ll see three choices the first one being to add a new customer the first thing you need to tell QuickBooks is what is the name of the customer if you remember the customer name was alphabetical last name comma first name it’s not going to alphabetize them automatically you’ll need to actually type in their last name and then put a comma and put the first name then it will sort by the first letter of the last name there the next field that you see says opening balance what this means is how much money did the customer owe you as of the start date of your company file you might want to leave that blank if you’re just starting your company file new what you might want to do is actually enter the invoices that aren’t yet paid for that customer if you just have a balance here your accounting will be correct but you won’t have any way of going back and looking at one of those invoices that’s still open notice that I’m on the address info Tab and the first thing it asks me is what is the name of the company if Tom Allen works for a company then you can type it in if not you can leave this blank and I’m going to say he works for ABC Plumbing notice there is a place for the full name you can say mister Tom and of course you’ve got the middle initial and last name a common question is if I have the name here why do I need to put it in here this field right here allows you to put the customer’s name in that list that we saw right over here remember this it’s going to put it in that list however if I wanted to do a mail merge it would pull from these fields right here so it’s important to have these filled in you can see that you can fill in the job title and then all of these fields down here you can actually edit that field to represent any of these options that you see on the drop down now here’s something really important you’ll see when I typed in ABC Plumbing Tom Allen that it populated this right here but this is the actual address block that’s going on a customer’s invoice so you may want to click in there and set it up the way you’d like it to be I’m going to say attention Tom Allen and then I’m going to go ahead and put in a P.O box here I’ll put in the street address we’ll just use a PO Box in this case then I can go ahead and hit the enter key and go ahead and put in the city state and zip and we’ll just say this person is in Charlotte North Carolina if you wanted to have a separate shipping address maybe you like things for this customer shipped to the job site as an example you could type that in over here or you can just copy this address to this one but if you don’t ship anything you really don’t need to fill in this section right over here now let’s go up to our tabs on the left and click on payment settings the first thing you’ll see here on the payment settings tab is there is a field for the account number if you give your customers account numbers you can fill this in if you don’t you can leave this blank the next one you’ll see is for payment terms you might give different payment terms to different customers maybe if it’s a new customer you give them terms of Duo from receipt and maybe if it’s someone you know well then you might get them net 30. we’ll just add net 30 in this case the next field asked you what is their preferred delivery method do they prefer to have things emailed to them mailed or neither and is there a preferred payment method now this doesn’t mean that they’re going to pay you with their Visa card every time it’s just giving you information letting you know that they usually prefer to pay with their credit card you’ll notice there is a place down here to store your customers credit card information I probably wouldn’t do that because if someone gets into your computer you are liable for that as a business if you’ve got someone that wants you to keep their credit card number on file just write it down somewhere and just keep it safe so that no one can get access to it you’ll see over on the right there’s a feel for a credit limit what would happen is if you set a credit limit for your customer and you invoice and those invoices exceed the credit limit it will pop up and ask you would you still like to sell them something and then you can just bypass that there’s also a field for Price levels if you decide that all of your commercial customers should get a 10 discount as an example then you can set that up I’m just going to click on add new for a moment and just show you what the screen looks like the first thing you would do is put in a price level name commercial for example and then you can see that you can tell QuickBooks that every time you invoice a commercial customer their price level will either increase or decrease by whatever percentage you type in and we’ve got commercial already set up back here so I’ll cancel that but that’s how that would work and it would automatically give them that discount you can also set up online payments for your customers if you want to have a button that they can click on once you email the invoice to them that button would allow them to actually pay you with either bank transfer or credit card and you could set that up with Intuit let’s go over to the sales tax settings tab if you charge sales tax to your customers then you can specify whether this customer is a non-taxable or a taxable customer a non-profit organization for example would be non-taxable where a regular customer would be charged sales tax you also would tell QuickBooks what is the most common tax item you would have to have these set up already or go through and set them up here these are actually set up in the items list and we’ll discuss this in a later module and also there’s a feel for the resale number all that means is let’s say that I sell physical products in my store and one of my customers sells physical products as well they might have a resale number already set up that they can give me so that when they purchase those products for me they don’t have to pay sales tax and this would be a good place for you just to keep that information the next tab says additional info this is where you can categorize your customers you can see in this example they have commercial customers and residential customers if you work with sales reps in your organization you can set them up here as well and then these fields that you see on the right these are created by you all you have to do is click on Define Fields And if you have a new field you want to add just type the name of it here and then check underneath each of these if you want that field available for customers vendors and or employees so you don’t have to set it up three different times now the last tab says job info you obviously wouldn’t use this one setting up a customer but if this was a job you could put a description of the job you could have a type of job if you want a status for the job you can put in a start date and end date and a projected end date and those are options you would use if you were creating a new customer I’m going to click OK and let’s see if our new customers in the list and you can see there’s Tom Allen right there now that you have a new customer Tom Allen let’s go ahead and add a job for this customer as long as you’re clicked on your customer you can come up here where it says new customer and job and choose the add job option I want to call this job kitchen remodel I really don’t need to fill in any of this other information it pulls in the information from that customer so unless something’s different all you have to do is Click OK at the bottom and now you’ll see you have a job for your customer if you want to edit any of the information for your customer or your job just make sure your clicked on that customer or job and you can come right over here where you see this little pencil and that means edit and that will take you right back into the screen so you make any changes you want when you’re finished click ok and you’ll see that your customer dropper now created let’s go ahead and now move over into customers and jobs part two and we’ll finish talking about setting up these customers hey there welcome back it’s Cindy again we’re working in QuickBooks desktop 2022 we just got through with customers and jobs part one I want to go ahead and continue talking to you a little bit about setting up your customers and jobs this is part two let’s go ahead and flip over to QuickBooks and we’ll keep going I am back in the customer center just in case you forgot how to get here I’ll go back to the home screen for just a moment from the home screen you can access the Customer Center from here you can access it from the Icon bar under the icon that says customers or you can go to customers on your menu and you’ll see the very first option says Customer Center whichever customer you’re clicked on on the left you’ll see their information in this area of the screen I’m clicked on Christy Abercrombie and you can see that I’ve put in information like her billing address I’ve got her phone number her email address you’ll also see here a map and directions to Christie’s Bill to address and just to show you how this works if I click directions it’s going to open Google Maps and the address will be 5647 Cypress Hill Road let me go ahead and do that so you can see how this works and now I know how to get to Christie’s office let me go ahead and close this a couple things on the right that I want to point out first of all you’ll see there’s a box right here underneath note and when I point there you’re going to see three notes and you can see the dates for each one now those notes actually come from this tab here that says notes that’s these three notes if I wanted to pin one of those notes Here I could do that I could just go ahead and click the pen option here or here and that would actually stick it here permanently so that I can see those notes whenever I come into Christie’s account you’ll notice below this you’ll see a couple of reports for Christy I can run a quick report I can run an open balance meaning every invoice I’ve created for Christy that she has not paid me yet I can show estimates for Christy and also there’s a customer snapshot the other thing I want to mention up here is this little paper clip if you have a file you’d like to attach to Christie’s account all you have to do is make sure that file has a name I’m going to click the paper clip all you would have to do is search your computer if you have the file already saved if it’s on your phone you can actually connect that there’s also a document Center here these would be any documents you’ve already scanned that might be in QuickBooks you can also just take a file and just drop it into this area here maybe it’s on your desktop currently and that will attach it as well if you have a file attached you will see a little paper clip show up right over here and that way you can click there anytime you want to see that file let’s look at some of these tabs down at the bottom I’m going to click on transactions this is one of the easiest ways to look for a transaction related to a customer instead of running a report which you could certainly do or doing a search if you can just come here and look down the list sometimes it’s easier just to pick out the transaction you’re looking for you’ll see these transactions are currently sorted by date you can see the little down arrow there but I could sort them by type or number if I wanted to any of these column headings if you want to open one of these transactions let’s just say the very first one just double click on it in this case it’s a payment and you can see that it brought up that payment for Christie if you needed to make a change to this transaction you could do it right here save and close at the bottom and when you come back you will see that change reflected on this line notice I’m currently looking at all the transactions but I might want to filter this list maybe I just want to see invoices for some reason you can also over here instead of showing all the transactions you can filter it by this date range you can come down and say last month or if you want to see anything last fiscal year this fiscal year you can see your choices here notice at the bottom of this tab you see an option that says manage transactions and there’s a down arrow to the right of it here’s where you can go in and create an estimate an invoice a sales receipt you can create any of these transactions you want right from here chances are you’re not going to be in this screen though but just know that you could if you wanted to this edit selected transaction is the same thing as double clicking and making that change and saving it you’ve also got some reports down here at the bottom if you click the down arrow I can view this entire screen here as a report if I want to let’s take a look at the contacts tab a contact is a person that you want to keep a record of that maybe works for that company it could be that when you call this company you always speak to a certain person maybe Steve you can see Steve is set up as a contact here if I come to the bottom and click the down arrow you can see I can add a new contact here I can edit the one that’s selected or can delete the selected contact I’m just going to click edit because I want to show you the information that you can fill in when you’re editing or adding a contact you would have to put in their name you can see they’ve got Christie’s first and last name notice they have her last name in the same field as the first name I’m going to go ahead and actually cut that out and paste it down here the next thing is I can add her work phone Fax mobile and again these fields can represent whatever you’d like them to just by clicking the down arrow and seeing your choices Christy is a primary contact but notice I could set up an additional contact or a secondary I’ll go ahead and save and close and now you’ll see there’s Christy Abercrombie she’s still our primary contact let’s look at the to do’s a to-do is something you have to do related to this customer if you had any to-do’s already set up you would see them listed here to create a new to do come down to the managed to Do’s at the bottom click the down arrow and you’ll see create new a to-do can be a phone call a fax an email a meeting an appointment or a task you decide I’ll go ahead and say it’s a call and set the priority is it a high priority task or a low priority task it’s going to assume it’s with this customer but notice you can change that if you want to this can actually be with the lead possibly or a vendor or an employee you can set the due date if you want to set a time on that date you just click this check box and set the time now at the bottom is where you type in the details you can also change the status when you first set this up it will be an active to do but you can actually say this to-do has been done or make it inactive I’m going to go ahead and click ok and now you’ll see that this to do has been set up once you’ve completed this task or this to do notice that over in this done column you can actually double click and that will open up this to do you can actually come down here and say done and click OK and now you’ll see there’s a check mark indicating that you’ve completed that to do you can also run reports on your to-do’s notice you can launch a to-do report which looks just like this and you’ll see all the to-do’s that you have set up not just for this customer I’m going to go ahead and close that the last thing I want to mention is the tab that says sent email once you send an email through QuickBooks you’re going to see that email is listed here and that way if you want to go back and see a record of all the emails sent to this client you would have that list now there’s a couple of other things here I just want to mention real quick before we wrap up working with customers and jobs you’ll notice at the top here the new transactions we’ve seen this screen already we saw this under transactions when we went to manage transactions we could create these new items this is the same list chances are you won’t be on this screen when you want to create these and all of these happen to be on your home screen by the way as well but if you happen to be here you can do it from here if you wanted to print you could print your customer list you might print just job information or customer and job transaction list you can also export this customer list over to excel that way you have a list that’s separate from QuickBooks if you needed it for some reason you can export the transactions you can also import from Excel if you have a list of customers already set up then you can either import them or paste them in from Excel and just to show you this screen I’m going to click on paste from Excel when you look at this screen what you see here is a listing of all of your customers and each field of information what you can do if you have a lot of customers you want to add you can go to the bottom and just start typing the new customer information in these fields and when you’re finished you can save changes and they’ll be in QuickBooks just as if you set them up from within QuickBooks you also have the ability if you want to do a mail merge with Microsoft Word you can do that from here and we’re going to go through all of this in a later module and then also you have what’s called an income tracker that you can look at we’re going to cover this in a later module as well but just want to give you an idea of what types of things you’re going to see in the customer center well that’s going to wrap up customers and jobs let’s go ahead now and go over to the next video which is number three and talk about customer groups hey there welcome back it is Cindy again we are working in QuickBooks for desktop version 2022 we’re down in video number three now and I want to talk to you about a newer feature that QuickBooks has called customer groups this is a newer tool designed to help small business owners with one of the hardest problems that they have and that’s actually getting your customers to pay you can actually categorize your customers and based on that you can create groups of customers so that you only have to send one email instead of a separate email to each customer let’s flip over to QuickBooks now I’ll show you how to set up customer groups and then I’ll also show you how you can create an email and send it to that group to access the groups option you’ll need to head up to the menu and click on list and you’ll see the very bottom options as manage groups if you had any groups already set up you would see them listed here I don’t so I’m going to click on create customer group and set up my first group the first thing I want to do is give my group a name I’m going to call this one my commercial customers and if you wanted to add a description you could certainly do that but I’m going to click on next and set up some criteria the first thing I’m going to do is drop down this list where it says field what I’d like to do is all of my commercial customers I want to be able to send them emails separate from my residential customers I have customer types already set up so I’ll choose customer type then I’ll select the operator I want any customer types that equal residential and these are the two customer types that I had set up over in QuickBooks once you’ve filled in those three options go ahead and click on ADD and then you’ll see it on this list of selected fields I’m going to click next and now it gives me a list of all of the customers that meet that criteria if you see one that you don’t want to be in this list you can uncheck it if you do uncheck one QuickBooks will give you a message letting you know that if you want to add this customer back to the list you’ll have to manually do that I’m going to go ahead and say no in this case and I’m going to hit finish at the bottom now my group called commercial customers has been created successfully I’m going to click OK and now you’ll see it in the list there if I want to create another group here’s the button to create that new customer group now that I have a customer group here you’ll notice under actions there’s a down arrow this is where you would go if you want to edit the group maybe you want to change the name of the group you can delete the entire group or you can actually send the group an email I’ll click on email so you can see how this works now this can be any type of email it doesn’t have to be an email regarding their payment you’ll notice that it actually pulled up a list of all the customers that met my criteria if I don’t want to send an email this one time to one of these customers I can just uncheck them so just go through this list and check or uncheck the ones you do or don’t want to send to you’ll notice the one that you’re clicked on you will see that customer’s email address if I click on Chris Baker you’ll see this changes to Chris B it is going to send an email to each customer if you wanted to add another email address you can actually click here and type that in here you can attach a file if you’d like to send a file with this and then you can put in a subject I’ll just put in here payment and then you can set up the body of your email I just put in hope you’re doing well I see that your account is overdue do you think you can make a payment by Friday you can see the rest of that message you want to check your spelling just to make sure that you look very professional you wouldn’t want to have any misspelled words here and then when you’re ready to send this you’ll just hit send now notice also that it tells you down here in this case QuickBooks will take 16 minutes to send these emails and won’t be available just make note of that because if you go ahead and send and then you’re trying to use QuickBooks it might not allow you to do certain things because it’s still trying to actually get those emails out for you and that’s how your customer groups are going to work I’m going to go ahead and close this one let’s go ahead now and head over to video number four of this module one of the new features that QuickBooks 2022 has is the ability to add multiple customer contacts to your emails and I want to show you how to do that thank you hey there welcome back it’s Cindy we’re in QuickBooks desktop 2022. I’ve got a really short video this time because I just want to show you a new feature that’s been added to the desktop 2022 version and that is the ability to add multiple customer contacts to your emails or any forms that you’re actually going to send out let’s go ahead and flip over to QuickBooks and I’ll show you how to do that really quick books allows you to email a form to your customer or vendor in this case I’m on an invoice and I’d like to email it to my customer I’m going to click on email and then I’m going to choose invoice you see that it tells me I have information that’s missing or invalid and that’s because I don’t have an email address set up in Tom Allen’s customer setup window I’m going to go ahead and set it up here if I wanted to add an additional email to this I would put in a semicolon at the end and then put in that second email address because I copied this in you can see it put in that semicolon for me but if I was typing it I would have to type that semicolon and you can put in as many email addresses as you’d like and that’s how you would go ahead and add more than one email address to a form that you’re actually sending out to a customer or a vendor I told you this would be a really short video let’s go ahead and wrap this one up now and head over to video number five where we start talking about estimates welcome back to QuickBooks desktop 2022 this is Cindy and we are working through module four where we’re going through and talking about setting up customers and jobs we’re going to start talking a little bit about estimating jobs in the next couple of videos if you do not create estimates as part of your business then skip on down to video number nine and go ahead and look through invoicing customers for products and services we’re going to go ahead now though and start talking a little bit about creating estimates this is part one make sure you watch both parts so that you get a full understanding of how estimates work let’s flip over to QuickBooks and we’ll start talking about estimating jobs QuickBooks offers the ability to create estimates or quotes So that you can turn those quotes into invoices to get paid from your customer you can actually do what they call progress invoicing meaning that you invoice your customer for certain items that are on that estimate until everything is pulled over on your home screen you’re going to see the estimate icon right here if by chance you don’t see it it’s probably because you told it when you set up the company file that you do not create estimates Let me refresh your memory on how to turn that back on if you go up to edit on the menu come down to preferences make sure on their left you’re clicked on jobs and estimates and then the company preferences tab here’s where you turn on the option to create estimates remember if you’re creating estimates you probably do want progress invoicing as well make sure this one says yes and then go ahead and click ok now you should see your estimate icon appear if you do not use estimates and you want to leave this icon here it doesn’t hurt a thing you would just start with the create invoices if you invoice in your business something else just to know is estimates and purchase orders are on the same line here and that’s because they’re both considered non-posting if you create estimates for a potential customer and you never hear back from them it doesn’t really affect your books you’d have to actually run special estimate reports to even see that estimate let’s go ahead and start the process I’ll show you how this works let’s go ahead and click on estimates the first thing you want to do is choose your customer and your job if you’re working with the job feature always always always click the job underneath your customer that you’re wanting to work with if you just choose the customer name you’re going to run reports and see other and you won’t know which job those transactions go to make sure you click on the customer and the job the next thing you’ll want to do is choose the class if you’re using the class feature if you’re going to use the class feature use it consistently because it doesn’t do you any good to use it sometimes and not others reports won’t be accurate I’m going to choose remodel in this case there are also different templates you could use when it comes to estimates invoices any of your forms if you look over in module 10 that’s where you’re going to see how to actually customize these different templates we’ll just use the one that it pulls up automatically in this case the next thing you want to look at is the date it’s going to pull in the current date but you can change that date if you need to and also notice the estimate number any transaction that’s numbered in QuickBooks whether it’s a check or an invoice or an estimate it’s going to start with number one you probably want to start off by changing that number and then it will number sequentially after that for you unless you change it again you’ll see here it pulled in the name and address of your customer and if you happen to be shipping items somewhere then you’ll want to choose a ship to address over here if you don’t have one you can add it if you don’t need this field at all just leave that blank let’s go look down in the body of the estimate if you notice there’s a column that says item and if you click right underneath it a down arrow appears this will give you a list of all the different items you have set up in QuickBooks items are things that you sell to your customers sometimes you purchase items as well items are set up by different types you’ll see that some of these items are Services you provide you’ll see some of these are actual Parts physical parts there’s inventory and there’s non-inventory you’re going to have different categories that items can fall into we’re going to be looking at these in a later module but for now we’re just going to use a couple that are on the list to show you how this works I want to start with framing you’ll notice once I click framing it pulls in a description and you can type over that you can add to this this will word wrap so you’ve got plenty of space to type in that description if you need a lengthy one I’m going to go over to the quantity field and I’m going to put in 10 and you’ll notice that it calculated my 10 times the cost of 55. this 55 was set up when the item was set up you can type over that if you want to change it this one time only you’ll notice that it calculated the quantity times the cost to give me an amount in this column now we skipped over the unit of measurement you’ll see it’s grayed out right here if you have something you sell by the foot the yard that by the case possibly you could set that up as a unit of measurement and choose one case one yard we don’t have that set up in this example that’s why it’s grayed out let’s take a minute and talk about the markup column you have the ability to mark up an item a dollar amount or a percentage I’m going to say 30 percent in this case you have to put the percents on or it won’t do the percentages then if You tab through it you’ll notice that it calculated that for you to give you a total the last column says tax that means that for sales tax purposes framing is a labor and this is a non-taxable item let’s go put in one more we’ll do a physical part this time let me scroll down and find some wood doors we’re going to choose exterior wood door and I want to add two of these we’ll just use the cost that it brings in I wanted to point out the markup in this case the reason that this markup pulled in automatically and it’s a negative number is because when you’re setting up an item you can tell Quickbooks on average how much you pay for it and on average how much you sell it for if those two were set up it will pull in a markup for you we obviously don’t want that one we’ll just delete it and we’ll put in a dollar amount in this case I’ll just say a thousand dollars and notice it did the calculation for me this is a taxable item because it’s a physical product that we’re selling our customer like you could keep going down the list and add as many items as you want this line here is not the very bottom you it will keep going as long as you keep adding items let’s take a look at a few things at the bottom of the screen on the left side you’ll see there’s an area for customer message there are some that are pre-set up but if you want to add your own you would click add new and add one right below that is a field for a memo just something quick you might want to say that the customer won’t see and this also tells me the customer is taxable as far as sales tax is concerned on the right hand side you can see it gives me the subtotal the total of the markup if there were sales tax it has the sales tax rate pulled in and you see that amount and then there’s a total at the very bottom that gives you a general idea of how to set up the body of the estimate what I want to do now is head on over to part two and we’re going to go up and look at some of these options that you see on your icon bars up here and a few of these different tabs we’ll be looking through some of the reports and things like that so let’s head over to part two and I’ll see you shortly hey there welcome back to QuickBooks desktop 2022 this is Cindy we just completed estimates part one where we were able to set up an estimate for a potential customer let’s go ahead now and finish talking about some of the other options available for estimates this is part two let’s flip over to QuickBooks and we’ll keep going in part one we actually created an estimate for a customer and I’d like to go back to that estimate since I’m on the home screen the easiest way to do that is to go back to the customer center right here and look at the transactions for my customer we were using Tom Allen and you can see that here is Tom Allen’s estimate all I have to do is double click and go right to it now that we have the estimate created what I’d like to do is go for some of the options with you and we’ll go to the top of your screen and go through these four tabs starting with the main tab here you’ll see the first thing you can do is use the find feature that QuickBooks has to find an estimate you could use the arrows that go left or right to go to the next or previous estimate keep in mind that every transaction in QuickBooks is set up in date order that means that if you had previously entered an estimate and maybe you backdated it a few days it may not be the previous one when you hit this arrow and you have to keep clicking on it if you can’t find it that way you can click on this find option right here and this will allow you to put in some criteria you can see that you can put in a customer and job name a date beginning and end date here an estimate number and an amount and you can fill in all or any of this information you’d like and then have it find for you and that would generally find that estimate the other option I want to mention is this Advanced option right here you can go in and put in any of this criteria under this filter column that you see and search that way we are going to look at the whole search option a little bit later let’s go ahead and close out of this I just wanted you to know that advanced option was there the next option you see here says new and this will allow you to create a new blank estimate this is the exact same thing as going to the bottom of your screen and clicking on Save and new that you see down here the next option over says save if you’re working on this and you want to save what you’ve done so far you can hit that save option notice there’s a down arrow there that will also let you save this as a PDF file if you’d like to do that here’s where you would delete this estimate if you’d like you can also create a copy that’s handy if you need to create another one exactly like this and maybe just make one or two changes saves you a lot of work we’re also going to be looking at memorizing transactions in a later module but this would allow you to basically tell QuickBooks that every month as an example I would like to see the same estimate in QuickBooks you can also Mark a transaction as inactive now what happens is if you have a transaction that’s inactive it will still be in QuickBooks but it’s not counted as any of your numbers when you run reports if you ran an estimate report for example it wouldn’t be counted in those totals the next option you see is the option to print this you’ve got a couple things you can do you can preview this which we’re going to do in a second you can also just print the estimate right here you can print an envelope which will do a mail merge with Microsoft Word and you can also save this as a PDF let’s start with the preview option I’m going to just click anywhere in the middle and that will zoom in and I wanted you to take a peek at what your estimates will currently look like because you will want to customize this you can see it’s very plain it has your company name and address at the top you may want to add a logo your telephone number the website email address you can do that by using one of the templates that’s available to customize in QuickBooks and we’re going to do that in a later module you’ll see here’s the date of the estimate the estimate number here’s where it automatically puts the job name notice they call it project that would be something else you may want to customize the big things I wanted you to notice here is that when you have an estimate the customer does not see the name of your item they also don’t see the markup column now you could turn those on if you wanted the customer to see those but generally you don’t want them to so QuickBooks doesn’t turn them on automatically you’ll notice at the bottom you can see the subtotal and the sales tax and the total of the estimate as well and again those are some things you can customize I’m going to close out of that here at the top the next thing I want to point out is the email option you have the option to email this to your customer if you had several that you had set up that you wanted to email you would make sure this little check box where it says email later is checked and then you can email the batch notice you can also attach a file to this this could be a Word document or something you’ve scanned in notice you can also create an invoice from here chances are you will not be in this screen when you want to create an invoice but you can do that from here and just to mention the start project there are several different add-on packages you can buy for QuickBooks in two it does make a project management type software and this is where you can go and get a 30-day free trial if you’d like it’s called Maven link and that way you can manage the project the expenses anything related to it let’s look at the formatting tab I mentioned a few moments ago that you could customize this template for this estimate this is where you would be doing some of that and like I said we’re going to look at that in a later module here’s where you can run your spell check you can also insert a line whichever line you happen to be clicked on if you insert a line notice you insert one above the one you’re clicked on if you’re clicked on a line you can also delete that entire line or you can copy the line you’re clicked on and here’s some more customization options we’ll look at in a later module now let’s talk about the send slash ship option I mentioned earlier that QuickBooks can do mail merges with Microsoft Word you can merge envelopes letters and this is where you would work with those options we will work with those in a later module as well and then let’s look at the reports for a moment there are a couple of generic reports already set up for you that are related to estimates you can see you can run an estimate by job if you’d like if you want to see an estimate versus actual you can do that and then you can also see an item price list I also want to point out the transaction history which you have none right now but if you’d already created an invoice based on this estimate maybe received a payment that would create a history you could go look at and sometimes that’s very helpful to narrow down where to find certain transactions typically the main tab is where you’re going to be working so I’ll just click back on that and that’s how estimates work in QuickBooks I’m going to go ahead and save and close at the bottom and if you’ve made any changes to your transaction it will ask you if you’d like to save them just go ahead and say yes now that you know how to create estimates in QuickBooks let’s head over to the next video and we’re going to start talking about how to create invoices based on those estimates that you’ve already created hey there it’s Cindy again welcome back we are working in module four we’re talking about customers and jobs this is actually video number seven where I want to introduce you to how to invoice from estimates if you do not create estimates in your business then you can skip 4-7 and 4-8 and just go right down to 4-9 and just start with invoicing customers for products and services but let’s talk about how to take your estimates and turn them into invoices let’s flip over to QuickBooks and we will go ahead and get started now that you’ve created an estimate for your customer you’ll want to go ahead and pull some of those items onto an invoice that way you can send the invoice out and get paid for some of that hard work you’ve been doing before we do that we’re going to be talking about progress invoicing as we go through and create this invoice and I want to make sure again that you know where that option is in case it’s not turned on if you go back to edit on your menu and come down to preferences you want to make sure on the left here that you’re clicked on jobs and estimates company preferences tab and make sure you’ve chosen yes for the option that says do you do progress invoicing this is what’s going to allow you to pull items from that estimate onto an invoice I’m going to go ahead and click OK because that looks okay and let’s get started I’m going to choose create invoices the first thing I want to point out is if you have this gray bar you can click this Arrow to show the history this may be on already and you want to actually hide the history by clicking on this arrow that will give you more room to work with on your screen the history will just give you the recent transactions any notes customer payments things like that that you may want to see as you’re creating this invoice we’re going to go ahead and hide that for now and notice the first thing that QuickBooks wants to know is who is my customer and my job that I’m actually creating an invoice for I’m going to choose Tom Allen’s sunroom now you have a list of available estimates these are estimates that you’ve created for Tom Ellen’s sunroom and you haven’t pulled everything onto an invoice yet if this window doesn’t pop up the first thing I would do is check your estimate to see if you have the exact same customer and job if I created the estimate originally and I just had Tom Allen and not the sun room but here I chose the sun room there’s not going to be an exact match so this window won’t pop up I’m going to go ahead and click on the estimate I’d like to pull from and then click ok and now you see the progress invoicing window this is what I wanted to make sure was turned on over in the preferences here I have three choices I can go ahead and pull everything on the estimate onto this invoice that would be the first one the next thing I could do is create an invoice for a percentage if I wanted to create an invoice for 30 percent I would just type in the 30. it will let you put the percent sign in that’s okay but it does know it’s a percentage and then the third option at the bottom notice is where you would create an invoice for selected items I’m going to show you how that one works I’ll just click on OK and here you’ll see each item that you had actually pulled on to your estimate you can also see the quantity and all the information about each one if you want to pull over three of the hours of framing you would just type that in the quantity area and then here let’s say I pull over one of the wood doors you could also go in and put in the percentages if you prefer to do that I’m going to click OK and now you can see that it pulled in those quantities that I just told it I wanted to pull over if you wanted to add something to this just click on the next line down and type it in you can add as many items as you want to maybe there’s a freight charge that you want to get reimbursed for they actually already have an item set up called Freight reimbursement here I’m just going to say there’s a quantity of one of these and I’ll just make up an amount 193.26 and you can see it tracks all of that you can see at the bottom here that the sales tax that I’m using is San Thomas and the tax it’s charging is 84.51 you can see the total if there were payments applied you would see that here you wouldn’t see any payments applied until you’ve saved this and then recorded a payment and then opened this back up that’s when you will see any payments have been applied and of course there’s the balance is due right down at the bottom over on the left hand side you can see there’s a place for a customer message they have a few of these already set up but if you wanted to add a new one you would just choose add new and type that in I’ll just choose this one here that says please sign and date this proposal there’s a place for a memo below that and no one will see this memo except you it’s not going to print out on your invoice there’s also a place for the customer text code this just means this customer is subject to sales tax couple things at the top I want to go over real quick if you’re using the class feature make sure that you choose the correct class you want to use that consistently if you’re going to use it so that your reports are accurate there’s also a place for the template that you want to use for this invoice we’re going to cover templates in a later module here’s the date of your invoice I’m going to change this to December 27th the invoice number is populated automatically you can change that if you’d like and double check that your billing information is correct for your customer this customer has terms of net 30. I can change that if I like you can see that if I choose net 15 as an example that this due date reflects 15 days from this date right here when you’re finished just go ahead and save and close if you’re finished or if you want to create another one you can choose save a new I’m going to save and close for now and you’ll notice that I changed the terms over here and this is asking me do I want QuickBooks to change those terms permanently in the customer’s record I’ll go ahead and say yes for now and that invoice has now been completed let’s go ahead and move over now to part two that’s going to be video number 4-8 and we’ll continue and talk about some of the options you have when you’re creating that invoice hey there it’s Cindy again welcome back we just wrapped up invoicing from estimates part one we actually went through and created an invoice based on an estimate what I want to do now is go ahead and take you into part two we’re going to complete another invoice based on that estimate and then we’ll go over some of the options you have available when you’re working with that invoice you’ve created let’s go ahead and flip over to QuickBooks and we will continue with part two I want to head back to the customer center I still have it open on the left just to show you that we do have our estimate and then we have one invoice we created what I want to do now is go ahead and create an invoice for whatever was left on that estimate because we’ve completed that job and we’ll just follow the same process I’m going to go back to the home screen and choose create invoices the first thing I want to do is pick my customer and my job I’m going to pick Tom Allen’s sunroom it does tell me I have some available estimates as long as you have even one penny left on that estimate this window will pop up you won’t get this window for this customer and job once you’ve pulled everything from that estimate but I’ll go ahead and choose the estimate I’d like to pull from and click ok and now I get my progress invoicing window again one thing that’s a little bit different from the first time we saw this is notice the first option now says create an invoice for the remaining amounts of the estimate which is what I’m going to do but I could choose another percentage or if I want to pick selected items like we did with the first one I could do that as well I’m going to click OK here and you can see that it pulled in whatever was left on that estimate that had not yet been invoiced I’m just going to double check some of the options on the screen I want to change the date in this case I’ll say that it’s January the 9th notice it does give me the next invoice number my bill to information is correct you want to make sure you check the terms and the due date if you want to add anything to this remember just click on the next line down and you can add anything you’d like to this invoice you do have at the bottom your sales tax your payments applied and your balance due we talked about all of that once you’re finished you can go ahead and save and close or save a new if you want to create a new one before I save and close I want to go through some of the options that you have up under your tabs at the top of your window these are options that pertain to this invoice you’re probably going to stay on the main tab most of the time and some of these options you’ll already be familiar with because you saw them when we actually created the estimate but let’s go back through these the first thing you’ll notice is you have the option to find if you’re looking for an invoice and you just can’t find it using these arrows that go left or right go ahead and click on the find option and that way you can put in some search criteria and have QuickBooks search for you your next option is your new button this allows you to create a new blank invoice remember this is the exact same as coming down to the bottom of your screen and choosing save and new you do have the option to save this invoice if it’s taking a while and you have a lot of line items you might want to save it at various points notice also that you can save this as a PDF just by clicking that down arrow the next thing you’ll see is the delete option this is how you’re going to delete this invoice notice when I click the down arrow I also have an option to just void it if I delete it it’s going to be gone but if I void it it will stay in QuickBooks and it will just say void across it with a zero balance if I wanted to create a copy of this I could I could also memorize this and we’ll talk about memorizing in a later module also Market as pending remember if you mark something as pending it’s going to be in QuickBooks but QuickBooks will not count it in your numbers it could be that you set this up a little bit early and maybe you’re not quite ready to send it out but you don’t want to delete it you could leave it in here and that way it’s not part of your accounts receivable you do have the option to print this I want to show you a preview of what your invoices look like I’ll just click anywhere to zoom in a little bit you can see that it has your company name and your address you will want to customize this a little bit so you have some more information here possibly the telephone number the email address you’ll notice over on the right it says invoice there’s a place for the date and the invoice number and then all of the information that’s on that invoice remember you can customize this like I mentioned and we’ll do that in a later module I’m going to hit the close button at the top and that’ll take me back now underneath print there are a few other options here’s where you can actually print that invoice out or print a batch and what a batch means is if you notice there’s a check box here that says print later if you’ve got several invoices created the ones that have the check mark if you choose the batch option those will be printed if you’re going to be shipping items here’s where you can create a packing slip a shipping label or an envelope these will do mail merges with Microsoft Word and then notice you can also save this as a PDF file you have the ability to email your forms in QuickBooks if you want to email this invoice to your customer you could just choose invoice here and that would let you email it if you want to email the batch all the ones that have the check mark that say email later would be included in that batch here you can attach a file you might have some file that you’ve scanned in or it’s a file that you can access in your computer and actually attach to this so that way you don’t have to go out of QuickBooks and search for those files and open them up they’re right here you do have an option to add your time and your cost we’ll actually talk about this over in the next video which is video number nine invoicing customers for products and services so we’ll hold that and you can also apply credits we’ll hold that one as well and talk about those in the next video and just to tell you what progress means if you wanted to see a timeline of I’ve estimated this job I created an invoice I received a payment that would show you the progress and you can see the
progress too as to how much you’ve actually pulled from that estimate here’s a way to receive a payment against this invoice chances are you’re not going to be on this screen when you want to receive a payment but you can do that you can also create a batch what that basically does is takes one invoice and allows you to send it to multiple customers maybe if you have three customers that are each going to pay a third then you’ll be able to send this to all three and there’s also a place for a refunder credit and we’ll talk about that a little bit later in this module as well I just want you to be familiar with those options because that’s where you’re going to find most of the things you’ll use on a daily basis we’ll look at some of these other tabs when we get over into the next video as well I just want to make sure here that you know how to actually pull all of the information from your estimates onto invoices once you’re finished go ahead and save and close and that’s how you’re going to create your invoices based on estimates let’s go ahead now move over to video 9 in this module and talk about invoicing customers for products and services hey there it’s Cindy again welcome back to QuickBooks desktop 2022. I want to go ahead in this video which is video number nine of module four and talk to you a little bit about invoicing your customers for products and services we’ve been talking about invoicing in the previous videos but that was actually taking estimates you’ve created and turned them into invoices not every business uses the estimate feature if that’s the case you would just start here and just start with the invoicing and go forward let’s move over to QuickBooks and I will show you how to create an invoice to create an invoice for a customer you’ll find the create invoices icon right here on your home screen the first thing you’ll want to do is go ahead and choose your customer and your job I’ll just choose Robert Allard remodel job make sure you choose the class if you’re using the class feature remember to use this consistently so that your reports are accurate you’ve also got an option to choose a template I’m going to use the default one we’ll talk about templates in a later module but you can choose different templates for each invoice you’ll want to make sure you choose the correct date that you’re creating the invoice and remember that invoices are numbered it’s going to number the next one sequentially unless you change that number invoice numbers can include letters if you’d like you just type those in you want to make sure you have the correct billing address for your customer as well each customer can have different terms I’m going to go ahead and say net 30 for this one and you’ll notice that if I choose net 30 the due date defaults to 30 days from this date here you can always change the due date if you want a specific date to be the date this is due here’s where you’re going to click down in the body of the invoice and you’re going to choose an item that you’re going to invoice your customer for you’ll see on this list these are the items that are already set up if you wanted to create a new one you would click on add new and we’ll go through that in a later module right now we’re just going to choose a couple of these we’ll choose floor plans and if you wanted to add a different description this will let you type as much as you want it will word wrap all the way down to the bottom let’s say that we’re going to charge our customer for two sets of floor plans and we’re going to charge a thousand dollars a piece you’ll see that it does the calculation for you when you tab over to the amount column and the last column tells you that for sales tax purposes this item is not subject to sales tax on the next line down I’m going to choose labor and I’ll add a description I’ll add labor for getting the kitchen to prepare for the remodel we’ll say it was a quantity of 30 hours to do that and we charge fifty dollars an hour you can see it did the calculation it’s 1500 for the total amount and this is also a non-taxable item and you can keep adding as many items as you like to this list a couple things to notice at the bottom on the left you have a place for a customer message there are some pre-built ones but if you wanted to add your own you would click on add new and create a new message to add to this list that you could use in the future underneath that it says memo that is strictly for you that memo will not print on the invoice and then you’ll see that this customer is subject to sales tax if you charge sales tax in your business if you wanted to change that you would change it to non-taxable sales on the right hand side if your customer is subject to sales tax you will see the tax they’re being charged the total for that tax if they’ve made any payments to this invoice you would see that right here you wouldn’t see any payments until actually this has been saved and then you’ve applied a payment and opened this back up and that’s when you would see if there were any payments applied and then of course the balance due right here all you need to do at this point is go ahead and save and close and if you’ve made any changes if you remember I changed the class up here and I also changed the terms it will ask you if you like those changes to be reflected in the setup just go ahead and say yes and now that invoice has been created let’s go to our Customer Center over on the left here just to look if I go ahead and click on Robert Allard you will see that there are now two invoices the top one is the one that we just did it was dated December 28th if I just want to see the invoices for that job then I would click on the remodel job on the left and see just those invoices if you want to open that invoice up just double click anywhere on that line and now you will see that invoice you can make changes if you need to and then save it and those changes will be saved a couple things I want to point out at the very top you’ll notice there is a main tab and this is the tab you’re going to use the most often there are several different items here that I want to point out first if you’re looking through your invoices for a particular one and you just can’t find it use these arrows to go left or right to look at the next or previous and if you still can’t find it you can click on this find option and then put in some criteria and QuickBooks will search for you here’s your new option if you want to create a new blank invoice this will save the one you’re on this is the exact same thing as if you came down to the bottom and clicked on Save and new next you can save your invoice if you’re working on this and it’s taking a while you can go ahead and just say save invoice you can also save this as a PDF file if you’d like here’s where you would delete that invoice you can create a copy of this invoice if you need to create another one that’s very similar you can go ahead and make a copy and then just change whatever you need to change and save it we’re going to talk about memorizing in a later module but what this would allow you to do is if you had an invoice that needed to go out once a month let’s say you can actually memorize it and QuickBooks will automatically create that invoice for you next month and then you can send it out you can also Mark this as pending and what that basically means is that if you have an invoice that you want to put in QuickBooks but you don’t want it to count in your numbers when you run reports you can do that it will be inactive and you can always turn it back on when you’re ready to activate it again let’s look at print preview so that you can see what this invoice will look like you can see this invoice actually has the company name and address it doesn’t have the phone number fax email any of that information so you probably want to customize this template you can see it has the word invoice on the right there’s the date the invoice number and then all the information about the invoice we’re going to customize in a later module I’ll go ahead and hit close at the top you’ll also notice that you can email this now notice there is a check box over here for print later and email later if you’ve got several that you’re working on you can check those boxes and when you’re ready to email all of them you can email the batch or if you’re ready to print them all you’ll see there’s an option for batchender here as well here you can attach a file if there’s some file that would pertain to this invoice and you don’t want to have to get out of QuickBooks and go find it you can attach it here and open it up easily here’s an option that we haven’t talked about yet add time slash cost if you’re doing job costing in your business that basically means that you want to make sure every transaction you enter is tied to a job then you can run job costing reports you could run a profit and loss for example to see how much you’ve made or lost on a particular job each transaction will have a place where you can choose the customer or job that it pertains to if you want to be reimbursed from your customer for certain expenses that you might have incurred when you create those expenses whether it be a check credit card transaction whatever it happens to be if you’ve told QuickBooks that it pertains to a particular customer and job then when you come into this invoice you can add time slash cost you can see that here’s the time tab if you had any time you’d created related you could pull that in here’s expenses if you had actually used a credit card and purchased something and tied it back to this job that would be listed you could check it off click OK and then that way it would pull in those expenses you’ve got mileage and also items I’m going to go ahead and click OK there you can also apply credits if you have an existing invoice and you’ve created a credit memo you can apply those credits right here you can also receive a payment for this invoice here chances are you’re not going to be on this screen you’ll probably be on the home screen but you can do it here you can create a batch and that means that if three different customers were going to pay this one invoice you could actually send this to all three customers and then also here’s refund or credit you would use this if the customer had already paid the invoice and you were going to issue a refund or credit memo for them to use for future invoice there’s also a formatting tab here I just want you to be aware that this is here we’re going to be looking at some of the options for customizing your templates that I mentioned over here a few minutes ago we’ll look at that a little bit later here’s your spell check if you want to insert a line delete a line or copy a line you can do that there’s also some options for sending and shipping if you ship items and you typically ship through one of these FedEx UPS or US Postal Service then you can set all that up right from here and the last tab has some different reports you can run related to invoicing most of the time you’ll be using that main Tab and that’s really all there is to actually creating an invoice let’s go ahead and click save and close at the bottom if you’ve made any changes you might want to go ahead and save those if it asks you and now that invoice has been completed let’s go ahead and move over to video number 10 now and we’re going to talk about receiving customer payments towards those invoices hey there welcome back to QuickBooks desktop 2022 this is Cindy we are all the way down now to video number 10 in module 4 and I want to show you in this video how to receive customer payments once you send an invoice to a customer and they pay you how do you actually receive that payment in QuickBooks let’s go ahead and flip over to QuickBooks and I’ll show you how to receive this customer payments when you receive a payment from a customer you want to go ahead and enter it through this receive payment window notice if you’re following the flowchart it’s the next thing after creating voices it doesn’t matter how the customer paid you it doesn’t matter how much they paid you you’re going to enter all of that information in this window if there’s a balance due QuickBooks will remember that the first thing you want to do is put in who the payment was received from if you’re using the job feature always click the job I’m going to say this is for Tom Allen’s sunroom as soon as you choose the customer job you’ll notice that any invoices that are still open for that customer job will appear at the bottom here and it will also let you know the amount that’s due just in case something had already been applied to this you’ll also notice in the top right this is the customer balance the next thing you want to do is put in the amount that the customer paid you I’m going to say in this case it’s 3193 dollars and I’ll leave off the sixth sense just to show you what happens when there’s an over or under payment if you noticed at the bottom this appeared now because it says I have an underpayment of six cents and it’s asking me what would I like to do with that I can just leave it on their account which is what I’m going to do in this case hopefully they’ll pay me next time or if you know you want to write it off you can go ahead and do that with this option right here the other thing to notice is that QuickBooks automatically assumed that all of the first invoice would be paid in full and the balance would go to the second invoice you want to make sure you apply payments correctly because if not six months down the road you’re going to end up with a situation where your books don’t match your customers books if you need to uncheck one of these or if you need to check one you can do that and you can also type over here how much the customer has specified that you apply to each invoice always choose the correct date of the payment and you also have a feel for the reference number over here you’ll notice this is a way to tell QuickBooks how the customer paid you did they give you cash did they write a check you can see that based on which option you choose this may change when I was clicked on cash this said reference number and that would just be any reference number I’d like to pop in there but notice when I click on check it gives me a place to put in the customer’s check number if you click on Visa you’re going to see that it pops up and asks you to enter the card information if you’re not using the Intuit merchant services then you don’t really need to fill this in because you’re not running their card through in QuickBooks it would just be a matter of you keeping that information for your records I’m going to cancel that there are some other options here notice there’s a down arrow that has a few payment methods listed it could be the customer Bartered this with you but if you need to add a new payment method just click on new payment method here and then put in the method they paid you with I’ll add sell to the list and I’ll just say that the payment type is cash but notice my other choices here I’ll just click OK and now that will be on my list for any customers that pay me with zazelle now let’s take a look at some of your options up here under your tabs you can see that we’re under the main Tab and a lot of these options you’re already familiar with you know how to find a customer payment if you’re looking for one here’s a way to create a new customer payment that’s the same thing as that save and new in the bottom right here’s a way to delete the payment you could also come over here and print the payment I’ll just show you what that looks like if you’re going to print the payment it does ask you what you’d like your payment receipt template to look like you have the ability to customize this if you wanted to do that you would click on customize template down here but right now this is what it’s going to look like I’m going to go ahead and say not now and preview this so that you can see here’s what the payment receive actually looks like you can see it’s a little different than an invoice or an estimate it has a place for the date of that payment and also the payment method and you can see where this was a check number and they have that check number in there over on the right is the total amount of the payment and the invoices listed that it paid below I’m going to go ahead and close the next thing I’ll point out is the email option if you want to email that payment receipt you can do that and email it to your customer here’s where you can attach a file you can also look up a customer and an invoice if you click on that this will allow you to search right here it says invoice number and I could search for any customer that has a particular invoice number but I could also search by one of these options as well if I wanted to unapply a payment that basically is going to uncheck all of this see how these are unchecked now I’ll just go back and check them and then if there were any discounts or credits that you’re going to give your customer related to this you could go ahead and enter that now you would enter the amount of the discount you’re going to give the discount account and then a class if you happen to be using that this process payments just allows you to process a credit card payment if you’re using the Intuit merchant services here’s where you could sign up for that if you wanted to check out the options you do have a formatting tab in the back you’ll notice a couple of things here for the payment receipt we saw a few moments ago you can go through and actually use the standard one here or customize it there’s also a tab for reports if you wanted to look at open invoices for this customer or some of these other reports that you see right here you could do that and the last tab over says payments if you wanted to check out again the credit card processing from Intuit you could do that most of the time you’ll stay under the main tab before we save this let’s go ahead and go to the bottom right and you’ll notice that it tells you the amount due how much was applied and if there were any discounts and payments applied here all you have to do when you’re finished is go ahead and save and close and if you’ve made any changes to your transaction you can go ahead and say yes if it asks you if you want to record your changes and that’s how you’re going to receive payments for customers now before we leave let me go ahead and go back to the customer center I’m going to click on customers and if you notice I’m on Tom Allen’s sun room over here and you can see there’s the estimate we created the two invoices we created and then there’s the payment right there if you need to make a change to that payment or open it up to look at it for any reason just double click on it and then you can look and see what’s going on with this payment there is one quick thing that I wanted to mention there’s a question here that says where does this payment go let me just show you real quick where the payment’s going to end up I’m going to go back to the chart of accounts I just clicked on home over on the left here and I’m going to the chart of accounts you’re going to see an account called undeposited funds you’ll see it right here that money that we just received for that payment is in this total right here let me open this up so you can see it here it is right down here at the bottom something to know about undeposited funds these are monies that you’ve received but you have not yet taken to the bank as far as QuickBooks is concerned it’s not a deposit in your checking account one of the ways to keep a check on yourself is this should always say zero if you’ve already deposited all of the money now how does that get to zero well we’re going to talk about that when we talk about recording deposits I’m going to have you go ahead and head over to video number 11. we’ll talk about payment links and then when we get to video 12 we’ll be going through the deposits right here so you can see how that money gets out of undeposited funds and into the actual checking account hey there welcome back to QuickBooks desktop 2022 this is Cindy we’re working through module four and we’re down to video 11 now I want to talk to you about a new feature that QuickBooks has that will allow you to send your customer a link the customer can use that link to go to a secure site and actually send you a payment you can use this whether you’ve invoiced the customer or not it could be that you need to get an advance payment for something you can just send this link via email and have the customer pay you the money will actually be deposited to your account within two to three business days let’s go ahead and flip over to QuickBooks and we’ll look at those payment links this new payment links option is going to be a really great tool to help you collect payments before you even send an invoice if you require down payments in your business this is a great way to email your customer a secure link they click the link they go to a secure site that lets them put in their debit or credit card information and then you receive the funds automatically through direct deposit into your bank account within two to three business days in order to access the payment links option you need to go through the menu and click on customers and then you’ll see payment links the first thing you’ll need to do is decide if you’d like to actually set up what they call a QuickBooks payment account or if you want to use pay as you go the QuickBooks payment account that you see on the left here is a merchant services account you would pay a monthly fee for that whereas the pay as you go is good if you don’t accept a lot of down payments but you want to use this feature whenever someone needs to pay you I’m going to use the pay as you go option and click get started QuickBooks will want a little bit of information from me before it takes me over to the screen where I set up the payment link you can see there’s business info personal info and deposits account info I’m going to start with business info and just click on start and answer a few questions the first thing QuickBooks is asking me is what is the business type and this is where you’re going to pick one of these options that you see here the next thing it asks you is do you have a particular industry or you can pick one that happens to be the closest match I’ll pick the first one accounting auditing and bookkeeping services you can see it did bring in the business name I would also want to put in the website and that’s an optional thing notice my address is already in I don’t have a state so I’ll go ahead and choose that and then you’ll notice that there’s a place to put in your business email I’ll just go ahead and put mine in the next thing you want to do is when you scroll down you’ll see that it actually takes you to the personal info here I’ll click on start and here’s where you want to put in the owner’s first and last name some of your personal information date of birth social and all this is required to set up the account I’m not going to put this in now but you would put it in and click next the last option down the bottom is the deposits account info when you click Start here what this allows you to do is go ahead and add your bank account here’s where you put in the account number and the routing number and then click save I’m going to go ahead and finish setting this up off camera and then I will come back and I’ll show you how to set up that link I went ahead and closed that window because I wanted to show you that once you get out of that window you won’t see that same screen again when you’re ready to actually send that link now all you have to do is go back to customers and back to payment links and what you’re going to see this time is that it’s going to connect you to your Intuit Payment Solutions account which you just created and here it will allow you to go ahead and create that payment link from this button right here I’m going to go ahead and click on that the first thing you want to do is put in the amount of money that you’re wanting to get from your customer and you can put in a product or service or some kind of description right down here so you might say that’s down payment for kitchen remodel here’s where you’re actually going to put in the name of your customer and you can put in your customers email you’ll see here at the bottom that you have the ability to choose the ways that you’d like to get paid if you want to give your customer the option to pay you with a credit card or a bank transfer you can leave both of those selected if you don’t want one or the other just slide this to the left and then that option won’t be available all you have to do now is send the payment link the customer is actually going to receive this they’re going to be able to click that link and pay you and the money will show up in your bank account within two to four business days and that’s how that new payment links feature Works in QuickBooks now that you know how the payment links work in QuickBooks let’s go ahead and head over to video number 12 and we’re going to talk about how to make deposits in QuickBooks now that you know how to receive payments in QuickBooks let’s talk about how to take that payment you’ve received and actually make a deposit so that it shows up in your checkbook register hi this is Cindy welcome back to QuickBooks desktop 2022. we’re going to talk in this video about making deposits in QuickBooks if you’re invoicing customers and receiving payments then most of your deposits will be from those payments you received sometimes though you might have a deposit that’s just strictly something you’re putting into the bank let’s go ahead and flip over to QuickBooks and look at making deposits when you look at the flow chart the last thing you did was receive a payment from a customer following the flow chart to the end you’ll see the next thing is to record your deposit and that’s what you want to do let me just mention that new in the QuickBooks 2022 there’s an icon that says merchant service deposit this has to do with your online banking that we’ll talk about in module seven so we’ll hold this until we get there I’m going to have you follow the flow chart all the way across let me mention a couple of things that I want you to be aware of when you’re making deposits when you were in this receive payment window one of the things that happened is you had an option of where to put your money remember that if you have not turned on the preference telling it where you’d like to put the money this money will automatically go into an account called undeposited funds and that’s what this question is asking you right here if I go back to the chart of accounts I’ll just show you that real quick undeposited funds is actually an account where money sits that’s been received but not deposited yet one of the ways to check yourself is if you have money sitting in here but you know that everything has been deposited then you’ve done something wrong and you can see currently there’s fifty six hundred and thirty three dollars sitting in that account the other thing I want you to be aware of is once you receive your payment do not go over here to the checkbook register and type in that payment the reason is you’re bypassing the record deposits window that money will stay in undeposited funds if you put it directly in the register the other thing is if you’re typing in the register you will have to tell QuickBooks which account in the chart of accounts does this go back to most people will pick accounts receivable which is wrong because you’ve already been there done that or they will pick one of the income accounts and if you do that you’re doubling your income so this will mess you up every time do not do it this way follow the flow chart all the way to the end I’m going to click on record deposits this is a listing of all the payments you’ve collected that went into undeposited funds what you want to do is any of these that actually were deposited into this account you want to check off I could check off the first two for example and now I have a deposit for two thousand four hundred forty dollars if I click OK you’re going to see it pulls in those two payments if by chance you pulled in the wrong ones you’ll notice right up here there’s a button that says payments you can click on and you can check or uncheck these you want to make sure this matches the actual deposit that went into the bank do not come in here and change where it says from account because this is where the money actually came from it came from undeposited funds you can see that it tells you who the money’s from the account over here if it was a check and you had typed in the check number you could pop that in if you forgot to put in a check number just type it right in here there’s your payment method the class and the amount over to the right if you needed to add something to this you could you would just click on the next line down and add it what if you as the business owner wanted to put some personal money into the business account you could do that here remember here’s your chart of accounts and you would just pick the correct account in a situation like that don’t pick an income account because it’s not income to your business this is where you’d want to use one of those owner accounts that you set up it could be the liability or if you wanted to use it as a owner draw you could do that as well in this case they actually call it Capital stock right here you can go ahead and put in a memo if you’d like and then go over to the amount column and put in the amount that you’re depositing you could be actually putting in a rebate if you were doing something like that you would want to choose the account that the money actually was expended from to begin with let’s say it was an office supply you would put it back to office supplies just make sure that you recognize everything that you put here is not income you’ll notice at the top make sure you have the correct account you’re depositing the money to because it’s very easy to put it in the wrong account and it doesn’t show up in your checkbook register and then make sure you have the correct date of the deposit there’s also a place for a memo right here it usually defaults to the word deposit but you can change that to anything you like down at the bottom left you’ll see a couple of things there is a field where you can keep some money from this deposit if you’re a sole proprietor and tell QuickBooks which account that money goes back to there’s a place for a memo and the amount and it would subtract it from your deposit total down here at the bottom let’s go back up and look at a couple of options you have at the top here’s your next and previous if you wanted to actually go through and look for a specific deposit you could do it that way you could save this you could also go through and print a deposit slip that you can actually take to the bank or deposit summary we talked about the payments button and let me just talk to you about the history button for a moment this deposit will have a history once you save this you can see right now it does not but once I save it I can go back and look at the actual payments that were received and from there I could go back and look at the invoices that were all related to this deposit I can also attach a file here if I’d like I’m going to go ahead down to the bottom and a saving close and this deposit for three thousand four hundred and forty dollars will now show up in our checkbook register let’s just go to the checkbook register and see if it’s there I’m going to choose my checking account and click ok and now you’ll see there’s your deposit right there that we just made of three thousand four hundred and forty dollars the blue line just means it’s post-dated so don’t worry about that we’re going to look more at the register in module 7 but for now I just want to make sure you know how to correctly enter a deposit the other thing I want to mention is that if you had a deposit that was not related to an invoice or payment you received you could just type it directly in the register just make sure that you have the correct account chosen from this list and again like I said we’ll get into this a little bit later but that’s how you make deposits in QuickBooks let’s go ahead now and go over to the next video number 13 and talk about how to create credit memos in QuickBooks hey there welcome back it is Cindy we are working in QuickBooks desktop 2022. we’re down to video number 13 in module 4 now and I want to talk to you a little bit in this video about how to create credit memos for your customers you might have a customer that returns a physical product and wants a refund or it could be that you just want to issue a credit towards their account either way we’re going to go through this whole creating credit memos process for you let’s go ahead and flip over to QuickBooks and we’ll see how to get those started when you’re creating a credit memo or refund it’s important to go back to that invoice and see exactly what it is you’re crediting or refunding and the amount you can do that a couple of ways we’ve been working with Tom Allen let’s go ahead and go to the customer center I have it open here on the left here’s Tom Allen’s sunroom and you can see here’s the invoice I’m going to go ahead and open that up because I want to show you that Tom still owes six cents on this invoice and I will go ahead and issue a credit memo to write that off since it’s been hanging out there for a while the other thing I want you to notice is I’m going to show you how to return an item to inventory if they return something and give your customer a refund you can see here is the exterior wood door it’s a thousand ninety dollars and 39 cents I’m going to go ahead and close that because I want to jump ahead and show you one other way that you can look to see how much is owed on an invoice we’re going to jump ahead here we’re going to talk about reports in module 11 but let me show you a very quick report that you can run if you go up to reports on your menu go down to customers and receivables and you’ll see one called open invoices this is going to be any invoice that has a balance even if it’s just a penny when I look at this report I don’t see Tom Allen on the list and that’s because I’m only looking at invoices that are due before December 15th if you come up here and change this date then click inside the report that will update it and you can see now that here’s Tom Allen’s sun room there’s that invoice we just looked at and he has a sixth sense once we create the credit memo and apply it this will disappear from this report let’s go back to the home screen and I’ll show you how to get started issuing that credit memo or refund you’ll see right down here it says refunds and credits the first thing you want to do is pull in your customer and your job I’ll pick Tom Allen’s sunroom you want to make sure you choose the class if you’re using a class feature in this case it’s new construction and here are the different templates you could use we’ll be looking at templates in a different module so we’ll leave that for now make sure you change the date to the date that you’re issuing the credit memo it’s going to pull in the next credit memo number you can change that if you want to but it numbers sequentially and of course you want to make sure you have the customer information correct which it should be at this point here’s what you’re going to do down here where it says item if your customer is returning a physical item or you’re wanting to credit a particular item you want to choose it from the list if it’s something like the sixth sense that’s just hanging out there and I want to write it off my books that’s called bad debt and that is an item they have already set up in this list here I’m going to type it in so that it’ll save us a little time here and anytime you have bad debt it will pop up and give you this warning telling you it’s associated with an expense account you can just click OK and get past that you’ll notice the description that comes up says bad debt or write-off amounts you can edit that to say anything you want but you want to go ahead and make sure that when you put this in you put a quantity of one and you want to make sure you have the exact amount you’re going to write off and make sure this says non-taxable here because if you charge tax you’re actually going to end up with another credit so make sure that it ends up being exactly six cents at the bottom like this says and that’s really all you have to do for this you can go down to the bottom and add a customer message or a memo if you want on the left a couple things at the top you’re familiar with most of these already but here’s where you can search if you want to look for a particular credit memo use the arrows or your find feature if you want to create a new credit memo you can click here that’s the same thing as saving new down at the bottom here’s your save option notice you can save it as a PDF if you choose to you can delete this make a copy memorize it I think you’re familiar with most of these we’ve talked about them in previous videos the only thing that’s a little different that I want to point out is notice because it’s a credit memo you now have the ability to use this to give them a refund or apply this to an invoice in this case we’re trying to wipe out the sixth sense that’s still open I’m going to use it to apply to an invoice you’ll notice that any invoice that’s open will appear here if there’s an exact match it will actually check it off and that is the one I want to apply it to so I’m going to click done at the bottom and saving clothes now let’s go back over to the open invoices on the left you’ll see it says refresh needed indicating that a change has been made to that report and when you look at this notice it’s still February 3rd so Tom Allen’s should show up at the top of the list and you can see that it’s gone because it is paid in full now let’s go back and look at a refund for Tom I’m going to go back to home and refunds and credits again now this time Tom is actually returning one of the wood doors so we’re going to give him a refund go ahead and choose the customer in the job make sure you check everything out over here I’ll go ahead and change this date this time what I’m going to choose is that exterior wood door that we originally invoiced him for and you can type anything you want in this description area you want to make sure that when you put this in you have the correct amount that you charged him for to begin with this one was a thousand ninety dollars and thirty nine cents and we did charge sales tax and that’s all you have to do now at the top you’ll notice that there is an option that says use credit to give a refund I’m going to click on that and it pulls in all of the information you’ll probably want to check the date here and make sure that it has the date that you’re issuing that refund the other thing is how do you want this refund issued via a check do you want to put it back on their Visa card I’ll go ahead and just choose check and you can see there’s the ending balance in the checking account so make sure you have the correct bank account chosen there and the correct class that this goes to and that’s all you have to do this means you’ll be able to print the check but once I click OK this check is actually going to be in the register I’m going to change this date again to make sure I have the correct date here I’m going to go ahead and click OK and now that check is in the register I’m going to hit save and close at the bottom and let’s see how this looks let’s go to our check register I’ll just go right over here and I will open up checking and there is the check that you just created all you have to do now is go in and print it and you are good to go that’s how you’re going to create credit memos and refunds for your customers let’s go ahead now and go over to video number 14 and we’ll talk about creating statements that you can send to your customers at the end of the month so they know exactly how much they owe hey there welcome back to QuickBooks desktop 2022 my name is Cindy and we are all the way down now to module 4 and we’re talking in this video which is number 14 about how to create statements in QuickBooks a statement is basically a history of what happened that month that you can send out to your customers usually you send statements at the end of the month you do not have to send statements but it’s really a great way to gently remind your customers if they owe you money that they need to pay let’s go ahead and flip over to QuickBooks and I’ll show you how to create those statements to get started creating statements for your customers head over to your home screen and click on the icon that says statements the first thing you need to let QuickBooks know is what is your statement date typically statements are sent the end of the month I’m going to set this for December 31st and the statement period would be that same month the beginning of the month through the end of the month but you can also choose whatever date range you would like notice also as far as dates are concerned that you might choose this option here to just include all the open transactions as of that statement date and you will have an option to include any transactions over in this case 30 days past due and you can see you can change that it will default to sending statements to all of your customers but notice you could choose multiple if you choose multiple customers then you click this choose button and you just click on the customers you’d like to send a statement to if you’re wanting to send a statement to One customer choose the One customer option and then you can choose that customer from the drop down list you can also choose to send statements to customers of a particular type that you might have set up or only ones that have a preferred send method maybe they like their statements mail or emailed when you’re through you can always preview what your statement looks like at this point I’m going to hit the preview option and here’s what your statements look like I’ll just click in the middle to zoom in you’ll see it says statement right up at the top it has your company name and address and then of course the customer’s name and address here and notice at the bottom it has the balance forward from the previous month and then any transactions that occurred that month will show up on this statement whether it’s an invoice a payment at the bottom you’re actually going to see for each of these categories the amount that’s due I’m going to hit close at the top and show you some other options you have for statements over on the right you do have template options you can change for your statements we’ll cover that in a later module but notice some of the check boxes here you might not want to see any of the details or you might want to show them you can check or uncheck that option you can choose to print statements by their billing address ZIP code this would actually sort them numerically by ZIP code it’s going to print the due date automatically if you don’t want it to do that just uncheck that option you might choose to not send statements to your customers who don’t owe you money that would be this option here or if they owe you less than let’s just say five dollars maybe you don’t want to send a statement you could actually check the box and choose that amount there if they didn’t have any activity you might not want to send them a statement or if they’re an inactive customer you might not want to send a statement if you’re assessing finance charges you do have the ability to click here and set all those options up for the finance charges after you’ve previewed this you can print these if you’d like and send them through the mail or if you’d like to email them you can do that as well there is an option now also to automate sending your statements this way you don’t have to remember to manually go in and do this every single month let’s go ahead and click on go to payment reminders now that you’re in the payment reminders window the first thing you’ll want to do is create a schedule for these statements up here at the top there’s a drop down and you’ll choose statement from the list the next thing you want to do is tell QuickBooks to send reminders to whichever customer group you have set up if you do not have a customer group set up you can choose add new from here and create one but we’ll just choose commercial customers for now once you have your customer group set up you’ll want to click on add reminder and then fill in some of these options the first thing I’d ask you is what is the statement date you’d like to have on your statements so you can set it for a particular date you can say every week every month every quarter we’ll just go ahead and set this for the first of every month the statement period let’s go and include the previous month if you’re setting this for the first then you’ll want to include the previous month on your statement notice you could also generate a statement for any of these transactions that are open or overdue you just choose whichever option you want I’m going to go back and say statement period for the previous month the next thing it asks you is which invoice details do you want to include notice you can include all the details from each of the transactions you’d include a memo if you’d like and a due date I’ll just go ahead and choose a couple of these the next thing QuickBooks ask is how would you want your statements to look if you’ve chosen different statement templates you can choose them from the list here notice you can also go ahead from here and customize one and we’re going to talk about customizing in a later module the next thing is the email template if you’ve got some set up you’ll see them on the list if not you can go ahead and edit or create one from here and the last thing QuickBooks wants to know is if you want to separate your statements by each job that you’ve done for your customer once you’ve chosen your options go ahead and click on OK and now the statement reminders are set up and every month on the first it will send those out automatically for you that’s really all there is to creating statements for your customers let’s go ahead now and move over to video number 15 and I’ll show you how to use the income tracker in QuickBooks hey there welcome back it’s Cindy again we’re working in QuickBooks desktop 2022. we’re on the last video in module four this is video number 15 where I want to take a few moments and just introduce you to the income tracker that’s available in QuickBooks the income tracker is going to allow you to see on one screen any invoices you’ve sent out that haven’t been paid what has been paid if you have expenses you’re going to be able to see all that in one screen let’s go ahead and flip over to QuickBooks and I will show you how the income tracker works when you’re looking at the home screen you will not see an icon for the income tracker the easiest way to access it is to look for a button that says income tracker here or if you have it on the left you’ll see it I’ll go ahead and click on the income tracker and this is what it looks like this is showing me a list of all the transactions I have set up and you’ve got different ways you can sort this list but I want to show you at the very top across here it shows you that you have so much that’s unbilled meaning that you have estimates you have it turned into invoices yet you’ve got so much that falls in the category of time and expenses related to these jobs here it tells you how many open invoices you have these are invoices that have not yet been paid and how many of those are overdue and this last option here will show you how many were paid in the last 30 days on this next row you can add some filtering options currently I’m looking at all the customers and jobs but if I only want to see a particular customer and job let’s say Christy here then you can see it narrowed the list for me all will always be the Top Choice on the list if you want to see everything the next thing is the type of transaction do you want to look at just invoices do you want to look at any payments you’ve received you just choose the options that work for you the next thing is the status do I want to see invoices that are open overdue or paid or all and then of course you have a date option over on the right hand side where you can see anything this year the last 90 days those are some of your choices there for each of these you can go down the list and check off a particular transaction let’s say that it’s Brian Cook’s invoice on this line right here you’ll notice all the way to the right I have some options where I can go in and receive a payment for that invoice right from this window I can print this row or email this row if you’re on a line that has an estimate you’ll notice that your options are a little bit different I can convert this estimate to an invoice Market is inactive or go ahead and print or email that row so this is a quick way if you just want to go down the list and receive several different payments or if you want to just look and see how many estimates you have there’s all kinds of information that you can actually see from this window another thing I want to point out is let’s say you have several of these selected you can do what’s called a batch action down at the bottom you can actually click the arrow next to batch actions and you can choose invoices or if you want to batch email them you can do that as well you can also see the managed transactions options over here so if you wanted to go to sales receipts or receive payments you could do that take a few minutes and look through this because it might make things a lot easier for you than just hunting for the correct icon and entering things one at a time just an option I’ll go ahead and close the income tracker here and that actually wraps up module four let’s go ahead now and jump over to module 5 and we’re going to talk about working with the vendors hey there welcome back it is Cindy again we are talking about QuickBooks desktop 2022. we’ve made it down to module 5 now and this is the module where we’re going to discuss vendors vendors are people or businesses that you buy from sometimes you buy inventory sometimes you buy a service but anyone you buy from is considered a vendor I wanted to take time in this first video and give you a little bit of information on how to set up your vendors in QuickBooks let’s head on over and to set up some vendors just like with customers we had a customer center we also have a vendor Center you can access it from the home screen by clicking here where it says vendors you can also go up here and click on vendors or if you want to go to vendors from the menu you can do that as well I’m going to the vendor Center this is a list of all of your vendors in alphabetical order you can also see the balance that you owe that vendor if you’ve put in bills that’s the only way you’re going to know a balance and also notice there’s a column where you can attach a file over here you’re currently looking at all of the active vendors if you drop the list down you can see that if you just want to see the ones with open balances you can do that you can also look at all the vendors that would include any that you had made inactive as well I’ll just click on the active vendors whichever vendor you have selected here on the left you’re going to see information about that vendor over on the right you’re going to see their company name you’re going to see their billing address phone number fax email all the same information that we saw when we were looking at the customer center you’ve got a map to their location and directions here and over on the right you can see that if you wanted to run a couple of reports for this vendor like a quick report or an open balance report you can do that as well notice the option to order 1099 forms from Intuit if you want to but you don’t have to order them from into it you can buy them anywhere you like or if you want to order checks from Intuit you can do that right here here’s where you would go up and attach a file this would be any file that you want related to this vendor it could be a bill that you’ve made a copy of and if you want to edit the information for that vendor you would choose this option right here down here at the bottom you’ll notice under the transactions tab you’re looking at all the transactions related to this vendor the types of transactions you’re going to see here are going to be bills you’ve entered purchase orders if you’re using the purchase order system any what we call Bill payment checks you’re going to see all of those listed here you will have options to sort or filter this list you can see that right now you’re filtering it by all of the transactions but you can also filter it by a different date range if you’d like the next tab over has all of your contacts related to this vendor you have any to Do’s related to this vendor under the to-do’s tab and then any notes related to this vendor you’d be able to enter those here also if you’ve sent any emails through QuickBooks to these vendors then you would see them listed here as well what I want to do now is take you in and show you how to actually enter a new vendor what you’re going to do is right up here at the top where it says new vendor you’re going to click and you’re going to enter a new vendor the first thing you want to do is put in the name of the vendor we’re going to say this vendor’s name is Smith painting and you’ll see there’s a place to put in the open balance this field is set up so that you can put any money you owe the vendor as of your start date you can put that number in here as a starting balance I suggest that you don’t put anything here and you actually put in the bills that you still owe as of your start date that way you can go back and look at them at any time the first thing you’ll notice at the bottom here is we’re under the address info and this is where we’re going to put in the address the phone number things like that this is Smith painting now I know we have Smith painting already up here but remember that if you’re going to do mail merges with Microsoft Word it’s going to pull from this field so you want to make sure you’ve got information there if you wanted to put in a name for a particular person there you can do that we’ll say this is Randy Smith if you want to put his job title in there you could do that we’ll say he’s the owner and then you can see there are fields for the phone numbers the faxes emails website and all of these fields can be changed if you want them to represent something different down at the bottom where it says build from this is going to be the billing address that is set up for this vendor I’ve got Smith painting in here I might put in attention Randy Smith and then go ahead and put in whatever Randy’s address is the next tab over to the left is the payment settings tab the first thing that it asks you is do you have an account number with this vendor if you don’t have one just leave that blank what are the payment terms for this vendor we’re going to say net 30 in this case notice there’s a field also so that you can put in the name that the vendor wants printed on their checks this would be the payable to field if the vendor gives you a credit limit you can put that in here and also a billing rate level this means that if you happen to do certain things for this vendor at a particular rate and other things for a different rate you can set those up the next tab I want to point out is the tax setting Tab and this one’s really important if you have 1099 contractors these are not employees these are people that you call in to do special projects they need to actually send you a bill and then you pay that bill that’s the correct way to handle that if you have 1099 vendors you want to have their tax ID in here and also check the box that they’re eligible for 10.99 if you do not do this when it’s time to print 1099s they will not get a 1099. the next tab on the left is account settings if you know that every time you create a check or some type of entry for this vendor there is a certain account for the chart of accounts you want this to go to then you can pick from the list you can assign up to three of these and that way you don’t have to choose those accounts every time you’re working on a transaction and the last tab is additional info if you want to categorize your vendors you can do that you can see there are several different types here I’ll just pick subcontractors and also there are custom Fields over on the right if you want to create additional custom Fields come down to Define fields type in whatever you want that field label or name to be and then check off whether you want that field available for customers vendors and or employees I’m going to click OK and we should see Smith painting in our list you can see it right down here it’s in alphabetical order once we create our first transaction for Smith painting then you will actually see a balance and then you’ll see those transactions show up over here under the transactions tab while we’re in this window I do want to mention a couple things notice if you go up here where it says new transactions there are several different options here you can enter bills pay bills create purchase orders you can see the list but chances are you’re not going to be on this screen when you want to create those transactions you can also come up here and you can print your vendor list you can also export this list to Excel or you can import a list of vendors you have from Excel already you can also do mail merges with Microsoft Word those are some of the options you’re going to be able to do when you’re working with vendors now that we know how to set up vendors let’s go ahead and move over into the second video and talk about how to enter bills in QuickBooks using these vendor names hey there welcome back to QuickBooks desktop 2022 my name is Cindy we are working in module 5 and we’re talking about vendors in this module this is the second video where I want to talk to you a little bit about how to enter bills in QuickBooks bills come in the mail that you have to pay they could be emailed to you but it’s something you know that you’re going to have to pay at a future date you could enter that bill so that you could run reports at any time and see who you owe if you’re on the 30-day overdue category just different things that you’ll want to know about upcoming expenses that you have let’s go ahead and flip over to QuickBooks and I’ll show you how to get started entering bills when you’re looking at your home screen you’ll see this section here is your accounts payable section anything having to do with bills paying bills purchasing inventory things like that will show up in this section when you’re entering bills if it’s just a normal Bill like an electric bill for example you would start here if your business deals with inventory and the purchase order system then you would actually start here and follow the flow chart all the way across to this enter bills button right here you can see from there the flowchart would go this way before I get started I wanted to mention that a lot of people don’t enter bills in QuickBooks they just have them on their desk or know that they’re due and they’ll go ahead and make that payment and enter the payment in QuickBooks that’s certainly okay your accounting will be correct but if you need to forecast your expenses you will want to use the enter bills feature that you see right here and enter all of your bills you will have some things that are automatically deducted like a car payment for example you might not think to enter a bill for that but I would go ahead and do that because it’s part of your forecasting of your expenses for the next few months anything you want to show up in those reports you want to put in the enter Bill section right here let’s go ahead and start with the inter bills and let’s say that our subcontractor Smith painting has sent us a bill for some work that he’s completed he expects to get paid you can see I typed in SM for Smith’s painting and it popped up I could also click the down arrow and choose that vendor from the list if it’s a brand new vendor that you haven’t entered yet you’ll notice at the top of this list it says add new that keeps you from having to go back to your home screen and enter them through the vendor Center you could do it right from here once you click down in the address section you’ll see that the address appeared if you needed to edit that you could edit it right here and once you save this transaction QuickBooks would let you know that it’s going to change it permanently for you ‘ll notice right below that it says the terms are net 30. that’s because we set up the terms of net 30 when we set up the vendor over in the vendor Center if you notice over here it pulls in today’s date and the build date is 30 days from that date what you want to do is put in the correct build date that means if you have a paper bill in front of you go ahead and put in the date it was printed you will want to make sure that the bill due date is correct in a case like that you can go ahead and change that to 30 days or if it says specifically on the bill that is due on a certain date then you change that because this date here is important so when you pull reports you’ll know when things are actually due this reference number would be the number that is on the bill then you have the amount to do we’re going to say it’s 500 dollars you also have a place to put a memo if you’d like you’ll notice down the bottom there are two tabs there is the expenses Tab and there’s the items tab when you’re finished these two tabs have to Total this amount due to the penny or will not let you save it you’ll notice under the expenses tab if you click on the first line this is your chart of accounts you can choose whatever account you’d like to put this to if you have subcontractors then you probably have set these up as a cost of goods sold and you can pick any one of these I’ll just choose subcontractors the next thing you’ll see is the amount this is five hundred dollars for this one account but this can be broken up into as
many accounts as you like if some of the money went to a different account you would just click on the next line down and choose that account and that amount from the list the other thing I want you to notice is there’s a place for a memo and also very important if you are tracking job costing your business you would want to choose the job the customer and the job that this particular expense needs to relate back to if you’re using the class feature you can see that the class option is here and I’ll go ahead and pick remodel now this little box that says billable in the middle here when we talked about invoices there was an option to pull in any expenses that you had incurred relating to this particular customer job that you wanted to be reimbursed for if this is checked then you’ll be able to do that now I do want to mention the items tab over here when you look at items these are physical products that you sell in your business if you are purchasing inventory for example you’ll want to make sure that you pick that particular product from this list so that it goes into your inventory count if you don’t do that and you just say it’s an expense over on this tab then it will not show up in your inventory I’m just going to choose expenses and I’m choosing the subcontractors in this case and I’m going to go ahead and save and close and now that bill has been entered now let’s go back and look at a couple of things first of all I’m going to my vendor Center up here and I’m just going to go down and pick my vendor which is Smith painting and when I click on Smith painting on the left now you’ll see the bill that I entered for Smith painting I’m going to double click and open it back up and there you’ll see it over on the right hand side of your screen you can actually hide this history or if you want to show this history you can basically what it will do is just give you some history like it says of this particular vendor you can see there’s a summary if there was any purchase orders that needed to be received here’s the bill we just entered you won’t see this until it’s saved but since this was saved and we opened it we now see that bill and any notes we had entered down here I’m going to hide that for a few moments and let’s look at a couple of options we have up at the top I want to point out that this is a bill but sometimes a vendor May issue you a credit we’re going to go for vendor credits in video number six of this module but just notice that option a lot of these options on your icon bar you’ll already be familiar with you know how to search you can go backwards or forwards and search for a particular bill you can also hit find and put in some criteria this new option would be the same thing as the save and new Option at the bottom right of your screen and of course if you’re working on this and you’re not finished you can hit save so that you don’t lose any of your information if you wanted to delete this bill this is where you would delete it you could also just avoid it meaning it would stay in the system but it would be voided and the amount due would be zero if you had another bill you wanted to enter that was very similar to this one you could create a copy and then make those few changes on that copy we’re going to talk about memorizing in a later module but if you have a bill that you need to pay on a repetitive basis the car payment is a really good example you pay it every month on the first of the month you could enter that bill one time and then QuickBooks would automatically enter it each month for you because it was memorized here’s where you can print this you can also attach a file here if you had a physical paper bill that you want to attach to this you could do that so you could open it up from here if you need to look at it also if you’re working with purchase orders and you happen to have chosen the wrong one you can go ahead and select the correct one from here and if you needed to enter some time associated with this you could do that this would go into your job costing and we’re going to talk more about this in a later module clear splits that basically means that if you have multiple lines of accounts chosen for example or items you get to clear that and start over you can also calculate or upload and review your bills this is a new feature right here where QuickBooks will actually try to match a bill that you might have as a PDF file for example and we’re going to look at this over in the next video which is number three and of course you can pay your bill from here chances are you’re not going to be on this screen when you’re ready to pay this bill but you can if you happen to be here there are a couple of reports I just want to mention and we’re going to go over reports in a later module but if you wanted to run some reports just on bills you can look at the transaction history here and that would actually show you if there were any payments made towards this you could see that history there you could run an item listing which would just list all of your items if you had some quantity on hand things like that that you might need to know you can look at open purchase orders your vendor balance detail for every vendor you can look at unpaid bills and you can also look at purchases by vendor in a detail format I’m going to hit save and close at the bottom and that’s how you’re going to enter bills and QuickBooks let’s head on over now to video number three in module five and I want to show you a new feature where you have the ability to upload and review your bills right here in QuickBooks hey there welcome back to QuickBooks desktop 2022 my name is Cindy and we are working now in module 5 where we’re talking about the accounts payable function in QuickBooks module 5 is all about vendors and we’re down now to video number five where I want to show you the correct way to pay your bills in QuickBooks let’s head on over to QuickBooks and I will show you how to get those started pain bills is easy in QuickBooks if you look at your home screen this is where you had previously entered that bill and now what you want to do is follow the flow chart all the way across to the pay bills icon before I click on that I just want to mention a couple of things what you don’t want to do is have a bill that you’ve entered and then come down here to either the right checks or the check register to enter that payment if you just come directly to one of these icons what will happen is the bill will stay open because it doesn’t see an association between the bill and the payment make sure you follow the flow chart all the way across to the pay bills once you complete this pay bills option here it will automatically put that payment in the register for you I’m going to click on pay bills this is a list of all the bills that you owe even if you owe a penny and you’ll see that currently they’re listed by vendor in alphabetical order if you want to change that use this sort right here you can sort these by the due date or if you want to sort them by any that might have a discount or credit you can see different options on this list but we’ll leave it sorted by vendor for now you can also filter the list if you’re looking for a particular vendor let’s just say it’s CU Electric then you can actually hide all the other vendors and just work on paying these two I’m going to go back and show all and that’s going to be at the top of the list it says all vendors notice I’m also showing all the bills if I just want to see ones due before a particular date I can choose this option here let’s say I’ve got a couple of different ones that I want to pay I do want to pay CU electric notice there are two bills for that vendor I’ll just pay them both if you’ve got multiple vendors you’re going to pay bills for you can just check them all at the same time and it will write Separate Checks and it will create separate payments for each or if you want to do them one at a time you could do that as well once you check those off you’ll notice that over to the right it assumes you want to pay all of that bill if you’re wanting to make a partial payment just change this amount right here to whatever it is you’re going to pay and it will remember the rest some of your options down at the bottom are to go to that bill this is one of the few places in QuickBooks you can’t double click on the bill itself you have to actually have that bill selected and then choose go to Bill you can also set your discount here if the vendor is giving you a discount for paying early or for some other reason you can go ahead and take that discount here you would type in the amount of that discount you’re taking and then you would have an account set up in your chart of accounts for that discount and if you’re using the class you might have one of those set up as well if your vendor has issued you a credit you can actually apply that credit here you would need to have that credit already set up in QuickBooks and here you could set that here’s the date of your payment the method of your payment it can be check credit card or bank payment remember that if you’re using a debit card or it’s automatically drafted just choose the check option to be printed you would use this option if you’re going to actually put checks in your printer and print these out if you’re going to just pay it online or maybe it’s automatically deducted just choose the assign check number option and you can type anything you want in that check number field make sure you have the correct bank account Chosen and then choose pay selected bills now here’s the check number field when I mentioned to you a moment ago to use the assigned check number if you’re using a debit card you can leave this field blank or you can put the word debit in there any code that you’d like to show QuickBooks what type of payment that is I’m going to click ok and now that payment has been made this is the payment summary window just letting you see the payments you just made if you have more bills to pay you can choose this option or you can say done you also have in the middle of it an option to print a bill payment stub you would print that if you wanted to send a check and maybe a stub with it there’s your print or email Now options I’m going to click on done and let’s see if it’s in our register I’m going over to the check register here on the right I’m going to use my checking account because that’s the bank account I paid this from and here is your payment for CU electric you’ll see that it says bill payment it does not say check that’s how you know you did this correctly that you actually entered a bill and then you made a bill payment to pay this bill I do want to show you one other way that you can pay your bills especially if you have a lot of them this might be a little quicker for you notice I have the vendor Center opened on the left here in the vendor Center you’re going to see this button that says build tracker this will let you see all of the expenses you have related to a particular customer or job or even if they’re just for the office you can see all of that here notice some of these are purchase orders some of these are bills that have been entered and at the top it gives you some totals here’s the total of your 10 purchase orders any open bills if you want to see if any of these are overdue you can look here and you can also see the total that were paid in the last 30 days now you’ll notice that if you’ve got a purchase order you can convert it to a bill we will be talking about purchase orders over in module six also notice if you have a bill that there’s an option to pay that bill all you would have to do is check the box all the way to the left of that bill and then you’ll see it says pay bill here you can also copy or print that bill if you wanted to you also have options to copy or print that bill but when you’re ready to pay it just come down here where it says batch actions and then choose pay bills you’ll see this is your pay bills window that appears you can actually click on that bill if it’s not already chosen if we have another one you want to add to that since there’s another one for Perry Windows I’ll go ahead and check that one as well and then all of the options we just talked about are right here in this window once you’ve made your choices you can pay your selected bills now that payment is in the register as well as the one we did a few moments ago I’m going to choose done and that’s how you pay your bills in QuickBooks now that you know how to pay your bills let’s go ahead and move over into video number six and we’re going to look at how to set up credits that your vendor has given you towards a bill hey there welcome back it’s Cindy we’re working in QuickBooks desktop 2022 and I want to talk to you about vendor credits sometimes a vendor will issue you a credit that you need to apply to a bill or it could be you want to apply it to your account and use it in the future but I want to show you how to handle those once the vendor sends them to you let’s go ahead and flip over to QuickBooks and I’ll show you how to set up those vendor credits I’m here in the vendor Center and you can see that this company owes Cal Gas and Electric 122.68 calgastic electric has issued a credit memo of 25 towards that bill I want to show you how to enter that credit memo and then how to apply it to that bill I’m going back to the home screen and what you’re going to do is you’re going to use the enter bills option the only difference is you’re going to set this as a credit right here and then just fill out the rest of the form this vendor was Cal Gas and Electric we’ll say they issued this credit memo on December the 20th you can put in a reference number and I’ll just put in it’s for 25 dollars if you want to pin a memo here you can do that in this case since it’s Gas and Electric you want to make sure that you pick the correct account from the chart of accounts remember if you’re getting a credit for a physical item that you’ve returned you want to use the items Tab and choose that item if this is for a particular customer or job you want to choose it from the list and also make sure that you’re using the correct class if you’re using the class list I’m going to go ahead and save and close at the bottom now let’s go ahead and follow the flow chart all the way to the end where it says pay bills what I want to show you is if you look at Cow Gas and Electric right here if you go ahead and click on that you’re going to see right down here where it says set credits there’s a 25 credit available so you’re not going to see it when you look up here as long as you have the bill selected you want to apply it to all you have to do is set credits you’ll notice this credit appears right here and all you have to do is click done and now you’ll see that credit is used right up here and it shows you there is an amount to pay now of 97.68 if you’re going to pay that just go ahead and make sure it’s checked off and go through the process and pay the selected bill and that’s all you need to do to enter a credit memo and then apply it to a bill I’m going to go ahead and cancel out of this let’s go ahead now and move over into video number six where we’re going to talk about a new feature in QuickBooks where you can schedule and pay your bills directly from QuickBooks foreign hey there welcome back to QuickBooks desktop 2022 this is Cindy we are moving now into module six where we’re talking about how to work with items and inventory we’re going to start off in this first video just talking about where the items list is and how you would actually go through and set up an item or an inventory part there are actually two parts to this video so make sure you watch videos number one and two let’s go ahead and flip over to QuickBooks and we’ll get started entering some of those items if you’re looking at your home screen you’re going to see an icon here that says items and services that’s where you want to click to go ahead and see all of these different items that you would either sell to your customers or purchase maybe for resale when you first set up your QuickBooks company file this list will be empty you won’t have any items you’ll have to go through and set these up yourself I wanted to go through this list because I want to point out that each of the items that you create can be set up as one of these different types that you see in this column some companies will have three or four maybe six seven items other companies might have over a thousand it just depends on what your business actually does let’s go through and look at some of these starting with the type called service what you’ll find is that based on the type the names will be in alphabetical order over here think of a service as an actual service that you provide to your customers if you look at framing that’s a service you provide labor would be a service repairing that would be a service as well sometimes you’re going to have items that are main items and then you’ll have sub items below carpet and drywall are sub items of this word Subs the next type that you’re going to see down here are your inventory parts you’ll notice for each of these inventory Parts you’re going to see the total quantity that you have on hand these are physical parts that you buy or sell the way that this number changes is when you sell this item meaning you put it on an invoice to sell it this number will go down when you purchase this the number will go up when you’re entering your expenses where you’ve actually made the purchase of these items you’re going to see on the bottom of that screen will be a tab that says items and you’ll be able to actually put that item on that tab let me show you what I’m referring to I’m going to flip back to home for a moment and let’s just say that you were using the right checks feature down here now I know we haven’t gone through this yet but you’re going to see on every type of expense that you enter you’re going to have the same screen down here you could either put this to an expense which is your chart of accounts or this is your items tab here where you can pick an item if I pick door frame and I say that I ordered quantity of two of these then what will happen is over here when I look at door frame this 21 will actually go to 23. you can also manually adjust this inventory we’re actually going to talk about that down in video number seven of this module the next type I want to point out are non-inventory parts these are physical products or parts that you have but you don’t keep a record of how many you have in inventory you might keep two or three on hand all the time just in case you need them or you might order them as you need them but you don’t really keep track of the quantity you have for non-inventory parts below that you’re going to see what they call other charges these are miscellaneous type things you’ll notice there’s a freight reimbursement here there’s a delivery charge they’ve got one set up for permit I did want to point out this next one that says subtotal over here you may not use this very often but what will happen is if you had six or seven line items on an invoice or an estimate and you want to subtotal those you can just add this as the next line and it will actually subtotal everything above it that it has it already subtotaled these are groups down here if you create estimates and you’re constantly creating an estimate for the same thing and maybe it has 100 different line items instead of typing those line items every time you can create a group and that group can include those line items that way the next time you need to put those on an estimate or an invoice you just type this group name and it will pre-populate all of those items for you there is a place to put a discount on your invoice if you’d like and it will figure the discount for you and also you can set up a line item as a payment I personally wouldn’t put payments on an invoice I would make this a separate transaction but you do have that ability and then the last couple of types I want to mention are your sales tax items and your sales tax group when we get to the videos where we talk about sales tax this is where we’re going to come to actually create those items and then if you have several you pay and pay to one entity you can create a group to include those that gives you a quick overview of the different types of items that you can set up in QuickBooks what I want to do now is go ahead and set up a service item with you just so you can get a feel for how to set up these items anywhere in this list you just right click and you’ll see the new Option here notice there’s also an edit option if you need to edit one of the items you already created you can duplicate an item if there’s a new one you need that’s similar to one you already have you can duplicate it and then make those few changes you need you can also delete an item you cannot delete an item if you’ve ever used it if you want to hide it from the list maybe you’re not going to use it in the future then go down here and make it inactive so it hides it from this list for now we’re going back to New so that we can create our new service item the first thing quick to ask you is what type of item is this and these are the types we just mentioned I’m going to say it’s a service item and we’ll actually call this one a consultation if this is a sub item of another you can check the box and pick the item it’s a sub item of remember the example where carpet is a sub item of Subs but this one’s not this is just a new item and then if you’re using the unit of measurement feature you can create a new unit of measurement they have one set up here it looks like they sell things each by the case for example and then of course you have a description area if this is going to change all the time you can just leave it blank I’m just going to duplicate the same item name there and then that can be changed when you’re actually on an invoice if you have a standard rate you charge for this item you’ll want to go ahead and put it in if it’s going to be different every time just leave that on zero and then change it on the invoice or estimate as you need to the next thing QuickBooks ask you is this a taxable item or not this is for sales tax purposes and then the most important thing on this screen is the account this is the chart of accounts and QuickBooks wants to know which account in the chart of accounts do you want this to relay back to nine out of 10 times you want it to relate back to an income account and this is where I see a lot of people have problems because if you don’t point this back to an income account your profit loss will not be correct there’s very few exceptions to that so if you just always pick an income account you’ll be good I don’t see one I’d like to use I’d like to have one called consultation income I’ll just create that I’ll go to the top of the list and choose add new I’m going to put in the account name and I really don’t need to fill any of this other stuff in I’m going to go ahead and hit save and close at the bottom and now you’ll see that it has my new account name there I’m going to click OK and now that item has been created you’ll see it right here at the top of the list that’s how you’re going to create a new service item what I want to do now is stop the video here and let’s move over to part two because I do want to show you how to set up inventory items so that you can go ahead and tell QuickBooks what the quantity is that you have currently and then you have the correct number to move forward with hey there it’s Cindy again welcome back to QuickBooks desktop 2022 we are working in module 6 where we’re talking about items and inventory we just completed part one where I showed you how to go through the items list and start adding items to that list now I want to show you how to specifically add inventory parts to that list let’s head over to QuickBooks and get started we’re back in the items list in QuickBooks in case you forgot how to get here go back to your home screen and you’ll see an icon right here that says items and services we’ll just head back over there to create any new item in your list just right click anywhere in the list and choose the new option the first thing you have to tell QuickBooks is what type of item is this and this is an inventory part let me just mention that if you don’t have inventory part on this drop down list it’s because when you set up the company file you told QuickBooks you do not keep inventory now if you want to change that at this point all you have to do is go back up to edit and back to your preferences in here you want to click items and inventory on the left then choose your company preferences Tab and make sure all of these are checked once you’ve done that go ahead and click OK and then you will see inventory part appear on this list this is going to be a screen door if this was a sub item of another I would click sub item of and choose that item from the list but this is not and notice there’s a place now for the manufacturer’s part number this is just helpful information for you whenever you’re ordering this part that way you don’t have to keep guessing of what that number is if you’re using the unit of measurement you’ll want to choose that from the drop down list you’ll notice when you’re entering inventory that you have two sides to the screen you’ve got the purchase information side and then over here you have the sales information side this is when you buy this item and this is when you sell this item I’m going to put a description in here I’ll just say screen door and of course you can edit that whenever you’re on an estimate or an invoice and what you’ll notice is if you click on the right it’ll put that same description here and of course you can edit that as well this would typically be the description that you would see when you’re purchasing this item from your vendor the next thing you’ll see on the left is the cost on average what do you pay for this if it’s totally different every single time you can leave it on zero I’ll just put in 200. but the sales price is what you charge for this that means anytime you put this on an invoice or an estimate it will pull in in this case 550 and of course you can type over that if you need to if it’s going to vary every single time again then go ahead and leave that blank over here the cost of goods sold account you really don’t want to change this unless you have some sub accounts underneath that you specifically want it to go to but this is considered a cost of goods sold because you have to buy this product to make or sell this product in your business to make sure that stays on a cost of goods sold below that is a feel for the preferred vendor if you have a specific vendor you’d like to buy this from then you can go ahead and pick them from the list if not you can just leave that blank over on the right for sales tax purposes is this item subject to sales tax and typically if it’s a physical item it is and the most important thing on this whole screen again is the income account this word says income so that means pick one of these income accounts that you want this to go to when you’re selling this item where do you want it to end up I’ll just say in this case I wanted to end up under materials income because this is inventory you’ve got some options down at the bottom you can plug in you don’t want to change the asset account this is the account the assets going into inventory is considered an asset to your business because it’s worth something it makes your company more valuable but it is liquid and you’ll want to sell it and get it out the door there is a place to plug in a minimum reorder point and a maximum and what that means is do you want QuickBooks to tell you when you have two left to order some more so you don’t run out and what if you get too many maybe you want to have a Max of 10 in the back room and you want QuickBooks to tell you that here’s where you’re going to put in how many you have on hand that’s the starting number QuickBooks will have and remember if you have one every time you purchase it we’ll add to that number and anytime you sell this it will take away from that number and that’s really all you have to plug in when you’re setting up an inventory part I’m going to click OK and it should tell us that we have one of these let’s go look and see here you can see our screen door and you can see that we have one of them that’s how you’re going to set up inventory and get started with that whole inventory process that’s going to go ahead and wrap up the items and inventory part of this module let’s go ahead and move over to video number three and we’ll talk about purchase orders hey there welcome back to QuickBooks desktop 2022 this is Cindy we are working in module 6 where we’re talking about items and inventory and we’re down now to video number three I want to show you how purchase orders work in QuickBooks if your company uses the purchase order system that means that when you order an item you’re going to actually enter a purchase order once that inventory comes in you’re going to actually enter an item received and then eventually you’re going to pay for that and that’s the purchase order system but let’s go ahead and start with video number three here and I’ll show you how to enter purchase orders before we get started I want to go back to the items list and show you that we have one screen door right now as an inventory part and we want to order three more we’re going to use the purchase order system to do that back on the home screen you should have an icon here that says purchase orders if you do not have this icon it’s because you told QuickBooks when you set up the company file that you do not track inventory to turn that on you would go back to edit down to preferences make sure you’re under the items and inventory option on the left and then click on company preferences you want to make sure all three of these are on and that way your icon will show up on your home screen I’m going to click on purchase orders and we’re going to enter the purchase order the first thing it asks me is who is the vendor that you want to order this from and we’re going to say this is Perry windows and doors this would be my vendored list if you’re using the class feature then you’ll want to go ahead and choose which class this would pertain to if you want to drop ship this to a particular customer site that means when you order it you want the vendor to send it to the customer site then you could choose it from the list but if you’re not doing that you’re just going to put them in your office then you don’t want to choose anything here you can also choose a template for your purchase orders we only have one right now but we can create those and we’ll talk about that in a later module the next thing you want to do is check the date this is going to be the date you’re creating the purchase order and then you want to put in the purchase order number QuickBooks will number sequentially if you want to change that number then you just change it to whatever you’d like it to be here is the vendor information that it pulled in when you chose your vendor right up here at the top and next to that is the ship to information if you were shipping it directly to a client site or if you’re not you’ll see it pulled in that your company information what you want to do is go down on the first line under item and you just want to pick screen door and if you want to add a description this would be the description the vendor uses they might have a particular part number they might call it a particular brand name but you can change that to say anything you’d like we’re going to order three more of these and let’s say that we’re ordering three because they’re on sale they’re 185 dollars so see I’m going to change that right there if they were for a particular customer again you would pick the customer job from this list and if you were using the unit of measurement you would choose it from that list if you could and you can see pulled over the total there of 555. you can keep adding as many items as you like to this purchase order a couple of quick things you’ll notice at the bottom left of the screen there is a place for a vendor message that would be something that you would put in there that only you would see and then a place for a memo over the right hand side you can see your history here if you want to hide that just use the arrow to hide the history or the left Arrow to show the history but that’s just going to show you information about the vendor you can see their phone number if you have an open balance with them if you have any purchase orders still that need to be received and then recent transactions will show up here now let’s head up to the top and see if there’s anything new I think you’re familiar with most of this already you know how to print email these let’s go ahead and see what a purchase order would look like I’ll preview this you can see it just says purchase order here at the top it has all the information on it you can see the company information here on the left there’s the vendor name and address and the ship to name and address and what you’re actually ordering I’m going to close that screen one thing that you haven’t seen yet is this icon here that says create item receipts now that’s going to be the next thing in the process once you receive the physical products into your office chances are you’re not going to be on this screen when you want to receive your items but you could do that and you would also select your item receipts from here but again we’re going to do that back from the home screen there are some reports you can run back here if you want to look at any open purchase orders you can do that you can look at purchase orders by job you can look at them by item detail you might see an item listing and then purchases by vendor detail I’m going to click save and close at the bottom and now that purchase order has been created what I want to do is go back to the items list and just show you that you still only have one screen door right here and that’s because you’ve only ordered it you have not received it into inventory yet and that’s the next thing we’re going to talk about if you’ll head on over to video number four we’re going to talk about how to receive those items into inventory hey there it’s Cindy again welcome back to QuickBooks desktop 2022 we are working our way down through module 6 where we’re talking about items and inventory we’re down to video number four now we’re going to talk about how to receive items into inventory these would be items you’ve already created a purchase order for and now you’ve received them you want to update QuickBooks so that your inventory number is correct let’s flip over to QuickBooks and we will look at how to receive those items into inventory in QuickBooks we’re back in our items list and I wanted to point out the screen doors you still only have one as far as the quantity is concerned because we’ve ordered three more but we haven’t received them now that they’ve come in I want to show you how to go ahead and receive those so that they’ll show up in this list and this quantity will change to four I’m going to go back to the home screen and following the flow chart I’m going to go to the receive inventory icon you’ll notice here that there’s a down arrow because there are two ways that this can happen one you can receive your inventory and the bill is actually in the box with it or you can receive it and later the bill will come in the mail they’ll just have a packing slip for you to look at right now but let’s go ahead and use the bottom option we’ll say without the bill because that’s normally the way it happens and now you’re on what’s called an item receipt now you have to have a purchase order in here already in order to pull from that purchase order the first thing QuickBooks wants to know is who is the vendor in this case it was Perry windows and doors because we have an open purchase order then it’s letting us know that we can receive against one or more of these we’re going to say yes this is how you’re going to close the purchase order you’ll see there are two purchase orders here and you’re going to choose the one you want to receive against let’s just say I picked this one and I click ok you’ll notice it pulled in those three screen doors what if you clicked the wrong purchase order and you want to go back and pick the correct one instead of getting out of this whole thing notice you have a button up here that says select po you would uncheck the one you pulled in check the correct one and then click ok and you can see that I really needed that first one so I’ll go back and choose that first one but the point is that you can actually change the purchase order that you pulled in the next thing I want to do is go ahead and pick the date this is the date that I actually received the items let’s go ahead and say it was January the 3rd you wanted to put in a reference number you could and then the total and that total shouldn’t change because this is not a bill where they would add shipping or tax this should be the same amount that was actually on the purchase order now the only exception is what if when you’re looking at these items here they only sent you two of those doors then you would change this to two which obviously would change your total up at the top and then you could go through the same process when that last one actually comes in going across you’ll see it pulled in the cost it pulled in the amount and if you wanted to make this billable meaning that you would have the customer reimburse you you could click here and you can see it pulled everything you need right from here let’s go back up and see if there’s any new buttons that you’re not familiar with up here you should be familiar with all of these we talked about selecting a PO if you choose the wrong one you could also enter some time what this means is if you are tracking the time that it takes you or an employee to actually process this maybe open the box put the things in inventory the whole process then you can do this because it’s part of your job costing you just pick a start date and an end date for this and then you would click ok you can also clear the splits that means that if you had multiple line items you could clear that and start over and you could recalculate it there are some reports you can run as well related to items there’s an item listing which just list all your items if you want to see the details about any purchase orders that are open you can do that there’s a vendor balance detail and unpaid bills detail and purchases by vendor let’s go ahead and click save and close at the bottom and see if our item list has been updated when I look at screen doors you can now see that I have four screen doors so you can see that once you create those purchase orders it’s not going to change your quantity but once you receive the item in inventory then it will that’s how you’re going to receive items into inventory in QuickBooks let’s move over to the next video number five and we’ll quickly walk through how to handle the bills for those items that you just received hey there welcome back it’s Cindy again we are working through QuickBooks desktop 2022. right now we’re in module number six where we’ve been discussing items and inventory and I want to take a quick moment in this fifth video here and talk to you about how to handle the bills for items that have gone through the purchase order process it’s really going to be fairly easy it’s very similar to just entering any Bill and paying it but I want to follow the flowchart and show you how to take this all the way through let’s go ahead and flip over to QuickBooks and we’ll get started if you have a bill you need to enter that’s for items that went through the whole purchase order system you want to enter those here because you want to complete the flowchart I’m going to click on enter bills against inventory the first thing you want to do is choose an item receipt and you need to pick the vendor this was Perry windows and doors in the previous video we had actually ordered a three screen doors and now we’re ready to enter that bill you can see that an item receipt came up for Perry windows and doors you want to make sure you choose the correct one this would be any items you received through this receive inventory button right here I’m going to click ok and now you can see a bill and it’s pulled in all three of the screen doors that we had ordered when you receive a bill you’ll probably have some additional charges like a shipping charge or something else go ahead and just change all the information needed to make this correct this bill would be for six hundred dollars in this case and I’ll just put in a reference number that would be the bill number or the invoice on the vendor side as they would call it make sure you have to build date correct and make sure you have the due date correct that’s the important one that way when you run reports you’ll have accurate dates when your bills are due now in this case we’re going to break up our amount due we know that 550 is for the items we purchased but the rest of it is for a shipping or freight charge you would click on the expenses Tab and choose Freight and delivery from this drop down list and then put in that amount go ahead and save and close and QuickBooks will say that this transaction is linked to others are you sure you want to change it and you would just say yes here now that Bill is in QuickBooks ready for you to pay it let’s go ahead now and hop over to video six and we’ll go ahead and get those items paid for hey there welcome back to QuickBooks 2022 this is the desktop version and we are going through module six items and inventory we’re down to video number six now paying for items there’s a couple different ways you’re going to be able to actually enter those items in QuickBooks especially if you have inventory and you want it to increase as you make those purchases it could be that it’s a bill you’ve put in and you just want to pay that bill or it could be that you’re actually using a check or debit card or purchasing them online let’s go ahead and flip over to QuickBooks and we’ll look at how to pay for those items let’s go ahead and start with the easiest thing first so far in this module we’ve gone through this whole purchase order system we actually ordered some items we ordered three screen doors we actually received that into inventory and this is when your inventory number increased and then we actually entered the bill when you get ready to pay the bill just follow the flow chart all the way down to this pay bills option right here if you remember we actually purchased our doors from Perry windows and doors and looking down this list you can see there are several you just want to go ahead and check off the one or ones that you’re going to pay and pay this like you normally would when you’re paying any Bill I’m going to go down and change the date that I’m making the payment I’ll choose the method I’ll just leave a signed check number and go ahead and pay selected bills remember that when this screen pops up you can enter anything you want the check number field I’ll just say that I used a debit card to pay this and I’ll click ok and now that is done I’m going to go ahead and choose the done option so that’s the first thing I wanted to point out is paying the bill the next thing is when you’re entering the expense let’s say that you actually went to your local store and you purchased those screen doors maybe you wrote a check used your debit card it really doesn’t matter how you paid for it in QuickBooks desktop anytime you have something that comes out of the checking account it’s considered a check you can use the right checks window whether you paid for it online debit card it doesn’t matter you can use that window or you can use the check register I’m going to use the right checks let’s say that I want to purchase one more screen door I’ll go back to Perry windows and doors notice it tells me I have open purchase orders since I’m purchasing this and I’m not actually applying this to a purchase order I’m going to say no in this case and that way the purchase orders stay open for the next time I’m going to say that the door was 185 dollars now here’s the important thing this is your chart of accounts when you’re under the expenses tab you could most certainly if you’re not tracking inventory then you could come down and pick that this was a job material or whatever account you’d like to use however in this case I want to add that door to my inventory so that means I need to delete this line here and make sure I put it under the items tab just a quick little trick whenever you’re trying to delete an entire line anywhere in QuickBooks just click on that line and all you have to do is hold Ctrl and hit your delete key and it will delete the entire line now I’m going to go to the items Tab and I’m going to put in screen door and there you can see it pops up I’m purchasing one of these it looks like it’s 185 dollars and if it is for a particular customer job I can choose that here but if I’m trying just to keep that in my inventory I’ll just leave that empty now I’m going to go ahead and save this and then close this window when we go back to our items and services let’s see how many we actually have right now we’re going to go down and find a screen door and we have five of them one of them was just added to our inventory we haven’t yet talked about credit cards but if you’re using a credit card to make that purchase the same thing would apply you would click here and you would still see that you have the two tabs you’d want to make sure it’s under the items tab so that goes into your inventory and that’s what I wanted to point out to you about actually paying for those items specifically when you want items to go into your inventory let’s go ahead and finish up module 6 over in the seventh video I’ll show you how to manually adjust your inventory because inventory is going to get off and you want it to always be as accurate as possible hey there welcome back to QuickBooks desktop 2022 this is Cindy we are getting ready to wrap up module six we’ve spent some time talking about items and inventory and then this last video I want to show you how to manually adjust inventory inventory is just going to get off and every now and then you’ll go in the back room and you’ll count and you’ll want to adjust the number in QuickBooks to match what you actually have I want to show you how to do that let’s go ahead and flip over to QuickBooks and we’ll see how to adjust that inventory on the home screen you’ll want to navigate to the items and services icon and that way you can see your list of items if you look at your screen doors here we have five we’re going to adjust this because let’s say there’s only four that we actually have on hand we need to decrease that number by one at the bottom of your items list there are a lot of different options most of these options you can get to by right clicking anywhere on your screen you’ll see there is the adjust quantity value on hand option which you would also find under activities the very bottom option down here the first thing you need to tell QuickBooks is what type of adjustment is this are you adjusting the quantity the total value or both we’re just in the quantity set your adjustment date whatever date you’re doing this adjustment and then you want to have an adjustment account now I’ve set up one called inventory adjustments you’ll want to go ahead and set that up yourself because it will not automatically be in the list QuickBooks will number each one of these adjustments you can change that reference number if you like also if you’re adjusting this for a particular customer job you can choose that from the list if you’re just suggesting inventory on hand then you leave that blank make sure you choose the class this would apply to as well the next thing you want to do is go down and find the item from the items list that you’re adjusting in this case it’s a screen door it tells me I have five but the new quantity I want is four that means there will be a negative one adjustment I’m decreasing by one if you want to put a memo here you can down at the bottom but that’s really all you need to do I’m going to save and close and now if we go down and look at our screen doors we should have four and we do you can see it right there and that’s how you’re going to adjust your inventory that you have on hand well that’s going to go ahead and wrap up module 6 where we’ve talked about items and inventory why don’t we move over now to module 7 and we’re going to look at all the different options related to banking features in QuickBooks if you’re not a subscriber click down below to subscribe so you get notified about similar videos we upload now to get the course transcript and follow along with this video click right over there and click over there to watch more videos on YouTube from Simon says it

By Amjad Izhar
Contact: amjad.izhar@gmail.com
https://amjadizhar.blog
Affiliate Disclosure: This blog may contain affiliate links, which means I may earn a small commission if you click on the link and make a purchase. This comes at no additional cost to you. I only recommend products or services that I believe will add value to my readers. Your support helps keep this blog running and allows me to continue providing you with quality content. Thank you for your support!

Leave a comment