Managing expenses incurred by a business is one of the primary reasons why many businesses decide to use QuickBooks. Most businesses know when they are generating income, but when it comes to where their money is going, it’s a whole different story. For a business to be profitable, it must be able to control expenses that directly affect the bottom line.
In this chapter, we will show you four ways to record expenses, also known as money-out transactions: (1) entering and paying bills, (2) managing recurring expenses, (3) writing and printing checks, and (4) capturing and categorizing receipts and bills.
Entering a bill is ideal for suppliers who have extended credit to you. You receive your purchases immediately and payment is due sometime in the future. However, expenses that require immediate payment should be paid via check. Entering a check allows you to record both the expense and the payment at the same time.
Using one or more of these methods will give you access to detailed reports that will give you insight into all of your money-out transactions. This is a key component in having the ability to control expenses.
In this chapter, we will cover the following topics:
By the end of this chapter, you will know how to enter and pay your bills, and how to create recurring expenses for rent, utilities, and other recurring costs. Plus, you will understand how to write a check and print it directly from QuickBooks, and you will become familiar with the various ways in which you can upload receipts and bills in QuickBooks.
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.
For purchases made on account, entering bills into QuickBooks and paying them a few days before they become due is the best way to manage your cash flow. If you enter bills into QuickBooks as you receive them, you can run reports that will show you which bills are due, or are nearly due, so that you can plan ahead and ensure you have sufficient cash on hand to pay them. Unpaid bills are also referred to as accounts payable, or A/P for short. In the following sections, we will first cover how to enter bills, and then we will discuss how to pay a bill in QuickBooks Online (QBO).
Pro Tip: There are a number of apps available to help automate the bill entry process. From the left navigation bar, select Apps. In the search box, type the keyword bill pay
and several options such as Bill Pay for QuickBooks Online and bill.com will display. To learn more about the Intuit Apps marketplace, refer to Chapter 16, Finding Apps and Handling Special Transactions in QuickBooks Online.
Entering your bills into QuickBooks before they come due will help you to manage your cash flow. You can easily run reports, such as the Unpaid Bills report or the A/P Aging report, to see which bills are coming due or are past due.
To enter bills into QuickBooks Online, you will need to complete the following steps:
Figure 8.1: Navigating to Bill from the Vendors menu
Figure 8.2: Completing the Bill form for a vendor
The following is a brief description of the key fields in the Bill form. All fields must be completed, except for the DESCRIPTION field:
A+ Printing
is the vendor.123 Printers Way, Van Nuys, CA 91405
.09/17/2022
. 10/17/2022
.876543
.Workbooks for QBO Training
.200
workbooks were purchased.5
in our example.In our example, this bill only has an impact on the balance sheet. There is no impact to the profit and loss (income statement) reports. Inventory (which is an asset) increases by $1,000.00, and A/P also increases, which in turn increases current liabilities on the balance sheet report.
The journal entry that is recorded in QuickBooks for the preceding bill is shown in Figure 8.3:
Figure 8.3: Journal entry to record a vendor bill
If you are recording the purchase of an expense (i.e. consultation services or office supplies), instead of inventory, an expense account such as Consulting expense or Office supplies would be in place of inventory in our example. This would increase expenses on the profit and loss report. Accounts payable would still increase by the amount that was purchased.
In order to stay on top of your bills, it’s a good idea to enter them as soon as you receive them. Be sure to enter a due date, so that QuickBooks can alert you when a bill is coming due.
If you overpay a vendor or receive a credit for damaged or returned merchandise, you can enter the credit memo into QuickBooks and apply it to future purchases. However, if you don’t plan to order from that vendor again, you should request a refund. In our example, we received a credit on the order for the workbooks because the shipment was short by 10 workbooks.
To enter vendor credits into QuickBooks Online, you will need to complete the following steps:
Figure 8.4: Navigating to the Vendor credit form
Figure 8.5: Complete Vendor Credit form
The following is a brief description of the key fields in the Vendor Credit form. All fields must be completed, except for the DESCRIPTION field:
123 Printers Way, Van Nuys, CA 91405
.09/24/2022
. CM876543
.Ordered 200 workbooks, only 190 received
.10
.If you receive the credit before paying the original bill, then the A/P account will be reduced by the credit, and the inventory will be reduced by the same amount. Both of these accounts will only impact the balance sheet report. There is no impact to the income statement.
The journal entry that is recorded in QuickBooks for the preceding vendor credit is shown in Figure 8.6:
Figure 8.6: Journal entry to record a vendor credit
In our example, the debit to Accounts payable decreases the current liabilities on the balance sheet report by $50, and the credit to Inventory decreases total inventory on the balance sheet by $50.
After you enter a bill in QuickBooks, you will need to pay it before the due date. Paying bills in QuickBooks will ensure that the A/P balance is always up to date. It will also allow you to run reports, and to see which bills have been paid or need to be paid.
Follow these steps to pay bills in QuickBooks Online:
Figure 8.7: Navigating to Pay Bills from the Vendors menu
Figure 8.8: Completing the Pay Bills form
The following is a brief description of the fields in the Pay Bills form; all fields must be completed:
09/17/2022
in our example.1
in our example.Pro Tip: If you have more than one invoice for a vendor and your vendor prefers separate checks for each invoice, select the first invoice and save it, and then select each individual invoice one at a time, clicking Save in-between each. Then, when you print checks, there will be separate checks for each invoice. An example where this might be useful is paying utility bills. Many utility companies prefer separate checks per account for which you are paying a bill.
12345
is the reference number for the Staples bill and 876543
is the reference number for the A+ Printing bill.Pro Tip: To reinforce the steps covered for entering and paying bills in QuickBooks, watch this Intuit video tutorial, How to manage your bills in QuickBooks Online: https://youtu.be/p4FPKQ8Bf5M.
When you pay a bill in QuickBooks, it only has an impact on the balance sheet report. The A/P balance goes down because you no longer owe your vendor for the bill, and the business checking account goes down because a payment has been made. If you paid the bill with a credit card, the credit card balance goes up, which increases liabilities.
The following screenshot shows the journal entry recorded for the preceding bills:
Figure 8.9: Journal entry to pay bills
In our example, the debit to A/P decreases total liabilities on the balance sheet report by $1,075. In addition, the credit to the business checking account decreases total assets on the balance sheet report by $1,075. Paying bills in QuickBooks will give you access to detailed information about your expenses. You can run reports to show how much you are spending, which vendors you purchase from, and how often. These reports will help you to control what you are spending your money on, which allows you to properly manage your expenses. In Chapter 13, Vendor and Expenses Reports, we cover reports in detail.
Creating recurring expenses in QuickBooks can save you a lot of time. We will cover how to manage recurring expenses next.
In this section, we will show you how to create a template for recurring (repeat) expenses. Most businesses purchase goods and services from the same vendors. For example, rent and utilities are examples of recurring expenses that are generally paid monthly. Instead of creating these expenses from scratch each month, you can create a recurring expense, which is a template you can save with the vendor, amount, account, and other pertinent information.
When you are ready to pay a recurring expense, you can schedule the expense to be recorded automatically on a certain day. You can manually generate the expense when you need to pay it, or have QuickBooks send you an alert when it’s time to make a payment. Using recurring expense templates will save you time and will reduce the amount of manual data entry required.
Follow these steps to create a recurring expense in QuickBooks:
Figure 8.10: Selecting Recurring Transactions from the Lists menu
Figure 8.11: Clicking New to create a new recurring transactions template
Figure 8.12: Selecting the Transaction Type for a recurring transactions template
You can create a recurring transaction for a number of different types of transactions besides a bill. The other options available from the dropdown include Check, Credit card credit, Credit memo, Deposit, Estimate, Expense, Invoice, and Journal entry. While the screens may differ slightly, they will be very similar to what you see in this example.
Figure 8.13: Completing the recurring transactions template
The following is a brief description of the information required to complete the recurring transactions template:
Monthly Telephone Expense
is the template name in our example.2
days in advance is selected in our example.The Telephone Company
is the vendor in our example.10/01/2022
and the end date is None in our example.123 Telephone Way, Mansfield, Tx 76063
. Monthly cellphone bill
is the description in our case.$150.00
in our example.Figure 8.14: Recurring Transactions template (Expense)
In the Recurring Transactions template list, you will see the information previously entered in the template. The following info appears in Figure 8.14 above:
Monthly Telephone Expense
10/01/2022
The Telephone Company
150.00
In addition to creating recurring transactions such as bills to pay expenses, you can also create the following types of recurring transactions:
Pro Tip: Recurring transactions are ideal for loan payments or other cash disbursements that you may not receive a monthly bill for.
Pro Tip #2: If you need to pay a bill that was unexpected or past due, you don’t need to enter it as a bill and then pay it. Instead, you can go directly to the check register and write a check. We will cover writing checks in the next section.
So far, we have discussed how to pay expenses by entering them as bills and paying them at a later date, and how to set up recurring expenses. A third way in which you can record expenses for your business is by writing checks. The benefit of writing checks directly in QuickBooks is that you don’t have to waste time manually writing a check. Instead, you can create checks and print them directly from QuickBooks. This is ideal for vendors that typically don’t accept debit or credit card payments.
Follow these steps to write checks in QuickBooks Online:
Figure 8.15: Navigating to Check
Figure 8.16: Completing the Write Checks form
The following is a brief description of the information in the Check form:
Pro Tip: You can also use the Write Checks form to record expenses paid with a debit card. Instead of entering a check number in the Check no. field, you would use DB
or Debit
, indicating the expense was paid with a debit card. To record ACH transactions, you would put ACH
in the check number field.
September Rent
is the description in our example.1,500.00
.When entering a check into QuickBooks, it can have an impact on accounts that appear on both the balance sheet and the profit and loss (income statement). The balance sheet will always be affected because the bank account is included in the assets section of the balance sheet. However, the profit and loss will only be affected if you purchase an expense. Otherwise, if you purchase a product for resale (inventory), it will only have an impact on the balance sheet.
Figure 8.17 shows the journal entry recorded for the preceding check in Figure 8.16:
Figure 8.17: Journal entry to record payment of a bill by check
In our example, Rent expense increased by $1,500, which increases expenses on the profit and loss (income statement). The Business Checking account decreased by $1,500, which means assets have gone down on the balance sheet report.
After entering a check, you can choose to print the check immediately, or wait and print a batch of checks later on. In the next section, we will show you how to print checks.
In order to print checks, you must purchase check stock that is compatible with QuickBooks Online. You can order checks from a variety of places, such as your financial institution, or directly from Intuit. Visit the Intuit Checks and Supplies (https://intuitmarket.intuit.com/checks) website to learn more.
Follow these steps to print checks:
Figure 8.18: Navigating to Print Checks
Figure 8.19: Selecting the check type for printing checks
The following is a brief description of the steps:
Pro Tip: To recap the steps on writing and printing checks in QuickBooks, watch this Intuit video tutorial: https://quickbooks.intuit.com/learn-support/en-us/write-checks/how-to-record-print-checks/00/344866.
As discussed, printing checks directly from QuickBooks will save you time when you reconcile your bank account. Since expenses paid with a check are automatically recorded in QuickBooks when you save the check, you won’t have to worry about manually entering them later on. One way to have quick access to source documents is to attach receipts and bills to transactions by using the capture and categorize receipts feature. We will discuss this shortly.
Pro Tip: Imagine you have pizza delivered to the office and you need to quickly print one check. Click the + New button, select Check, enter the payment details, and select Print check at the bottom of the screen.
Like most transactions in QuickBooks, you can edit bills up until they are paid. However, after you have paid a bill you will need to either record a credit memo if you overpaid or request a new bill if you underpaid. To edit a bill, you need to go to the Vendor Center, select the vendor, and then click on the bill you wish to make changes to. After making the necessary changes, save the bill and close out of it. You can also edit checks in a similar manner. As long as you have not printed the check, you can make any changes necessary. Navigate to the check register, locate the check, and make the necessary changes. After you have printed a check, you will need to void it if it is incorrect. From the check register, select the check that needs to be voided. Click the Edit option and the check will display on your screen. At the very bottom of the page, you will see a tab that says More, click on it and the following menu will appear:
Figure 8.20: Reaching the option for voiding an expense from the More button
For expenses in general, if you have not closed the books or reconciled the bank account for the period, you can make changes to expenses that were previously recorded. If you have closed the books or reconciled the bank account for the period, you cannot make changes to the transaction date or amount. If a correction to the books is required, you will need to consult with your accountant to discuss recording a journal entry. See Chapter 15, Closing the Books in QuickBooks Online, to learn more about journal entries.
Receipt capture allows you to attach receipts and bills to transactions in QuickBooks. As a result, you will be able to quickly access source documents when needed. This feature works in two different ways. First, you can attach receipts and bills to transactions previously entered into QuickBooks Online. Second, you can use a receipt capture to record a transaction for the first time. Of course, you can use both methods interchangeably.
Perform the following steps to capture a receipt or bill:
Figure 8.21: Uploading receipts to QBO
There are three options available to capture receipts:
Pro Tip: Keep in mind that for each of the receipt capture options, there should only be one receipt per file. If you try to include more than one receipt in a file, QuickBooks will not be able to process the receipt capture.
Figure 8.22: Reviewing receipts uploaded in QBO
Figure 8.23: Reviewing a selected receipt in QBO
To summarize, we have covered how to use the capture and categorize receipts and bills feature, which allows you to attach source documents such as bills to existing transactions. In addition, you can create new transactions using this feature, which will save you the time you normally would have spent entering the data manually.
Pro Tip: You can also add receipts to transactions using the paperclip (Attachments) feature located at the bottom of the screen when you have an individual transaction open such as a bill:
Figure 8.24: Button for attaching a receipt to a transaction
In this chapter, we have shown you how to enter and pay your bills, how to enter vendor credits, how to manage recurring expenses, how to write checks, and how to print checks. We also covered the three ways in which you can upload bills and receipts to QuickBooks.
As a result, you will be able to stay on top of your cash outflow.
In the next chapter, we will show you how to reduce or eliminate the need to manually enter bank and credit card transactions by uploading transactions automatically into QuickBooks using bank feeds.
The primary difference between expense transactions and bank feed transactions is that expense transactions are typically entered manually through bills, checks, recurring expenses, and receipt capture, whereas bank feeds do not require manual data entry. Instead, your bank account is connected to QuickBooks and bank transactions automatically “feed” into the Banking Center in QuickBooks, saving you time.
3.147.65.65