Skip to main content

Budget Spenddown Tracking

Learn how Instrumentl can help your team streamline budgeting your awarded grants & track expenses

Written by Rebecca Huber
Updated this week

Instrumentl is committed to being your all-in-one platform for the full grant lifecycle—this includes post-award management! We know Grant Managers and Program Teams need a streamlined way to monitor grant finances, which is why we offer Budget Spenddown Tracking.

Note: Budget Spenddown Tracking is a feature exclusive to the Professional and above.


Overview

Simplify the financials for your organization's fundraising efforts. Jump ahead to a section by clicking one of the three components of Budget Spenddown Tracking below:

I. Expense Categories: Organize your awards into different areas of spending.

II. Add Expenses: Import expenses in bulk or enter them one-by-one.

III. Spenddown Tracking: Monitoring spend at the award and project levels

Value Add

Instrumentl's Budget Spenddown feature is tailored for managing expenses through the grant management lens. View your spend metrics with in-depth and at-a-glance charts and visuals. Increase financial visibility for grants, streamline communications and save valuable time!

Spenddown helps your organization spend within your award budget, reducing financial mismanagement risks:

  • Reduce manual work: Your Finance Team and others at your organization can see grant spending, eliminating the need for frequent back-and-forth requests.

  • Improve expense attribution accuracy: Grant managers can verify grant-expense attribution to ensure it's reconciled appropriately!

  • Simple budget checks: Quickly see whether you're veering off track or staying on pace with expected expenditure.

  • Focus on grants: Managing your budget within Instrumentl simplifies tracking grant expenses compared to heavier accounting tools that provide broader, irrelevant data.


Expense Categories

Create an Expense Category

Once you've been awarded your grant, you'll want to add Expense Categories to your budget. First, ensure the opportunity is in the Awarded Status:

Next, open the opportunity from the Tracker or Awards View and navigate to the 'Financials' tab within the saved grant page.

Under 'Budget & Expenses', select + Add Expense Category.

This will trigger a window to pop up on the right-hand side of your screen. Enter the category's Name (required field) as well as Description and Amount Budgeted (both optional):

Once finished, click Save at the bottom:

Edit an Expense Category

You can always add or make changes to the Description and Amount Budgeted later, as well as rename the category by selecting Edit from the Category Actions menu (three-dot button on the far-right):

Delete an Expense Category

If you wish to remove a category from your budget, select Delete from the Category Actions menu (see below).

Note: When you delete an Expense Category with 1 or more expenses added to it, you both the category and all its expenses will be permanently erased from your budget.


Add Expenses

Manually enter expenses

Once you've created an Expense Category, you can select + Expense to enter an individual expense manually from the Category Actions dropdown menu.

Alternatively, you can open the + Add Expenses dropdown menu and select + Add an expense. With this workflow, you need to select the category in the next step.

You'll see the following 'New Expense' window appear from the right-hand side. Enter the Transaction Date and Amount, and then choose a Category, if not populated already (all required fields). You may also enter a Description, Notes and a Transaction ID.

Note: The Transaction ID will not be visible when looking at the budget in the 'Financials' tab of the award (unless editing the expense). This field is, however, included in the Financials Report.

When finished, click Save.

Your new expense will be slotted within the designated category in chronological order of Transaction Date. The budget view of expenses displays the Transaction Date, Description, Notes and Amount.

Import expenses

Save time and add your expenses in bulk by importing an expense spreadsheet into Instrumentl. You can simply generate a CSV or Microsoft Excel (.xlsx) file from your current accounting software, such as QuickBooks, Sage, MIP, Financial Edge NXT, etc.

Circular image showing that all accounting tools, such as Quickbooks, Financial Edge NXT, Sage, MIP, Jenzabar, and more are all compatible with Instrumentl.

Prepare a spreadsheet

1. Change the opportunity's Status to Awarded and navigate to the 'Financials' tab.

2. Next, open the + Add Expenses dropdown menu and select Import expenses.

3. Open the Expenses Import Template in Google Sheets > File > Make a copy.

4. You can copy & paste data from your accounting software into your copy of the Google Sheets template. (Be sure to delete row 2 of sample data!)

5. Download the Google Sheet as a .csv/.xlsx file, or you can first download the template as a .csv/.xlsx file and then enter your expense data into said file.

Spreadsheet Formatting Requirements

❗ Your expenses spreadsheet must be formatted exactly as in the template.

  • Each Transaction ID must be unique (no repeated values in this column).

  • Pay close attention to the Date and Actual Amount formatting.

  • Every row & column must be filled. You cannot leave any field blank.

  • Delete any additional columns not included in the template, which is especially important if you choose to download a .csv/.xlsx file from your accounting software as your starting point.

When your spreadsheet is ready, go back to the Financials page under the 'Import Expenses' tab (follow step 2 above or navigate to Account > Financials)

➡️

The import process is organized into four sequential stages.

Stage #1: Import

Click Select Expenses File.

Upload your CSV/Excel spreadsheet > click Next.

Stage #2: Map Awards

Select the Instrumentl Award(s) from the dropdown menu, ensure your Amount Awarded is accurate, then click Next.

Note: You can include expenses for multiple awards in a single import.

Stage #3: Set Budgets

