Читать книгу QuickBooks 2015 For Dummies - Nelson Stephen L. - Страница 6

In This Chapter

▶ Getting ready to run QuickBooks Setup

▶ Stepping through QuickBooks Setup

▶ Taking the next steps after QuickBooks Setup

I know that you’re eager to get started. After all, you have a business to run. But before you can start using QuickBooks, you need to do some upfront work. Specifically, you need to prepare for the QuickBooks Setup process. And then you need to walk through the Setup steps. In this chapter, I describe how you do all this stuff.

I assume that you know how Windows works. If you don’t, take the time to read Chapter 1 of your Windows user’s guide or try the appropriate edition of Windows For Dummies, by Andy Rathbone.

Getting Ready for the QuickBooks Setup

You need to complete three tasks to get ready for QuickBooks Setup:

✔ Make an important decision about your conversion date (the date you convert from your old accounting system to QuickBooks).

✔ Prepare a trial balance as of the conversion date.

✔ Go on a scavenger hunt to collect a bunch of stuff that you’ll need or find handy for the interview.

The big decision

Before you fiddle with your computer or the QuickBooks software, you need to choose the date – the so-called conversion date – on which you want to begin using QuickBooks for your financial record keeping.

This decision is hugely important because the conversion date that you choose dramatically affects both the work you have to do to get QuickBooks running smoothly and the initial usefulness of the financial information that you collect and record by using QuickBooks.

You have three basic choices:

✔ The right way: You can convert at the beginning of your accounting year (which is, in most cases, the same as the beginning of the calendar year). This way is the right way for two reasons. First, converting at the beginning of the year requires the least amount of work from you. Second, it means that you have all the current year’s financial information in one system.

✔ The slightly awkward way: You can convert at the beginning of some interim accounting period (probably the beginning of some month or quarter). This approach works, but it’s slightly awkward because you have to plug your year-to-date income and expenses numbers from the old system into the new system. (If you don’t know what an interim accounting period is, see Appendix B.)

✔ The my-way-or-the-highway way: You can convert at some time other than what I call the right way and the slightly awkward way. Specifically, you can choose to convert whenever you jolly well feel like it. You create a bunch of unnecessary work for yourself if you take this approach, and you pull out a bunch of your hair in the process. But you also have the satisfaction of knowing that through it all, you did it your way – without any help from me.

I recommend choosing the right way. What this choice means is that if it’s late in the year – say, October – you just wait until January 1 of the next year to convert. If it’s still early in the year, you can also retroactively convert as of the beginning of the year. (If you do this, you need to go back and do your financial record keeping for the first part of the current year by using QuickBooks: entering sales, recording purchases, and so on.)

If it’s sometime in the middle of the year – say, Memorial Day or later – you probably want to use the slightly awkward way. (I’m actually going to use the slightly awkward way in this chapter and the next chapter because if you see how to convert to QuickBooks by using the slightly awkward way, you know how to use both the right way and the slightly awkward way.)

The trial balance of the century

After you decide when you want to convert, you need a trial balance.

“Yikes,” you say. “What’s a trial balance?” A trial balance simply lists all your assets, liabilities, and owner’s equity account balances as well as the year-to-date income and expense numbers on a specified date (which, not coincidentally, happens to be the conversion date). You need this data for the QuickBooks Setup process and for some fiddling around that you need to do after you complete the QuickBooks Setup process.

Creating a trial balance doesn’t have to be as hard as it sounds. If you’ve been using another small business accounting system, such as the simpler Quicken product from Intuit or the Simply Accounting program from Computer Associates, you may be able to have your old system produce a trial balance on the conversion date. In that case, you can get the balances from your old system. (Consider yourself lucky if this is the case.)

Just to split hairs, the trial balance should show account balances at the very start of the first day that you’ll begin using QuickBooks for actual accounting. For example, if the conversion date is 1/1/2015, the trial balance needs to show the account balances at one minute past midnight on 1/1/2015. This is also the very same thing as showing the account balances at the very end of the last day that you’ll be using the old accounting system – in other words, at exactly midnight on 12/31/2014, if you’re converting to QuickBooks on 1/1/2015.

