General Ledger FAQ
General Ledger - Custom Reports
| File Name | Description | Select | Input | Output |
| Glcus00 | Expenditure | Cur or Pre Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period Sub-Object, Fund, Category, Acct, Object | Acct, Budget, Expenditures, Unencumbered Bal, % of Budget Expended |
| Glcus05 | Last Year Expenditures | Individual or All Funds, Print 79% Y/N | Entity #, Fund, Heading Line | Line Item, Last Yr Expense, Cur Yr Bud, Proposed Bud |
| Glcus06 | VTSTOT Expenditure | Cur or Pre Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Range, Category, Dept, Acct, Object, Sub-Object | Acct, Bud, Cur Yr, Period, Expenditure, % of Bud Expended, Unemcumbered Balance |
| Glcus07 | VT School Status | Fund, Program, Last or Cur Yr Values | Revenue Code, Total Revenue | |
| Glcus10 | Budget Report | |||
| Glcus11 | VTHINE Budget Status | |||
| Glcus13 | Expenditure | Cur or Pre Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund, Category, Dept, Acct, Object, Sub Object | Acct, Original Bud, Adjusted Bud, $$ Spent this Month, $$ Spent to Date, $$ Left |
| Glcus15 | Special Trial Balance | Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Acct, Desc, Bud, Bal | |
| Glcus16 | Expenditure Worksheet for Schools | Fiscal Yr, # of Accts per page | Acct, FY, LY Bud, LY Actual, Cur Bud, Space for NY Bud and Comments | |
| Glcus17 | VTRAND Budget Worksheet | |||
| Glcus18 | Old Budget Report | Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | ||
| Glcus19 | Budget Status | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | ||
| Glcus20 | Comparative Expenditure | Fund | Dept Name & #, Current Bud, YTD Expend, % of Bud Expended, Prev Yr % of Bud Expended | |
| Glcus21 | VTRSWS Budget | Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | ||
| Glcus22 | Budget at Period Close | |||
| Glcus23 | Revenue & Expenditure | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund, Category, Dep, Acct, Object, Sub-Object | Acct, Est Rev & Exp, Rec/Spent to date, %Bud Rec/Exp to Date, Uncollected/ Unspent, Period Collected/Spent |
| Glcus24 | Budget | Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | ||
| Glcus25 | Budget | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | ||
| Glcus26 | Budget | Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | ||
| Glcus27 | Trial Balance | Normal, Combined or Combining | ||
| Glcus28 | VTTHET Budget | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | ||
| Glcus29 | Trial Balance for Dept | Cur or Prev Yr, Trial Bal Worksheet Y/N | Period | |
| Glcus30 | Revenue & Expenditure | Page Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period | |
| Glcus31 | VTTHET Comp Budget | Rev/Exp/Both, Page Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal,Acct # Y/N | ||
| Glcus32 | VTSVSU Expense | |||
| Glcus33 | Expenditures Statement | Fund | Purpose of Approp, Bud Exp to Date, Obligations to Date, Commited to Date, Bal to Date | |
| Glcus34 | Comparative Budget Worksheet | Rev/Exp/Both, Page Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category | Acct, LY Bud, LY Actual, Cur Bud, Space for Next Yr Bud |
| Glcus35 | North DakotaSchool Report | Co# & Name, Dist # & Name, Dist Type, Dept Code, Header Dates, #’s & % of Students & Activities | ||
| Glcus36 | VTSVSU Activity Acct Ledger | Cur or Prev Yr | Beg & Ending G/L Period, Acct #’s | |
| Glcus37 | VTWNES Budget | Skip Header Y/N, Suppress Detail, 0 Bal, Acct# Y/N | Fund, Program, Group, Function, Object, Sub-Object | Acct Desc, Orig Bud, Adjusted Bud, Encumbered, YTD Actual, Anticipated, Projected Bal, Creates Lotus Spreadsheet |
| Glcus38 | Checking Acct Reconciliation | |||
| Glcus39 | VTRSWS Expenditure | Cur or Prev Yr, Pg Break after Dept Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund, Category, Dept, Acct, Object, Sub-Object | |
| Glcus40 | VTMILT Expenditure | Cur or Prev Yr | Period, Fund, Category, Dept, Acct, Object, Sub-Object | |
| Glcus41 | Custom Report Generator | |||
| Glcus42 | Selected Sub-Object | Cur or Prev Yr, Date or Period | Sub-Object, Beg & End Date or Period | |
| Glcus43 | VTFWSU | Copy Existing Headers Y/N | Group, Section, Description | |
| Glcus44 | Year to Date Account Log for Iowa Chart of Accts | |||
| Glcus44a | Iowa Chart of Accounts | |||
| Glcus45 | Trial Balance | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund | Acct Desc, Bud/Est Revenue, Applied For, Rec/Exp to Date, Uncollected/ Unencumbered, MTD |
| Glcus46 | VTROCK Auditor Report | |||
| Glcus47 | VTROCK Auditor Report | |||
| Glcus48 | Revenue & Expenditure | Rev or Exp, Normal/ Combined or Combining, Cur or Prev Yr, Pg Break after Dept Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund, Category, Dept, Acct, Object, Sub-Object | Est Rev/Bud, Received/ Expended, % Rec/Exp, Uncollected/ Unencumbered Bal, Rec/Exp Period |
| Glcus49 | Budget Worksheet | Rev/Exp/ Both, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct Desc, Orig Bud, Adjusted Bud, YTD Actual, Place for Proposed Bud |
| Glcus49a | Budget Worksheet | Rev/Exp/ Both, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct Desc, Cur Bud, YTD Actual, Space for Dept Proposal, Manager Recommend, Select Approval |
| Glcus50 | VTARLT Budget Status | Incl NY Bud Proposed Y/N, Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Cur Bud, Cur Exp, Cur, Inc, Cur Actual, NY Bud (if answered Y) |
| Glcus51 | Expenditure | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Sub-Object, Fund, Dept, Acct, Object | Acct, Bud, Expenditure, Unencumbered Bal, Cur Per Exp, % Bud Spent |
| Glcus51a | Revenue | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Sub-Object, Fund, Dept, Acct, Object | Acct, Bud, Rev, Uncollected Bal, Cur Per Rec, % Bud Received |
| Glcus51b | Expenditure | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Sub-Object, Fund, Dept, Acct, Object | Acct, Bud, Cur Period, YTD Exp, Unencumbered Bal, % of Bud Spent |
| Glcus51c | Revenue | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Sub-Object, Fund, Dept, Acct, Object | Acct, Bud, Cur Period, YTD Rec, Uncollected Bal, % Bud Received |
| Glcus52 | Revenue | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Sub-Object, Fund, Dept, Acct, Object | Acct, Bud, Rev, Unencumbered, Cur Per, % Received |
| Glcus53 | Balance Sheet | Normal/ Combined/ Combining, Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Date, Period | Assets (positive), Liabilities (negative), Fund Balance |
| Glcus54 | Comparative Budget | Rev/Exp/Both, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, LY Actual, Cur Yr Bud, Revised Bud, Next Yr Budget |
| Glcus55 | Expenditure | Normal Combined/ Combining, Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Budget, Outstanding Encumbrances, Expenditures, Unencumbered Bal, % Expended |
| Glcus56 | Comparative Budget | Include Object Detail Y/N | LY Bud, LY Actual, FY Bud, YTD Committed, Anticipated, Total FY, Variance, NY Budget, % Change, Subtotal on Object | |
| Glcus57 | VTWCSU Budget Report | Rev/Exp/Both, Pg Break after Program Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund Program, Group, Function, Object, Sub-Object | Acct, Orig Bud, Adjusted Bud, Projected Actual, Variance, Encumbered, YTD Actual, Variance |
| Glcus58 | VTWCSU Comparative Budget | Rev/Exp/Both, Pg Break after Program Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Program, Group, Function, Object, Sub-Object | Acct, LY Bud, LY Actual, CurBud, NY Bud |
| Glcus59 | Budget Status By Program | Program | Acct, Orig Bud, Cur Bud, Enc/Acc, Exp/ Rec, Bal, % Exp/Rec, Total on Programs | |
| Glcus60 | VTFWSU Status Report | Fund, Function | Acct, Orig Bud, Cur Bud, Enc/Acc, Exp/Rec, Bal, % Exp/Rec | |
| Glcus60a | VTFWSU Budget Status by Group | Fund, Function | Acct, Orig Bud, Enc/Acc, Exp/ Rec, Bal, % Exp/Rec, Totaled on Group | |
| Glcus60b | Consolidated Budget Status | Fund, Function | Acct, Desc, Orig Bud, Enc/Acc, Exp/Rec Bal, % Exp/Rec | |
| Glcus61 | Posting Register | Cur/Prev Yr | Reference Range, Desc Range, Memo Search Word, Dates | Acct/Desc, Date, From Module, Transaction Desc, Ref, Debit/Credit |
| Glcus62 | Revenue & Expense | Rev/Exp/Both, Pg Break after Program Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Rev or Exp, Period, Fund, Category, Dept, Acct, Object, Sub-Object | Creates Lotus Spreadsheet in NEMRC Dir—Acct, Desc, Cur Bud, YTD Actual, Encumbered, Bud Bal |
| Glcus63 | Budget Status Worksheet | Rev/Exp/Both, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Orig Bud, Adjusted Bud, Encumbered, YTD Actual, Anticipated, Projected Bal |
| Glcus64 | Budget Worksheet | Rev/Exp/Both, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Creates Lotus Spreadsheet in NEMRC Dir—Acct, Desc, LY Bud, LY Actual, Cur Bud, Anticipated, NY Bud, % Budget |
| Glcus65 | Budget Transfer System | Enter Request, Del Request, Request Report, Approve Request, Reset, Exit | ||
| Glcus66 | CAREB Balance Sheet | Cur or Last Yr | Period | Acct, Desc, Bal, Subtotal by Object & Group |
| Glcus67 | CAREDB Revenue & Expenditure | Cur or Last Yr | Period | Acct, Desc, Bal, Subtotal by Object & Group |
| Glcus68 | CAREDB Expenditure | Cur or Last Yr | Period | Acct, Desc, Bal, Subtotal by Dept |
| Glcus69 | VTSHEL Budget Status | Rev/Exp/Both, Pg Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Bud, Actual, % of Bud, Yr to Date Last Yr |
| Glcus70 | VTFLET Comparative Budget | Rev/Exp/Both, Pg Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, LY Bud, LY Actual, % of Bud Used, Cur Bud, FY % Change |
| Glcus71 | VTBRIS Comparative Budget | Rev/Exp/Both, Pg Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Object, Sub-Object | Acct, LY Bud, LY Actual, Cur Bud, Rec/Spent to Date, NY Bud, % Change |
| Glcus72 | VTHIGH Budget Status | Rev/Exp/Both, Pg Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Bud, Actual, % of Bud, Bal |
| Glcus73 | VTARSU Budget Worksheet | Rev/Exp/Both, Pg Break after Fund, Pg Break after Program Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund | Acct, Orig Bud, Adjusted Bud, Anticipated, Projected Bal, Encumbered, YTD Actual |
| Glcus74 | VTSTAC Revenue & Expenditure | Rev or Exp, Pg Break after Fund Y/N, Pg Break after Dept Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | # of Copies, Period, Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Desc, Bud, YTD, Unexpended |
| Glcus75 | NJSOME Expenditures | Cur or Prev yr, Pg Break after Acct Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Bud, Outstanding Encumbrances, Expenditures, Unencumbered Bal, Grouped by Acct |
| Glcus76 | NMCIMA Budget | Rev or Exp, Pg Break after Fund Y/N, Pg Break after Dept Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Approved Bud, YTD Budget Adjustment, Adjusted Bud, This Quarter, Prior Quarter, YTD Bal, Available Bal |
| Glcus77 | VTDORS Budget Variance | Rev or Exp, Pg Break after Fund Y/N, Pg Break after Program Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Program, Group, Function, Object, Sub-Object | Acct, Des, Cur Bud, Cur Actual, This Period, Projected Variance % |
| Glcus78 | Consolidated Budget Status | Fund, Function | Acct, Desc, Orig Budget, Enc/Acc, Exp/Rec, Bal, % Exp/ Rec | |
| Glcus79 | Comparative Budget | Rev/Exp/Both, Pg Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Cur Bud, Next Year Bud |
| Glcus80 | VTLAMO Bucget |
|
Entity, Heading Line | Line Item, LY Exp, Cur Bud, Proposed Bud, No Inactive Accts |
| Glcus81 | Revenue & Expenditure | Rev or Exp, Incl Acct Notes Y/N, Pg Break after Fund Y/N, Pg Break after Dept Y/N, Skip Header Y/N, SupprDetail, 0 Bal, Acct # Y/N | Period, Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Bud, Last Yr Pd, Expenditures, Unencumbered Bal, Cur Yr Pd |
| Glcus82 | VTSTAC Detail Transaction | Cur or Prev yr, Assets, Liabilities, Rev, Exp, All Accts, Range, Single Acct, Transaction Type, Date or Period | Modules, Dates or Periods | Acct, YTD Posting Amt, Desc, Date, From Module, Desc, Ref, Debit/Credit, Totals |
| Glcus83 | Expenditure Grouped by Project | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund, Program, Group, Function, Object, Sub-Object | Acct, Bud, Outstanding Encumbrances, Expenditures, Unencumbered Bal |
| Glcus84 | Due To/From Balances | Acct #, Acct Desc, Acct Bal, Total | ||
| Glcus85 | Budget Status | Cur or Prev Yr, Rev/Exp/Both, Pg Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Budget, Actual, Bal |
| Glcus86 | CAGUST Revenue & Expenditure | Rev or Exp, Cur or Prev Yr, Pg Break after Fund Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Desc, Exp for Yr by Month, YTD Total, Budget, Remainder |
| Glcus86a | VTJAYT Monthly Expense & Revenue | Rev or Exp, Cur or Prev Yr, Pg Break after Fund Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Desc, Exp for Yr by Month, YTD Total, Budget, Remainder |
| Glcus87 | VTREAD Balance Sheet |
|
Period, Fund | Balance Sheet |
| Glcus88 | VTCONS Budget/ Expense Comparison | Suppress Bal Y/N, Suppress Acct #’s Y/N, Cur or Prev Yr, Subtotal on Fund/Dept Y/N, Subtotal on Function Y/N | Period | Function, Object, Sub-Object, Sch, Desc, Budget, Exp, Bal, Prev EYTD, Subtotal on Object |
| Glcus89 | VTBRAD Comparative Budget | Cur or Prev Yr, Rev/Exp/Both, Pg Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct, LY Bud, LY Actual, Current Bud |
| Glcus90 | VTMONT Budget Export | Type of Spreadsheet, Cur or Prev Yr | Spreadsheet Name, Period |
Exports to Spreadsheet in NEMRC Dir, Acct,
Desc, Per Bal, YTD Enc, LY Bal, Adjusted Bud, Unused Bud,
Cur Yr Final |
| Glcus91 | VTMONT Revenue & Expenditure Export | Cur or Prev Yr, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund, Category, Dept, Acct, Object, Sub-Object, Dept Name | Acct, Desc, Est Rev/Exp, Applied For, Rec/Spent to Date, Uncoll/ Unencumbered, Cur Yr Pd |
| Glcus92 | VTONSU Special Revenue & Expenditure | Rev or Exp, Cur or Prev Yr, Incl Acct Notes Y/N, Pg Break after Fund Y/N, Pg Break after Dept Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Period, Fund, Category, Dept, Acct, Object, Sub-Object | Acct, Bud, Projected Bud, Outstanding Encumbrances, Expenditures, Unencumbered Bal |
| Glcus93 | VTBFAC Detailed Transaction | Assets, Liabilities, Rev, Exp, All Accts, Range of Accts, Single Acct, Transaction Types, Date or Period | Modules, Beg & End Dates or Periods | Acct #, Desc, Date, From Module, Desc, Ref, Bud Debit/Credit, Enc Debit/ Credit, Acct Debit/Credit, LY Unused Bud, Bud, Encum, YTD Posting, Unexpended Bal, Pg Break on Subs |
| Glcus94 | VTWNES Expenditure | Cur or Prev Yr | ||
| Glcus95 | VTMONT Budget Maint | Cur Yr Bud, Anticipated Rev/Exp, NY Bud, LY Bud | Enter Acct # | Enter Figures by choosing each Acct # |
| Glcus96 | VTSVSU Budget Worksheet | Rev/Exp/Both, Incl Bud Entry Memos Y/N, Pg Break after Fund Y/N, Skip Header Y/N, Suppress Detail, 0 Bal, Acct # Y/N | Fund, Category, Dept, Acct, Object, Sub-Object | Acct Desc, Orig Bud, Adjusted Bud, YTD Actual, Anticipated, Projected Bal |
| Glcus97 | VTWNES Comparative Budget Report | Show Budget Notes Y/N | ||
| Glcus97a | VTWNES Comparative Budget Report | Show Budget Notes Y/N | ||
| Glcus98 | VTWNES Comparative Budget Export | Ready to Create Spreadsheet | Glcus98a | VTWNES Comparative Budget Export |
