QuickBooks Tip: Creating Customer Statements in QuickBooks

Let’s say you have a regular customer who used to pay on time, but he’s been hit-and-miss lately. How do you get him caught up?

Or, one of your customers thinks she’s paid you more than she owes. How do you straighten out this account?

Both of these situations have a similar solution. QuickBooks’ statements provide an overview of every transaction that has occurred between you and individual customers during a specified period of time. They’re easy to create, easy to understand, and can be effective at resolving payment disputes.

A Simple Process
Here’s how they work. Click Statements on the home page, or open the Customers menu and select Create Statements. A window like this will open:

QuickBooks provides multiple options on this screen so you create the statement(s) you need.

First, make sure the Statement Date is correct, so your statement captures the precise set of transactions you want. Next, you have to tell QuickBooks what that set is. Should the statement(s) include transactions only within a specific date range? If so, click the button in front of Statement Period From, and enter that period’s beginning and ending dates by clicking on the calendar graphic. If you’d rather, you can include all open transactions by clicking on the button in front of that option. As you can see in the screenshot above, you can choose to Include only transactions over a specified number of days past due date.

Choosing Customers
Now you have to tell QuickBooks which customers you want to include in this statement run. Your options here are:

  • All Customers. 
  • Multiple Customers. When you click on this choice, QuickBooks displays a Choose button. Click on it, and your customer list opens in a new window. Click on your selections there to create a check mark. Click OK to return to the previous window.
  • One Customer. QuickBooks displays a drop-down menu. Click the arrow on the right side of the box, and choose the correct one from the list that opens.
  • Customers of Type. Again, a drop-down list appears, but this one contains a list of the Customer Types you created to filter your customer list, like Commercial and Residential. You would have assigned one of these to customers when you were entering data in their QuickBooks records (click the Additional Info tab in a record to view).
  • Preferred Send Method. E-mail or Mail?

Miscellaneous Options
At the top of the right column, you can select a different Template if you’d like, or Customize an existing one. Not familiar with the options you have to change the layout and content of forms in QuickBooks? We can introduce you to the possibilities.

Below that, you can opt to Create One Statement either Per Customer or Per Job. The rest of the choices here are pretty self-explanatory – except for Assess Finance Charges. If you’ve never done this, we strongly recommend that you let us work with you on this complex process.

When you’re satisfied with the options you’ve selected in this window, click the Preview button in the lower left corner of the window (not pictured here). QuickBooks will prepare all the statements in the background, then display the first one. You can click Next to view them one by one. At the bottom of each, you’ll see a summary of how much is due in each aging period, like this:

It’s easy to see how much each customer is past due within each aging period. This summary appears at the bottom of statements.
After you’ve checked all the statements, click the Print or E-mail button at the bottom of the window.

Other Avenues
Your company’s cash flow depends on the timely payment of invoices. Sending statements is only one way to encourage your customers to catch up on their past due accounts. There are many others, like opening a merchant account so customers can pay you online with a bank card or electronic check. If poor cash flow is threatening the health of your business, give us a call. We can work together to identify the trouble spots and get you on the road to recovery.

QuickBooks Tip – Using QuickBooks’ Income Tracker

You can get an enormous amount of useful information from QuickBooks’ reports – especially if you customize them to isolate the precise data you want. Reports included with the software range from the very simple, like Open Invoices, to output that’s exceptionally complex, like Trial Balance and Profit & Loss.

Warning: Standard financial reports like Trial Balance are easy to run in QuickBooks, but very difficult to understand and analyze. You should, though, be aware of what they’re telling you at least once a quarter – even once a month in some cases. We can help with this.

Sometimes, especially first thing in the morning as you’re planning your day, you just want to cut to the chase and get a quick overview of your company’s finances. That’s where QuickBooks’ Income Tracker comes in. It not only provides that overview, but it also contains links to related screens where you can do the work that’s needed there.

A Simple Layout
Click the Income Tracker link in the toolbar to open the tool’s main screen. If you’ve been using QuickBooks for a while, you’ll see a framework like this with your own company’s data already filled in.

