Chapter 13. Managing Accounts Receivable

In addition to performing work, invoicing customers, and collecting payments, you also have to keep track of who owes you how much (known as Accounts Receivable) and when the money is due. Sure, you can tack on finance charges to light a fire under your customers’ accounting departments, but such charges are rarely enough to make up for the time and effort you spend collecting overdue payments. Far more preferable are customers who pay on time without reminders, gentle or otherwise.

Because companies need money to keep things running, you’ll have to spend some time keeping track of your Accounts Receivable and the payments that come in. In this chapter, you’ll learn the ins and outs of tracking what customers owe, receiving payments from them, and dinging them if they don’t pay on time. You’ll get up to speed on Income Tracker (which Intuit introduced in QuickBooks 2014), a handy dashboard that shows estimates you’ve created, how much customers owe—both overdue and not—and what’s been paid in the past 30 days.

In contrast to invoices, sales receipts are the simplest and most immediate sales forms in QuickBooks. When your customers pay in full at the time of the sale—at your retail store, for example—you can create a sales receipt so the customer has a record of the purchase and payment. At the same time, QuickBooks posts the money from the sale into your bank account (in QuickBooks, anyway) or the Undeposited Funds account. (Sales receipts work only when customers pay in full, because that type of sales form can’t handle previous customer payments and balances.) In this chapter, you’ll learn how to create sales receipts for one sale at a time and to summarize a day’s worth of merchandising.

Receivables Aging

You don’t have to do anything special to create Accounts Receivable—they’re the by-product of invoicing your customers. But receivables that are growing long in the tooth are the first signs of potential collection problems. Fortunately, with QuickBooks’ Income Tracker, Company Snapshot, Customer Center, and built-in reports, you have four ways to check the state of your Accounts Receivable.

Note

You can’t use Income Tracker if you have multiple currencies turned on (Multiple Currencies). When that preference is turned on, the Income Tracker entry doesn’t appear in the Customers menu. And in QuickBooks Pro and Premier, only users with full access to Sales and Accounts Receivables features (What the Access Areas Represent) can use Income Tracker.

Viewing Receivables with Income Tracker

Income Tracker (choose Customers→Income Tracker or click Income Tracker in either icon bar to open it), shown in Figure 13-1, is the best of both worlds: It provides the big picture of your unbilled, outstanding, and paid income and lists the transactions that contribute to those high-level numbers. Income Tracker also offers time-saving features for invoicing customers and collecting the money they owe you.

Note

The new Insights tab (The Insights Tab) on the Home Page has an Income section that includes Income Tracker’s overview bars for open invoices, overdue invoices, and payments made during the past 30 days. To display the full-blown Income Tracker, simply click any of those bars.

Here’s what each part of the Income Tracker window shows you:

  • Estimates. The blue box at the window’s top left shows the total value of estimates you’ve created. Although the label above the box reads “Unbilled,” this value doesn’t really represent unbilled income. Estimates are merely potential income. Customers have to approve those estimates and you have to perform the work or sell the goods before you can turn that money into unbilled income. In addition, you might create multiple estimates for the same customer and job to see which one is the winner.

  • Sales Orders. You see this light-blue box only if you have QuickBooks Premier or Enterprise; it shows the total value of open sales orders.

  • Time & Expenses. This dark-blue box is a great way to catch billable time and expenses that you haven’t added to invoices yet. It shows the total value of unbilled time and expenses and the number of records that contribute to that total.

    Tip

    In QuickBooks 2015, you can choose whether to hide or display some of Income Tracker’s boxes by clicking the Settings icon (the gear) at the window’s upper right. To hide estimates or unbilled time and expenses, turn off the Estimates and “Time and Expenses” checkboxes, respectively. (If you use QuickBooks Premier or Enterprise, you can also turn off the Sales Orders box.)

    The panel at the top of the Income Tracker window provides an income overview. The table below it lists the transactions that make up the overall totals.You can filter the transaction table in different ways: by customer, transaction type, status, or date. You can even process transactions in this window, for example, receiving payment on an open invoice, as shown here.

    Figure 13-1. The panel at the top of the Income Tracker window provides an income overview. The table below it lists the transactions that make up the overall totals. You can filter the transaction table in different ways: by customer, transaction type, status, or date. You can even process transactions in this window, for example, receiving payment on an open invoice, as shown here.

  • Open Invoices. The orange box below the Unpaid heading shows the total amount on your open invoices. This is current income that your customers owe—that is, the invoiced income that isn’t due yet.

  • Overdue. The red hue of this box emphasizes the total amount that’s overdue from your customers. If that number is larger than you’d like, filter the transaction list (you’ll learn how in a sec) to track down the customers you need to nudge into paying.

  • Paid Last 30 Days. The green box at the window’s top right displays how much your customers paid you in the last 30 days. The label at the bottom of the box tells you how many payments are included in that total.

  • The transaction table. The transactions listed in the Income Tracker window are the ones that contribute to the totals at the top of the window. For example, the number in the orange Open Invoices box is the total of all the open invoices in the table. The number in the red Overdue box is the total of all the table’s overdue invoices. The transactions with the word “Paid” in their Status cells make up the total in the green Paid Last 30 Days box. And the estimates in the table contribute to the total in the blue Estimates box.

And here’s what you can do in the Income Tracker window:

  • Filter transactions. Say that business is booming and Income Tracker’s table is awash with transactions. You can filter the table to drill down and see, for example, all the overdue invoices for the last quarter. To see transactions for a specific customer, click the down arrow to the Customer:Job box’s right, and then, in the drop-down list, choose the customer or job you want. Choose an entry in the Type drop-down list to show only a specific type of transaction, like invoices or received payments. The Status drop-down list lets you filter the table to show open, overdue, or paid transactions (alternatively, you can click one of the colored bars at the top of the window to filter for that status). And the Date drop-down list lets you filter by date range.

  • Sort transactions. You can sort the transactions in Income Tracker’s table by clicking any of the table’s column headings. (QuickBooks initially sorts the table by date from the most recent to the earliest.) For example, click the Due Date heading to sort transactions by due date. When you click a heading, QuickBooks sorts the table in ascending order (alphabetically, from smallest to largest values, or from earliest to most recent dates, depending on the type of information in the column). To sort in descending order, simply click the heading again.

  • Take action. Income Tracker makes it easy to take the next step with your transactions. For instance, if you just snagged a customer payment from your post office box, you can start the receive-payment process right in the Income Tracker window. To do that, click the appropriate invoice’s Action cell, click the down arrow that appears, and then choose Receive Payments from the drop-down list shown in Figure 13-1. Or choose Print or Email from the drop-down list to print or email the invoice. For estimates, the Action drop-down list includes additional options like “Convert to Invoice” (Creating an Invoice from an Estimate) and “Mark as Inactive” (Creating Multiple Estimates). To open a transaction in its corresponding window, just double-click it or select the transaction in the table, click Manage Transactions at the bottom of the window, and then choose Edit Highlighted Row in the drop-down menu.

    Note

    You can also create new transactions from within Income Tracker. Click the Manage Transactions button, and then, beneath the menu’s Create New heading, choose the type of transaction you want to create.

  • Print transactions in batches. You can also print several transactions at a time (invoices, sales receipts, and credit memos or refunds) from the Income Tracker window. For example, suppose you want to print new copies of all the invoices that are overdue to nudge your customers about paying them. To do that, click the red Overdue bar at the top of the window to display the overdue transactions. Next, in the table’s first column, turn on the checkboxes for all the transactions you want to print. Then click the down arrow to the right of the Batch Actions button and choose the type of transaction; QuickBooks opens the “Print [forms]” dialog box. (See Printing Forms to learn how to print forms.)

