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.

Accounts Receivable and Open Invoices Examples

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 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

 Company Preferences Screen Shot

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

 Reports Include Company, Financial, Customers, Receivables, Sales, etc.

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.

For more QuickBooks tips, tricks and info on training from our team of Certified QuickBooks ProAdvisors® subscribe to The QBC.

QuickBooks and QuickBooks ProAdvisor are registered trademarks and/or registered service marks of Intuit Inc.

What Are Payroll Items in QuickBooks?

If you plan to process your own payroll using QuickBooks, you need to understand how payroll items work.

Considering processing your own payroll in QuickBooks? Whether you’re moving from a payroll service or getting ready to pay your first employee, you’re taking on a complex set of tasks that requires a great deal of setup and absolute precision. But the reward is complete control over your compensation records and transactions, and constant access to your payroll data.

If you have no experience dealing with paychecks, deductions, and payroll taxes, we strongly recommend that you let us help you get started. QuickBooks simplifies the actual mechanics of setting up and running payroll, but there’s still a lot you need to know.

It goes without saying that accuracy is critical here. You’re responsible for your employees’ livelihoods and for maintaining any benefits they’ll receive. Federal, state, and local taxing agencies will count on you to submit the proper payroll taxes and filings on time; failure to do so can result in stiff penalties and worse.

A Look Around Payroll Items

That said, we’ll give you a brief preview of how QuickBooks Payroll Items work. You must first make sure that payroll is turned on. Open the Edit menu and click Preferences, then click Payroll & Employees | Company Preferences.

Company Preferences

The Company Preferences screen in Payroll & Employees Preferences

Under QUICKBOOKS PAYROLL FEATURES, make sure the button in front of Full Payroll is filled in by clicking on it. If you’re interested in exploring Intuit’s online payroll service, we can tell you about that, as well as advise you on the other options displayed here.

This element of your accounting is complicated enough that QuickBooks has a separate setup tool to guide you through the myriad details you’ll need to provide. You find this tool by going to Employees | Payroll Setup. This is a multi-screen, wizard-like tool that walks you through the process of providing information about employees, compensation, benefits and other additions/deductions, and taxes. Each page poses questions, and you provide answers by entering data and selecting options from drop-down lists. In doing so, you’re creating Payroll Items.

This is a time- and labor-intensive process, one that will send you scrambling for all of the minutiae that make up your payroll system. Once you have your payroll framework established, though, as we said earlier, everything will be in one place and easily accessible.

A Useful List

The information you entered in Payroll Setup is likely to change and need modification. Maybe you forgot to account for something while you were working in the wizard, or perhaps you just want to look up a bit of payroll data. To do any of these, open the Lists menu and click on Payroll Item List.

 New Payroll Item

You can access this menu from the bottom of the Payroll Item List screen.

The window that opens contains a list of the Payroll Items you created. It looks like a checkbook register, with one line devoted to each item. You’ll be able to view, for example, its Type, any Limit imposed, the Payable To name, and Tax Tracking designations. At the bottom of this list, you’ll see three drop-down menus: Payroll Item, Activities, and Reports. When you click on the down arrow next to Payroll Item, you’ll see the menu displayed in the above image.

Warning: There are many options in this menu for altering Payroll Item definitions. QuickBooks allows you to do this, but we would caution you here. If it involves an action that we have not gone over with you, please ask us about it.

This is fairly self-explanatory. To Edit or Delete a Payroll Item or make it Inactive, highlight it in the list and click on the correct option. You can also Customize Columns in the table and perform other related tasks. When you click on New Item and select EZ Setup on the next page, this window opens:

Payroll item type

You can add Payroll Items by working your way through this wizard-like progression of screens.

QuickBooks will help you here by asking questions and building a Payroll Item based on your responses.

There’s much more to know about working with Payroll Items and assigning them to employees. We’re ready to help introduce you to payroll processing in QuickBooks – once you’re ready to take it on.

For more QuickBooks tips, tricks and info on training from our team of Certified QuickBooks ProAdvisors® subscribe to The QBC.

