Reconciliation nightmares

We run through hundreds of transactions each month. Reconciling weekly takes us hours. We cannot discover a way to find the last amount we reconciled to, instead of a running balance. I would like to start from the last date, amount and transactions I reconciled to. As it is I end up going back to the beginning of time. The dates of the monthly amounts do not match the cycle dates of the bank. How can I lock my accounts to the last amount reconciled to? The program "locks" transactions but does not provide a date and amount of the last reconciliation. We are about to abandon YNAB after several months of extreme frustration. Our problems with reconciling have overshadowed any attempts to use the program for budgeting--which was our intention when I purchased the program. 

11replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • nolesrule
    • Stealing From the Future fix is an improvement but is incomplete....
    • nolesrule
    • 3 yrs ago
    • 3
    • Reported - view

    You could always log the information externally. I know that's not the ideal answer.

    And I agree that YNAB should provide the date/amount information, and that the reconciliation function should have a date entry for those that do statement reconciliations.

    Unfortunately the problem is that YNAB considers itself a budgeting program first and foremost and doesn't consider proper account management features to be a priority, even though proper account management is necessary for an accurate budget.

    Like 3
    • WordTenor
    • Can we agree that goals are dumb and immature? Sure.
    • WordTenor
    • 3 yrs ago
    • 1
    • Reported - view

    It is true that at this time, there's no way to reconcile to a specific date. This was a feature in prior versions and you might make a feature request to bring it back. 

    You can see the previous reconciled amount by unclearing all transactions which have happened since the last reconciliation (those which are clearedbut not locked). This does necessitate clearing them by hand, though, which might be cumbersome. But if you unclear them, you will see the date of the most recent un-reconciled transaction, and, at the top of the screen, the cleared balance should match your last reconciled balance. 

    I would just suggest reconciling more often, based on transaction volume rather than by date. I don't have hundreds and hundreds of transactions, I admit, but I reconcile all my accounts based on volume. My cash investments pass through account has an interest transaction of pennies each month and otherwise only one transaction per quarter to pay my financial planner. I reconcile it about every six to twelve months. My main credit card, on the other hand, I reconcile at least once a month, when I have more than a screen or two of unreconciled transactions. You may be finding that a week is too infrequent for the volume of transactions you have. 

    Like 1
      • WordTenor
      • Can we agree that goals are dumb and immature? Sure.
      • WordTenor
      • 3 yrs ago
      • Reported - view

       One thing I will point out though is that you should never have to go back to the beginning of time except for the first time you reconcile. If your accounts reconciled at point A and you used the reconciliation tool to indicate that in YNAB, any mistake is after that point. The only reason you'd need to go back before that point is if you reconciled to the wrong number originally. 

      Like
    • WordTenor 

      Like
      • jenmas
      • jenmas
      • 3 yrs ago
      • Reported - view

      What WordTenor said. Once you reconcile a transaction, it is locked, so if you sort by cleared status, you will see which transactions have been reconciled and what date that happened (first make sure that the filter setting will show the reconciled transactions - I have mine set to hide all reconciled transactions so my registers only show clear and uncleared transactions). I clear transactions daily and reconcile weekly.

      Like
    • MsTJ
    • YNAB has given me back my future
    • Believer_in_YNAb
    • 3 yrs ago
    • Reported - view

    The other option is to reconcile more often.

    Like
  • You could probably use the filters as well to show all items cleared but not reconciled. Then you could check the box at the top that checks all the transactions at once then do a mass unclear instead of doing each one manually. 

    Like 1
    • MsTJ
    • YNAB has given me back my future
    • Believer_in_YNAb
    • 3 yrs ago
    • Reported - view

    YNAB recommends checking in with your budget daily.  When done daily, there isn't much catch up you have to do.  Also, do you check your budget when spending?  That is also recommended.

    Here is the official position, https://docs.youneedabudget.com/article/776-quick-start-a-daily-budget-routine

    Like
  • Chiming in to amplify the filter suggestion. Maybe I am not understanding the basic issue you are having, because I keep all reconciled amounts hidden, making it very easy for me to know where my last reconciliation point was. If you are unfamiliar with this function, it is right next to the search bar -- choose "filters" and then check the box that says "hide all reconciled transactions." (Or is it unhide all reconciled? I am working from memory, here.) That said, YNAB automatically hides reconciled transactions, so the only reason to use the filter is if you have undone the hiding for some reason.

    Oh, that said, I can share what I do, which might help if you want other visual cues. Because I do my reconciliation online, it's very easy to lose track of whether I have captured every transaction (since I can't cross out or check off anything, and because YNAB and my banks tend to have differing dates for many transactions). So what I do is to use the flag function -- as I move item-by-item through my bank statement, I turn the corresponding YNAB transaction's flag green. This allows me to do a visual check to confirm all YNAB entries have been addressed. This makes it very easy to see where I last reconciled, without having to distinguish between the green "cleared" circular symbol and the green lock symbol which, while different shapes, aren't visually distinct enough for me to consistently pick out when scanning. (I also flag the reconciled amount, if there is one, in a different color, so that I can always locate it easily.

    Like 1
  • Just a suggestion: Try entering everything manually. I find it is actually easier. Since I've started faithfully adding each transaction as soon as I buy something (whether online or in person), I find reconciling is really pretty quick, as there are rarely discrepancies.  Also, reconciling every few days helps. By the YNAB method, you just enter the bank or credit card's balance as shown, and then check everything that matches. If it has a green "lock" icon, it can safely be ignored, as that transaction was already recorded in a previous reconciliation. So no need to have a starting balance.

    Like 1
  • By chance, do any of you YNABers live in Houston?  I'm 2 months in and having some challenges.  YNAB support is great but would love to sit down with a YNAB pro in person.  

     

    [email protected]

    Like
Like1 Follow
  • 1 Likes
  • 3 yrs agoLast active
  • 11Replies
  • 2869Views
  • 9 Following