Running QuickBooks 2014 Premier Editions · the Only Definitive Guide to the Premier Editions by Barich, Tom -- Read -- Imperial Library of Trantor

Index

Chapter 1:

Getting Started

Installation Tips

Upgrading QuickBooks Opening an Existing Company File Restoring a Backup File

Chart of Accounts

Designing a Chart of Accounts Using Account Numbers Account Naming Protocols Creating Accounts Select Accounts from Examples Automatically Created Accounts Special Accounts in All Company Files Feature Based Special Accounts Using Multiple A/R and A/P Accounts Inventory Special Accounts Never Enter Opening Account Balances Using Subaccounts Using Subaccounts for Easier Tax Preparation Editing Accounts Deleting Accounts Hiding Accounts Merging Accounts Importing the Chart of Accounts

Multiple Currencies

Select the Currencies You Need Tracking Exchange Rates Linking Customers and Vendors to Currencies Assigning Currency to New Customers and Vendors Accounts for Multicurrency Transactions Creating Transactions in Other Currencies Creating Reports on Multicurrency Transactions

Opening Trial Balance

Understanding the Opening Trial Balance Entering Historical Transactions Entering Open Payables Entering Inventory Creating the Trial Balance for Last Year Checking the Results Generating the Trial Balance for the Current Year

Managing Company Files

Versions Vs. Editions Copying and Deleting Company Files

Chapter 2

Lists and Classes

Setting Up Your Lists

Customer & Vendor Profile Lists Customers & Jobs List Vendor List Fixed Asset Item List Price Level List Applying Price Levels to Customers in Batches Billing Rate Level List Item List

Manipulating List Data

Using a Hidden List Component in Transactions List Limits Creating Custom Fields In Lists Adding Custom Fields to Transaction Forms

Classes

Chapter 3

Premier Sales Features

Easier Invoicing for Time and Expenses

Enabling the Invoice for Time & Expenses Feature Opening the Invoice for Time & Expenses Window Creating Invoices from the Invoice for Time & Expenses Window

Internal Costs Reimbursements

Setting Up Internal Cost Tracking Creating Reimbursable Charges for Internal Costs Internal Costs Job Costing

Sales Orders

Enabling Sales Orders Enabling Warnings about Inventory Stock Status Creating Sales Orders Sales Order Templates Turning Sales Orders into Invoices Creating the Invoice Managing Backorders

Creating Transactions Automatically

Automatic Purchase Orders From Sales Orders Automatic Sales Orders from Estimates

Chapter 4

Premier-Only Accounting Functions

Journal Entries

Adding a JE Icon to the Icon Bar or Favorites Menu AutoFill Memos in Journal Entries Auto Reversing Journal Entries Adjusting Journal Entries Send GJEs History and Reports in the GJE Window

Allocating Overhead Expenses to Jobs

JE Source and Target: Solving the Mystery

Allocating Overhead Expenses to Classes Auto-calculating by Percentage Previous Bank Reconciliation Reports

Choosing the Type of Reconciliation Report Resolving Reconciliation Problems Reconciliation Vs. Downloading Transactions

Chapter 5

Reporting and Planning Tools

Balance Sheet by Class Exporting Reports as Templates

Customizing Reports Exporting a Template Sending a Template Importing a Report Template Creating Groups of Memorized Reports

Closing Date Exception Report

QuickBooks Closing Date Procedures Setting a Closing Date Sometimes Password Protection Doesn’t Work Generating the Closing Date Exception Report Interpreting the Closing Date Exception Report

Forecasting

Creating a Forecast Setting the Criteria for a Forecast Choosing the Method for Obtaining Data Entering Data Manually Editing the Forecast Creating Reports on Forecasts

Business Planner

Entering Company Information Income Projection Using the Projection Wizard Entering Income Data Manually Expenses Projection Interview Section Writing Your Business Plan Previewing Your Business Plan Viewing and Printing the Business Plan Export the Business Plan Backing Up the Business Plan

Chapter 6

Inventory Tips

Understanding Inventory

Cost of Goods Sold Inventory Adjustment Accounts

Using the Inventory Center

Inventory Center Components Inventory Information Pane Creating an Inventory Item Properly QuickBooks Average Costing

Tracking the Real Cost of Inventory

Inbound Shipping Costs Work in Process Inventory Cost of Improving Inventory

Units of Measure

Enabling Units of Measure Creating a Single Unit of Measure Creating Multiple Units of Measure Changing or Removing the U/M for an Item Managing Units of Measure

Inventory Assemblies

Creating an Assembly Understanding the Cost of an Assembly Building an Assembly Managing Pending Builds Disassembling an Assembly

