I think the project income is just that - listing revenues and expenses to show net profit.

If you need to show daily how much is owed on each project then perhaps create a new customer for each project such as CanPro Construction - ABC Project, CanPro Construction - Apex Condo - Block A, etc Would that help?

Also maybe look at one of the Sage construction edition (Sage 100 or Sage 300?) to see if perhaps this is something your company needs to look into to get the construction type reports that you are looking for.

To use a new customer for each project would be extremely cumbersome, worse than the way I am doing it now.   I will look into the construction editions, thanks

another way that might work is to use the general journal entry for every payment made. You would still record the customer payments as per usual but then record in general journal to debit bank account and allocate payment to project then second line is to credit bank account but not allocate payment. This way the payment is just an in and out entry to record the allocation only. You would have to ensure only the taxfree portion is recorded and that the bank account is set to 'Allow Allocations'. Then the report to pull up would be the 'Allocation' report and you select the revenue accounts and bank accounts to show what is left owing.

I would build a custom query in Access or LibreOffice.   If you want help doing this please let me know.

Such a thing should also be possible in Sage Intelligence.  It's available from Sage.

SQL queries in Excel are also possible.  There are some sample worksheets under the Reports | Microsoft Office Documents menu.  

And with a load of 'if' statements and some Lookup formulas, you can export the A/R aging and reference that from an export of the Project Allocation.  I wouldn't want to do THAT every day.

I agree with Randy, one of us consultant's can build a report for you