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.
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?
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!
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).
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! :)
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.