Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts

Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts

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

Buy this Book

Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts

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

Buy this Book

Overview of this book

QuickBooks Enterprise Edition 12.0 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. 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. 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. This book is rooted in the longstanding features of QuickBooks and includes the newest tools, whether you’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. 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.

Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts

Credits

About the Author

Acknowledgment

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Special Capabilities of the Enterprise Edition

Introduction

Customizing user permissions

Creating highly-customized reports with ODBC

Using the Employee Organizer

Customizing the Interface

Introduction

Customizing the icon bar

Customizing the home page

Customizing QuickBooks windows

Shortening the data entry process for customer payments

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

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

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

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

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

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

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

Integration with Excel

Introduction

Combining reports from multiple entities

Setting up reports for optimal exporting

Updating exported reports

Using Excel to edit lists hyperefficiently

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

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

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Creating and transmitting custom batch letters

Combine the database of QuickBooks with mail merging capabilities of Microsoft Word to quickly prepare custom batch letters for your customers, vendors, employees, or others. Use this recipe to create a completely customized letter, instead of just using the templates.

Getting ready

Make sure that the information for the desired recipients is included in the Customer List, Vendor List, or other appropriate list in QuickBooks. To quickly scan all customers for missing information, use the Add/Edit Multiple List Entries feature in the Lists menu.

How to do it...

1. Select Customer Center (Ctrl + J) | Word | Customize Letter Templates as shown in the following screenshot:
2. Select Create a New Letter Template from Scratch, and click on Next.
3. Choose a letter type, and enter a template name.
4. Click on the Next button. A Word document opens.
5. Prepare the letter as desired. To insert fields from the QuickBooks file, click on the Add-Ins tab.
6...

Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts

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

Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts

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

Overview of this book

Related Content you might be interested in

Current Title:

Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts

Creating and transmitting custom batch letters

Getting ready

How to do it...