Project Balance Sheet Tile

Alex Wong

Hi,

Trying to get some understanding of the Balance Sheet Tile.

I have a project in FE (7729), and a Fund ID in RE (7729) tie to the 7729 project in FE.

In RE, there is a pledge of $154K for 7729, and then there is a $195K pay-cash where $154K is paying the aforementioned pledge and the rest of $41K paid another pledge. However, in the split gift, there was a user error, where the split of the gift was $160K to 7729 and $35K to the other fund on the other pledge.

In FE, we also use the account payable to pay out $115,637.80, which is recorded in Expense account code.

In FE NXT Balance Sheet tile I see

Assets ($77,347.60)
Liabilities ($115,673.80)
Fund balance $38,326.20

Can someone help me understand how these numbers came about?

Thank you

Kevin Brazell

@Alex Wong
they are coming from any and all posted transactions in FE using that project, not just activity from RE posted over. If you want to pull data to compare then run other reports, you can start with the Project Financial Statement. You can set it to just balaance sheet and run it for the same period the tile is set , and the numbers should tie. You can even set the level of detail to accounts on this report so it will show you the balances of each category by their accounts.

Here is a test one in my sample database, my project's tile showed these amounts with nothing in Liabilities. Then I ran the same report but asked it to show me the account balances :

If you want even more detail about how it go there, then I'd go to the General Ledger Report, filter it by your project, and set the report time you like. This will show how any and all uses from all of FE will show the amounts. Also remember the expense would roll up into the Net Asset field. So you may want to run the Project Financial Statement with both Balance sheet and Income statement information so you can check it against the GL report's details.