Tag Archives: beginner quickbooks

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

Social media posts

Concerned about the safety of your QuickBooks data? We can help you take security measures.

Lose your QuickBooks data, and you’ll face serious consequences. Make sure you keep backups in a safe place.

Do you issue smartphones to employees? Make sure they’re not used on public networks.

Even if you don’t have an IT specialist, you can protect your QuickBooks data from viruses and malware. Ask us how.

QuickBooks Advantage

QuickBooks Advantage
p //

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.

 

 

 

QuickBooks Advantage

QuickBooks Advantage
p //

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.

 photo QBO 0417 image 1_zpsei9u3lqq.jpg

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.

 photo QBO 0417 image 2_zps3hfipesf.jpg

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.

 photo QBO 0417 image 3_zpswddevkaz.jpg

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.

QuickBooks Advantage

QuickBooks Advantage
p //

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.

 photo QBC 1116 image 1_zpsijzg0oeq.jpg

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

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.

 photo QBC 1116 image 2_zpsliekdv23.jpg

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.

 photo QBC 1116 image 3_zpspsigzmnx.jpg

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 Any, Not Billable, Unbilled, 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.

 

QuickBooks Advantage

QuickBooks Advantage
p //

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.

 photo QBO 1016 image 1_zpsbsuqvatw.jpg

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

 photo QBO 1016 image 2_zpsw5rghapb.jpg

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 Terms, Due 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.

 photo QBO 1016 image 3_zps858vk66i.jpg

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.

QuickBooks Advantage

QuickBooks Advantage
p //

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.

 photo QBC 1016 image 1_zps4mlg4h2s.jpg

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

 photo QBC 1016 image 2_zpsbeg7xosm.jpg

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

 photo QBC 1016 image 3_zpsdu5ylq5n.jpg

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.

QuickBooks Advantage

QuickBooks Advantage
p //

Can’t Keep Up with Bills? QuickBooks Online Can Help

There are more pleasant accounting tasks than paying bills, but QuickBooks Online organizes and simplifies this critical chore.

How does your company keep track of its bills now? If you’re like a lot of small businesses, you’re still dealing with a lot of paper. You may have a paper or electronic calendar where you enter all of the due dates as bills come in. When you see one approaching, you either take out your checkbook or schedule an online payment. Then you store all of your paid paper bills in file folders in case you have to look back at them.

It’s probably pretty clear to you that this isn’t the best system. You occasionally miss payments because a bill was lost in transit or for some other reason didn’t make its way to you. Or you were out of the office for a few days and didn’t look back on deadlines you missed.

QuickBooks Online can help keep bill-payment running smoothly and your relationships with vendors on the up-and-up.

Two-Step Process

Before you can start paying bills, you have to enter them into QuickBooks Online. This will entail a bit of extra work the first time you deal with a particular vendor, but there are numerous benefits to handling your accounts payable in this fashion, like:

  • Speed. Once you’ve created a framework (template) for a bill, it will take minimal time to pay it in the future.
  • Documentation. All of your bill payments will be recorded in QuickBooks Online, so you won’t have to hunt through checkbook registers or file folders to see if a bill was paid.
  • Timeliness. QuickBooks Online will always remind you when a bill must be paid (if you’ve set it up correctly).

To enter a bill, click the plus (+) sign at the top of the screen and click on Vendors and then Bill. This screen opens:

 photo QBO 0916 image 2_zps00hllu36.jpg

You’ll enter information about each bill on a screen like this. There are fields not pictured here that you’ll sometimes have to complete. So let’s start a conversation about the whole process.

Looks pretty simple, doesn’t it? It is – if you have a simple bill like the one you receive for gas and electric. You select the vendor by clicking on the arrow next to the blank field in the upper left and choosing from the list that opens. The Mailing Address and Terms should fill in automatically if you’ve done all of your initial QuickBooks Online setup. If not, you can add and edit this information.

