I have many about prepaid transactions and I don't use Vendor Prepayment Module so I want to create a report or saved search to get but I have no idea.

how to get the remaining amount for prepaid Account?

for example,

A transaction I prepaid $10000 to A vendor on 8/1 then create a bill $7000, the remaining amount is $3000.

B transaction I prepaid $20000 to B vendor on 7/31, bill $5000, the remaining amount is $15000.

then report/saved search will show

Vendor      date     Memo      Amount   Amount Remaining

    A            8/1         one        $10000          $3000

    B           7/31        two        $20000          $15000