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.

     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 format

Column	Field Name
A	Chart Code*     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	Line Description
I	Organization Reference Id
J	Amount*

More:

JV_Offset_Bal_Type_Import.xls