Note

Although Income Tracker makes it easy to stay on top of overdue invoices, some folks prefer the Collections Center, which includes an Overdue tab that shows customers with overdue invoices, the number of days overdue, and the customers’ phone numbers. You can also send out email reminders by clicking “Select and Send Email” near the top right of the Collections Center window. To open the Collections Center, in the Customer Center’s toolbar, click Collections Center. (If you don’t see this option, that means you need to turn on this feature. To do that, choose Edit→Preferences→Sales & Customers, and then click the Company Preferences tab. In the Collections Center section, turn on the Enable Collections Center checkbox.)

Getting a High-Level View with the Company Snapshot

Another handy feature is the Company Snapshot window (Figure 13-2), which can show each customer’s balance. To open it, choose Company→Company Snapshot, and then click the window’s Company tab if it’s not already selected. (When you want to see more detail about receivables, turn to QuickBooks’ built-in aging reports instead; they’re described in the next section.)

The Customers Who Owe Money section shows who owes you money, how much they owe, and when it’s due. (If you don’t see this section, try maximizing the window. If that doesn’t work, see page 705 to learn how to display it in the Company Snapshot.) If the due date is in the past, it’s displayed in red text.To record a payment, click the Receive Payments link (circled).

Figure 13-2. The Customers Who Owe Money section shows who owes you money, how much they owe, and when it’s due. (If you don’t see this section, try maximizing the window. If that doesn’t work, see page 705 to learn how to display it in the Company Snapshot.) If the due date is in the past, it’s displayed in red text. To record a payment, click the Receive Payments link (circled).

Viewing Receivables Detail in the Customer Center

Yet another way to view your Accounts Receivable is in the Customer Center (choose Customers→Customer Center or, on the Home Page, click Customers). The window’s Customers & Jobs tab lists your customers and jobs and the balance owed by each one. If you select a customer or job in the list, you can see the invoices or other sales transactions that generated the open balance on the right side of the window, as shown in Figure 13-3.

To see the transactions that make up a customer’s balance, select the customer on the Customers & Jobs tab. On the Transactions tab in the lower-right part of the window, in the Show drop-down list, choose Invoices; and in the tab’s Filter By drop-down list, choose Open Invoices, as shown here. A value in an invoice’s Aging cell indicates the number of days it’s past its due date.

Figure 13-3. To see the transactions that make up a customer’s balance, select the customer on the Customers & Jobs tab. On the Transactions tab in the lower-right part of the window, in the Show drop-down list, choose Invoices; and in the tab’s Filter By drop-down list, choose Open Invoices, as shown here. A value in an invoice’s Aging cell indicates the number of days it’s past its due date.

Note

In the Customer Center, if the customer’s balance on the Customers & Jobs tab doesn’t equal the total in the Transactions table, that’s a clue that not all transactions that affect the customer’s balance are displayed in the table. For example, if you’ve tweaked the Transactions table so that it lists only overdue invoices, the total at the bottom of the table’s Amount column is only for overdue invoices, whereas the balance on the Customers & Jobs tab is the customer’s total balance (overdue and not) taking into account invoices, statement charges, credit memos, payments, and so on.

Accounts Receivable Aging Reports

Aging reports tell you how many days have passed since you sent each open invoice, and viewing them is the first step in keeping your Accounts Receivable from growing overly ripe. It’s a fact of business life that the longer a customer hasn’t paid, the more likely it is that you’ll never see that money. Taking action before an account lags too far behind limits bad debts and protects your profits. (The box on Watching Receivables Trends describes a way to gauge how well you manage your Accounts Receivable.)

QuickBooks includes two built-in aging reports: A/R Aging Summary and A/R Aging Detail. These reports show how much your customers owe for the current billing period (invoices that are less than 30 days old), as well as unpaid invoices from previous periods (invoices that are between 1 and 30 days late, 31 to 60 days late, 61 to 90 days late, and more than 90 days late). The Accounts Receivable Graph can also show you some useful info. Here’s a bit more about each one:

  • A/R Aging Summary. For a quick look at how much money your customers owe you and how old your receivables are, choose Reports→Customers & Receivables→A/R Aging Summary. To see the transactions that make up a customer’s total, put your cursor over a summary value. When the cursor changes to a magnifying glass like the one circled in Figure 13-4, double-click the transaction.

    This report lists customers and jobs and shows the money they owe in each aging period. Ideally, you should see more zero balances as you look at older periods. When you’re on a mission to collect overdue accounts, start with the oldest aging period on the right side of the report.

    Figure 13-4. This report lists customers and jobs and shows the money they owe in each aging period. Ideally, you should see more zero balances as you look at older periods. When you’re on a mission to collect overdue accounts, start with the oldest aging period on the right side of the report.

    Note

    If you work with more than one currency, the A/R Aging reports and the Accounts Receivable Graph use your home currency for all values. But you can modify the A/R Aging Summary report to see transactions in the currencies in which they were recorded: In the report’s window, click Customize Report. On the Display tab of the Modify Report dialog box that appears, below the “Display amounts in” label, select the “The transaction currency” option, and then click OK.

  • A/R Aging Detail. To see Accounts Receivable transactions for all your customers categorized by age, choose Reports→Customers & Receivables→A/R Aging Detail.

  • Accounts Receivable Graph. This graph doesn’t show as much detail as either of the A/R Aging reports, but its visual nature makes aging problems stand out. To display it, choose Reports→Customers & Receivables→Accounts Receivable Graph. Ideally, you want to see the bars in the graph get smaller or disappear completely as the number of days overdue increases. To see more details for a particular period, double-click a bar in the graph to open a QuickZoom Graph. To see more detail about a customer, double-click the customer’s name in the legend or double-click the slice of the pie chart that corresponds to the customer.

Seeing What Customers Owe with Reports

Aging reports aren’t the only goodies you can generate in QuickBooks. To see all the reports associated with customers and what they owe, choose Reports→Customers & Receivables. Here’s an overview of when it makes sense to use these reports:

  • Customer Balance Summary. This report shows the balances for each job and the customer’s total balance. You can find this same total balance information on the Customer Center’s Customers & Jobs tab, but unlike that tab, you can easily print this report.

    Note

    In QuickBooks 2015, reports have been spiffed up with new fonts and shading to make them easier to read (see Adding Comments to Reports).

  • Customer Balance Detail. This report shows every transaction that makes up customers’ balances, so it can get pretty long. It lists every transaction (such as invoices, payments, statement charges, and credit memos) for every customer and job in your company file, whether the customer is late or not. To inspect a transaction’s details, double-click anywhere in the transaction’s row to see it in its corresponding window (Create Invoices for an invoice, for example). If you’d rather see the transactions for just one customer, open the Customer Center, select the customer, and then, on the right side of the window, click the Open Balance link.

  • Open Invoices. This report includes unpaid invoices and statement charges, as well as payments and unapplied credits, so you can see if a payment or unapplied credit closes out a customer’s balance. This report is sorted and subtotaled for each customer and job, so you can find an unpaid invoice quickly. When you find the invoice you want, double-click anywhere in its row to open it.

  • Collections Report. When you’re on a mission to collect the money that’s owed to you, this report shows the past-due invoices and statement charges by customer and job, along with the due date and number of days that the transaction is past due. If a customer has questions about a transaction, double-click the transaction’s row to view it in detail.

    Tip

    When customers have pushed their credit limits—and your patience—too far, you can easily create collection letters by merging information for overdue customers with mail-merge collection letters in Word. See Mail Merge to a Word Document for details.

  • Average Days to Pay Summary/Average Days to Pay. These reports show how long customers take to pay your invoices. The summary report lists each customer and the average days it took it to pay based on all transactions. If you notice customers going far beyond your limits, you might consider increasing your finance charges or looking for new customers.

  • Unbilled Costs by Job. Another way you might leave money on the table is by forgetting to add reimbursable expenses to invoices. Run this report to see whether there are expenses you haven’t billed; if there are, the report lists the type of expense and when you incurred it, among other info. If you spot older expenses that you haven’t yet billed, add them to the next invoice (Invoicing for Billable Time and Costs).

