Splitting Expense Charges Across Multiple ChartStrings

   Overview   

This article shows how to split expense charges across multiple charstrings by both percentage and dollar amount.  

For more information on the Expense Reports process, see the Creating an Expense Report and Submitting an Expense Report articles.

 

  1. Step 1

Expense Report General Information page displayed with the Accounting Defaults button highlighted

To split all charges between chartstrings based on percentages, use the Accounting Defaults option on the Expense Report General Information page.

Click the Accounting Defaults button.

 

  2. Step 2

Expense Report Default pop-up window displayed with the New Row [+] button highlighted

The Expense Report Default pop-up window is displayed along with any previously entered chartstring(s).

To add a new chartstring, click the New Row [+] button.

  3. Step 3

Expense Reports Defaults window displayed with the added row highlighted

A new blank row is added.

Note: Dept 74999999 must be updated to the appropriate Dept information.

  4. Step 4

Expense Reports Defaults window displayed with the Percentage column highlighted

The total of all rows in the Percentage % column must equal 100.00.

  5. Step 5

Expense Reports Defaults window displayed with the Percentage field highlighted

Enter the appropriate information in the existing chartsting Percentage % field.

Example shown here: 60.00

  6. Step 6

Expense Reports Defaults window displayed with the Percentage field highlighted

Enter the appropriate information in the Percentage % field for the added row(s).

Example shown here: 40.00

  7. Step 7

Expense Reports Defaults window displayed with the Bud ref field highlighted

Enter the appropriate information in the Bud Ref field.

Example shown here: 2024.

   Step 8

Expense Reports Defaults window displayed with the Fund, Program, Dept, and Class fields highlighted

Continue entering the appropriate information in the required Fund, Program, Dept, and Class fields.

Example shown here: Fund: 10000, Program: 16400, Dept: 19111FIB, Class: 11200.

Note: If using Project funds, Project ID, PC Bus Unit, and Activity information are required.

  9. Step 9

Expense Reports Defaults window displayed with the Done button highlighted

Once all the appropriate information has been entered,

click the Done button.

  10. Step 10

Expense Reports page displayed with the Update Details button highlighted

The Accounting Defaults information is updated with the number of chartstrings entered.

Example shown here:  2

To split expenses based on amount, click the Update Details button.

  11. Step 11

Expense Entry page displayed with the Date, Expense Type, Description, Payment, and Amount fields highlighted

Enter the appropriate information in the New Expense window.  

For more information on entering expenses, click here.

  12. Step 12

Expense Entry page displayed with the Date, Expense Type, Description, Payment, Amount, Merchant, Preferred Merchant, Billing Type and Receipt fields highlighted

Ensure that all required information including the Amount has been entered.

  13. Step 13

Expense Entry page displayed with the Accounting button highlighted

To split an expense by amount, click the Accounting button.

  14. Step 14

Expense Report Distributions pop-up displayed with the GL ChartField section highlighted

The Expense Report Distributions pop-up is displayed. 

Note: The Amount information is populated based on any percentage distribution information entered via the Accounting Details on the General Information page.

  15. Step 15

Expense Report Distributions pop-up displayed with the Add row + button highlighted

To add another chartstring, click the Add Row [+] button.

  16. Step 16

Expense Report Distributions pop-up displayed with the Amount field highlighted

The existing rows and values are displayed along with the new row.  

Note: The Amount information in the pop-up header and the total for all rows in the Amount fields must match.

  17. Step 17

Expense Report Distributions pop-up displayed with the Amount field highlighted

Enter updated information in the Amount fields for the existing chartstrings.

Example shown here: 400.00 and 200.00

  18. Step 18

Expense Report Distributions pop-up displayed with the Amount field highlighted

Enter the appropriate information in the Amount field(s) of the new row(s)

Example shown here: 108.13

  19. Step 19

Expense Report Distributions pop-up displayed with the Show All tab highlighted

With all Amount field information entered,

click the Show All tab.

  20. Step 20

Expense Report Distributions pop-up displayed with the Chartstring information highlighted

The full chartstring information is displayed for all distribution rows.

  21. Step 21

Expense Report Distributions pop-up displayed with the Fund, Program, Dept, Class , and Bud Ref fields highlighted

Enter the appropriate information in the required Fund, Program, Dept, Class , and Bud Ref fields.

Note: If using Project funds, Project ID, PC Bus Unit, and Activity information are required.

  22. Step 22

Expense Report Distributions pop-up displayed with the Done button highlighted

When all information has been entered in the appropriate fields,

click the Done button.

  23. Step 23

Expense Entry page displayed with the updated Accounting information highlighted

You are returned to the Expense Entry page, and the Accounting information is updated to reflect the number of chartstrings used for expense distribution.

  24. Step 24

Expense Entry page displayed with the Save button highlighted

Click the Save button.

You can continue adding Expense lines, making additional edits, or submit the expense report.

Additional Resources:

At this time, no additional resources are available for this topic.