Using Custom Fields and Classes in QuickBooks® Online

QBO’s tools are generic enough that myriad businesses can use it. But custom fields and classes help you shape it to meet your specific needs.

Small business accounting is not a one-size-fits-all proposition. Your company is unique in that sense; you have your own customers and products, vendors and services. Your requirements for your accounting application—what it must do and how it does that—is unlike anyone else’s. QuickBooks Online contains a standard set of features that can accommodate a broad cross-section of the millions of small businesses in the U.S. It also offers customization options that you can use to make it your own. Two of these are custom fields and classes.

Start from the Beginning with Custom Fields

You can start working with custom fields and classes at any time. They’re most effective, though, when you build them in as you’re just starting to use QuickBooks Online.

Let’s look at custom fields first. When we refer to “fields,” we simply mean the rectangular boxes in records and forms that either already contain data or that can be filled in by you, either by entering the correct word or phrase, or by selecting from drop-down lists. Most of these are already named. On an invoice, for example, there are fields for information like Invoice date and Due date.

​But you can add up to three additional fields to sales forms. To do so, click the gear icon in the upper right corner of the screen and select Account and Settings, then click Sales in the vertical navigation bar on the left. The second block here contains Sales form content. Click Custom fields, and you’ll see something like this:

Custom fields

You can define up to three custom fields on sales forms and make them visible internally and/or to your customers.

Click the word Off if it appears, and it will change to On and display three blank fields. Think carefully about what you would like to appear here, as this isn’t something you’ll want to change. If you haven’t yet met with us about how to set up QuickBooks Online, let’s schedule some sessions to go over all your setup procedures, including custom fields. Enter the words or phrases you want displayed on sales forms in the three fields. Then decide whether you want them to be visible only to you and your accounting staff or to your customers, too. Click within the Internal and Public to create checkmarks. When you’re done, click Save.

Additional Categorization with Classes

QuickBooks Online’s classes provide another way to categorize transactions. You can use them to differentiate between, for example, departments or divisions. If you’re a construction company, you might have different classes for New Construction and Remodel. Unlike custom fields, you’re not limited to three classes.

You can filter many reports by class. QuickBooks Online contains report templates designed specifically for reporting by class, like Sales by Class Detail, Purchases by Class Detail, and Profit and Loss by Class.

​Here’s how you create your own list. Click the gear icon in the upper right of the screen and select Account and Settings. Then click Advanced in the left vertical navigation toolbar. Under the fourth heading, Categories, you’ll see Track classes. If the word “Off” appears to the right, click in the box to turn this feature on. A box like this will appear:

Class-tracking in QuickBooks Online helps you create more targeted reports.

Class-tracking in QuickBooks Online helps you create more targeted reports.

Even if you’ve defined a number of classes, they’re not required on transactions. If you want to be reminded should you forget to classify one, click in the box in front of Warn me when a transaction isn’t assigned a class. You can also choose to assign one class to an entire transaction or to each individual row. Click the arrow to the right of One to entire transaction to drop the option box down and make your choice. When you’re done, click Save.

You can create classes as you’re entering transactions by clicking the arrow next to Class over to the right of the screen and selecting +Add new. We recommend, though, that you think this through ahead of time and make at least an initial list by clicking the gear icon in the upper right and choosing All Lists, then Classes, then New.

Great Flexibility

These are two of the customization tools that are built into QuickBooks Online. Whether you’re just getting started or you’ve been using the site for a while, we can introduce you to all the ways that you can make QuickBooks Online your own. 

Establishing Preferences in QuickBooks®

Before you start entering data, make sure QuickBooks is set up appropriately for your company.

QuickBooks was designed to serve the needs of millions of small businesses. To do that, it had to include the tools and processes suitable for a wide variety of companies. But Intuit recognized that every organization is unique, so your copy of QuickBooks can be customized in ways that make it work best for you.
You could just dive in and start adding records and transactions. But we recommend you do some setup first. If you don’t, you may run into some issues later, such as finding that some features you need haven’t been turned on, for example, or that QuickBooks is simply not doing some things the way you do. The good news is that you can change many of these.

Getting There

QuickBooks refers to these options as Preferences. You’ll find them by opening the Edit menu and selecting Preferences.
Preferences

To start customizing QuickBooks so it works best for you, open the Edit menu and choose Preferences.

