payroll

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

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.

Tracking Bills in QuickBooks, Worth the Effort

Next to payroll, paying bills is probably your least favorite task in QuickBooks. You don’t have to use this feature — you can keep stacking bills on your desk, scrawling the due dates on a paper calendar, and writing checks.

If you’re still operating this way, though, you’re missing out on the numerous tools that QuickBooks offers to track your accounts payable, including the ability to:

Enter bills as they come in
Set reminders for bills due
Pay bills easily
Locate a bill or payment quickly
Enter bills as (or after) you receive items
Link bills to purchase orders
Have instant access to a bill’s status

Receiving the goods

When an expense bill comes in (from a utility company, for example), click the Enter Bills icon on the home page, or Vendors | Enter Bills. A window like the one displayed above opens. Select the vendor and fill in the blanks. Make sure that the Expenses tab below is selected and the appropriate account number and amount fields are completed. If it’s a bill for an item that already has a related Item Receipt (the shipment preceded the bill), QuickBooks instructs you to use Vendor | Enter Bill for Received Items. Follow the prompts. Note: Dealing with incoming inventory is complex. Consult with us if you plan to use this feature. If the bill came simultaneously with items, click Vendors | Receive Items and Enter Bill. When you select the vendor from the list, this box opens (if you have sent a purchase order):

Figure 2: QuickBooks is telling you that you have open orders with this vendor.

Click Yes. The Open Purchase Orders box opens, containing a list of open POs. Select the one(s) you want and click OK. The bill form opens, containing the details of that purchase order. Change quantities if they don’t match the shipment, and edit other fields as necessary. Save the bill.

Settling your debts

It’s good to set reminders for bills. Go to Edit | Preferences and click Reminders. Make sure that the Show Reminders List…box is checked, then click Company Preferences. Find the Bills to Pay row and enter the advance notice you’d like. Indicate whether you want to see a list or a summary, then click OK. When bills are due, click the Pay Bills icon or select Vendors | Pay Bills. A window opens displaying all outstanding bills. You can pare this down by selecting a date in the Due on or before field and filtering by vendors. The screen will look something like this:

Figure 3: You can easily select the bills you want to pay.

Enter a check mark next to the bills you’re paying, and change the amount in the Amt. To Pay field at the end of the row if necessary. At the bottom of the screen, you can set the payment date and type, use any discounts or credits, and make sure the correct payment account is selected. When you’re done, click Pay Selected Bills. Tip: You can have credits and discounts automatically applied by going to Edit | Preferences | Bills

After You’ve Paid Up

There are a number of places where your bills appear in QuickBooks, including:

The Unpaid Bills Detail report
The A/P Aging Detail report
The Vendor Center
QuickReports
In the Recent Transactions pane of some forms
On the bills themselves

Figure 4: QuickBooks displays the Paid status of bills.

QuickBooks also lets you void and delete bills, and copy and memorize them. Check with us before voiding and deleting, as this can make some complicated changes in your accounts.

You can just pay bills by using Banking | Write Checks or Enter Credit Card Charges. But the payoff for tracking bills is instant access to your accounts payable status, better relations with vendors, and a more insightful accounting of your company’s cash flow.