This collection of miscellaneous tips and techniques contains something for every QuickBooks user. Here you find tips for correcting errors, and you learn how to customize a form. You also learn how to check your spelling and how to create mailing labels.
This chapter contains information about working with an outside accountant who can access your company information and help you make year-end journal entries to produce accurate financial statements. You learn how to void checks without affecting a prior period balance.
In addition, you explore budgets and how to produce budget reports. You also learn some tips for using a budget effectively. The QuickBooks Class feature, a method of grouping transactions, is also covered in this chapter, with information on how to incorporate classes into your forms and reports.
To spell correctly, or not to spel corectley—fortunately, there’s a bit more to setting your spelling preferences than that! Do you want QuickBooks to check your spelling on your forms? Are there certain types of words you want the spellchecker to ignore? The spelling preferences are personal settings, as opposed to companywide settings, so each QuickBooks user at your company can choose personalized spelling features.
Select Edit, Preferences.
Click Spelling.
Click the My Preferences tab.
Check the Always Check Spelling box to require that QuickBooks spellcheck each of your forms before printing, saving, or sending them.
Check Internet Addresses to eliminate URLs from spellcheck.
Check Numbers to eliminate spellchecker alerts on words containing numerals.
Check Capitalized First Letter to eliminate proper nouns from spellcheck.
Check All UPPERCASE Letters to eliminate from spellcheck words that contain all capital letters.
Check Mixed Case to eliminate from spellcheck words that contain capital letters after the first letter.
Did You Know?
Spellchecking is not available on all forms. The QuickBooks spellchecking feature is available only on forms you send to customers and vendors. This includes invoices, purchase orders, estimates, sales receipts, and credit memos. You can enforce automatic spellchecking, or you can spellcheck on an individual basis by clicking the Spelling button at the top of the form.
You can set up a budget in QuickBooks that you can use to track your company’s financial progress throughout the year and to draw comparisons between actual and budgeted performances. The easiest way to begin budget creation is to use a year-end income statement from your company’s previous year. You can use the numbers on the financial statement to get started with your budget and then fine-tune the budget after all the prior year’s numbers have been entered. QuickBooks has created a wizard to walk you through the process of setting up your budget.
Select Company, Planning & Budgeting; then select Set Up Budgets from the side menu that displays.
Important
If the Set Up Budgets window displays, click Create New Budget to open the window shown here. If this is the first time you have created a budget, the Create New Budget window opens automatically.
Enter the year (calendar year or fiscal year, depending on your company’s year-end) for which this budget will apply.
Indicate whether this budget is to be based on profit and loss or balance sheet (for this example, we use profit and loss).
Click Next.
If you want your budget to be organized by customer and job or by class, indicate that here. For this example, we do not organize the budget by these criteria. (Note: Class is not an option on this screen if your company does not use class tracking.)
Click Next.
Select whether you want to create your budget from scratch or from prior year financial statement numbers. For this example, we create the budget from prior year numbers.
Click Finish.
Did You Know?
Budget setup is easy after the first year. If you’ve used QuickBooks in the past, your prior year’s financial information is already saved in your file. Instead of creating your budget from scratch, you can use the prior year’s financial statement numbers as your starting point and save yourself the time of looking up and entering this information.
In the blank areas, fill in the monthly amounts for your budget. QuickBooks automatically summarizes your monthly amounts in the Annual Total column (the first column).
Save time by entering an amount in the first month; then click the Copy Across button to insert that amount in every other month for the year.
Automatically increment budgeted amounts by clicking the Adjust Row Amounts button. All amounts in the selected row are increased or decreased by the amount or percentage that you indicate.
In the window that displays after you click Adjust Row Amounts, choose whether you want to begin the increase or decrease with the first month or with the currently selected month.
Indicate whether you want the budgeted amount to increase or decrease by the amount you enter.
If you chose Currently Selected Month in Step 12, you have the option of checking the Enable Compounding box (not shown). This feature produces amounts that are incremented each month by the amount you enter in the next step.
Enter the amount or percent as a positive number in the field provided.
Click OK. All amounts that appeared on the budget line are increased or decreased based on your entries.
When you have finished entering all the budgeted information, click Save to save your budget.
Click OK to close the budget window.
To make changes to an existing budget, click the drop-down arrow and choose the budget you want to edit.
Did You Know?
You can save your budget as you go. You can click the Save button while you’re working on your budget to make sure your budgeted information is saved. Clicking Save authorizes QuickBooks to save the information you have entered but doesn’t close the budget setup window. Clicking OK saves and closes the window.
You can produce several budget reports in QuickBooks, comparing your actual performance to your budgeted performance. Income statements and balance sheets both utilize budgeted numbers. Use these reports to see how your company’s performance compares to your expectations.
Select Reports, Budgets & Forecasts, and then select Budget Overview from the side menu that displays.
Select the budget you want to view in your report.
Click Next.
Choose a report layout for the report.
Click Next.
Click Finish to produce the report.
QuickBooks provides an additional level of organization called classes. Classes enable you to group transactions in ways that can help you better analyze your company’s performance. For example, you can use classes to track transactions by region, salesperson, or type of job.
Select Edit, Preferences.
Click Accounting.
Click the Company Preferences tab.
Check Use Class Tracking for Transactions to turn on the class feature.
Click OK.
Select Lists, Class List (not shown). If this is the first time you’ve used classes, the list will be empty.
Click the Class button and select New from the drop-down menu to set up a new class.
Enter a name for this class.
If the class is a subclass of another class, indicate that by checking the Subclass Of box and selecting a class from the drop-down list.
Click OK to save the class.
Did You Know?
The Class option displays on forms. After you’ve turned on the class tracking feature in the Preferences window, you’ll notice a Class option on your various forms. The option is not present when class tracking is turned off.
Did You Know?
You can enable class and location tracking with QuickBooks Online Plus. After you’ve turned on the location tracking, you can select the terminology for the location based on what you call the different areas of your company you want to track. You can select from business, department, division, location, property, store, or territory.
You might think that you can enter only one class per form. But what if the information on your form relates to more than one class? For example, you might need to order items from one vendor that relate to different classes. You can solve this problem by putting a separate class column on the form instead of using the Class box at the top of the form. Then you can designate a separate class next to each item you order.
Important
Turn on Classes! You must have the Class feature turned on before performing this task.
Select Lists, Templates.
Double-click the form to which you want to add a class column.
Click the Additional Customization button in the Basic Customization window that displays (not shown).
Click the Columns tab in the Additional Customization window.
Check the box next to Class in the Screen column and optionally the Print column.
Click OK in the Additional Customization window.
Click OK in the Basic Customization window (not shown).
You can display several class-related reports right from the class list window. And don’t forget that you can customize many of the QuickBooks standard reports to include a column for your classes. See Chapter 18, “Working with Reports in QuickBooks,” for more information.
Select Lists, Class List.
Click the Reports button.
Choose from these reports:
QuickReport (Ctrl+Q)—Displays a report of all the transactions that refer to the selected class (Government in this example).
Profit & Loss by Class—Select Reports on All Classes, Profit & Loss by Class. This report shows you all income and expenses for the year to date, with a separate column for each class.
Profit & Loss Unclassified—Select Reports on All Classes, Profit & Loss Unclassified to display the Profit and Loss without breaking out amounts by class.
Graphs—Select Reports on All Classes, Graphs to select either graphs depicting Income and Expense Items by Class or Budget vs. Actual by Class.
When you send an invoice to a customer, it is common practice to indicate when you expect to receive payment. You might want to be paid the full amount in 30 days (net 30) or in 15 days (net 15). You might offer a small discount for early payment (2% 10 net 30 = 2% discount if the balance is paid in 10 days, but the full balance is due in any case in 30 days), or you might expect to be paid immediately (due on receipt). All these options are called terms, and QuickBooks starts you out with a sample list of frequently used payment terms. You can add your own favorite terms to this list.
Select Lists, Customer & Vendor Profile List; then select Terms List from the side menu that displays.
Click the Terms button and select New from the drop-down menu to create a new term.
Timesaver
You can also press Ctrl+N to open the New Terms window.
Enter a name for this term.
Select Standard to base the term on the date an invoice is issued. Alternatively, select Date Driven if you want the term to be based on a particular day of the month.
Enter the number of days until the full amount of the invoice is due.
Enter the discount percentage, if any, for early payment.
Enter the number of days during which the customer is eligible to claim the discount.
Click OK.
Did You Know?
Using payment terms results in better record keeping. When you enter payment terms, QuickBooks uses this information to determine due dates of bills and invoices and posts related notices in the Reminders window.
You no longer need to be a designer to create forms that wow your customers or that look more professional when communicating with your vendors. QuickBooks has a free form design service. Customize all your forms at once, add industry-specific designs, modify text font, and pick from several layout options.
Access the feature from Lists, Templates. Choose Create Form Design from the Templates menu lower left.
The QuickBooks Forms Customization dialog displays.
To add your company logo, click Add and you can browse to the location where you have stored your logo. Or select Need a logo? Get started for information on having a logo designed for your business (fees apply).
From the Industry drop-down menu, select your industry or show all industries. Click on a design to select a specific industry design.
Click Next to advance to the Colors and Fonts options in the wizard.
From the overall colors and fonts section, choose an overall font for the entire form, or customize with specific fonts for selected data. Also select the colors for your form’s grid.
Place a check mark next to the fields you want to include in your form. Grayed-out fields indicate missing information in your QuickBooks data file. (To update this information from the Company menu, select Company Information and enter the missing data).
Optionally, select the I Use Window Envelopes option to help guide the placement of the data on the form.
Click Next to display the Grid Style options.
Select your preferred shading options for the grid. Note that the form previews are for selecting shading options and do not necessarily match your own form data layout.
Click Next to review your design.
Click Back to return to previous choices and make changes.
Click Next on the Review Design dialog (not shown).
Place a check mark next to each form to which you want to apply the newly created design. What a timesaver! QuickBooks makes a copy of the original template, so you do not need to worry about overriding your previous design.
Click Apply.
Read the information on the Design Applied dialog (not shown). Click OK to close.
Optionally, save your design online by providing a name for the design and clicking Save. If you choose the option to Save, follow the instructions to create an Intuit online account (not shown).
Did You Know?
Does your company need to have a logo designed? Click the Need a Logo? link on the QuickBooks Forms Customization screen, and several designers will provide samples that you can purchase. Web design, brochure design, graphic design, and merchandise logo design are also offered.
The previous section provided steps to use the QuickBooks forms designer to customize the professional look of your forms. The following steps help you change the layout of the data on your forms. QuickBooks comes with a collection of standard forms that are ready for your use. You are welcome to use these forms as is, or you can determine what data is displayed or printed on the form.
Select Lists, Templates.
Click a form you want to revise. For this example, the MyDesign Intuit Product Invoice has been selected.
Choose Templates, Edit Template from the button at the bottom of the window, or double-click the template name.
In the Basic Customization window that displays, click the Manage Templates button.
If you did not previously add a logo to your documents, place your logo image file in the images folder of your QuickBooks directory. Check the Use Logo box and navigate to the location of your logo image file. Your logo must be a JPG, GIF, or BMP file.
Modify the selected detail as needed; most of this should already be selected from your work in customizing the form (see previous task).
Click the Additional Customization button.
Click the Header tab to customize the details that print at the top of the invoice form. Check boxes to choose or uncheck boxes to deselect the elements you want to include.
Click the Columns tab to choose which columns should appear in the print and screen versions of the item description area of your form, and indicate the order in which they should appear.
Did You Know?
There are screen elements, and there are print elements. For each form, some elements are displayed only on your screen and not on the printed form, other elements are displayed on both the screen and the printed form, and some elements are displayed only on the printed form. Check boxes in either the Screen or the Print column, or both, to determine where the elements appear.
Did You Know?
Certain form elements can’t be changed. You might see a message indicating that some of the design options are unavailable to you. If you choose to edit a standard Intuit form, there are certain areas you are not permitted to change. You can overcome this obstacle by choosing to create a new form from the existing template, as we have done in this example.
Click the Prog Cols tab. (This tab displays only if you have chosen Invoice as your form type.) Choose which columns should appear on the print and screen versions of your progress invoice form, and indicate the order in which they should appear. Note: The Estimate Columns portion of this screen only displays if you have turned on the preference for progressive billing.
See Also
More information about estimates and progressive billing can be found in Chapter 8, “Job Cost Estimating and Tracking.”
Click the Footer tab. Check boxes to add features to the bottom of the print and screen versions of your form; uncheck boxes to remove features.
Click the Print tab. Choose whether you want to use the default printer settings from your QuickBooks Printer Setup, or you can choose to set specific printer settings for this form.
Check the box Print Page Numbers if you want page numbers to appear on multipage forms.
Check the Print Trailing Zeros box if you want QuickBooks to display insignificant, or trailing, zeros so that numbers will be aligned on the form. If you choose to display the zeros, you can indicate how many decimal places you want to display.
Click the Layout Designer button to view your masterpiece.
In the Layout Designer, click the Margins button to designate the size of your form.
Click the Grid button to display a nonprinting grid that can help you line up various elements on your form.
Click specific elements and drag them to new locations (not shown).
Click the handles on the corners of form elements to resize them (not shown).
Click OK when you have completed working with the Layout Designer.
Click OK to close the Additional Customization window.
Click OK to close the Basic Customization window (not shown).
Did You Know?
You can preview your new form. In the actual form window, click the arrow next to the Print button and then select Preview.
For some transactions, no QuickBooks standard form is available. For these transactions, you use the General Journal. The General Journal is the place where you adjust the balances in your accounts without the use of forms such as invoices, bills, and checks. In this journal, you can reclassify balance sheet information, void a prior period check (as in Chapter 5, “Making Purchases and Recording Payments”), record depreciation and amortization expenses, and reclassify amounts charged to the wrong account. General Journal entries are made to accommodate these changes. For this example, we create a General Journal entry to record depreciation expenses.
Select Company, Make General Journal Entries.
Verify the date and entry number for this journal entry.
Enter the first account name.
Enter the amount in the Debit or Credit field.
Enter a description in the Memo field (optional, but recommended).
Enter a customer name in the Name field if this amount is to be associated with a specific customer. QuickBooks adds a check mark in the Billable field, indicating that the amount is to be transferred to a customer’s invoice.
Click the Billable field if you want to uncheck the box and not have this amount transferred to a customer’s invoice.
Enter a class if you are using the Classes feature.
Enter the next account name.
Verify the amount.
Repeat these steps until you have entered all the accounts required of this journal entry.
Click a Save option.
Did You Know?
Journal entries aren’t just for depreciation. Use a journal entry whenever you need to enter or change information in your accounting records and no obvious form is available for the job.
Did You Know?
It’s easy to reverse a journal entry. Some journal entries get reversed at the end of each month, quarter, or year. Open an existing journal entry and click the Reverse button located at the top of the General Journal Entry window. A new entry displays, dated for the first day of the following month, with the prior entry’s amounts reversed.
If you travel or work out of the office and want to access your QuickBooks file from a remote location, the QuickBooks Remote Access feature is the tool you need. Depending on which version of QuickBooks you purchased, you may get 6 or 12 months free. Optionally, you may select a different level of service with various monthly fees to use the remote service.
In QuickBooks, click File, Remote Access (or Accountant, Remote Access) to sign up and learn more about the remote access feature.
After the remote access feature is activated, you are given a web address, login name, and password. Depending on the level of service you purchase, you can perform the following tasks from any location 24 hours a day with remote access:
Log in and open your company file.
Enter transactions in your company file.
Transfer files from one computer to another (depending on the level of service purchased).
Meet clients in an online remote location, with video, record, and playback capabilities.
Access files and applications on other remote computers (depending on the level of service purchased).
Print information from your company file (depending on the level of service purchased).
Did You Know?
Fees are subject to change. Any fees for services that are quoted in this book are the fees that were in place when the book went to press. The fees might have changed by the time you decide to purchase these services. Be sure to check online at the web address you are given to find out the latest information about the exact fees for a service before you agree to purchase the service.
Sending an announcement to all your customers, vendors, or employees is easy when you use the address information already stored in your QuickBooks file to create mailing labels. QuickBooks lets you select the group and then produce labels based on your specifications.
Select File, Print Forms; then select Labels from the side menu that displays.
Select which group of labels you want to print. For this example, the customer list has been selected.
Indicate whether you want to narrow the mailing list to particular types.
Indicate whether you want to specify ZIP Codes that begin with a particular number.
In the Sort Labels By drop-down list, indicate how you want the list to be sorted.
Check Print Labels for Inactive Names if you want to print labels for names that are inactive.
Check Print Ship to Addresses Where Available to use ship to addresses instead of mailing addresses.
Check whether you want to print labels for individual jobs (only applicable if you are printing labels for customers).
Click OK.
Select from the Label Format list to choose the style of label to print.
Click Preview to see whether the labels you are about to print are what you expect.
Click Align if you need to adjust the alignment of the text that will appear on your labels.
Enter any horizontal or vertical adjustments that you need to make to align your printed material with your labels.
Click Print Sample and print a test version on plain paper to see how the labels will look without wasting label paper.
Click OK to close the Fine Alignment window after making any necessary adjustments.
Click Print.