Quickbooks

How do you let your customers know how much they owe you, and for what products or services? In these days of ecommerce and merchant accounts, your customers may provide a credit card number over the phone or on a website. Or perhaps you send invoices after a sale and receive checks or account numbers in the mail. QuickBooks can help you both create the invoices and record the payments.

There’s another type of sales document that you can use in certain situations: the sales receipt. You’d probably be most likely to use one of these when customers pay you in full for products or services at the same time they receive them.

Figure 1: If you receive full payment for a product or service at the same time the customer receives it, you should use a sales receipt.

Completing a sales receipt is similar to filling out an invoice or purchase order. Click Create Sales Receipts on QuickBooks’ home page or open the Customers menu and select Enter Sales Receipts. A screen like the one above will open.

Choose a Customer from the drop-down list and a Class (if applicable). If you have created more than one Template (more on that later), make sure that the correct one appears in the field. Verify that the appropriate Date and Sale No. read as they should. Click on the type of payment you’re receiving, and enter the check or credit card number where necessary (a small window will open for the latter).

Note: If you are working with a type of payment that does not appear in the four icons, click on the arrow below More to add it.

Now you’re ready to select the products or services you sold by clicking on the arrow in the field under Item to open the available list (if you have not created a record for what you’re selling, select and complete the fields in the New Item window that opens). Enter the quantity (Qty. ). The Rate, Amount, and Tax fields should fill in automatically, based on the information you entered when you create the item’s record.

When you’ve entered all of the items that the customer is paying you for, you can choose which Customer Message will appear on the sales receipt (you can see your options in the drop-down list found in the lower left corner of the screen). Anything you enter in the Memo field will be for your internal use only; it will not appear on the printed or emailed sales receipt.

Click Save & Close or Save & New.

Customizing Sales Receipts

Figure 2: QuickBooks provides tools for customizing forms, including sales receipts.

QuickBooks’ forms contain the fields most often used by small businesses. But you can alter them in numerous ways to meet your company’s needs. To customize a sales receipt, open the Sales Receiptwindow and click on the Formatting menu. Select Manage Templates.

You’ll want to make a copy of the original sales receipt so that the original will always be available. Click the Copy button in the lower left. “Copy of Custom Sales Receipt” appears in the list of templates. In thePreview pane on the right, click in the field next to Template Nameand replace the existing name with a new, more descriptive one if you’d like. Click OK.

The Basic Customization window opens. Click on Additional Customization at the bottom of the screen. You’ll see a window like the one in the image above. Click the Columns tab. The list on the left displays all of the columns that can be included in the body of your sales receipt.

Click in the boxes below Screen and Print to indicate which columns should display on your QuickBooks screen and which should appear on the customer’s copy. The numbers in the Order column can be changed to reflect which column will come first, second, etc.

Numerous Options

There’s a lot more you can do to customize your QuickBooks forms. And there are other situations where you might want to issue a sales receipt. If you would like to explore these and other elements of QuickBooks, please call the office to schedule a time that is convenient for you.

• By Leon Clinton
• July 31, 2016

There are many reasons why your customers send in payments past their due dates. Maybe they missed or misplaced your invoice, or they’re disputing the charges. They might not be very conscientious about bill-paying. Or they simply don’t have the money.

Sometimes they contact you about their oversight, but more often, you just see the overdue days pile up in your reports.

You could use stronger language in your customer messages. Send statements. Make phone calls if the delinquency goes on too long. Or you could start assessing finance charges to invoices that go unpaid past the due date. QuickBooks provides tools to accommodate this, but you’ll want to make absolutely sure you’re using them correctly–or you’ll risk angering customers and creating problems with your accounts receivable.

Setting the Rules

Before you can start, you’ll need to tell QuickBooks how you’d like your finance charges to work. It’s at this stage that we recommend you let us work with you. There’s nothing overly difficult about understanding finance charges in theory: you apply a percentage of the dollar amount that’s overdue to come up with a new total balance. But setting up your QuickBooks file with the finance charge rules you want to incorporate may require some assistance. If it’s done incorrectly, you will hear from your customers.

Here’s how it works. Open the Edit menu and select Preferences, then Finance Charge | Company Preferences.

Figure 1: Before you can start adding finance charges to overdue invoices, you’ll need to establish your company preferences.

What Annual Interest Rate percentage do you want to tack onto late payments? This is an issue we can discuss with you. Too low, and it’s not worth your extra time and trouble. Too high, and your customers may stop patronizing your business. And do you want to set a Minimum Finance Charge? Will you allow a Grace Period? If so, how many days?

You’ll need to assign an account to the funds that come in from interest charges. This needs to be an income account. In our example, it’sOther Income.

The next decision, whether to Assess finance charges on overdue finance charges, needs consideration–and some research. This may not be an option depending on the lending laws in the jurisdiction where your business is located. So again, if you want to charge interest on unpaid and tardy finance charges themselves, let’s talk.