Receiving Payments for Invoiced Income

To record a payment, click Receive Payments on the Home Page or choose Customers→Receive Payments. Either way, QuickBooks opens the Receive Payments window, which handles full and partial payments, early payment discounts, credits, and downloaded online payments.

The Receive Payments window works for most payments, but you record some types of payments in other places. Here are the windows that can record payments and when to use them:

  • Receive Payments. When customers send you money to pay their invoices or their statement balances, on the Home Page, click Receive Payments to record the payment as explained below. This window is for full or partial payments that you receive after you’ve made a sale. It lets you apply early payment discounts and credits for returns, as well as downloaded online payments. (See Recording Deposits to find out how to record the deposits for any type of payment.)

  • Create Invoices. As explained in the box on Different Ways to Apply Payments, this window is where you record a partial payment that you receive before you prepare an invoice. These payments appear on the next invoice you create and reduce its balance. And if you happen to receive a payment while you’re preparing the customer’s next invoice in this window, you can add the payment to the invoice right then. You can also apply available credits in this window.

  • Enter Sales Receipts. When your customers pay in full at the time of sale (with cash, check, or credit card), record payments in this window (Creating Sales Receipts).

To record full or partial payments (with or without discounts or credits) that you receive from customers, follow these steps:

  1. Choose CustomersReceive Payments or, on the Home Page, click Receive Payments. (Alternatively, in the Customer Center, select the customer who sent a payment, and then, in the window’s toolbar, choose New TransactionsReceive Payments.)

    QuickBooks opens the Receive Payments window.

  2. In the Received From box, choose the customer or the job for which you received a payment, as shown in Figure 13-5.

    If the customer sent a payment that covers more than one job, choose the customer’s name rather than a job. QuickBooks then adds the Job column to the Receive Payments window’s table and fills in the rows with all the outstanding invoices for all the customer’s jobs. When an invoice applies to a specific job, the job’s name appears in the table. If the cell in the Job column is blank, the invoice applies directly to the customer, not to a job.

    Tip

    Income Tracker (Receivables Aging) can help you record payments more quickly. In the Income Tracker window (Customers→Income Tracker), click the Action cell in the row for the invoice for which you received a payment, and then choose Receive Payment on the drop-down menu. QuickBooks opens a new payment transaction in the Receive Payments window and fills in the Customer:Job box with the customer or job associated with the invoice you selected.

  3. In the Payment Amount box, type the amount of the payment (if the customer uses a foreign currency, type the amount received in the foreign currency).

    If you select a customer who is set up to use a foreign currency, QuickBooks automatically sets the A/R Account box to the Accounts Receivable account for that currency. For euros, for example, you’ll see “Accounts Receivable - EUR.”

    Tip

    If you choose a job and don’t see the invoice you expect, in the Received From box, choose the customer to see all invoices for that customer and its jobs. If the invoice is assigned to the wrong customer or the wrong job, edit the invoice (Modifying Invoices), and then choose the correct job in the Received From box.

    When you choose a customer or job in the Received From box, the Customer Balance at the window’s top right shows the corresponding balance, and QuickBooks fills in the table with every unpaid invoice for that customer or job. If you choose a customer (as shown here), QuickBooks adds the Job column to the table and fills in the rows with the customer’s outstanding invoices. The cell in the Job column lists the job’s name when an invoice applies to a specific job, and it’s blank when the invoice applies to the customer.

    Figure 13-5. When you choose a customer or job in the Received From box, the Customer Balance at the window’s top right shows the corresponding balance, and QuickBooks fills in the table with every unpaid invoice for that customer or job. If you choose a customer (as shown here), QuickBooks adds the Job column to the table and fills in the rows with the customer’s outstanding invoices. The cell in the Job column lists the job’s name when an invoice applies to a specific job, and it’s blank when the invoice applies to the customer.

    Tip

    You don’t have to fill in the Payment Amount box if you’ve turned on the “Automatically calculate payments” preference (Payments). With this setting turned on, QuickBooks fills in the payment transaction’s Payment Amount field with the value of the first invoice you select. As you select (or deselect) additional invoices, the program recalculates the total payment.

    If this preference is turned off, you have to fill in the Payment Amount field with the payment amount in order to select invoices in the table. If you leave the Payment Amount field blank and try to select an invoice in the table, QuickBooks warns you that you can’t apply an amount greater than the total payment plus any credits the customer has. The advantage to turning this preference off is that a discrepancy between the customer’s payment and the selected invoice total is easy to spot—the Underpayment or Overpayment section shown in Figure 13-6 appears, showing the difference between the two values.

  4. If you turned off the “Automatically apply payments” preference (Payments), in the window’s table, turn on the checkmark cells (in the first column) for the invoices to which you want to apply the payment, as shown in Figure 13-6.

    To tell QuickBooks to choose the invoices for you, on the window’s Main tab, click Auto Apply Payment. (Once you’ve selected at least one invoice to pay, this button’s label changes to Un-Apply Payment.) The box on Different Ways to Apply Payments explains how to adjust the amount of the payment that’s applied to the invoices you select.

    If the “Automatically apply payments” preference is turned on, after you enter the payment amount and either press Tab or click another box, QuickBooks automatically selects an invoice for you. If the payment doesn’t match any of the customer’s invoice amounts, QuickBooks applies the payment to the oldest invoices first. If the program doesn’t select the correct invoices, turn off the checkmark cells that QuickBooks turned on, and then turn on the checkmark cells for the invoices you want. (If QuickBooks selects the wrong invoices but you don’t notice until later, see Correcting Misapplied Customer Payments to find out how to correct this mistake after you’ve applied the payment.)

    Sometimes, the amount your customer sends doesn’t match any combination of open invoices.If that’s the case, first see if the customer deducted an available credit (page 350) or early payment discount (page 353). Otherwise, you can edit the values in the Payment column to allocate the payment to those invoices. (The total has to match the total payment.)

    Figure 13-6. Sometimes, the amount your customer sends doesn’t match any combination of open invoices. If that’s the case, first see if the customer deducted an available credit (page 350) or early payment discount (page 353). Otherwise, you can edit the values in the Payment column to allocate the payment to those invoices. (The total has to match the total payment.)

    Tip

    When you select a customer who is set up to use a foreign currency, the Receive Payments window’s “Exchange Rate 1 [currency] =” box comes to life, filled in with the current exchange rate set in QuickBooks. If you want to use a different rate, type it in this box. If the exchange rate you use when you receive the payment is different from the rate you used on the invoice, QuickBooks automatically calculates the gain or loss (Generating Tax Reports) for the transaction.

  5. To the right of the Payment Amount box, click the icon that corresponds to the method the customer used to make the payment.

    If you click Cash, QuickBooks displays the Reference # box, where you can type a receipt number or other identifier. If you click Check, QuickBooks displays the Check # box instead, so you can type the number from the customer’s check. For any type of credit card or EFT, in the Card No. box and Exp. Date boxes, type the card’s number and the month and year that it expires. The Reference # box that appears is perfect for storing the credit card transaction number.

  6. If the Deposit To box is visible, choose the account for the deposit, such as your checking account, money market account, or Undeposited Funds account.

    When you first start using QuickBooks, the program’s Use Undeposited Funds preference (Payments) is turned on, which tells QuickBooks to automatically deposit payments into your Undeposited Funds account. When this setting is on, you won’t see the Deposit To box, and the program holds payments in that account until you tell it to deposit those payments into a specific bank account.

    If electronic payments land directly in your bank account (for example, payments made with PayPal or a merchant credit card service), you can record those deposits to the appropriate bank account in the Receive Payments window. To do that, turn the Use Undeposited Funds preference off and then, in the Receive Payments window, choose the bank account in the Deposit To box.

    Tip

    To make reconciling your bank statement a bit easier, choose the Deposit To account based on the way your bank statement shows deposits you make. For example, if your bank statement shows only a deposit total regardless of how many checks were in the deposit, put payments in the Undeposited Funds account. If your bank shows every check you deposit, choose your QuickBooks bank account instead so that each payment appears separately. (Payments explains how to set your QuickBooks preferences so that the program always chooses Undeposited Funds for payments.)

    If the customer paid too much or too little (or you’ve selected too few or too many open invoices in the Receive Payments window), you’ll see an overpayment or underpayment message like the one in the lower-left part of Figure 13-6. Before you edit values in the Payment column, make sure that you’ve selected the correct invoices. Then see if the Available Credits value equals the Underpayment value. If it does, your customer reduced the payment by its available credit. See Applying Credits to Invoices When You Receive Payments for details about applying credits.

  7. If you want to print a payment receipt, at the top of the Receive Payments window, click PrintPayment.

    QuickBooks opens the Print Lists dialog box. If necessary, change the print settings, and then click Print.

  8. To assign the payment to the selected invoices and close the window, click Save & Close.

    If you want to apply another payment, click Save & New instead.