If your old system is rather informal (perhaps it’s a shoebox full of receipts), or if it tracks only cash (perhaps you’ve been using Quicken), you need to do a bit more work:

✔ To get your cash balance: Reconcile your bank account or bank accounts (if you have more than one bank account) as of the conversion date.

✔ To get your accounts receivable balance: Tally the total of all your unpaid customer invoices.

✔ To get your other asset account balances: Know what each asset originally costs. For depreciable fixed assets, you also need to provide any accumulated depreciation that has been claimed for that asset. (Accumulated depreciation is the total depreciation that you’ve already expensed for each asset.)

By the way, check out Appendix B if you have questions about accounting or accounting terminology, such as depreciation.

✔ To get your liability account balances: Know how much you owe on each liability. If you trust your creditors – the people to whom you owe the money – you may also be able to get this information from their statements.

You don’t need to worry about the owner’s equity accounts. QuickBooks can calculate your owner’s equity account balances for you, based on the difference between your total assets and your total liabilities. This method is a bit sloppy, and accountants may not like it, but it’s a pretty good compromise. (If you do have detailed account balances for your owner’s equity accounts, use these figures – and know that you’re one in a million.)

If you’re using the slightly awkward way to convert to QuickBooks – in other words, if your conversion date is some date other than the beginning of the accounting year – you also need to provide year-to-date income and expense balances. To get your income, cost of goods sold, expenses, other income, and other expense account balances, you need to calculate the year-to-date amount of each account. If you can get this information from your old system, that’s super. If not, you need to get it manually. (If you suddenly have images of yourself sitting at your desk late at night, tapping away on a ten-key, you’re probably right. What’s more, you probably also need to allocate half of another Saturday to getting QuickBooks up and running.)

Just for fun, I created the sample trial balance shown in Table 2-1. This table shows you what a trial balance looks like if you convert at some time other than at the beginning of the accounting year.

Table 2-1 A “Slightly Awkward Way” Sample Trial Balance

About those debits and credits

Don’t get freaked out about those debits and credits. You just need to keep them straight for a few minutes. Here’s the scoop: For assets and expenses, a debit balance is the same thing as a positive balance. So, a cash debit balance of $5,000 means that you have $5,000 in your account, and $20,000 of cost of goods sold means that you incurred $20,000 of costs-of-goods expense. For assets and expenses, a credit balance is the same thing as a negative balance. So if you have a cash balance of –$5,000, your account is overdrawn by $5,000. In the sample trial balance shown in Table 2-1, the accumulated depreciation shows a credit balance of $2,000, which is, in effect, a negative account balance.

For liabilities, owner’s equity accounts, and income accounts, things are flip-flopped. A credit balance is the same thing as a positive balance. So an accounts payable credit balance of $2,000 means that you owe your creditors $2,000. A bank loan credit balance of $10,000 means that you owe the bank $10,000. And a sales account credit balance of $60,000 means that you’ve enjoyed $60,000 worth of sales.

I know that I keep saying this, but do remember that those income and expense account balances are year-to-date figures. They exist only if the conversion date is after the start of the financial year.

If you’re converting at the very beginning of the accounting year, your trial balance instead looks like the one shown in Table 2-2. Notice that this trial balance doesn’t have any year-to-date income or expense balances.

Table 2-2 A “Right Way” Sample Trial Balance

The mother of all scavenger hunts

Even after you decide when you want to convert to QuickBooks and you come up with a trial balance, you still need to collect a bunch of additional information. I list these items in laundry-list fashion. What you want to do is find all this stuff and then pile it up (neatly) in a big stack next to the computer:

✔ Last year’s federal tax return: QuickBooks asks which federal income tax form you use to file your tax return and also about your Taxpayer Identification number. Last year’s federal tax return is the easiest place to find this stuff.