QuickBooks Income Tracker displays both summaries of income types and the specific transactions that contribute to those totals.

Look first at the top of the screen. You’ll see six horizontal bars, each of which represents groups of transactions that either require immediate attention or will at some point in the future. Besides identifying the type of transaction, each block displays the number of transactions involved and their total dollar amount. They are:
  • Estimates – estimates that have been created and shared with customers, but haven’t yet turned into sales
  • Sales Orders – orders that have been entered but have been neither fulfilled nor converted to invoices
  • Time & Expenses – hours that have been recorded for customers but not yet invoiced
  • Open Invoices – invoices that have been created and sent to customers, but no payments have been received
  • Overdue – open invoices that have passed their due dates
  • Paid Last 30 Days – payments that have been received within the last 30 days

Modifying the View
Click on any of the colored bars, and the list of transactions below will change to include only those that meet that particular criteria. To get back to the default display of all transactions, click the Clear/Show All link in the upper right of the screen.

QuickBooks also lets you display a user-defined subset of the transactions. Click on one of the four drop-down lists above the transaction grid itself to change the view of:

  • Customer: Job – choose just one from the complete list
  • TypeSales Orders, Invoices, Received Payments, etc.
  • StatusAll, Open, Overdue, or Paid
  • Date – multiple ranges available

You can also modify the toolbar if your company doesn’t use all the sales forms/transaction types supported. To do so, click the gear icon in the far upper right of the screen and click in the boxes in front of Estimates, Sales Orders and/or Time & Expenses to remove them.

Taking Action
QuickBooks’ Income Tracker provides a great way to get a quick look at your finances. But it also serves as a launching pad for related activities.

Click the down arrow in the Action column to take care of tasks related to that transaction.

Highlight a transaction by clicking in the row, then click the down arrow at the end of the row in the Action column. The options that appear there depend on the type of transaction you selected. Choose a Sales Order, for example, and you can Convert to Invoice, Print Row, or Email Row. Options for an invoice are Receive Payment, Print Row, or Email Row.

As we said before, QuickBooks offers numerous reports that can give you more insight about your accounts receivable. If you understand the software’s robust customization tools, you can create reports about your income that will answer questions you may have. If you don’t, let us know. We’ll be happy to work with you on pulling together just the data you need.

QuickBooks Tips: Best Practices for QuickBooks Online

Even if you’ve been using QuickBooks Online for a long time, it’s good to step back and evaluate your actions.

“Best practices” aren’t enforceable rules. They’re simply guidelines businesses commonly follow in one area or another. If you’re in retail, for example, one best practice might be to always ask customers checking out if they found everything they were looking for. This serves two purposes: It conveys a feeling of concern for the customer’s shopping experience, and it may also lead to increased sales.

QuickBooks Online has many best practices, some of which may serve multiple purposes, including these:

  • They keep your company data safe and clean.
  • They provide insight on your financial status.
  • They save time.
  • They can lead you to better relationships with customers and vendors.

Are any or all the following common practices for your business?

Reconcile accounts regularly.
One of QuickBooks Online’s most useful features is its ability to connect to your financial institution’s websites and download cleared transactions. QuickBooks Online also offers tools to help you keep your accounts reconciled online, like you used to do every month when your paper statement came. Reconciling accounts can help you uncover errors. It gives you a truer picture of your cash flow, and it improves the accuracy and timeliness of some reports.

QuickBooks Best practices — Start reconciling

It’s not a particularly pleasant process, but you should be reconciling your accounts regularly in QuickBooks Online. We can help.

Clean up your lists.
Some lists in QuickBooks Online aren’t overly lengthy. You don’t have to worry about, for example, Payment Methods, Terms, or Classes. Your lists of customers and vendors, products and services, on the other hand, can grow unwieldy over the years. This means it can take more time than it should to scroll through lists when you’re using those entities in transactions. It also puts unnecessary stress on your company file. If you can’t delete any, at least make them inactive.

Never leave QuickBooks Online open when you leave your work area.
This goes for everyone, even people who work alone and don’t access their company files away from their work areas. The obvious reason is to keep someone else from getting in and authorizing payments, for example, or otherwise compromising your financial information. It also protects the integrity of your data file in case your internet connection suffers some kind of outage.

