Import fund updates via CSV to bulk edit funds

UXPROD-199 - Getting issue details... STATUS

Problem(s) to be solved

Libraries find it easier and/or more efficient to make batch updates to funds via file upload than doing such updates on a one-by-one basis. 

Requirements & use cases

RequirementStatusRollover-specific?PriorityUse cases
Library must be able to edit budget allocations for multiple budgets at one time

VERIFIED

Yes

HIGH

Administrator does not have allocation numbers for the new fiscal year at time of rollover. After rollover is completed the librarian needs to allocate money to all budgets in the new fiscal year. User downloads all budgets so they have a full picture of all funds on a particular ledger. Then updates numbers in spreadsheet and uploads all numbers to update values in Finances

Batch fund updates need to target specific FYs, not just current FY

VERIFIED

Yes

LOW

Library may want to upload budget numbers for planned budgets for the coming year. This would require us to have the ability to choose what fiscal year we are adding the budget information to.

Note: not all libraries allow for this to happen (Eg. Library of Congress)

Changes in current allocations need to be tracked and logged

VERIFIED

No

LOW

Mid fiscal year it is sometimes necessary to make updates to budget allocations. To do this we would export budgets and make changes to the necessary budgets. Uploading these changes would result in increases or decreases in allocation for the budget that were changed. 

Note: For most mid year adjustment the use of a spreadsheet could be overkill. Small changes/transfers are manageable on a fund by fund basis.

When changes are made to fund allocations, encumbrances and available balances need to be updated

VERIFIED

Yes

MEDIUM

Librarian 1 uploads a spreadsheet to update fund allocations near the end of the FY to allow for certain purchases to be made. Librarian 2 views fund information shortly thereafter to confirm available balances. Librarian 2 should see updated balances and transactions immediately (or as soon as is practical, based on load and processing time).
User must be able to review the result of allocation changes before committing them

VERIFIED

No

MEDIUM

User needs to confirm the change in allocation numbers will still add up correctly. Librarian will compare current budget numbers to the budget numbers after their changes before updating budgets permanently so they do not need to create additional transactions just to correct mistakes.

Often done even when updating manually. Reports are run as the allocation changes are being made in order to catch mistakes early.

User should be able to edit values from a downloaded CSV file and re-upload without changing columns, formats or labels

VERIFIED

No

LOW

Librarian downloads all budgets in order to update funds on a particular ledger. Then the librarian updates the numbers in that spreadsheet and uploads all numbers to update values. (Download format and upload format match).
It is possible for a helper app to be written to retrieve fund total based on fund type

VERIFIED


HIGH

Fund totals for certain fund types are used by helper applications to create commitments in accounts payable system. The helper app (PL1 scripts) receives the total funding number and creates an "LQ" commitment in the AP system.




LOW

It would be great also if allocations could be done by percentages of an overall amount as well as specific dollar amounts. When uploading to have a specific total and make updates based on the percentage.

Questions

QuestionStatusResolutionRemarks
What is the desired process for handling update via CSV when it would result in overencumbrance/overexpenditure? Should account for both overexpenditure allowed and overexpenditure disallowed.

OPEN



What is the desired process when there are other errors in the CSV (invalid fund, invalid FY, etc.)?

OPEN



Are you doing this in voyager

CLOSED


No we are manually adding the money in all Funds and then making transfers to the following continuing resolutions.
How are "Bulk" funds actually committed in momentum

CLOSED


These are retrieved by PL scripts similar to how orders are retrieved. Commitments are created in momentum for the full value of the Fund.

MODFIN-96 - Getting issue details... STATUS

UIF-126 - Getting issue details... STATUS