✔ Copies of all your most recent state and federal payroll tax returns: If you prepare payroll for employees, QuickBooks wants to know about the federal and state payroll tax rates that you pay, as well as some other stuff.

✔ Copies of all the unpaid invoices that your customers (or clients or patients or whatever) owe you as of the conversion date: I guess this is probably obvious, but the total accounts receivable balance shown on your trial balance needs to match the total of the unpaid customer invoices.

✔ Copies of all unpaid bills that you owe your vendors as of the conversion date: Again, this is probably obvious, but the total accounts payable balance shown on your trial balance needs to match the total of the unpaid vendor bills.

✔ A detailed listing of any inventory items you’re holding for resale: This list should include not only inventory item descriptions and quantities, but also the initial purchase prices and the anticipated sales prices. In other words, if you sell porcelain wombats and you have 1,200 of these beauties in inventory, you need to know exactly what you paid for them.

✔ Copies of the prior year’s W-2 statements, W-4 statements for anybody you hired since the beginning of the prior year, detailed information about any payroll tax liabilities you owe as of the conversion date, and detailed information about the payroll tax deposits you made since the beginning of the year: You need the information shown on these forms to adequately and accurately set up the QuickBooks payroll feature. I don’t want to scare you, but this is probably the most tedious part of setting up QuickBooks.

✔ If you’re retroactively converting as of the beginning of the year, you need a list of all the transactions that have occurred since the beginning of the year: sales, purchases, payroll transactions, and everything and anything else: If you do the right-way conversion retroactively, you need to re-enter each of these transactions into the new system. You actually enter the information after you complete the QuickBooks Setup that I describe later in this chapter, but you might as well get all this information together now while you’re searching for the rest of the items for this scavenger hunt.

If you take the slightly awkward way, you don’t need to find the last item that I describe in the preceding list. You can just use the year-to-date income and expense numbers from the trial balance.

Stepping through the QuickBooks Setup

After you decide when you want to convert, prepare a trial balance as of the conversion date, and collect the additional raw data that you need, you’re ready to step through the QuickBooks Setup. You need to start QuickBooks and then walk through the steps.

Starting QuickBooks

To start QuickBooks 2015 in Windows 8 or 8.1, click the QuickBooks 2015 tile on the Windows Start screen. In other versions of Windows, click the Windows Start button and then click the menu choice that leads to QuickBooks. (For example, I choose Start⇒All Programs⇒QuickBooks⇒QuickBooks Enterprise Solutions 15.0.) Or in either version of Windows, double-click the QuickBooks program icon if you put one on the desktop during the installation.

QuickBooks comes in several flavors. The most common flavors are

✔ QuickBooks Pro: The Pro version includes the advanced job costing and time-estimating features, which I briefly describe in Chapter 16; it also includes the capability to share a QuickBooks file over a network, as I describe in Appendix C.

✔ QuickBooks Premier: The Premier version adds features to the QuickBooks Pro and also comes in a variety of “industry-specific” flavors, including an Accountant edition, which mimics most of these other flavors.

✔ QuickBooks Enterprise Solutions: This version is nearly identical to QuickBooks Premier but allows for very large QuickBooks files, including much larger customer, vendor, and employee lists.

I used the Accountant’s Edition flavor of QuickBooks Enterprise Solutions, so some of the figures might differ a wee bit from what you see onscreen. But know this: Aside from minor cosmetic differences, the various versions of QuickBooks all work the same way. You can use this book for any of these program versions.

If this is the first time you started QuickBooks, QuickBooks starts by telling you how it plans to use your Internet connection to regularly update the QuickBooks software. After you click the button that indicates, “Okay, yeah, I’m good with that,” QuickBooks displays the No Company Open dialog box (not shown). You then click the Create A New Company button so that QuickBooks displays the QuickBooks Setup window with the message, Let's get your business set up quickly! (See Figure 2-1.)

Figure 2-1: The first QuickBooks Setup window.

If you’ve already been using an earlier version of QuickBooks, QuickBooks should prompt you to open (and possibly convert) an existing file – and you don’t need to be reading this chapter.