Keep track of 1099 vendors.
Whether your company uses 10 vendors or a hundred or more, you may have to supply at least some of them with an IRS Form 1099 at about the same time you’re preparing W-2s for employees. Your 1099-related tasks will be much easier if those individuals and/or companies are earmarked. If you think vendors might need 1099s when you create their records in QuickBooks Online, click in the box to the left of Track payments for 1099 in the lower right corner. Not sure? Ask us.

Classify everything with care.
Every time you have to create a record or transaction where categories are involved (i.e., Classes, Customers and Vendors, Territories), check and double-check that you’ve assigned them the correct classification. Errors here can result not only in problems with daily workflow, but your reports will not be accurate. A related best practice: Create a meaningful group of Classes, and use them faithfully. They’ll help you make better business decisions.

QuickBooks Best practices — Class

To create your list of Classes, click the gear icon in the upper right and select All Lists | Classes | New.

View reports on a regular basis.
There are some advanced financial reports in QuickBooks Online that we should be creating for you on a regular basis, either monthly or quarterly. These include Profit and Loss, Balance Sheet, and Statement of Cash Flows. The mechanics of creating them aren’t difficult, but analyzing them is. You should be running reports on your own at frequencies that you think would be helpful, like A/R Aging Detail, Unpaid Bills, and Sales by Class Detail.

If you’ve been using QuickBooks Online for a while, you could probably come up with your own list of best practices. If you’re new to the site, consider scheduling some time with us to go over more of them. Develop good habits from the start, and there won’t be nearly as much need for troubleshooting down the road.

QuickBooks Tip: Receiving Payments in QuickBooks Online

It’s perhaps one of your favorite activities in QuickBooks Online: recording money that comes in. Are you doing it right?

Your days of matching paper checks to paper invoices are over. QuickBooks Online excels at keeping your accounts receivable organized. No more digging through piles of forms and hand-stamping PAID on your customer bills and statements. No more trying to write small enough in your register so you can identify the origins of deposits.

You do, though, need to know how to get to payment screens—there are multiple ways—and which form to complete for each remittance. Here are the three types you’ll deal with most often.

Receive payment on an invoice
When payment comes in on an invoice, you can get to the right screens in any of several ways.

Click the + (plus) sign in the upper right corner. Under Customers, select Receive Payment. In the upper left of the window that opens, select the correct customer by clicking the down arrow at the end of that field to open the list.

Make sure the Payment date is correct. Open the Payment method list and select from Cash, Check, Credit card, etc. If there’s a Reference no., like a check number, enter it in that field. The default value for Deposit to is Undeposited Funds. Leave that active, and enter the Amount received in that field.

When you select a customer’s name in the Receive Payment window, a list of unpaid invoices will appear at the bottom.

If the customer has multiple outstanding invoices, QuickBooks Online will put a check mark in front of the oldest one(s). You can change this if you need to by clicking to uncheck the box and clicking in the box in front of the correct one.

Tip: If you want to isolate invoices from a specific date range, click the arrow next to Filter.

When you’ve specified where the payment(s) will go, add a memo and/or attachment if you’d like and select either Save and close or Save and new in the lower right corner.

You can also record payments on invoices from other screens in QuickBooks Online. For example, click Transactions in the left vertical navigation bar and select Sales to open the list of sales transactions. At the far right end of every line that contains an unpaid invoice, you’ll see a link to Receive payment. Click it, and the payment screen will open with the name and amount already filled in. Another option: With an invoice open, click Receive payment in the upper right corner.

Receive payment at the time of the sale
When a customer pays you immediately for products and/or services, there’s no need to create an invoice. You’d instead use a sales receipt. Click the + sign in the upper right and select Sales Receipt under Customers.

Tip: If you click the small diagonal arrow when it appears next to an option, the site will open the screen in a separate window.

Fill in the fields at the top like you did on the Receive Payments screen.

Use a sales receipt in QuickBooks Online if you receive payment at the same time you provide a product or service.

