Quickbooks

Spring Cleaning: Streamlining QuickBooks 2013

Although Intuit did a great job of giving QuickBooks’ home page a fresher, more “open” look in its 2013 versions, maybe some of your screens have become unnecessarily cluttered. Perhaps your QuickBooks company file needs some attention as well. By taking a few minutes to do some “spring cleaning” you’ll have a tidier workspace, and you’ll save time and frustration. The following suggestions will help you to do just that.

Make a Clean Start

One simple way to take care of cluttered screens is to do the following:

Minimize icons. That pretty graphical process map on the home page is great for quick access to frequently-used actions. Some of them must remain there if they’re related to activities you do (i.e., Invoices has to stay if you use Estimates), but you can remove some of the ones you don’t use. Go to Preferences | Desktop View | Company Preferences. You’ll see this:

Figure 1: You can turn off some of the feature icons on your home page.

Some of the options have been grayed out because they support other processes. To remove an active feature icon like Inventory, click on it. In the window that opens, uncheck the box next to Inventory and purchase orders are active (you can also modify options here).

Figure 2: Clicking the checkbox next to Inventory and purchase orders are activegrays out the other options and removed related feature icons from the home page.

To reduce the number of feature icons even more, go to the Finance Charge, Jobs & Estimates, Payroll & Employees, Sales & Customers, Sales Tax and Time & Expenses. QuickBooks removes the related icons and reroutes the process map on the home page.

More Time-Saving Tweaks

Don’t allow multiple windows to open in your work area. Tired of seeing all of those overlapping open windows on your desktop? Open the View menu and select One Window. All of your open windows remain active in the background. To return to one of them, open the Window menu and select the one you want to move to the front (Window | Close All returns you to a blank work area).

Figure 3: Your Icon bar can be your fastest route to often needed screens–if you modify it to only contain the functions you use, in order of importance. You can also change the labels to make them more meaningful to you.

Trim down your icon bar. Seems like a minimal change, but it’s one of those things that can add unnecessary moments of frustration throughout the day (“Where’s the Calendar!”). Click View | Customize Icon Bar.

Customize columns in Lists. You probably work in QuickBooks’ Lists often, but are you spending too much time tracking down the right information? Customize their columns so your registers contain only what you usually need (and add additional ones if it’s helpful). Open a list, right-click anywhere within it and select Customize Columns to modify the display (re-size column widths by placing your cursor on the vertical set of dots between labels and dragging).

Figure 4: When you customize your columns in Lists, you’ll find what you’re looking for faster.

Hide inactive items. Highlight an item, right-click and select Make Item Inactive. Open the Item menu in the lower left and click Hide Inactive Items (this action won’t delete them).

Internal Cleaning

These may all seem like cosmetic changes, but you will save time and frustration over the long run.

The most critical spring cleaning task is company file analysis and maintenance. We can handle this for you. QuickBooks can slow down and start generating error messages when the data file becomes unwieldy and sloppy. Preventing file corruption before it crashes your system is a lot faster and less expensive than a reconstruction project.

By Leon Clinton
April 22, 2013

Use QuickBooks’ Tools to Prevent Financial Fraud

Whether your accounting tasks are done on a single PC or you have multiple users working on different screens, it’s critical that you make use of all that QuickBooks offers in terms of internal controls.

First Stop: Audit Trail

An audit trail is a very large report that displays every addition, deletion and modification of every transaction. In older versions of QuickBooks you could turn it on and off, but it’s permanently on now.

Because of its size, you’ll probably have to use QuickBooks’ filtering tools to zero in on the user and/or date(s) you’re looking for. Go to Reports | Accountant & Taxes | Audit Trail. Click Customize Report | Filters to set up your search.

Your audit trail won’t alert you when someone tries to enter a prohibited area, and it won’t detect changes to lists. Setting up permissions will help (Company | Set Up Users and Passwords | Set Up Users), but you need more than that.

Figure 1: Be especially careful when granting user access to areas that contain customer, vendor and employee information.

Run the Right Reports

Other QuickBooks features help prevent fraud as well. Review these reports regularly:

Closing Date Exception. Why were those changes necessary?
Voided/Deleted Transactions. Is there supporting documentation? Should you be reviewing these daily?
Expenses by Vendor Detail. Look for irregularities, especially multiple payments made to a vendor in a short period of time.
Check registers. Use the Balance Sheet for this. Go to Reports | Company & Financial | Balance Sheet Standard and customize the report for the correct period and, if necessary, for specific customers, vendors and/or jobs.