As you can see, the left vertical pane contains a list of Preference types. Click on any of these to change the option screens to the right. Always click the tabs labeled My Preferences and Company Preferences to make sure you see everything that’s displayed for each type (sometimes one will have no choices).

Setting Up Reminders

Let’s look closely at one set of Preferences: Reminders. It’s very important that you visit these screens when you begin using QuickBooks. Depending on how big your company is and how complex your accounting processes are, there may be things you need to do every day, like pay bills and follow up on overdue invoices. It would be nearly impossible for you to do everything on time if you didn’t ask QuickBooks to keep track of critical dates and remind you of them.

Click Reminders in the left vertical tab. You’ll see one option under My Preferences. Do you want QuickBooks to show Reminders List when opening a Company file? If so—and this is a good idea—click the box in front of that line if there isn’t a checkmark there already.

Then click Company Preferences. Here’s where you’ll tell QuickBooks whether you want to see summaries or lists for each reminder, or neither. You can also specify how much advance notice you want for specific tasks by entering a number of days. QuickBooks comes with default settings, but you can easily change these.

Preferences

QuickBooks comes with default settings for Reminders, but you can enter your own Preferences here.

As you can see, it’s easy to specify your Company Preferences. Click the appropriate button under Show SummaryShow List, or Don’t Remind Me. If you’ve requested a reminder, delete any number that appears in the box in front of days before or days after and then enter your own.

Critical Areas

We recommend that you look through all of QuickBooks’ Preferences and change any that don’t fit your company. Some simply have to do with the way QuickBooks displays information and how it functions, but others have direct impact on your accounting work. As always, we’re available if you have questions here.
There are many that you will probably want to visit. They may have numerous options, but here’s some of what you can establish in each:

  • Accounting. Do you want to use account numbers and classes?
  • Checking. Which accounts should QuickBooks automatically use for tasks like Open the Pay BillsOpen the Make Deposits, and Open the Create Paychecks?
  • Finance Charge. Will you be assessing finance charges on late payments from customers? What’s the interest rate, minimum finance charge, and grace period?
  • Items & Inventory. Do you want inventory and purchase orders to be active?
  • Multiple Currencies. Does your company do business using other currencies?
  • Payments. Can customers pay you online? What methods can they use?
  • Payroll & Employees. Will you be processing payroll using QuickBooks?
  • Sales & Customers. Do you want to use sales orders? How should QuickBooks handle invoices when there are time and costs that need to be added?

You can see why it’s important to study QuickBooks’ Preferences early on. It’ll help you avoid unnecessary roadblocks and ensure that your company’s needs are reflected well in the software.

Use Recurring Transactions in QuickBooks® Online

Save time and ensure that repeating transactions are processed as scheduled.

You know how much time QuickBooks Online already saves you. Customer, vendor, and item records need never be entered again once they’re created for the first time. Pre-built forms use your record data to complete transactions quickly and accurately. Customizable report templates provide real-time overviews of your financial status in every area.

There’s another way QuickBooks Online can reduce the time you spend on accounting chores: recurring transactions. If you have invoices, bills, and other transactions that occur on a regular basis, you can save all or part of their data to use again. You can even choose to have them dispatched automatically.
Here’s how it works. You need to create a template, a type of model, for each recurring transaction. To do this, simply create the transaction you want to repeat. Say it’s an invoice for a service you provide monthly to a company or individual. You’d fill in all the required fields, then click Make recurring in the horizontal toolbar at the bottom of the screen. This window will open:
Make recurring

When you click Make recurring at the bottom of a transaction, this window of options will display.

Select the Customer first by clicking the arrows to the right of the blank field. QuickBooks Online will fill in contact information and automatically display name that as the Template name. You can leave it there, or you can try to think of a phrase that describes the transaction, so you’ll remember it. Next, you need to decide how QuickBooks Online will handle the transaction. There are three options:

  • Scheduled. Be very careful with this one, since QuickBooks Online will automatically create and dispatch it. This only works if the information in the transaction—minus the date—is always exactly the same.
  • Reminder. This is safer. QuickBooks Online will display a reminder in time for you to complete and process the transaction.
  • Unscheduled. QuickBooks Online will do neither of the above, but the template will be available to use as you need it. This is good for infrequent transactions that share some common information.

Next, taking into account variables like delivery methods and due dates, enter a number in the field in front of days in advance. Then skip down to Options and click the box in front of all the statements that apply to that transaction. The bottom line in this window contains the fields that will let you specify the transaction’s Interval.