If you aren’t starting QuickBooks for the first time but you want to step through the QuickBooks Setup to set up a new company anyway, choose File⇒New Company.

I should mention that the first QuickBooks Setup dialog box (the one shown in Figure 2-1) identifies some other setup options you can use to get started. For example, the dialog box gives you the option of a Detailed Start (where you get to control the setup and fine-tune the company file). The dialog box gives you the option of creating a new file from an old file. And the dialog box also suggests that you might want to upgrade from Quicken or some other accounting system. (Basically, that upgrade just means that you want QuickBooks to try using your existing accounting system’s data as a starting point for QuickBooks.)

Two simple bits of advice: Don’t fiddle with the Detailed Setup unless you’re an accounting expert. And don’t attempt to “upgrade” Quicken or some other accounting program’s data. It’s just as easy and usually considerably cleaner to work from a trial balance.

The one group of new QuickBooks users who should probably try upgrading their old accounting system’s data are people who’ve done a really good job of keeping their books with the old system, including complete balance sheet information. No offense, but you probably aren’t in this category. Sorry.

Using the Express Setup

QuickBooks 2015 provides you with a very fast setup process compared with other accounting software programs and even with past versions of the QuickBooks software. Basically, you’ll fill in some boxes and click some buttons, and, voilà, you find that you’ve largely set up QuickBooks. Because I can give you some tips, identify some shortcuts, and warn you of some traps you want to avoid, I’m going to provide step-by-step instructions.

1. Choose to use the Express Setup.

With the first QuickBooks Setup dialog box displayed (refer to Figure 2-1), click the Express Start button. QuickBooks displays the Tell Us about Your Business dialog box, shown in Figure 2-2.

Figure 2-2: The Tell Us about Your Business dialog box.

2. Specify the business name.

The name you specify goes on QuickBooks reports and appears on invoices you send customers. Accordingly, you want to use your “real” business name. And if your business is incorporated or formed as a limited liability company (LLC), you want to use the right suffix or acronym in your name. For example, don’t use Acme Supplies, but rather, Acme Supplies Incorporated or Acme Supplies LLC.

Note: QuickBooks also uses the company name for the QuickBooks data file.

3. Identify your industry.

For example, if you’re in the construction business, type construction. When you type something into the Industry field, QuickBooks turns the box into a drop-down list showing the industries that it recognizes. You can pick an industry from this list (or pick the industry that’s closest to your business).

Be thoughtful and cautious about the industry you specify. QuickBooks sets up a starting chart of accounts for you based on the industry. A chart of accounts lists the asset, liability, income, and expense accounts (or categories) that QuickBooks will use to categorize your business’s finances.

4. Identify the tax return you file and your taxpayer identification number.

Use the Company Type field to specify the tax return that your business files. You can click in that field and then select from the list that QuickBooks provides.

The QuickBooks list of tax return options includes only two options for LLCs: single-member LLCs that file their taxes with the LLC owner’s 1040 tax return, and multiple-member LLCs that file their taxes as a partnership by using a 1065 tax return. An LLC can also file its taxes as an S corporation or regular C corporation, however (part of the reason accountants love LLCs). If you’re running an LLC that files its taxes as an S corporation, do select the S corporation tax return option. And if you’re running an LLC that files as a regular C corporation, select that tax return option.

Use the Tax ID # field to provide your business taxpayer identification number. If you’re a sole proprietorship without employees, your tax identification number may be your Social Security number. In all other cases, your taxpayer identification number is your Employer Identification number.

5. Indicate whether the business employs people.

Note that a sole proprietor is not an employee in his or her own business (though the proprietor’s spouse or child would be employees if they were paid for work performed in the business). Further, partners paid for work performed in a business are also not employees. Partners, for example, don’t get paid wages – they get paid something called guaranteed payments.

6. Click the Continue button.

7. On the next page, supply your business contact information.

