company preferences

QuickBooks Helps You Make a Statement

How do you let customers know they owe you money? Probably by sending invoices. And how’s that working for you? If your customers are all conscientious and pay on time, maybe that’s all you need to do.

But perhaps you need to consider doing at least part of your billing by dispatching statements. These forms have their drawbacks. For example, you can’t include sales tax or discounts on them. You can’t group related charges and subtotal them. And your customization options are weaker than in invoices.

Statements lay out the customer’s current financial obligation to you, including any statement charges, invoices, payments, unpaid bills and finance charges that have accrued during a specified period. Unlike invoices, they do not create new charges; they simply report on what’s already been entered. Billing statements that outline historical transactions can be sent as reminders of past due accounts, or you can use them for customers who order frequently, to keep track of items until you’re ready to bill and ship. They’re also useful when you request payment in advance.

You should not invoice for any products or services that have already been entered as statement charges or the customer will be double-billed. Statement charges show up under Recent Transactions in the window adjacent to invoice forms; they also appear in the Customer Center and your Accounts Receivable account in the Chart of Accounts. And you can find them in the Customer Register (Customers | Enter Statement Charges).

Outlining the charges

If you want to enter new statement charges instead of an invoice for, say, a monthly billing or a customer who is ordering frequently but is not ready to be billed, click on the Statement Charges icon on the desktop. (If there’s no icon and you want one, click Edit | Preferences, then Desktop View | Company Preferences, then click in the box next to Statements and Statement Charges.) Or you can just click Customers | Enter Statement Charges.

Click on Edit | Preferences to add Statement Charges and Statements icons to your desktop.

The customer register opens. Select the customer you want to create a charge for by clicking the down arrow next to Customer:Job. If you are in the middle of more than one job for the customer, make sure you make the correct one active.

Go down to the first blank line and change the date if necessary. Tab to the Item field, and drop the list to select the relevant product or service. Tab and enter the Quantity. The Rate and Amt Chrg should be filled in (if not, go back to Lists | Item List and edit the record). QuickBooks will have entered STMTCHG in the Type field. Tab to the Description field and complete it if it’s blank, and select a Class if you’d like. Your window will look something like this:

It’s very easy to enter statement charges in QuickBooks.

If you have another charge for that job or customer, go ahead and enter it. When you’re done with charges for that job/customer, click Record.

Build a statement

You can create statements at any time from data already entered in QuickBooks. The process is the same whether you’ve just entered a series of charges, as outlined above, or you want to remind a customer of outstanding invoices. You’re simply capturing all activity within a given time period. To do so, click the Statements icon on the home page. This window opens:

You’ll select options from this window when you’re building a statement run.

If the window contains an A/R field, that means that you have more than one receivables account. Be sure to select the appropriate one. Verify, too, that the date is correct. This will appear in the customer’s register as the Billed Date.

Here, too, you can choose a range of transaction dates for your statement(s), or simply opt to create forms for all customers with open transactions (in the latter case, you can limit it to transactions that are more than 30 days past due). You must also indicate whether you want statements sent to all customers or a subset. You can manually choose one or many customers, or select by Type (commercial, residential) or Preferred Send Method (E-mail or Mail).

QuickBooks gives you some control over your statements’ layout; click Customize if you want to explore this. Next, you can indicate whether you want to create one statement per customer or per job. The other options here are self-explanatory, but be sure to go through them every time you create statements.

Another decision

Will you be wanting to assess finance charges on the past due charges? This is a decision you should talk over with your ProAdvisor. It’s a complex issue. Should you want to do so, though, clicking on Assess Finance Charges will open the Assess Finance Charges window.

When you’re satisfied with all of your statement choices, you can Preview them. Here’s an example:

Statements lay out all transaction activity within a given period. Statement charges appear as “Due.” In this case, you’re reminding the customer that there’s a large past due balance as well as additional new charges.

Statements can be an effective way to let your customersâ€”and youâ€”get a comprehensive view of their financial interaction with you. They can be used instead of invoices, but there are limitations. If you’re still unclear on how these forms can fit into your accounting workflow, your ProAdvisor can help.

Classes or Types? When To Use Them in QuickBooks

QuickBooks’ standard reports are critical to understanding your company’s past, present, and future. But the program also offers innovative tools that can make them significantly more insightful and comprehensive.

QuickBooks offers two simple conventions that let you identify related data: classes and types. Classes are used in transactions. Types are assigned to individual customers, vendors, and jobs.

For example, you might use classes to separate transactions that relate to different departments, locations, or types of business. A construction company might want to track classes using New Construction, Remodel, and Overhead. Your customer types might help you isolate groups by characteristics like Industry or Geographical Location.

Creating Classes

First, make sure that QuickBooks is set up to use classes. Go to Edit | Preferences | Accounting | Company Preferences. Make sure that Use class tracking is checked. If you want to be prompted for a class designation in transactions, check that box, too. QuickBooks already contains a Type field in customer, vendor, and job records.

It’s easy to build lists of options for both. To define classes, go to Lists | Class List. In the bottom left corner of the screen, click on Class, then select New from the menu. You’ll see this:

Figure 1: To create a class, just give it a name and click OK

Let’s say that you’re a contractor and you want to separate remodeling jobs into room types, like Bathroom or Kitchen. Go through the above steps again. Enter “Bathroom” in the Class Name field and click the box next to Subclass of. Open the list and choose “Remodel.” Click OK.

Tip: If your class list grows lengthy and you want to tidy it up, you can make classes that you’re not currently using inactive by checking the box in this window. It will remain in your QuickBooks records and can be reactivated again.

Putting Classes to Work

Now you can use classes in transactions. Open a blank invoice and select a customer. The Class field will be next to the customer name. If the entire invoice will be assigned to the same class, click the drop-down list and select it. You can also assign separate classes to individual line items:

Figure 2: You can assign different classes to individual line items in transactions.

Not all invoice templates include a column for classes. You can add this by selecting the invoice form you want to modify and clicking Customize in the toolbar.

QuickBooks comes with two reports specially designed for tracking class-based transactions: Profit & Loss by Class and Balance Sheet by Class (both can be found in the Reports menu, under Company & Financial). Of course, you can filter other reports to include a class column. You can also create a QuickReport for individual classes. Go to Lists | Class List and select a report or graph.

Figure 3: You can filter by class in QuickBooks reports.

Warning!
The Balance Sheet by Class report is complicated and may produce unexpected results. Let your ProAdvisor help you work with this one. They can also help you set up a solid class structure.

A Simpler Assignment

Customer, vendor, and job types are a bit less complicated. Job types are especially useful; you can track, for example, profitability and time spent on individual projects. Customer and vendor types can produce output for things like targeted mailings and reports.

Creating types is very similar to creating classes. Go to Lists | Customer & Vendor Profile Lists, and select the type you want to work with. You’ll follow the same instructions here as you did for classes. Types do not appear on transactions; they’re designed for your own internal use, and they’re stored in records.

Figure 4: Customer, vendor, and job types are specified in their records.

Classes and types can be used very effectively in your bookkeeping, but they require a good deal of thought and planning upfront to get accurate, meaningful reports. Let your ProAdvisor know if he/she can assist as you attempt to use these powerful forms of classification.