Scott Gregory, QuickBooks Expert

Accept Credit (and Debit) Cards in QuickBooks

Looking for ways to improve your cash flow? (and who isn't these days!)

If so, consider how one simple button within QuickBooks can improve your cash flow AND your efficiency as well. That button is the "Process Credit Card When Saving" option, which allows you to accept Visa, MasterCard, American Express and Discover card payments from your customers quickly and easily (the Visa example is shown in the screen shot below)

Once you have a merchant account set up with Intuit Payment Solutions, this button becomes active and ready to use for "one click" processing of credit card payments.

This solution is perfect for businesses that have have a fixed location. The process works exactly the same whether you swipe the card or just get the card details via mail order, internet, etc. (other solutions suggested below)

Watch a video on how to accept credit cards in QuickBooks using Intuit Payment Solutions

IF YOU NEED A MOBILE CREDIT CARD SOLUTION...

Let's say that you have a service business where you or your team is out on the road all day. Just because you are mobile doesn't mean you can't have a credit card processing solution that is simple too.

The Intuit GoPayment solution may be just what your CPA ordered to help improve your cash flow.

The GoPayment solution allows you to accept credit cards using your mobile phone. You can even get a Bluetooth card swiper and printer to complete your mobile credit card processing setup.

Watch a video on how the Intuit GoPayment solution works

POINT OF SALE (POS) USERS HAVE A SOLUTION TOO!...

Intuit has a solution for businesses that are using the QuickBooks POS too. It is designed to meet the unique needs of retailers and others that are tied into POS processing every day.

Watch a video on how the Intuit POS Payments solution works

THE KEY DIFFERENCE

Many of my clients have said the QuickBooks credit card solutions outlined above stopped them from having to do double work that is required if other credit card processing systems are used in addition to QuickBooks. In those cases, the data is entered twice. 

In the case of using the QuickBooks solutions, the data is entered once, and only once. Given this, be sure to factor in the value of your time when assessing proposals from various credit card processors.

In addition, be sure to carefully review the fee structure and costs of any credit card processing solution you may be evaluating.

GET A NO OBLIGATION CUSTOMIZED QUOTE ON THESE QUICKBOOKS SERVICES FOR YOUR BUSINESS

If you would like to get more information and/or pricing on one of these services for your needs, pick up the phone and dial my associate Kirstan Gides who works for the Intuit Payment Solutions Group. Her number is 800-601-4083 x 68287. You can also e-mail Kirstan to get a conversation going that way too.

Be sure to mention the discount code "bottomline" to Kirstan in order to get the best package possible that meets the specific needs of your business. 

_________________________________________________________________________________________________

Subscribe to this QuickBooks blog today!

Download Scott's free QuickBooks guides and learn more about QuickBooks.

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise accounting software. He has been helping businesses "think beyond the ledger" for over 25 years.

QuickBooks Tip: Need More Report Options? Just a Click Away

Tucked away in the corner of the Report Center screen in QuickBooks 2010 is a button called "Find More Reports" - an often overlooked but very powerful button.

Clicking the "Find More Reports" button transports you to the new QuickBooks Reports Library...

 

Here you will find an entire library of new reports that have been created by other QuickBooks users and QuickBooks ProAdvisors.

Within the library, you can search by the same categories you are used to seeing in QuickBooks, such as "company and financial", "customers and receivables" and more. You also have the ability to sort by the most recent, the most downloaded, and highest rated reports using the "sort by" button in the upper right hand corner of the screen.

HOW TO DOWNLOAD THESE REPORTS

Once you find a report of interest, simply create a folder on your computer to store the reports, click the download button and save the report in your newly created folder. Go to your reports folder, double-click on the report, and it will be added to your memorized reports menu. The process couldn't be any easier.

Some reports you may find of interest:

• Payments by Vendor
• Overhead as % of Total Income and Expenses
• Unapplied Customer Payments and Credits
• Sales by State
• Cash Flow Forecast by Quarter
• Many, many more...

What is your favorite report? Post a comment below and share it with everyone - thanks!

Save 20% and get an instant download or free shipping if you prefer to upgrade to QuickBooks 2010

____________________________________________________________________________________________________

Subscribe to this QuickBooks blog today!

Download Scott's free QuickBooks guides and learn more about QuickBooks.

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise accounting software. He has been helping businesses "think beyond the ledger" for over 25 years.

Using Custom Filters for Customers and Vendors in QuickBooks

There is a very powerful option within QuickBooks to help you quickly filter and find customers and/or vendors that match certain criteria (i.e. zip code). It's unfortunate that this option isn't as obvious as it could be within the software.

When browsing your customer list in the Customer Center, there is a drop-down menu at the top of the list that provides several choices:

• All customers
• Active customers
• Customers with open balances
• Custom filters

In this post, we will focus on the custom filters option.

 

Once you select the custom filter option, another box appears. This box is where the power and functionality of this feature lies:

As you can see, you have the ability to search and filter by:

• Name fields
• Address fields
• Phone fields
• Customer: Job name
• Company name
• City
• State
• Zip
• E-Mail
• Accounts number
• Custom fields
• Memo

For example, if I wanted to filter my customer list for all (not just active) customers that had a zip code of 94326, I would complete the box as shown below:

and then click the "Go" button.

My customer list is then filtered by zip code!

Clearing this custom filter is easy - just click the red "X" that appears to undo your search and filters or simply remove the filter option you have entered.

ALTERNATE METHOD OF FILTERING - Just type the zip code in the "find" box at the top of the customer list. Keep in mind that this method may find matching results in other areas beside the zip code field - using this option, it will display ALL matches to the criteria you have entered, not just the zip code.

SPECIAL NOTE IF USING JOBS - If you use the custom filter option and you have jobs in your list, QuickBooks changes the view of the list from the standard "hierarchical view" (say that 3 times fast!) to the "flat view". Translated, this alternate view doesn't show the jobs as being "indented" in the customer list as they normally are. Quick fix - just right click on the customer list and click the "hierarchical view" to return it to normal.

________________________________________________________________________________________________

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise accounting software. He has been helping businesses "think beyond the ledger" for over 25 years.

Subscribe to this QuickBooks blog today!

Download Scott's free QuickBooks guides and learn more about QuickBooks.

Track Inventory in QuickBooks? Optimize Your Investment With This New Add-On

Alterity, the creators of Acctivate, which is a leading inventory management add-on for QuickBooks, have recently released their "EZ Analytics for Inventory" software that plugs into QuickBooks 2009 and 2010 (Pro, Premier and Enterprise Windows versions only).

EZ Analytics for Inventory is designed to help businesses improve their inventory forecasting process while trying to find the optimum balance between customer service and inventory investment.

Inside EZ Analytics for Inventory you will find the following functionality:

• Monthly Sales Analysis
• Overstock Analysis
• Understock Analysis
• Reorder Analysis

Each of these reports is designed to pull your QuickBooks data and then analyze it against the desired objective of the report.

You can't beat the price of this software - it is currently free. The trade-off is that it is in beta form right now. The good news about it being in beta is that the developers would love to hear from you about how to make the product even better when it comes to managing your inventory.

This add-on concept relating to inventory management is excellent, as QuickBooks itself has been lacking in many respects in that area.

Take a look at EZ Analytics for Inventory and share your comments and insight below so the tens of thousands of businesses looking for inventory management tools for QuickBooks know how it works for you.

FOR MORE DETAILS ON ACCTIVATE INVENTORY MANAGEMENT SOFTWARE: Contact Ryan Moeller at (817) 870-1311to get a complimentary demo and see how it can benefit your business.

__________________________________________________________________________________________________

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise accounting software. He has been helping businesses "think beyond the ledger" for over 25 years.

Subscribe to this QuickBooks blog today!

Download Scott's free QuickBooks guides and learn more about QuickBooks.

QuickBooks 2010: The Improved Company Dashboard

Having a company dashboard/snapshot in QuickBooks was a new feature in QuickBooks 2009. In QuickBooks 2010, the QuickBooks software development team has made it an even more powerful tool to help manage your business.

A client recently commented that "this was an excellent new feature that was built into QuickBooks"

To access it, click the Company Snapshot icon at the top of the page, or click Company > Company Snapshot from the menu bar:

Here is a breakdown of the new features in the QuickBooks 2010 company dashboard/snapshot:

• A separation of company and payment dashboard content
  
  
  
• The ability to add new content and delete existing content
  
  
  
• The ability to print the information within the company dashboard/snapshot
  
  
  
• The ability to drag and drop your QuickBooks company dashboard content
  
  To do this, simply click on the section of the dashboard you would like to reposition and drag and drop it to the desired location.

Here is a view of the Company portion of the QuickBooks 2010 company dashboard/snapshot:

Here is a view of the Payments portion of the QuickBooks 2010 company dashboard/snapshot:

In order to take full benefit of this feature in QuickBooks 2010, be sure you have downloaded the latest update to the software (Help > Update QuickBooks).

NEED MORE DASHBOARD FUNCTIONALITY INCLUDING THE ABILITY TO INTEGRATE EXCEL DATA? Learn about QVinci, the "GPS" for QuickBooks.

WANT TO SAVE 20% AND GET AN INSTANT DOWNLOAD OR FREE SHIPPING ON QUICKBOOKS 2010? Visit my corporate web site and save big!

Using QuickBooks 2010? What are your thoughts on the "new and improved" company dashboard? Please post a comment below to share them...

__________________________________________________________________________________________________

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise accounting software.

Subscribe to this QuickBooks blog today and keep up to date on everything QuickBooks!

Download Scott's FREE QuickBooks guides now!

Download Paychex Payroll Data into QuickBooks With This Tool

If you have grown tired of manually entering your Paychex payroll data into QuickBooks each pay period, their General Ledger Reporting Service may be the solution.

According to information on the Paychex web site, this solution is part of their Paychex Online service, so using that service looks to be a prerequisite.

You can get a demo or sit in on a web seminar for their General Ledger Reporting Service via links on the site.

If I recall correctly, there is a small monthly fee that is charged for the use of this service. Maybe with some careful negotiation, you can get them to reduce or eliminate that fee? In any event, this software should allow you to work on more productive tasks than rekeying your Paychex payroll data into QuickBooks.

Are you currently using this Paychex service? Please post a comment to let our readers know how it is working out for you - thanks!

______________________________________________________________________________________________________

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise accounting software. He has been helping businesses "think beyond the ledger" for over 25 years.

Subscribe to this QuickBooks blog today!

Download Scott's free QuickBooks guides and learn more about QuickBooks.

Is Your QuickBooks a Pain in The Asset? New Webinars to Help

 

If your resolution for 2010 was to learn more about your bookkeeping and QuickBooks, I have the perfect solution for you - my new webinar series called "Is Your QuickBooks a Pain in the Asset"?

Throughout this series, we'll take a closer look at various aspects of bookkeeping, QuickBooks, and business finance. All of the webinars are designed with one thing in mind - to help you gain comfort and clarity when working with the finances of your business.

The first two webinars in my "Is Your QuickBooks a Pain in the Asset" series are:

• "All the Accounting You Need to Know" - designed to help you understand commonly used (and commonly confusing) bookkeeping terms and concepts. You will gain a much better understanding of terminology such as: chart of accounts (and why it is critical to your success), cash vs. accrual basis and much more.
  
  Even if you are not using QuickBooks, the terms and concepts discussed in this webinar apply to any accounting software. I will be using QuickBooks for demonstration purposes.
• "Understanding QuickBooks Preferences and Finding Information Fast!" - this webinar is perfect for QuickBooks users who DIDN'T know there was a preferences option in the Edit menu and for those who DID know one existed but were afraid to venture into it!

Registration for one or both of these webinars is a snap. Just click the link above and register. The cost for each webinar is a modest $25.

I hope to "see" you in the webinars!

_____________________________________________________________________________________________

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise accounting software. He has been helping businesses like yours "think beyond the ledger" for more than 25 years.

Subscribe to Scott's blog!

Download Scott's free QuickBooks guides today.

Inside QVinci - The DashBoard for QuickBooks: Management Tools

Qvinci provides you with the ability to calculate a number of critical metrics and perform detailed analysis using your QuickBooks and/or Excel data. Think of it as the "GPS for your Business".

This post will focus on the Tools option within the Management Tools section of QVinci:

Inside the Tools option, you will find the following resources available to you to assess your business (or if you are a CPA, to assess your clients' business):

Note: S = Standard version, P = Pro version, and E = Extended version of QVinci software

Using the Top Ten option above as an example, you can quickly pull Top Ten Customers by Sales information from QuickBooks into an easy to read dashboard page like this:

Inside the Top Ten option, you will also find the Top Ten Job Profitability, Sales by Rep and Purchase by Vendor dashboard reports.

As another example, the Average Aging option within the Tools menu allows you to assess your Accounts Receivables in a way that QuickBooks simply can't offer:

PREVIOUS POST: Inside QVinci - The Dashboard for QuickBooks: Getting Started

LIKE WHAT YOU SEE WITH QVINCI?

• Small businesses - save 50% on your first month of QVinci.
• CPAs and Accountants - get your own copy of QVinci for just $5 per month!

______________________________________________________________________________________________________

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise accounting software. He is also a QVinci Master Guru.

Connect with Scott today to download his free QuickBooks guides.

QuickBooks 2010 - Download This Product Update (R5) for Less Intrusive Marketing

I recently received this news update regarding QuickBooks 2010 from the product managers at QuickBooks and I wanted to share it with you:

"We've heard you! And, you've told us loud and clear that our marketing communications in QuickBooks 2010 have become a distraction to getting your work done.

Our newly released R5 patch to QuickBooks 2010 has the following improvements based on your feedback:

• The “Recommended for You” widget in the Snapshot can now be turned off with one click. Just click on the “X” on the upper right side of the box.
• The “Accept payments” sidebar on the Receive Payments and Sales Receipts screens can now be closed with one click.  Just click on the “close toolbar” on the upper left side of the box.  Alternatively, you can show or hide this sidebar through your preference settings.
• You can now use the "turn off pop-ups" preference in QuickBooks to turn off newly added pop-ups in QuickBooks. Clieck Edit > Preferences > General > Turn off pop-up messages.
• You can now turn off the “Payment Interview” permanently.  Just click on the “X” on the upper right corner.

The R5 patch will be automatically pushed to any version of QuickBooks 2010 which has updates turned on.  If you prefer to get the update manually, you can access that here."

I figured it was only a matter of time until the din of user complaints reached a crescendo before some action was taken to remove these various marketing intrusions.

Now, if only QuickBooks opted to take similar actions on their phone in product registration process!

_______________________________________________________________________________________________

Have you downloaded Scott's free QuickBooks guides yet? Get your copy today.

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise accounting software. He has been working with businesses like yours for over 25 years, solving their QuickBooks and accounting headaches.

Understanding Price Levels in QuickBooks

If your business has a standard/base price for items that you sell and the need to create various levels of discounts or increases to those standard prices, the price level tool in QuickBooks is just for you.

Tucked away within the Lists option on the menu bar, the Price Level list provides the flexibility you need to quickly and easily create different price levels based either on a fixed percentage of your base price or on a per item basis.

The video below provides the insight you need on how to use price levels on a fixed percentage basis, and then have those various prices appear in quotes, sales orders or invoices and also default to a certain level based on the customer too!

__________________________________________________________________________________________________

Scott Gregory is a specialist with QuickBooks Pro, Premier and Enterprise accounting software.

Have you downloaded his free QuickBooks guides yet? Download them today!