This guide helps you navigate the Budget Ledger, a tool designed to give you a clear view of your project's financial status. We'll focus on how to use the Budget Ledger to understand your current year funds and any funds carried over from previous years. |
The Budget Ledger presents information based on the level you are viewing.
View: You have the option to deselect the "Show Text Columns" box to hide unnecessary textual columns, making the data easier to read.
Export: Click "Export to Excel" to edit and print the table's contents in Microsoft Excel.
Understand Each Category: To get a quick explanation of what each column in the Budget Ledger represents, hover your mouse pointer over a column heading. A pop-up will display a short description.
Adjusted Control: This category represents the total funds allocated by Congress, minus any adjustments made through a General Rescission, Reduction, or SBIR/STTR funding. This is a general, non-program-specific measure.
Project Guidance Prepared: This field displays the sum of all funds assigned to the project, plus the sum of all direct charges for the selected folder and its sub-folders. You assign funds to a project by creating a funding action for it.
Funding Action Approved: This field shows the funds that a budget analyst has authorized for a project by approving a program guidance letter in the system.
In Process: This field indicates funds corresponding to a funding action that has been sent to the Budget Analyst but has not yet been included in an approved Program Guidance letter. These funds are awaiting authorization.
Funds Awaiting Action: This is the balance of funds that have not yet been included in approved funding documentation. You can calculate this by taking the Adjusted Control minus Funding Action Approved.
Unplanned Amount: Unplanned Amount shows the remaining balance of funds that has not yet been planned. This means these funds have not yet been assigned through a funding action or a direct charge.
Actions: Choose an action to manage funds.
Create Funding Action: You can create a funding action for each project directly from the budget ledger, specifically for control/reporting level folders, provided the planned balance is not zero. Clicking this link takes you to the "Create Funding Action" form.
Direct Charges: Direct charges allow you to reserve or release funds.
Add: By clicking on the Add a Direct Charge link under Edit on the right side of a B&R Code, a budget analyst can reserve funds within that specific B&R Code. Reserving funds prevents other users from accessing those funds when preparing funding actions. You can add credits against a direct charge under Edit of a direct charge row. To create a direct charge, enter a new name in the provided space. Then, enter the amount you want the direct charge to reserve.
Debits: These can only be as large as the unplanned amount. The budget ledger will display these as a positive number in the "project guidance prepared" column, as these funds reduce the amount available for funding actions.
Credits: You must apply credits against an existing direct charge. The total sum of credits can only be as large as the amount of the associated direct charge. The budget ledger will display these as a negative number in the "project guidance prepared" column, as these funds increase the amount available for funding actions.
Click Save to Database to save your changes, or click Cancel to close the pop-up without saving.
Edit: To modify an existing direct charge, click the Edit link in the budget ledger row for that entry. This will open the pre-populated direct charge pop-up.
Delete: You can remove a direct charge from view by clicking the Delete link in its budget ledger row. Deleting a direct charge will also remove all associated credits. However, you can delete credits independently without deleting the direct charge itself.
Q: How do I quickly find the exact project I'm looking for in a large table?
A: Use the filter icon to refine your view. Click the icon, select the specific program, subprogram, or key activity you're interested in, and the table will refresh to show only those relevant rows. This helps you cut through the noise and quickly locate the data you need.
Q: I need to share this budget information with a colleague who doesn't have system access. What's the best way to do that?
A: Click the "Export to Excel" button. This allows you to generate a spreadsheet version of the table, which you can then easily share or print for review outside the system.
Q: The "Project Guidance Prepared" amount seems too high for my project. How can I investigate why?
A: The "Project Guidance Prepared" field sums all funds assigned to a project and direct charges. If it seems off, consider reviewing the funding actions created for that project or checking for any direct charges that might have been applied.
Q: I'm a budget analyst and I've sent a funding action, but the funds aren't showing up as "Funding Action Approved". What's happening?
A: If funds are not yet "Approved", they are likely in the "In Process" stage. This means the funding action has been sent to the Budget Analyst but has not yet been included in an approved Program Guidance letter. These funds are currently awaiting authorization.