General
Best Practices
Event Procedure
Helpdesk Request Form
Lab Closure Procedure
Links
Resource Drive Conventions
Resource Map
Shipping (FedEx)
Shipping (International)
Suggestion Box
Support Article Guidelines
Welcome
Information Technology
Email & Calendar
Add Calendars to iPhone
Confidential emails
Create a Shared Calendar
Create an Email Group
Email Filters & Rules
Email Groups
Email Headers
Email Signatures
Google 2-Step Verification
Google Calendar Overview
Phishing
Schedule emails
Staff Minus One Emails
Using Outlook with Gmail
Using Yubico Security Keys with your Google account
Print & Fax
Software
1Password
Adobe Acrobat DC
Adobe Creative Cloud
ArcGIS
Colby VPN
Combine PDFs in Adobe Acrobat
Excel Trust Settings
Install Falcon Antivirus
Microsoft Office
Mosyle Mac Enrollment
Raiser's Edge
Slack
Software Resources
Uninstall OpenVPN
Windows 10 - Restore from backup
Updates
2020 December - email name spoofing
2020 October - COVID resources
2021 December - WiFi
2021 January - Zoom recording + private chat
2021 March - NetSuite Google authentication
2021 March - VPN Upgrade
2023 - Zoom Updates
2024 May - VPN SSO
DNS
DNS Change
Data Storage and Computer Backups
Google Drive
HPCC and Storage Proposal Information
Laptop Recommendations
Loaner Hardware
Migrating data from Storage to Google Drive
Passwords
Phones
Restoring Files
Storage
VPN
VPN Migration
Vendor Access
Website Request
WiFi
Zeiss Digital Classroom
HR & Payroll
Paid Time Off
Payroll Overview & FAQ
Personnel Offboarding
Personnel Onboarding
Timesheet Approval (supervisors)
Timesheets
Facilities
BMS Access
Bigelow R/V Billing Form
E&I Wing Construction Update
R/V Bowditch Reservation Center
R/V Clarice Reservation Center
Finance
Admin
Budget & Reports
Invoicing
Policies & Procedures
Advancement Entry of Donations and Pledges
Corporate Traveler / Melon
Gas and Cryo-Supply Ordering Process and Form Link
Purchasing Flowchart - for staff reference
Purchasing Policy
Vendors Exempt from Purchase Orders
Proposals
Purchase & Expense
Bill/Invoice Approval
Creating a Bill to be Paid
Expense Report
Expense Report (example)
Non-Employee Reimbursement
Purchase Order
Purchase Order (example)
Purchase Order (supplemental)
Recurring Purchase Order (SRS)
Amazon.com
Approval Reminders
Business Office Orientation
Capital One - Corporate Credit Card
Customize Dashboard
Dashboard (SRS)
NetSuite FAQ
NetSuite Login
NetSuite shortcuts
Revenue Flow Chart
Workshop, Training Projects, and Participant Support Help
Computing
Software
AAI Calculation
ANI Calculation
AlphaFold
Anvi'o
Conda environments
Jupyter notebook
Prokka
RStudio
dada2
sag-mg-recruit
Job management
Charlie Overview
Connect to Charlie
Edit with VS Code
Getting Started
Monitor jobs
Software modules
Transfer files
Zoom
- Home
- Finance
- Budget & Reports
- Budget vs. Actual Report
Budget vs. Actual Report
Updated
Report notes
- This report shows project activity for the full time period that the project has been active.
- The current period and the year-to-date (ytd) information will always default to the current month you are in and the YTD total of the fiscal year. Those columns do not respond to the filter.
- The cumulative budget is loaded in Jul 2020 so to make the budget appear, that month must be included in the filter dates.
Generate report
- Click on the light blue "BLOS Budget vs. Actual" tile on the SRS dashboard
You can also search for "BLOS Budget vs. Actual" in the top search bar - Click the two upward-facing chevrons ︽ in the bottom right corner of the screen to expand the section
If the chevrons are facing down, skip this step - Click on the "program any of" dropdown and use CTRL + F to search for and select your project number
You can select multiple projects by holding the CTRL key while clicking - Select the desired time period (you can select single or multiple periods)
Date range information
The date range is the most important part for returning results.
Because we don't reuse projects, you can leave the "from" date set to P1 2012 (the earliest period available). It does not matter if the project didn't exist at that time.
The "to" date should be the time you want to see the project totals column to end.
Typically you will want to return results from the previous month end
Note that this is set for "Grant" budgets.
If you want to see this for your fiscal budget:
1. change the "budget category" to "fiscal"
2. change "from" time period to July of the current year - Click the blue "refresh" button at the bottom to run the report
If you see "no data available", try running with a different time range
Navigating the report
The report will open as an expanded version. You can use the collapse and expand buttons on the bottom right for easy viewing. Press the up arrow to collapse the report down to its highest level and then the down arrow twice to drill down to a summary level that will be easy to view. You can always drill down further if you want to expand the various levels.
To expand individual accounts, click the + button to the left of the accounts or click on the account numbers to "drill into" that account.
Report information
Report column | Description |
Financial Row | Chart of accounts is expandable by clicking the + to the left of the account |
Award Budget | Shows budget if one exists |
Current Period | Based on time filters |
YTD | Based on fiscal YTD. Up to the present month, regardless of filter. |
Project Total Amount | Total for time period selected |
Amount under/over | Award budget less the project total amount. Amount remaining in your grant award drawn by viewing the revenue (the business office generally draws revenue 10 business days after a month ends) |