Docstoc

Quickbooks Troubleshooting

Document Sample
Quickbooks Troubleshooting Powered By Docstoc
					                  TECH 2008
          QuickBooks News, Tips and
               Troubleshooting

               Douglas Sleeter, Founder
                The Sleeter Group, Inc.




                                              www.sleeter.com




                       Topics

What’s New in QuickBooks 2008
QuickBooks Troubleshooting and Repair
  Data File Analysis
  Troubleshooting Out-of-Balance Balance Sheets
Data File Management
  File Types, File Sizes, Cleaning Up, Starting Over




                                              www.sleeter.com




      The QuickBooks 2008 Product Line

Simple Start
Pro
Premier
Premier: Accountant
Enterprise Solutions




                                              www.sleeter.com




                                                                14-1
           Simple Start New Features

Payroll
Customer Credit Card Protection Features
Import Customers and Vendors from Excel
List restriction removed
Simple Start Plus Pack




                                           www.sleeter.com




            Pro Edition New Features

Outlook Integration
Remote Access
Time Tracker for Outlook (add-on)
Enhanced Office Integration




                                           www.sleeter.com




          Premier Edition New Features

Invoice for Time and Expenses
Remote Access Enhancements
Accountant Edition New Features
  Improved Accountant’s Copy




                                           www.sleeter.com




                                                             14-2
     Enterprise Solution New Features

Linux Support
True Commerce EDI Transaction Manager software




                                                 www.sleeter.com




New Features of QuickBooks 2008 and Enterprise
                 Solutions 8.0
     We’ll Discuss These Enhancements in Detail

  Accountant’s Copy Enhancements
  New Customer Credit Card Protection Features
  Remote Access via Webex Improvements
  Outlook Integration
  Excel List Import Improvements
  Invoice List for Time and Expenses
  Merchant Services Enhancements




                                                 www.sleeter.com




    Accountant’s Copy Enhancements

Dividing Date
Online Data Transfer Option
Reconciliation
Other enhancements




                                                 www.sleeter.com




                                                                   14-3
Accountant’s Copy Enhancements – Dividing Date




                                                                                 www.sleeter.com




 Accountant’s Copy Enhancements – Online Data
                   Transfer

Two Options for Accountant’s Copy
  Save File (same as previous versions)
  Send to Accountant
     Enter email address
     Enter Encryption
     Password
     Must communicate
     the password




                                                                                 www.sleeter.com




Accountant’s Copy Enhancements – Reconciliation
  Can only be used if both client and consultant are
  using QuickBooks 2008
  Release 4 Now available
    Fixes problems with special characters in
    account names
    Reconciliations Not Rolled Back when:
         Client did not reconcile anything before Dividing
         Date
         Accountant did not Reconcile any Accounts
    http://support.quickbooks.intuit.com/support/Pages/KnowledgeBaseArticle/1009504



                                                                                 www.sleeter.com




                                                                                                   14-4
    Accountant’s Copy Enhancements – Other
                 Enhancements

Work with a 2007 or 2008 created Accountant’s Copy
Highlight color on fields to be transferred
Changes to “ownership” of lists
Conflict Resolution improved




                                              www.sleeter.com




 New Customer Credit Card Protection Features

Meets PCI requirements




                                              www.sleeter.com




    Remote Access via Webex Improvements

File > Utilities > Remote Access in QuickBooks Pro
Improved speed when remotely accessing client
computers.
Revised pricing
  Free version now includes remote printing




                                              www.sleeter.com




                                                                14-5
             Outlook Integration

New Preference for tracking email communication
through Outlook




                                           www.sleeter.com




      Excel List Import Improvements

New Data Import Wizard




                                           www.sleeter.com




    Invoice List for Time and Expenses

Time & Expenses Company Preferences




                                           www.sleeter.com




                                                             14-6
      Merchant Services Enhancements

Previously, authorization and charge a single step
With 2008, can process authorization before
processing payment




                                                         www.sleeter.com




     Troubleshooting QuickBooks Files

Data File Analysis – A “Best Practice” for
Consultants/Accountants
   Why Do Data File Analysis?
   Selling The Data File Analysis Engagement
   What to Charge
   Performing the Analysis (Where, When, How
   Often)
   Preparing a Report of the Analysis
   Automating the Process

                                                         www.sleeter.com




    Troubleshooting Corrupted Files

