I need to add a tab to the grant tracker that allows me to track the spenddown on each grant, preferrably by grant line. There is a transactions but it does not let me put negative only positive amounts so i can’t put a starting balance and then spend down the grant. Has anyone done this? Does anyone have suggestions?
Question
Grant Balance Tracking
+1
+1I haven’t used the template much, so can’t speak to that, but to add negative numbers, toggle on “Allow negative numbers” as seen below:
+14I am assuming you have a Grants table and an Expenses table.
On the grants table., you can build a few fields:
1. Manual entry Numbers/Currency field for the value of the grant. (ex. $10,000)
2. Roll up field to sum together the expenses from your expenses table (ex. $4,000) - notice this is still a positive number.
3.Finally, a formula field that takes the grant value and subtracts the rollup field. (ex. $10,000 - $4,000 =$6,000)
This should allow you to see the remaining value in the grant.
+14I am actually working in the one from the training
Awesome!
+1Is there a way to add a transaction under a field with a balance and have that balance decrease? if that makes sense? I’m trying to picture how i would want to do this in real time
+8
+22Is there a way to add a transaction under a field with a balance and have that balance decrease? if that makes sense? I’m trying to picture how i would want to do this in real time
I was going to suggest
Important to note though that the lookup will decrease when other transactions are added. If you want to freeze that figure (so you can see that Transaction 3 had the balance at $2,342, while Transaction 4 brought the balance to $2,134, etc) then you can add an automation that fires when the lookup field isn’t empty and the transaction field isn’t empty and write the value into a currency field.
+1It’s starting to do what I want now that I’ve gotten some information from here and I think I have to play with it and do some research, get some refresher information. I would really love to figure out how to track the budget lines and I know if classify an expense like we paid $240 in training supplies i can connect that to a training supplies line but i need to figure out what that looks like in tab itself. I feel like it appears as a header of the grant name etc. and each budget line below it if that makes sense and I have to figure out how to create that.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.