Use this screen to view YTD ledger information with budgeting information entered from the Budgets menu of Costpoint General Ledger. The ledger information is compared to your YTD G/L budget data, if any, and can be compared to your prior year's YTD balance. The variance between your actual and budgeted data is also shown.
This inquiry shows information similar to that shown in the regular G/L Inquiry. Where the G/L Inquiry screen concentrates on showing a period breakdown of information, this inquiry shows instead a YTD comparison to the budget and to the prior year, with budget-to-actual variance columns.
The YTD fields on the main G/L Inquiry - Budget and Prior Year Comparison screen are listed below. You can use the Period Detail subtask to "drill down" to specific period information with similar budget comparisons. The Posting, Transactions, Transaction (Form View), and Labor Detail subtasks are also available for "drill-down" at various places in this inquiry. All of these subtasks for this screen are very similar to those of the G/L Inquiry screen. Please refer to the G/L Inquiry documentation for information on these subtasks.
Use this screen whenever you want to view summary actual and G/L budget data from the Budgeting menu in Costpoint General Ledger. Only transactions that were posted before the last execution of the Create General Ledger Report Tables process will be included in this screen. You must first post transactions and run the Create General Ledger Report Tables process before you can view current information in this screen and its subtasks.
If you want to narrow the rows shown in the table window to a specific fiscal year, select that fiscal year before executing the inquiry. If you do not select a fiscal year, all fiscal years that have general ledger activity will be shown. If you are interested in a range of fiscal years, use Subquery to select the desired range.
If you want to limit the rows shown in the table window to a specific account, enter that account before executing the inquiry. (You can also use Lookup to find the appropriate account number.) If you are interested in a range of accounts, use Subquery to select the desired accounts. If you do not enter an account or use Subquery, all accounts will be shown.
If you want to limit the rows that will display in the table window to a specific organization, enter that organization in this field before executing the inquiry. (You can also use Lookup to find the appropriate organization number.) If you are interested in a range of organizations, use Subquery to select the desired range. If you do not enter an organization or use Subquery, all organizations will be shown.
The fiscal year for this row displays in this field.
The account and account name for this row display in these fields.
These non-editable fields display the organization and organization name for this row.
The total actual year-to-date amount for this account/org displays in this column.
The total budgeted amount year-to-date for this account/org displays in this column. These budget amounts were entered via the Maintain Org/Account Budgets screen.
The total variance between the actual YTD activity and the budgeted YTD amount for this account/org displays in this column.
The total amount for the prior fiscal year for this account/org displays in this column
The last date that the Create General Ledger Report Tables process was run displays in this field. This indicates the last date that this information was updated for viewing in this inquiry. To see more recent data, you must run the Create General Ledger Report Tables process.
The total year to date balance displays in this field.
Select this pushbutton to access the detail, by period, of the actual and budgeted amounts.