/
Preparing the annual budget

Preparing the annual budget

approved

Access accounting data 

  1. Open COGNOS Finance.

  2. Select “GL Budget Statement Report”.

  3. Select the appropriate month.

  4. Select “No” for “Exclude Accounts with Zero Balances”.

  5. Enter Organization Number. You can type Registrar and use it to search. Click the carat and change it to “Contains any of these keywords”.

  6. Click the account you want included. Click Insert.

  7. Enter Account Number. You can type Registrar and use it to search. Click the carat and change it to “Contains any of these keywords”.

  8. Click the account you want included. Click Insert.

  9. Click “Finish”.

 

Exporting data 

  • Click the triangle icon

  •  Click “Run” in your preferred format. Excel is common.

 

Updating the budget  

  • Use data from previous year or more.

  • Go through Natural Accounts and base new budget on those accounts and the office goals.

 

Using the spreadsheet

  1. Make sure Annual/Template is up to date.

  2. Look up Rev & Expense data (Accessing accounting data).

  3. Fill in Columns.

    • Monthly Spending/Income= Period to Date 

    • Income/ Spending to Date= Year to Date 

    • Available Budget= Remaining 

  4. Make sure all rows are accurate and match.

 

 

Related content

Accessing financial reports in Cognos
Accessing financial reports in Cognos
More like this
Submitting expense reports in Concur
Submitting expense reports in Concur
More like this
3 Document the academic calendar process
3 Document the academic calendar process
More like this
Initiating an electronic interdepartmental transfer (EIT)
Initiating an electronic interdepartmental transfer (EIT)
More like this
Creating and updating the academic calendar (Drupal)
Creating and updating the academic calendar (Drupal)
More like this