Bill date refers to the date of the bill itself, not the day payment is due to the vendor. That goes in the Due date field. Select your Account from the list that opens when you click in that field, and enter a Description and Amount. If that’s all that’s required for that bill, you can save it and proceed to the next. It’s now recorded as a bill that needs to be paid.

Recurring Payments

Some of your bills are just one-offs,but others arrive on a regular basis. So QuickBooks Online has tools that will minimize the time required to process them after you’ve entered the basic information once. After you’ve completed a bill, click Make recurring at the bottom of the page to see this screen:

 photo QBO 0916 image 1_zpsncgowctt.jpg

QuickBooks Online lets you create templates for bills to use in future payments.

This screen is self-explanatory. You simply tell QuickBooks Online how much notice you want before a bill’s due date so you can process the payment. Take care with this screen to avoid paying bills too early, which affects your cash flow unnecessarily, or too late.

You have three options when you’re creating a Recurring Bill template. You’ll choose one from the list that opens when you click the arrow in the Type field:

  • Scheduled. This is best used when the details of a transaction don’t change, like rent or a loan payment. You don’t have to do anything for the payment to be dispatched; it’s done automatically for you at the interval you set. You can, however, ask to be notified every time this occurs.
  • Reminder. You could use this for periodic payments that will require editing before they’re sent. For example, you’ll probably need to change the amount on your utility bills every month. QuickBooks Online will place a reminder in your Activities list on the home page.
  • Unscheduled. If you have bills that contain a great deal of detail but aren’t due on a set schedule, you can save the template and call it up when you need it by clicking the gear icon in the upper right and selecting Recurring Transactions.

Next month, we’ll talk about the process of actually paying bills. If in the meantime you start entering bills and find that you’re having trouble completing the fields required for more complex bills, call us to schedule a session or two.

QuickBooks Advantage

QuickBooks Advantage
p //

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.

 photo QBC 0816 image 1_zpsai8phrev.jpg

To help minimize errors, maintain data integrity, and preserve confidentiality, QuickBooks lets you restrict users to designated areas in the software.

Here’s how you as the Administrator can define these roles. Open the Company menu and select Set Up Users and Passwords | Set Up Users. The User List window opens. You should see yourself signed up as the Admin. Click Add User and enter a User Name and Password for the employee you’re adding. Confirm the Password and check the box in front of Add this user to my QuickBooks license. Click Next.

Note: You can have as many as five people working in your QuickBooks company file at the same time, depending on how many user licenses you’ve purchased. Not sure? Press F2 and look in the upper left corner. If you need more than five user licenses, talk to us about upgrading to QuickBooks Enterprise Solutions.

In the next window that opens (see above screen), you’ll be given three options. Probably you’ll most often select the second option, which lets you specify the screens this user can see and what he or she can do there. The first—All areas of QuickBooks—would seldom be granted. And the third allows us to come in and do whatever tasks have been outlined in our work relationship (troubleshooting, monitoring, creating and analyzing reports, etc.).

Click the button in front of Selected areas of QuickBooks and then Next. You’ll see the first in a series of screens that deal with the software’s functional areas: Sales and Accounts Receivable, Purchases and Accounts Payable, Checking and Credit Cards, Inventory, Time Tracking, Payroll and Employees, Sensitive Accounting Activities (funds transfers, online banking, etc.), Sensitive Financial Reporting, and Changing or Deleting Transactions.

 photo QBC 0816 image 2_zpsscooy6vb.jpg

When you give employees Selective Access in a particular area, you can further define their roles there.

The Sales and Accounts Receivable screen is a good example. You can see the options offered in the above image. By clicking on the buttons pictured, you’re giving this employee permission to both create and print transactions. Below these options, you’ll be able to keep him or her from seeing customers’ credit card numbers in their entirety by clicking in the small box. When you’re finished, click Next.

Keep clicking Next and proceed through the rest of the screens. Your choices will be similar on each. But be sure to read all of the descriptive text very carefully. Keep in mind the importance of confidentiality issues and security as you go along.

