So far, we have covered the most common transactions for which small businesses use QuickBooks. However, there are a few more topics that we would like to share with you. While some of these may not apply to your business when you are starting out, it’s a good idea to be aware that they exist.
First, we will start by using apps in QBO. Apps are a great way to help you streamline day-to-day business tasks that can be time-consuming. Next, we will show you how to record credit card payments from customers. This is an excellent way to get paid faster. Third, we will show you how to create professional-looking sales templates. If you have several expenses that you pay weekly, monthly, or quarterly, you should set them up as recurring transactions. We will also cover how to create and manage recurring transactions in this chapter. If you have a business loan or line of credit, you need to keep track of payments and overall outstanding balances in QuickBooks. Petty cash is often used for small purchases such as stamps or lunch for the office. Due to this, we will show you how to keep track of petty cash. While you always hope it doesn’t happen to you, there may come a time when you need to record a bad debt, so we will show you how to properly record bad debt expense. Finally, we will show you how to record delayed charges. Delayed charges are used to keep track of the services you have provided to customers that you will invoice at a later date.
In this chapter, we will cover the following topics:
We will begin by learning how to search for apps in the QuickBooks app store and locate apps that are ideal for your business.
The US edition of QBO was used to create this book. If you are using a version that is outside of the United States, results may differ.
Please note the screenshots in this chapter have been taken using the Accountant view menu. In Chapter 1, Getting Started with QuickBooks Online, we introduced a new menu called Business view. If you are in Business view, you will need to switch to the Accountant view menu so that your screen resembles the images shown throughout this book. To do this, click on the gear (settings) menu (located in the upper-right corner) and select Switch to Accountant view as shown in Figure 16.1 below:
Figure 16.1: Switching to Accountant view
There are many benefits and a few risks of extending functionality through apps. Some of the benefits of using apps in QBO are:
A couple of the risks involved with using apps are:
The app store is organized into categories based on app functionality. Customer reviews are included, along with short video demonstrations to show you how the app works and customer service information if you have additional questions. In this section, we will provide you with an overview of the App Center, show you how to find apps that are relevant to your business needs, and show you how to add apps to QuickBooks Online.
Pro Tip: Because of the large number of apps that are available, it’s impossible for ProAdvisors and accountants to be familiar with all apps. Therefore, you will need to reach out to the technical support team for the app that you choose for assistance with setup, implementation, and training needs.
The layout of the App Center is very simple. You can easily search for apps, see a list of the apps you have added, and check out apps that have been recommended based on the type of business you have. Let’s take a look at the layout of the App Center:
Figure 16.2: Navigating to the QuickBooks App Center
Figure 16.3: QuickBooks App Center
The five key areas of the QuickBooks App Center featured in the preceding screenshot are as follows:
A few of the categories you can search by include get paid, manage workers, make payments, manage customers, manage projects, and many more. This will greatly assist in finding apps for the purpose you are looking for.
If you’re not sure which app to choose, I recommend that you schedule a live demo with the app company so that you can see how the app works and get your questions answered. Many companies offer a trial period of 14 days or more so that you can try the app before you buy it. Like QBO, there are no contracts, so you can cancel your subscription at any time. Let’s now walk through an example of how to find apps for your business.
As we mentioned previously, there are more than 700 apps in the QuickBooks App Center. While it can be overwhelming at first, you should focus on the needs of your business. There is a lot of information in the center about each app, which will save you the time you would have normally spent doing research. Let’s take a look at an app to see what kind of information you can expect to find here.
Scroll down to the Most Popular category and click on the Bill.com app. You will be greeted with the following screen:
Figure 16.4: The app profile for the Bill.com app
The following is a brief description of the information you will find in the app profile:
Once you have decided which app(s) to go with, it’s easy to get started. Simply click on the Get app now button located on each app profile. Follow the onscreen instructions to complete the app’s setup.
Pro Tip: Reaching out to an industry-specific professional organization is a great way to find out the most popular apps used for your industry. This may help narrow down your search for the right fit.
There are several apps that allow you to accept credit card payments from customers. If you sign up for one of these apps, it will make managing credit card payments that much easier in QuickBooks. Next, we will explain how to manage credit card payments.
In addition to traditional payments such as cash and checks, you should accept credit cards as another form of payment. While there are fees associated with accepting credit card payments, there are several benefits. First, you can get paid faster with a credit card than waiting to receive a check in the mail.
Second, if you sign up for a QuickBooks Payments account (https://quickbooks.intuit.com/payments/?sc=seq_intuit_pay_click_ft), you can email customers their invoice, which includes a payment link. They can click on the link, enter their payment information, and pay their invoice in a matter of minutes, which is much faster than waiting to receive a check in the mail. Best of all, QuickBooks will mark the invoice as paid, which automatically reduces your accounts receivable balance. As we discussed in Chapter 7, Recording Sales Transactions in QuickBooks Online, you can send your customers payment reminder emails, which will include a copy of the open invoices, along with a payment link.
If you decide to go with a third-party credit card processor, you can manually record these payments in QuickBooks. In this section, we will show you how to record credit card payments that have been received from customers via QuickBooks Payments and a third-party credit card processing company.
Before you can perform the steps, you will need to have an active QuickBooks Payments account that is connected to your QBO account. Visit QuickBooks Payments (https://quickbooks.intuit.com/payments/?sc=seq_intuit_pay_click_ft) to learn more about how this works. If you are using a third-party processor, you may be able to connect your account to QuickBooks. Contact your credit card processor to find out if they are compatible with QuickBooks Online.
Follow these steps to record a credit card sale:
Figure 16.5: Navigating to sales receipt
Figure 16.6: Completing the sales receipt form
After selecting the customer from the dropdown menu, the Email and Billing address fields will automatically be populated with the information you have on file.
Figure 16.7: Completing the credit card payment information
In Figure 16.7, the credit card number has been removed for security reasons. Be sure to complete all of the necessary fields and click the Use this info button to save the information.
Pro Tip: After entering the customer’s credit card information, QuickBooks will keep this information on file. You won’t have to enter it again unless your customer would like to use a different payment method or the credit card expires.
Pro Tip: If you don’t have a QuickBooks Payments account, you can still enter the credit card information and save it. However, you will need to process the credit card payment outside of QuickBooks using your third-party merchant company. When the payment is deposited into your bank account, you will need to match it up with the sales receipt in the Banking Center. To learn more about matching transactions, read Chapter 9, Reconciling Uploaded Bank and Credit Card Transactions.
You now know the benefits of accepting credit card payments from customers and how to manage these payments in QuickBooks. You can impress your customers further by creating invoices, estimates, and sales receipts that include your company logo and branding style. We will show you how to customize sales templates next.
QuickBooks allows you to create custom sales forms to match your brand and style. Taking the time to customize sales templates will allow you to create professional-looking forms so your customers can easily see what they owe and make payments online in just a few minutes. You can customize invoices, estimates, and sales receipt templates. Follow these steps to learn how to customize these sales templates:
Figure 16.8: Navigating to Custom Form Styles
Figure 16.9: Clicking the New style button
Figure 16.10: Three customization options for sales templates
The following is a brief explanation of the information you can customize in each of these areas:
Figure 16.11: Sample custom invoice for Small Business Builders, LLC
You can create an unlimited number of templates for various types of sales and customers. It is easy to make changes to them anytime. The best part is that you don’t have to create any templates from scratch.
Now that you know how easy it is to customize sales templates, you can use one of these templates to create a recurring transaction. We will show you how to create and manage recurring transactions next.
If you take out a business loan or line of credit, you need to track the payments that have been made, as well as the outstanding balance owed in QuickBooks. This will ensure that your financial statements include the money that is owed to all creditors. If this information is not included in QuickBooks, it will not show up on your financial statements. If this information is not reported in your financial statements, you will have inaccurate reports and you could miss out on legitimate tax deductions.
In this section, we will cover how to set up a business loan or line of credit, how to track payments, and how to stay on top of the outstanding balances owed.
The first step to properly tracking loans and lines of credit in QuickBooks is to set them up on the chart of accounts. We will do this next. Follow these steps:
Figure 16.12: Navigating to Accounting
Figure 16.13: Clicking the New button
Figure 16.14: Adding a new business loan account
A brief description of the fields in the preceding screenshot is as follows:
loan
and you will have the option to select Short-term business loan (as we have done) or Long-term business loan from the dropdown menu.Business Loan - Bank of the USA
, in our case).Pro Tip: Another way to record a beginning balance for a line of credit (or loan) is by categorizing the transaction to the loan account (created above) when you receive the funds in your bank account.
If you haven’t done so already, you will need to repeat these steps to add an interest paid or interest expense account to the chart of accounts list. You will track the interest portion of your payments in this account. Now, we’ll cover how to make payments on a loan or line of credit.
Pro Tip: It is very important that you track the interest in loans and lines of credit in a separate expense account. The reason for doing this is interest expense for most liabilities such as this is tax-deductible. If the amount is buried with the principle payments, it will be difficult to go back and calculate later on.
In general, you can make payments on a loan or line of credit in the same manner that you pay other creditors. You can write a check or have the funds automatically deducted from your bank account. Here, we will walk through how to record a payment.
Follow these steps to make payments on a loan or line of credit:
Figure 16.15: Navigating to Check
Figure 16.16: Completing the check form to record payment for loan
A brief description of the fields you need to complete in order to record a payment for a loan or line of credit is as follows:
Pro Tip: In order to accurately record the proper amounts for the principal and interest accounts, you may need to refer to your loan statement to see how your payment was applied. Be sure to do this so that your books match up with those of the financial institutions.
One final step you should do to ensure that the business loans and lines of credit on your books match your statements is to reconcile these accounts on a monthly basis. The steps to reconcile business loans and lines of credit are identical to reconciling your bank accounts. Refer to Chapter 9, Reconciling Uploaded Bank and Credit Card Transactions, for step-by-step instructions on reconciling.
Remember, it’s important for your financial statements to be as accurate as possible. This means including all of the money that is owed to creditors, such as loans and lines of credit. In addition, in order to deduct the interest expense, you need to keep track of it in QuickBooks.
If you tend to pay cash for small incidentals for the office, such as a Starbucks run for the office or stamps, you need to set up a petty cash fund to keep track of these types of expenses. We will show you how to manage petty cash in QuickBooks next.
Petty cash is a small amount of money that’s used to cover incidentals such as postage, lunch for the office, or other items. Petty cash is generally no more than $500 and is kept under lock and key and managed by the business owner or someone designated by the owner. Like all business expenses, you need to keep track of all your receipts so that you can record the expenses in QuickBooks.
In this section, we will discuss how to track petty cash, record petty cash expenses, and reconcile the petty cash account. Let’s get started by creating a petty cash account.
In order to track petty cash in QuickBooks, we need to add a petty cash account to the chart of accounts.
Follow these steps to add a petty cash account:
Figure 16.17: Navigating to Accounting
Figure 16.19: Completing the fields to add a new petty cash account
The following is a brief explanation of the information you will need to fill in:
Cash
and select it from the dropdown menu.Petty Cash
as the name of the account and any additional details required.Pro Tip: Instead of entering a starting balance in this account, you can record a transfer from a business checking account to the petty cash account in QuickBooks. In general, this is the most likely place that the cash will originate from.
Pro Tip: If you are using apps such as PayPal, Zelle, or Cash App, you will set these accounts up in the same manner as we have done the Petty Cash account. It’s important to treat these accounts like your bank account by recording all transactions and reconciling these accounts monthly or more often.
Now that you have created a petty cash account, you are ready to record the purchases that are made using petty cash.
Receipts for petty cash expenditures should be kept in the same place the petty cash is kept: under lock and key. If possible, you should enter the petty cash receipts into QuickBooks on a weekly basis. If petty cash is not used that often, monthly should be sufficient.
Follow these steps to record petty cash transactions:
Figure 16.20: Clicking on the View register link
Figure 16.21: Clicking the dropdown arrow next to Add check and selecting Expense
Figure 16.22: Completing the fields to record the expense
Explanations of the fields to fill in are as follows:
Repeat the preceding steps to record each petty cash receipt in QuickBooks.
Eventually, you will get to a point where you’ve run out of petty cash or you don’t have enough to pay for an item. Before replenishing petty cash, make sure you have entered all of the receipts for petty cash purchases that have been made thus far. Similar to a bank account, you can record a transfer in QuickBooks so that you can transfer money from a checking account to a petty cash account. Of course, to get the actual cash, you will need to make a withdrawal from your business checking account to replenish the actual funds.
To record a transfer from the business checking account to petty cash, follow these steps:
Figure 16.23: Clicking on Add transfer and selecting Transfer
Figure 16.24: Completing the fields to record the transfer
Brief explanations of the fields you need to fill in to complete the transfer are as follows:
If you have recorded all the money that you have paid out of petty cash, this transaction will increase the balance back to the cash on hand in your petty cash box.
Now that you know how to add the petty cash account to the chart of accounts, record petty cash expenses, and replenish the petty cash fund, you need to know how to ensure that it stays in balance. Like most bank accounts, this will require you to reconcile the petty cash account.
As we mentioned previously, petty cash is similar to bank and credit card accounts you track in QuickBooks. You need to ensure these accounts remain in balance. To do that, you must reconcile them. In Chapter 9, Reconciling Uploaded Bank and Credit Card Transactions, we showed you how to reconcile these accounts in QuickBooks. Refer to that chapter for step-by-step instructions on how to reconcile your petty cash account. I recommend that you reconcile your petty cash account before you replenish it. This will ensure that you have accounted for all the expenses that have been paid for using petty cash and that you have all the receipts to support these purchases.
While you will hope to avoid such a situation, there may come a time when a customer cannot afford to pay their outstanding balance. If this happens, you will need to write off the receivable as bad debt. We will discuss how to record bad debt expense next.
If you’re in business long enough, there will come a time when a customer is unable or unwilling to pay you. If you use cash basis accounting, you don’t need to record bad debt expense because you don’t have accounts receivable. However, if you do extend credit to your customers and, after attempting to collect the payment, you become aware that you will not be able to collect payment, you should write off the bad debt. This will ensure that your financial statements remain accurate and that revenue is not overstated.
There are three steps you need to follow in order to write off bad debt: first, you need to add a bad debt item to the products and services list; next, you need to create a credit memo; and finally, you need to apply the credit memo to the unpaid customer invoice. We will walk you through these steps in this section.
The first step of recording bad debt expense is to add an item to the products and services list for tracking.
Follow these steps to create a bad debt item:
Figure 16.25: Navigating to the Products and Services list
Figure 16.26: Selecting Service as the item type
As you can see, there are four item types to choose from. Service is the item type we will use for bad debt expense.
Figure 16.27: Completing the fields to add Bad Debt to the products/services list
Brief descriptions of the fields to fill in are as follows:
Bad Debt
or Bad Debt Expense
in the item name field.Now that you’ve set up the new bad debt expense item, you can use this item to record the bad debt on a credit memo form.
A credit memo is generally used to refund a customer for items purchased that were returned or services that were not rendered in full. After creating the credit memo, we can apply it to the unpaid customer invoice.
Follow these steps to create a credit memo:
Figure 16.28: Navigating to Credit Memo
Figure 16.29: Completing the fields in the Credit Memo form
Brief explanations of the fields to fill in to complete the credit memo are as follows:
We will show you how QuickBooks applies the credit memo to the customer’s open invoice next.
The final step in writing off bad debt is to remove the open invoice from accounts receivable. This step is automatically done by QuickBooks for you. Follow these steps to see how the credit memo is automatically applied to the open customer invoice:
Figure 16.30: Navigating to Receive payment
Figure 16.31: Selecting the invoices and/or credit memos to process
In Figure 16.31, we have selected the invoice that needs to be written off (Invoice # 1009) and above that, we have selected the credit memo to apply (Credit Memo # 1012). As you can as see QuickBooks has automatically marked the open invoice #1009 as Paid and the credit memo has been marked Closed. You can see this information in the STATUS column.
To summarize, it’s important that you write off accounts as soon as they become uncollectible. This will ensure that the accounts receivable balance is not overstated. If you are an accrual basis taxpayer, you will not want to pay tax on income that you will never receive.
Pro Tip: If the customer has already paid the invoice and you need to refund their money, do not create a credit memo. Instead, create a refund receipt. To do this, click on the +New menu, select Refund Receipt and complete the form as shown below.
Figure 16.32: Creating a refund receipt
If you provide ongoing services to customers on a weekly or bi-weekly basis but you don’t want to invoice customers that often, you should consider using delayed charges. Delayed charges allow you to accumulate charges in QuickBooks (without affecting the financial statements). Once you are ready to bill a customer, you can easily transfer the delayed charges to an invoice. We will discuss delayed charges and credits in detail next.
Delayed charges and credits are used to keep track of services that are provided to customers so you can bill them sometime in the future. For example, if someone provides weekly pool maintenance to customers but does not want to bill them until the end of the month, delayed charges are ideal for keeping track of the services that are provided each week. These weekly services can easily be added to an invoice when it’s time to bill the customer.
Follow these steps to record delayed charges:
Figure 16.33: Navigating to Delayed charge
Figure 16.34: Completing the Delayed Charge form
Brief descriptions of the fields to fill in are as follows:
When you save a delayed charge, it is a non-posting transaction, which means it doesn’t affect the financial statements. Next, we will show you how to add delayed charges to an invoice:
Figure 16.35: Selecting the delayed charges to bill the customer for
If you would like to review a list of unbilled charges before creating an invoice, you can do so by running an unbilled charges report. We will show you how to generate this report next:
Figure 16.36: Navigating to the unbilled charges report
Figure 16.37: Sample unbilled charges report
That’s how delayed charges work. One last thing you need to know is that if you need to reverse a delayed charge, you can do so by recording a delayed credit. Similar to delayed charges, navigate to the +New menu and select Delayed credit. Follow the onscreen instructions to record the delayed credit. Delayed charges are used a lot in landscaping and maintenance industries for routine services that are billed monthly.
In this chapter, you have learned how to handle many special transactions in QuickBooks Online. You may be able to take advantage of a few of these now or keep them in your back pocket for later on when you need them. To recap, you now know how to locate apps in the QuickBooks app store and add them to QuickBooks. We have shown you how to manage credit card payments from customers and how to customize sales templates such as invoices to fit your business style and brand. For those expenses that occur often, you know how to add them to QuickBooks as recurring transactions and use them when needed. If you obtain a business loan or line of credit, you know how to set these up in QuickBooks and track payments. For those incidental purchases, you can create a petty cash account, track purchases, and reconcile the account, just like bank accounts. We also discussed the importance of recording bad debt expenses, which you now know how to record in QuickBooks to ensure that your financials are accurate. Finally, you learned how to record delayed charges and credits to track services that are provided to customers that will be billed sometime in the future.
In the next chapter, we will show you how to find apps to help streamline your daily tasks in QuickBooks Online as well as cover how to handle special transactions such as managing credit card payments, customizing sales templates, managing petty cash and much more!
3.146.105.137