When QuickBooks displays the Enter Your Business Contact Information dialog box (see Figure 2-3), verify that the correct business name shows in the Legal Name field. Then fill in the rest of the address and contact information. I hope you don’t feel cheated that I’m not giving you instructions like “Enter your street address into the Address box” and “Please remember that your telephone number goes into the Phone box.”

Figure 2-3: The Enter Your Business Contact Information dialog box.

If you ever decide that you want to change some piece of information that you entered on a previous page of the QuickBooks Setup dialog box, you can just click the Back button to back up.

If you’re an observant person, you may have noticed the Preview Your Settings button that appears on the Enter Your Business Contact Information dialog box. You can safely ignore this button, but if you’re a truly curious cat, go ahead and click it. QuickBooks then displays a dialog box that identifies which standard QuickBooks features the QuickBooks Setup process is turning on and which asset, liability, income, and expense accounts will initially appear on your chart of accounts. Oh, one other thing: The Preview Your Company Settings dialog box also provides a Company File Location tab that identifies where your QuickBooks data file will be located.

8. Create the QuickBooks data file.

After you provide the business contact information requested by QuickBooks, click the Create Company File button. QuickBooks creates the data file it will use to store your financial information. (In some versions of QuickBooks, the file creation process takes a few minutes.) When QuickBooks finishes creating your file, it displays the You’ve Got a Company File! dialog box. (See Figure 2-4.)

Figure 2-4: The You’ve Got a Company File! dialog box.

9. Identify your customers, vendors, and employees.

With the You’ve Got a Company File! dialog box displayed, click the Add the People You Do Business With button. QuickBooks displays another dialog box that asks, “Perchance, are contact names and addresses stored electronically someplace else like Microsoft Outlook or Google Gmail?”

• If you do have contact name and address information stored someplace else that QuickBooks will retrieve: Click the appropriate button and follow the onscreen instructions.

• Otherwise: Click the Paste from Excel or Enter Manually button and then Continue.

When QuickBooks displays the Add the People You Do Business With dialog box (see Figure 2-5), use the rows of the displayed worksheet to describe your customers, vendors, and employees. To enter a contact into the next empty row

1. Select the Customer, Vendor, or Employee option button (as appropriate).

2. Describe the contact using the fields provided: Name, Company Name, First Name, Last Name, Email, Phone, and so forth. Each contact goes into its own row.

3. Click the Continue button twice when you finish identifying your contacts to return to the You’ve Got a Company File! dialog box.

Figure 2-5: The Add the People You Do Business With dialog box.

In the first Name column, which is used for customers and vendors, provide an abbreviated name or a nickname for a contact. You’ll use what you specify in the Name column within QuickBooks to refer to the contact, so you want to use something short and sweet. For example, if you’re working with, say, customer John Smith at IBM Corporation, you might enter IBM into the Name column, IBM Corporation into the Company Name column, John into the First Name column, and so forth.

If you add any customers or vendors, QuickBooks asks about open balances that customers owe you or that you owe vendors after you click the Continue button to leave the Add the People You Do Business With dialog box. You don’t need to worry about these open balances at this point of the QuickBooks Setup process. I describe how to cleanly and correctly deal with open customer and vendor balances in Chapter 3.

1. Identify the items (the stuff) you sell.

With the You’ve Got a Company File! dialog box displayed, click the Add the Products and Services You Sell button. QuickBooks displays another dialog box that asks what kind of stuff you want to describe: services, stuff that you track in inventory, stuff that is inventory but that you don’t track, and so on. (Which items QuickBooks lists depends on the industry that you specify in Step 3.) Click the appropriate button.

When QuickBooks displays the Add the Products and Services You Sell dialog box (see Figure 2-6), use the rows of the displayed worksheet to describe a product or service. For any item, you’ll always enter a name, description, and price. For some items, however, you can specify much greater detail than just this skeletal information. Click the Continue button when you finish identifying your products and services. QuickBooks may try to sell you some extra stuff (like Intuit checks) but go ahead and click “No Thanks” to return to the You’ve Got a Company File! dialog box.

Figure 2-6: The Add the Products and Services You Sell dialog box.