Applying Credits to Invoices When You Receive Payments

When something goes awry with the services or products you sell, customers won’t be bashful about asking for a refund or credit. And customers who buy from you regularly might prefer a credit against their next order rather than a refund so that checks aren’t flying back and forth in the mail (Handling Customer Refunds and Credits tells you how to create a credit).

As you saw on Applying Credits to Existing Invoices, you can apply a credit to a customer’s invoice at any time to reduce the amount that the customer owes. But if a credit is still available when you receive a customer’s payment, you can apply the credit and the payment at the same time. Here’s what you do:

  1. Choose CustomersReceive Payments or, on the Home Page, click Receive Payments.

    QuickBooks opens the Receive Payments window.

  2. In the Received From drop-down list, choose the customer or job you want. In the Payment Amount box, type the customer’s payment amount, and to the right of this box, click the button for the payment method the customer used.

    If you choose a customer or job with an available credit, the Available Credits section appears below the window’s table and shows the amount of credit that’s available (this section is visible in Figure 13-6). If you choose a customer, the Available Credits value represents all the credits available for all jobs for that customer. If your customer reduced the payment by the amount of its available credit, you’ll also see the Underpayment section at the window’s bottom left.

  3. To apply the credit to the invoice you selected, at the top of the Receive Payments window, click Discounts And Credits.

    QuickBooks opens the “Discount and Credits” dialog box (Figure 13-7).

    When you click a credit’s checkmark cell in the Available Credits table here, the Credits Used value changes to show the total credit that has been applied to the invoice, and the Balance Due value shows how much is still due on the invoice (if any).If you applied other credits to the invoice in the past, they appear in the Previously Applied Credits table at the bottom of this dialog box.

    Figure 13-7. When you click a credit’s checkmark cell in the Available Credits table here, the Credits Used value changes to show the total credit that has been applied to the invoice, and the Balance Due value shows how much is still due on the invoice (if any). If you applied other credits to the invoice in the past, they appear in the Previously Applied Credits table at the bottom of this dialog box.

  4. If necessary, in the Available Credits table, click the credit’s checkmark cell to turn it on.

    If the customer asked you not to apply a credit, turn off that credit’s checkmark cell. If the credit doesn’t appear in the “Discount and Credits” dialog box, it probably relates to a different job or to the customer only. If you want to apply a credit to a different job or to the customer’s account, see the box on Different Ways to Apply Payments.

  5. Click Done.

    QuickBooks closes the “Discount and Credits” dialog box and returns to the Receive Payments window, where you see the applied credit, as shown in Figure 13-8.

    When you apply a credit to an invoice, its amount appears in the Credits cell in the Receive Payments window’s table and to the right of the “Discounts and Credits Applied” label below the table.When you’ve applied all a customer’s credits, the Available Credits value equals 0.00.

    Figure 13-8. When you apply a credit to an invoice, its amount appears in the Credits cell in the Receive Payments window’s table and to the right of the “Discounts and Credits Applied” label below the table. When you’ve applied all a customer’s credits, the Available Credits value equals 0.00.

  6. Click Save & Close to apply the credit to the invoice.

    If the customer’s available credit is greater than the total for an invoice, you can still apply the credit to that invoice. QuickBooks reduces the invoice’s balance to zero but keeps the remainder of the credit available so you can apply it to another invoice. Simply repeat these steps to apply the leftover credit to another invoice.

Discounting for Early Payment

Customers aren’t eligible for early payment discounts until they actually pay early, so it makes sense that you apply such discounts in the Receive Payments window. The process for applying an early payment discount is almost identical to applying a credit. In fact, if an invoice qualifies for both a credit and an early payment discount, you can apply them both in the “Discount and Credits” dialog box.

Note

If the discount is for something other than an early payment, such as a product that’s on sale, instead of using the technique described in this section, add a Discount item to the invoice when you create it (Applying Subtotals, Discounts, and Percentage Charges).

