Hi Maureen,

The best I've been able to do with Sage 50 and Excel is to export the aging detail with 999 days history, put a formula in to check whether the 'Invoice' line is followed, and use THAT as a lookup table (vLookup) to check for payment from the Project report.

There's the possibility of doing something better using a SQL query or XLGL (or Sage 'Intelligence' if it's still available), but I haven't, because the way the data is stored makes it difficult to extract just that information - the A/R tables are separate from the G/L and Project tables, and there are separate data tables for each G/L and each Project, for each fiscal year. 

And Receipts can't be allocated, so it's not possible to simply sum up all the transactions to 1200 Accounts Receivable, by Project.

Please post back if you would like some sample Excel sheets to copy formulas from.  I'm not sure we can post them in this forum, but probably can attach them to a private message.