Click the arrows next to each field to open its menu.
In the example above, we’ve indicated that the invoice occurs monthly on the first day of the month, starting on January 1, 2017. You don’t know how long this will recur, so we’ve left End set to None. When you’re satisfied with everything in the window, click Save template in the lower right corner.

To see a list of the repeating transactions you’ve defined, click the gear icon in the upper right corner of the screen and select Recurring Transactions. A table displaying them will open and display columns including Type, Interval, and Previous Date. Look toward the end of one of these lines. To modify the template, click Edit.

Recurring Transactions

The Recurring Transactions screen gives you an overview of the templates you’ve created and provides links to action options.

There are other options here that vary depending on the type of transaction. In the screen shot above, the template is a bill. You can:

  • Use it to create a new transaction,
  • Duplicate it and modify it, to make a new template,
  • Pause it, to temporarily suspend its recurrence,
  • Skip next date and resume after the next interval, or
  • Delete

QuickBooks Online also includes a report that will display all the templates you’ve created. Click Reports in the left vertical pane, then All Reports (unless this list is already active), then Accountant Reports. You’ll find the Recurring Template List in the lower right corner.

Recurring transaction templates can save you a lot of time and increase accuracy. Conversely, they can result in unbilled revenue and past-due bills—or even duplicate transactions—if they’re not created with precision. We’d be happy to step in and guide you through the process for the first time.

Anatomy of a QuickBooks® Inventory Item

If you have an item-heavy business, you need tools to track your inventory. QuickBooks provides them.

When you started your business, maybe you were able to keep track of your inventory by peering in the closet or your garage. As you grew, that simply took too long. But you grew tired of running out of stock because you didn’t have time to constantly check its levels, and you forgot about items that didn’t sell and were tucked away in a corner.

You need inventory-tracking. QuickBooks can help you create thorough records for each product you sell. It keeps track of how much you have on hand and warns you when your stock is running low. And its reports tell you what’s selling and what’s not, so you can make better, smarter purchasing decisions.

Activating Inventory-Tracking

Before you get started creating item records and including them in transactions, you need to make sure that QuickBooks is set up to start tracking. Open the Edit menu and click Preferences. Click Items & Inventory in the left vertical pane and then select the Company Preferences tab. This window will open:
inventory-tracking

QuickBooks needs to know what your intentions are when it comes to inventory-tracking.

First, of course, click in the box to the left of Inventory and purchase orders are active if it isn’t already checked. Click the next box down if applicable. The rest of this window deals with two concepts you need to understand. Quantity on Hand refers to the number of items that you actually haveQuantity Available subtracts items currently on Sales Orders. QuickBooks will warn you if you don’t have enough of a specific item to commit to a customer. You just have to decide which definition of Quantity you want to use. When you’re done here, click OK.

Accuracy Matters

Now you can start entering records for the products you sell. Accuracy is absolutely essential here. You’ll see why as you explore QuickBooks’ tracking capabilities. There are a few ways to open an item record window. You can click Items & Services in the upper right corner of the Home Page, or open the Lists menu and select Item List. Both will open a window displaying any item records that have been entered in a register-type view. Right-click anywhere and select New, or click the arrow next to Item in the lower left corner and select New.
QuickBooks item record window

Double- and triple-check your work as you enter information in the QuickBooks item record window.

QuickBooks lets you create records for numerous types of items, including ServiceDiscount, and Inventory Assembly. To see how inventory-tracking works, select Inventory Part from the drop-down menu under TYPE. Next, enter an Item Name/Number in that field.

If you’ve already named a main category (like Hardware, in the example above) and want to place your product in a subcategory of it, click the Subitem of box and choose from the drop-down list. Manufacturer’s Part Number is optional. You can ignore UNIT OF MEASURE, if this isn’t an option in your version of QuickBooks.

Purchase Information

If you buy this item from a vendor, fill in this side of the window. Write the description that should appear on purchase transactions when you place an order. Enter the cost you pay for it, and select the COGS (Cost of Goods Sold) account if the default isn’t correct. Do you buy this product exclusively from one supplier? Select the name in the drop-down menu under Preferred Vendor.

Sales Information

Enter the description you’d like customers to see on invoices and the price you’ll charge. If you’re at all unsure of what to select for Tax Code or Income Account, we can go over your Chart of Accounts with you and explain how its accounts are used in records and transactions.

Inventory Information

Here’s where the software’s tracking capabilities come in. QuickBooks will probably default to your Inventory Asset account, which is fine. Enter the minimum number of items that should be in stock when you get a reminder to reorder, and the maximum you want to have at any one time. Fill in the On Hand field with the number you currently have. QuickBooks will automatically calculate the Total Value.

In the screen shot above, you see an example of what that last line looks like once you start using that item in transactions. You’ll see its Average Cost and the number that are currently on purchase orders and sales orders.

​Creating records for every product you sell can be tedious, time-consuming work. But the payoff comes in the real-time knowledge you’ll have of your inventory that will lead to better, smarter purchasing decisions. As always, we stand ready to help.

5 QuickBooks® Online Add-On Apps You May Need in 2017

Not finding quite everything you need in QuickBooks Online? Here are some handy add-on apps available.

QuickBooks Online may work for you just fine as is. After all, it was designed to meet the needs of the millions of small businesses that want to manage and track their income and expenses, create records and transactions, and run reports to gauge their financial health. 

QuickBooks Online was also designed to grow along with your business. But there’s no need for Intuit to add internal features to do so. In fact, that would make it too expensive and unwieldy for many companies.

Instead, Intuit has partnered with other small business websites to provides add-ons—applications that extend the usefulness of QuickBooks Online in one or more areas, like accounts receivable and payable, inventory, and expense-tracking. They integrate easily to share data and do the extra work you need. Here are some of them to consider.

Bill.com

Bill.com

Bill.com automates your accounts receivable and payable processes. It supports electronic billing and payment, as well as multiple approval levels.

You can certainly enter and pay bills using QuickBooks Online. And you can send invoices to customers and receive payments. But adding a connection to Bill.com gives you more advanced options for accounts receivable and payable. Simply send your bills to Bill.com by scanning, emailing, faxing, or taking a picture with your smartphone. The site’s automation tools turn them into digital records and route them through your specified approvers. Once approved, they’re paid electronically or by paper check. Invoices are just as easy to process; customers can pay by using PayPal, credit card, or ACH. Bill.com’s mobile app makes it possible to keep up with invoices and bills while you’re out of the office.

Expensify

Are your employees still paper-clipping receipts to handwritten expense reports? This method is unnecessarily time-consuming – and often inaccurate. Expensify solves both problems. Your staff can take photos of receipts with their smartphones. Expensify then converts the expense information into coded digital records and submits them for approval based on your company’s policies. Credit card purchases can be automatically imported, too. All data is synchronized with QuickBooks Online in real-time and coded to reflect your preference of QBO’s expense accounts, customers/jobs, etc. Once you’ve approved a report, you can have the money deposited in the employee’s bank account the next day.

TSheets Time Tracking

TSheets employee scheduling software automates tasks that QuickBooks Online doesn’t do: scheduling and remote time-tracking for your hourly employees. Your staff no longer has to fill in paper timesheets. Instead, they can use their smartphones to track their hours and GPS location points. And while Excel is certainly better for creating schedules than paper, TSheets takes over that task, too. After you’ve approved timesheets, that information is sent over to QuickBooks, ready for use in your payroll processing.
TSheets

Your employees can easily “punch” in and out using their smartphones. TSheets also uses GPS technology so that your staff members’ locations are always known to you.

SOS Inventory

QuickBooks Online performs some basic inventory management tasks. You can create records for items and use them in transactions, and keep track of the number of items in stock so you know when to reorder (or have a sale). SOS Inventory goes well beyond those capabilities. You can create sales orders, track cost history and serial numbers, and document work-in-progress (WIP). SOS Inventory supports multiple locations and the entire pick/pack/ship process.

Insightly CRM

You can create thorough customer records in QuickBooks Online and document some of your interaction. But it doesn’t facilitate true Customer Relationship Management (CRM) nor project management. Insightly CRM does both. It lets you build exceptionally thorough customer profiles so that you can view social streams, email history, and any events, opportunities, or events related to them. Its project management features include the ability to track by pipelines or milestones, define contact roles and custom fields, and generate advanced project reporting.

QuickBooks Online Integration Key

All of these apps can work in standalone settings, but their integration with QuickBooks Online and their mobile capabilities create powerful partnerships that help you serve both your customers and your employees in ways that QuickBooks Online alone can’t.

