Scott Gregory, QuickBooks Expert

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!

Inside QVinci - The Dashboard for QuickBooks: Getting Started

Qvinci is add-on software for QuickBooks that allows you to quickly create your own customized dashboards so you can review and analyze not just your QuickBooks data, but also data from your Excel sheets as well.

For example, you can easily create a dashboard that contains the following key metrics and charts for your business (or your clients if you are a CPA):

• Profit and Loss Overview
• Last 3 year Profit and Loss Comparison
• A/R and A/P Last 12 Months
• Balance Sheet Charts (shown in the screen shot below)
• Key ratios, such as the quick ratio, current ratio, gross profit margin

There is a tremendous amount of functionality and flexibility built into QVinci, and this post will show you a few of the basic things you need to know to get up and running quickly with it.

Once you install the software, open it and follow these instructions:

• Click the New Dashboard button on the File tab
• Click the QuickBooks graphic on the Options tab
• Click the Jump Start button on the File tab
  
  
• Connect to your QuickBooks data file (it must be open in order to make this initial connection)
• Select the "Build Everything" option and wait a couple of moments for your QVinci dashboard to be created.
• Answer the few remaining questions about building charts and using Excel, and you are finished.

Your QuickBooks data file (and/or Excel worksheets) are now attached to your QVinci dashboard, and you are ready to either review the results or customize the dashboard even further by adding or deleting key charts and performance indicators.

As another example, you are able to see information about your Accounts Receivable in a way that QuickBooks can't offer you, as shown in the screen shot below:

Be sure to click the Save button on the File tab to quickly and easily store your dashboard configuration for future analysis. I'll cover more features and functionality of QVinci in future posts.

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.

Get Your Free QuickBooks Guides and Training Manuals

Looking for free QuickBooks tutorials and training manuals?

Tucked away in a far corner of QuickBooks are two very important links that will allow you to download digital versions of user guides and even the complete "how to" QuickBooks manual.

Click Help > Learning Center Tutorials and a screen like this appears:

Take note of the links to "Download the free e-book" - the official guide to using QuickBooks and also the link to "Download QuickBooks user guides in PDF format".

The list of user guides includes:

• QuickStart Guide
• Multi-User Checklists
• QuickBooks Install Guide
• QuickBooks Basics Guide

Of course, if you need help sorting out all of this information to get QuickBooks set up and fine-tuned for your business, I am available to help you. Drop me a line and we can arrange an appointment to help you get your QuickBooks questions resolved.

____________________________________________________________________________________________

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

Scott Gregory is a specialist with QuickBooks Pro, Premier, and Enterprise software. He also works with a number of QuickBooks add-on software solutions.

Another Way to Quickly Find Information in QuickBooks

If you have been looking for an easy way to look up transactions related to your customers, vendors or employees, don't forget about using the transaction tab to locate them.

The screen shot below is taken from the Customer Center (the information below applies to the Vendor and Employee Centers as well):

Once you click on the transactions tab, you then have access to the various types of transactions relating to customers. This list is already organized for you by the type of transaction:

Green arrow: Shows you the list of available transaction types. In the example above, I clicked on the word Invoices, and a listing of all invoices in the default date range appeared to the right.

Red arrow: Note the black triangle just to the right of the word "Customer". This indicates that this information is sorted by customer from A to Z. If you click the word "Customer" again, the list will resort by customer from Z to A. To sort by any of the other columns, simply click on the title of that column and the list will be resorted as you like.

Keep in mind that you can also choose a different range of dates by clicking in the date box and making your selection.

Taking advantage of the various options within the transactions tab can be an easy way for you to quickly locate information within QuickBooks.

______________________________________________________________________________________________

Have you downloaded Scott's free QuickBooks guides yet?  Do it today!

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

ATTN: Accountants - Tools To Help in Your Business

As you look for ways to get more done in less time and provide even more timely insight to your clients in the new year, here are several solutions that may be of interest to you:

• Tic, Tie and Calculate - a plug in for Adobe Acrobat that will help you be far more efficient with your digital workpapers.


• Tungle - software that makes it a snap to schedule meetings with clients and staff members. I've just begun using this in my business with great results.


• QVinci - a great way to set your clients up with a customized dashboard of key financial data, performance metrics, and other key indicators. Works with QuickBooks and Excel data to create the financial dashboard your clients are looking for. Use referral code 74481650 to set up your own copy of QVinci (which you can customize for your business) for just $5 per month.


• Rescue Time - an interesting solution to help recover productive time from your work week. Plans for individuals and businesses available.


• CPA Productivity Survey - a detailed survey tool designed to help you take a closer look at how to make your firm more productive and profitable.

What technology tools are you using in your business to help with productivity and profitability? Post a comment below to share your secrets with us.

______________________________________________________________________________________________

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

Get your clients some huge savings on QuickBooks Enterprise! Limited time offer!

Import and Export Data Into QuickBooks from External Sources and Databases

I was recently introduced to a product that can simplify the importing and exporting of data between QuickBooks and outside sources of information, such as spreadsheets and other databases.

Autofy, from PropelWare, automatically and simply synchronizes a variety of business records between desktop and enterprise software, as well as online data sources.

Accounting invoices, sales transactions, customer contact information and more can be easily exchanged between QuickBooks and outside data sources.

Some Key Benefits...

• Affordable, simple-to-implement solution
• Seamless integration between QuickBooks data and dozens of software products and data sources
• Eliminate double data entry and associated errors and problems
• Import and export using CSV or XML file formats

Autofy comes with a setup wizard that can help you get started and includes:

• Simple data mapping setup
• Schedule for automatic processing
• Manage saved sync operations
• View sync history
• Retrieve data from the web or PC

If you are in need of pulling data into or out of QuickBooks, Autofy may be a tool to help you make that an easier process.

Currently using Autofy? Post a comment below to let our readers know about your experience with it!

_____________________________________________________________________________________________

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

Have you downloaded Scott's free QuickBooks guides yet?

FTC Disclaimer: If you purchase a copy of this product via my blog, I will be paid a referral fee from Propelware. It will promptly go into my movie and pizza fund.