Creative Financial Software

Complete QuickBooks Year End Procedures with Reproducible Checklists

Extensive Data Analysis Troubleshooting Procedures

Step by Step Year End Procedures Include:

Obtaining Copies of Your Client’s Files (multiple methods)
Correcting Setup and Data Entry Errors (see detail below)
Depreciating Fixed Assets in QuickBooks
Working with Accountant's Copy Files (recently improved by Intuit)
Using the QB Working Trial Balance Tool
Transferring Your Changes to Your Client’s Files (multiple methods)
Importing the Adjusted Trial Balance into Lacerte and ProSeries Income Tax Preparation Software
Creating GAAP Compliant Financial Statements Using Your Client’s Corrected and Adjusted Trial Balance

Extensive Troubleshooting Procedures Include Steps for Analyzing and Correcting the Following:

Setup Errors in QuickBooks Posting Lists
- Chart of Accounts
- Items, Payroll Items and Fixed Asset Items
Changes by the Client to Prior Years (Closed Years)
- When the Closing Date is Set
- When the Closing Date is Not Set
Bank Reconciliation Errors
Cash Basis Conversion Issues
- Removing Balances in AR/AP on the Cash Basis B/S
- Clearing the Balance in Accrual Accounts other than AR/AP
Posting Errors to Trial Balance Accounts
- Cash
- Accounts Receivable/Payable
- Inventory Asset
- Sales Tax Payable
- Payroll Liabilities and Payroll Expenses
- Opening Balance Equity
- Income Statement Accounts

Thank you for your interest in the two books authored by Joe Woodard scheduled for publication within the next couple of months.

Since these are the first books Joe Woodard has self published, we are processing book sales through faxed order forms until we are able to get our web store up and running. We appreciate your patience with this "old school" method of purchasing these books. We hope to have the web store up very soon.

Joe Woodard’s

Top 100 QuickBooks Tips, Tricks and Workarounds

Note - We Offer a Webinar Series Based on this Book

33 Tips in the Book (For Example)

Increasing Multi-User Performance
Leveraging Cutting Edge Remote Access Technologies
Tracking All of Your Adjustments When Working with Client Files
Reducing Bad Debt for QuickBooks Consulting Engagements

33 Tricks in the Book (For Example)

Enhance Bank Reconciliations by:
- Sorting Banking Transactions by Information Other than Check Number While Reconciling Bank Accounts.
- Using a "Find" Button While Reconciling Bank Accounts.
Hiding Account Numbers on Financial Statements
Viewing All Transactions in QuickBooks with Debits and Credits
Restricting Your Client's Edits to the Chart of Accounts
Tying QB Sales Reports to the Income Statement
Tracking Sent Methods (Mail/Email) for Sales & Purchase Forms
Creating a Single QB List for All Name Types
Creating Custom Fields on Sales Forms with Drop Down Lists
Recording Write Offs that Result in Accurate Item Reports & Cash Basis Reports
Locating Specific Problems with Your Data File Detected by the Data File Verification Utility

34 Workarounds in the Book (For Example)

Tying the P&L to the P&L by Job
Burdening Freight to Inventory
Allocating Payroll Taxes to Both Expense and Cost Accounts
Transferring Transactions between QuickBooks Files
Creating "Real" Back Orders (as separate transactions from Sales Orders)
Showing the "Real" Open Balance for Purchase Orders
Showing the "Real" Open Balance for Sales Orders
Including Reported Tips on Paychecks
Posting Timesheet Information to the P&L by Job/Class without Using Paychecks
Clearing Bank Reconciliation History
Export Data To Excel with Dynamic Links to QuickBooks Data

Joe Woodard’s

QuickBooks at Year End and
Tax Time

Book Order Page