Working With the Balance Sheet Trending Reports
The Balance Sheet Trending card has the following forms:
-
Days Sales Outstanding
For more information, see Forecasting With Days Sales Outstanding.
-
Days Inventory Outstanding
For more information, see Forecasting With Days Inventory Outstanding.
-
Days Payable Outstanding
For more information, see Forecasting With Days Payable Outstanding.
-
Balance Sheet Movement Adjustment
For more information, see Submitting Final Adjustments to the Balance Sheet.
The Balance Sheet Trending card also has the Cash Cycle Dashboard which shows revenue, working capital, and cash conversion cycle trends. For more information, see Analyzing Trends in the Cash Cycle Dashboard.
Finance executives monitor and review the balance sheet and project future working capital closing balances and monthly movements. They use the Balance Sheet Trending forms to project the closing Accounts Receivable, Inventory, and Accounts Payable balances. Finance executives do this by entering the estimated days outstanding and percentages of sales and purchases on credit.
Finance executives also enter monthly movements or additional asset and liability Accounts, either manually or based on trends. They can apply a percentage increase or decrease and make final Balance Sheet monthly movement adjustments. Finally, finance executives review the Cash Cycle Dashboard and look at primary cash drivers and key financial metrics to identify trends.