Map each "Org Expense Category" from your spreadsheet import to a Grant Expense Category in your Instrumentl award budget. If you haven't already created the categories you wish to assign to the expenses in this import, you can create new Expense Categories at this stage.

Enter a Budgeted Amount for each Expense Category > select Import Expenses.

Check that your spreadsheet was imported accurately. Notice any mistakes? Start Over. Everything looks good? Go To Awards View.

🎊 Congrats! You've finished the expense import. Now view your expense data in your award's 'Financials' tab under the section 'Budget & Expenses':


Expense Actions

In order to make any changes to expenses in your Budget, expand the relevant Expense Category to view its expenses by clicking the dropdown arrow 🔽

Next, open the Expense Actions menu (three-dot button on the far right) for the expense you wish to modify.

Edit an expense

To edit an expense, open the Expense Actions > select Edit.

An 'Edit Expense' window will open from the right-hand side with the same fields as when manually entering a new expense.

Recategorize an expense

Move an expense to a different Expense Category from the 'Edit Expense' window under Category. Open the dropdown options and scroll/search for the category where you wish to reassign this expense.

"Bulk" editing/recategorizing of expenses is not supported at this time.

Note: You cannot transfer an expense from one award to another.


When you're finished making changes, select Save (or Cancel to undo edits).

Delete an expense

To delete an expense, open the Expense Actions > select Delete.

Alternatively, you can select Delete Expense from the 'Edit Expense' window.

To "bulk delete" expenses, you can delete an Expense Category to remove all expenses assigned to it. Apart from this action, there is no other way to delete multiple expenses simultaneously.

Ignore an expense

If you wish to include an expense in your budget, but not count it toward your spenddown tracking, you can "ignore" it. From the Expense Actions menu, select Ignore.

When you've ignored an expense, you will still see it listed in your budget and Expense Category just as before, except for three things:

  1. The expense text will be slightly faded in grey to differentiate it from "non-ignored" expenses.

  2. You'll see an 'Ignored' badge in the expense line (circled in green below).

  3. The ignored expense amount will not be factored into the $ amount spent across all financial metrics:

    Expense Category

Overall award budget

Project spenddown

. ➡️

Unignore an expense

To revert an ignored expense back to its original, default state, select Unignore from the Expense Actions menu. This will result in the expense transaction amount affecting the calculation of the total amount spent across all financial metrics.


Spenddown Tracking

Track spend at the Project level

In the Awards View, your dashboard displays how your Spenddown is tracking.

It defaults to showing the percentage (%), but hovering your cursor over the percentage metric shows both the amount Available and the Total spent ($).

You'll also see both a Payments and Spenddown column in your Awards View, allowing you to track award spend (as well as the payments received from the funder*).

*Learn more about Payments Tracking.

Monitor spend at the Award level

Within an awarded grant's 'Financials' tab, you'll find an 'Overview' section. This includes the amount awarded, spent and remaining. It also visualizes your tracking during the grant period. The On Track and Off Track icons are calculated based on the amount you've spent thus far and where you are in the grant period.

🆚

If you see Untracked, you need to add a Start & End date in the 'Overview' tab of the saved grant (not to be confused with the 'Overview' section described above).

⬇️

Track budgeted Expense Categories

Scroll down further in the 'Financials' tab to view a breakdown of your award spend by Expense Category. Each category has its own graph showing the $ and % of how much is spent and the remaining amount allocated.


Budget Spenddown Tracking eliminates uncertainty about grant financials with intuitive visuals to support smarter decision-making. We’re excited to continue improving Instrumentl's post-award management capabilities!


FAQs

How does this feature differ from other financial tracking tools?

Unlike other large-scale software, Instrumentl is tailored specifically for Grant Managers. We focus on usability and effectiveness in grant management versus overall accounting. We have a unique visual approach to financial tracking that sets us apart from traditional, number-heavy tools.

Can I just manually add a budget without importing a spreadsheet?

Yes! The spreadsheet template is just used for importing expenses. You can go ahead and start adding budgets for any saved grant in an Awarded Status. This will help you keep track of grant budgets and enable you to compare the budget vs. actuals as you add expenses. Moreover, you can now add expenses manually, one at a time!

Can I add Subcategories within the Expense Categories?

Sub-categories for expenses are not formally supported at this time, but there are two workarounds. Let's use an example of a desired "parent" category of 'Supportive Services' and "sub-categories" of 'Food' and 'Life Skills'.

  1. Create Expense Categories for each "sub category" and label them as 'Supportive Services - Food', 'Supportive Services - Life Skills.'

    1. You would need to manually add each of these "subcategories" (that are actually Expense Categories technically) to get the total 'Supportive Services' "Parent" category sum.

  2. Create a single Expense Category 'Supportive Services', and for each expense, add the "subcategory" name as the Description ('Food', 'Life Skills').

    1. You would see the total $ amounts for the 'Supportive Services' "Parent" category, but you'd need to manually calculate the "sub-category" amounts based on the descriptions.

Can I remove expenses in bulk?

Yes, deleting an Expense Category will delete all expenses within that category.


Contact Us

If you have any questions about our Budget Spenddown Tracking feature, simply start a conversation with our friendly Support team via Messenger when logged in to your account, or email us at hello@instrumentl.com.

Did this answer your question?