Just add another column to the right, call it "Paid" or something equally imaginative and put the amount there. Do a "Sum" at the bottom of the column, you then know your clubs income for the year. Save the old spreadsheet and start a new one for each club year, you automatically know who has paid and what your current membership income is. Ours is done using LibreOffice, but at this level, everything is the same.