Links to Default Data Import Templates

The following table lists the types of e-docs for which templates are available in the default system along with links to the corresponding templates.

Data import templates by document type

Document Type

Link to Template

Usage Notes

Advance Deposits Document (AD)

Cash Receipt (CR)

Credit Card Receipts (CCR)

Disbursement Voucher (DV)

Service Billing (SB)

AD_CR_CCR_DV_SB_Import.xls

 

Auxiliary Voucher (AV)

AV_Import.xls

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 will be imported to the e-doc; the debit amount will not be imported.

Budget Adjustment (BA)

Year End Budget Adjustment (YEBA)

BA_YEBA_Import.xls

If an amount is erroneously entered in the Base Budget Adjustment Amount column, it is imported to the accounting line of the e-doc. An error is displayed when the data is validated via saving or submitting the e-doc.

Distribution of Income and Expense (DI)

Internal Billing (IB)

Pre-Encumbrance - encumbrance lines only (PE)

Transfer of Funds (TF)

Year End Distribution of Income and Expense (YEDI)

Year End Transfer of Funds (YETF)

DI_YEDI_IB_TF_YETF_PE_Encumbrance_Only_Import.xls

 

General Error Correction (GEC)

Year End General Error Correction (YEGEC)

 

GEC_YEGEC_Import.xls

 

Indirect Cost Adjustment (ICA)

ICA_Import.xls

Object code is automatically populated by an APC value

Journal Voucher (JV)- Debit/Credit amount entry, used for the following balance type:

EX - External Encumbrance

JV_Ext_Encumbr_Import.xls

Debit/credit amount entry, used for external encumbrance balance types. A journal voucher has three different accounting line formats, depending on its balance type. You must choose the balance type before importing. 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.

Journal Voucher (JV) - Single amount entry, used for the following Non-offset 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

JV_NonOffset_Bal_Type_Import.xls

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.

Journal Voucher (JV) - Debit/Credit amount entry, used for the following Offset 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

JV_Offset_Bal_Type_Import.xls

A journal voucher has three different accounting line formats, depending on its balance type. You must choose the balance type before importing. 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.

Labor Distribution Journal Voucher (LLJV)

LLJV_Import.xls

 

Non-Check Disbursement (ND)

ND_Import.xls

 

Pre-Encumbrance (PE) -disencumbrance lines only

PE_Disencumbrance_only_Import.xls

Disencumbrance lines only

Purchase Requisition (REQS) item import

PURAP_Item_Import.xls

This template imports line item data into the Items tab.

Purchase Requisition (REQS) and Purchase Order (PO) account import

PURAP_Account_Import.xls

The REQS and PO documents have no Accounting Lines tab, but clicking setup distribution in the Items tab opens an Accounting Lines section. This template imports account data into the Accounting Lines section.

Capital Asset Payment (MPAY) account import

CAM_MPAY_Account_Import.xls

Clicking setup distribution in the Items tab of the MPAY document opens an Accounting Lines section. This template imports account data into the Accounting Lines section of the Asset Payment and Asset Manual Payment menu items.

Budget Construction (BC) annual request import

BC_Annual_Request_Imports.xls

Imports annual data from one or more files into a Budget Construction document.

Budget Construction (BC) monthly request import

BC_Monthly_Request_Imports.xls

Imports monthly data from one or more files into a Budget Construction document.

Endowment Asset Decrease (EAD), Asset Increase (EAI), Liability Decrease (ELD), Liability Increase (ELI) transaction lines

KEM_EAI_EAD_ELI_ELD_Import.xls

Imports transaction line data into the Transaction Lines tab. Note that you must choose the appropriate tab (cash or non-cash) on the template before entering data.

Endowment Cash Decrease (ECDD), Cash Increase (ECI), and Cash Transfer (ECT) transaction lines

KEM_ECI_ECDD_ECT_Import.xls

Imports transaction line data into the Transaction Lines tab. Note that for ECT, you use the same template for both the To and From lines.

Endowment Security Transfer (ECT)

KEM_EST_import.xls

Imports transaction line data into the To section on the Transaction Lines tab.

Endowment Corpus Adjustment (ECA)

KEM_ECA_import.xls

Imports transaction data for KEMIDs. Note that you must select the appropriate import lines link to import increase or decrease transactions.

Endowment to General Ledger Transfer (EGLT)

KEM_EGLT_import.xls

Imports transaction data for KEMIDs and GL accounts. Note that you must choose the appropriate tab (From or To) on the template before entering data.

Endowment Holding Adjustment (EHA)

KEM_EHA_import.xls

Imports transaction data for KEMIDs. Note that you must select the appropriate import lines link to import decrease/increase transactions.

Endowment Unit/Share Adjustment (EUSA)

KEM_EUSA_import.xls

Imports transaction data for KEMIDs. Note that you must select the appropriate import lines link to import decrease/increase transactions.

General Ledger to Endowment Transfer (GLET)

KEM_GLET_import.xls

Imports transaction data for GL accounts and KEMIDs. Note that you must choose the appropriate tab (From or To) on the template before entering data.

Project Code Import

ProjectCode_Import.xls

This template imports a list of project code names and numbers into the Project Code e-Doc.

Sub-Account Import

Sub-Account_Import.xls

This template imports a list of sub-account names and numbers into the Sub-Account e-Doc.

Sub-Object Code Import

Sub-Object_Code_Import.xls

This template imports a list of sub-object code names and numbers into the Sub-Object Code e-Doc.

More:

Process Overview