& connect with us on...
| |
Our Monthly Tip:
Exporting to Excel
by Ihor Czornobil,
WB Accountant Have you ever generated a report from QuickBooks ® only to wish that you had more flexibility in what you could do with the report? Perhaps you need a different sorting basis or you just want to drill down into specific parts of a report and analyze that part. Well, to a majority of QuickBooks users, this is not really a new feature; however, every report which you generate from QuickBooks can be exported into a new or existing Excel workbook. On your tool bar above each report you generate is a series of options, located towards the middle of the page. There is a Print button, an Email button and the now famous Excel button. You simply click on this button and it converts the report you see on the screen to an Excel workbook. The workbook is prefaced with a set of instructions or guidelines that will help you understand the capabilities of the data that was exported from your QuickBooks data files. Once the data has been converted, and it only takes seconds, you are off and running. Everything you can do in Excel can be accomplished in this exported file. Upon completion, you can save it just like any other Excel work book. So, for those of you power-Excel users who just can't get enough analytical tools, here is your opportunity to make things much clearer to your benefactors; and for the novice Excel users, just another skill to add to your arsenal of analytical tools. Try this feature and see how useful it can be in making your life that much simpler. |
 Webinars Designed To Peak Your Interest
and sharpen your skills!
Webinar Topics:
Wed., May 8, 10 am CST
Cost: $49 per person
1 hour CPE credit for CPAs
To register, please email your name and contact information to:
If you have a friend who is interested, make sure they sign up for the QB Newsletter so they can receive future announcements, too.
If you have an idea for a topic or need more information, please email Rich Kane. |
Have a question that needs a solution?
Contact one of our QuickBooks® Pros... they have the answers!
Rich Kane
847.941.0253
Dean Klemenz 847.941.0205
Adam June
Rich Bauer
847.941.0237
Weltman Bernfield
485 E Half Day Rd, Suite 250
Buffalo Grove, IL 60089
P: 847.941.0100
F: 847.941.0101
|
|
|
Greetings!
Here are some important highlights for the upcoming month:
- Are you using QuickBooks® 2010? Did you know it is being retired as of the end of this month? Would you like to upgrade to version 2013? Call us for pricing.
- Tax season is over and our webinar season has begun. Join Rich Kane on May 8th to learn how to work with reports in QuickBooks. See the left column for cost and how to register.
- More and more of our clients are going to QuickBooks products in the cloud. Please contact us so we can give you the low down.
- Do you have a suggestion for the software? Please go into QuickBooks and go to "Help" (the last item along the top). Then go down to "Send Feedback Online." Fill it out and Intuit will gather all suggestions for consideration. Please do this soon as they are wrapping up ideas for QuickBooks 2014.
Please don't hesitate to contact us if you have any questions. See our contact information below.
Sincerely,
Your QuickBooks® ProAdvisory Team
|
|
10 Tips to Perfect Check-Printing in QuickBooks
|
|
Be sure that you've established all the right settings and understand the process.
If you used small business accounting products in the early days, you know how frustrating it was to print checks correctly from your software. Pre-printed checks weren't cheap, and you probably printed at least a few that didn't line up right or were otherwise unusable.
 Figure 1: The Write Checks window in QuickBooks 2013.
Printing checks from QuickBooks® has gotten easier, and online banking has made this task less of a necessity for many businesses. But when you do print checks, precision is still required.
So to minimize frustration, save time and money, and ensure that everything will be copacetic when your checks are processed at the bank, it's important that you use the tools that QuickBooks offers appropriately. If you've been having trouble with check-printing or you're considering attempting it, keep these tips in mind:
- First, be sure you are creating standard checks, not paychecks. Go to Banking | Write Checks or click the Write Checks icon on the home page.
- QuickBooks offers a few options for check creation. ClickEdit | Preferences | Checking | My Preferences. Here, you can specify a default account for the Write Checks function. Click Company Preferences for additional options.

Figure 2: Check the boxes here to activate options.
- You can customize the appearance of your checks. Click File | Printer Setup | Check/PayCheck. Specify printer options and check style, change the fonts in some fields, designate a partial page printing style (using the envelope feed) and add your company's name and address, logo and a signature image.

Figure 3: The Printer Setup window provides access to your output options.
-
Be sure that your printer has enough ink or toner before you begin a job.
-
If you print a lot of checks, consider dedicating one printer to that task. But secure your blank checks. Don't leave them in the printer.
- Does your printer process pages in reverse order, last page first? This can cause problems when you're printing multiple checks. You have several options here. You can:
- Modify your printer's property settings in Windows and/or consult your printer documentation,
- Load the paper to accommodate reverse printing, or
- Alter the check numbers in QuickBooks. Go to Lists | Chart of Accounts and open the correct checkbook register to change them. (This option is the least elegant and most risky, and not something you want to do on a regular basis. Let us help you with your printer setup if you can't resolve the problem.)
- QuickBooks supports batch printing. If you're writing multiple checks that you'll want to print later, click the Print Later or To be printed link (depending on your version of QuickBooks). When you're ready, you can either select File | Print Forms | Checks or click the Print Checks link on the home page. Both will open this window:
Figure 4: Uncheck any items you don't want printed to remove them from the batch job.
- Printing a batch of checks and realize that you've set something up wrong? Hit the Esc key to halt it.
- Double-check to make sure that your numbers match before you launch a print job. Compare the number in the First Check Number field to the number of the first check queued up in the printer.
- Ruin a check or an entire page of them? If your accounting protocol allows you to skip check numbers, just start over by changing the First Check Number so that it corresponds with the starting number on a fresh batch of check blanks. If not, you'll have to create a check for each one that was ruined, choosing a name and account and an amount of $0.00. Then void the check(s). (Click Banking | Use Register and select the account. Highlight the transaction(s), select the edit option and void. Do not delete them.
Check-printing can be tricky, but it must absolutely follow the rules. Let us know if you get stuck or want some guidance upfront - or if you want to switch to online banking and bill-pay.
|
|
|
|
|