How do you reconcile the bank statement with opening and ending balances ?
When I receive the bank statement there is an OPENING value and an ENDING value.
After each transaction from the bank statement is REVIEWED how do i know in dollar value how many more are left to be reviewed to balance with listed transactions on the statement to arrive at the same ending balance as the bank shows as ENDING balance on the statement ?
I am transitioning from a simple MS Money software that is handling that question very easily.
Thank you
Best Answers
-
Well, there isn't true reconciliation in Simplifi. Since it works (as Mint did for example), by taking the balance from your bank's website and subtracting any pending transactions to calculate the Balance. Thus unlike MS Money or Quicken Classic, the balance should always be right.
So you have to employ a workaround.
Some people use the Review checkmark as a replacement. When they get their statement they go through and check the review box for each one. If they find a missing transaction, they enter it, clear it and check the box. In that way, they "reconcile" the statement.
I don't bother to do that with my connected accounts. I just check the transactions as they come in to show that I reviewed it and I accepted it was a transaction I made. I also enter my pending transactions manually for accounts that don't download them.
What I do instead is periodically check to make sure I haven't missed any transactions by confirming the total amount of my transactions with the balance that Simplifi shows. It works with any account and not just connected ones (though theoretically with the new feature to "re-sync" manual accounts it shouldn't be necessary for those since the re-sync re-totals the transactions).
For this to work, you need to have set a beginning balance for your accounts (unless of course it was $0.00). Here's a screenshot of my "reconciliation" of my Apple Cash account:
Here you see that my downloaded balance of $167.93 equals Simplifi's total of all my 306 transactions, which I chose using the selection button on the far left. Note that I first sorted the account by category. You could choose another column except date. This sorting forces Simplifi to open up all the transactions so you can choose them all at once using the selection box in the column header.
Now I have confirmed that I am not missing any transactions. I do this with all my connected accounts from time to time.
Hope this helps.
Steve
Quicken Simplifi (Safari & iOS) Since 2021
Quicken Classic (MacOS) Since 2009
MS Money (1991-2009) and Dollars & Sense (1987-1991)0 -
Thank you very much @SRC54 for the detailed explanation.
I am not connected to my bank which is TD (Toronto Dominion) in Canada and not it is listed here as it is not a US bank and I didn't need to create a manual connection to the bank.
I only reconcile my statement to see which of my transactions did not go through the bank at the end of the month. So, my reconciliation process is easy.
When I will receive my March 2026 statement (in early April) I will use your suggested method with the REVIEWED checkbox.
Once again, Thank you
1

