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

Detecting errors with standard reports

Experienced accountants detect errors with some form of variance analysis: a comparative annual balance sheet, a monthly profit and loss. This recipe highlights other methods of detecting errors in the QuickBooks file, which may be otherwise overlooked.

How to do it...

  1. 1. Identify check numbers missing from the sequence: Select Reports | Banking | Missing Checks, and select the checking account:

  2. 2. Identify transactions altered after being reconciled: Go to Reports | Banking | Reconciliation Discrepancy Report. Modify the columns as indicated in the following screenshot:

  3. 3. Identify altered transactions from a closed period: Go to Reports | Accountant & Taxes | Closing Date Exception Report. This report also displays the closing date history.

  4. 4. Isolate income or expense transactions not assigned a class: Go to Reports | Company & Financial | Profit & Loss Unclassified.

  5. 5. Identify unreimbursed expenses or unwithheld advances: Select Reports...

Previous Section
End of Section 5
Next Section