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

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 document; 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 document. An error is displayed when the data is validated via saving or submitting the document.

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 document; the debit amount is not imported.

Journal Voucher (JV) - Single amount entry, used for the following Non-offset balance types:

BB- Adjusted Base Budget

CB - Current 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

EX – External Encumbrance

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 document; the debit amount is not imported.

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

AR Customer

AR_Customer_Upload.xls

Creates new and updates existing AR customers.

Milestone Schedule

Milestone_Import_bulk_template.xlxs

Creates new and updates existing Milestone schedules. 

Predetermined Billing Schedule

PredeterminedBilling_Import_bulk_template.xlxs

Creates new and updates existing Predetermined Billing schedules.

PDP Payment Upload Spreadsheet

PDP_PaymentSpreadsheetUpload.csv

Upload spreadsheets with payments for processing by PDP.