Page 1 of 1

Mortgage needs to show up in Reports

Posted: Thu Oct 27, 2016 8:58 am
by LQ Helper
I have budgeted a liability to reflect our current mortgage principal for 2017 and know that the current mortgage liability does show up on the budget report (YEA :D) but how do I get that liability included in the total budget figures to present to the church? The only thing in the total are the expenses. Do the members have to add them on their own or is there a way to include the liability in a grand total or do we have to put a note on the budget to show the total of the expenses and liability?

Re: Mortgage needs to show up in Reports

Posted: Thu Oct 27, 2016 9:26 am
by NeilZ
LQ Helper wrote:I have budgeted a liability to reflect our current mortgage principal for 2017 and know that the current mortgage liability does show up on the budget report (YEA :D) but how do I get that liability included in the total budget figures to present to the church? The only thing in the total are the expenses. Do the members have to add them on their own or is there a way to include the liability in a grand total or do we have to put a note on the budget to show the total of the expenses and liability?
In order to pay off a liability, you must have an expense account to show where the money is coming from to pay the mortgage.

Here's an example from the original thread where you posted this, I moved it as things tend to get lost in 2 year old threads:
To make a $2000 Mortgage payment with $1,300 toward interest and $700 toward principle:
CR 01-1110-000 Checking Account $2000
DB 01-2016-000 Mortgage liability $700
DB 01-5610-000 Mortgage Interest Expense $1,300
This is what you budget for, the expense for the year of paying off the loan. The overall liability is normally not reflected in a budget report, but does show up on such things as the Cash Management report.

Does this help any, or is the issue a bit different.

Re: Mortgage needs to show up in Reports

Posted: Mon Oct 31, 2016 8:44 am
by LQ Helper
Yes it does. Thank you very much for that.