Is it possible to set a row definition so that it reports the change in an account as opposed to the actual balance in it? I want to record a balance sheet account in a P&L statement, but don't want to include the beginning balance, only the activity for the year.
We are a non-profit and apply grant funding received for capital directly to a balance sheet account called "grant proceeds for capital equipment". I would like to show that funding on the profit and loss below operating profit so our board clearly sees when this happens as opposed to noticing a change in the equity section of the balance sheet.
If there is no way to do this, my alternative is to set up a new balance sheet account and then transfer its balance to the normal balance sheet account at the end of the fiscal year. As long as the new balance sheet is zeroed out at the end of each year, this would work for reporting on the P&L.
Curious to know how other users might be tackling this.
Thanks,
*This post is locked for comments