r/QuickBooks • u/JusticeIsHere2024 • 19h ago
r/QuickBooks • u/JanFromEarth • 20h ago
QuickBooks Online Using QBO projects for Capital Purchase Grants?
I have a nonprofit which receives grants for major building improvements. I create a new project for each of these grants and assign the proper donor/project even though the expenditure is coded to a CIP account. CIP accounts will not show up on project reports. We then run a report that captures all transactions that have the donor/project and use it to create an offline spreadsheet for grant reporting.
This works well but we sometimes have some expenses which will not be capitalized but will be funded by the grant such as meals for workers. Because they are expenses, they show up on the project/grant summary for the individual grant as well as the Project Summary report which I provide to the treasurer to see unspent (restricted) grant balances. I have been adding the net from the offline spreadsheet but I am trying to figure out the best way to deal with the expenses.
- I could deduct them from the total on the Project Summary report. (simplest)
- I could create a JE which would allocate the capital spending to the project/grant. (This satisfies my accountant's soul)
- I could create a JE which would offset the expenses from the QBO project.
- There may be another solution I have not thought about .
I am hoping for some advice.