CARD DEBT CHARTS (01/14/2025): On the worksheet for Card Debt which has simple bar graph charts for each row in the table, the last 4 bar charts are pointed at the same cell as the data source. This has been fixed as of 01/14/2025, but you can quickly fix your copy if you have more than 8 card balances in the table. To do so, right-click on the bar chart under column “W & X” and choose Select Data and change the cell reference from F$10 to F$11. Repeat this process on the next bar chart under column “Y” and change it’s cell reference to F$12, and do the same for the bar chart under column “Z – AA” to be F$13, etc.
RECONCILE, DEPOSITS (12/4/2024): 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/2024): 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/2024): On the Categories sheet, the instructional text has been updated to clarify what can be changed, added or rename.
ISSUE (5/13/2024): 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/2024): 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.
