240 likes | 335 Views
QCC Account Lookup & Finance Reports Budget Division by Coral Bowers Budget Contacts: Clarise Dilbeck Adelle Abad Coral Bowers Julie Fagundes October 2008. Log-In Screen. User Names & Passwords can be obtained by submitting a SRTS to BIS Support. Main Menu .
E N D
QCC Account Lookup &Finance ReportsBudget Divisionby Coral BowersBudget Contacts:Clarise Dilbeck Adelle AbadCoral BowersJulie FagundesOctober 2008
Log-In Screen User Names & Passwords can be obtained by submitting a SRTS to BIS Support
Main Menu Account Lookup has replaced Display Account Balance Screen
AccountLookup 1. Enter budget number you would like to lookup, use question marks “?” for wild cards 2. Click binoculars in upper left hand corner to display results of account lookup 3. Right click on account line to obtain: -Account Info -Account Activity (See next two slides)
Drill Down Capability Any item that highlights in yellow when hovered over with mouse can be clicked. More detail on transaction will appear. Typically, these are Purchase Orders (PO), Pay Vouchers (PV), Budget Transfers (BT), Budget (BG), Cash Transfers (TF) and Journal Entries (JE) .
Inspect Warrant Inspecting a warrant will show vendor number, warrant number, status of warrant, and warrant total
Finance Reports Access Budget Report & General Ledger Report via Finance Reports/Processes
Budget Report Writer Click Budget Report Writer
Budget Report Writer, cont. Open folder in upper left hand corner, called a “report preset”
Budget Report Writer, cont. Double click budget report you would like to retrieve
Budget Report Writer, cont. 1. Change dates for desired month or entire year. There is no need to change the other report options. 2. Click submit job icon 3. Close window
Budget Report Writer, cont. Return to QCC Main Menu and click Print Manager
Budget Report Writer, cont. 1. Budget Report should appear on list. Double click folder to view report. 2. Delete reports no longer needed by clicking the red “X” in the upper left hand corner
Sample Budget Report Report date range Budget summary Budget # Working budget Expensed amount for report date range Expensed amount year to date Encumbrances Balance of account =working budget less expenses and encumbrances
General Ledger Report Click General Ledger Report
General Ledger Report, cont. Open folder in upper left hand corner, called a “report preset”
General Ledger Report, cont. Double click general ledger report you would like to retrieve
General Ledger Report, cont. 1. Change dates for desired month or entire year. There is no need to change the other report options. 2. Click submit job icon 3. Close window
General Ledger Report, cont. 1. Return to Print Manager 2. General Ledger should appear on list of reports. Double click folder to view report. 3. Delete reports no longer needed by clicking the red “X” in the upper left hand corner
Sample General Ledger Report Report date range Budget summary Purchase order # Vendor Vendor # Warrant # Budget # Debits (generally expenditures) Credits