michael harr, mba
recurring transactions

adding recurring transactions

To add a recurring transaction, follow these steps:
  1. Go to the last transaction row toward the bottom of your cash flow spreadsheet
  2. Enter the first TWO transactions in the series by typing the first two dates, payee/payor descriptions, and cash in/cash out amounts
  3. Highlight the first two transactions in the series
  4. Click on the bottom right corner of the highlighted area and drag down to automatically fill in the remainder of the series
  5. 'Bank Sort' the spreadsheet
NOTE:  Google Sheets will automatically project dates for daily, weekly, bi-weekly, monthly, bi-monthly, quarterly, semi-annual, and annual dates. What it will NOT do is project dates for 1st & 15th or 15th & 30th date series. To add a 1st & 15th or 15th & 30th series, create two monthly series - e.g. for a 1st & 15th date series, add a monthly series for the 1st and then a monthly series for the 15th using the steps outlined above.

editing recurring transactions

To edit a recurring transaction, follow these steps:
  1. From the 'Sort' menu, click 'Payee/Payor Sort'
  2. Locate the transaction series by scrolling down the spreadsheet
  3. To edit the dates of a series, enter the first TWO dates, then click and drag to fill in the new dates. To edit the payor/payee description or cash in/cash out amounts, edit the first item, then click and drag to fill in the edited information.
  4. 'Bank Sort' the spreadsheet

deleting recurring transactions

To delete a recurring transaction, follow these steps:
  1. From the 'Sort' menu, click the 'Payee/Payor Sort'
  2. Locate the transaction series by scrolling down the spreadsheet
  3. Click and highlight the dates, payee/payor descriptions, and cash in/cash out cells
  4. Press the delete key
  5. 'Bank Sort' the spreadsheet

comments, questions, and suggestions

‚ÄčIf you have any comments, questions, or suggestions, please use the form below to email me directly. I reply to most emails within one business day.