Adhere to Best Practices

You undoubtedly implement financial best practices in your personal life. You reconcile your accounts. You don’t give your online banking password to anyone. And you glance through your recently-posted transactions on your financial institutions’ websites.

If your company is large enough that you have multiple accounting employees, you probably can’t be as hands-on as you are at home. But you can still set up internal control procedures.

Figure 2: Debit? Credit? Reverse the transaction? No one should be making General Journal entries but you. It’s easy to err here; talk to us before using this feature.

For example, if your company has grown to the point where you’re removed from the daily workflow, you may still want to have approval rights for some procedures, like bank balance adjustments, refunds and credits, printed checks (you should still be signing them), timesheets and expense reports.

It goes without saying that you should password-protect your QuickBooks company file and change the password regularly, even–and especially–if you are the entire accounting department. It’s important to protect yourself from external fraud too. We can do a review of your security procedures and make suggestions.

Reinforce the Rules

Figure 3: Anyone in your company who has access to accounting data should have a background check.

Know who your employees are (consider running background checks) and, if you can, rotate the duties assigned to accounting staff. If you have only one person managing all of your bookkeeping work, conduct an even more thorough background search: credit, references, and criminal activity.

Finally, make sure that all employees understand the definition and consequences of fraud. Let them know about the steps being taken to prevent it, but do some unannounced auditing on your own. Include a session on fraud in orientation and get current staff up to speed. Explain that this is necessary for their protection, too. Make it easy to report fraud anonymously, with no fear of repercussions.

This may seem like a lot of extra tasks in your workday, but imagine the time you’ll lose tracking down fraudulent activity if it occurs.

If you have questions on this subject, or anything else, don’t hesitate to email or give us a call. We’re here to be your partner.

By Leon Clinton
March 26, 2013

2013: The Year You Go Mobile With Financial Data?

There are only a few reasons why you wouldn’t be using QuickBooks Mobile on your smartphone. Maybe you don’t have a smartphone. Or when you’re out of the office, you don’t want to be available for accounting work. Or you might not think that it has enough features to make it worth using.

While the first two reasons are matters of personal preference, the third just isn’t true. QuickBooks Mobile automatically–and almost instantly–synchronizes the data from your desktop or laptop computer copy of QuickBooks. While it’s only focused on sales, not payables or payroll, you can manage receivables quite nicely whether you’re in a customer’s office or at a trade show or community event–or sitting on the couch at home.

Figure 1: You can see this screen no matter where you and your smartphone are (the recently-upgraded Android version is pictured here).

Countless Scenarios

There are numerous situations where you might want to access, add or edit customers, estimates, invoices, sales receipts or payments when you’re not near the PC where QuickBooks is installed, like these:

You do a half day of onsite training and your client wants to pay you cash right then to qualify for a discount. You can record the payment and email a sales receipt.
You’re on the road and you want to see how well your bookkeeper is managing receivables. QuickBooks Mobile displays three views: recent activity, today and upcoming.
You’re with a client who would like to give you a check to get current, but he or she can’t find the invoice. Rather than calling your office and sitting on hold until someone has time to look, you can pull up the form on your smartphone to discuss it.

Figure 2: You can record sales receipts and payments on your smartphone, and even schedule appointments that move to your Google calendar.

Paper or Plastic?

If you’ve been in business for very long and still don’t accept credit cards, you have an idea of how many sales you’ve lost. And QuickBooks Mobile won’t let you do so, anyway. You’ll need to get a merchant account from Intuit Merchant Service for QuickBooks (fees apply). A merchant account allows you to accept plastic through QuickBooks itself, your web browser, your web storefront–and on your smartphone or iPad.

Figure 3: Missed your flight and afraid you’ll miss the current payroll run, too? Intuit Online Payroll gives you access from your Android or iPhone.

To do so, you’ll need to apply for a merchant account and download Intuit’s free GoPayment app. You can either swipe cards on the free mobile reader or type numbers in. Your customers sign their names on the surface of your mobile device, and you can print or email a receipt.

Figure 4: You’ll need to get acquainted with the Intuit Merchant Service Center to work with credit card payments.

It would be nice if those credit card payments were just instantly zapped into the right places in QuickBooks, but alas, it isn’t so. You’ll need to do some setup and processing both within QuickBooks and in the online Intuit Merchant Service Center. We can help you with setup and your initial transactions to make sure all of your payments get through and are deposited and/or credited correctly.

We think you’ll find that once you start using all of the mobile payment services that Intuit offers, you’ll wonder what took you so long.