Ad Hoc G/L Balance Sheet Fields and Field Descriptions:
The company codes to which you have access.
The name of the Company.
The Office Codes for each company to which you have access.
The name of the Office.
The code used to identify the type of Balance Sheet entry. Codes include A=Assets, L=Liabilities, OE=Owner’s Equity.
The name of the type of Balance Sheet entry. Types include Assets, Liabilities, and Owner’s Equity.
The code used to identify the category associated with the Account Type. Example: If the Account Type is Assets, the Account Category code may be AC=Current Assets, AF=Fixed Assets, AG=Goodwill, etc.
The name of the category associated with the type of account. Example: If the Account Type is Assets, the Account Category may be named Current Assets, Fixed Assets, Long-Term Assets, Goodwill, etc. Type your drop-down text here.
Part of the selected G/L Printing Scheme attached to codes in the G/L Chart of Accounts and used to limit the collection of information in adhoc reporting. This code is used in combination with Print Major and Print Minor Codes. Note: A Printing Scheme must be selected to show these codes.
Part of the selected G/L Printing Scheme attached to codes in the G/L Chart of Accounts and used to limit the collection of information in adhoc reporting. This code is used in combination with Print Category and Print Minor Codes. Note: A Printing Scheme must be selected to show these codes.
Part of the selected G/L Printing Scheme attached to codes in the G/L Chart of Accounts and used to limit the collection of information in adhoc reporting. This code is used in combination with Print Category and Print Major Codes. Note: A Printing Scheme must be selected to show these codes.Type your drop-down text here.
The code used to identify accounts set up in the General Ledger Chart of Accounts.
The name of accounts set up in the General Ledger Chart of Accounts.
The code used in combination with the Account and is generally used at an office level for more detailed reporting.
The name of the budget used to compare general ledger balances to budgeted amounts and display variances for the specified period.
The name of the budget used to compare general ledger balances to budgeted amounts between two different budgets and display variances for the specified period.
Data collected for the 11th month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 11th month prior is July 2006.
Data collected for the 10th month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 10th month prior is August 2006.
Data collected for the 9th month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 9th month prior is September 2006.
Data collected for the 8th month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 8th month prior is October 2006.
Data collected for the 7th month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 7th month prior is November 2006.
Data collected for the 6th month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 6th month prior is December 2006.
Data collected for the 5th month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 5th month prior is January 2007.
Data collected for the 4th month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 4th month prior is February 2007.
Data collected for the 3rd month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 3rd month prior is March 2007.
Data collected for the 2nd month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 2nd month prior is April 2007.
Data collected for the month prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month is May 2007.
Data collected for the current month based on the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the current month is June 2007.
Data collected for the month following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the following month is July 2007.
Data collected for the 2nd month following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 2nd month following is August 2007.
Data collected for the 3rd month following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 3rd month following is September 2007.
Data collected for the 4th month following the selected Fiscal Month/Year.. Example: If a June 2007 Fiscal Month/Year is selected, the 4th month following is October 2007.
Data collected for the 5th month following the selected Fiscal Month/Year.. Example: If a June 2007 Fiscal Month/Year is selected, the 5th month following is November 2007.
Data collected for the 6th month following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 6th month following is December 2007.
Data collected for the 7th month following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 7th month following is January 2008.
Data collected for the 8th month following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 8th month following is February 2008.
Data collected for the 9th month following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 9th month following is March 2008.
Data collected for the 10th month following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 10th month following is April 2008.
Data collected for the 11th month following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the 11th month following is May 2008.
Data collected for the 3rd quarter prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), data is collected for 3rd quarter prior to this quarter (July, August, and September of 2006).
Data collected for the 2nd quarter prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), data is collected for the 2nd quarter prior to this quarter (October, November, December of 2006).
Data collected for the quarter prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), data is collected for the quarter prior to this quarter (January, February, March of 2007).
Data collected for the Current Quarter based on the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, data is collected for the months of April, May, and June of 2007.
Data collected for the quarter following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), data is collected for the following quarter (July, August, September 2007).
Data collected for the 2nd quarter following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), data is collected for the 2nd quarter following this quarter (October, November, December 2007).
Data collected for the 3rd quarter following the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), data is collected for the 3rd quarter following this quarter (January, February, March 2008).
Data collected for the current year and based on the selected Fiscal Month/Year. Example. If a June 2007 Fiscal Month/Year is selected, data is collected for all months with totals for 2007.
Data collected for the current year’s months prior to the selected Fiscal Month/Year. Example. If June 2007 Fiscal Month/Year is selected, the balance forward data is collected for the months of January, February, March, April, and May.
Data collected for the current year’s months leading up to and including the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, year-to-date data is collected for the months of Jan, Feb, Mar, Apr, May, and June.
Data collected for the 11th month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 11th month/year prior to June 2006 is July 2005.
Data collected for the 10th month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 10th month/year prior to June 2006 is August 2005.
Data collected for the 9th month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 9th month/year prior to June 2006 is September 2005.
Data collected for the 8th month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 8th month/year prior to June 2006 is October 2005.
Data collected for the 7th month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 7th month/year prior to June 2006 is November 2005.
Data collected for the 6th month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 6th month/year prior to June 2006 is December 2005.
Data collected for the 5th month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 5th month/year prior to June 2006 is January 2006.
Data collected for the 4th month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 4th month/year prior to June 2006 is February 2006.
Data collected for the 3rd month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 3rd month/year prior to June 2006 is March 2006.
Data collected for the 2nd month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 2nd month/year prior to June 2006 is April 2006.
Data collected for the 1st month/year prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 1st month prior to June 2006 is May 2006.
Data collected for the month/year prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006.
Data collected for the 1st month/year following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 1st month following June 2006 is July 2006.
Data collected for the 2nd month/year following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 2nd month following June 2006 is August 2006.
Data collected for the 3rd month/year following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 3rd month following June 2006 is September 2006.
Data collected for the 4th month/year following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 4th month following this date is October 2006.
Data collected for the 5th month/year following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 5th month following June 2006 is November 2006.
Data collected for the 6th month/year following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 6th month following June 2006 is December 2006.
Data collected for the 7th month/year following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 7th month following June 2006 is January 2007.
Data collected for the 8th month/year following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 8th month following June 2006 is February 2007.
Data collected for the 9th month/year following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 9th month following June 2006 is March 2007.
Data collected for the 10th month following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 10th month following June 2006 is April 2007.
Data collected for the 11th month/year following the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, the prior month/year is June 2006 and the 11th month following June 2006 is May 2007.
Data collected for the 3rd quarter prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), the prior month/year is June 2006 (2nd fiscal quarter 2006) and the 3rd quarter months prior to the 2nd fiscal quarter 2006 are July, August, and September of 2005.
Data collected for the 2nd quarter prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), the prior month/year is June 2006 (2nd fiscal quarter 2006) and the 2nd quarter months prior to 2nd fiscal quarter 2006 are October, November, and December of 2005.
Data collected for the 1st quarter prior to the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), the prior month/year is June 2006 (2nd fiscal quarter 2006) and the 1st quarter months prior to 2nd fiscal quarter 2006 are January, February, and March of 2006.
Data collected for the prior year’s quarter. Example: If a June 2007 Fiscal Month/Year is selected (2nd quarter 2007), data is collected for the prior year’s 2nd quarter and includes the months of April, May, June 2006
Data collected for the 1st quarter following the month/year that is prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), the prior month/year is June 2006 (2nd fiscal quarter 2006) and the 1st quarter months following this quarter are July, August, and September 2006.
Data collected for the 2nd quarter following the month/year that is prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), the prior month/year is June 2006 (2nd fiscal quarter 2006) and the 2nd quarter months following this quarter are October, November, and December 2006.
Data collected for the 3rd quarter following the month/year that is prior to the selected Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected (2nd fiscal quarter 2007), the prior month/year is June 2006 (2nd fiscal quarter 2006) and the 3rd quarter months following this quarter are January, February, and March 2007.
Data collected for the prior year based on the selected Fiscal Month/Year. Example. If a June 2007 Fiscal Month/Year is selected, data is collected for all months of 2006.
Data collected for the same months in the prior Fiscal Month/Year. Example. If June 2007 Fiscal Month/Year is selected, the prior balance forward data is collected for the months of January, February, March, April, and May of 2006.
Data collected for the same months including the fiscal month in the prior Fiscal Month/Year. Example: If a June 2007 Fiscal Month/Year is selected, prior year-to-date data is collected for the months of Jan, Feb, Mar, Apr, May, and June of 2006.
Budget 1 totals for the selected Fiscal Month/Year.
Budget 1 totals for the month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for July 2006.
Budget 1 totals for the 3rd month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for August 2006.
Budget 1 totals for the 4th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for September 2006.
Budget 1 totals for the 5th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for October 2006.
Budget 1 totals for the 6th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for November 2006.
Budget 1 totals for the 7th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for December 2006.
Budget 1 totals for the 8th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for January 2007.
Budget 1 totals for the 9th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for February 2007.
Budget 1 totals for the 10th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for March 2007.
Budget 1 totals for the 11th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for April 2007.
Budget 1 totals for the 12th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for May 2007.
Budget 1 totals for the first quarter of the selected Fiscal Month/Year.
Budget 1 totals for the second quarter of the selected Fiscal Month/Year.
Budget 1 totals for the third quarter of the selected Fiscal Month/Year.
Budget 1 totals for the fourth quarter of the selected Fiscal Month/Year.
The total of all Budget 1 months for the selected Fiscal Month/Year.
The total of the Budget 1 months prior to and including the month of the selected Fiscal Month/Year.
Budget 2 totals for the month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for July 2006.
Budget 2 totals for the 3rd month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for August 2006.
Budget 2 totals for the 4th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for September 2006.
Budget 2 totals for the 5th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for October 2006.
Budget 2 totals for the 6th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for November 2006.
Budget 2 totals for the 7th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for December 2006.
Budget 2 totals for the 8th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for January 2007.
Budget 2 totals for the 9th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for February 2007.
Budget 2 totals for the 10th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for March 2007.
Budget 2 totals for the 11th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for April 2007.
Budget 2 totals for the 12th month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for May 2007.
Budget 2 totals for the month following the selected Fiscal Month/Year. Example: If a June 2006 Fiscal Month/Year is selected, data is collected for July 2006.
Budget 2 totals for the first quarter of the selected Fiscal Month/Year.
Budget 2 totals for the second quarter of the selected Fiscal Month/Year.
Budget 2 totals for the third quarter of the selected Fiscal Month/Year.
Budget 2 totals for the fourth quarter of the selected Fiscal Month/Year.
The total of all Budget 2 months for the selected Fiscal Month/Year.
The total of the Budget 2 months prior to and including the month of the selected Fiscal Month/Year.