Import the Manual Encumbrance


In this lesson you will learn how to import the manual encumbrance.


Steps:

  1. Click the State of Nebraska link.

    Step 1
  2. Click the Budget link.

    Step 2
  3. Click the Enter/Adjust Manual Encumbrances link.

    Step 3
  4. Click the Enter/Adjust Manual Encumbrances link.

    Step 4
  5. Click the Add button.

    Step 5
  6. Enter "J9" into the first Doc Type/No/Co field.

    Step 6
  7. Click in the G/L Date field.

    Step 7
  8. Enter the G/L Date into the G/L Date field. 

     

    For this lesson enter "5/25/10".

    Step 8
  9. Click in the Explanation field.

    Step 9
  10. Enter an explanation into the Explanation field. 

     

    For this lesson enter "Training Example".

    Step 10
  11. Enter the Account Numbers and Amounts in the grid.

     

    Note: If you have few business units or lines to enter, you can enter these manually. Otherwise, you can import the data from a spreadsheet.

    Step 11
  12. To import a spreadsheet click the Import Grid Data button.

    Step 12
  13. Click the Browse... button.

    Step 13
  14. Browse to the file you want to import and click on it.  

     

    For this lesson click the Training Example.xls list item.

    Step 14
  15. Click the Open button.

    Step 15
  16. Click in the Worksheet name: field.

    Step 16
  17. Enter the name of the spreadsheet into the Worksheet name: field.  

     

    For this lesson enter "July Payroll".

    Step 17
  18. Click in the Starting Column field.

    Step 18
  19. Enter the starting column into the Starting Column field. 

     

    For this lesson enter "A".

    Step 19
  20. Click in the Starting Row field.

    Step 20
  21. Enter the starting row into the Starting Row field. 

     

    For this lesson enter "1".

    Step 21
  22. Click in the Ending Column field.

    Step 22
  23. Enter the ending column into the Ending Column field. 

     

    For this lesson enter "B".

    Step 23
  24. Click in the Ending Row field.

    Step 24
  25. Enter the ending row into the Ending Row field. 

     

    For this lesson enter "62".

    Step 25
  26. Click the Apply button.

    Step 26
  27. Note: The account number and the amount should be sufficient to populate the transaction, so these are the only lines imported. It is important to review the journal entry for any credit transactions that may be in the original payroll. These would need to be changed.

    Step 27
  28. Click the Continue button.

    Step 28
  29. Click the OK button.

    Step 29
  30. Remember, the Remaining Amount will not be zero. Manual Encumbrances are a one-sided entry.

     

    Note: Remember to approve and post the transaction.

     

    Note: The encumbrance will appear on the allotment status and budget status reports.

     

    Note: After encumbrances have been certified, void, approve, and post the batch.

    Step 30
  31. Click the Cancel button.

    Step 31
  32. Click the Close button.

    Step 32

You have successfully completed this lesson.

Table of Contents  Start Topic