We’re not trying to sell you applications here. Our concern is that you’re getting as much out of QuickBooks itself as you can. We can steer you toward add-on solutions if that seems necessary, but we’re always happy to work with you on getting to know QuickBooks Online better and matching its capabilities to your company’s needs.

Ringing Out 2016 in QuickBooks®

2017 is just around the corner. Now’s the time to do your end-of-year QuickBooks® tasks.

Since early January of this year, you’ve been faithfully creating new records, entering transactions, and recording payments. You’ve run basic reports. You’ve done your collection duties. You may have paid employees and submitted payroll taxes.

Now the end of the year is rapidly approaching. In the midst of holiday get-togethers, gift shopping, and perhaps preparing for travel, you probably have a list of work tasks that must be completed by December 31.

​Is your annual QuickBooks wrap-up on that list? It should be. Here are some of the things we suggest you fit into your busy schedule sometime this month.

Create and send year-end statements.

Statements to past-due accounts.

As your customers wrap up 2016, too, it’s good to send statements to past-due accounts.

In an ideal world, all of the invoices that are currently due would be paid off by the end of the year. We all know that that’s not usually the reality. Two reports can help you here: the A/R Aging Summary and Open Invoices.

Give everyone a chance to clear their accounts before December 31 by sending statements. Click Statements on the Home page (or Customers | Create Statements) to open the window pictured above.

You have multiple options here that are fairly self-explanatory. The screen above is set up to create statements for all customers who have an open balance as of the date you select, but not for inactive customers or those with a zero balance or no account activity. That way, no one who’s paid in full to date will receive a statement. Of course, if you didn’t want statements created for anyone who’s less than 30 days past due, you’d click in the box in front of Include only transactions over and enter a “30” in the following field. Questions about all of this? Give us a call.

​Tip: You can also find out who’s overdue by clicking on the Customers tab in the left vertical pane to open the Customer Information screen. Click on the down arrow to the right of the field just below Customers & Jobs. QuickBooks provides several filters for your list.

Reduce your inventory.

Change Item Prices

Want to discount all or selected items in your inventory by the same percentage or amount? Open the Customers menu and click Change Item Prices. We can work with you on the whole item pricing process.

The week between Christmas and New Year’s Day might be a good time to sell excess inventory by having a sale. If you only sell a few products, you probably know what hasn’t sold well in 2016. If your stable of products is larger, you can run QuickBooks reports like Inventory Stock Status by Item and Sales by Item Detail to identify your slow-sellers and discount them. You may need to filter your reports to see the right data. Talk to us about customization options if you’re unsure of this.

Clean up your contact lists.
If you don’t maintain your customer and vendor lists, you’ll eventually start wasting time scrolling through them when you enter transactions. So this would be a good time to designate those contacts that you’ve not dealt with in 2016 as Inactive (you can delete their records entirely, but we advise against that). Simply open a Customer record, for example, and click the small pencil icon in the upper right to edit it. Click on the box in front of Customer is inactive.

Send holiday greetings to customers and vendors.
It’s getting a little late to send a holiday greeting/thanks-for-your-business note in December. Consider doing this in January (Best Wishes for a Successful 2017!) when your customers’ and vendors’ lives have slowed down a bit. You’re less likely to get lost in the crowd. If your lists are short enough, personalize these cards as much as possible. At least sign them by hand if you can.

Tip: You can print customer labels for your cards directly from QuickBooks. Open the File menu and then click Print Forms | Labels.

Run advanced reports.
Here’s where we come in. If we’re not already creating and analyzing QuickBooks’ advanced financial reports (found in the Accountant & Taxes submenu of Reports) monthly or quarterly, talk to us about it. They’re important, and they give you insight that you can’t get on your own. This is another activity that can spill into January.

We’d like to thank you for being a client this year, and to wish you a successful 2017!

Stock image courtesy of FreeDigitalPhotos.net

Paying Bills in QuickBooks Online

In a previous column, we talked about setting up bills in QuickBooks Online. Now it’s time to pay them.

We recently laid out the benefits of using QuickBooks Online for bill entry and payment. It’s faster than manual methods. It leaves an electronic record of your accounts payable. And it helps ensure that bills are paid accurately and on time.

As we discussed, QuickBooks Online employs a two-step process for bill payment. Once you’ve completed the first (setup), the hard part is done, and you can move on to fulfilling your financial obligations. Let’s take a look.



