Click cell C2, then drag the black box that appears around it down to cell C30, which applies the same formula to the first 30 rows of the spreadsheet. Click your mouse inside cell A2, then type a short description of the first purchase or deposit, then type the amount - positive for deposits, negative for purchases and other deductions - into cell C2.Ĭlick the mouse inside cell D2 and type the following formula: =(C2+C1), which adds the positive or negative amount in cell C2 to cell C1 to create your new running balance. Type 'Beginning Balance' into cells A1 and B1, then type your current checking account balance into cell D1, leaving cell C1 blank. Give your spreadsheet a name and wait for Google to save it automatically.
Choose 'Spreadsheet' from the 'New' drop-down menu.