QuickBooks and QuickBooks ProAdvisor are registered trademarks and/or registered service marks of Intuit Inc.

Setting Up User Access in QuickBooks

The QBC: QuickBooks® Client Newsletter

Setting Up User Access in QuickBooks

Will multiple employees be working with your QuickBooks company file? You’ll need to define their permission levels.

If you ever did your bookkeeping manually, you probably didn’t allow every employee to see every sales form and account register and payroll stub. Most likely, you established a system that allowed staff to work only with information that related to their jobs. Even so, there may have been times when, for example, someone pulled the wrong file folder or was sent a report that he or she shouldn’t have seen.

QuickBooks helps prevent this by setting virtual boundaries. You can specify which features of the software can be accessed by employees who work with your accounting data. Each employee receives a unique user name and password that unlocks only the areas he or she should be visiting.

QBC 0816 image 1_zpsai8phrevTo help minimize errors, maintain data integrity, and preserve confidentiality, QuickBooks lets you restrict users to designated areas in the software. (more…)

Make QuickBooks Your Own: Specify Your Preferences

The QBC: QuickBooks® Client Newsletter

Make QuickBooks Your Own: Specify Your Preferences

Your business is unique. Make sure that QuickBooks knows how you operate.

QuickBooks was designed to be used by millions of businesses. In fact, it’s possible to install it, answer a few questions about your company, and start working right away.

However, we strongly suggest you take the time to specify your Preferences. QuickBooks devotes a whole screen to this customization process. You can find it by opening the Edit menu and selecting Preferences.

(more…)

Using Sales Receipts: When? How?

The QBC: QuickBooks® Client Newsletter

Using Sales Receipts: When? How?

Some types of businesses always use sales receipts. Some use them occasionally. Here’s what you need to know about them.

How do you let your customers know how much they owe you, and for what products or services? In these days of ecommerce and merchant accounts, your customers may provide a credit card number over the phone or on a website. Or perhaps you send invoices after a sale and receive checks or account numbers in the mail. QuickBooks can help you both create the invoices and record the payments.

There’s another type of sales document that you can use in certain situations: the sales receipt. You’d probably be most likely to use one of these when customers pay you in full for products or services at the same time they receive them.  (more…)

Are You Applying Finance Charges? Should You Be?

The QBC: QuickBooks® Client Newsletter

Are You Applying Finance Charges? Should You Be?

Assessing finance charges is a complicated process. But if you have a lot of late payments coming in, you may want to consider it.

There are many reasons why your customers send in payments past their due dates. Maybe they missed or misplaced your invoice, or they’re disputing the charges. They might not be very conscientious about bill-paying. Or they simply don’t have the money.

Sometimes they contact you about their oversight, but more often, you just see the overdue days pile up in your reports.

You could use stronger language in your customer messages. Send statements. Make phone calls if the delinquency goes on too long. Or you could start assessing finance charges to invoices that go unpaid past the due date. QuickBooks provides tools to accommodate this, but you’ll want to make absolutely sure you’re using them correctly – or you’ll risk angering customers and creating problems with your accounts receivable. (more…)

Preventing Data Theft in QuickBooks

The QBC: QuickBooks® Client Newsletter

Preventing Data Theft in QuickBooks

Be proactive about the security of your QuickBooks company file, and you’ll be less likely to encounter data theft.

Thanks to the internet, privacy has been on the wane over the last few years. We assume that our addresses and phone numbers are public information, thanks to sites like Switchboard and 411.com. We hope that our dates of birth are private (though the number of birthday wishes on Facebook makes that doubtful), and we assume that our Social Security numbers are hard to get.

Your customers trust you enough to provide you with additional private information, like credit card numbers. And you’ve seen what an uproar occurs when major corporate entities like Target and Home Depot get hacked.

Your small business may not have hundreds of thousands of customer information files, but you can still be targeted by external hackers and even your own employees. Are you taking measures to ensure the security of that data stored on your hard drive and/or in the cloud? (more…)

Page 1 of 3123