QuickBooks: How to avoid the top mistakes made by new QuickBooks users

If you’re new to QuickBooks, now is the time to get off on the right foot. Learn from others’ mistakes and avoid these common problems. You’ll thank yourself later!

Don’t use the sample files as your actual company file

QuickBooks includes sample files that you can use as examples for setting up your own QuickBooks company data file. These files are examples, not templates. They contain only a limited set of items and services typically performed by particular types of businesses. Use them to see how a file might be set up and to learn how QuickBooks works. Do not try to use these files for your live information; they won’t work for that purpose. You must create your own company file to store your accounting data. mistakes_01

Don’t write a check and forget to apply the payment to the bill

QuickBooks gives you options for paying your bills, depending on how closely you want to track bills and payments. Once you’ve chosen a method for a particular bill, you need to stick with it — otherwise you might end up paying your bills twice. Here’s what to do:

  • If you enter a bill in the Enter Bills window, always use Pay Bills to pay it. (If you use Enter Bills and Pay Bills, you can still pay by check or credit card.)
  • If you’re sure you don’t need to track your bills and bill payments, you can use the Write Checks or Enter Credit Card Charges window instead of using Enter Bills and then Pay Bills.
  • Don’t use Pay Bills if you’ve already used the Write Checks or Enter Credit Card Charges window to record your bill payment.

Don’t enter invoices and then make a deposit without going through the Receive Payments step

If you are entering invoices in QuickBooks to record your sales, be sure to use the Receive Payments screen to apply the payment against the invoice. Sometimes people make the mistake of skipping that step. But if you go right to the Make Deposits screen, the invoice won’t show as paid, and your sale might end up being counted twice. mistakes3

Don’t accidentally record your customer payments twice

When you receive a payment from a customer, you have two options:

  • You can record that payment as a deposit to a bank account in QuickBooks at the same time that you apply the payment against the customer’s account. The payment will be automatically recorded as a deposit to your bank account on that day. (All you need to do is get the check to the bank, if necessary.)
  • Alternatively, you can group several payments together and then record the entire group as a deposit in QuickBooks later. In this case, QuickBooks holds those payments in the Undeposited Funds account until you move them to the bank account.

When you receive a payment for an invoice and enter it in the Receive Payments screen, QuickBooks automatically puts that money in the Undeposited Funds account. Sometimes people do this but then also make a separate deposit for the same amount, and that makes a mess of their records. Instead, when you go to the Make Deposits window, include the payment in the Payments to Deposit window that comes up. This will move it from Undeposited Funds to your bank account.

Don’t choose your bank account in the Expense Account field when writing a check

When they’re using the Write Checks window, sometimes users don’t realize that the check is already affecting their bank account, so they select their checking account as the expense account. This causes the money to go out and immediately back into your checking account instead of reducing the checking balance. Typically, you’d want to specify one of the expense accounts you’ve set up, such as Utilities, not the bank account the check is drawn on. mistakes4

Don’t rename or delete the critical accounts that QuickBooks automatically creates

To simplify the job of setting up your company file, QuickBooks creates critical accounts like Retained Earnings and Sales Tax Payable for you. Changing the names or account types it assigns, or moving these accounts, can seriously impair QuickBooks’ ability to work for you.QuickBooks automatically sets up other accounts as well: Accounts Receivable, Cost of Goods Sold, Estimates, Inventory Assets, Payroll Liabilities, Payroll Expenses, Purchase Orders, Retained Earnings, Sales Tax Payable, and Undeposited Funds. Moving or editing these accounts can easily introduce errors to your financial records. Worst case: You might have to dedicate hours (or days!) recreating these accounts and correcting all the errors, and we bet you’ve got better things to do!

Don’t assign items to the wrong kind of account

In QuickBooks, an item is anything your company buys, sells, or resells in the course of business, such as products, services, shipping and handling charges, discounts, and sales tax, if applicable. Think of the line items on an invoice. For your records to be accurate, you need to associate every item you create with an account and account type that make sense. For example, any item you sell must be assigned to the right income account. (Generally, Balance Sheet accounts – such as Bank, Accounts Receivable, Accounts Payable, Credit Card, etc. – would not be assigned to items.) mistakes7

Leave a Reply