Importing Accounting Lines into an Internal Billing

Staff can import Accounting Lines directly into any eDoc with fields for Accounting Lines.  

  1. Save the spreadsheet as a CSV file. 

  2. If you wish to do an import on both the income and expense sides, create two import files (one for each side).
    Tip: Save frequently used templates on your desktop for easy access. 

  3. Navigate to Internal Billing

  4. Click on the question mark symbol next to the Internal Billing heading.

  5. Under the "Overview" sub-menu, click Data Import Templates and choose the appropriate template for the eDoc.

  6. An Excel spreadsheet will open. Enter the Accounting Lines. The columns with red lines are required. 

  7. Enter the Accounting Lines. The columns with red headings are required.

  8. In the Amount column, change the format to General to remove any commas if any are present. This column should contain no commas. 

  9. Delete the first three lines of text.  

  10. Save the document as a CSV file.  

    1. Click on Save As.  

    2. From the drop-down menu next to Save as Type, select CSV (Comma delimited).  

    3. Click the Save button.  

  11. You may receive a prompt(s) like the one shown below. Click Yes for these prompts. 
     

  12. On the Accounting Lines tab, click the Import Lines button.  

  13. Click Choose File.

  14. Locate your CSV import files.  

  15. Click Open.  

  16. Click the ADD button next to the filename.

Doing so will complete the process. Your Accounting Lines will be successfully imported into your eDoc.  

Related Articles

Related content

Kuali Financials eDocs Quick Reference
Kuali Financials eDocs Quick Reference
Read with this
Importing Accounting Lines into a DI
Importing Accounting Lines into a DI
More like this
Departmental Funding Sources
Departmental Funding Sources
Read with this
Importing Accounting Lines (Budget)
Importing Accounting Lines (Budget)
More like this
Balance Inquiries Quick Reference
Balance Inquiries Quick Reference
Read with this
Completing a Distribution of Income and Expense (DI))
Completing a Distribution of Income and Expense (DI))
More like this