The approach discussed in this thread seems workable for rental properties.
Attached is a sample rent Transaction Report. The transactions are shown in
Assets:Rent Owing (ie A/R) account which could be used as a tenant rent
report if the Debit/Credit column labels were changed to something like
Paid/Owing so normal people like tenants or magistrates could understand it.
Rent due works well as a scheduled payment provided payments are actioned.
As mentioned previously, Filtered reports ( or
https://github.com/dawansv/gnucash-custom-reports?tab=readme-ov-file#examples
) would be useful for multiple properties/tenants etc.
An unfortunate byproduct of this approach for those on cash accounting (ie
almost everyone) is rent due appears as income when it is due even if it
hasn't been paid. Tax reporting on a cash basis would require an end of
year adjustment.
Regards
>
Transaction Report
From 01/07/2019 to 30/06/2020
Date Num Description Memo/Notes Account Transfer from/to Debit Credit
Assets:Rent Owing
01/03/2020 T Smith Rent for Unit Assets:Rent Owing Income:Rent
[1]$1,000.00
06/03/2020 T Smith Rent for Unit Assets:Rent Owing Assets:Savings
[2]$750.00
03/04/2020 T Smith Rent for Unit Assets:Rent Owing Income:Rent
[3]$1,000.00
28/04/2020 T Smith Rent for Unit Assets:Rent Owing Assets:Savings
[4]$2,000.00
01/05/2020 T Smith Rent for Unit Assets:Rent Owing Income:Rent
[5]$1,000.00
01/05/2020 WaterCo Water usage Assets:Rent Owing
Expenses:Utilities:Water [6]$15.00
Total For Assets:Rent Owing $265.00
Assets:Savings
06/03/2020 T Smith Rent for Unit Assets:Savings Assets:Rent Owing
[7]$750.00
28/04/2020 T Smith Rent for Unit Assets:Savings Assets:Rent Owing
[8]$2,000.00
Total For Assets:Savings $2,750.00
Expenses:Utilities:Water
01/05/2020 WaterCo Water usage Expenses:Utilities:Water Assets:Rent
Owing [9]$15.00
Total For Expenses:Utilities:Water $15.00
Income:Rent
01/03/2020 T Smith Rent for Unit Income:Rent Assets:Rent Owing
[10]$1,000.00
03/04/2020 T Smith Rent for Unit Income:Rent Assets:Rent Owing
[11]$1,000.00
01/05/2020 T Smith Rent for Unit Income:Rent Assets:Rent Owing
[12]$1,000.00
30/06/2020 Rent for Unit EoFY adjustment - Income not received
Income:Rent Liabilities:Contra [13]$265.00
Total For Income:Rent $2,735.00
Liabilities:Contra
30/06/2020 Rent for Unit EoFY adjustment - Income not received
Liabilities:Contra Income:Rent [14]$265.00
Total For Liabilities:Contra $265.00
__________________________________________________________________
Grand Total $0.00
References
1. gnc-register:split-guid=3e1d517990074ca5af83b24c866a33ac
2. gnc-register:split-guid=44d5c12fac3d4781b8c7df76f228c396
3. gnc-register:split-guid=2e26d25abb944b29adcab45315db9642
4. gnc-register:split-guid=a6bd25f47c984aa3bb4b49f4d76a0ba6
5. gnc-register:split-guid=cb43a611c4ee4573a6dd521301e8bf9a
6. gnc-register:split-guid=e66a614d51d241adb07e23bd85b1f198
7. gnc-register:split-guid=61e6b098ece2483c9ff4640ef48bce11
8. gnc-register:split-guid=b91ac43feb754d4495f14fbc7c194afd
9. gnc-register:split-guid=ea792505b556471491488f5ab873f9d3
10. gnc-register:split-guid=a079ce65cf9e49c28f848e9c3e60f099
11. gnc-register:split-guid=4d76cfae96e644c188e2c1f20aa46314
12. gnc-register:split-guid=4801e0fb69f0420f8602fba2fcc035d7
13. gnc-register:split-guid=fc035cdf31c74c368b6ea395b7d8c94f
14. gnc-register:split-guid=1186c69cdd9f4287abbe44b5309dc8f2
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
