Book Image

Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts

By : Jaime Campbell, CPA, MBA, CTT, MCT
Book Image

Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts

By: Jaime Campbell, CPA, MBA, CTT, MCT

Overview of this book

<p><i>QuickBooks Enterprise Edition 12.0</i> is accounting software that is both user-friendly and sophisticated. The interface is visual and intuitive, but feature-rich for mid-size businesses, as well as complex, growing small businesses.<br /><br />QuickBooks Enterprise Edition 12.0 for Experts is a cookbook with specific recipes for time-saving shortcuts, valuable customized reports, and surprising ways to use this accounting software to support decision-making in your small or medium-sized business.<br /><br />With QuickBooks Enterprise Edition 12.0 Cookbook for Experts you can choose a topic of value and learn specific, practical techniques usable in your own QuickBooks file or in a sample file.<br /><br />This book is rooted in the longstanding features of QuickBooks and includes the newest tools, whether you&rsquo;re upgrading from Premier or from a prior version of the Enterprise Edition. Topics include customizations, time-saving methods, integration with Microsoft Excel, and special tools and setup techniques for hyper-efficient information retrieval and analysis.<br /><br />Whether you are an independent or industry accountant, whether you are a book-keeper, controller or CFO, QuickBooks Enterprise Edition 12.0 Cookbook for Experts will help you to expand what is possible in your business.</p>

Related Content you might be interested in

Current Title:

Small book image
Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts
Jaime Campbell, CPA, MBA, CTT, MCT
May, 2012 | 220 pages
No titles found
Table of Contents (19 chapters)
Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts
Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts
Credits
Credits
About the Author
About the Author
Acknowledgment
Acknowledgment
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Special Capabilities of the Enterprise Edition
Special Capabilities of the Enterprise Edition
Introduction
Customizing user permissions
Creating highly-customized reports with ODBC
Using the Employee Organizer
2
Customizing the Interface
Customizing the Interface
Introduction
Customizing the icon bar
Customizing the home page
Customizing QuickBooks windows
Shortening the data entry process for customer payments
3
Items
Items
Introduction
Setting up items for different purposes
Using group items
Configuring items for fund accounting
Configuring inventory assembly items
Creating standard item-based reports
Creating customized item-based reports
4
Special Tools
Special Tools
Introduction
Using the History button
Running the Transaction Journal report
Producing a single-transaction audit trail
Extracting customer and vendor histories
Distinguishing between the the Search and Find tools
5
Customizing Reports
Customizing Reports
Introduction
Creating an "Unearned income by customer" report
Creating an "Accrued interest payable by lender" report
Creating an "Uncleared transactions" report
Capturing unbilled items simultaneously
Memorizing reports
Sharing reports
Preparing a custom Profit & Loss report with the QuickBooks Statement Writer
6
Memorized Transactions
Memorized Transactions
Introduction
Memorizing transactions for automatic entry
Memorizing transactions for assisted entry
Editing a memorized transaction
Configuring reminders for memorized transactions
Grouping memorized transactions
7
Customer and Vendor Relations
Customer and Vendor Relations
Introduction
Creating and transmitting custom batch letters
Customizing invoices, purchase orders, and other documents
Using the Collections Center
Applying customer credit limits
Creating and utilizing custom fields
8
Troubleshooting
Troubleshooting
Introduction
Clearing stale undeposited funds
Adjusting cash basis receivables or payables balances
Writing off stale receivables
Writing off stale payables
Balancing the balance sheet
Classifying unclassified transactions
Reclassifying Opening Balance Equity transactions
Classifying uncategorized income or expenses
Resolving opening balance discrepancies in bank reconciliations
9
Keyboard Shortcuts
Keyboard Shortcuts
Introduction
Using the Ctrl key shortcuts with lists
Using the Ctrl key shortcuts with transactions
Using the Alt key shortcuts
Using date shortcuts
Using other shortcut techniques
10
Integration with Excel
Integration with Excel
Introduction
Combining reports from multiple entities
Setting up reports for optimal exporting
Updating exported reports
Using Excel to edit lists hyperefficiently
11
Supervisory Tools
Supervisory Tools
Introduction
Using memorized reports for supervisory activities
Creating customized item-based reports to detect errors
Detecting errors with standard reports
Using the Attached Documents feature to spot-check transactions
Using the Audit Trail feature to gather supervisory intelligence
12
New for the 12.0 Edition
New for the 12.0 Edition
Introduction
Refreshing Excel reports
Using the Advanced Inventory features
Making a period copy
Using Find & Select during data entry

Setting up reports for optimal exporting

Most QuickBooks experts are already familiar with the ability of the software to export to Excel. However, some customizations may be needed in the Excel environment. This recipe includes a tool to eliminate repetitive structural customizations every time a report is exported to Excel.

Getting ready

Perform the following steps:

  1. 1. Create a report in QuickBooks, click on the Excel button, and then select Create New Worksheet.

  2. 2. Click on the Advanced button.

How to do it...

Perform the following steps:

  1. 1. Make your selections on the Advanced Excel Options pop-up box. The following screenshot represents my favorite export settings:

  2. 2. Click on OK. Please note that these options need to be set only once. The next time you export a report from QuickBooks to Excel, these settings will be present automatically, and there will not be any need to click on the Advanced button.

How it works...

We have the following options in Excel that facilitate our working...

Previous Section
End of Section 4
Next Section