Here’s how to apply an early payment discount to a customer:

  1. On the Home Page, click Receive Payments or choose CustomersReceive Payments.

  2. In the Receive Payments window’s Received From drop-down list, choose the customer or job for the payment you received.

    The window’s table then displays all the invoices and/or statements for that customer or job that aren’t paid.

  3. In the Payment Amount box, type the payment amount you received from the customer.

    If the “Automatically apply payments” preference is turned on (Payments), when you click away from this box, QuickBooks applies the payment to the customer or job’s open invoices. If QuickBooks doesn’t apply the payment to the correct invoices, you can choose the ones you want (Applying Credits to Invoices When You Receive Payments). If that preference is turned off, turn on the checkmark cells (in the first column) for the invoices to which you want to apply the payment

    If the customer already deducted the early payment discount, the Receive Payments window shows an underpayment (Figure 13-9).

  4. To apply the early payment discount, at the top of the Receive Payments window, click Discounts And Credits.

    QuickBooks opens the “Discount and Credits” dialog box. If the Credits tab is visible, click the Discount tab to display the Discount fields shown in Figure 13-10. If the date of the payment is earlier than the Discount Date that’s listed, QuickBooks uses the early payment percentage from the customer’s payment terms (Entering Payment Information) to calculate the Suggested Discount. For example, if the customer gets a 2 percent discount for paying early, the suggested discount is 2 percent of the invoice total.

    Note

    Customers often deduct their early payment discounts despite sending their payments after the early payment cutoff date. The typical reaction of most business owners is a resigned sigh. Although QuickBooks shows the suggested discount as zero when a customer doesn’t actually pay early, you can show your customer goodwill and accept his payment. In the Amount of Discount box, simply type the discount that the customer took.

    If the customer sent a payment that’s less than the invoice amount, you’ll see the difference as an underpayment, as shown here.Look below the unpaid invoice table for a message that says the customer has discounts or credits available, as unapplied discounts and credits might explain the difference between the payment and invoice amounts. If you see that message, click the Discounts And Credits button at the top of the window to apply the available discounts and credits.

    Figure 13-9. If the customer sent a payment that’s less than the invoice amount, you’ll see the difference as an underpayment, as shown here. Look below the unpaid invoice table for a message that says the customer has discounts or credits available, as unapplied discounts and credits might explain the difference between the payment and invoice amounts. If you see that message, click the Discounts And Credits button at the top of the window to apply the available discounts and credits.

  5. In the Discount Account box, choose the income account you’ve set up to track customer discounts.

    You might think it makes sense to post customer discounts to one of your income accounts for products or services you sell. But customer discounts tend to fall off your radar when they’re buried among your regular income. The best course of action is to keep track of the discounts you give by creating an income account specifically for them, called something imaginative like Customer Discounts.

    If you spot an expense account called Discounts, don’t use that as your customer discount account, either. An expense account for discounts is meant to track the discounts you receive from your vendors.

  6. If you use classes, in the Discount Class box, choose the appropriate one.

    This class is typically the same one you used for the invoice.

    QuickBooks automatically puts the suggested discount in the Amount of Discount box, but you can type a different amount—if the customer paid only part of the invoice early, for instance.The Invoice section at the top of the dialog box shows the amount due on the invoice and the balance due after applying the early payment discount you chose. If the customer has already paid the invoice in full, the early payment discount becomes a credit for the next invoice.

    Figure 13-10. QuickBooks automatically puts the suggested discount in the Amount of Discount box, but you can type a different amount—if the customer paid only part of the invoice early, for instance. The Invoice section at the top of the dialog box shows the amount due on the invoice and the balance due after applying the early payment discount you chose. If the customer has already paid the invoice in full, the early payment discount becomes a credit for the next invoice.

  7. Click Done.

    When QuickBooks closes the “Discount and Credits” dialog box and returns to the Receive Payments window, you’ll see the discount in two or three places, as Figure 13-11 shows. The early payment discount appears both in the invoice table’s Discount column and below the table next to the “Discount and Credits Applied” label. If the customer paid the invoice in full, the early payment discount also becomes an overpayment (not shown in Figure 13-11).

    Tip

    If a customer overpays, QuickBooks displays two options at the bottom left of the Receive Payments window: “Leave the credit to be used later” and “Refund the amount to the customer.” Unless your customer wants a refund, keep “Leave the credit to be used later” selected.

  8. When you’re done, click Save & Close.

You’ve just recorded the payment with the discount applied.

When you apply an early payment discount to an invoice, it appears in the Receive Payment window’s Discount cell, as shown here. The discount also contributes to the “Discount and Credits Applied” at the bottom of the window.

Figure 13-11. When you apply an early payment discount to an invoice, it appears in the Receive Payment window’s Discount cell, as shown here. The discount also contributes to the “Discount and Credits Applied” at the bottom of the window.

Correcting Misapplied Customer Payments

Say you realize that you’ve applied a payment to the wrong invoice. The way you correct this mistake depends on whether you applied the payment to a different invoice for the same customer or job, or you applied it to the wrong customer or job. This section shows you how to fix misapplied payments in both situations (regardless of whether you’ve deposited the payments).

Wrong Invoice, Right Customer or Job

If you simply selected the wrong invoice for a customer or job when you applied a payment, it’s easy to set things straight. Here’s how:

  1. Choose CustomersCustomer Center or, on the Home Page, click Customers. On the Customer Center’s Customers & Jobs tab, click the customer or job whose payment you misapplied.

    The Transactions tab in the Customer Center’s lower right displays the transactions for the customer or job you selected.

  2. On the Transactions tab, click the Show box’s down arrow, and then choose Received Payments.

    If you do that but still don’t see the payment you’re looking for, click the Filter By down arrow and choose All Payment Methods; or click the Date down arrow and choose a different date range.

  3. When you see the payment in question, double-click it.

    The Receive Payments window opens to the payment you double-clicked.

  4. In the Receive Payments window’s unpaid invoice table, you’ll see both the wrong invoice and the right one. Turn off the checkmark cell for the currently selected invoice; turn on the checkmark cell for the correct invoice, and then click Save & Close.

    QuickBooks applies the payment to the correct invoice.

Wrong Invoice, Wrong Customer

When you apply a payment to the wrong customer’s invoice, you can’t use the steps in the previous section. Here’s why: When you open the misapplied payment in the Receive Payments window, the Received From box contains the erroneous customer or job, and the invoices that appear in the window’s unpaid invoices table are for that customer. That means there’s no way to select the invoice for the correct customer in the Receive Payments window.

To correct this type of misapplied payment, you need to create a new payment for the correct customer and delete the payment you applied to the wrong customer. The good news is that this approach also works if you deposited a payment without applying it to an invoice; it even works if you’ve already reconciled the deposit with your bank account. Here are the steps:

  1. First, create a new payment for the correct customer.

    To do this, in the Customer Center (Customers→Customer Center), click the Customers & Jobs tab, and then select the customer or job to which the payment should be applied. Then, at the top of the window, click New Transactions→Receive Payments and follow the steps on Receiving Payments for Invoiced Income to record the new payment. Click Save & Close when you’re done.

  2. If you already deposited the misapplied payment, on the Home Page, click Record Deposits (or choose BankingMake Deposits). If you haven’t deposited the payment, skip to step 7.

    If you see the “Payments to Deposit” window, click OK to open the Make Deposits window.

  3. In the Make Deposits window’s toolbar, click Previous until you see the deposit you’re looking for.

    If you don’t see the deposit, be sure to choose the correct bank account in the window’s Deposit To box.

  4. In the window’s toolbar, click Payments. In the “Payments to Deposit” window, click the checkmark cell for the payment you created in step 1, and then click OK.

    The Make Deposits window’s table now lists both the old payment and the new payment, as shown in Figure 13-12.

    In the Make Deposit window’s toolbar, click Payments to open the “Payments to Deposit” window so you can add the new, correct payment to the deposit. Then, back in the Make Deposits window, delete the misapplied payment from the deposit by clicking anywhere in the payment’s row, and then, on the main QuickBooks menu bar, choosing Edit→Delete Line.

    Figure 13-12. In the Make Deposit window’s toolbar, click Payments to open the “Payments to Deposit” window so you can add the new, correct payment to the deposit. Then, back in the Make Deposits window, delete the misapplied payment from the deposit by clicking anywhere in the payment’s row, and then, on the main QuickBooks menu bar, choosing Edit→Delete Line.

  5. To delete the misapplied payment from the deposit, click anywhere in its row in the payments table, and then, on the main QuickBooks menu bar, choose EditDelete Line.

    The misapplied payment disappears, leaving the correctly applied payment in the table.

  6. Click Save & Close.

    QuickBooks saves the deposit with the correctly applied payment and closes the Make Deposits windows.

  7. Delete the original, misapplied payment.

    In the Customer Center, click the Transactions tab on the window’s left, and then click Received Payments. Double-click the payment you misapplied to open it in the Receive Payments window. At the top of the Receive Payments window, click Delete, and then, in the message box, click OK.

