The 2025 version of the Excel Checkbook has two balance numbers that appear at the top of each register for Today’s Balance and Future Balance. For example:
If you are using some of these registers for credit card accounts (liability), the formula for Future Balance needs to be corrected in any register worksheet after Register4. The value for future balance should show as a positive number, but due to an omission, it will show as a negative number. Please note that there’s no harm, but for aesthetic reasons, it’s nicer to see both balance values show as a positive number.
These corrections have been made in the current copies stored on the website, so if you visit your Order History page, you can download a fixed version. However, you’ll likely find it easier to correct the formulas in any register that you’re using for credit cards (liability accounts).
How to Fix
Starting with Register5, copy the appropriate formula from the list below and paste it into the G2 cell in each register where you need this fix. You can tell which formula to copy/paste by noting the Reg# number just after ‘VLOOKUP’. For example, the first row in the grey box below will be to fix Register5 as the ‘VLOOKUP’ has a reference for ‘Reg5name’.
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg5name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg6name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg7name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg8name,Setup_TBL,5,FALSE)))
If you have the special 20-register version of the spreadsheet, the formula for Future Balance needs corrected in the additional registers too, assuming you are using any of these for credit cards:
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg9name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg10name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg11name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg12name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg13name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg14name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg14name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg15name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg16name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg17name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg18name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg19name,Setup_TBL,5,FALSE)))
=IF($A$4="Reconcile Mode is On","",LOOKUP(2,1 / (G:G<>""),G:G)*(VLOOKUP(Reg20name,Setup_TBL,5,FALSE)))
REGISTER12, THE FORMULA FOR TODAY'S BALANCE ALSO NEED FIXED:
=IF($A$4="Reconcile Mode is On","",INDEX(Register12[Balance], MATCH(TODAY(), Register12[Date], 1))*(VLOOKUP(Reg12name,Setup_TBL,5,FALSE)))