Math just doesn't add up...potential reconcile error

Checking account reconciled, Check.

Savings accounts reconciled, Check.

Math adds up on budgeted money vs. available each time.

However, there is a $1.75 cent difference between the Funds for Mar and the Budgeted in Mar... BUT when the math is double-checked is should add up.

Do not want to sacrifice years of data (which I enjoy seeing trends) to fresh start.

Unsure how to correct the calculation error.

Thank you for any help you can offer.

23replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Is there any categories hidden, that have money still in them? I have a problem throwing off the balance there a time or two. 

    Like
    • Ruff16965 (05bd62cee897) great thought...but no hidden categories. I usually solve this by a math error on my part...but not this time. 

      Like
  •  I wouldn’t fresh start over $1.75 either. Did you have any budgeted money left over from Feb. With no categories selected, does your available in the inspector equal the sum of your cash accounts? Do you have a credit balance on any of your credit cards?

    Like
  • Or have you moved any money from one category to another that might give you negative balance and that could through you off the $1.75.

    Like
  • Hi Beige Nomad !

    Hmm, what a mystery! I'm sure we can get this figured out, without the need for a fresh start though. 😊

    Budgeted in [This Month] is the total of the Budgeted column in this month and Funds for [This Month] is the total of:

    • the amount leftover in To be Budgeted from last month
    • the amount Budgeted in Future from last month
    • all Inflow:To Be Budgeted transactions for the current month (including from Reconciliation Balance Adjustments)
    • any Starting Balance transactions with a date in the current month on cash accounts (not credit card accounts)
    • any positive credit card balances in the current month
    • any cash advances from a credit account to a cash account in the current month

     

    Do any of those possibilities add up to that $1.75? 

    Like
    • nolesrule
    • Been waiting 5 years for the Stealing From the Future fix...
    • nolesrule
    • 2 yrs ago
    • 1
    • Reported - view

    Unless you wall your months, money will flow between months.

    Like 1
  • After taking a couple of weeks to allow my frustration to settle... I am happy to report that the discrepancy has been corrected. I do not know where it was.. however, I deleted all of my March transactions (since I knew February was good to go) and reentered them all (as I exported my .CSV file to use as reference).  The crazy thing is that the export I did after I re-entered them is the same.... so I don't know where the $1.75 error originated... has there ever been any similar glitches reported?... but the important thing is that the numbers add up and I have a green box at the top that reads, "$0.00" to be budgeted.... so as you can all appreciate.. is a great feeling.

    Thank you all again for your time and assistance!

    -Travis

    Like 1
  • I spoke too soon... after reconciling each of my accounts... all are to the penny.... I have the identical $1.75 error.  Please help me.  I have done every single thing recommended above.

    Like
    • Beige Nomad I just noticed there was no response to your comment. Were you ever able to iron out that discrepancy?

      Like
  • I am having a similar problem.  The calculations are not accurate, and there is no way to inspect them or correct them.

    Like
    • Hi Green Cyborg ! Can you tell me a bit more about what you're seeing? I know you mentioned the calculations aren't accurate, which calculations are you referring to in your budget?

      Let me know and we can take a closer look at what's going on! :)

      Like
  • Hi! Thank you for following up. 

    I have just completed my first month (September) in nYNAB and in spite of reading everything available on budgeting with credit cards, it doesn't make sense to me.  In a spreadsheet, I can recreate formulas that produce the same results as YNAB to try to understand them (this wouldn't be necessary if you could inspect the components of how the numbers are calculated by clicking on them).  After spending several hours of that, I'm left with this question regarding the budget view:

    My credit card activity in Sept was +$963.81, meaning I spent almost $1000 more than I paid off on my card. The budget automatically fills in $963.81 for "available for payment" September.  The problem is that I've already made payments in September on the card -- these are included in the activity number.  I didn't have an additional $963.81 left to pay last month, plus there was a starting balance before the month's activity began.  (Please don't pass judgement: we don't usually carry a credit card balance, but we just paid a lump sum for orthodontics and need an extra two months to pay it off).  Now that it's October, I'm even more confused.  I've made a payment already, bringing my October activity so far to -$2642.01, and my actual credit card balance to -$1,060.34. 

    Logic tells me that if the balance is -$1060.34,  I need to pay an additional $1,060.34 to pay off this card in October.  So I budget $1060.34, expecting to see a nice $1060.34 payment indicated.  Instead, the budgeted amount for the card keeps jumping up to $1678.20 and the payment says $0.  Why would I need to budget $1678.20 to pay off $1060.34 and why would the money "available for payment" be $0???  Also, on the right, the budget says I have $963.81 "Cash left over from September," clearly meaning the additional amount I should have paid in Sept if I'd had the cash to pay it off.  How does that even factor in?

    I don't know if this is a glitch or if it's on purpose (since I'm new to this).  What I do know is that the credit card method is far from intuitive, and setting it up has been challenging and time consuming.  Even though I keep reading that I should stop obsessing about account balances and focus on BUDGETING, it's highly unlikely that I will have the confidence to do this if I can't trust the hidden calculations!  

    Thank you for your time (and sorry my frustration is coming through).

    Like
    • Here's a screenshot of what it looks like in Oct when I budget $1060.34 to pay off the AmEx.  It uses the $963.81 that I did not pay in Sept (calling it "cash left over") to say I have -$617.86 available to pay in October... and that I've overspent.  When I click on the -$617.86 "available" in the budget to cover the amount, it adds $617.86 to my budgeted amount.  I hate seeing the red in October, but even worse, it carries over as overspending into November as well.

      Like
      • WordTenor
      • I have the honor to be your obedient servant
      • WordTenor
      • 2 yrs ago
      • Reported - view

      Green Cyborg You had $963 available to make your payment. You made a much larger payment than that, subtracting  $2650 when you made the payment. Then you added $1040, but your balance in the category was -$1687, so adding $1040 couldn’t bring it all the way back to zero. It looks like you probably made a budgeted purchase or two which put a few dollars into the category. 

      While there is definitely some weirdness about returns and paying the card positive, the basic credit card functionality is relatively straightforward, even if it might seem a little confusing at first. You can’t pay more than is in the category at any time, or just like any other category, it will go overspent. The only fundamental difference between it and any other category is that in addition to you being able to budget money there directly, money moves to it automatically when you spend budgeted dollars. But you still can’t spend more than is in the category. If you do, it will show you that you are overspent—you have sent more money to the card company than the budget had set aside for that purpose, and as a result, the green amounts can’t be trusted. 

      Long story short—you need to move $600 to the card category, because you’ve already sent it to the card company and it’s not actually available to do the other jobs you thought it could do. 

      Like
    • Green Cyborg No judgment and no need to apologize! If you have a moment, I highly suggest our Master Credit Cards with your Budget workshop - it'll allow you to see credit cards in action and give you the chance to ask questions live! :)

      I can't tell based on the screenshot, but it sounds like you budgeted for the $963.81 you spent on the credit card. When you budget for an expense and then put that expense on your credit card, YNAB moves those funds from your spending category to your Credit Card category so those funds are now Available to pay your credit card bill.

      For instance, let's say you budget $20 towards Dining Out and then spend $20 on your credit card and categorize it as Dining Out. YNAB moves that $20 from your Dining Out category to your Credit Card category so you can now pay your credit card off in full.

      Since that $963.81 was Available, that's the amount you had put aside to pay towards your credit card statement. That $963.81 Available rolled over from last month, then you budgeted an additional $1,060.34, which gave you a total of $2,024.15 Available to pay towards your credit card (that's the max you had available to pay towards that card). Since you paid $2,642.01, you spent $617.86 more than what was budgeted to cover that balance. You'll need to budget $617.86 towards your credit card category to cover that negative.

      The key is to have your credit card Available amount match what you plan to pay towards your credit card. If you plan to make a $100 payment, and there's only $80 in that category, you'll need to budget another $20 to cover the difference.

      I hope that helps clear things up! You can take a look at our Quick Start Guide to Credit Cards for more information, or let me know if you still have questions! :)

      Like
    • Faness Thank you for your responses.  To clarify: I did NOT budget for the $963.81. 

      WordTenor

      The program automatically filled the $963.81 in as "available."  The program is not behaving as described.

      Firstly, budgeted amounts were not "moved" to the credit card category.  My credit card category budget in Sept is $0.  Instead, the outflows and inflows on the card give a net for the month of $963.81 (spent more than paid).  In other words, even though I made several payments, they only show up as part of "activity," and not in "budgeted."  It has been suggested that I budget an additional $600 amount to cover this amount.  When I try this, the $600 is ADDED to the $963.81 so that available has now increased to $1563.81.  

      How is it possible that budgeting the AMOUNT DUE on the card does not bring the credit card PAYMENT DUE to $0? I've signed up for the credit card workshop for tomorrow morning; thank you for the recommendation.  I'm not sure how taking a class will fix the math... hopefully it will reveal some error that I've made.  I've been budgeting for over 30 years, though: if I can't figure it out, it's more complicated than it needs to be!

      Like
      • WordTenor
      • I have the honor to be your obedient servant
      • WordTenor
      • 2 yrs ago
      • 1
      • Reported - view

      Green Cyborg  The credit card class isn’t so much about the math as helping you understand what the budget is doing. 

       When you spend budgeted money on a credit card,  the software automatically set that money aside so that it’s ready for when you need to make the payment.  Imagine it like cash in an envelope: when you spend money on dining out, it takes a $20 bill out of the dining out paper envelope, and put $20 into the credit card payment envelope. 

       That’s  where the $963 came from. So, in your budget, just like you might have $200 set aside for buying groceries, you had $963 set aside for making a credit card payment,  via money moving from one envelope to another automatically. 

       But you then spent a lot more than that.  You made a payment of $2650.  That was way more than the budget had set aside for the purpose of making a credit card payment.  So it showed you as overspent by over $1600— you sent $1600 to the credit card that may have been in your account, but which you currently had budgeted in other categories.  You took it from other envelopes, but you didn’t tell the software which envelopes you wanted to take it from. 

       You then budgeted $1040.  So you did take some money from some other envelopes.  but that still wasn’t enough, because when you sent your credit card payment, you sent $1600 more than the budget had set aside, not just $1000 more. So there still $600 left to go. 

       You can see this if you add up all of your positive category balances.  They will equal $600 more than what is actually in your account.  The missing $600 is the money you already sent to the credit card company.  By budgeting the $600 to cover that negative, you will bring the rest of your categories in line with the money you actually have on hand right now. 

      Like 1
  • Green Cyborg said:
    How is it possible that budgeting the AMOUNT DUE on the card does not bring the credit card PAYMENT DUE to $0?

     The Available amount is not equal to the Payment Due, it's the amount you've put aside to pay towards the credit card. When you budget funds towards your credit card category, you're increasing the amount of money set aside to pay your credit card bill, which increases the Available amount (because that's how much you have Available to pay the card balance).

    If you still have questions after the class, please don't hesitate to ask! :)

    Like
  • I'm not sure how many ways to say this: Sept was my first month (so it cannot be the fault of previous months), and I did NOT budget any $$ toward credit card payment.  There was still an automatically filled amount under "available."  This is so much more frustrating than it should be.  YNAB4 was a superior product in so many ways, this is just one.  

    Like
    • Green Cyborg I just sent you an email so we can take a closer look at what's going on. As long as it's okay with you, we'll investigate and get to the bottom of things! :)

      Like
      • WordTenor
      • I have the honor to be your obedient servant
      • WordTenor
      • 2 yrs ago
      • 3
      • Reported - view

      Green Cyborg I really do understand what you’re saying and I really do understand your confusion. I also understand what happened and am explaining exactly what that was. I know it’s not fun to feel confused, but you are assuming no one understands what has happened without carefully trying to understand what we’ve taken the time to write. You are going to hear exactly the same thing from the person from YNAB who emails you, but I hope the penny drops for you more easily with someone helping you one on one. I wish you the best of luck. When it clicks, it will click. 

      Like 3
      • Agent99
      • Working to Get Smart at budgeting, finances and life
      • Agent99.1
      • 2 yrs ago
      • Reported - view

      WordTenor  I tried nYNAB for 4 months as a test (along with YNAB4) and it never clicked. I took the class as well.  Should I ever use nYNAB, I will just set up as a Checking account. It really is not intuitive, and I'm pretty analytical.    I'll reach out to you if I do decide to use as designed since you seem to have the process on lock. 

      Like
      • WordTenor
      • I have the honor to be your obedient servant
      • WordTenor
      • 2 yrs ago
      • 1
      • Reported - view

      Agent99 If you understand the pre-YNAB debt category in YNAB 4, understanding the credit card payment category in nYNAB is a matter of understanding what two parts of the system you're looking at. In both systems, the relationship is that the budget tracks the debt, and the accounts track the card balance. In 4, what was visible in the budget was the carried debt, the accounts showed the balance, and you did math to figure out the payment. In web, what is visible in the budget is the payment, the accounts still show the balance, and you do math to figure out the carried debt. (It is also in the inspector.) 

      90%+ of the problems I see with credit cards (I would honestly be willing to guess it is nearly all of them, but I haven't kept track and wish I had) that aren't related to a return or cash back are people paying the card without budgeting for the payment first. This is especially confusing for YNAB 4 users, because YNAB 4 let you do this without throwing up any sort of warning. If you had a large enough base of working capital in YNAB 4, it was entirely possible to bumble along forever without realizing that you were consistently paying more than the budget had set aside, because you had enough cash to never really be in danger of overdraft. nYNAB gives you a big red angry oval the moment you go even a penny over, regardless of how much cash you have on hand. 

      Returns and cash back are a different matter, and I wish the devs would hurry up and just eat the requisite crow on that design and fix it. That SFTF is being worked on gives me hope that perhaps someday they will backpedal on how these are treated. 

      Like 1
Like Follow
  • Status Answered
  • 2 yrs agoLast active
  • 23Replies
  • 2412Views
  • 9 Following