How Do I Get A Outstanding Amt From Table

I have 2 Tables
1. tbl_Bill
2. tbl_Payment

i want to get data from this 2 tables
from tbl_Bill - Billed Amount and Billed Date
from tbl_Payment - Paid Amount and Paid Date

i want to get datas between from date and to date

i have datas from novemer2013 to till date both billed amount and paid amount
if i give 01.01.2014 as start date and 12.02.2014 as to date,
then i want get the total billed amount and paid amount then get a
outstanding(Billed Amount Total - Paid Amount Total) From 01.11.2013(Nov) to 31.12.2014 

Then need to show like this

Company Outstanding (15000.00)(as on 31.12.2013)
SINo   Billed Amt   Billed Date     Recived Amt     Received Date  
 1	500.00	     10.01.2014        --           --
 2	250.00	     20.01.2014        --	    --
 3	--	     --		       250.00	    21.01.2014
 4	200.00 	     22.01.2014        ---	    --
 5	--	     --                150.00 	    01.02.2014
 --------------------------------------------------------------
Total   950.00			       400.00
				   Total Outstanding : 15550