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.

78replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • I have no idea how to reconcile properly without this functionality. Can someone explain to me what to do if I'm forced to reconcile today's date but I still have pending transactions waiting on my account? I put $8 in ynab but the pending transaction for gasoline is often just $1 because its a credit check. This throws off my total balance and I have no way to fix this as far as I know. I'm still on a trial and wading through the mess to get it so my wife and I could share a budget was time consuming enough. This is going to be a deal breaker if there's not some way to handle this that I am not thinking of. It's hard enough to get my wife to use the software, much less with these kinds of complications.

    Like
      • Superbone
      • YNAB convert since 2008
      • Superbone
      • 2 mths ago
      • 2
      • Reported - view

      Tan Screwdiver Reconcile to your cleared balance, not your working balance.

      Like 2
      • dakinemaui
      • dakinemaui
      • 2 mths ago
      • 4
      • Reported - view

      Tan Screwdiver Pending transactions you've manually entered into YNAB should not be cleared. They should also be excluded from the balance you provide at the start of reconciliation (obtained from the website). Thus, there is no conflict.

      This should not be a deal breaker.

      Like 4
    • dakinemaui Superbone My bank doesn't give me my cleared balance. They give me what they expect to be my cleared balance (for good reason, I imagine, since it shows me what I can likely spend). Are you saying I should take that balance, subtract the 20 pending transactions by hand, and then use the number I come up with to reconcile against? That seems really silly. Can I just reconcile against my last statement instead?

      Like
      • dakinemaui
      • dakinemaui
      • 2 mths ago
      • 2
      • Reported - view

      Tan Screwdiver Certainly you can reconcile to your statement. You can also talk to your bank to perhaps explain a less tedious approach to find the actual cleared balance.

      Perhaps one possibility is if your bank's website shows a running balance that excludes pending transactions.

      Like 2
      • dakinemaui
      • dakinemaui
      • 2 mths ago
      • Reported - view

      Another possibility might be that the website or mobile app may give more information, including the actual cleared balance.

      Additionally, you won't always have 20 pending transactions. Reconcile when the number is more manageable.

      Ultimately, you could stop using this CC. At the very least you should lodge a complaint with their customer service. You cannot be the only user who needs the cleared balance.

      Best of luck!

      Like
      • dakinemaui
      • dakinemaui
      • 2 mths ago
      • Reported - view
      dakinemaui said:
      Certainly you can reconcile to your statement

      Forgot to mention that process is described several times earlier in the thread.

      Like
    • dakinemaui So I think I understand where the confusion is happening for new people like me. When I go to reconcile my account it first asks if $123 is my current balance and I say no. Then it asks: "Enter your *current* balance". Instead of saying "current balance" this needs to say "current cleared balance" or something to that effect. That was my main point of confusion.

      Like 2
      • dakinemaui
      • dakinemaui
      • 2 mths ago
      • 2
      • Reported - view

      Tan Screwdiver Makes sense. That input was designed several years ago when the main balance the bank would show was, in fact, the cleared balance. Times change, it seems, and more than a few banks today seem to think showing you the "working" balance (including pending transactions) is the way to go.

      Like 2
      • Momofboysx3
      • I'm going to master budgeting, even if it kills me!
      • Steel_Blue_Mainframe.11
      • 2 mths ago
      • Reported - view

      Tan Screwdiver Just curious if you are looking at your bank balance only on a mobile app? My mobile app doesn't not give a running balance, but when I log into the webpage on a computer, I can get the running balance. Just a thought.

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

      dakinemaui This was actually mandated by the Consumer Finance Protection Bureau circa 2010, 2011., along with a bunch of other disclosures about overdraft operation. 

      Like 1
  • I would like a reconciliation date feature as well. My accounts are linked to my bank and are imported automatically. However, when I reconcile over the weekend some transactions don't get imported (since they're in pending status on my bank account). The following week, these records that were in pending status get imported (after I've reconciled my account), but these newly imported records are backdated. So I have to reconcile it again - and YNAB adds another reconciliation record again!!

     

    I like the date feature since I reconcile it with my statement ending balance and date. All transactions should have cleared and imported to YNAB by the time it's the end of the statement date.

    Like
  • I’m going to submit a feature request for this as well. I don’t link my accounts because I feel it disconnected that way. Also, it would be nice to know at a specific date that your accounts are reconciled.

    Like 1
  • I would really like to see this feature return to the app. Sure it works great when the bank sync is reliable (US only) but for many non-US YNAB customers, reliable bank sync is a long way off. Manual imports can often lead to missed or duplicated transactions which throw off the reconciliation process.

     

    Whenever I couldn't reconcile to 'today's date' I used to go through historical statements in bitesize chunks, say 1 week at a time until I found the rogue / missing figure - added it and watch everything subsequent to that fall into place nicely.

     

    I'm not stupid. Yet without this figure I have not been able to reconcile my accounts since July - I've never had enough time to go through all of the data.  This is seriously making me contemplate abandoning YNAB.

    Like
  • AW said:
    Manual imports can often lead to missed or duplicated transactions

    Make sure the download window is a few days before the most recent locked transaction. This will ensure there are no misses. There should not be any duplicates because of matching or prior import signatures.

    If you are seeing duplicates, then you should make a bug report.

    Like 1
  • Obligatory "Yes I filed a feature request"

    Wow it's kind of amazing this hasn't been implemented yet. I used the old YNAB and not being able to do a proper reconciliation in the new version is a head scratcher. Do we not understand what reconciliation means?

    If I've reconciled a transaction, I've confirmed my records match the bank records, and I don't have to worry about it anymore. Even YNAB by default hides reconciled transactions. So when I get my statement from the bank, I reconcile the transactions in the statement to my records. If everything matches, I can file the statement away and never worry about it again. If there is ever a discrepancy between my records and the bank's, I know that discrepancy came in since the last statement. This is all pretty basic stuff, and worked correctly in the old version - and it was very easy: enter in the statement date and the amount, and most of the time YNAB would correctly reconcile the transaction list to the info, and hide the reconciled transactions (who needs to actively track them anymore?).

    With automatic transaction imports, YNAB is assuming the transaction downloaded from the bank is the information to reconcile, but I don't think anyone who has used online banking for long would consider that to be the case. If you have a discrepancy with your bank, they're going to go to your statements, not your online banking portal.

    Please fix this, YNAB. I have 27 days left on my trial.

    Like
      • Ceeses
      • Ceeses
      • yesterday
      • Reported - view

      Sea Green Octopus Interesting point of view. For me, reconciling only once a month (at best, most of my accounts only give me quarterly statements) would mean more work for me. It is a lot easier to find a discrepancy within a week worth of transactions (or less) than within a month worth of transactions.
      I also agree with dakinemaui , banks don't look at statements anymore but at the ongoing record of transactions, even the pending ones if I have an issue with a transaction.

      In short, I prefer to reconcile as I go. To give an example: one day I was checking transactions in YNAB with the bank record. And there was a discrepancy between the cleared balances. I searched. I uncleared all unreconciled transactions and there was still a discrepancy! This told me the issue was at my bank! And sure enough, I connected a few days after and the discrepancy was gone. This was much easier to do with few unreconciled transactions than with a month worth.

      Like
  • Sea Green Octopus said:
    for long would consider that to be the case. If you have a discrepancy with your bank, they're going to go to your statements, not your online banking portal

    Not in my experience. They would rather know if an issue as soon as possible -- potential fraud -- and waiting possibly another 4 weeks for a statement increases their risk.

    Like
  • Sea Green Octopus said:
    Please fix this, YNAB. I have 27 days left on my trial.

    Don't hold your breath. There are issues that have existed since launch over 4 years ago.

    Still, you won't find a better tool, IMHO. The tedium / workarounds are still better than using any available alternative.

    Like
Like11 Follow
  • Status Answered
  • 11 Likes
  • yesterdayLast active
  • 78Replies
  • 2351Views
  • 45 Following