When do you want the finance charge “countdown” to begin? When QuickBooks identifies a transaction that has not been paid within the stated terms, do you want the added charge to be applied based on the due date or the invoice/billed date?

Note: If your business sends statements rather than invoices, leave the Mark finance charge invoices “To be printed” box at the bottom of this window unchecked.

Applying the Rules

QuickBooks does not automatically add finance charges to your customers’ invoices. You’ll need to administer these additions yourself, though QuickBooks will handle the actual calculations. Open the Customers menu and select Assess Finance Charges to open this window:

Figure 2: You’ll determine who should have finance charge invoices created in the Assess Finance Charges window.

Make very sure that the Assessment Date is correct, as it has impact on QuickBooks’ calculations–because being even one day off makes a difference. Select the customers who should have finance charges applied by clicking next to their names in the Assess column. QuickBooks will display the Overdue Balancefrom the original invoice, as well as the Finance Charge it has calculated.

• If you choose not to apply finances charges to a customer because he or she has provided a good reason for the late payment, be sure the box in the Assesscolumn is unchecked.
• If you want to change the finance charge due for a valid reason, you can type over the amount in the last column. This would be a rare occurrence and should be exercised only after consulting with us.

Important: If there is an asterisk next to a customer’s name, there are payments or credit memos that have not yet been applied to any invoice.

When everything is correct, click the Assess Charges button at the bottom. QuickBooks will create separate invoices for finance charges for each customer who owes them.

We can’t stress enough the importance of consulting with us before you start to work with finance charges enough. Keep your company file accurate and your customers happy by getting this complex accounting element right from the start.

• By Leon Clinton
• June 30, 2016

If you’re using QuickBooks, you probably know that you’re complying with the rules of double-entry accounting. The software is designed such that you can be compliant with these requirements without even being aware of it. You’re dealing with invoices and purchase orders, bank account reconciliation and bill-paying and payroll, not debits and credits and journal entries. QuickBooks does the double-entry part in the background.

While every business that uses QuickBooks is following those same rules, each has its own unique structure and its own need to modify some elements of the program to do certain tasks. For example:

• Store more specific information about customers, vendors, and employees in their records,
• Differentiate between variations of similar inventory items, and
• Create more targeted reports.

This is where custom fields come in.

Defining Custom Fields

Figure 1: QuickBooks comes with pre-designed form and record templates.

One of the ways that QuickBooks simplifies your life as your company’s accounting manager is by providing pre-designed record and form templates. Need to create an invoice? There’s a form that already contains the most commonly-used data fields; you just fill in the blanks or select from drop-down lists. Want to store information about your customers and about the items you sell? Ditto.

However, if you need more fields than QuickBooks offers on a record or form, you can easily add your own. The software lets you add 15 fields total to customers and jobs, vendors, and employees, and you’re limited to seven for any one record type (if you want to use the same field in two of these, it will only count as one). And you’re allowed to define up to five fields for your item records.

This type of modification is easy to do, but it’s critical that you think carefully about what fields you should add. You don’t want to learn three or six months down the road that one isn’t really necessary and two more are needed, for example. This is especially important when you’re creating records for inventory items.

You may want to schedule some time with us to go over this (and to explore QuickBooks’ item-tracking features if you’re new to managing inventory). You can change custom field names, but you need to understand how this will affect your data if you do this.

Figure 2: It’s easy to add custom fields to records, but be sure you give a lot of thought to what will be needed.

Let’s say you want to add some custom fields to your customer records. Open the Customer Center by clicking the tab in the left vertical pane or opening the Customers menu and clicking on Customer Center. Double-click on a customer or click on the small pencil icon in the upper right. The Edit Customer window opens.

Click on the Additional Info tab on the left and then on the Define Fields button in the lower right. The Set up Custom Fields for Names window opens, as pictured above.

Click in the first column, under Label. Enter the name of the field as you would like it to appear in records and reports. Then click in the box or boxes below Cust, Vend, or Empl. If you want to use the same field in more than one record type, enter a check mark in both. Continue to enter field names until you’re done, then click OK.

Now when you create a customer record, you can fill in the blanks. And your new fields will appear as filters in some reports.

Figure 3: Custom fields can sometimes be used in reports.

You’ll follow a similar set of steps when you create custom fields for items in QuickBooks. Open the Lists menu and select Item List. Double-click on any item to open the Edit Item window. Click theCustom Fields bar on the right, then Custom Fields and Define Fields. If your company sells a lot of products with multiple variations, call the office before you attempt this.

Personalizing your copy of QuickBooks by adding custom fields has a lot of benefits. But this major structural change requires a lot of thought and planning up front to make sure that this feature is a plus for your business.

• By Leon Clinton
• May 31, 2016