Managing Returned Damaged Inventory Items

Using an Item Designed for Damaged Inventory Returns Inventory Adjustments for Damaged Items

Tracking Prepayments of Purchase Orders

Creating the Elements for Prepayments Creating Prepayment Transactions Receiving Prepaid Items into Inventory

Taking Inventory on the Road

Configuring On-the-Road Inventory Creating On-the-Road Customers and Jobs Configuring the Calculation of Available Quantity Creating a Sales Order for Inventory on the Road Returning Items to the Warehouse Reports for On-the-Road Inventory

Chapter 7

Tips for Payroll and 1099 Vendors

Keeping Payroll Information Secure Configuring Vendors For Payroll Liabilities Posting Payroll Liabilities and Expenses Social Security Numbers on Pay Stubs Pay Stubs Generated for Clients

Using a PDF Printer File Security

Re-issuing a Lost Paycheck Payroll Deductions for Employee Repayments

Setting Up Employee Repayment Elements Creating an Employee Loan or Paycheck Advance Creating an Employee Purchase Transaction Deducting Payment from the Paycheck Tracking Multiple Employee Repayment Accounts

Garnishments

Garnishment Vendors Payroll Item for a Garnishment Assigning a Garnishment Deduction to an Employee Viewing and Editing Garnishment Paycheck Deductions Remitting Garnishment Deductions Returned Garnishment Checks

Tracking and Reporting Tips

Creating an Account for Tracking Tips Adding Tips to Sales Transactions Creating a Sales Item for Tips Creating Payroll Items for Tips Adding Tips to Paychecks Tips and IRA Plans

Tracking Outsourced Payroll

Entering Payroll as a Journal Entry

Net To Gross Paycheck Calculation Subcontractors and 1099s

Form W-9 1099 Backup Withholding Remitting Backup Withholding to the IRS Reimbursing 1099 Vendor Expenses Subcontractor Garnishments

Chapter 8

Sales and Use Tax

Sales Tax

Enable Sales Tax Configure Sales Tax Codes Configure Sales Tax Items Create Sales Tax Groups Assign Sales Tax Items to Customers Sales Tax Rates that Differ by Item Special Tax Rates Remitting Sales Tax

Use Tax

Tracking Use Tax for Purchases Use Tax for Inventory Items Used in Your Business

Common Sales Tax Problems

Payments to State Didn’t Reduce Sales Tax Liability Sales Tax Charged to Exempt Customer

Chapter 9

Accountant Edition

Premier Accountant Plus Using Accountant Edition in Your Practice

Company Data File Configuring Customers and Jobs Managing Items Using Price Levels Using Billing Rate Levels Entering Transactions in a Batch

Client Support Tools

Working Trial Balance Accountant’s Copy Portable Files Client Data Review External Accountant Client Data Review Tools Working in the CDR Center Fixed Asset Manager File Manager Open Two Company Files in QuickBooks

Send General Journal Entries Client Troubleshooting Tips

Managing Uncashed Checks Vendor Bills Paid with Direct Disbursements Vendor Pays Off a Credit with Checks Applying Additional Credits to a Paid Bill Reimbursable Cost of Goods Managing Outside Sales Reps Bartering Inter-company Transactions Selling Items on Behalf of Another Company

Chapter 10

Contractor Edition

Contractor Company Files

Classes for Contractors Customer Types for Contractors Job Types for Contractors Vendor Types for Contractors Items for Contractors

Managing the Sale of Materials and Parts

Applying Units of Measure to Materials

Handling Customer Deposits

Elements for Tracking Customer Deposits Recording a Customer Deposit Applying the Customer Deposit to an Invoice Reporting on Customer Deposits Deposits that Are Just Payments in Advance Transferring Deposits Held to Operating Funds

Job Costing

Linking Expenses to Jobs Using Items for Job Costing Tracking Material That Isn’t Job-Specific Reporting Job Costs

Estimates Change Orders

Creating a Change Order Making Additional Changes to an Estimate

Managing Retainage

Configuring QuickBooks for Retainage Creating a Retainage Account Creating Retainage Items Using the Retainage Item in Sales Forms

Holding Retainage for Subcontractors

Configuring QuickBooks for Retainage Payable

Depositing Checks with Two Payees

Chapter 11

Manufacturing and Wholesale Edition

Stock Status Information for Sales Orders

Stock Status Configuration Options Out of Stock Warnings Insufficient Stock Warnings Checking Stock Status Details Modifying Sales Orders to Obtain Promised Stock

Sales Order Fulfillment Worksheet Customizing Purchase Orders

Duplicating a Template Customizing the Purchase Order Template Adding Purchase Order Info to the Item List

