Information from the chart of accounts
|
Account
And double-click an
option such as Account Description, Account ID, and so on.
|
Company > Financials > Chart of Accounts
|
Account activity for a specific time frame, excluding closing entries
|
Activity
And double-click an option such as This Month This Year, Last Quarter Last Year, and so on.
|
Month-End Date field
on the Workbook Properties sheet
|
Account balances at a specific point in time, including all previous
closing entries
|
Balance
And double-click an option such as Current Balance This Year, Retained Earnings Balance Two Years Ago, and so on.
|
Month-End Date field
on the Workbook Properties sheet
|
Accrual budget amounts for a specific time frame
|
Budget
And double-click an option such as Budget This Month This Year, January Budget Three Years Ago, and so on.
|
Month-End Date field
on the Workbook Properties sheet
Note:
|
The QTD and YTD options are based on and restricted by the month-end date. The other budget options are based on that date but not restricted by it.
|
|
Credit or debit account activity for a specific time frame
|
Cash Flow
And double-click an option such as This Month Debit This Year, Year End Credit Four Years Ago, and so on.
|
Month-End Date field
on the Workbook Properties sheet
|
Activity, balance, or cash-flow information for a time frame or point in time that you specify
Note:
|
Custom account balances will not include all previous closing entries.
|
|
Custom
And double-click a custom date property.
|
Custom Date Properties window and the Month-End Date field
on the Workbook Properties sheet |