Warning: Because you may be “handling” a lot of your bills twice in QuickBooks Online, this system can take some getting used to. We’ll be happy to walk you through the process until you’re comfortable.
Recurring Bill

Before you can pay a bill, you must create a template and enter its details. You can even set up payments to recur, as shown here.

To review quickly, we created a bill by clicking on the plus (+) sign at the top of the screen and selecting Bill under Vendors. Once you’ve created a bill, you can click on Make recurring at the bottom of the screen to establish periodic payments (as pictured above). You can choose to have payments that are always the same sent automatically, or you can request a reminder so that you can change the amount before emailing or printing. Those reminders appear when you first log into QuickBooks Online. You can access them by clicking on the corresponding link under Tasks.

Making Payments
QuickBooks Online makes it very easy to pay bills. You can do so from a handful of different screens on the site – sometimes in multiple places on the same page.

  • Click on the Vendors tab in the vertical toolbar on the left side of the screen. The page that opens displays a horizontal chain of bars near the top, color-coded to indicate what they represent: Purchase Order, Open Bills, Overdue, and Paid Last 30 Days. Each segment tells you how many transactions share that status as well as their total dollar amount. When you click on a segment, the table below changes to include a list of the actual transactions. At the right end of each line is a Make Payment link that you can click to get a payment screen. If you want to see the actual bill that was sent, click on the Vendor name itself.
  • You can click on the plus (+) sign at the top of any screen where it appears and go to Vendors | Pay Bills.
  • Open the bill itself and click on the Make Payment link in the upper right corner.
Bill Payment

A partial view of the Bill Payment screen

When you’ve opened a bill that you want to pay, double-check the information in the upper part of the screen. The Vendor details should, of course, be correct, but make sure the date reads as it should. And look in the box to the right of the vendor’s name. If it’s not displaying the correct account for the transaction, click on the double arrows and select the right one.

QuickBooks Online will follow its own numbering system for bill payments. If you want to assign your own by entering a reference number of some kind, delete what’s showing in the Ref no. field and add your own. The Bill Payment # in the upper left will change to reflect that.

​If there are multiple bills in the list below, click in the box in front of the one(s) you want to pay to create a checkmark. Look at the end of each line, too. QuickBooks Online defaults to a full payment for bills. If for some reason you’re planning to make a partial payment, replace the dollar amount in the Payment box with your own. In the bottom left portion of the screen, you can enter a Memo if you’d like and add an Attachment. When you’ve checked everything for accuracy, click Save and close or Save and new in the lower right corner.

Automation Helps

Paying bills manually can be painful. Beyond the fact that you’re watching money leave your accounts, the mechanics of writing checks and/or dispatching electronic payments on time—and keeping everything organized—can be a constant challenge. QuickBooks Online’s bill-paying tools can help with that.

Creating Reports in QuickBooks®, Part 2

Last month, we discussed QuickBooks’ report Preferences and The Report Center. We’ll look at report customization this month.

QuickBooks makes your bookkeeping faster, safer, and more accurate than what you could do using a manual system. Still, you may occasionally tire of your daily tasks. You want to know what all of these forms and records mean in terms of your overall financial health. You want to see reports.

The actual mechanics of creating reports in QuickBooks are fairly straightforward. You can go to the Report Center, make a selection, maybe change the date range, and voila! Your company’s related data appears in neat rows and columns.
changing the date range on  QuickBooks

You may be able to get some of the information you need by simply changing the date range on a QuickBooks report.

But perhaps you to see different columns than what QuickBooks’ report templates include. Further, you might like to filter your output for more meaningful, targeted analysis. And frankly, some of QuickBooks’ reports—particularly those included in the categories Company & Financial and Accountant & Taxes—can be a little advanced for the average small businessperson with little bookkeeping experience. They’re easy to run, but difficult to understand.

So we strongly encourage you to let us run these more complex reports, like the Balance Sheet, for you on a regular (monthly or quarterly) basis. They can provide valuable insight as you continue to make critical business decisions.

​But we don’t want to discourage you from working with QuickBooks’ reports on your own. You could run A/R Aging Detail, for example, to keep an eye on past-due payments, or Unpaid Bills Detail to see where you stand with your own financial obligations.

Make Reports Yours

Sometimes, QuickBooks’ own report output is a bit too broad for your needs. So the program provides sophisticated customization options. You can work with these to narrow down and shape the data that appears in your reports.

