![]() ![]() When set up correctly, the sheet will automatically. Type in descriptions future deposits and credits in the A and B columns of new rows, then the positive or negative amount in the C cell to automatically calculate your running balance in the "D" column. A set of directions for creating an auto-calculating checkbook register in Excel or Google Sheets. 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. You can also take a look at our other useful articles. Also, you can download and use this template in Excel, Google Sheets, or PDF format. Here we provide you with a free downloadable checkbook register table that can keep track of the incoming and outgoing transactions. Give your spreadsheet a name and wait for Google to save it automatically. This article has been a guide to Checkbook Register Template. ![]() Choose "Spreadsheet" from the "New" drop-down menu. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |