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.

72replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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...

    Reply Like 3
    • rlogue06 I added you as a plus one on that feature request! :)

      Reply Like 1
      • rlogue06
      • rlogue06
      • 1 yr ago
      • 1
      • Reported - view

      Faness at YNAB 

      Thank you, much appreciated!

      Reply Like 1
  • 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! :)

    Reply Like 2
  • 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.

    Reply Like 3
  • 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. 

    Reply Like 3
  • 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.

    Reply Like 1
      • bobbucy
      • Tomato_Snow_237e7f17927
      • 1 yr ago
      • 1
      • Reported - view

      Faness at YNAB Exactly how I do it as well.  I was initially worried about losing the ability to reconcile to a specific date, but haven't missed it.  In fact, I ran into a few cases in YNAB4 where trying to reconcile to the exact date of the statement presented problems based on the timing of some transactions.  That is not an issue in the new YNAB.

      Reply Like 1
      • J Canter
      • Orchid_Projector
      • 1 yr ago
      • Reported - view

      Faness at YNAB My accounts are all setup to automatically import but right now my online account and YNAB don't match and I don't know why. I haven't done anything different. This happened to me recently with my Credit Card account where YNAB did not import 2 days worth of transactions and I don't know why. I even turned off the importing, redid it and it still didn't import them. I had to manually add them all in.  This is why other ways to reconcile would be helpful - when technology causes glitches or even human error happens.

      You can't see your register balance can you? I'm not missing something , am I?

      Reply Like
    • bobbucy I'm happy reconciling in the new YNAB works well for you! :)

      J Canter While there isn't a running balance column in the new YNAB, the Selected Total feature can help you figure out the balance of your account on any particular day:


      - In the search field, begin typing the date you’d like to check.
      - Click on “On or Before [Date]” from the drop-down menu.
      - Select all the transactions using the checkbox above the first transaction.

      In the upper right corner, you’ll see the Selected Total value which is the balance of the account on that day.

      If a transaction was in your account and then deleted (by accident or on purpose), you can't re-import the transaction into that account. You'd need to manually enter transactions or create a new account and move the transactions there in order to have those missing transactions appear - this is to prevent the same transactions from importing more than once.

      Give the Selected Total feature a try and let me know if it helps!

      Reply Like 3
      • Helen1958
      • All At Sea!
      • Maroon_Admiral
      • 1 yr ago
      • 1
      • Reported - view

      J Canter The Chrome Toolkit allows you to have a running balance but that's just  for the browser version

      Reply Like 1
    • Faness 
      I'm not able to easily reconcile by the current Account Balance shown on my CC. It has to do with how RBC displays their transactions and balances. The "Current Balance" is shown and assumedly up-to-date, so is reflecting transactions that have taken place same day, but which also take a day or two to show up on the transactions list. To compound this issue, only the credit and debit amounts are listed beside each transaction. There is no running balance associated with the transactions to show what it was on previous dates. I also need this feature, so I can reconcile based on a statement. Mine are digital, but the same premise seems to apply to me because of how my online banking displays.

      Reply Like
    • Hi Hot Pink Yearling !

      I actually have the same issue with Chase bank in my personal account. The transactions in Chase show in a different order than what they import in YNAB, so I use the Selected Total feature to tally the transactions in a different order for each date. 

      Since this thread was created, we've changed how we collect feedback. You can fill out our Feature Request form to let our development team know exactly what you'd like to see moving forward! :)

      Reply Like
  • 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.  

    Reply Like
  • 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!

    Reply Like 1
      • WordTenor
      • Arranged the menu, the venue, the seating.
      • WordTenor
      • 1 yr ago
      • 2
      • Reported - view

      Gold Falcon Pending  transactions are not included in the number that YNAB suggests is the balance when you reconcile.  You should always be matching the cleared balance at your bank to the cleared balance in YNAB. 

       If you are trying to reconcile to a date that is in the past,  you will need to ensure that any transactions since that date are left as pending,  which may require manually "un-clearing" them. 

      Reply Like 2
    • WordTenor Sorry, I meant pending transactions in my bank account. They aren't pending in YNAB, which is the problem. In order to make them pending in YNAB to match my bank, I would have to adjust the date on every single one of them, which seems incredibly inefficient. So, I grab the overall balance from my bank (including pending), which should technically match YNAB, assuming the pending amounts match what is in YNAB. Today, they were accurate, so they matched what YNAB had, so everything should have washed. I was $180+ off. :( I'm a bookkeeper, so I get all of the accounting/reconciling stuff (I use QB for my business), so there is just something "off" about this process in YNAB. Maybe I'm overthinking it, but not being able to reconcile is DUMB. :) Thanks for your suggestion, though!

      Reply Like 1
      • WordTenor
      • Arranged the menu, the venue, the seating.
      • WordTenor
      • 1 yr ago
      • 4
      • Reported - view

      Gold Falcon You're definitely overthinking it. Not all banks make the cleared balance obvious these days (they now err too far in the other direction, IMO), but you should still be able to find the cleared balance. You should never try to match a working balance. 

      A transaction which hasn't cleared your bank shouldn't be cleared in YNAB. So "they aren't pending in YNAB" should not be a thing. If they are pending at your bank, they should be pending in YNAB. 

      To reconcile to a past date, you unclear all transactions which cleared after that date. So if you got a statement for February 28 that says the cleared balance on that date was $1000 and since then, you've spent another $200 which has cleared, you have to unclear the $200 to get the numbers to match. The intended current method is a nod to the fact that the majority of new budgeters use their online account balance. So they look today at what the cleared balance is today, and check that it matches YNAB, and click reconcile.  If you want to do something other than that, it's more complicated to do. 

      You're not alone in being a financial professional who is confused by YNAB. The system is much simpler in execution than what you are probably used to. In five years of using the software and communicating with other users on various forums, I've often found that it's the accountants who bang their heads against the wall longest. Try not to overthink it! :) 

      Reply Like 4
    • WordTenor Thanks for your feedback! I understand and am doing all of that. Still off on my reconciliation, so not sure what is going on. I've gone back 4 weeks to verify all transactions match what is actually in my bank and am still off. Guess I will just have to let it go and try and reconcile daily to see where things get off. I definitely need to identify if it is user or system error, as I can't keep using YNAB if I'm constantly battling these issues! :)

      Reply Like 1
    • WordTenor I'm guessing that's part of my problem since I'm a CPA. But I still like one monthly reconciliation rather than having to log onto multiple accounts several times a week.

      Reply Like 1
  • 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.

    Reply Like 2
  • I'd love this feature too. I'm trying to reconcile my credit card statement. The bank has the balance as of a few days ago, but YNAB knows about some purchases that have not cleared yet.

    Reply Like
    • Pieter Nagel Pending transactions aren't included in the reconciliation, so you'll want to compare cleared balances in both places. You can also use the Selected Total feature to help you figure out the balance of your account on any particular day:

      - In the search field, begin typing the date you’d like to check.

      - Click on “On or Before [Date]” from the drop-down menu.

      - Select all the transactions using the checkbox above the first transaction.

      In the upper right corner, you’ll see the Selected Total value which is the balance of the account on that day.

      Let me know how it goes!

      Reply Like
  • 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!  

    Reply Like
    • Janelle Thank you!

      Reply Like
  • 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.

    Reply Like
      • VanillaCottage
      • Believer in the life-changing magic of YNAB4 - since 2013
      • VanillaCottage
      • 1 yr ago
      • Reported - view

      maryv Fill out the Feature Request form that Janelle posted a link to above.

      Reply Like
      • maryv
      • Khaki_Horn.1
      • 1 yr ago
      • 1
      • Reported - view

      VanillaCottage Did so yesterday - saw it after posting! Thanks.

      Reply Like 1
  • 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:

    1. Flag any cleared transactions dated after your statement date (to allow you to restore them later)
    2. Unclear those post-statement (flagged) transactions
    3. Reconcile, providing your statement balance
    4. Re-clear then un-flag the flagged transactions

    Hopefully this is helpful until YNAB adds a statement date capability to reconciliation.

    Reply Like 4
  • 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. 

    Reply Like 1
    • Hi Steel Blue Harp !

      Are you having trouble reconciling to a certain date or reconciling in general? WordTenor mentioned a work around to reconcile to a certain date, but if you're trying to pull in transactions from the last 6 months try File Based Importing. That will allow you to import your transactions - any that were already imported will be skipped and any that you manually entered will be Matched.

      That should help bridge the gap you're currently seeing! :)

      Reply Like
  • As a former YNAB 4 user, I really miss the feature. Reconcile is the only way to be aligned with my bank statement.

    Reply Like 1
    • That's helpful to know,  Hot Pink Trumpet ! Have you sent this into our development team through the Feature Request form? 

      Reply Like
    • Veronica at YNAB Just did, thanks for the link !

      Reply Like
  • I agree, I would like to see the feature that would allow us to reconcile to a specific date. 

    Reply Like 1
      • Jannelle
      • jannelle_ynabsupport
      • 10 mths ago
      • Reported - view

      Tomato Piranha Thank so much for letting us know! We’re always working to make YNAB better, and feedback gets digested by our design team, so I'm going to pass this on to them. You may not hear back with specifics, but our research operation is in full swing!

      Reply Like
  • +1 on this request.  This was an essential feature for me in both classic and new YNAB.  Please bring it back.

    Reply Like 1
  • +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.

    Reply Like 2
  • I also need this feature back! For those of us used to reconciling to the date on our bank statement it's essential. I'll try the work around mentioned above but really find this an unnecessary hassle. :(

    Reply Like 1
    • Forest Green Foal 

      If you still want to reconcile against your statement balance, that's definitely possible! Here's how:

      1. Mark all transactions in your account register that occur after your statement's closing date as uncleared (select those transactions and hit the "c" key on your keyboard to do this with multiple transactions at once).
      2. Click the reconcile button at the top right of your budget and enter the statement balance instead of your current account balance.
      3. Clear transactions from before that statement date until the Cleared balance of your (YNAB) account matches your statement balance - YNAB will automatically show you how close those balances are.

      That should do it! If you have more questions, please let me know!

      Reply Like 2
      • WordTenor
      • Arranged the menu, the venue, the seating.
      • WordTenor
      • 8 mths ago
      • 3
      • Reported - view

      Faness is exactly right! This is the procedure that dakinemaui and  I posted above. 

      Reply Like 3
  • I followed this and it worked. I'm just sayin I'd still prefer the former feature due to the ease. It looks like others have requested it as well and sent requests to the development team. Any chance they are going to honor those requests?

    Reply Like 2
    • Forest Green Foal 

      Let me see if I can explain our thinking here. :)

      The amount of money available for you to budget in YNAB is directly based on the amount of money in your bank accounts (so you can Give Every Dollar a Job!). As a result, if your account balance is off by +$100, you might think you have an extra $100 available in your budget. To avoid that issue, we recommend reconciling against your current account balances rather than the statement balances.

      This isn't to say that option can't make a return! The feature requests we receive are analyzed and coded so our development team can keep track of them and see just how they'd help users. They then use that information to update the What’s Up Next page. :)

      Reply Like
  • 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.

    Reply Like 1
    • Hi Bob Colclough ! I'm sorry to hear that you're having trouble. We have a Transition Guide all about the changes between YNAB 4 and the current version that should help there!

      If you want to reconcile against your statement balance, here's how to do that:

      1. Mark all transactions in your account register that occur after your statement's closing date as uncleared (select those transactions and hit the "c" key on your keyboard to do this with multiple transactions at once).
      2. Click the reconcile button at the top right of your budget and enter the statement balance instead of your current account balance.
      3. Clear transactions from before that statement date until the Cleared balance of your (YNAB) account matches your statement balance - YNAB will automatically show you how close those balances are.

      That should do it! If you have more questions, please let me know!

      Reply Like
      • dakinemaui
      • dakinemaui
      • 5 mths ago
      • Reported - view

      Nicole I suggest you add a step 0 to Flag those post-statement transactions that need to be un-cleared. This makes it easier to re-clear them after reconciliation is complete.

      Reply Like
      • Patzer
      • Retired at age 60. Thank you, YNAB!
      • Patzer
      • 5 mths ago
      • 3
      • Reported - view

      dakinemaui Of course, that would be much easier if there were a way to change multiple flags in a single operation.  I submitted a Feature Request for that over a year ago, and it hasn't happened.  Oh, wait . . . Toolkit fixed that.  I believe the guy who coded it said something like, "It only took until I actually used flags for me to realize how necessary this feature is."

      I conclude that no one at YNAB actually uses any of the no-brainer stuff we'd like to have fixed.

      Reply Like 3
  • 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. 

    Reply Like 1
  • 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. :-)

    Reply Like
    • Hi rog !

      Sorry for the trouble! There are steps listed above on how to reconcile up to a certain date, but I understand wanting to simplify that process. You can let our development team know by submitting a Feature Request. :)

      Reply Like
    • Faness How many more feature requests must be made before this becomes something the YNAB development team will look at adding? :)

      Reply Like
      • Patzer
      • Retired at age 60. Thank you, YNAB!
      • Patzer
      • 5 mths ago
      • 1
      • Reported - view

      Faness I don't have a dog in this fight, but for linked accounts your competition offers a choice of reconciliation to the linked bank balance or reconciliation to a statement:

       

      Reply Like 1
    • Hi Slate Blue Hammerhead !

      We don't keep an exact number of required feature requests for a feature to be implemented. Each feature requests goes to our development team, so they'll see each new submission and it'll update their database.

      Patzer Thank you for sharing that screenshot! It's interesting to see the other options available.

      Reply Like
  • 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? 

    Reply Like 1
      • Patzer
      • Retired at age 60. Thank you, YNAB!
      • Patzer
      • 5 mths ago
      • 2
      • Reported - view

      Bob Colclough 

      It's not that YNAB has too few resources; it's that none of the resources are ever devoted to no-brainer fixes like a Save As function, Reconcile to Date, or changing multiple flags in one operation.  Instead, we're told these are unnecessary and YNAB focuses on rolling out color changes or API functionality for a 3rd party that none of us have ever heard of.

      Customers:  We need this thing.

      YNAB (covering ears):  La, la, la, I can't hear you!

      Reply Like 2
  • @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??

    Reply Like
      • bevocat
      • Sometimes, It Just Sucks to Be You
      • bevocat
      • 5 mths ago
      • 4
      • Reported - view

      Bob Colclough Not if it means having to admit that something was a bug an unintended feature.

      Reply Like 4
  • #metoo 

    I understand why the new way was implemented. But, now that I’ve been on YNAB Classic for years I don’t need help assigning every dollar a job. 

    The work-around is tedious. Please implement a way to reconcile to the statement date. Feature request submitted.

    Reply Like 2
    • OregonRider Thank you for taking the time to submit a feature request! They're an important part of our research as we look into ways to continue to improve YNAB. :)

      Reply Like
Like10 Follow
  • Status Answered
  • 10 Likes
  • 9 days agoLast active
  • 72Replies
  • 2260Views
  • 42 Following