How to Create the Starting QuickBooks 2013 Setup Trial Balance - dummies

How to Create the Starting QuickBooks 2013 Setup Trial Balance

By Stephen L. Nelson

Regardless of whether you use the Express Start version or the Advanced Setup/EasyStep Interview version of the QuickBooks Setup process, you don’t actually get a complete trial balance into the QuickBooks company file simply by setting up. Assuming that you follow the instructions and tips provided in the preceding paragraphs, you get only your bank account, accounts receivable, inventory, and accounts payable balances into QuickBooks.

Yet you need to enter all of the missing trial balance information into QuickBooks, too, to begin getting good reports out of QuickBooks and to use QuickBooks for supplying financial data to your tax returns.

In order to record the rest of your starting trial balance, you record a journal entry. The journal entry records the remaining trial balance amounts for all of your other accounts at the conversion or start date: accounts other than your bank accounts, accounts receivable, accounts payable, and inventory.

As a simple example to show you how this works, suppose that you have the trial balance shown in the following table.

A Trial Balance
Account Debit Credit
Cash 5,000
Inventory 0
Accounts payable 0
Loan payable 0
S. Nelson, capital 1,000
Merchandise Sales 13,000
Cost of goods sold 3,000
Rent Expense 1,000
Wages 4,000
Supplies 1,000 _____
Totals 14,000 14,000

Please notice that no balance is recorded for a bank account, no balance is recorded for accounts receivable (this account doesn’t even show up in the trial balance), and no balances are recorded for inventory or accounts payable (because these accounts have zero balances at the conversion date).

For purposes of this example, the cash balance is not a bank account but is actually cash: a desk drawer full of low-denomination, used bills with non-sequential serial numbers.

The next figure shows how the Make General Journal Entries window looks when it records the missing trial balance information. After this journal entry is recorded, the trial balance is correct as of the start date.


Choose the Company→ Make Journal Entry command. When QuickBooks displays the General Journal Entries window, use the Account, Debit, and Credit columns to record your journal entry.

If the idea of making a journal entry terrifies the heck out of you, you may find yourself in a bit of a pickle. You need to become comfortable working with double-entry bookkeeping in order to set up QuickBooks at a time other than at the beginning of the year.

This means, unfortunately, that if you are setting up QuickBooks sometime during the middle of the year, you must enter a general journal entry in order to fix the weirdness that the QuickBooks Setup creates. If you don’t know how double-entry bookkeeping works — if debits and credits aren’t your friends — you probably need to get somebody’s help.

Note: This shouldn’t be a big project — just in case you decide to call your CPA. If your CPA comes over to your office, and if you have the trial balance ready for her, it should take her only a few minutes to enter the necessary general journal entry. Perhaps you can buy her a nice lunch, and that will settle the score.

A real-life example to finish

Okay, true confessions. The example I give in the preceding four paragraphs? You probably won’t be lucky enough to have your starting trial balance journal entry be so simple. You probably will have to deal with a bank account and with account balances in your accounts receivable, accounts payable, or inventory accounts. I now show you, therefore, how this works.

Suppose that you have the trial balances shown in Table 1-2. Note that in this example (unlike the preceding example), the first account shown —the one with $5,000 — is a bank account.

Another Trial Balance
Account Debit Credit
Checking 5,000
Accounts receivable 5,000
Inventory 2,000
Accounts payable 1,000
Loan payable 5,000
S. Nelson, capital 2,000
Merchandise sales 13,000
Cost of goods sold 3,000
Rent expense 1,000
Wages 4,000
Supplies 1,000 _____
Totals 21,000 21,000

Here’s the tricky part of recording this trial balance. You do not need to record all this trial balance information through a journal entry. Because the bank account, accounts receivable, accounts payable, and inventory portions have already been recorded if you added customer, vendor, item, and bank account information during the QuickBooks Setup process, you just need to enter the rest of the trial balance.

Because you will not be recording all of the trial balance, however, your journal entry not only won’t match your actual trial balance, but also won’t balance. To make it balance, therefore, you plug the difference into an account that QuickBooks supplies for just this sort of bookkeeping madness: the Opening Balance Equity account (see the following figure).