Document Type

Link to Template

Usage Notes

Advance Deposit (AD)

Cash Receipt (CR)

Credit Card Receipts (CCR)

Disbursement Voucher (DV)

Distribution of Income and Expense (DI)

Internal Billing (IB)

Intra-Account Adjustment (IAA)

Pre-Encumbrance - encumbrance lines only (PE)

Procurement Card (PCDO)

Service Billing (SB)

Transfer of Funds (TF)

Year End Distribution of Income and Expense (YEDI)

Year End Transfer of Funds (YETF)

Standard_Import.xls

Disbursement Voucher (DV)

DV_Import.xls

Auxiliary Voucher (AV)

AV_Import.xlxs

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.xlxs

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.

General Error Correction (GEC)

Year End General Error Correction (YEGEC)

GEC_YEGEC_Import.xls

Indirect Cost Adjustment (ICA)

ICA_Import.xlxs

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.xlxs

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.xlxs

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.

Group Travelers (TA/TAA/TR)

Group_import.xlxs

Imports travelers into the Travel Authorization, Travel Authorization Amendment and Travel Reimbursement.

Event Attendees (ENT)

Attendee_List_import.xlxs

Imports event attendees into the Entertainment Reimbursement.