For more information contact:
The Account Balances/Detail Application is a means of communicating financial information between University units. It provides WSU Budget Statement information which permits the comparison of commitments (expenditures and encumbrances) with allocations and revenues.
Such comparison assists deans, budget administrators, finance officers and principal investigators in monitoring and controlling each project’s financial activities.
Personnel should check online Account Balances/Detail or the hard-copy Budget Statement monthly to make sure recorded commitments to the account are an accurate reflection of actual commitments as documented by the responsible department.
The Controller’s Office encourages departments to use online Account Balances/Detail to review and control departmental financial activity. The online application provides more timely data and is less costly to departments than using and maintaining hard-copy Budget Statements.
Departments should request computer access to the Account Balances/Detail Application, also referred to as BALANCES (see BPPM 85.33). Online data available through this application reflect all financial transactions which have cleared the Controller’s Office by the end of the previous working day.
Account Balances/Detail provides the same information as Budget Statements. Much of the descriptive information about the online Account Balances/Detail included in this section (BPPM 30.07) also applies to the Budget Statement.
Hard Copy Distribution
When requested by University departments, the Controller’s Office authorizes the issue of hard-copy Budget Statements. Contact the Budget Statement Distribution Coordinator for details; telephone 509-335-2013. Departments are charged for hard-copy Budget Statements.
Departments and deans’ offices receive copies of the statement by the15th of each month. The statement reports transactions processed by the Controller’s Office through the last working day of the previous month.
Using Account Balances / Detail (BALANCES)
The responsible administrator (dean, chair, etc.) may delegate to a specific office group or individual responsibility for carefully monitoring assigned accounts.
Personnel may use the Account Balances/Detail (BALANCES) and project records to get a relatively current accounting of project allocations, revenues, encumbrances and expenditures. An accurate accounting of a project’s financial status is critical when the project is nearly out of money or when the end of the fiscal year or agreement period is near.
Refer to BPPM 30.06 for suggested reconciliation procedures.
The following pages provide descriptions and sample exhibits of all sections of the online Account Balances/Detail (BALANCES). Since the configuration of the Account Balances/Detail reflects departmental activities, a given department’s Account Balances/Detail may or may not include all of the described sections.
Certain data are printed at the top of each page.
Programs 0110, 15 and Up
For accounts in these programs Account Balances/Detail (BALANCES) headings include the following elements (Fig. 1).
The budget title indicated. The responsible budget administrator is also indicated in some report screens.
This is the budget number. The Budget Office assigns budget numbers (see BPPM 30.05).
Inclusive Dates of This Report
This period commences with the beginning of the current fiscal year and ends with the last business day of the indicated month.
Page (Budget Statements Only)
All of the project Budget Statements within a budget are issued together in project order within program. This number appears on the hard-copy Budget Statements only and simply indicates page number sequence within a given budget. It has nothing to do with the specific program or project.
This indicates the specific type of operating function within the University. Programs 1 through 10 are educational and general operating programs. Programs 11 through 14 are sponsored; 11 and 12 by federal agencies; 13 and 14 by nonfederal agencies. Auxiliary enterprises, service funds, scholarships, trust and agency funds are included in programs 15 through 19 (see also BPPM 30.05).
Each project within a given budget is assigned a unique number.
Project numbers under programs 1-10 and 15-19 are assigned by the General Accounting Section of the Controller’s Office.
All numbers are approved by Controller’s Office personnel to prevent duplication.
- Hard-Copy Budget Statement
Each unique project number initiates a new page; thus, each project’s complete Budget Statement can be separated if necessary.
The project title is indicated after the project number.
% of Period Elapsed
This is the percent of the current fiscal year which has elapsed.
The following data appears on the master account table for sponsored accounts in programs 11 through 14 only (Fig. 2).
Inclusive Dates of This Report
Statements for sponsored programs report data from the beginning of the agreement period to the last business day of the indicated month.
In most cases Sponsored Programs Services assigns project numbers when sponsored accounts are established; however, Sponsored Programs Services has designated blocks of project numbers for assignment by certain major University units.
The project title may be the sponsor’s name or initials or a short description of the research involved.
This indicates the beginning and termination dates for the project.
The name of the principal investigator(s) is printed below the project period. The principal investigator is responsible for all charges incurred during the project. (NOTE: Although the principal investigator is responsible for charges, he or she does not automatically have expenditure authority for the account. See BPPM 70.02 for delegation procedures.)
% of Period Elapsed
This is the percentage of the actual project period which has elapsed.
Project Summary to Date by Object
This report provides a concise summary of the current status of the project’s budget. All allocations, expenditures and encumbrances which have been processed between the commencement of the fiscal year or project period through the end of the indicated month are included. (See Fig. 3).
Object categories identify expenditure type. The object code and name are indicated on the left side of the page. Object categories are grouped differently on various types of Account Balances/Detail reports. See BPPM 70.09 for more information about objects.
The following descriptions of this section are divided into two major parts. The first part describes project summary reports for general University accounts in programs 01 through 10. The first part also describes those elements common to all Account Balances/Detail reports. The second part describes those aspects of project summary reports which apply to Account Balances/Detail reports for accounts in programs 11 and above only.
General University Accounts
General University accounts include those accounts in programs 1 through 10.
This column indicates the total amount allocated or budgeted for expenditure by object.
- Object Grouping
Objects 01, 02, 03, 04, 06, 11, 16, 19 and 21 are grouped and the operation subtotal is provided. A budget administrator can reallocate between these objects by notifying the Budget Office.
- Object 05
If the account is in fund 001, object 05 (computing) is not subject to object reallocation by the budget administrator.
- Object 00
Object 00 monies are usually allocated on the basis of positions assigned to the account.
- Object 07
Object 07 monies are usually allocated on the basis of employee benefit charges for positions assigned to the account.
Expended To Date
This column indicates the expenditures processed by the last business day of the previous month.
- Object 21
This object records transfers between accounts in programs 01 through 10. For vendor departments interdepartmental transfers (object 21) are recorded as a negative expenditure and are interpreted as transfers of funds into the account.
This column includes amounts that administrators have obligated but not yet disbursed. Encumbrances are carried forward from month to month until the designated expenditures are processed by the Controller’s Office. If a partial payment is made to a vendor, only the amount of the payment is liquidated from the original encumbrance. The balance of the original encumbrance remains encumbered until the remaining payments are made to the vendor.
- Object 00
Salaries (00) are encumbered to the end-date of the fiscal year, assignment, position, or appointment; whichever comes first.
A personnel action processed by Payroll automatically generates encumbrances in this object (see BPPM 60.25).
- Objects 03, 06 and 16
Goods and Services (03), Equipment–Capitalized (06), and Equipment–Noncapitalized (16)
Purchases from off-campus vendors are encumbered by issuance of a Purchase Order (see BPPM 70.13).
Subtract Expenditures and Encumbrances from Budget to calculate Balance.
Example for equipment (object 06):
Only those expenditures and encumbrances which cleared the Controller’s Office by the end of business on the previous day are indicated on the current Account Balances/Detail reports.
This is the percentage of the budgeted amount which was processed by the Controller’s Office as spent or encumbered by the final working day of the previous month. This figure is calculated as follows:
(Expenditures + Encumbrances / Budget) x 100 = Percentage Used
Budget administrators and principal investigators are encouraged to compare this figure (especially the total) with the percentage of time elapsed indicated at the top of each page. If the project’s percentage used to date greatly exceeds the percentage of time elapsed, a budget administrator or principal investigator might wish to carefully monitor future obligations.
Programs 11 and Up
All objects are totaled together (Fig. 4).
- Sponsored Programs
In programs 11 through 14 the indicated amounts are budgeted to each object by the sponsor’s agreement. Requests for changes in allocations are transmitted to Sponsored Programs Services. Sponsor’s approval may be required before an allocated amount is transferred. See rebudgeting procedures in BPPM 40.23.
- Programs 15 and Up
For programs 15 and above this is the amount allocated to an object for the fiscal year.
It is not necessary for the department to request object reallocation since expenditures are not limited to specified object allocations.
Revenues collected during the year are allocated to object 03, 08, or 15.
At the start of a new fiscal year, the previous year’s closing Balance is allocated to object 19 as the new year’s project Budget.
- Object 00
Salaries (00) are encumbered under sponsored programs (11-14) to the end-date of the applicable project, assignment, position, or appointment; whichever comes first.
- Object 07
Employee benefits (07) are encumbered under sponsored programs (11-14) to the end-date of the applicable project, assignment, position, or appointment; whichever comes first.
- Object 13
Facilities and administrative (F&A) costs (programs 11-14 only)
The amount encumbered is merely an estimate based on the F&A cost rate specified by the agreement multiplied by the estimated expenditures included in the base. The amount spent for F&A costs is the specified percentage of actual expenditures.
Project Summary To Date Revenue
This section provides a summary of revenue received or invoiced to date. (This section is not provided on Account Balances/Detail reports for state-funded accounts (fund 001) in programs 01 through 10.) (Fig. 5).
Revenue-This includes amounts received from sources of funding. (This does not include interdepartmental transfers which are recorded in object 21. See Object 21 above.)
- Programs 01-10, Fund 148-01
This is the projected revenue for the fiscal year.
- Programs 11-14
This is the award amount due from the sponsor.
- Programs 15 and Up
Differing methods are used for setting the Estimate.
Generally, this is the amount the project has received or invoiced, unless the revenue comes from a revenue pool account (RPA).
This is the amount currently due from the source. This is the amount received or invoiced (Revenue) minus the Estimate. The Variance is negative as long as the Estimate exceeds Revenue.
Personnel should report positive variances for sponsored projects (programs 11-14) to Sponsored Programs Services. This positive variance may result from an overpayment by the sponsor or from late allocation of funds by Sponsored Programs Services personnel when processing a new or recently renewed agreement.
This is the percent of the Estimate which the project has received from the funding source. This is defined as:
(Revenue / Estimate) x 100 = Percent
A project Balance is displayed for sponsored and self-sustaining accounts. The project Balance is Revenue received to date minus the total Expenditures.
Project Summary To Date By Subobject
This section provides more detail than Section 1. Budget administrators may use this section to help identify problem areas or to analyze expenditures. Objects are listed in numerical order with subobject codes listed alphabetically within object. Subobject titles are listed after the subobject codes.
Allocations are not made at the subobject level, thus nothing is shown in the Budget column by subobject categories.
Expenditures and Encumbrances are indicated at the subobject level (Fig. 6).
The Budget, Expenditures, Encumbrances, Balance, and Percentage Used (PCT) columns are all indicated at the object level, repeating data shown in Section 1.
Current Month Transactions–Operations
This section provides data to enable personnel to check or audit the Account Balances/Detail. (See BPPM 30.06 for reconciliation procedures.)
Each transaction for the month is indicated under the appropriate object with the subobject code listed in the first column Fig. 7).
This is the date the transaction was processed by the Controller’s Office.
Description or Payee
This is usually a vendor’s name or a description of what was encumbered.
Additions or subtractions in allocated amounts are listed under the appropriate object.
Expenditures for the month are listed in alphabetical order by subobject under the appropriate object.
Actual payments to vendors may differ somewhat from the encumbered amount. The original encumbered amount may be an estimate based upon a catalog price, or it may not include sales tax, shipping charges, or discounts.
The minus next to an amount in the Expenditure column indicates a recovery of expenditure which results in a gain of available funds within that object.
Encumbrances are listed in alphabetical order within subobject code under the appropriate object.
Encumbrances are carried forward until the obligated funds are spent or the encumbrance is cancelled.
Sponsored programs (11 through 14): Treatment of encumbrances at the project termination date varies with the agreement (see BPPM 40.03).
Programs 01 through 10: Encumbrances carry forward at the end of the fiscal year. Expenditures which correspond to carried-forward encumbrances are charged to new fiscal year dollars.
Encumbrances for salaries under sponsored programs (11-14) are based upon 174 hours a month. Actual salary expenditures are based on the number of hours worked divided by the actual total potential working hours for that month. Actual working hours may be more or less than 174; thus, the actual expenditure may vary somewhat from the encumbered amount.
- Salaries and Wages
Most transactions involving salaries (object 00) and wages (object 01) have an ID number. The first six digits are the position number. The last alpha character is the employment type code. Employment type codes are as follows:
C = Classified Employees
E = Administrative Professional
F = Faculty
G = Graduate Student
H = Nonstudent Temporary
R = Retiree
U = Student Temporary
- Other Objects
For other objects, the Controller’s Office assigns the ID number to identify the vendor when a disbursement takes place.
The fund designates the type of resource expended or allocated. A fund may have restrictions placed upon its use (see also BPPM 30.05).
The transaction type identifies the way a transaction is handled by the accounting system.
If the transaction type is odd (e.g., 51, 83, 91), the transaction is processed as a positive amount. If the transaction type is even (e.g., 52, 84, 92), the transaction is processed as a negative amount. Usually the even transaction type is the inverse of the odd transaction type.
Journal vouchers are used to make adjustments within the WSU accounting system. A transaction type that is described as journal vouchering another transaction type is simply adjusting a previous transaction. For audit purposes, the previous transaction is not changed.
The transaction types in the following table are found on Account Balances/Detail reports.
|01, 02||Cash Receipt--Records the receipt of cash.
|07, 08||Refund--Records a refund of revenue and operating transfer.
|11, 12||Original Allocation--Used to enter the original budget for the fiscal year or the project period.
|13, 14||Supplemental Allocation or Reallocation--Entered throughout the fiscal year or project period to cover allocation transfers to the account.
|15, 16||Computer Generated Allocations--Automatically created in the month-end processing of receipts. This is done only in certain accounts.
|17, 18||Balance Forward Allocation--Carries forward cash balances at the end of the fiscal year.
|21, 22||Journal Voucher--Corrects an original receipt or transfers revenue between accounts.
|27, 28||Journal Voucher--Used to transfer revenue between accounts or to cancel a refund check.
|51, 52||Encumbrance--Records an obligation or encumbrance against an account based upon an order which has been placed with a vendor or an expressed intention to purchase goods or services.
|55, 56||Encumbers salaries and wages
|57, 58||Encumbers employee benefits
|71, 72||Refund of Revenue
|85, 86||Expenditure-Payroll System--Records payments for salaries, wages or retirement supplementation.
|87, 88||Compensating Tax Accrual--Records the sales tax payable on a purchase from a vendor who does not collect sales tax as a part of the invoice total.
|91, 92||Expenditure Journal Voucher--Corrects the account coding of a previous expenditure or transfers expenditures between accounts.
|93, 94||Check Cancellation--Cancels a check written to the wrong vendor or for the wrong amount, e.g., duplicate payment, payment for out-of-stock item.
|97, 98||Recovery of Expenditure--98 records the recovery of a prior expenditure. It also records a transfer from another department in object 21. 97 records an increase of expenditure.
|A1, A2||Accounts Receivable--Records a receipt processed through the Billing Receivables System.
- Document, Reference Numbers
These numbers refer to documents associated with a transaction.
- Doc. No
This is the number of the document which directly initiated a transaction shown on the Account Balances/Detail reports.
- Ref. No
Usually this is the number of the document which initiated a previous step in the expenditure procedure, e.g., field order. Sometimes a reference number is assigned to further identify the transaction, e.g., a Request for Shipment of Merchandise number.
For allocations or transfers listed as entries in the budget column, nothing is indicated under document number. The budget journal voucher number is indicated under reference number.
- Salaries and Wages
Expenditures for salaries (object 00) and wages (object 01)-The reference number indicates the month worked and the fraction of total staff-months the expenditure represents, e.g., FEB 0.18.
Salaries–The reference number indicates the date through which the salary is encumbered.
Other objects–No reference number is shown. The document number is the field order or contract number.
- Employee Benefits
Expenditures for employee benefits (object 07)–The reference number indicates the date of the expenditure.
- Telephone Rental
Expenditures for telephone rental (object 11) or telephone tolls (object 03)–The reference number is the billing month.
- Number Prefixes
Most document and reference numbers are numeric (other than exceptions noted above) with an alpha character prefix. The alpha prefix identifies the type of document involved. The following prefixes have been assigned:
B. Budget journal voucher BA. Blanket Purchase Order C. Contract CC. Computer Benter IRI CR. Confirming Requisition D. WSU Receipt E. Emergency orders F. Field order H. Departmental requisition I. Interdepartmental Invoice (Service Center automated billings only) J. Income journal voucher K. Departmental purchase order M. Olympia requisition MS. Mailing Services N. Olympia purchase order P. Payment Request P. State printer requisition R. Receipt S. Salary and benefits encumbrance (document number only) S. Slip number (similar to a packing slip number) (reference number only) T. Transportation Request U. Purchasing card transaction line V. Payroll batch number X. Requisition number Z. Purchasing Blanket Order Blank Interdepartmental Requisition and Invoice (IRI)
Project Summary To Date
This section shows receipts by source/subsource (Fig. 8).
Source codes are listed for receipts with a source description.
Current Month Transactions–Receipts
This section details receipt activities for the month of the report (Fig. 9).