Microsoft Office Small Business Accounting 2006 Step by Step

by Frye, Curtis

• ISBN13: 9780735621541
• ISBN10: 0735621543
• Edition: 1st
• Format: Paperback
• Copyright: 2005-09-07
• Publisher: Microsoft Press

Summary

The smart way to learn how to manage and track your small business finances-one step at a time! Work at your own pace through the book's easy-to-follow lessons and skill- building exercises on CD to master the fundamentals of managing your company's finances with Microsoft Office Small Business Accounting. Starting with a quick overview of accounting for non-accountants, the book covers everything from generating business intelligence reports to managing accounts, banking transactions, products and services, sales data, invoices, customer payments, vendors, and employee time and payroll. You get all the book's practice files on CD, along with the Microsoft Office System Reference pack.

Author Biography

Curtis Frye is the author of numerous books on Excel and other Office products, most recently the Excel 2007 Pocket Guide. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

Table of Contents

Getting Help	vii
Getting Help with This Book and Its CD-ROM	vii
Getting Help with Microsoft Office Small Business Accounting 2006	vii
Using the Book's CD-ROM	ix
Minimum System Requirements	ix
Opening the Practice Files	x
Using the Practice Files	x
Using Northwind Traders and Fabrikam Databases	x
Conventions and Features	xi
Quick Reference	xiii
Setting Up a New Company	xiii
Managing the Chart of Accounts and Journal Entries List	xvii
Managing Products and Services	xx
Setting Up Customer Information	xxiii
Managing Jobs	xxvi
Generating and Managing Quotes	xxvii
Handling Sales	xxviii
Preparing and Managing Invoices	xxix
Handling Customer Payments	xxxi
Purchasing from and Paying Vendors	xxxiii
Managing Employee Time and Payroll	xxxiv
Managing Bank Accounts and Transactions	xxxv
Creating Reports to Manage Your Business	xxxvii
Getting to Know Microsoft Office Small Business Accounting 2006	1	(5)
What Is Accounting?	1	(1)
Key Terms and Definitions	2	(1)
Your Accounting Duties as a Small Business Owner	3	(3)
Setting Up a New Company	6	(24)
Viewing a Sample Company	7	(3)
Creating a New Company	10	(6)
Managing Company Data	16	(4)
Protecting Your Data Files	20	(4)
Managing User Accounts	24	(6)
Managing the Chart of Accounts and Journal Entries List	30	(22)
Viewing the Chart of Accounts	32	(6)
Adding and Editing Accounts	38	(5)
Making a Journal Entry	43	(9)
Managing Products and Services	52	(18)
Viewing the Item List	53	(3)
Creating New Items	56	(2)
Managing Inventory Items	58	(5)
Managing Service Items	63	(4)
Managing Custom Item Groups	67	(3)
Setting Up Customer Information	70	(28)
Creating a Customer Record	72	(6)
Viewing the Customer List	78	(3)
Creating a Customer Group	81	(1)
Creating Price Levels, Credit Ratings, and Payment Terms	82	(4)
Setting Up Sales Tax Agencies and Sales Tax Codes	86	(5)
Adding Details to a Customer Record	91	(3)
Creating a Customer Statement Template	94	(4)
Managing Jobs	98	(18)
What Is a Job?	99	(1)
Viewing the Job List	100	(6)
Viewing Job Details	106	(2)
Creating Jobs	108	(1)
Editing and Deleting Jobs	109	(2)
Modifying Job Groups	111	(2)
Accounting for Cash Sales Related to a Job	113	(3)
Generating and Managing Quotes	116	(14)
Creating a Quote	118	(4)
Viewing the Quote List	122	(2)
Managing Accepted and Rejected Quotes	124	(4)
Creating a Quote Template	128	(2)
Handling Sales	130	(14)
Entering a Sales Order	131	(7)
Viewing and Manipulating the Sales Order List	138	(1)
Creating Sales Order Templates	139	(1)
Editing Sales Orders	140	(1)
Managing Back Orders	141	(3)
Preparing and Managing Invoices	144	(14)
Invoicing a Customer	145	(4)
Creating an Invoice from a Quote or a Job	149	(3)
Voiding and Editing Invoices	152	(2)
Recording a Finance Charge	154	(4)
Handling Customer Payments	158	(16)
Managing Payments	159	(5)
Handling Cash Sales	164	(1)
Setting Up Credit Card Processing	165	(1)
Managing Returns and Refunds	166	(6)
Designing Credit Memo Templates	172	(2)
Purchasing from and Paying Vendors	174	(18)
Creating a Vendor Record	176	(1)
Creating a New Vendor Record	176	(4)
Viewing the Vendor List	180	(1)
Creating a Purchase Order	181	(3)
Receiving Purchased Items	184	(1)
Paying Vendor Bills	185	(3)
Preparing 1099 Forms for Vendors	188	(4)
Managing Employee Time and Payroll	192	(16)
Managing Employee Records	193	(4)
Tracking Employee Time	197	(5)
Managing Payroll	202	(6)
Managing Bank Accounts and Transactions	208	(20)
Working with Account Registers	210	(3)
Writing Checks	213	(2)
Recording a Bank Deposit	215	(2)
Transferring Funds	217	(1)
Editing a Credit Card Charge	218	(2)
Reconciling a Bank Account	220	(2)
Setting Up Online Banking	222	(2)
Downloading and Matching Transactions for Online Accounts	224	(4)
Creating Reports to Manage Your Business	228	(19)
Managing Reports	229	(6)
Creating Custom Reports	235	(4)
Generating Business Intelligence from Reports	239	(8)
Glossary	247	(2)
Index	249