Units of Measure Customer Return Merchandise Authorizations

Creating RMAs Processing Customer Returns of Inventory Providing Credits for Damaged Inventory

Returning Products to a Vendor

Voiding or Modifying a Purchase Order Voiding or Modifying a Receipt of Items Voiding or Modifying a Receipt of Items and Bill Entering a Vendor Credit for a Paid Bill Entering a Vendor Refund Creating a Non-Conforming Material Report Tracking Damaged and Missing Products

Manufacturing and Wholesale Reports

Chapter 12

Nonprofit Edition

Unified Chart of Accounts (UCOA)

Renaming Accounts Importing the UCOA

Accounts Receivable

Using Multiple A/R Accounts Using A/R Accounts in Invoice Transactions Reporting on Receivables

Using Classes

Program Classes

Customers and Jobs Equity Accounts

Balance Sheet By Class Report

Customized Templates for Transactions

Pledges (Invoices) Donations (Sales Receipts)

Avoid Data Entry Shortcuts Reports for Nonprofits

Chapter 13

Professional Services Edition

Company File Lists

Customers and Jobs List Items Customer and Vendor Types Billing Rate Levels Classes Allocating Overhead to Classes

Retainers

Liability Account for Retainers Retainer Items Virtual Bank Accounts for Retainers Moving Existing Income to Retainers Applying Retainers to Invoices Tracking Retainer Balances Postings for Applying Retainer Funds Moving Retainers to the Operating Bank Account

Managing Upfront Deposits

Creating Accounts for Upfront Deposits Creating Items for Upfront Deposits Receiving Upfront Deposits Applying an Upfront Deposit to an Invoice Upfront Deposits that are Just Payments in Advance

Managing Escrow

Configuring Escrow Components Receiving Funds into an Escrow Account Disbursing Funds from an Escrow Account

Customized Templates

Customized Invoice Templates Customized Proposal Template

Customized Reports

Chapter 14

Retail Edition

Company File Elements

Chart of Accounts Inventory Items Customers Payment Methods Handling Over and Short

Recording Sales

Recording Individual Sales Recording Sales in Batches

Upfront Deposits

Managing Upfront Deposits as Liabilities Managing Upfront Deposits as Regular Payments

Layaways

Using Sales Orders for Layaways Using Invoices for Layaways Service Charges for Undelivered Layaways

Gift Certificates

Selling Gift Certificates Redeeming Gift Certificates

Consignment Sales

Configuring QuickBooks for Consignment Sales Consigned Products as Inventory Parts Consigned Products as Non-Inventory Parts Customizing Templates for Consignment Sales Selling Consigned Items Tracking Consigned Item Sales Paying Consignors

Traveler’s Checks

Traveler’s Checks Configuration Traveler’s Checks that Are Less Than the Sale Amount Traveler’s Checks that are More than the Sale Amount

Point of Sale Add-ons

QuickBooks POS Third Party POS Applications

Appendix A

Importing Lists from Excel

Importing Excel or CSV Files

Configuring an Excel or CSV File as an Import File Selecting the Import File Mapping the Data Categories Setting Preferences for Importing Data Previewing the Import Managing Preview Errors Importing the File Viewing the Import Error Log Re-using Mappings

Data Keywords

Chart of Accounts Excel/CSV Headings Account Type Keywords for Excel/CSV Files Customer:Job Headings for Excel/CSV Files Customer:Job Data Mappings for Excel/CSV Files Job Keywords for Excel/CSV Files Vendor Headings for Excel/CSV Files Vendor Data Keywords for Excel/CSV Files Item Headings for Excel/CSV Files Item Type Keywords for Excel/CSV Files

Add/Edit Multiple List Entries

Customizing the Window Adding Entries to a List Editing List Entries

Using Third-Party Add-Ons

Appendix B

Using IIF Files

About IIF Import Files Accountants and IIF Files Format of an IIF File Exporting Data into an IIF File Creating Multiple Lists in One IIF File Importing an IIF File IIF File Keywords for Lists Profile Lists Import Files

Customer Type List Import File Vendor Type List Import File Job Type List Import File Sales Rep List Import File Ship Via List Import File Terms List Import File

Standard Lists Import Files

Chart of Accounts Import File Customer:Job List Import File Importing Jobs Vendor List Import File Item List Import File Employees List Import File Other Names List Import File Price Level List Import File Sales Tax Code List Import File Class List Import File

Summary of List Headings Updating Lists with Import Files

Creating Import Files to Update Existing Lists Adding and Modifying Data Working With Custom Fields Saving the Import File Importing Updated Data into QuickBooks

← Prev
Back
Next →

← Prev
Back
Next →