Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColor#999999
titleColor#FFFFFF
borderWidth2
titleBGColor#085A9B
iconfalse
titleDESCRIPTION

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.

Access the Budget Ledger

  • In the Navigational Menu, choose the correct fiscal year and folder for which you want to view the ledger. Once the content area refreshes, hover on "Funding Information" in the menu header and click "Budget Ledger". 
  • This action will display the Budget Ledger screen for all projects under the selected heading. You will see a table listing your projects and their funding status, which is explained in the Budget Ledger Details section. 

Ledger Type

  • Regular: Displays funds allocated for the current fiscal year, representing the standard budget that is active for immediate use.
  • Carryover: Refers to funds from previous fiscal years that were not spent and have been brought forward to be used in the current fiscal year.
  • PY Deobligation: Displays funds from a previous fiscal year that were committed or obligated but are now being released or cancelled, making them available again.
  • Carryover - ER: Displays funds carried over from prior years that might have specific restrictions or a deadline for their use.  

Budget Ledger Levels

  • The Budget Ledger presents information based on the level you are viewing.   

    • Non-reporting-level folder: When you view the budget ledger on a folder that is not at the official reporting level, the table will list all the B&R codes within that folder and accurately calculate the columns for those codes.
    • Reporting-level folder: If you are viewing the budget ledger at the reporting-level folder, you have options to "group by" funds. You can choose to view funds by solicitation/project, agreement, or agreement with fund transfers. If you want to see funding amounts without including solicitation awards, deselect the checkbox to not Show Adjusted Totals Including Solicitation Award Values. When you are on the ‘unobligated carryover’ tab at a reporting level, you can also group by solicitation/project or agreement.
    • Solicitation-level: At the solicitation level, the budget ledger will show you all the B&R codes providing funds to the selected solicitation, any unawarded balance remaining on that solicitation, and all the agreements that received funds from the selected solicitation for each B&R code.
    • Project-level: The project budget ledger will list all the B&R codes that provide funds to your selected project. It also shows the balance remaining on the project that has not yet been broken down to an agreement, and all agreements receiving funds for that selected project for each B&R code. To see funding amounts excluding solicitation awards, deselect the checkbox to not Show Adjusted Totals Including Solicitation Award Values. You can "group by" options to view the allocation of funds by agreement or by agreement with fund transfers.
    • Agreement-level: When you view the budget ledger at the agreement level, you can choose to group by agreement or agreement with fund transfers, depending on the fiscal year. The agreement budget ledger will list all the B&R codes providing funds to your selected agreement. To see funding amounts excluding solicitation awards made to the agreement, deselect the checkbox to not Show Adjusted Totals Including Solicitation Award Values.

Budget Ledger Details

  • View: You have the option to deselect the "Show Text Columns" box to hide unnecessary textual columns, making the data easier to read.

  • Filter: To focus on specific programs, subprograms, or key activities, use the filter icon in the columns. Click it to reveal a dropdown list. Check the names you want to include in your filter and click "OK" to apply your changes. The table will refresh to show only the selected data. 
  • 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.

Frequently Asked Questions

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. 

Article: Understanding the Budget Ledger


Content by Label
showLabelsfalse
max5
showSpacefalse
cqllabel in ("budget","budget-period","cps","funding","cost-and-obligations")


Optics Button
macroIdtZQ4UtHlceCqB3iTmBs8s
dataJTdCJTIyYnV0dG9uVHlwZSUyMiUzQSUyMmljb25fbGVmdCUyMiUyQyUyMmJ1dHRvblNpemUlMjIlM0ElMjJtZWRpdW0lMjIlMkMlMjJidXR0b25UZXh0JTIyJTNBJTIyQ29udGFjdCUyMEhlbHBkZXNrJTIyJTJDJTIyYnV0dG9uUmFkaXVzJTIyJTNBNCUyQyUyMmJ1dHRvbldpZHRoJTIyJTNBMjAlMkMlMjJidXR0b25Db2xvciUyMiUzQSUyMiUyMzIwMzE1OWZmJTIyJTJDJTIyYnV0dG9uRm9udENvbG9yJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTJDJTIyYnV0dG9uQm9yZGVyQ29sb3IlMjIlM0ElMjIlMjMyMDMxNTlmZiUyMiUyQyUyMmJ1dHRvbkxpbmslMjIlM0ElMjIlN0IlNUMlMjJsaW5rJTVDJTIyJTNBJTVDJTIyaHR0cHMlM0ElMkYlMkZlZXJlc3lzdGVtaGVscC5lZS5kb2UuZ292JTJGc2VydmljZWRlc2slMkZjdXN0b21lciUyRnBvcnRhbHMlNUMlMjIlMkMlNUMlMjJzb3VyY2UlNUMlMjIlM0ElNUMlMjJkaXJlY3QlNUMlMjIlN0QlMjIlMkMlMjJidXR0b25OZXdUYWIlMjIlM0ElMjJ0cnVlJTIyJTJDJTIyYnV0dG9uTmV3TGluayUyMiUzQSUyMiUyMiUyQyUyMmJ1dHRvbkljb24lMjIlM0ElMjJtYXRlcmlhbC1kZXNpZ24lMkZDb250YWN0TWFpbCUyMiUyQyUyMmJ1dHRvbkhvdmVyQ29sb3IlMjIlM0ElMjIlMjNmZmZmZmYlMjIlMkMlMjJidXR0b25Cb3JkZXJIb3ZlckNvbG9yJTIyJTNBJTIyJTIzMjAzMTU5ZmYlMjIlMkMlMjJidXR0b25Gb250SG92ZXJDb2xvciUyMiUzQSUyMiUyMzIwMzE1OWZmJTIyJTJDJTIyYnV0dG9uSWNvbkhvdmVyQ29sb3IlMjIlM0ElMjIlMjMyMDMxNTlmZiUyMiUyQyUyMmlzQnV0dG9uU2hhZG93T24lMjIlM0F0cnVlJTJDJTIyYnV0dG9uSWNvbkNvbG9yJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTJDJTIyYnV0dG9uV2lkdGhEZXRlY3Rpb24lMjIlM0E0NiUyQyUyMmVtb2ppRW5hYmxlZCUyMiUzQWZhbHNlJTJDJTIyZW1vamklMjIlM0ElMjIlN0IlN0QlMjIlN0Q=