The ninth screen, Changing or Deleting Transactions, deserves special attention. First, should this employee be able to change or delete transactions in his or her assigned area(s)? Even though you trusted these employees to work with finances when you hired them, consider this question carefully. Depending on the volume of transactions processed every day, you may want to reserve this ability for yourself.

We may or may not have established and password-protected a Closing Date for your company file. This is the date when the books for a specific time frame have been “closed,” meaning that transactions should not be entered, added, or deleted prior to it. We can talk with you about the pros and cons of such an action.

A summary of user access rights

Here and on every other screen in this multi-step wizard, you can always click the Back button if you want to return to a previous window. When you’re finished, you’ll see a screen like the one in the above image that summarizes the choices you have just made.

If you’re feeling any uncertainty or confusion about the whole issue of access rights, we’ll be happy to go over your options with you. These are important decisions. You’ll want to stress to your employees that restricting their permissions does not signal a lack of your trust in them. Rather, QuickBooks provides these tools to protect everyone who uses the software as well as any external individuals and companies that might be affected.

QuickBooks Advantage

QuickBooks Advantage
p //

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.

 photo QBC 0616 image 1_zpsaqhwjj1s.jpg

If you receive full payment for a product or service at the same time the customer receives it, you should use a sales receipt.

Completing a sales receipt is similar to filling out an invoice or purchase order. Click Create Sales Receipts on QuickBooks’ home page or open the Customers menu and select Enter Sales Receipts. A screen like the one above will open.

Choose a Customer from the drop-down list and a Class (if applicable). If you have created more than one Template (more on that later), make sure that the correct one appears in the field. Verify that the appropriate Date and Sale No. read as they should. Click on the type of payment you’re receiving, and enter the check or credit card number where necessary (a small window will open for the latter).

Note: If you are working with a type of payment that does not appear in the four icons, click on the arrow below More to add it.

Now you’re ready to select the products or services you sold by clicking on the arrow in the field under Item to open the available list (if you have not created a record for what you’re selling, select <Add New> and complete the fields in the New Item window that opens). Enter the quantity (Qty.). The Rate, Amount, and Tax fields should fill in automatically, based on the information you entered when you create the item’s record.

When you’ve entered all of the items that the customer is paying you for, you can choose which Customer Message will appear on the sales receipt (you can see your options in the drop-down list found in the lower left corner of the screen). Anything you enter in the Memo field will be for your internal use only; it will not appear on the printed or emailed sales receipt.

Click Save & Close or Save & New.

Customizing Sales Receipts

 photo QBC 0616 image 2_zpsve3feedv.jpg

QuickBooks provides tools for customizing forms, including sales receipts.

QuickBooks’ forms contain the fields most often used by small businesses. But you can alter them in numerous ways to meet your company’s needs. To customize a sales receipt, open the Sales Receipt window and click on the Formatting menu. Select Manage Templates.

You’ll want to make a copy of the original sales receipt so that the original will always be available. Click the Copy button in the lower left. “Copy of Custom Sales Receipt” appears in the list of templates. In the Preview pane on the right, click in the field next to Template Name and replace the existing name with a new, more descriptive one if you’d like. Click OK.

The Basic Customization window opens. Click on Additional Customization at the bottom of the screen. You’ll see a window like the one in the image above. Click the Columns tab.  The list on the left displays all of the columns that can be included in the body of your sales receipt.

Click in the boxes below Screen and Print to indicate which columns should display on your QuickBooks screen and which should appear on the customer’s copy. The numbers in the Order column can be changed to reflect which column will come first, second, etc.

Numerous Options

There’s a lot more you can do to customize your QuickBooks forms. And there are other situations where you might want to issue a sales receipt. We’ve only been able to touch on both topics here, but would be happy to schedule time with you to explore these elements of QuickBooks.

 

QuickBooks Advantage

QuickBooks Advantage
p //