JV_NonOffset_Bal_Type_Import.xlxs

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

exclaim       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:

•      BB- Adjusted Base Budget

•      CB - Current 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 (fields listed in order required by template)

Column

Field Name

A

Chart Code

exclaim.gif    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

 

Amount

More:

JV_Offset_Bal_Type_Import.xls