RECONCILE, DEPOSITS (12/4/24): When entering the statement start date during reconciliation, the previous version would include deposits that are on the start date entered on the Reconciliation Screen. Normally, a bank statement’s “previous balance as of” date already included deposits in the previous month’s statement, so the formula for finding Deposits/Credits on the reconciliation screen needed to be adjusted. OLD Formula example: =IF(AND(C4<>””,D4<>””),SUMIFS(Register1[Deposit],Register1[Date],”>=“&C4,Register1[Date],”<=”&D4),””) UPDATED Formula: =IF(AND(C4<>””,D4<>””),SUMIFS(Register1[Deposit],Register1[Date],”>”&C4,Register1[Date],”<=”&D4),””)
MICROSOFT ONEDRIVE FIX (11/21/24): For users of OneDrive who have encountered a datasource error (file is being used by another process), there’s now a fix. See this page for full details.
UPDATE TO INSTRUCTIONAL TEXT (10/7/24): On the Categories sheet, the instructional text has been updated to clarify what can be changed, added or rename.
ISSUE (5/13/24): If you delete a row in the register, it can cause the next row to not be referenced in the dashboard charts because of a #REF error in a hidden column. In the screenshot below, there are 3 hidden columns which includes column ‘O’ where the following formula can be found in cell O5: =TRIM(MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1),1)+1,255))
Here’s a corrected version that doesn’t mess up when a row is deleted: =TRIM(MID(CELL(“filename”,A$1),FIND(“]”,CELL(“filename”,A$1),1)+1,255))
If you want to fix this in your existing spreadsheet, start by unhiding columns M-O and then click your cursor into the first occurrence (cell O5), and update the formula so that the reference to “A1” becomes “A$1” in both areas of the formula. Next, copy (fill) that updated formula all the way down, and then repeat this update on all of the other register worksheets. You can also download the spreadsheet again from Order History or from your emailed receipt as this has been corrected in the most current version posted to the site.
ISSUE (4/21/24): On the Reconcile sheet, the formulas that are located in the following cells are incorrect. Cells: H7, H8, I7, I8, J7 and J8. They reference “Register3” but row 7 should reference Register4 and the formulas in row7 should reference Register5. You can correct those references in the formula or you can download the spreadsheet again from Order History or from your emailed receipt as this has been corrected in the most current version posted to the site. See the following screenshot for additional reference.
