Getting to Know QuickBooks Online Reports

They’re one of the rewards you get for your conscientious accounting work: reports. Are you using them to make better business decisions?

What do you see when you log on to QuickBooks Online? Your most important business numbers represented by real-time charts. Profit and loss. Income and expenses. Sales. And all of your account balances.

This is a great way to start your workday. You know where you stand financially, and you know what areas of your company file need attention, fast.

But QuickBooks Online’s home page only tells part of the story. You also need more in-depth, customizable reports. In the short term, reports help you further determine any necessary accounting work. Long-term, they’ll provide insight to help you make smarter decisions as you plan for your company’s future.

Critical Overviews

Creating reports in QuickBooks Online is easy. Customizing them is a bit harder. And analyzing them, depending on their complexity, can be more of a challenge.

We’ll start with some of the simplest, most important ones: Accounts Receivable. Where do you stand with customer payments? Who isn’t paying on time? How much is outstanding? To find them, click Reports in the toolbar pane. Click All Reports (over to the right, near the top), and then Manage Accounts Receivable. The list of related reports will open.

QuickBooks Online displays descriptions of each A/R report and links to the Run and Customize functions in its directory.

Click the Customize button under Open Invoices. The customization options will appear on the pane to the right of the screen. You can modify:

• The Report period, Number format, and the appearance of Negative numbers
• Columns (Transaction Type, Due Date, Open Balance, etc.)
• Aging method (Current or Report Date)
• Filter (Customer, Territory, Sales rep, etc.)
• Header/footer (Show logo, Report title, Date prepared, Alignment, etc.)

QuickBooks Online comes with commonly used options already selected. Changing them helps you zero in on the precise cross-section of data you want to see.

This is a partial list of the Column options in QuickBooks Online. You can also customize in multiple other ways.

When you’ve finished making changes, click Run report to see it displayed with your own data.

If you’d like to save that report (including the modifications you just made), click Save customization in the upper right corner of the screen. In the window that opens, create a new name for the report that you’ll recognize, and enter it in the Custom report name field.

Want to build a group of related custom reports? Click Add this report to a group and type its name into the New group name field. Click Add. That report will now appear in the list of reports you’ve created when you click the down arrow in the field below Add this report to a group.

Would you like to share the custom report with other QuickBooks Online users? Click the down arrow in the field under Share with, and select All or None. When you’re done here, click Save. You can click the icons in the upper right to email the report, print it, or export it to Excel or PDF format.

Reports in other categories—like Review Sales, Business Overview, and Review Expenses and Purchases—work similarly.

Note: There’s one category named Accountant Reports. If you’re very familiar with double-entry accounting, you might attempt to run and analyze these yourself. Most likely, you’ll need some help with these critical financial reports that should be created periodically. We’d be happy to assist with this.

The Reports page toolbar

Saving Time

You can always go to the All Reports screen and drill down to the report you want to see. QuickBooks Online provides a better, faster way to access many of them. The toolbar pictured above appears when you’re browsing through lists of reports. Click Recommended to see what QuickBooks Online deems the most important data for you to see regularly.

Once you’ve started working with reports, the ones you access most often will appear when you click Frequently Run. Those reports that you modified and saved will be listed under My Custom Reports. Management Reports are geared toward company managers, of course.

We encourage you to familiarize yourself with QuickBooks Online’s reports and modification options. And as we said, we’re on hand to run and analyze the site’s more complex report options on a regular basis, or when you have a specific need, like when you apply for financing. Together, we can get the information you need to complete your daily work and do more long-term planning.

Receiving Customer Payments: Your Options

It’s one of your more pleasant tasks as a QuickBooks user: receiving payments from customers. Here’s how it works.

QuickBooks was designed to make your daily accounting tasks easier, faster, and more accurate. If you’ve been using the software for a while, you’ve probably found that to be true. Some chores, of course, aren’t so enjoyable. Like paying bills. Reconciling your bank account. Or anything else that has the potential to reduce the balance in your checking accounts.

The process of receiving customer payments is one of your more enjoyable responsibilities. You supplied a product or service that someone liked and purchased, and you’re getting the money due you.

Depending on the situation, you’ll use one of multiple methods to record customer payments. Here’s a look at some of your options.

A Familiar Screen

If you’re like many businesses, you send invoices to customers to let them know what they owe and when their payment is due. So one of the most commonly used ways to record payments is by using the Receive Payments window. To open it, click the Receive Payments icon on the home page or click Customers | Receive Payments.

