SBFM97: Contents of the Quickbooks 5.0 Filter Readme.txt

Last reviewed: January 7, 1998
Article ID: Q171408
The information in this article applies to:
  • Microsoft Excel 97 for Windows
  • Microsoft Small Business Financial Manager 97 for Microsoft Excel 97

SUMMARY

The following is the contents of the Quickbooks version 5.0 filter for the Microsoft Small Business Financial Manager 97 Readme.txt. You can obtain this Readme.txt file by downloading Sbfmqb5.exe from the Microsoft Software Library and extracting its contents.

For more information about how to download files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

MORE INFORMATION

MICROSOFT SMALL BUSINESS FINANCIAL MANAGER 97 FOR MICROSOFT EXCEL

      QUICKBOOKS AND QUICKBOOKS PRO 5.0 FILTERS README FILE

(c) 1997 Microsoft Corporation. All rights reserved.

CONTENTS

  1. Installation Instructions

  2. Problems Importing Accounting Data from Intuit Quickbooks 5.0

  3. Problems with Accounts Being Incorrectly Classified in Financial Manager

  4. Differences in Account Numbers Between Intuit Quickbooks 5.0 and Financial Manager

  5. Differences in Quantity Sold Between Intuit Quickbooks 5.0 and Financial Manager

  6. Support and Licensing Information

NOTE: To use these filters, Microsoft Excel 97 and Microsoft Small Business Financial Manager 97 must be installed on your computer.

  1. INSTALLATION INSTRUCTIONS

        A. Quit Microsoft Excel 97, if it is running.
    

        B. Copy the Aapqbw50.dll file to the SBFM folder on your computer's
           hard disk. By default, this is C:\Program Files\Microsoft
           Office\Office\Sbfm.
    

  2. PROBLEMS IMPORTING ACCOUNTING DATA FROM INTUIT QUICKBOOKS 5.0

    Before you import accounting data from QuickBooks 5.0 for Windows, you must register QuickBooks and disable all password protections on the data. In addition, if you have Quickbooks set to automatically enter memorized transactions, this should be disabled while running the Financial Manager filter. If you don't, you may receive a series of error messages, which you should clear by pressing ENTER in response to each.

    If you encounter problems importing accounting data from QuickBooks 5.0 for Windows, you should run the QuickBooks utility to rebuild your accounting data, and then try importing again. To run the QuickBooks repair utility, choose Rebuild Data on the QuickBooks File:Utilities menu.

  3. PROBLEMS WITH ACCOUNTS BEING INCORRECTLY CLASSIFIED IN FINANCIAL MANAGER

    Occasionally, when importing Quickbooks 5.0 data, accounts end up in the wrong category. This causes Financial Manager reports to be incorrect.

    If this occurs, use the Remap menu item on the Accounting Menu within Microsoft Excel to correctly map your data to the proper account categories.

  4. DIFFERENCES IN ACCOUNT NUMBERS BETWEEN INTUIT QUICKBOOKS 5.0 AND FINANCIAL MANAGER

    If you use account numbers when setting up accounts in Quickbooks, these account numbers will not appear on Financial Manager reports. Financial Manager will create its own account numbers to ensure that reports are sorted correctly.

  5. DIFFERENCES IN QUANTITY SOLD BETWEEN INTUIT QUICKBOOKS 5.0 AND FINANCIAL MANAGER

    When entering an invoice in Quickbooks 5.0, if you do not enter a sales price and quantity, it will default to a quantity of 1 when creating reports. This quantity is not an accurate reflection of the transaction.

    Financial Manager will use a quantity sold of 0 for these transactions, which properly reflects what was entered in the invoice. This will cause some differences between the quantity sold reported in Financial Manager and that reported in Quickbooks 5.0.

  6. SUPPORT AND LICENSING INFORMATION

    Assistance with these filters is provided to you through your Microsoft Small Business Financial Manager 97 for Microsoft Excel warranty support policy. Installing these filters will not restart this warranty period. If your Microsoft Small Business Financial Manager 97 warranty support period has expired, paid phone support and alternative options are available.

    If your license to the Microsoft Small Business Financial Manager 97 product was obtained from a hardware manufacturer, then technical support for these filters is not available from Microsoft. Please contact your hardware manufacturer before installing these filters to determine your support options.

    These filters, for use only with Microsoft Small Business Financial Manager 97 for Microsoft Excel, are considered to be part of Microsoft Small Business Financial Manager 97 for Microsoft Excel. Therefore, their use is subject to the same terms and conditions governing the use of Microsoft Small Business Financial Manager 97 software.


Additional query words: 2.00 XL97 sbfm readme update
Keywords : kbref xlsbfm kbtool
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbref


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 7, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.