Chapter 24
Customizing QuickBooks for Your Business
In this chapter:
• Configure preferences
• Customize transaction templates
The Preferences settings you establish in QuickBooks allow you to control the way you complete tasks, how data is entered, and how it is reported. It’s not uncommon for QuickBooks users to change or tweak these preferences periodically. In fact, the more you use QuickBooks and understand the way it works, the more comfortable you’ll be with changing preferences.
Many of the templates that QuickBooks uses allow customization so that you can capture additional information about your transactions. Once captured, this information is available in reports. The ability to customize templates also means that you can modify the way information is displayed in a transaction window, which makes it easier to fill in a form with just the information that you need.
Customize Settings and Options
Your settings and options for the available QuickBooks features are maintained in the Preferences dialog, which you open by choosing Edit | Preferences from the QuickBooks menu bar.
Each category in the Preferences dialog is accessed by clicking the appropriate icon in the left pane. While every category has the two tabs My Preferences and Company Preferences, not every category will have options available on each tab.
• The My Preferences tab is where you configure your preferences as a QuickBooks user. Each user you create in QuickBooks can set her own My Preferences. QuickBooks will apply the correct preferences as each user logs into the company file.
• The Company Preferences tab is the place to configure the way the QuickBooks features work for the current company, regardless of which user logs in. Only the Admin or an External Accountant user can change settings in the Company Preferences tab.
As you configure options and move from one category of the Preferences window to another, you’re asked whether you want to save the changes in the section you just left.
For convenience, all of the Preferences categories are covered in this chapter. However, you may also find some additional details about a specific preference category in a relevant chapter.
Accounting Preferences
Click the Accounting icon on the left pane of the Preferences dialog to open the Accounting preferences (see Figure 24-1). There are only Company Preferences available for this section; the My Preferences tab has no options available.
FIGURE 24-1 |
Configure the way basic accounting functions work. |
You can select the option to use account numbers, and if so, you should also select the option Show Lowest Subaccount Only. The latter option is useful because it means that when you see an account number in a drop-down list (in a transaction window), you see only the subaccount. If the option is not selected, you see the parent account followed by the subaccount, and since the field display doesn’t show the entire text unless you scroll through it, it’s hard to determine which account has been selected.
The option to require accounts means that every item and transaction you create in QuickBooks has to be assigned to an account. If you disable this option, transaction amounts that aren’t manually assigned to an account are posted to Uncategorized Income or Uncategorized Expense. These amounts will show as such on reports—not really useful when you want to analyze your business.
You can also enable the Class feature, which lets you create Profit & Loss reports for divisions, departments, or other categories by which you’ve decided to analyze your business.
The other options on this dialog are self-explanatory, except for the Closing Date section, which is discussed in detail in Chapter 18.
Bills Preferences
In the Bills category, you have the opportunity on the Company Preference tab to set options for the way you enter and pay vendor bills:
• You can set default terms (QuickBooks sets this at ten days, but you can change this default). When you create terms and link those terms to vendors, QuickBooks ignores this default for any vendor that has terms configured.
• You can tell QuickBooks to take discounts and credits automatically when you’re paying vendor bills. If you choose the discounts option, you’ll be asked to select a Default Discount Account that QuickBooks will post your discounts to.
Calendar Preferences
All the settings available in this preference area are found only on the My Preferences tab. This means that the choices you make here will apply when you log into QuickBooks. Other users will see the default settings unless they also make changes.
The Calendar Settings area on this tab gives you several alternatives on the view (daily, weekly, monthly) that should be set as your default. If you can’t decide, you can tell QuickBooks to open the view that you were using the last time you had your calendar window open. Other options in the Calendar Settings area include the number of days you want to appear for each week and the type of transactions your calendar should display for you.
The Upcoming & Past Due Settings area gives you control over which future and past-due transactions will make their way onto your calendar.
Checking Preferences
This category has options in both the My Preferences and Company Preferences tabs. On the My Preferences tab, you can select default bank accounts for different types of transactions. Skip these options if you only have one bank account.
The Company Preferences tab (see Figure 24-2) offers several options concerned with check printing, which are described in the following paragraphs.
FIGURE 24-2 |
Select the options you need to make check writing more efficient. |
Print Account Names On Voucher
This option is useful only if you print your checks and the check forms you purchase have vouchers (stubs). If so, selecting this option means that the text on the stub will display posting accounts. That information is of no interest to your vendors, so only use this option if you keep and file check vouchers instead of leaving them attached to the check.
Change Check Date When Non-cleared Check Is Printed
Selecting this option means that at the time you print checks, the current date becomes the check date. If you don’t select this option, the check date you specified when you filled out the check window is used, even if that date has already passed.
Start With Payee Field On Check
Enabling this option forces your cursor to the Payee field when you first bring up the Write Checks window. If the option is not enabled, the Bank Account field is the first active field. If you always write checks from the same bank account, enable this option to save yourself the inconvenience of pressing TAB.
Warn About Duplicate Check Numbers
This option means that QuickBooks will warn you if you attempt to save a check with a number that already exists.
Autofill Payee Account Number In Check Memo
Most vendors maintain an account number for their customers, and your own account number with that vendor can be included on the checks you print. In order for this to occur, you must fill in your account number in the Account No field on the Payment Settings tab in the vendor record. The printout appears in the Memo section on the lower-left section of the check.
Select Default Accounts To Use
You can set the default bank accounts for different types of payroll transactions, which is important if you have a separate bank account for payroll. Then, when you create these checks, you don’t have to select the bank account from a drop-down list in the transaction window.
Bank Feeds
If you use the Bank Feeds (aka Online Banking) to download your banking transactions, you can choose how you want to view and enter transactions. Express mode (which was a new addition in QuickBooks 2014) uses a Transaction List window, which you’ll use to add or match transactions to your QuickBooks company file.
Express mode also gives you more robust options on how your transactions are matched to existing QuickBooks names (called renaming rules). Specifically, you can control whether QuickBooks automatically creates an “alias” name for you or whether you want to be asked to create an alias name.
If you select Classic (Register) mode, the work of processing and categorizing your transactions happens while in a register view.
As you make your decision on the Bank Feeds mode that you want to use, keep in mind that the renaming rules you set in Express mode are not available if you switch to Register mode—and vice versa.
Desktop View Preferences
This is where you can modify the way the QuickBooks window looks and acts. The My Preferences tab (see Figure 24-3) contains basic configuration options. In the View section, you can specify whether you always want to see one QuickBooks window at a time or view multiple windows.
FIGURE 24-3 |
Configure the look and behavior of the QuickBooks window. |
• Choose One Window to limit the QuickBooks screen to show one window at a time, even if you have multiple windows open. The windows are maximized and stacked atop each other, with only the top window visible. A convenient way to switch between multiple windows is by using the Open Window List. To add this list to the left side of your QuickBooks window, select View | Open Window List.
• Choose Multiple Windows to make it possible to view multiple windows on your screen. Selecting this option activates the arrangement commands on the Window menu item, which allows you to stack or arrange windows so that more than one window is visible at a time.
In the Desktop section, you can also specify what QuickBooks should do when you open and exit the software, choosing among the following options:
• Save When Closing Company This means that the state of the desktop is remembered when you close the company or exit QuickBooks. Whichever QuickBooks windows were open when you left will reappear when you return. You can pick up where you left off. If you select the option Show Home Page When Opening A Company File, that option overrides this option, so if you close the company file after closing the Home page, the Home page appears on top of any open windows when you open the company file.
• Save Current Desktop When you choose this option, the next time you open QuickBooks, it displays the desktop as it was the last time you worked in your company file.
• Don’t Save The Desktop This tells QuickBooks to display an empty QuickBooks desktop (unless you enable the Show Home Page When Opening A Company File option) when you open this company file or when you start QuickBooks again after using this company file. The desktop isn’t really empty—the menu bar, Icon Bar, and any other navigation bars are on the desktop, but no transaction or list windows are open.
• Keep Previously Saved Desktop This is available only when you select Save Current Desktop. This option tells QuickBooks to display the desktop as it was the last time you used the Save Current Desktop option.
• Show Home Page When Opening A Company File This tells QuickBooks to display the Home page when you open the company file.
Buttons are available to configure Windows settings for display and sounds. Clicking either button opens the associated window in your Windows Control Panel. The display and sounds configuration options you change affect your computer and all your software, not just QuickBooks.
Use the drop-down menu under Company File Color Scheme to change the color associated with the QuickBooks file that you’re working in. Changing colors can be an effective way to quickly differentiate one QuickBooks company file from another—especially helpful if you find you’re often doing work in multiple company files.
In the Company Preferences tab, you can customize some of the contents of the Home page. If you want to add an icon on the Home page for a particular feature (such as Estimates), this tab also tells you whether that feature has been enabled in your company file. If the feature hasn’t been enabled, click the feature’s name to open its category in the Preferences dialog. Turn the feature on to add its icon to the Home page, and then click the Desktop View icon to return to this window.
Finance Charge Preferences
In the Company Preferences tab, you can turn on, turn off, and configure finance charges. Finance charges can get complicated, so read the complete discussion about this topic in Chapter 10.
General Preferences
This dialog contains options for the way you work in QuickBooks. There are settings on both the My Preferences and Company Preferences tabs.
The My Preferences tab (shown in Figure 24-4) offers a number of options that are designed to let you control the way QuickBooks behaves while you’re working in transaction windows.
FIGURE 24-4 |
The My Preferences tab in General Preferences helps you control the way QuickBooks behaves when you’re the logged-in user. |
Pressing Enter Moves Between Fields
Use this option to tell QuickBooks that you want to use the ENTER key to move between fields rather than the default method, which is the TAB key.
Automatically Open Drop-Down Lists When Typing
This is a handy option that’s used when you’re making selections from drop-down lists. When you begin typing the first few letters of the listing you need, the drop-down list appears and you move to the first listing that matches the character(s) you typed.
Beep When Recording A Transaction
If you don’t want to hear sound effects as you work in QuickBooks, you can deselect the option. But if you select this option (which is the default QuickBooks setting), you can control what sounds you want to hear and when you want to hear them on the My Preferences tab of the Desktop View Preferences.
Click the Sounds button to open the Sounds window. Click the tab labeled Sounds. Use the slider in the Program Events area to find the list of QuickBooks actions that trigger a sound. Highlight an action to specify which sound you want to hear for that action.
Automatically Place Decimal Point
This is a useful feature once you get used to it. When you enter numbers in a currency field, a decimal point is placed automatically to the left of the last two digits when you enable this feature. Therefore, if you type 5421, when you move to the next field, the number changes to 54.21. If you want to type in even dollar amounts, type a period after you enter 54, and QuickBooks will automatically add two zeros to the right of the period.
Warn When Editing A Transaction
This option, which is selected by default, tells QuickBooks to flash a warning message when you change any transaction and try to close the transaction window without explicitly saving the changed transaction. This means you have a chance to change your mind. If you deselect the option, the edited transaction is saved as changed, unless it is linked to other transactions, in which case, the warning message explaining that problem appears.
Bring Back All One Time Messages
One-time messages are those informational dialogs that include a Don’t Show This Message Again option. If you clicked that Don’t Show option on any message dialogs, select this check box to see those messages again (and you can once again select the Don’t Show option).
Turn Off Pop-Up Messages For Products And Services
Selecting this option stops pop-up messages from QuickBooks that are connected to products and services available from Intuit.
Show ToolTips For Clipped Text
Enabling this option means that if text in any field is truncated, hovering your mouse over the text displays the entire text. This saves you the trouble of selecting the field and using the arrow keys to read the entire text.
Warn When Deleting A Transaction Or Unused List Item
When selected, this option produces a warning when you delete a transaction or a list item that has not been used in a transaction—it’s a standard message asking you to confirm your action. If you try to delete an item or a name that has been used in a transaction, QuickBooks won’t permit you to complete the deletion.
Keep QuickBooks Running For Quick Startups
When enabled, QuickBooks will start automatically and run in the background whenever you start your computer. When you close QuickBooks, it remains running in the background so it starts quickly the next time you open it.
Automatically Remember Account Or Transaction Information
Enabling this option tells QuickBooks to prefill information in a bill, check, or credit card transaction window, based on previous transactions for the same vendor. If this option is enabled, you can choose either of the suboptions:
• Automatically Recall Last Transaction For This Name, which duplicates the information in the last transaction. This is handy for transactions that don’t change (or don’t change often), such as the check to your landlord, which is always for the same amount and posted to the same account.
• Pre-fill Accounts For Vendor Based On Past Entries, which examines the history of transactions for the current vendor. If the same information appears in all or most of the historical transactions, QuickBooks autofills the transaction window (same as the previous option). If historical transactions differ, QuickBooks does not prefill the transaction window, saving you the trouble of removing the data if it doesn’t match this transaction.
ProAdvisor Tip: In addition to these “auto recall” options that QuickBooks provides for vendor transactions, you can prefill accounts for vendors right in the vendor record. Learn more about that feature in Chapter 4.
Default Date To Use For New Transactions
Use this option to tell QuickBooks whether you want the Date field to show the current date or the date of the last transaction you entered when you open a transaction window. If you frequently enter transactions for the same date over a period of several days (for example, you start preparing invoices on the 27th of the month, but the invoice date is the last day of the month), select the option to use the last entered date so you can just keep going.
Keep Custom Item Information When Changing Item In Transactions
The selection you make for this option determines what QuickBooks does when you change the description text or the price for an item you insert in a sales transaction form and then change the item:
• If you select Always, QuickBooks will keep the descriptive text you wrote, even though you changed the item. This descriptive text is linked to this different item only for this invoice; no changes are made to any item record.
• If you select Never, QuickBooks just fills in the description that goes with the new item you selected.
• If you select Ask, as soon as you change the item, QuickBooks asks if you want to change only the item and keep your customized description on the invoice. You can answer Yes (or No), and you can also tell QuickBooks to change this Preferences option permanently to match your answer.
The same thing happens if you entered a different price (instead of, or in addition to, the description) and then changed the item.
The Company Preferences Tab in General Preferences
The Company Preferences tab in the General section has the following options:
• Time Format Select a format for entering time, choosing between decimal (for example, 11.5 hours) or minutes (11:30).
• Always Show Years As 4 Digits If you prefer to display the year with four digits (01/01/2014 instead of 01/01/14), select this option.
• Never Update Name Information When Saving Transactions By default, QuickBooks asks if you want to update the original information for a name when you change it during a transaction entry. For example, if you’re entering a sales receipt and you change the customer’s address, QuickBooks offers to make that change on the customer’s record (you can choose Yes or No when QuickBooks asks). If you don’t want to be offered this opportunity and always want the record to remain as is, select this option.
• Save Transactions Before Printing The rule that a transaction must be saved before it’s printed is a security precaution. Keeping this option enabled will help to prevent an employee (or others who have access to your QuickBooks file) from printing an invoice or check without the transaction being recorded. It’s recommended that you keep this default setting.
Integrated Applications Preferences
You can let third-party software access and share the data in your QuickBooks files. Click the Integrated Applications icon and move to the Company Preferences tab to specify the way QuickBooks works with other software programs.
When you use a third-party program that links to QuickBooks, you’re asked to approve that link the first time that other application attempts to make a connection to the QuickBooks file you’re working in. If you click Yes, basic information for that program is recorded and appears in this dialog so that you do not have to reapprove future connections.
Items & Inventory Preferences
Use this dialog to enable the inventory function and set options for processing inventory transactions. Only the Company Preferences tab has options (see Figure 24-5).
FIGURE 24-5 |
Set up your QuickBooks file to track inventory. |
Inventory And Purchase Orders Are Active
Select this option to tell QuickBooks that you want to enable the inventory feature; the ability to create and track purchase orders is automatically enabled with that option.
Warn About Duplicate Purchase Order Numbers
When this option is enabled, any attempt to issue a purchase order with a PO number that already exists will generate a warning.
Warn If Not Enough Inventory Quantity On Hand (QOH) To Sell
This option turns on the warning feature that is useful during customer invoicing. If you sell ten widgets but your stock of widgets is fewer than ten, QuickBooks displays a message telling you there’s insufficient stock to fill the order. You can still complete the invoice; it’s just a message, not a functional limitation, but you should order more widgets immediately.
The Company Preferences tab of the Items & Inventory Preferences dialog also contains an Advanced Inventory Settings and a Unit Of Measure button. If you find that both of these buttons are not “live,” it’s because these features are only available in the QuickBooks Premier and Enterprise editions (Advanced Inventory is only available at the Enterprise level). Click the Learn More links to see if either of these features is a fit for your business and learn how to upgrade to either one of these versions of QuickBooks.
Jobs & Estimates Preferences
Use the Company Preferences tab to configure the way your estimates work. While the options are self-explanatory, if you plan on using estimates you should read Chapter 9 to learn everything about creating estimates and how to save time and increase accuracy by creating invoices from estimates.
Multiple Currencies Preferences
The Company Preferences tab is where you enable the ability to do business in multiple currencies. The available options are Yes and No, but if you select Yes, QuickBooks prompts you to make a backup of your company file before finalizing your decision since this feature cannot be turned off once it’s been turned on. From this window, you’ll also tell QuickBooks what your home currency is.
Even if you’re sure you want to work in multiple currencies in QuickBooks, make a backup, and use a name for the backup file that indicates what you’re doing (such as <Company Name>PreMulticurrency.qbb). Then, if you decide you don’t want to use this feature, you can restore your backup file and proceed as before. Using the multiple currencies feature in QuickBooks is covered in Appendix B.
Payments Preferences
Use the Payments preferences (Company Preferences tab only) to learn more about or to sign up for the Intuit Payment Network. With this service, you can choose from credit card processing, paper check processing, or electronic check processing (additional fees may apply).
In the Receive Payments section, you’ll find three options.
Automatically Apply Payments
This option tells QuickBooks to apply payments automatically to open invoices. If the payment amount is an exact match for an open invoice, it is applied to that invoice. If the payment amount is smaller than any open invoice, QuickBooks applies the payment to the oldest invoice. If the payment amount is larger than any open invoice, QuickBooks applies payments, starting with the oldest invoice, until the payment amount is used up.
Without this option, you must manually apply each payment to an invoice. That’s not as difficult as it may sound, and in fact, is quite common because the customer’s check almost always indicates the invoice the customer wants to pay, even if the check doesn’t cover the entire amount of that invoice. Sometimes, customers don’t mark the invoice number on the check and instead enclose a copy of the invoice in the envelope. Read Chapter 10 to learn about receiving and applying customer payments.
Automatically Calculate Payments
When this option is enabled, you can begin selecting invoices to pay in the Receive Payments window before entering the amount of the customer’s payment check. When you’ve finished selecting invoices, either paying them entirely or applying a partial payment, the amounts you’ve applied should equal the amount of the check you received.
This is efficient if a customer has many invoices (some of which may have credits or may have an amount in dispute) and has attached instructions about the way to apply the checks.
Use Undeposited Funds As A Default Deposit To Account
Selecting this option automates the process of depositing all cash received into the Undeposited Funds account. If the option isn’t selected, each cash receipt transaction window (customer payment and sales receipt) offers the choice of depositing the cash into a bank account or into the Undeposited Funds account.
Invoice Payments
In this section, you can learn more about or sign up for the Intuit Payment Network. And if you’re already signed up for this service, this is where you can go to turn it off. When you sign up for the Intuit Payment Network, a link with a web address set up just for your business is included on your invoices. Your customer can use this link to pay you online. Click the Learn More or Explain link to activate this service or to get more information about how it works. Additional fees may apply.
Payroll & Employees Preferences
Use the Company Preferences tab of this category to set all the configuration options for payroll. Refer to Chapter 20 for an explanation of the selections in this window.
Reminders Preferences
The Reminders category of the Preferences dialog has options on both tabs. The My Preferences tab has one option, which enables the display of the Reminders List when you open the company file.
The Company Preferences tab lists all the available reminders, and you can select the ones you want to use (see Figure 24-6). Keep in mind that these selections won’t take effect unless you select the Show Reminders List When Opening A Company File check box on the My Preferences tab.
FIGURE 24-6 |
Decide which tasks you want to be reminded about. |
For each item, decide whether you want to see a summary (just a listing and the total amount of money involved), a complete detailed list, or nothing at all. You can also determine the amount of lead time you want for your reminders. If you notice that some of the options are grayed out, it’s because they’re only available in QuickBooks Premier or Enterprise edition.
Reports & Graphs Preferences
This is another section of the Preferences window that has choices on both tabs, so you can set your own user preferences and then set those options that affect the current company.
Using the My Preferences tab, you can customize your experience when working with reports and graphs.
Prompt Me To Modify Report Options Before Opening A Report
If you find that almost every time you select a report you have to customize it, you can tell QuickBooks to open the Modify Report window whenever a report is brought to the screen by selecting this option.
Reports And Graphs Settings
While you’re viewing a report or a graph, you can make changes to the format, the filters, or the data behind it. Most of the time, QuickBooks automatically changes the report or graph to match the changes. Sometimes, however, if there is anything else going on (perhaps you’re also online, or you’re in a network environment and other users are manipulating data that’s in your report or graph), QuickBooks may not make changes automatically. The reason for the shutdown of automatic refreshing is to keep your computer running as quickly and efficiently as possible. At that point, QuickBooks has to make a decision about when and how to refresh the report or graph. You must give QuickBooks the parameters for making the decision to refresh:
• Choose Prompt Me To Refresh to see a message asking you whether you want to refresh the report or the graph after you’ve made changes to the data behind it. When the reminder appears, you can click Yes to refresh the data in the report.
• Choose Refresh Automatically if you want up-to-the-second data and don’t want to bother to click the Refresh button. If you work with QuickBooks across a network, this could slow down your work a bit because whenever any user makes a change to data that’s used in the report/graph, it will refresh itself.
• Choose Don’t Refresh if you want to decide for yourself, without any reminder from QuickBooks, when to click the Refresh button on the report window.
Graphs Only
Give QuickBooks instructions about creating your graphs, as follows:
• Choose Draw Graphs In 2D (Faster) to have graphs displayed in two dimensions instead of three. This doesn’t limit your ability to see trends at a glance; it’s just not as high-tech. The main reason to consider this option is that the 2-D graph takes less time to draw on your screen.
• Choose Use Patterns to draw the various elements in your graphs with black-and-white patterns instead of colors. For example, one pie wedge may be striped, another speckled. This is handy if you print your graphs to a black-and-white printer.
Move to the Company Preferences tab of the Reports & Graphs category to set company preferences for reports (see Figure 24-7).
FIGURE 24-7 |
Set the default Company Preferences options for reports. |
Summary Reports Basis
Specify whether you want to see summary reports as accrual-based or cash-based. You’re only setting the default specification here, and you can always change the basis in the Modify Report dialog when you actually display the report.
Aging Reports
Specify whether you want to generate A/R and A/P aging reports using the due date or the transaction date.
Reports—Show Accounts By
Specify whether you want reports to display account names, account descriptions, or both. If you enabled account numbers, those numbers are part of the account names.
Reports—Show Items By
Specify whether you want reports that include items to display just the item name, the item description, or both.
Setting Report Format Defaults
You can set the default formatting for reports by clicking the Format button and making changes to the default configuration options for parts of reports that aren’t data related but instead control the look of the reports. Use this feature if you find yourself making the same modifications to the formats over and over.
Configuring the Statement Cash Flows Report
A cash flow report is really a complicated document, and before the days of accounting software, accountants spent many hours creating such a report (and charged a lot of money for doing so). QuickBooks has configured a cash flow report format that is used to produce the Statement Of Cash Flows, which is available in the list of Company & Financial reports.
You can view the format by clicking the Classify Cash button, but if you plan on using this report on a regular basis, it’s a good idea to check with your accountant before you reassign accounts. You can learn about cash flow reports in Chapter 27.
Collapse Transactions
Selecting this option will collapse (combine) a transaction that includes multiple items into one line on a report. When you run a report with this option, you can then use the Expand button at the top of the report window to display the details.
Sales & Customers Preferences
You can set options in the Sales & Customers category on both the My Preferences and Company Preferences tabs. On the My Preferences tab, set the options for invoicing customers for reimbursable expenses and billable time.
Prompt For Time/Costs To Add
Choosing this option tells QuickBooks to open a dialog that displays the current outstanding reimbursable expenses and time associated with a customer whenever you create an invoice or sales receipt for a customer. This is the option to select if you typically need to rebill your customers for out-of-pocket expenses or for time spent on a project.
Don’t Add Any
Selecting this option prevents the automatic display of any dialogs about reimbursable expenses when you create a sales transaction. Choose this option if you rarely (or never) seek reimbursement from your customers. If you decide that you do want to collect reimbursable expenses during invoice creation, you can click the Add Time/Costs button on the sales transaction form.
Ask What To Do
Select this option to tell QuickBooks to ask you what you want to do whenever you create a sales transaction for a customer with outstanding reimbursable costs. Depending on your selection in that dialog, you can either add the costs to the sales transaction or omit them. You can learn how to bill customers for expenses and time in Chapter 9.
On the Company Preferences tab, set the default options for sales transactions.
Usual Shipping Method
Use this to set the default shipping method if you use the same shipping method most of the time. This saves you the trouble of making a selection from the drop-down list unless you’re changing the shipper for a particular invoice.
Usual FOB
Set the FOB language for invoices. FOB (Free On Board) is the location from which shipping is determined to be the customer’s responsibility. This means more than just paying for freight; it’s a statement that says, “At this point, you have become the owner of this product.” The side effects include assigning responsibility if goods are lost, damaged, or stolen. FOB settings have no impact on your financial records.
Warn About Duplicate Invoice Numbers
This option tells QuickBooks to warn you if you’re creating an invoice with an invoice number that’s already in use.
Choose Template For Invoice Packing Slip
Select a default packing slip to use when you print packing slips. If you’ve created customized packing slips, you can make one of them the default.
Enable Collections Center
Selecting the Enable Collections Center check box makes the Collections Center feature available. Once enabled, an icon with the same name is added to the Customer Center for easy access. Its purpose is to help you keep track of past due and almost past due customer balances while also giving you an easy way to send e-mail reminders to the customers that are listed there.
Custom Pricing
Choose one of two options: No Custom Pricing and Enable Price Levels. Price levels are a way for you to customize your prices by customer. Learn more about how to use price levels in Chapter 6.
Sales Tax Preferences
If you collect sales tax, you must set your sales tax options. Most of the selections are predefined by state tax laws and state tax reporting rules. Check with your accountant and read the information that came with your state sales tax license. For more information about managing sales taxes in QuickBooks, see Chapter 5.
Search Preferences
The Search feature allows you to quickly search in all areas of your company file for things like transactions, names, amount, dates, QuickBooks features, and so on. By default, the Search field is included on the QuickBooks Icon Bar—whether you use the Top or Left Icon bar. If you use the Top Icon bar, you can remove the Search field on it by unchecking that option at the top of the My Preferences tab (learn how to customize the QuickBooks Icon Bar in Chapter 1). You can also tell QuickBooks whether to search the Help files or your QuickBooks file when a search term is entered in this field.
The preferences listed on the Company Preferences tab give you the option of updating your search information either automatically (as often as every five minutes) or manually.
Send Forms Preferences
If you send transactions to customers via e-mail, the My Preferences tab offers the opportunity to automatically select the Email Later option on a sales transaction if the current customer is configured for e-mail as the preferred send method.
You can choose whether to send this information via Outlook or a compatible web e-mail service like Yahoo! or Gmail. You can also use QuickBooks E-mail, which is a subscription-based offering. Click the Check For Valid Subscriptions button to learn more or to confirm your own subscription.
On the Company Preferences tab, you can use Email Templates to design multiple versions of the message that accompanies an e-mailed transaction (like invoices, estimates, sales receipts, reports, and employee pay stubs, to name a few).
Service Connection Preferences
If you use QuickBooks services on the Internet, use this category to specify the way you want to connect to the Internet for those services.
The My Preferences tab contains options related to online banking if your bank uses the Web Connect method of online access. (Chapter 16 has detailed information about online banking services.)
• Give Me The Option Of Saving A File Whenever I Download Web Connect Data Select this option if you want QuickBooks to provide a choice to save Web Connect data for later processing instead of automatically processing the transactions. QuickBooks provides the choice by opening a dialog that lets you choose whether to import the data immediately or save it to a file so you can import it later (you have to supply a filename). The QuickBooks dialog also includes an option to reset this option. This option only works when you select Open on the File Download dialog. If you disable this option, the file is automatically opened and the data is imported into QuickBooks.
• If QuickBooks Is Run By My Browser, Don’t Close It After Web Connect Is Done Selecting this option means that when QuickBooks is launched automatically when you download Web Connect data from your financial institution (after selecting Open on the Download dialog), QuickBooks remains open after you process the data. If you deselect this option, QuickBooks closes automatically as soon as your data is processed.
The following connection options are available on the Company Preferences tab (these options don’t apply to payroll services or online banking):
• Automatically Connect Without Asking For A Password lets all users log into the QuickBooks Business Services network automatically.
• Always Ask For A Password Before Connecting forces users to enter a login name and password in order to access QuickBooks Business Services.
• Allow Background Downloading Of Service Messages lets QuickBooks check the Intuit website for updates and information periodically when you’re connected to the Internet.
Spelling Preferences
The Spelling section presents options only on the My Preferences tab. This is where you control the way the QuickBooks spell checker works. You can instruct QuickBooks to check spelling automatically before saving, sending, or printing any form.
In addition, you can specify those words you want the spell checker to skip, such as Internet addresses, numbers, and all capital letters that probably indicate an abbreviation.
Tax:1099 Preferences
If you need to file 1099-Misc forms, select the Company Preferences tab of this window to access a wizard that will help you establish the 1099 form options you need. For each type of 1099 payment, you must assign an account from your chart of accounts. To make these assignments, use the Click Here link under If You Want To Map Your Accounts To Boxes On Form 1099-MISC. If you’re ready to prepare your 1099s, including mapping accounts, use the Click Here link to launch the 1099 wizard (see Figure 24-8). See Chapter 18 for detailed information about configuring and issuing 1099 forms.
FIGURE 24-8 |
Use the 1099 Preferences window to launch the wizard that will guide you through the process of configuring your QuickBooks file for 1099 reporting. |
Time & Expenses Preferences
Use this section in the Company Preferences tab to turn on time tracking and to tell QuickBooks the first day of your work week (which becomes the first day listed on your timesheets). Read all about tracking time in Chapter 19. In addition, you can configure invoicing options, as explained in the following sections.
Mark All Time Entries As Billable
Selecting this option will automatically make hours entered in a timesheet that are associated with a customer or job billable to that customer.
Track Reimbursed Expenses As Income
Selecting this option changes the way your general ledger handles customer payments for reimbursements. When the option is enabled, the reimbursement is assigned to an income account instead of posting back to the original expense account. As a result of enabling this option, QuickBooks adds a new field to the dialog you use when you create or edit an expense account so you can enter the associated income account.
Whenever you post a vendor expense to this account and also indicate that the expense is reimbursable, the amount you charge to the customer when you create an invoice for that customer is automatically posted to the income account that’s linked to this expense account.
QuickBooks requires a separate income account for each reimbursable expense. If you have multiple expense accounts for which you may receive reimbursement (a highly likely scenario), you must also create multiple income accounts for accepting reimbursed expenses. See Chapter 11 to learn how to enter expenses as reimbursable.
Mark All Expenses as Billable
Selecting this option will automatically make expenses that are associated with a customer or job billable to that customer, whether recorded via check, bill, or credit card.
Default Markup Percentage
You can preset a markup for reimbursed expenses and also for items that have both a cost and price. QuickBooks uses the percentage you enter here to automate the pricing of inventory items. When you’re creating an inventory item, as soon as you enter the cost, QuickBooks automatically adds this percentage and displays the result as the price. If your pricing strategy isn’t consistent, don’t enable this option because you may find yourself having to frequently re-enter an item’s selling price.
If you enter a default markup percentage, use the Default Markup Account field to select an account from your chart of accounts that you want the resulting markup amounts to be posted to.
Customize Transaction Templates
QuickBooks makes it easy to customize the forms you use to create transactions. Forms such as invoices, purchase orders, statements, and so on, are called templates in QuickBooks, and there are two options available when customizing templates.
The first allows you to create brand-new template designs from an online template gallery. You can then save these templates to your template list. The second option gives you the ability to work with and modify the appearance of an existing template or to create a new template based on an existing one from within the program. The focus of this section is on the second option.
You can use an existing template as the basis of a new template, copying what you like, changing what you don’t like, and eliminating what you don’t need. Existing templates can be customized in two ways:
• Basic customization Change the appearance by customizing the fonts, colors, and other output settings only—these are minor changes (a form of “window dressing”) that can be made to your templates, including the built-in Intuit templates.
• Additional customization Customize the fields and columns that appear on the template—these are major changes and require you to create a new template with a new template name.
Basic Customization of Templates
To make minor changes to an existing template, locate and open the desired template in the Templates list by choosing Lists | Templates. Double-click the desired template to open the Basic Customization window.
You can also open a template to the Basic Customization window when you’re working to create a new transaction (like an invoice, for example). In this case, on the Formatting tab located on the ribbon bar at the top of the form window, select Manage Templates. Choose the template you want to modify and click OK to open the Basic Customization window (see Figure 24-9).
FIGURE 24-9 |
Change the appearance of a template in the Basic Customization dialog. |
ProAdvisor Tip: Templates that have the word “Intuit” in the template name are designed to work with preprinted forms you purchase from Intuit (although you can use them with blank paper or letterhead). Except for the Intuit Packing Slip, you can only perform basic customization on these templates. To use Intuit templates as the basis of additional customization, you must make a copy of the template and create a new template, as shown next.
Managing Templates
Click Manage Templates to view, copy, or rename a template. The Preview pane (on the right) displays a layout of the template as it currently looks and displays the template name at the top. In the Template Name field at the top of the Preview pane, you can delete the current name (unless it’s an original Intuit template) and replace it with the name you want for the new template. Clicking OK returns you to the Basic Customization dialog.
Adding a Logo to a Template
You can add your company logo to a template by selecting the Use Logo check box. Navigate to the folder that has your logo graphic file, and select the file. Use the following guidelines to add a logo to a template:
• The logo should be a square shape to fit properly on the template.
• QuickBooks accepts all the common graphic formats for your logo. However, the graphic loads when you print the template, and graphic files saved with a BMP format tend to be larger than other formats and may take quite some time to load each time you print. The most efficient format, in terms of size and resolution, is JPG.
• Your logo appears in the upper-left corner of the form, unless you open the Layout Designer (covered later in this chapter) to reposition it.
• You won’t see the logo on the screen version of the template.
• If you can’t place the logo in the size and position you prefer, consider having stationery printed and using it as the paper source for the template.
Customizing Colors on a Template
You can change the color of the lines that appear on the template by selecting a color scheme from the drop-down list in the Select Color Scheme field. Click Apply Color Scheme to save the change and see its effect in the Preview pane on the right side of the dialog.
You can also change the color of any text that’s printed on the form by using the features for changing fonts (covered next) and selecting a color for the font.
Customizing Fonts on a Template
To change the fonts for any elements on the template, select the element in the Change Font For list and click Change Font. Select a font, size, style (such as bold or italic), effects, or color.
Customizing the Company Information on a Template
You can select and deselect the text that appears in the name and address block of your templates. The data is taken from the Company Information dialog, which you can open by clicking Update Information to make sure that the data exists.
Printing Status Stamps on Templates
You can select or deselect the option to print the status stamp on a transaction template (PAID, RECEIVED, and so on). The status stamp prints at an angle across the center of the header section of the template. If you deselect the status stamp, you are only removing it from the printed copy of the form; the screen copy always shows the status.
Additional Customization of Templates
You can make major changes in templates to suit your needs as well as your taste. QuickBooks calls this the Additional Customization feature. Start your customization by selecting an existing template on which to base your new template. Select the Customize Data Layout button located on the Formatting tab, which is located on the ribbon bar at the top of the form’s window. If you are attempting to modify an Intuit template, the Locked Template dialog appears instructing you to make a copy of the template; otherwise, the Additional Customization window opens (see Figure 24-10).
FIGURE 24-10 |
The Additional Customization dialog lets you point and click to redesign a template. |
ProAdvisor RecommendsThe List of Templates
If you’ve just started using QuickBooks, you may be confused by the template names you see in the Templates list (Lists | Templates). The templates that appear in the list depend on the preferences you set and the transactions you’ve created.
By default, QuickBooks installs Invoice templates, a Statement template, and a Packing Slip template. You won’t see a Purchase Order template unless you enable Inventory & Purchase Orders (covered earlier in this chapter) and also open the built-in Purchase Order template by choosing Vendors | Create Purchase Orders. As soon as the Create Purchase Orders transaction window opens, the Purchase Order template appears on the list (you can close the transaction window without creating a PO if your only purpose was to add the template to the list). The same convention applies to Sales Receipts, Estimates, and other QuickBooks templates.
Notice that in Figure 24-10, the name of this template includes the text “BOPref,” which refers to a custom field that was created for tracking customer preferences for back orders. This field will only display on the screen version of the template (the field serves as a guideline when filling an order), but not on the printed version that is sent to the customer.
Custom fields you create in a Names list appear in the Header section of transaction windows—custom fields you create in the Item List appear in the Columns section of transaction windows.
Customizing the Template Header
The header section of the Additional Customization dialog includes all the fields that appear above the line items in a transaction form. You can add or remove fields on the screen form, the printed form, or both. The Preview pane on the right is a preview of the printed form, and as you add or remove fields from the printed form, you see the changes reflected there.
There are some changes to the header section that you may want to make based on the way you’ve set up your QuickBooks company file. For example:
• If you assign account numbers to your customers, you may want to display the Account Number field (only available on the printed version).
• If you use reps, either as commissioned salespersons or as customer support contacts, you can add the Rep field to both the screen and printed versions.
• If you’re tracking jobs for the majority of your customers, add the job name to the form (only available in the printed version). QuickBooks uses the term “project” because that’s the commonly used term in most businesses (the exception is the construction trade, where “job” is a common term). If you refer to jobs as “jobs” with your customers, you can change the text.
Customizing the Template Columns
On the Columns tab of the Additional Customization dialog (see Figure 24-11), you can add or remove columns that appear in the line item section of the transaction form. If you created custom fields for items, they’re available for any template you design.
FIGURE 24-11 |
Add columns to specify details of the items you’re including in the transaction. |
If progress invoicing is turned on, another columns tab, called Prog Cols, is available for customizing the transaction form you use when you create a progress invoice against an estimate (to learn how to create estimates and progress invoices, read Chapter 9).
Customizing the Template Footer
The Footer tab (see Figure 24-12) contains the elements that appear at the bottom of the transaction form. If you want to add fields to this section of the printed transaction form, you’ll have to use the Layout Designer to maneuver the positioning because you don’t have a lot of space to work with.
FIGURE 24-12 |
Add fields from the Footer tab to add more information to the transaction form. |
Setting the Print Option
On the Print tab, you can configure the printer settings for just this template by selecting the option Use Specified Printer Settings Below For This Invoice. If you want to use the same invoice printer settings that you used in your printer setup (File | Printer Setup | Invoices), you can select that option as your default.
Using the Layout Designer
As you customize the printed forms, you can see the effects in the Preview pane. If you notice some overlapping fields, or you think the layout looks too crowded, you can use the Layout Designer to reposition the elements on the form. Click Layout Designer to open your template in the Layout Designer window, as seen in Figure 24-13.
FIGURE 24-13 |
You can reposition the elements in the form to create your own design. |
The Layout Designer is a powerful and complicated feature, and it’s beyond the scope of this book to go into deep detail about it. The more you work with it, however, the better you’ll get at making it work for you. It’s a good idea to make a copy of an existing invoice template and experiment on that copy before you make changes to your “live” template.
If you use window envelopes to mail your invoices, be sure the Show Envelope Window option at the bottom of the Layout Designer is selected before you start. The areas of the form that appear in envelope windows are highlighted in green. This helps you avoid moving any fields into that area.
Select any element to put a frame around it. Now you can perform an action on the frame, as follows:
• To change the size of the element, position your pointer on one of the sizing handles on the frame and then drag the handle to resize the element.
• To move an element, position your pointer inside the frame and, when your pointer turns into a four-headed arrow, drag the frame to a different location on the form.
• Double-click an element’s frame to see a Properties dialog that permits a variety of changes for the selected element.
• To change the margin measurements, click the Margins button at the bottom of the Layout Designer.
• Click the Grid button to open the Grid And Snap Settings dialog, where you can eliminate the dotted line grid, change the spacing between grid lines, or turn off the Snap To Grid option (which automatically aligns objects to the nearest point on the grid).
• Use the toolbar buttons to align, resize, and zoom into the selected elements.
There are also Undo and Redo buttons, just in case.
When you finish with the Layout Designer, click OK to move back to the Additional Customization window. If everything is just the way you want it, save your new template by clicking OK. This new template name appears on the drop-down list when you create transaction forms.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.