Financial Processing Documents Accounting Line Imports
The following table lists the appropriate accounting line import templates for all Financial Processing documents except for the Journal Voucher and Pre-Encumbrance. They are detailed below.
NOTES:
- When importing files into documents with two accounting line sections -such as FROM / TO, a separate file for each section will need to be created and imported into the relevant section.
- Each file should contain no more than 400 lines.
Refer to the Import Lines - How To article for instructions on how to use the templates to load line items and/or accounting lines into a document.
Financial Processing Document |
Accounting Line Import Template |
Adjustment/Accrual Voucher | AV_Import.xlxs |
Advance Deposit | Standard_Import.xls |
Budget Adjustment | BA_YEBA_Import.xlxs |
Cash Receipt | Standard_Import.xls |
Credit Card Receipt | Standard_Import.xls |
Customer Invoice | INV_Import.xls |
Disbursement Voucher | Standard_Import.xls |
Distribution of Income and Expense | Standard_Import.xls |
Indirect Cost Adjustment | ICA_Import.xlxs |
Internal Billing | Standard_Import.xls |
Intra-Account Adjustment | Standard_Import.xls |
Non-Check Disbursement | ND_Import.xls |
Procurement Card | Standard_Import.xls |
Service Billing | Standard_Import.xls |
Transfer of Funds | Standard_Import.xls |
Year End Budget Adjustment | BA_YEBA_Import.xlxs |
Year End Distribution of Income and Expense | Standard_Import.xls |
Year End Transfer of Funds | Standard_Import.xls |
Journal Voucher Accounting Line Imports
The Balance Type Code determines which Accounting Line Import to use. Select the Balance Type Code before importing the accounting lines.
Balance Type Code |
Accounting Line Import Template |
A2- A21 Balances-Labor Ledger Only | JV_Offset_Bal_Type_Import.xls |
AC- Actuals (Balance Sheet) | JV_Offset_Bal_Type_Import.xls |
BB- Adjusted Base Budget | JV_NonOffset_Bal_Type_Import.xlxs |
CB - Current Budget | JV_NonOffset_Bal_Type_Import.xlxs |
CE- Cost Share Encumbrances | JV_Offset_Bal_Type_Import.xls |
EX - External Encumbrance | JV_Ext_Encumbr_Import.xlxs |
IE- Internal Encumbrance | JV_Offset_Bal_Type_Import.xls |
MB - Monthly Budget | JV_NonOffset_Bal_Type_Import.xlxs |
NB - Close Normal Balance | JV_Offset_Bal_Type_Import.xls |
PE - Pre-Encumbrance | JV_Offset_Bal_Type_Import.xls |
RE -Year-End Budget Reversion | JV_NonOffset_Bal_Type_Import.xlxs |
TR – Transfers | JV_Offset_Bal_Type_Import.xls |
Pre-Encumbrance Accounting Line Imports
The Pre-Encumbrance document has two sections in the Accounting Lines tab, only one section can be completed for each document. The section determines which accounting line import template to use.
Accounting Line Section |
Accounting Line Import Template |
Encumbrance | Standard_Import.xls |
Disencumbrance | PE_Disencumbrance_only_Import.xls |
Comments
0 comments
Please sign in to leave a comment.