JV_Offset_Bal_Type_Import.xls

The JV_Offset_Bal_Type_Import.xls template applies only to Journal Voucher (JV) - Debit/Credit amount entry, used for 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:

A2- A21 Balances-Labor Ledger Only

AC- Actuals (Balance Sheet)

CE- Cost Share Encumbrances

IE- Internal Encumbrance

NB - Close Normal Balance

PE - Pre-Encumbrance

TR - Transfers

The basic format of the template is shown below.

JV_Offset_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

Debit*

J

Credit*

Note: An amount is required in either the Debit or Credit column for each accounting line. If amounts are erroneously entered in both Debit and Credit fields on an accounting line, only the credit amount is imported to the e-doc, the debit amount is not imported.

More:

LLJV_Import.xls