Microsoft KB Archive/169400

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 15:34, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

Article ID: 169400

Article Last Modified on 11/17/2000


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q169400


In a Trial Balance report, when you drill down for detail about an asset or liability account, the beginning balance figures do not match the beginning balances for the accounting data.


This behavior occurs only for the beginning balance figures. Note that the Trial Balance uses the Net Change column to reflect the true balance for that period.


Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


In the Microsoft Small Business Financial Manager 97 for Microsoft Excel 97 you can generate various reports by using the Report Wizard. In a report, when you double-click a cell that contains a balance for a particular account, a new worksheet is generated. Detailed accounting data for that account is listed including beginning balances and net change amounts. The beginning balances may not match accounting data. However, the net change amount for that period is correct.

Additional query words: XL97 quickbooks

Keywords: KB169400