pivot table effort

I am tracking the following data:
Column A thru F - costs
Column G - date the costs were incurred
Column H - Date the costs were paid

The number of rows will continue to increase as more costs are recorded. I am seeking to create a pivot table that would group/subtotal the rows by the dates in Column G and group/subtotal by the dates in Column H. These would be two seperate "views".

Any suggestions on how to do this? Also, if this is possible, how would I filter the dates that I want to subtotal/group?

I've attached some sample data.

You can filter the dates by the AutoFilter at the top of the pivot table. I created a sheet called Summary and put the dates and the amount. Two tables, one for each Liabilities and Deposits. All I did was highlight your data, including the column headers, and click on the insert tab. Pivot table, then selected the destination at the bottom of the window to be a cell on my summary sheet. Then when clicking on the pivot table to create it, I dragged the Liabilities to the row, and put the amount in the E (sum box). I had to click the down arrow on the amt to select Sum instead of count, or else it was just integers. Then repeated for the deposits.