QuickBooks Articles

Cheat Sheet / Updated 11-14-2022

QuickBooks 2023 makes small-business accounting fast and easy. But your day-to-day business bookkeeping will go even more smoothly if you employ a handful of QuickBooks user interface tricks, editing tricks, and keyboard shortcuts.

Cheat Sheet / Updated 11-14-2022

You can make the most of your work in QuickBooks Online (QBO) and QuickBooks Online Accountant (QBOA) using handy and time-savings shortcuts and tool buttons. Using QBO keyboard shortcuts means you can seamlessly access various windows and pages without touching a mouse. The various icons at the top of the QBO page help you quickly search for items, create new items, or display transactions.

Article / Updated 09-21-2022

When you're working with QuickBooks, you will encounter command windows. To perform a common accounting or bookkeeping task in QuickBooks, use these commands. When QuickBooks displays the command's window, you just fill in the boxes and press Enter. To Do This Choose This QuickBooks Command Dealing with Customers Invoice a customer Customers→Create Invoices Record a cash sale Customers→Enter Sales Receipts Issue a credit memo Customers→Create Credit Memo/Refunds Record a customer payment Customers→Receive Payments Handling Banking Activities Pay a bill with a check Banking→Write Checks Buy inventory with a check Banking→Write Checks Move money between bank accounts Banking→Transfer Funds Deposit money in a bank account Banking→Make Deposits See a bank account's transactions Banking→Use Register Reconcile a bank account Banking→Reconcile Working with Vendors Prepare a purchase order Vendors→Create Purchase Orders Record when items are received Vendors→Receive Items or Vendors→Receive Items and Enter Bill Record an accounts payable amount Vendors→Enter Bills or Vendors→Enter Bill for Received Items Managing Employees Preparing employee payroll Employees→Pay Employees Paying tax deposits Employees→Payroll Taxes and Liabilities→Pay Scheduled Liabilities Getting Financial Information Accounts Lists→Chart of Accounts Customers Customers→Customer Center Inventory Lists→Item List or Vendors→Inventory Activies→Inventory Center Vendors Vendors→Vendor Center Employees Employees→Employee Center Profit and loss Reports→Company & Financial→Profit & Loss Standard or one of the other profit & loss reports on Company & Financial submenu Net worth Reports→Company & Financial→Balance Sheet Standard or one of the other balance sheet reports on the Company & Financial submenu Managing the QuickBooks System Setting up a new company File→New Company Resetting company information Company→Company Information Backing up data file File→Save Copy or Back Up Restoring a data file File→Open or Restore Company Customizing QuickBooks Edit→Preferences Adjusting accounting data Company→Make Journal Entries

Article / Updated 08-01-2022

You can modify the rights that you assign to a user in QuickBooks Pro or Premier. To do this, choose Company → Set Up Users and Passwords → Set Up Users to display the User List dialog box (not shown). To look at the rights that a particular user has, select the user in the list and then click the View User button. When you do, QuickBooks displays the View User Access dialog box (not shown). This dialog box shows the same information as the final version of the Set Up User Access and Password dialog box, which is the dialog box that you use initially to specify what rights a user should have. Click the Leave button to close the View User Access dialog box. To change a user’s rights after reviewing them, select the user and then click the Edit User button. QuickBooks steps through the same set of dialog boxes that you use to set up the user and describe his rights. You use the Next and Back buttons to do things such as change the username or password, specify whether the user should be limited in his access, and — if necessary — to limit the user’s access to a particular activity within QuickBooks. To remove a user, you also use the User List dialog box. Simply select the user and then click the Delete User button. QuickBooks asks you to confirm your deletion. When you click the Yes button for confirmation, QuickBooks removes the user.

Cheat Sheet / Updated 05-02-2022

QuickBooks 2019 makes small-business accounting fast and easy. But your day-to-day business bookkeeping will go even more smoothly if you employ a handful of QuickBooks user interface tricks, editing tricks, and keyboard shortcuts.

Cheat Sheet / Updated 04-27-2022

Keeping track of your accounting with QuickBooks Simple Start means organizing your debits and credits, applying user interface tips, using calculating and editing tricks, working efficiently with keyboard shortcuts, and right-clicking on your mouse to perform basic tasks in QuickBooks Simple Start.

Cheat Sheet / Updated 03-02-2022

You can make the most of your work in QuickBooks Online (QBO) and QuickBooks Online Accountant (QBOL) using handy and time-savings shortcuts and tool buttons. Using QBO keyboard shortcuts means that you can seamlessly access various windows and pages without touching a mouse. The various icons at the top of the QBO page help you quickly search for items, create new items, or display transactions.

Cheat Sheet / Updated 02-17-2022

QuickBooks 2021 makes small business accounting fast and easy. But your day-to-day business bookkeeping will go even more smoothly if you employ a handful of QuickBooks user interface tricks, editing tricks, and keyboard shortcuts.

Cheat Sheet / Updated 10-01-2021

QuickBooks 2022 makes small-business accounting fast and easy. But your day-to-day business bookkeeping will go even more smoothly if you employ a handful of QuickBooks user interface tricks, editing tricks, and keyboard shortcuts.

Article / Updated 04-06-2021

Balancing a bank account is remarkably easy in QuickBooks. In fact, I’ll go so far as to say that if you have any problems, they stem from . . . well, sloppy record keeping that preceded your use of QuickBooks. Enough of this blather. I get started by describing how you reconcile an account. Give QuickBooks information from the bank statement In a reconciliation, as you probably know, you compare your records of a bank account with the bank’s records of the same account. You should be able to explain any difference between the two accounts — usually by pointing to checks you wrote that haven’t yet cleared. (Sometimes, deposits fall into the same category; you record a deposit and mail it, but the bank hasn’t yet credited your account.) The first step, then, is supplying the bank’s account information to QuickBooks. You get this information from your monthly statement. Give QuickBooks the figures it needs, as follows: 1. Choose Banking→Reconcile, or click the Reconcile icon on the home screen. QuickBooks displays the Begin Reconciliation dialog box, as shown. If you have several bank accounts, you may have to choose the account you want to reconcile. 2. If the bank account shown isn’t the one you want to reconcile, open the Account drop-down menu, and choose the correct account. 3. Enter the bank statement date in the Statement Date text box. You can adjust a date one day at a time by using the plus (+) and minus (–) keys. You can also click the Calendar button at the right end of the Statement Date text box to select a date from the calendar. See the online Cheat Sheet for a list of other secret date-editing tricks. 4. Verify the bank statement opening balance. QuickBooks displays an amount in the Beginning Balance section of the screen. 5. Enter the ending balance from your bank statement in the Ending Balance text box. 6. Enter the bank’s service charge. If the bank statement shows a service charge, and you haven’t already entered it, move the cursor to the Service Charge text box, and type the amount. (Type 10 for a $10 service charge, for example.) 7. Enter a transaction date for the service-charge transaction. QuickBooks adds one month to the service-charge date from the last time you reconciled. If this date isn’t correct, type the correct one. 8. Assign the bank’s service charge to an account. Enter the expense account to which you assign bank service charges in the first Account text box — the one beside the Date text box. Activate the drop-down menu by clicking the down arrow, highlight the category by using the arrow keys, and then press Enter. I’ll bet anything that you record these charges in the Bank Service Charges account that QuickBooks sets up by default. If you told QuickBooks that you also want to track income and expense amounts by using classes, QuickBooks adds Class text boxes to the Begin Reconciliation dialog box so that you can collect this information. 9. Enter the account’s interest income. If the account earned interest for the month, and you haven’t already entered this figure, type an amount in the Interest Earned text box. 10. Enter a transaction date for the interest income transaction. You already know how to enter dates. I won’t bore you by explaining it again (but see step 3 if you have trouble). 11. Assign the interest to an account. In the second Account text box, enter the account to which this account’s interest should be assigned. I bet that you record this one under the Interest Income account, which is near the bottom of the Account drop-down menu. To choose a category from the Account menu, activate the menu by clicking the down arrow, highlight the category, and then press Enter. 12. Click the Continue button. QuickBooks displays the Reconcile window, as shown. Mark cleared checks and deposits In the Reconcile window, you tell QuickBooks which deposits and checks have cleared at the bank. (Refer to your bank statement for this information.) Follow these steps: 1. Identify the first deposit that has cleared. You know how to do this, I’m sure. Just leaf through the bank statement to find the first deposit listed. 2. Mark the first cleared deposit as cleared. Scroll through the transactions listed in the Deposits and Other Credits section of the Reconcile window, find the deposit, and then click it. Alternatively, you can highlight the deposit by using the Tab or arrow keys and then pressing the spacebar. QuickBooks places a check mark in front of the deposit to mark it as cleared and updates the cleared statement balance. If you have a large number of deposits to clear, and you can identify them quickly, click the Mark All button and then simply unmark the transactions that aren’t on the bank statement. To unmark a transaction, click it. The check mark disappears. 3. Record any cleared but missing deposits. If you can’t find a deposit in the Reconcile window, you haven’t entered it into the register yet. I can only guess why you haven’t entered it. Maybe you just forgot. Close or deactivate the Reconcile window by clicking the Leave button. Now open the register and enter the deposit in the register in the usual way. To return to the Reconcile window, either reopen it or reactivate it. Or, if you like, choose Banking→Make Deposits and open the deposit screen right on top of the Reconcile window. Record the deposit and then click the Save & Close button. When you open the Reconcile window again, the deposit appears in the Deposits and Other Credits area. 4. Repeat steps 1–3 for all deposits listed on the bank statement. Make sure that the dates match and that the amounts of the deposits are correct. If they’re not, go back to the transactions to correct them. To get to a transaction, click the Go To button. You see the Write Checks or Make Deposits window where the transaction was originally recorded. Make the corrections there and then click Save & Close. You return to the Reconcile window. 5. Identify the first check that has cleared. No sweat, right? Just find the first check or withdrawal listed on the bank statement. QuickBooks enables you to sort the transactions listed in the Reconcile window by clicking the column headings in the Checks and Payments section and in the Deposits and Other Credits section. You may want to experiment a bit with this handy feature. Sorting and re-sorting transactions — particularly in high-transaction volume bank accounts — often eases the work of reconciling a bank account. 6. Mark the first cleared check as cleared. Scroll through the transactions listed in the Checks and Payments section of the Reconcile window; find the first check; and then click it. You also can highlight it by pressing Tab and an arrow key. Then press the spacebar. QuickBooks inserts a check mark to label this transaction as cleared and updates the cleared statement balance. 7. Record any missing but cleared checks. If you can’t find a check or withdrawal in QuickBooks, guess what? You haven’t entered it in the register yet. Close or deactivate the Reconcile window by clicking its Leave button or by activating another window. Then display the register and enter the check or withdrawal. To return to the Reconcile window, reopen or reactivate it. Or you can choose Banking→Write Checks, create the check right on top of the Reconcile window, and then click Save & Close to return to the Reconcile screen and carry on from where you left off. 8. Repeat steps 5–7 for all withdrawals listed on the bank statement. These steps don’t take very long. Reconciling my account each month takes me about two minutes. I’m not joking or exaggerating. By two minutes, I really mean two minutes. If the difference equals zero After you mark all the cleared checks and deposits, the difference between the Cleared Balance for the account and the bank statement’s Ending Balance should equal zero. Notice that I said should—not will. The background window in the above figure is a Reconcile window in which everything is hunky-dory. See that there’s zero difference in the bottom-right corner of the Reconcile window in the above figure? That means your bank account and QuickBooks file are in sync. If the difference is small, look for small differences between the amounts of the checks in the register and the actual cleared checks in the bank statement. If you find a discrepancy with a particular check, click the Go To button to go to the check and change the amount. Click Save & Close to go right back to the Reconcile window. If the difference does equal zero, you’re finished. Click the Reconcile Now button. QuickBooks displays a congratulatory message box (see figure above) telling you that the reconciliation is complete. As a reward for being such a good boy or girl, the message box asks whether you want to print a free, all-expenses-paid Summary or Detail reconciliation report. Click Summary or Detail and then click OK if you want to print the report; otherwise, just click Close. Can’t decide whether to print the reconciliation report? Unless you’re a business bookkeeper or an accountant who is reconciling a bank account for someone else — your employer or a client, for example — you don’t need to print the reconciliation report. All that printing does is prove that you reconciled the account. (Basically, this proof is the reason why you should print the report if you’re a bookkeeper or an accountant. The person for whom you’re reconciling the account will know that you did your job and will have a piece of paper to refer to later with any questions.) Also, you can always come back and print the report later, if necessary. To access the reconciliation reports that QuickBooks saved, choose Reports→Banking→Previous Reconciliation. Now each deposit, withdrawal, and check that you cleared is marked with a check mark in your register. If you don’t believe me, open the register and find out. If the difference doesn’t equal zero If the difference doesn’t equal zero, you have a problem. If you click the Reconcile Now button, QuickBooks shows you the Reconcile Adjustment dialog box, shown below. This dialog box tells you how unbalanced your account is and asks whether you want to adjust your maladjusted account. Click the Return to Reconcile button if you want to go back to the Reconcile window and start the search for the missing or incorrectly entered transaction. If you want to force the two amounts to agree, click OK. Forcing the two amounts to agree isn’t a very good idea. To do so, QuickBooks adds a cleared transaction equal to the difference. Postponing a reconciliation (by clicking the Leave Reconcile button) and not choosing to adjust the bank account balance usually is the best approach, because you can locate and correct the problem later, when you have fresh eyes. Then you can restart the reconciliation and finish your work. (You restart a reconciliation the same way that you originate one.)