QuickBooks Tip #1: Prepare Your Books for Quick Tax Preparation
(2011 Edition V.1)
1. Transaction Dates: Revise transactions done near end of year (Dec 15th to Jan 15th) to make sure that the correct dates are assigned to the transactions to make sure you report income and expenses in the correct year.
2. Method of Accounting: Make sure that the reports are in the correct accounting method (Cash or Accrual) Remember that most small businesses start at cash basis reporting for tax purposes and once they convert (or choose to change to) Accrual basis, changing back to cash basis is prohibited in 5 years.
3. Accounts Receivables: make sure all open invoices in accounts receivable report (A/R Aging Summary) are real invoices for work performed / product delivered and all invoices are collectable. In the case of overstatement, there will be additional income reported that should not be.
4. Accounts Payable: make sure that open bills (A/P Aging Summary) are actually for money owed, it's very common to have bills and checks repeat in a QuickBooks file, this double counts expenses
5. Negative Accounts: Please remember that generally there should be no negative accounts in the P&L Summary Report (unless is a return of some sort). In the Balance Sheet is common to see accounts such as "Accumulated Depreciation", " Allowance for bad Debt" , "Shareholder Distributions" , "Draw" as negative accounts, but it does not necessarily mean they should exist.
6. Uncleared Checks and Deposits: Pull a report of uncleared checks and deposits from the bank statement to make sure they are really outstanding items.. if not, delete them. For this to work, all bank statements MUST be reconcled first.
7. Report Comparison: if available pull a report comparing last year with current year to se major abnormalities or changes from year to year.
8. Chart of Accounts: try to use a consistent chart of accounts are the previous year
9. Fixed Assets: try to assign a sub-accounts for each major fixed asset to make it easy for the accountant to identify and build depreciation tables for them
10. Memos: try to have as much detail in the memos to make it easier for review.
Hector Garcia
Accountant / Certified QuickBooks ProAdvisor
http://www.qbkaccounting.com
2645 Executive Park Drive
Weston, FL 33331
954-414-1524
Published by Hector Garcia
- Why QuickBooks Has Become the Standard for New Businesses at StartupNew users of QuickBooks are usually adept at utilizing features which are quite easy to use. Good examples for this would be the checkbook and invoicing features.
- Quickbooks 2006 Update Error Guide: How to Make Them Go AwayThere are multiple potential error situations involved with Quickbooks 2006. Errors 1603 and 1328 specifically are covered, in addition to general information about the Quickbooks web patch available on the Intuit we...
- Setting Up QuickBooks for Builders and ContractorsIn order to use QuickBooks for Contractors to its fullest potential you need to setup and use QuickBooks a little differently than you would for most other businesses.
- How to Learn QuickBooks Basics for Free!QuickBooks one of the most widely used accounting software programs around can be learned for free. Here's how to learn to use it.
- How to Use QuickBooks and Accounting Assistant to Do Your EBay AccountingIf you use QuickBooks, you don't actually have to know how to do accounting. You just enter the data, and QuickBooks does all the math behind the scenes.
- Review of QuickBooks Pro 2008 Accounting Software
- Income Tax Preparation Services in Milwaukee
- Three Top Tax Preparation Firms in Benton Harbor, Michigan
- Tax Preparation Assistance in Missoula, Montana
- QuickBooks Tip: Fixing Corrupted Data Files
- Stressing Over QuickBooks? 10 Steps to Better Manage Your Bookkeeping Records
- How to Handle Work in Progress (WIP) or Construction in Progress (CIP) in QuickBooks