How to Calculate a Running Total of Daily Receipts in Excel
Open your Excel workbook (.xlsx) in Cue Office. Use SUM to add the amounts from the first day through the current row, then fill the formula down. Each row shows how much you received through that day, so you can check the amounts one day at a time.
Match each running total to that day’s receipts
Start by sorting your receipts by date. In the sample worksheet, column A lists the days of the week, and column B, Received, logs daily receipts. Because values begin in B2, enter Running total in C1, and then enter the formula below into C2.
=SUM($B$2:B2)
$B$2 keeps the sum anchored to cell B2. If you change the amount in B2, the totals recalculate. The B2 after the colon changes with each row. In C3, the formula becomes =SUM($B$2:B3), which adds Monday’s and Tuesday’s receipts. After entering the first formula, select C2:C6.
On the Home toolbar, open Fill and choose Fill Down to copy the C2 formula down the selection.
How to Verify the Running Total
Save and reopen the workbook in Cue Office. The log shows 25 for Monday and 40 for Tuesday, so Tuesday’s running total should be 65. With no receipts on Wednesday, the total stays at 65. By Friday, it reaches 120.
Have Cue AI Fill the Running Total Column
Open a copy of the original data. On the Home toolbar, click Cue AI and ask it to fill in the running totals in column C.
I'm tracking how much we've received by the end of each day. Could you fill C1:C6 on Sheet1 with a Running total column that updates whenever I change a Received amount? Please leave columns A and B as they are.
After Cue AI writes the formulas, close the sidebar, save the workbook, and reopen it in Cue Office. Check that columns A and B match the original and that C2:C6 shows 25, 65, 65, 100, and 120. In this example, Cue AI wrote =C5+B6 in the last row. It adds Friday’s receipts to Thursday’s running total.
To check that the totals update, change Wednesday’s amount in B4 from 0 to 10 in a separate test copy. Monday and Tuesday should stay at 25 and 65. Wednesday through Friday should now read 75, 110, and 130.
Practice with a Five-Day Donation Log
Show the full example
Community volunteers record daily contributions and want to know the cumulative funds raised before wrapping up on Friday. Copy the table below, paste it into A1 of Sheet1, and follow the steps above to populate column C.
Day Received Monday 25 Tuesday 40 Wednesday 0 Thursday 35 Friday 20
From Monday through Friday, C2:C6 should show 25, 65, 65, 100, and 120 in sequence.
How to track down a 10-unit difference in Friday’s total
Subtract the previous day’s running total from the current day’s total to see how much the sheet records for that day. Wednesday’s 75 minus Tuesday’s 65 gives 10. Check Wednesday’s receipts. If nothing came in that day, change B4 back to 0 and check that Friday’s total returns to 120. If you have more days to add, enter the amounts received, then give Cue AI the first and last new row numbers and ask it to extend the running total. Subtract the old last total from the new one and check that the difference equals the sum of the new receipts.
For the weekend handoff, use the free Cue Office app to edit your Excel (.xlsx) donation log and open PDF (.pdf) receipts to check any amounts in question. Add the verified total to your Word (.docx) handoff notes or update the PowerPoint (.pptx) fundraising report for volunteers.