Because you deleted the original payment, it’s a good idea to document what you did. For example, add a note (Viewing To-Dos) to the customer or job to which the deleted payment belonged explaining why you deleted it.

Applying Finance Charges

If you’ve tried everything but some customers still won’t pay, you can resort to finance charges. These charges usually don’t cover the cost of keeping after the slackers, but QuickBooks at least minimizes the time you spend on this vexing task.

Note

Typically, only small businesses actually pay finance charges. Corporations usually ignore them, so you may decide to skip finance charges for your corporate clients (you’ll just have to reverse the charges later on).

Customers tend to get cranky if you spring finance charges on them without warning, so spend some time up front determining your payment policies: what interest rate you’ll charge, what constitutes “late,” and so on. Include these terms in the contracts your customers sign and on the sales forms you send. Then, after you configure QuickBooks with your finance-charge settings, a few clicks is all it’ll take to add those penalties to customer accounts.

Finance Charge Preferences

Before you apply finance charges, you need to tell QuickBooks how steep your finance charges are, when they kick in, and a few other details. To adjust these settings, choose Edit→Preferences→Finance Charge. Because your finance-charge policies should apply to all your customers, these settings are on the Company Preferences tab, which means only a QuickBooks administrator can change them. To learn how to set these preferences, see Customizing the Home Page.

Assessing Finance Charges on Overdue Balances

QuickBooks creates finance-charge invoices for customers tardy enough to warrant late fees, but you don’t have to print or send these invoices. Instead, you can assess finance charges just before you print customer statements (Printing Statements) to have QuickBooks include the finance-charge invoices on statements, along with any outstanding invoices and unpaid charges for the customer.

Tip

Make sure you apply payments and credits to invoices before you assess finance charges. Otherwise, you’ll spend most of your time reversing finance charges and working to get back into your customers’ good graces.

Here’s how to assess finance charges for slow-paying customers:

  1. Choose CustomersAssess Finance Charges or, on the Home Page, click the Finance Charges icon.

    The Assess Finance Charges window (Figure 13-13) opens.

    If your company file is set up to use multiple currencies, in the A/R Account box, select the account for the currency you want to work with.

    In this window, if a customer has payments or credits that you haven’t yet applied, QuickBooks precedes the customer’s name with an asterisk. So if you see any asterisks, click Cancel. After you’ve applied those payments (page 346) and credits (page 350), you’re ready to start back at step 1.QuickBooks automatically chooses the current date as the date on which you want to assess finance charges and selects all the customers with overdue balances.

    Figure 13-13. In this window, if a customer has payments or credits that you haven’t yet applied, QuickBooks precedes the customer’s name with an asterisk. So if you see any asterisks, click Cancel. After you’ve applied those payments (page 346) and credits (page 350), you’re ready to start back at step 1. QuickBooks automatically chooses the current date as the date on which you want to assess finance charges and selects all the customers with overdue balances.

  2. If you begin the process of preparing statements a few days before the end of the month, in the Assessment Date box, change the date to the last day of the month.

    The last day of the month is a popular cutoff date for customer statements. When you change the date in the Assessment Date box and then move to another field, QuickBooks recalculates the finance charges to reflect the charges through that new date.

  3. If you don’t want to assess finance charges on one of the customers in the list, in the window’s table, click that customer’s Assess cell to turn off the checkmark.

    QuickBooks automatically selects all customers with overdue balances, but you can let some of them slide without penalty. Since there’s no way to flag a customer as exempt from finance charges, you have to do this manually. If you reserve finance charges for your most intractable customers, click Unmark All to turn off all the finance charges. Then, in the Assess column, click only the cells for the customers you want to penalize.

    To view a customer’s invoices, payments, and credits, click the row for that customer, and then click Collection History. QuickBooks displays a Collections Report for that customer that shows every open transaction that’s past due.

  4. If you want to change a finance charge amount, click it in the Finance Charge column, and then type the new amount.

    The only time you might want to do this is when you’ve created a credit memo (Handling Customer Refunds and Credits) for a customer but you don’t want to apply it to an invoice. As long as the credit memo is out there, it’s simpler to forgo the finance charges until you’ve applied the credit.

  5. If you want to print and send the finance-charge invoices, turn on the “Mark Invoices ‘To be printed’” checkbox.

    If you plan to send customer statements, leave this checkbox turned off. Sending customers statements to remind them of overdue balances is one thing, but sending a statement and a finance-charge invoice borders on nagging.

  6. To finalize the finance-charge invoices for the selected customers, click the Assess Charges button.

    If you turned on the “Mark Invoice ‘To be printed’” checkbox, QuickBooks adds the finance-charge invoices to the queue of invoices to be printed. When you print all the queued invoices (Printing Forms), the program prints the finance-charge invoices as well.

Cash Sales

Receiving payment when you deliver a service or product is known as a cash sale, even though your customer might pay you with cash, check, or credit card. For example, if you run a thriving massage therapy business, your customers probably pay for their stress relief before they leave your office—and no matter how they pay, QuickBooks considers the transaction a cash sale.

If your customers want records of their payments, you give them sales receipts. In QuickBooks, a sales receipt can do double-duty: It records the cash sale in the program, and you can print it as a paper receipt for your customer. (The box on Receiving PayPal Payments explains how to record payments you receive through PayPal using QuickBooks sales receipts.)

Note

Although a cash sale is a simultaneous exchange of money for goods (or services), you don’t actually have to create a QuickBooks sales receipt at the time of the sale.

Here are the two most common ways of handling cash sales:

  • Recording individual sales. If you want to keep track of which customers purchase which products, create a separate sales receipt for each cash sale. Individual sales receipts track both customers’ purchases and the state of your inventory.

    Note

    If you keep QuickBooks open on the computer in your store, you can print individual sales receipts for your customers. But keeping QuickBooks running on the store computer could be risky if the wrong people start snooping around in your records. And, unless you’re completely proficient with the program’s sales receipts, you might find that hand-writing paper sales receipts is faster when your store is swamped. Then, when there’s a lull, you can enter individual receipts into your QuickBooks company file.

  • Recording batch sales. If your shop gets lots of one-time customers, you don’t care about tracking who purchases your products, but you still need to know how much inventory you have and how much money you’ve made. In this situation, you don’t have to create a separate sales receipt for each sale. Instead, create one for each business day, which shows how much money you brought in that day and what you sold.

Creating Sales Receipts

Creating sales receipts in QuickBooks is like creating invoices, except for a few small differences. Here’s what you do:

  1. Choose CustomersEnter Sales Receipts or, on the Home Page, click Create Sales Receipts.

    Note

    You see the Create Sales Receipt icon only if you’ve turned on the sales receipt preference (Turning Customer and Vendor Icons On and Off).

    The Enter Sales Receipts window opens.

  2. Click the icon for the method of payment, such as Cash, Check, or Credit Debit. If the customer paid with a check, fill in the Check No. box with the customer’s check number.

    For cash or credit cards, leave the Check No. box blank.

  3. Fill in the item table with the items your customer purchased.

  4. If you see the Deposit To box, choose an account to tell QuickBooks where to plop the money you made from the sale.

    The Deposit To box appears only if you’ve turned off the preference to use the Undeposited Funds account (Payments).

  5. If you want to print the sales receipt now, at the top of the window, click PrintSales Receipt to have QuickBooks open the Print One Sales Receipt dialog box.

    To learn more about your printing options, see Printing Forms.

  6. Click Save & Close to save the sales receipt.

    The Enter Sales Receipts window closes. If you want to record another sales receipt, click Save & New instead to start a new transaction. Click Revert to clear the info you filled in so you can start over.

