JV_NonOffset_Bal_Type_Import.xls

The JV_NonOffset_Bal_Type_Import.xls template applies only to Journal Voucher (JV) - Single amount entry, used for non-offset balance types.

Warning! A Journal Voucher has three different accounting line formats, depending on its balance type. You must choose the balance type before importing.

Use this template for the following balance types:

AS- Actual Statistics

BB- Adjusted Base Budget

BS - Budget Statistics

CB - Current Budget

JB - July 1 Budget

MB - Monthly Budget

RE -Year-End Budget Reversion

The basic format of the template is shown below.

JV_NonOffset_Bal_Type_Import template formats:

Column

Field Name

A

Chart Code*

Warning: If your institution has set the ACCOUNTS_CAN_CROSS_CHARTS_IND parameter to NO, delete this column before using the template.

B

Account Number*

C

Sub-Account Number

D

Object Code*

E

Object Type Code

F

Sub-Object Code

G

Project Code

H

Organization Reference Id

I

Amount*

More:

JV_Offset_Bal_Type_Import.xls