1. Describe your bank account(s).

With the You’ve Got a Company File! dialog box displayed, click the Add Your Bank Accounts button. When QuickBooks displays the Add Your Bank Accounts dialog box (see Figure 2-7), use the worksheet to describe each bank account of your business: its name, account number, balance at the conversion date, and the actual conversion date. Click the Continue button when you finish identifying your bank accounts to return to the You’ve Got a Company File! dialog box.

Figure 2-7: The Add Your Bank Accounts dialog box.

1. Start working with QuickBooks.

With the You’ve Got a Company File! dialog box displayed, click the Start Working button. QuickBooks displays the QuickBooks program window. You’re done.

If you did not register during the installation, at some point after QuickBooks starts, you will see a message box that asks whether you want to register QuickBooks. If you don’t register, you can use the product roughly a few times, and then – whammo! – the program locks up, and you can no longer access your files. Either you register it, or you can’t use it. I don’t like being forced to do something, but getting worked up about having to register QuickBooks is a waste of time.

The simplest option is to just register when you see that message. Here’s how: When QuickBooks displays the message box that asks whether you want to register, click the Online button to register online, or click the Phone button to register over the phone. If you go with the Phone option, QuickBooks displays another dialog box that gives you a telephone number to call and provides a space for you to enter your registration number.

The Rest of the Story

Throughout the preceding paragraphs in this chapter, I describe how you prepare for and then step through the QuickBooks Setup process. When the QuickBooks Setup is over, though, you need to take care of three other little jobs:

✔ You need to describe in detail your inventory, your customer receivables, and (if you chose to track vendor bills you owe) your vendor payables.

✔ You need to describe your current business finances, including any year-to-date revenue and year-to-date expenses that aren’t recorded as part of getting your customer receivables and vendor payables entered into QuickBooks.

✔ If you want to use accrual-basis accounting, you need to make an adjustment.

These chores aren’t time consuming, but they are the three most complicated tasks that you need to do to set up QuickBooks. (If you aren’t sure what the big deal is about accrual-basis accounting, I respectfully suggest that you take a break here and read Appendix B.)

To set up the inventory records, you just identify the item counts you hold in inventory, as described in Chapter 3.

To set up your customer receivables and (if necessary) vendor payables, you first need to enter customer invoices that were prepared prior to the conversion date but that are still uncollected at conversion, as described in Chapter 4. Similarly, you may need to enter vendor payables that were incurred prior to the conversion date but that are still unpaid at conversion.

I talk about this stuff more in Chapter 3, so if you’re still okay with doing some more installation and setup work, go ahead and flip there. However …

Should You Get Your Accountant’s Help?

So should you get help from your accountant? Oh, shoot, I don’t know. If you follow my directions carefully (both in this chapter and the next), and your business financial affairs aren’t wildly complex, I think you can probably figure out all this stuff on your own.

However, having said that, I suggest that you at least think about getting your accountant’s help at this juncture. Your accountant can do a much better job of giving you advice that may be specific to your situation. In many cases, your accountant can give you beginning trial balance amounts that agree with your tax returns. The accountant probably knows your business and can keep you from making a terrible mess of things, just in case you don’t follow my directions carefully.

Just so you know: One of the things that I (as a CPA) do for my clients is help them set up QuickBooks. Because I do this, I can give you a couple of pieces of useful information about getting a CPA’s help in setting up. First, your CPA (assuming that he or she already knows QuickBooks) should be able to help you through the setup process in a couple of hours in most cases, so your CPA can do it (or help you do it) much faster than you can on your own. Second, another (a third) hour or so of tutoring from your CPA should mean that you get enough help to record all your usual transactions.

With just this help, you can find out how to pay your bills, how to invoice customers exactly the way you want, and how to produce reports. I used to pooh-pooh this kind of hand-holding, but the older (and, I hope, wiser) I get, the more I see that business owners and bookkeepers benefit from this upfront help. A bit of planning and expert advice in the beginning can save you a whole lot of trouble later.