Warning

Keeping track of customers who make one-time cash purchases can clog your Customer:Job List with unnecessary information. To keep your Customer:Job List lean, create a customer called Cash Sales (Creating a New Customer).

Editing Sales Receipts

If you’re in the process of creating a sales receipt, you can jump to any field and change its value. You can also insert or delete lines (Modifying Line Items) in the sales receipt’s line-item table as your customer tosses another book on the pile or puts one back on the shelf.

Although you can edit sales receipts after you’ve saved them, you won’t do so very often. After all, the sale is complete, and your customer has left with her copy of the receipt. However, you may want to edit the sales receipt after the sale to add more detailed descriptions to items, for example. To do so, in the Enter Sales Receipts window, click the left arrow (Previous) or right arrow (Next) until you see the receipt you want (or click Find, which is described on Using the Find Feature), and then add the additional info.

Voiding and Deleting Sales Receipts

If you created a sales receipt by mistake and want to remove its values from your accounts, you might think about simply deleting the receipt. However, you should always void sales receipts that you don’t want rather than deleting them.

If you delete a sales receipt, it’s gone for good: QuickBooks removes the dollar values and any sign of the transaction from your accounts. You’ll see a hole in your numbering sequence of sales receipts and an entry in the audit trail that says you deleted the transaction (Checking for Problems). Voiding a sales receipt, on the other hand, resets the dollar values for the transaction to zero (so your account balances show no sign of the transaction) and marks the transaction as void, so you have a record of it.

Here’s how to void a sales receipt:

  1. On the Home Page, click Create Sales Receipts (or choose CustomersEnter Sales Receipts).

    The Enter Sales Receipts window opens.

  2. Click the left or right arrow until you see the receipt in question, and then right-click the Sales Receipt window and choose Void Sales Receipt on the shortcut menu, as shown in Figure 13-14.

    All the values in the form change to zero, and QuickBooks adds “VOID:” to the Memo field. To remind yourself why you voided that transaction, type a reason after the colon.

  3. Click Save & Close.

Memorizing a Batch Sales Transaction

If you want to reduce your paperwork by recording one batch sales receipt for each business day’s sales, why not go one step further and memorize a batch sales receipt that you can reuse every day? Here’s how:

  1. On the Home Page, click Create Sales Receipts or choose CustomersEnter Sales Receipts.

    QuickBooks opens the Enter Sales Receipts window.

    Shortcut menus like this make choosing features easier.Simply right-click anywhere in the Enter Sales Receipts window to display the shortcut menu shown here.

    Figure 13-14. Shortcut menus like this make choosing features easier. Simply right-click anywhere in the Enter Sales Receipts window to display the shortcut menu shown here.

  2. In the Customer:Job box, choose the generic customer you created for cash sales.

    If you haven’t set up a cash sale customer yet, in the Customer:Job box, choose <Add New>. In the New Customer dialog box’s Customer Name box, type a name like Cash Sales. Then click OK to save the customer and use it for the sales receipt.

  3. If you typically sell the same types of items every day, in the table’s Item cells, choose those items.

    Leave the Qty cells blank because those values are almost guaranteed to change each day.

  4. If you want to split your daily sales among different types of payments (like Visa, MasterCard, and so on), add a Payment item for each type of credit card and other form of payment you accept, as shown in Figure 13-15.

    Because sales receipts are meant to handle cash, the total at the bottom of the form represents the bank deposit you make at the end of the day. But it can be helpful to know exactly which forms of payments customers used that day. To set up the memorized sales receipt so you can record that info, in the Item table, choose a Payment item, like Payment-Visa. (When you create a Payment item [Payment], choose the “Group with other undeposited funds” option so you can control when you deposit the money.) Leave the Amount cell blank; you’ll fill in the actual amounts when you use the memorized sales receipt to record the sales for a particular day.

    Add a Payment item for every form of payment you accept (American Express, Discover, debit cards, checks, and so on). Then, when you use the memorized transaction to record batch sales receipts, type a negative number for the amount charged to each type of payment. If the Total value doesn’t match the amount of your cash deposit, add an item for excess or short cash to make your bank deposit balance. (The next section explains how to use excess- and short-cash items.)

    Figure 13-15. Add a Payment item for every form of payment you accept (American Express, Discover, debit cards, checks, and so on). Then, when you use the memorized transaction to record batch sales receipts, type a negative number for the amount charged to each type of payment. If the Total value doesn’t match the amount of your cash deposit, add an item for excess or short cash to make your bank deposit balance. (The next section explains how to use excess- and short-cash items.)

    Tip

    By splitting a sales receipt among different types of payments, you can make a single deposit to each merchant card account at the end of the day. To do so, choose Banking→Make Deposits. In the “Payments to Deposit” window, choose the payment type in the “View payment method type” drop-down list. Select the deposits for that card, and then click OK to deposit them to the bank or merchant card company. Repeat this process for each type of payment you accept. (This technique works as long as your merchant card company deducts its fees as a single amount, instead of as a fee on every charge transaction.)

  5. When the sales receipt is set up the way you want, press Ctrl+M to open the Memorize Transaction dialog box.

    In the Name box, type a name for the reusable sales receipt, such as Day’s Cash Sales.

  6. If you want to use this memorized sales receipt only on the days you have cash sales, choose the Do Not Remind Me option.

    If you receive cash sales every day, choose the Remind Me option and then, in the How Often box, choose Daily.

  7. To memorize the sales receipt, click OK.

    QuickBooks closes the Memorize Transaction dialog box and adds the batch sales receipt to the Memorized Transaction List.

  8. If you created the sales receipt simply to memorize it, click Clear, and then close the Enter Sales Receipts window.

    To use the sales receipt, fill in the values in the table, and then click Save & Close.

Now that you’ve memorized the batch sales receipt, you can create a new sales receipt for a given day by pressing Ctrl+T to open the Memorized Transaction List window. There, double-click the memorized transaction for your batch sales receipt. QuickBooks opens the Enter Sales Receipts window to a new sales receipt based on the one you memorized. Edit the items in the window’s table, their quantities, and the prices to reflect your day’s sales, and then click Save & Close.

Reconciling Excess and Short Cash

When you take in paper money and make change, you’re bound to make small mistakes. Unless you’re lucky enough to have one of those automatic change machines, the money in the cash register at the end of the day rarely matches the sales you record. Over time, the amounts you’re short or over tend to balance out, but that’s no help when you have to record sales in QuickBooks that don’t match your bank deposits.

The solution to this reality of cash sales is one final sales receipt at the end of the day that reconciles your cash register’s total with your bank deposit slip. But before you can create this reconciliation receipt, you need to create an account and a couple of items:

  • Over/Under account. To keep track of your running total for excess and short cash, create an Income account named something like Over/Under. If you use account numbers, give this account a number that makes it appear near the end of your Income accounts. For example, if Uncategorized Income is account number 4999, make the Over/Under account 4998.

  • Over item. Create an Other Charge item to track the excess cash you collect, and assign it to the Over/Under account. Make sure that you set up this item as nontaxable.

  • Under item. Create a second Other Charge item to track the amounts that you’re short and assign it to the Over/Under account. This item should also be nontaxable.