You’ll use QuickBooks’ Receive Payments screen when you record a payment made in response to an invoice.

The first thing you’ll do, of course, is choose the correct customer by clicking the down arrow in the field to the right of RECEIVED FROM. The outstanding balance from that customer will appear in the upper right corner, and invoice information will be displayed in the table below. Enter the PAYMENT AMOUNT and make sure the DATE is correct. (The next field, REFERENCE #, changes to CHECK # only if the CHECK option is selected.)

Next, you’ll need to ensure that the payment is applied to the right invoices. If it covers the whole amount due, there will be a checkmark in every row in the first column of the table. If not, QuickBooks will use the money received to pay off the oldest invoices first. To change this, click Un-Apply Payment in the icon bar and click in front of the correct rows to create checkmarks.

Several Options

You’ll then want to tell QuickBooks what payment method the customer is using. Four options are displayed. The possibilities that are visible here are:

• CASH
• CHECK
• CREDIT DEBIT (A specific card type may be shown here if you’ve indicated the customer’s preferred payment method in his or her record.)
• e-CHECK

If the desired payment method isn’t included in those four, click the down arrow under MORE. If it’s still not there, click Add New Payment Method. This window will open:

The New Payment Method window

Click OK. When you choose your new payment method from the list, a window opens containing fields for the card number and expiration date. Click Done after you’ve entered it, and you’ll be returned to the Receive Payments screen. If you’re satisfied with your work there, click Save & Close or Save & New.

Haven’t gotten set up to accept credit and debit cards yet? We can get you going with a merchant account to make this possible. You’re likely to find that some customers pay faster with this option. Your customers will be able to click a link in an emailed invoice and make their payments.

Instant Sales

Depending on the type of business you have and its physical location, there may be times when customers will come in and buy something on the spot. You’ll need to give them a Sales Receipt. Click Create Sales Receipts on the home page or open the Customers menu and select Enter Sales Receipts to open this window:

The Enter Sales Receipts window

You’ll complete this form much like you entered data in the fields of the Receive Payments window. As you can see, you can print the mail for the customer and/or email it.

After all the hard work you’ve done to make your sales, the last thing you want to do is record a payment incorrectly so it isn’t processed and you don’t get paid. Though QuickBooks makes the mechanics of receiving payments simple enough, you still should understand the entire process involved in getting income into the correct accounts. We’re available to help with this and any other areas of QuickBooks.

Need to Set Up Users in QuickBooks Online?

Your employees probably don’t need access to every corner of QuickBooks Online. Here’s how to set limits.

One of the best attributes of QuickBooks Online is that multiple users can access it without having software installed on their PCs. No more paying up front for a boxed copy that you’ll store on your hard drive. You just pay a monthly subscription fee.

Unless you assign specific access rights to your users, though, they’ll be able to see and do everything that you see and do on the site. You undoubtedly trust your employees or you wouldn’t have hired them, but it’s just good business practice to restrict individuals to their specific work areas. You probably did the same thing if you ever ran a manual accounting system.

QuickBooks Online makes this easy. Once you’ve set up individuals for a specific set of screen permissions, that’s all they’ll see when they log in with their user names and passwords. Here’s how it works.

Several Levels

Click the gear icon in the upper right of the QuickBooks Online screen, then select Manage Users under Your Company, then click New. This mini-interview will open.

QuickBooks Online’s mini-interview will walk you through the steps required to assign access rights to employees.

As you can see, four access levels are supported. You’ll probably select Regular or custom user most often because you can drill down and set permissions at the screen level. The Company administrator is you, of course, unless you’ve assigned this role to someone else. The user at this level has access to everything.

You can also let someone see Reports only, with the exception of payroll reports and those that contain contact information about customers, vendors, and employees. If you have employees who submit time sheets but don’t otherwise work in QuickBooks Online, you can let them in to do Time Tracking only.

Tip: There’s a fifth option here. You can grant us access to your QuickBooks Online company data, making it easier for us to monitor and troubleshoot your accounting information. Let us know if you want to take advantage of this.

Paring Down Access

Click the button in front of Regular or custom user if it’s not already highlighted, and then click Next. This third screen in the mini-interview deals with Customers and Sales and Vendors and Purchases Access Rights. Click All or None if appropriate.

This screen in the mini-interview helps you restrict user access in Sales and Purchase areas.

If you’re allowing Limited access in these two areas, be sure to read the fine print explaining what is and isn’t allowed. When you’re satisfied with your selection, click Next. On the next screen, you’ll set administrative rights for that user by indicating whether he or she can manage other users’ access rights and work with your subscription status and other company information.

You’ll supply the individual’s email address and name on the following screen. This will be used to send an email inviting the user to sign in using an existing Intuit Business Services user name or one he or she creates. Click through the next screen and click Finish when you’re done. The mini-interview will close, and you’ll be back at the Manage Users page.

Your User Overview

The Manage Users page displays a list of all users who have been invited or are active.

The Manage Users screen

The table here lists all users’ names, email addresses, access rights, billable standing, and status. If you haven’t received a response to an invitation (Invited), you can click the Resend button to issue another email. When he or she responds, Invited changes to Active. Click on a row to highlight an individual, and you can Edit or Delete him or her, and see an audit log of Activity.

You or your appointed Master Administrator should set up access rights before any new employee is admitted to QuickBooks Online. Let us know if you’re having trouble with this element of the site, and if you’d like us to join your list of active users. It’s a lot easier for you and us if we can get in there and see what problems you’re having -- and resolve them.

Are You Memorizing Transactions? Should You Be?

You know that QuickBooks saves a lot of time. But have you explored how it does so by memorizing transactions?

Your accounting work involves a lot of repetition. You send invoices. Pay bills. Create purchase orders. Generate payroll checks and submit payroll taxes.

Some of the time, you only fill out those transaction forms once. You might be doing a one-time purchase, like paying for some new office furniture. Other times, though, you’re paying or charging the same companies or individuals on a regular basis.

QuickBooks contains a shortcut to those recurring tasks, called Memorized Transactions. You can save the details that remain the same every time, and use that template every time the bill or invoice is due, which can save a lot of time and improve accuracy. Here’s how it works.

Making Copies

To memorize a transaction, you first need to create a model for it. Let’s say you have a monthly bill for $450 that’s paid to Bruce’s Office Machines. You’d click Enter Bills on the home page or open the Vendors menu and select Enter Bills. Fill in the blanks and select from drop-down lists to create the bill. Then click Memorize in the horizontal toolbar at the top of the form.  This window will open.

Before you can Memorize a transaction, you first have to create a model (template) for it.

The vendor’s name will already be filled in on the Memorize Transaction screen. Look directly below that. There are three ways that QuickBooks can handle these Memorized Transactions when one of their due dates is approaching:

• Add to my Reminders List. If you click the button in front of this option, the current transaction will appear on your Reminders List every time it’s due. You might request this for transactions that will change some every time they’re processed, like a utility bill that’s always expected on the same day, but which has a different amount every month.
• Do Not Remind Me. Obviously, QuickBooks will not post a reminder if you click this button. This is best used for transactions that don’t recur on a regular basis. Maybe you have a snow-shoveling service that you pay only when there’s a storm. So the date is always different, but everything else is the same.
• Automate Transaction Entry. Be very careful with this one. It’s reserved for transactions that are identical except for the issue date. They don’t need your approval – they’re just created and dispatched.

Click the down arrow in the field to the right of How Often and select the correct interval. Then click the calendar icon to pick a date for the next occurrence. If you have selected Automate Transaction Entry, the grayed-out lines below Next Date not shown here) contain fields for Number Remaining and Days in Advance to Enter.

How Does QuickBooks Know?

Obviously, you’ll want advance warning of transactions that will require processing. QuickBooks lets you specify how many days’ notice you want for each type. Open the Edit menu and select Preferences. Click Reminders in the left vertical pane, then the Company Preferences tab. You can tell QuickBooks whether you want to see a summary in each category or a list, or no Reminder. Then you can enter the number of days’ warning you want.

QuickBooks lets you specify the content and timing of your Reminders.

Working with Memorized Transactions

Once you’ve created some Memorized Transactions, you will undoubtedly need to review them at some point. QuickBooks makes this happen. Open the Lists menu and select Memorized Transaction List to see all the templates for recurring bills, invoices, etc., that you’ve defined. Right-click on one you want to work with, and this menu appears:

The Memorized Transaction List with the right-click window open

You have several options here. If your list is so long that it fills multiple screens, you can Find the transaction you’re looking for. If you’ve created multiple related transactions, you can save them as a New Group. You can also Edit, Delete, and Enter Memorized Transactions.

Anytime you’re letting QuickBooks do something on its own, it’s critical that you thoroughly understand the mechanics of setting the process up. We’d be happy to go over the whole topic of Memorized Transactions with you, or any other aspect of QuickBooks operation