First, columns. Building reports from scratch would be too time-consuming and frustrating for you to do all of the time. And it’s unnecessary, since QuickBooks provides templates for its reports, sets of columns and data filters that would serve some businesses well, but which can be modified by each user.

​Try this. Open the Profit & Loss Detail report and click on the Customize Report button in the upper left corner. The Modify Report window opens.

QuickBooks

QuickBooks lets you modify the columns that appear in reports.

The Display tab should be highlighted. Change the Report Date Range if necessary by clicking on the down arrow to the right of the Dates field. You can also create your own custom date range by deleting the dates in the From and To fields and entering new ones, or by clicking on the small calendar icons and clicking on the desired dates.

Warning: Do you understand the difference between running reports as either Accrual or Cash? This is important. If you don’t, let’s get together to go over some basic report concepts.

It’s easy to change the default columns that appear in reports. You can either enter a column label in the Search Columns box or scroll down the list of all possible labels. Click in the space in front of the ones you want to include, and click on existing checkmarks if you want to remove those labels. You can also designate a sort order, either Ascending or Descending.

​If you want to work with the Advanced options, or if you come across a Display screen that puzzles you (depending on the report, you may have some complex choices), let us know.

QuickBooks report Filters screen

QuickBooks report Filters screen

When you’re done here, click on the Filters tab. This is a powerful element of QuickBooks report customization. You can limit your report output to data that meet certain criteria. In the image above, for example, you can tell QuickBooks which subset of Accounts should be included. Click on the Billing Status filter, and you can limit the results to AnyNot BillableUnbilled, or Billed. You get the idea.

You can apply multiple filters to a report. Every one you select will appear in the list under Current Filter Choices.

​We’ll skip the Header/Footer and Fonts & Numbers tabs, since these are primarily cosmetic options you can explore on your own. But you can see from this brief overview how you can use many QuickBooks reports as is or customize them extensively. And we do recommend that you work with reports regularly, both on your own and with us. The insight they provide can help your company grow and flourish instead of just getting by.

Customizing QuickBooks Online Forms

Make a good impression on your customers by sending them well-designed sales forms. QuickBooks Online helps you create them.

Your company’s “brand” can be composed of many things (and has many definitions), but it’s really about what pops into your customers’ minds when they think of you. Key components include your logo, your color scheme, and any other identifying visual element that people associate with your business.

A good way to reinforce this image is by making sure that a unifying graphic theme runs through every piece of print or web-based customer content you create, like your website, brochures, blog, and ebooks. Your brand should also be visible on all sales forms you dispatch, like invoices and receipts.
QuickBooks Online comes with its own default sales form style; this is the layout and content that will automatically display when you start a new transaction. You can easily change this and have it apply to all transactions.
QuickBooks Online

Your logo is an important element of your company’s brand. QuickBooks Online lets you include it on sales forms.

Here’s how it works. Click on the gear icon in the upper right of the screen, next to your company name. Select Custom Form Styles to open the table of existing styles. There should be one labeled Standard, though there may be another labeled Classic. You can make either the default by clicking Make Default or Remove as default using the down arrows and links under ACTION at the far right of each row.

Click the Edit link for the default style. This screen contains many of QuickBooks Online’s customization tools. The Style tab in the left vertical toolbar is automatically highlighted. In the column to its right, click through the five design options available and leave the desired one selected. Then click the plus (+) sign in the upper right of the screen. Browse for your logo file when the directory opens and double-click on it to add it to the top of your sales forms. Choose the color scheme you want by clicking in the correct box displayed below.

​When you’re done there, click on the Appearance tab to specify your logo’s placement and change any other settings.

Content Critical

Content Critical

You can decide which fields should and shouldn’t appear on your sales forms by checking and unchecking boxes.

You won’t necessarily need to make every data field available on your sales forms. But you want to include every field you might possibly need without displaying extraneous content areas. QuickBooks Online lets you turn fields on and off and change their labels easily by checking and unchecking boxes.

Click the Header tab on the left to start this process. Among your options here are:

  • Form names. Do you want invoices to say “Invoice,” for example? Do you want to use form numbers and allow custom transaction numbers?
  • How much of your company’s contact information should appear?
  • Do you want fields for TermsDue date, etc?
  • Do you need to define custom fields?

