
Reconciliation to date on statement - not possible?
I used ynab4 and recently reupgraded to the app.
in ynab4 reconciliation, i used to be able to reconcile my account to a certain date. For example, my bank statement shows transactions thru the 20th of the month. I get their statement mailed a few days later. On the 24th, I reconcile account and I could set the reconciliation balance date back to the 20th. Same for my credit card statement.
In the app, unless I missed it, I see no way to backdate my reconciliation, which is a regression in functionality for those of us who still want to balance against a printed statement or pdf statement.
Have I missed something or can you reconcile accounts only to the current date? thanks.
-
I brought this up a while back too. The answer was with the automated transaction downloading, it's no longer need (except for those of us who's banks are black listed). I'd like to see this functionality too. When a statement comes due that is a good time to review the month's transactions and make sure everything's in sync.
That said... it's still the best game in town hands down...
-
Hi JBCampo !
There isn't an option to reconcile to a certain date in the new YNAB. When you reconcile, it automatically reconciles transactions through today's date. You can still use your bank statement to check transactions through the statement date, but you'll want to use your bank register to confirm transactions beyond that.
I'll let our development team know you'd like to see this option return! :)
-
I would love to have this feature restored too because it really helps with finding errors when doing reconciliation. My balance and YNAB register were exactly the same until recently but I hadn't hit the reconciliation button and now they are different and I can't find the error. It would be so helpful to be able to reconcile to a past date so I don't have to go back through a couple of months worth of statements. Not everyone reconciles their accounts every month. Plus, I automatically import my transactions but sometimes it misses a few and I have to go enter them manually. That happened to me recently on a credit card account.
It would also be helpful to see the register balance. That would also help with reconciliation.
-
Add me to the list too! I've just switched to the new version and was totally frustrated trying to reconcile to my statement. I had to do this little dance where I uncleared an entry, reconciled to the statement, then had to go back and re-clear the item. Not being able to reconcile to a paper statement is definitely a step backward for me.
-
Two more feature requests submitted! :)
I can't make any promises about future features, but this at least lets our development team know you'd like to see this option. While I see how that date option would be convenient, are you able to reconcile using your account registers? I keep my account up to date with the online account. Then, when the statement comes, it's just a quick glance to make sure everything's the same between the two.
-
I just found this topic when searching for how to reconcile to a statement date. I'd love this functionality, also. I like to reconcile at the end of the month before I fund for the next month, and I reconcile to my statements which usually ended halfway through the month. Reconciling to the full transaction list on the website is just not as simple and also more difficult to account for any returns, adjustments, etc. that are easier to see on the PDF statement.
-
Agreed on needing this feature. I've yet to have a clean reconciliation and it is SO frustrating. I've had to create multiple adjustments because nothing reconciles properly. It's frustrating to have pending transactions being included when you try to reconcile, as they aren't always the actual posted amount. Any movement on adding in this feature? I'm tired of having to search and search for "missing" transactions...it's definitely not making the platform more efficient or user-friendly!
-
Please add me to this request as well. As a bookkeeper, I have always been taught to reconcile to the statements. That keeps everything clean and there is no confusion about pending transactions, etc. I don't see how you can truly call it reconciling if you can't choose a date... there are so many unknowns to a current random date and it's a lot more work to check and go through. I really hope there is an "as of" date feature for the reconciliation moving forward. It should be an option since it's the actual right way to reconcile.
-
Aquamarine Viper and Pieter ,
We'd love it if you'd fill out this form. It goes straight to our Development Team and is the best way to communicate what you'd like to see! You can also find it on the forum home page under Important Links.
Thanks! -
I know this thread is 4 months old, but please +1 me for reviving the feature to reconcile against a date other than today. I found it incredibly helpful for those times when I had a lot of catch up to do and couldn't get through all my transactions in one sitting. It was always the easiest way to find an error - especially for accounts where the bank showed the running balance per transaction date - I would keep reconciling against dates until I could ID the period where there was a discrepancy.
-
WordTenor gave an answer above, but many seem to have missed it. Since this issue keeps coming up, you can reconcile to a given date with the following:
- Flag any cleared transactions dated after your statement date (to allow you to restore them later)
- Unclear those post-statement (flagged) transactions
- Reconcile, providing your statement balance
- Re-clear then un-flag the flagged transactions
Hopefully this is helpful until YNAB adds a statement date capability to reconciliation.
-
This is a big issue for me. I fell off the YNAB wagon for about 6 months. Some of my account are linked for auto transactions, some can not be. Several of my accounts are severely out of sync and with months of data it is impossible to reconcile by hand all at once. I know "throw it out and start over" is an option, but it is very far from ideal. I have years worth of data and am trying to track spending habits. I want to see how my ignoring the budget has impacted my spending since the new year. The changes since YNAB4 seem to be for "in a perfect world" type situations and have no leniency for those of us who have setbacks. It is very frustrating and makes me want to ignore the budget for the next 6 months as well.
-
+1 for me as well.
The biggest reason is that I'm not great at reconciling immediately all the time. I may go 2 months before reconciling all the accounts. Being able to grab last month's statement, and reconcile to that helps me to find the discrepancy rather than having multiple month's to go through.
I would love to use the automatic import/link with a bank, but I also work in multiple currencies. And I use the "convert everything into a approx common currency" method. So even if I synced with the bank, it would be at the wrong currency. I can do the "pretend nothing is cleared" but that seems like a pretty bad hack.
-
I have used ynab4 for 7 years and it was great. But this new ynab still has multiple unnecessary hassles. Software is supposed to make life easier not more time-consuming. I was expecting to be able to reconcile statement by statement as old ynab and most other software allows eg Kashflow and Xero for businesses.
So the requirement to reconcile only to the current day is very troubling and tricky to achieve. Please bring new ynab up to the level of excellence achieved by old ynab. I am considering going back to old ynab before the trial finishes.
-
I had the same concern. However, you can still reconcile by statement. It's a little odd, but it works. Just use the statement date rather than the date you are reconciling. I select all of the transactions and mark them as "uncleared." Then reconcile as you normally would. Use the account balance and date from your bank statements. No problem.
-
I just switched from YNAB4 to nYNAB and I'm thinking, Reconciliation is such a simple process why does it have to get screwed up. Maybe call it something else? I've been using nYNAB for a month now. Just did my first reconciliation and when it asked the bank balance, I put in what my bank said, then realized one of those transactions was pending, and therefore wasn't downloaded to my YNAB yet. So, I went back and changed the balance.
As I redid it, I was like $620 off! That's never happened before. Now, my b budget was off for June, and I'm like - this is stupid.... and I deleted the adjustment and said I would start reading until I figured out what was going on.
Now, I see that I'm going to have to go through ALL my old transactions, not just the last month, to verify the reconciliation, to make sure my available budget is correct, etc. Maybe it's time for a fresh start.... I was trying to avoid that, but my import from YNAB4 was less than stellar......
So, yeah, put me down as a plus 1 for a reconcile by date. done with rant. :-)
-
Unfortunately I feel that YNAB have too few resources to meet client wishes. The progress on a whole range of issues seems pitifully slow.
Its still a great product and philosophy.
However , It would help if YNAB could let us know how many developers are in the team now split between maintenance and new features.
It would also be good to provide comparative figures for 3 and 5 years ago.
To fund increases in the development team, surely the finances must be improving with the steady stream of customers paying the annual fee?
-
@Patzer You are correct. However, I find it really puzzling that an organisation like YNAB does not want to understand and then act on highly requested features.
I wholeheartedly support YNAB in providing a forum like this. But surely they realise prospective customers will read these and many other similar posts. Don't they want the income from new users??