On the Account Reconciliation tab, are you supposed to make a separate entry for each month reconciled? Or just reuse the line for the account? 
Judy Finkelstein
314.496.6039
âOr just reuse the line for the account?â Yes, reuse.
If I use the Simple, does that replace one of my sheets? Also what is the title of column G? Do I need to replace any sheets and if yes, which ones? Thx
Judy Finkelstein
314-496-6039
Youâll need to check with the creator of the Simple Account Reconciliations template in that forum discussion, I tried it once over a year ago, donât remember much about it other than it didnât quite fit my needs.
One line per account, each month update the date and statement balance for that account and compare to your tiller ending balance.
New to Tiller and appreciate your efforts in creating these sheets. Iâve just downloaded your Account Reconciliation sheet. and have an issue with âAccount Reconciliationâ!B5. The dropdown is referencing column H on the Accounts sheet and I (assume) it should point towards a column referencing a âStatement/Tiller Accountâ. Using it as is my only options in that column are 8/8/23 or 8/9/23. Iâve read the directions and canât figure it out. What am I missing?
Thanks
The data validation does look to your Accounts sheet, which by default has a list of your Account names in column H. I didnât make this a âsmartâ feature that looks for moved columns, so to fix it youâll need to update the data validation to point to the column where youâre accounts are listed (there are two columns on the Accounts sheet named âAccountâ, weâre looking for the second one).
Thanks for the quick response. I downloaded a new version of the template and overwrote the existing version in my file. The data validation for column B is still pointing to column H, so you may want to check the version downloaded to the community site for accuracy. Regardless, Iâll make the change you suggest and see how it goes. Thanks again.
OK, looks like the column changed in the new version of the Foundation Template. I just fixed Account Reconciliation so new installs or updates will work properly once @randy pushes the update. The only change is "Data Validation for Accounts list now respects changes in Accounts sheet column order.
Joseph,
Iâve run across something that was driving me bonkers for a bit trying to reconcile an out of whack statement this evening and found that if transactions are split, then in the troubleshoot unbalanced statement section each of these transactions are showing up as the new split amounts but my statement is showing the full amount. Would it be possible to somehow flag these split transactions in the troubleshoot statement section so that you know a transaction has been split already? just an idea.
Continued thanks for this and many other templates.
Ahh, split transactions. Definitely hadnât thought about the repercussions of that. Iâll add it to my list of things to look at, thanks for pointing that out!
1 Like
FYI - this sheet got weird on me. I just noticed this sheet was still broken due to the change to Accounts so I didnât get a new version pushed or updated post Account sheet changing. Attempted to Restore which may not have been correct course of action. That didnât do anything so thought I would just start over. Deleted Account Reconciliation but when I go to Add back to Tiller I get the following. I seem to have discarded some dependency but not sure what it is:
Try it again. I think the master template that contains this template was having an issue that has since been fixed.
Hmm. Still getting the same dependency error graphic as above.
edit: Nevermind. Despite receiving that error, it downloaded the sheet and I just balanced my CC so seems to be working again.
1 Like
Hi, I have the reconciliation template, but it is now broken. I keep going to the community sidebar and looking for it, but canât seem to find a way to add it. I canât find it in any other area and when I click on the icon or the title, it just takes me to a new search window. Am I missing something?
If clicking on âAccount Reconciliationâ just below âTemplatesâ in the image you sent doesnât take you to it, go to the âExtensionsâ menu to âTiller Community Solutionsâ and then âManage Solutionsâ you should see âAccount Reconciliationâ in the âManageâ tab if you have it installed. You can click on it and click âRestore Sheetâ to get a fresh copy. If you donât it under the Manage tab, click on the Explore tab and you should find it in one of the categories (not sure how itâs normally categorized) and then you can install it from there.
So, Iâm not sure where to go. You can see that it doesnât think I have Reconciliation installed.
However, If I try to click the link as you suggested, it takes me to this search window.
I also tried looking for it under âExploreâ and looked at literally every category and it wasnât there.
Does it look at my base template version for a match?
@randy, have any idea why @bryman wouldnât see the Account Reconciliation solution? Which category is that in?
Itâs in âBank Statementsâ. Do you see it, @bryman?
@randy Nope:
