I need help designing a report that shows Expected revenue, Actual revenue collected and Arrears

Thegaijin

I'm new to this so excuse me if my question has an easy answer to it. I need help designing a report that shows Dimension values for a single dimension in the rows. Budgeted amount, Expected revenue, Actual revenue collected=(Expected revenue-Accounts receivable) and Arrears (Accounts receivable) in the columns. I'm trying to do this using a Query object after failing to do it with account schedules and standard report designing. My data source is the G/L Entry table. I'm stuck on how to represent the Accounts receivables Amounts in a separate column from the Income accounts Amounts. Any help will be greatly appreciated.

I should point out that when payments were being made, they were not applied to the respective invoices. The only link is the Dimension Values. It's a global dimension.
I've attached an image of what the report is supposed to look like, ideally.