pivot table effort

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.