Microsoft KB Archive/169400
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