At the end of each day, compare the income you recorded (run a Profit & Loss report and set the Date box to Today) with the amount of money in your cash register. Then create a sales receipt to make up the difference. Here’s how:

  • If you have less cash than you should, create a sales receipt and, in the first Item cell, add the Under item. In the Amount cell, type the amount that you’re short as a negative number. When you save this receipt, QuickBooks adjusts your income for the day in your income accounts to match the money in the cash register.

  • If you have too much cash, create a sales receipt and, in the first Item cell, add the Over item. In the Amount cell, type the excess amount as a positive number. This receipt increases your recorded income to match the money you have on hand.

Note

If you notice that your cash count at the end of the day is always short, a fluke of probability could be at work. But it’s more likely that someone is helping herself to the cash in your till.

Making Deposits

Whether customers mail you checks or hand over wads of cash, taking those deposits to the bank isn’t enough—you also have to record them in QuickBooks. In the Receive Payments window, if you designate a bank account as the Deposit To account (Receiving Payments for Invoiced Income), there’s nothing more to do after you save the payment—QuickBooks records the payment as a deposit to that account. However, if you initially store payments in the Undeposited Funds account, you have to work your way through two dialog boxes: one to record payments you receive, and then one to record the deposits you make in your bank account. (The box on Following the Money Trail explains how QuickBooks moves money between accounts as you record these transactions.) This section explains this two-step process. (The box on Putting Payment Deposit Types to Work explains how to record deposits made with different payment types.)

Choosing Payments to Deposit

If you store payments in the Undeposited Funds account, you end up with a collection of payments ready for deposit that coincide with the paper checks or cash you have to take to the bank (or the credit card payments and electronic funds transfers that show up in your bank account without any action on your part). When you have payments queued up for deposit and choose Banking→Make Deposits (or, in the Home Page’s Banking panel, click Record Deposits), QuickBooks opens the “Payments to Deposit” window, where you can choose the payments you want to deposit in several ways, as Figure 13-16 shows.

Note

If you have other checks to deposit, such as an insurance claim check, you’ll have a chance to add those to your deposit in the Make Deposits window as explained in the next section.

To filter payments by method, choose one in the “View payment method type” box; QuickBooks then displays only payments of that type.To record deposits for payments made in a foreign currency, in the “View Payments for currency” drop-down list (which you see only if you have multiple currencies turned on), choose the currency. You enter your bank’s exchange rate for the deposit in the Make Deposits window (as explained on page 370).

Figure 13-16. To filter payments by method, choose one in the “View payment method type” box; QuickBooks then displays only payments of that type. To record deposits for payments made in a foreign currency, in the “View Payments for currency” drop-down list (which you see only if you have multiple currencies turned on), choose the currency. You enter your bank’s exchange rate for the deposit in the Make Deposits window (as explained on page 370).

To choose specific payments to deposit, in the checkmark column, click each one you want to deposit. To select every payment listed, click Select All. When you’ve selected the payments you want, click OK. QuickBooks closes the “Payments to Deposit” window and opens the Make Deposits window, described next.

Recording Deposits

The Make Deposits window is like an electronic deposit slip, as you can see in Figure 13-17. The payments you chose to deposit in the “Payments to Deposit” window are already filled in. If you have other checks to deposit besides customer payments, they don’t automatically show up in this window, but you can add them to the table.

Note

If you’re depositing a payment made in a foreign currency, in the Make Deposit window’s “Exchange Rate 1 [currency] =” box, type the exchange rate that your bank used for the transaction (to find it, look at your bank statement or review the transaction on your bank’s website). The window’s table of deposits then shows the deposit amount in the foreign currency, and the bottom of the window shows the deposit total in both the foreign currency and your home currency.

After you make your foreign-currency deposits, you can see how much you gained or lost due to changes in the exchange rate by choosing Reports→Company & Financial→Realized Gains & Losses. This report shows the payment amounts in your home currency, the exchange rate, and the resulting gain or loss.

The Make Deposits window lets you specify the account into which you’re depositing funds, the date, and each payment in the deposit. If you’re in the habit of withdrawing some petty cash from your deposits, you can record that, too.To avoid bouncing checks, in the Date box, be sure to choose the date that you actually make the deposit.

Figure 13-17. The Make Deposits window lets you specify the account into which you’re depositing funds, the date, and each payment in the deposit. If you’re in the habit of withdrawing some petty cash from your deposits, you can record that, too. To avoid bouncing checks, in the Date box, be sure to choose the date that you actually make the deposit.

Here’s how to add these additional deposits:

  1. Click the first blank Received From cell and then choose the vendor or name of the source of your deposit. Then, in that row’s From Account cell, choose the account to which you’re posting the money.

    For example, if you’re depositing a refund check for some office supplies, choose the expense account for office supplies.

  2. In that same row’s Amount cell, fill in the amount of the additional deposit.

    If you like, fill in the rest of the row’s cells. For refunds or checks from other sources, jotting a note in the Memo cell can help you remember why people sent you money. And entering the check number gives your customer or vendor a reference point in case a question arises.

    Tip

    If you want to withdraw some money from your deposit for petty cash (Paying with Cash), in the “Cash back goes to” box, choose your petty cash account. (If you own a sole proprietorship, you can choose your owner’s draw account here instead.) Then, in the “Cash back amount” box, type the amount you’re deducting from the deposit.

  3. Repeat steps 1 and 2 for each additional deposit you want to record.

  4. When you’ve filled in all the fields you want, click Save & Close.

    QuickBooks posts the deposits to your accounts.

Depositing Money from Merchant Card Accounts

When you accept payment via credit card, the merchant bank you work with collects your customers’ credit card payments and deposits them in your bank account as a lump sum. However, you record your deposits in QuickBooks the way they appear on your bank statement, which might or might not show lump sums. For example, your merchant bank might show payments and merchant bank fees separately, whereas the amount deposited in your checking account is the net amount after the merchant deducts its fees.

Here’s how to record deposits of merchant credit card payments and fees into your bank account to match the way they appear on your bank statement:

  1. Choose BankingMake Deposits or, on the Home Page, click Record Deposits.

    In the “Payments to Deposit” window’s “View payment method type” drop-down list, choose the merchant card whose payments you want to deposit.

  2. In the window’s table, select the credit card payments you want to deposit by turning on their checkmark cells, and then click OK.

    QuickBooks opens the Make Deposits window, which lists the credit card payments in the deposit table. If the Deposit Subtotal amount doesn’t match the deposit that appears on your bank statement, the merchant bank probably deducted its fees; you’ll record those fees in the next step.

    Tip

    To make merchant card deposits easier to track, ask your merchant card company to charge one lump sum for fees instead of charging for each transaction; it will almost certainly say yes.

  3. In the Make Deposits window’s table, in the first blank row’s From Account cell, choose the account to which you post merchant card fees (such as Bank Service Charges). Then, in that row’s Amount cell, type the merchant card fees as a negative number.

    The Deposit Subtotal amount should equal the deposit that appears on your bank statement.

  4. When you’re done, click Save & Close.

Note

How soon you can enter your merchant card deposits in QuickBooks depends on how wired your company is. If you use Bank Feeds (Chapter 24), QuickBooks automatically downloads merchant card deposits into your company file. If you have online access to your merchant card account, make the deposit in QuickBooks when you log into your merchant card account online and see the deposit in your transaction listing. If you don’t use any online services, enter the deposit in QuickBooks when the merchant card statement arrives in the mail.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.15.143.40