How to Calculate the Running Total of Numbers from a File in Batch Script

Learn how to read numbers from a file and compute a running total (cumulative sum) in Windows Batch scripting, including error handling and CSV output.

A Running Total (also called a Cumulative Sum) is a sequence of partial sums where each entry is the sum of all previous values plus the current one. For example, given the numbers 5, 10, 3, the running totals are 5, 15, 18. This is commonly used in financial tracking, log analysis, and progress monitoring.

In this guide, we will demonstrate how to read numbers from a file and calculate their running total.

The Strategy: Read and Accumulate

Open a file containing one number per line.
Initialize a total variable to 0.
For each line, add the number to total.
Display or log both the current number and the running total.

Setup: Create the Input File

:: Create a sample numbers file
(
    echo 150
    echo 200
    echo 75
    echo 300
    echo 125
) > numbers.txt

Implementation Script

@echo off
setlocal enabledelayedexpansion

set "inputFile=numbers.txt"

:: Validate that the input file exists
if not exist "!inputFile!" (
    echo [ERROR] File not found: !inputFile!
    pause
    exit /b
)

set "total=0"
set "lineNum=0"

echo.
echo --- RUNNING TOTAL REPORT ---
echo.
echo  #   Value   Running Total
echo ---  -----   -------------

for /f "usebackq delims=" %%A in ("!inputFile!") do (
    :: Validate that the line contains a number
    set "val=%%A"
    set /a "check=val" 2>nul
    if !errorlevel! NEQ 0 (
        echo  [SKIP] Non-numeric line: "%%A"
    ) else (
        set /a "lineNum+=1"
        set /a "total+=val"
        echo  !lineNum!   %%A       !total!
    )
)

echo.
echo ==========================================
echo GRAND TOTAL: !total! (%lineNum% entries)
echo ==========================================
pause

Why Calculate a Running Total?

Financial Tracking: Monitoring how daily expenses accumulate over a month to visualize spending trends.
Log Analysis: Counting the cumulative number of errors or events over time from a system log.
Progress Monitoring: Showing "total bytes downloaded so far" when processing a list of file sizes.

Important Considerations

32-Bit Overflow

If the cumulative total exceeds 2,147,483,647 or falls below -2,147,483,648, the result will silently overflow and produce incorrect values. For large datasets or large values, use PowerShell:

powershell -NoProfile -Command "Get-Content 'numbers.txt' | ForEach-Object -Begin {$t=0} -Process {$t+=[int64]$_; \"$_ -> $t\"} -End {\"Total: $t\"}"

Best Practices

Output to CSV

Redirect the running total output to a CSV file for import into Excel or other tools:

@echo off
setlocal enabledelayedexpansion

set "inputFile=numbers.txt"
set "outputFile=running_totals.csv"
set "total=0"
set "lineNum=0"

echo Line,Value,RunningTotal> "!outputFile!"

for /f "usebackq delims=" %%A in ("!inputFile!") do (
    set /a "lineNum+=1"
    set /a "total+=%%A"
    echo !lineNum!,%%A,!total!>> "!outputFile!"
)

echo Results written to !outputFile!
pause

Multiple Columns

If your file has multiple columns (e.g., Date,Amount), use tokens and delims in the for /f loop to extract just the numeric column:

for /f "usebackq tokens=2 delims=," %%A in ("data.csv") do (
    set /a "total+=%%A"
)

Conclusion

Calculating a running total transforms a flat list of numbers into a dynamic, cumulative dataset. By reading values from a file and maintaining an accumulator variable, you build a powerful analytical tool for financial tracking, progress monitoring, and trend analysis. This technique ensures your Batch scripts can provide real-time, cumulative insights from any numeric data source.