Complete the lower half of the sales receipt by selecting the products and/or services sold from the drop-down lists. Then click the links at the bottom of the screen to print or email the receipt.

Receive a down payment or retainer
If a customer gives you money as part of a down payment or a retainer for work to be done or products to be delivered, you can enter it on the Receive Payment screen without connecting it to an invoice. If you’re prepared to create a record of the specific charges, though, you can use an invoice form and categorize the payment as a deposit.

There are other ways to receive payments from customers in QuickBooks Online, like creating credit memos or using a mobile payment device. However you do it, your bookkeeping needs to be precise, or you’ll run into problems down the road. If this is a topic that creates some uncertainty, we can go over the whole concept with you and outline your options. You work too hard for your money to risk applying it incorrectly –or worse, losing it to an accounting error.

QuickBooks Tip: How to Keep Your QuickBooks Data Safe

You work hard to make sure your QuickBooks data is accurate. Make sure it’s safe, too.

Your QuickBooks company file contains some of the most sensitive information on your computer. You may have customers’ credit card numbers and employees’ Social Security numbers. An intruder who captured all that data could create tremendous problems for you and a lot of other people.

That’s probably the worst-case scenario. But other situations could also spell disaster for your business, which involves losing your company data through fraud, hacking, or simple technical failures.

We can’t overstate the vital importance of protecting your QuickBooks company file, especially your customer and payroll information. Whether someone steals it or it’s inaccessible for another reason, it’s gone. Keeping your business going after such a loss would be very difficult – maybe even impossible. Here’s what we suggest to prevent that.

Internal Safeguards
No business owner wants to believe that his or her employees could use their QuickBooks access to commit fraud. But it happens. Your company file contains credit card and checking account data that could be used for nefarious purposes. As we discussed last spring, you can restrict user access to specific areas and actions of QuickBooks.

You can limit your employees who have QuickBooks access to certain areas and activities.

To get started, open the Company menu and select Set Up Users and Passwords | Set Up Users. The User List window opens. It should have at least one entry there, for you (Admin). Click Add User and enter the employee’s name and password in the next window that opens, then click Next.

Tip: Your QuickBooks license limits you to a specified number of users. If you’re not sure how many you’re allowed, click F2 to open the Product Information page. The number of user licenses you’ve paid for appears in the upper left.

On the next page of this wizard, click the button in front of Selected Areas of QuickBooks. The following screens will let you define that employee’s access permissions in areas like Sales and Accounts Receivable, Inventory, and Payroll and Employees. When you’ve clicked through every screen and reviewed the summary displayed, click Finish. Your user will now be able to sign in and access the areas you specified.

You can—and should—take numerous other steps to keep your QuickBooks data safe. If your company is big enough to have a dedicated IT expert, he or she will handle most of this. But there’s a lot you can do on your own to prevent data loss and theft.

Keep Your Operating System and Applications Updated

Don’t ignore this dialog box.

Software companies’ occasional updates offer more than just adding new features and fixing bugs. They sometimes refresh your software to ensure greater security based on new threats. Don’t forget about those all-important antivirus and anti-malware applications, as well as QuickBooks itself.

Keep Your Networks Safe
Just as a cold virus spreads around your office, so, too, can unwanted intrusions like computer viruses. Don’t allow an electronic epidemic to get started; take steps ahead of time to prevent it:

  • Discourage employees from excessive web browsing. This can be a hard rule to enforce, as some employees probably need internet access for research, timecard entry, and other work-related tasks. Create a firm policy legislating what workers can and can’t do on company-issued equipment (including tablets and smartphones) or any personal devices that use your wireless network.
  • Ask employees to refrain from using public networks on work equipment. Enforce the rules vigorously, and make compliance an element of performance evaluations.
  • Minimize app installations on business smartphones. Employees should ask for approval. Viruses and malware get in that way, as well as through some websites and email attachments.
  • Use monitoring software. If you can’t afford to pay for “managed IT” (a la carte, third-party IT services), install an application that alerts you to problems.

