[GNC] Tracking UnPaid Bills

[flywire]

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

>
-------------- next part --------------
  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