Salary Ledger Dashboard
- Brookebarton
- Rachel Cronn
Important Notes:
This report can be used to view payroll data and is used for historical payroll corrections and analysis.
The Salary Ledger Dashboard contains data for FY24 and prior. For data pertaining to FY25 and beyond, please view the Salary Data Report (beginning July 1, 2024).
You must have approved security access to run this report. To request access, have your supervisor submit a Help Desk Self-Service ticket with your name and the business purpose for your access.
If you export the Salary Ledger data, Excel downloads are limited to 50,000 rows. If your search results include more than 50,000 rows of data, you can export via CSV (limited to 250,000 rows).
If you download the data as CSV, follow the instructions linked in step 4 below for CSV exports and data formatting. If you do not reformat the CSV data, certain fields like the Accounting Period will display incorrectly on your export.
Step 1: Log in to Bronco Hub and Launch the Report
Access Boise State Reporting HR/Payroll and locate the Salary Ledger Dashboard report by entering Salary in the field to search by keyword.
Boise State Reporting will display the reports in either a List or Card view.
Change your view by selecting either List View or Card View in the upper navigation.
By default, this report launches with the category filter set to “All Reports”. If needed, update the Filter by Category drop-down to view reports specific to one area of reporting
Favorite commonly used reports by selecting Favorite in card view and the star icon in list view.
After locating the Salary Ledger Dashboard, select Launch on the report card or Launch located on the right side of the report name if you’re in list view.
If you need to request report access, submit an Access Request Form. When submitting the access request, include the name of the report and any other details that might be needed.
Step 2: Enter Search Parameters
Prior to searching for data, select Continue.
Enter data fields as appropriate. The Account and Accounting Date Between fields are required. Select Apply.
Step 3: Review Report Output and Export Results
For smaller exports (less than 50,000 rows) it is recommended that you export using Excel by following the steps below:
Select Page Options (the gear icon) in the top right corner.
Select Export to Excel and then select either Export Current Page to export the data displaying OR select Export Entire Dashboard to export current results.
End of Process
Export Large Amounts of Data (50k - 250k rows) via CSV
Scroll to the bottom of the page. Select Export, Data, CSV.
Open a blank Excel document.
From the blank Excel document, select File > Open > Browse
In the browse file window, update the File Type in the bottom right corner to “All Files” and select the CSV file you downloaded in the previous step.
Once you’ve located the file, select it and select Open.
A Text Import Wizard will display.
On step 1 of 3 of the Text Import Wizard, confirm Delimited is selected.
Select Next.
On step 2 of 3 of the Text Import Wizard, select Comma and un-check Tab located below the “Delimiters” section.
Select Next.
On step 3 of 3 of the Text Import Wizard, update the following fields from General to Text:
Accounting Period Name
Fund
Department
Cost Center
Account
Supplemental
Interfund
Project
Empl_ID
Position Number
Pay End Date
After updating all of the necessary fields to Text, select Finish.
Fields that must be formatted as Text: Accounting Period Name, Fund, Department, Cost Center, Account, Supplemental , Interfund, Project, Empl_ID, Position Number and Pay End Date
A CSV spreadsheet with your formatted data will populate. If you need to save the data, you must save the file as an Excel spreadsheet to keep the correct formatting.
To save the file, navigate to File > Save As > Excel Workbook.
End of process
Need help with the steps above?
Office of Continuous Improvement
oci@boisestate.edu
1910 University Dr. Boise, ID 83725-1247