Use Common Sense
You can fight data loss and theft by being cautious. Be diligent about backups, and if you create them on a local, portable device, don’t leave them in the office. Cloud-based solutions are better. Shred papers that have sensitive information on them. Log out of QuickBooks when you’re not using it or when you leave your office. Be aware of who may be around you, looking over your shoulder. We take data security very seriously in our own office, and we strongly encourage you to do the same. Contact us if you’re at all concerned with your own data safety, and we’ll come up with a plan together.

QuickBooks TIP: Receiving Customer Payments

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.

QuickBooks Tip customer payment
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:

QuickBooks Tip payment method
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:

QuickBooks Tip Sales receipt
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.

QuickBooks Tip: 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 operations.

Setting Up Users in QuickBooks

Controlling access to your QuickBooks company file is easy when you’re a one-person accounting department. You simply use one password to protect your data.

But when you add new employees to the mix, do you want them to have access to absolutely everything in QuickBooks? Probably not. You have confidence in your employees or you wouldn’t have hired them. But this isn’t solely a matter of trust. It’s just good business practice to restrict individuals to specific areas and responsibilities, no matter what the application.

That’s why QuickBooks has built-in tools to help you limit activity. Here’s how it works.

Identifying Users
To get started, open the Company menu and scroll down the list to highlight Set Up User Names and Passwords. On the slide-out menu, select Set Up Users. The User List window will open, and you should see your own entry as Admin. Click Add User.


To give an employee access to QuickBooks, enter a User Name for him or her here, then a password.

The Set up user password and access window will open. Fill in those fields and check the box in front of Add this user to my QuickBooks license. This will not be an option if you already have five users, since that’s the maximum number allowed by QuickBooks Pro and Premier. To buy more, open the Help menu and select Manage My License, then Buy Additional User License.

Tip: If you’re not sure how many user licenses you’ve purchased, hit your F2 key and look in the upper left corner. If you’ve maxed out and need more licenses, talk to us about upgrading to QuickBooks Enterprise Solutions.

Click Next. In the window that opens, you’ll define the access level for your new user. Your options here are:

  • All areas of QuickBooks,
  • Selected areas of QuickBooks, or,
  • External accountant (you can grant us access to all areas of the software except for those that contain sensitive customer data, like credit card numbers).

Click the button in front of the second option, then Next.


You can specify the access rights for individual employees in numerous areas.

The image above shows the first screen of 10 that display the levels of access available in many individual areas of QuickBooks. Be sure to read the whole page carefully before assigning rights. Here, for example, you’re not just allowing the employee to enter sales and A/R transactions. You’re also deciding whether to grant him or her permission to view the Customer Center and A/R reports. As you can see, your options are No Access, Full Access, and Selective Access (three levels there). Check the box below this list if you want the employee to be able to View complete customer credit card numbers.

When you’re finished there, click Next to specify your similar preferences for Purchases and Accounts Receivable, Checking and Credit Cards, Inventory, Time Tracking, and Payroll and Employees. The next two screens contain more complex concepts, but you’ll follow the same process to express your wishes. They are:

  • Sensitive Accounting Activities, like funds transfers, general journal entries, and online banking tasks
  • Sensitive Financial Reporting, which allows access to all QuickBooks reports. The option you choose here overrides all other reporting restrictions that you’ve specified for the employee.

Finally, you’ll tell QuickBooks whether this person can change or delete transactions in designated areas, and whether he or she can do so to transactions that were recorded before the closing date (if this applies). The last screen displays a summary of the access and activity rights you’ve given the employee. Check them carefully, and if they’re correct, click Finish.

Housekeeping Options


The User List window

QuickBooks then takes you back to the User List window, where you’ll see the employee’s name displayed. If you want to Add, Edit, Delete, or View a user, make sure the correct name is highlighted and click the button for the desired action.

If you’re just now looking to add your first employee to QuickBooks or if you’re starting to outgrow the five-user limit, give us a call. There are more issues to consider when you take on multi-user access. We’d be happy to discuss them with you.

Using Custom Fields and Classes in QuickBooks Online

QuickBooks Online’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

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.

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:

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.

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

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.