Creating a Budget Journal Spreadsheet

Summary

In this article, you will learn how to create a budget journal using a spreadsheet template.

Body

Overview

A budget journal spreadsheet can be used when many lines need to be entered. The spreadsheet provides a quick method of entry for all of the required values and simplifies moving from field to field for entry.

Processing spreadsheet journals is a process that consists of three steps.

Create the spreadsheet.
Import the spreadsheet into the UGA Financial Management System.
Submit the Budget Journal for approval and finalization.

This article will refer to the template file as “UGA Budget_Journal_Form”. There is only one file needed to create the budget journal spreadsheet. Templates may be obtained from the OneSource Knowledge Base at: https://onesource.uga.edu/resources/budget_journal_spreadsheet. It is recommended that you check the knowledge base often to ensure that you have the most recent version of the spreadsheet. Users are strongly advised to attend a training class or familiarize themselves with the following topics in the OneSource Training Library:

Creating a Budget Journal Spreadsheet
Importing a Budget Journal Spreadsheet
Submitting a Budget Journal Spreadsheet
Copying a Budget Journal Spreadsheet

In this article, you will learn how to create a budget journal using a spreadsheet template.

1. Step 1

First, log into UGA Financial Management System

Double-click on the UGA Budget_Journal_Form_.xls file from the folder where it is stored to open it.

2. Step 2

Click the Enable Content button if prompted.

3. Step 3

The template has two sections. Header detail is on the left and line detail is on the right.

You will only enter one header detail line for each journal. Line detail may require multiple lines.

Certain information is already defaulted.

4. Step 4

Enter your information into the available row under the Header Detail section.

Click the Business Unit drop-down list to select the appropriate Business Unit.

Example shown here: 18000.

5. Step 5

Enter NEXT into the Journal ID field to assign it the next available Journal ID number.

6. Step 6

The format for the Journal Date is MM/DD/YYYY.

Enter the appropriate date into the Journal Date field.

Example shown here: 8/22/2022.

7. Step 7

Click the Ledger drop-down list to select the correct ledger.

Budgets are not entered into the Actuals ledger. Use DEPT_REV to modify revenue budgets and DEPT_CHILD to modify expense budgets.

Example shown here: DEPT_REV option.

8. Step 8

Click the Budget Type drop-down list and select the Adjustment option. All other types are for Central Accounting use.

9. Step 9

The Header Description will help you identify your journal when doing searches in the UGA Financial Management System.

Enter the appropriate information into the Header Description field.

Example shown here: increase est. revenue.

10. Step 10

Scroll to the right to enter accounting ChartFields into the Line Detail section.

Budget transactions require Account, Dept, Fund, Budget Reference, Class, and Program. Operating Unit and Chartfield1 are optional. Project information is not allowed on Budget transactions. Project budgets are modified by SPA through the Grants Module.