Verify Company Files Periodically (Monthly)
If File is Corrupted, use Rebuild
If Rebuild Doesn’t Fix it, Look at the
QBWIN.LOG file
Remove/Replace Damaged Transactions
If That Fails…
www.quickbooks.com/support/programs/data_recovery.html




                                                         www.sleeter.com




                                                                           14-7
    Out-of-Balance Balance Sheets


Happens on Cash Basis Balance Sheets
Narrow Down the Problem to WHEN it
Happened
Find All Transactions on That Day
Inspect and Troubleshoot


                                                            10:00
                                              www.sleeter.com




        Troubleshooting Bank Recs

Correcting the Beginning Balance Field When the
client:
  Deleted a Reconciled Transaction
  Removed the Cleared Status
  Edited a Previously Reconciled Transaction




                                              www.sleeter.com




        Troubleshooting Bank Recs

Using the Reconciliation Discrepancy Report
  For all Causes Except Deleted Transactions




                                              www.sleeter.com




                                                                    14-8
          Troubleshooting Bank Recs

Use Previous Reconciliation Reports
  Compare PDF (Static) Report to Dynamic Report




                                         Static (PDF)
                                            Report


Dynamic
 Report
                                             www.sleeter.com




          Troubleshooting Bank Recs


  Troubleshooting Forced Reconciliations




              Non-Zero!
                                             www.sleeter.com




          Troubleshooting Bank Recs

Resetting the Default Statement Date
  If user erroneously enters a future date in the
  Statement Date field (01/31/2007 vs.01/31/2006),
  QuickBooks assumes the next bank reconciliation
  is 02/28/2007


Solution… Undo Reconciliation




                                             www.sleeter.com




                                                               14-9
             Data File Management

QuickBooks File Types – See Table
Portable Company Files
The Clean Up Data Utility (see next page)
When and How to Start Over




                                                   www.sleeter.com




       Using the Clean Up Data Utility
  Formerly “Condense Data” Feature
  Removes All Transactions On/Before Specified Date,
  Except:
     Uncleared
     Open/Unapplied
     Inventory (Some Exceptions)
     To be Printed
     Timesheets and Unbilled Pass-throughs
     Transactions Linked to Non-Condensable Transactions



                                                   www.sleeter.com




       Transactions Created by Utility

One Summary Transaction Per Month Replaces All
Deleted Transaction


Understanding The Utility




                                                   www.sleeter.com




                                                                     14-10
            When and How to Start Over

When to Start Over
   Data File Exceeds Maximums (see table below)
   Excessive Data Entry and/or Setup Errors –
   Correcting vs. Starting Over
      How Many Open Transactions Does the Client Have?
      How Far Back do the Problems Go?
      Proximity to Year End

                Recomm ended Dat a File Size M aximums
      QuickBo o ks Editio n s   Sim pleStart, Basic, Pro , o r   En terprise So lutio n s
                                Prem ier
      Th rou gh version 2006    100MB or sm aller                250MB or sm aller
      Version 2007              200MB or sm aller                350MB or sm aller




                                                                                            www.sleeter.com




        Salvaging as Much Data as Possible

Using Clean Up Data Utility to “Remove All”
This Preserves
  Users and Company Prefs/Passwords
  User Customizations
  All Lists
  Custom Form Templates
  Memorized Reports
  Memorized Transactions
  Online Banking Setups



                                                                                            www.sleeter.com




                     Utilities Worth Owning

Data Transfer Utility by Karl Irvin
   www.q2q.us
Data Mover by Personable
   www.personable.com/datamover/overview.asp
Transaction and List Copier for QuickBooks
   www.bigredconsulting.com
Data Flow Manager by Atandra
   www.atandra.com




                                                                                            www.sleeter.com




                                                                                                              14-11
    Questions



   Douglas Sleeter
The Sleeter Group, Inc.
  doug@sleeter.com
  www.sleeter.com




                          www.sleeter.com




                                            14-12

				
DOCUMENT INFO
Description: Quickbooks Troubleshooting document sample