Column A=date; column B; +data; column C +amount.. Column D -data; column E - amount. F daily/weekly total.
Go to Line 1 of your totals and ensure that it is Zero. Assuming you have formatted the column for cash the use this formula in the F2 box.
=F1+C2-E2 enter.
This will bring the result into the F2 box. To continue with the column highlight the box and ease the curser to the bottom RH corner of the box. This will bring up a cross and you can drag the box down and where you stop it will give you the total for the column.
Subsequently you only have to highlight the last result and pull it down. Should you want to be really lazy pull the result a few lines below those that you have used and it will automatically totalise until you reach it