You’ll see more options when you click on the Activity Table tab in the left vertical pane (see image above). Not only can you choose what content appears and how its labels read, but you can also indicate what percentage of that line each entry should occupy. Under WIDTH%, click on the plus (+) and minus (-) buttons to the right of each number to size it (your numbers, of course, should total 100).

Warning: Many of the decisions you have to make when customizing sales forms are simple. Others take some consideration, like custom fields and the handling of billable time. We can help you with these.

Click on the final tab in the left navigation pane, Footer, to add or edit text that should be displayed at the bottom of your sales forms. Click Save in the lower right when you’re done.

Some settings may need to be tweaked in Account and Settings.

Some settings may need to be tweaked in Account and Settings.

Note: As you’re browsing through the content options available as described above, you may find that a field appears to be missing or needs a default setting changed. If this occurs, click on the gear icon in the upper right of the main screen, then on Your Company | Account and Settings. Click on the Sales tab in the left vertical pane to get to Sales form content.

Consistent, well-designed sales forms will help promote your brand and present a polished, professional image to your customers.

Creating Reports in QuickBooks, Part 1

QuickBooks comes with dozens of report templates that can be run as is. This month and next, we’ll show you ways to make them “fit” your company.

Reports are your reward for all that hard work you put in entering records and transactions in QuickBooks. Sure, you can always find individual invoices, sales receipts, and customers by using the software’s search tools, but in order to make smart business decisions, you need to be able to see related subsets of the information you so carefully entered in neat rows and columns.

You’ve probably created at least some basic reports in QuickBooks. You may have, for example, wanted to see who’s late paying you, or whether you have unpaid bills. You might need to know your stock levels, or which purchase orders are still unfilled. You certainly want to keep a close eye on whether you’re making or losing money.

QuickBooks Report Center

The QuickBooks Report Center displays examples of reports you can create using your company’s own data.

QuickBooks makes it easy to get those answers in only a few seconds. But to get really meaningful, targeted views of your accounting information, you’ll want to shape your reports so that they reveal precisely what you need to know. You can do some of this on your own, but you might want to enlist our help to drill down even further – and to create and analyze the more complex output that some reports can provide.

Configure Preliminary Settings
As we often do when we’re starting a tutorial on a specific QuickBooks feature, we’re going to send you to the Preferences window first thing. Open the Edit menu and select Preferences, then Reports & Graphs. With the My Preferences section open, you can instruct QuickBooks on some of the ways reports should be handled. You can choose to:

  • Have the Modify Report window open every time you create a report (to remind you to make any necessary changes first).
  • Set your Refresh options. If you always want to have the most current data displayed when you generate a report, you can tell QuickBooks to Prompt me to refresh or Refresh automatically by clicking on the button in front of the appropriate response. Choose Don’t refresh—the fastest method—if you don’t want to be interrupted when you’re working with a report. You can refresh when you’re done.
  • Draw graphs in 2D to make them run faster, and Use [black and white] patterns instead of colors to better differentiate between segments.
  • Each person who has access to QuickBooks can set these Preferences any way he or she wishes.
Setting Up Company Preferences

You must be the QuickBooks Administrator to set Company Preferences.

You can decide on your own whether Aging Reports should start the aging process from the due date or the transaction date. Decide how you want Items and Accounts to appear in reports. And if you click the Format button located directly below Default formatting for reports, you can alter their appearance, for example, by changing fonts and indicating what information should appear in the header and footer.

For other preferences, you may need our help. Do you understand the difference between running Summary Reports as Accrual or Cash? And have you worked with a Statement of Cash Flows before so you can assign accounts to various sections? This is a report we should be generating and analyzing periodically for you, so don’t worry about dealing with it on your own.

Note: QuickBooks was designed for small businesspeople, not accountants. But if you really want to get the most out of it to make the best business decisions possible, let us help you with those concepts you don’t understand.

Navigating the Report Center

The QuickBooks Reports menu

The QuickBooks Reports menu

Unless you’re working with a very old version of QuickBooks, you have two options for accessing the software’s reporting functions. You can simply click on Reports in the left vertical pane to open the Report Center. Or you can get there by opening the Reports menu (which includes links to other areas, like the Transaction Journal, in addition to lists of QuickBooks’ reports divided by category).

Next month, we’ll look at some reports and their customization options in QuickBooks. In the meantime, as always, we’re available to work with you on enhancing your knowledge of QuickBooks reports and their setup.