How to untangle budget/account mismatch mess?

Hi all. So, me and my wife have been using YNAB for a little over two months (just finished the trial). I was reading Help, FAQs, watched videos and contacted support about some bits, but the end result is a complete mess.

We dutifully classify all transactions, and setup budgets on the 1st of the month, and yet none of the credit card account balances match the YNAB view, and neither does checking account balance. We are constantly seeing negative To Be Budgeted and "you have overbudgeted" warnings and yet have ~10k on the checking at the end of the month (my paycheck comes at the last business day of the month).

(Honestly, considering how long YNAB has been around and how many people are using it, I am surprised it takes so much effort to ramp up and use it, especially outside of the app itself; lots of potential design improvements).

Anyway, we are tenacious and willing to work with YNAB for a bit more. I suspect that the main problem are credit card accounts and mismatches between their pay cycles, paycheck cycle and budgeting cycle (1st of the month), but that does not really explain the checking account mismatch as well.

Did anyone else have this problem? Is there a standard procedure to figure out and fix all the mismatches? I saw "manual reconciliation" but that does not seem like a proper/sustainable solution. And I do not want to start from scratch and lose the transaction and budget history...

I've read somewhere that one can re-characterize credit card accounts as "checking" (paid in full = our case), to disable YNAB money-moving magic for them, but I could not find how/where to do it - is it still a supported option?

17replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • For the credit cards, when you started using YNAB, did you budget the amount of your outstanding balance to the credit card payments section?  So if your starting balance was $555, then you should have budgeted $555 to the credit card payments section to reserve that money to pay off the card. 

    Reply Like 3
    • satcook I am trying to fix this retroactively for one card to start with. I've calculated my starting balance for Apr1 based on the March statement + one March transaction post-statement = 160.78.

      I budgeted 160.78 on that credit card. However, I think the problem is that YNAB does not apply that budget towards the payment:

      • Starting balance Apr 1 (budgeted for): $160.78 = $109.54 March stmt + $51.24 March transaction post-statement.
      • April expenses on the card: –$342.82 (all budgeted for in other categories, no overspending in any)
      • April also has 2 positive transactions:
        • +109.54 payment for March statement. I coded it as transfer from Checking to Card account, so there is no category, and I think that trips up YNAB.
        • +5.97 cashback from transactions in April (since March stmt) - coded as "To be budgeted" per YNAB guidelines.

      So, now YNAB considers that $109.54 as a return of some sort and shows me Apr activity on the account as $233.28 = –$342.82+$109.54. It adds that to $160.78 "budgeted for" and shows me that I have $394.06 balance left on the account by the end of the month.

      This is why I am saying YNAB is confusing.

      What I really need is for YNAB to code +$109.54 payment as an expense, and apply it toward the budgeted amount $160.78 on the CC itself. That would leave the end of the month balance on the credit card account as $51.54 to cover transaction from March which will be paid in May (from April statement).

      Reply Like
      • WordTenor
      • A polymath, a pain in the ....
      • WordTenor
      • 9 days ago
      • 1
      • Reported - view

      alexandroid What you see in the budget is not a reflection of the money owed, but a reflection of how much of the budget is reserved for paying the card. By the time you pay your card, you’ll likely have spent additional budgeted funds. For most people, the category will never be zero. 

      Your procedure is exactly correct. Maybe take a credit card webinar so that you understand the mechanics and what number should match what. 

      Reply Like 1
      • WordTenor
      • A polymath, a pain in the ....
      • WordTenor
      • 9 days ago
      • 5
      • Reported - view

      Also, don’t try to retroactively fix this. Just budget so that as of right now, in July, the card category and the working balance on the card are equal to the penny. You may need to move money from other categories to do this.

      Reply Like 5
    • WordTenor Is there a technical reason which should prevent me from fixing this retroactively?

      "As of right now" is a bit of a pain too since YNAB is 1-3 days behind on transactions, so I have to check every single card and account to subtract pending transactions which are not in YNAB yet.

      Reply Like
      • dakinemaui
      • dakinemaui
      • 9 days ago
      • Reported - view

      alexandroid As of right now means look at the account balance in YNAB. Make the category match it, whatever it is (as a positive number).

      When transactions import, both the account balance and CC Payment will be updated in lock step, assuming those are budgeted purchases.

      Reply Like
      • dakinemaui
      • dakinemaui
      • 9 days ago
      • 1
      • Reported - view
      alexandroid said:
      Is there a technical reason which should prevent me from fixing this retroactively

       Only if you consider expending effort for zero benefit a technical reason.

      Reply Like 1
      • satcook
      • satcook
      • 8 days ago
      • Reported - view

      alexandroid manually enter those pending transactions so YNAB is up to date!!

      Reply Like
      • WordTenor
      • A polymath, a pain in the ....
      • WordTenor
      • 8 days ago
      • 2
      • Reported - view

      what dakinemaui said. Basicallt just that it’s a pain in the tuchis for the same result. Right this minute, your card payment category should match to the penny whatever your card’s working balance is. While you should manually enter pending transactions, it ultimately doesn’t matter; when they downlaod, the numbers will change accordingly, provided the purchases are budgeted. Flip to the register *right now,* note the current working balance, and then budget the card category in the budget so that it is the same amount. 

      Reply Like 2
      • WordTenor
      • A polymath, a pain in the ....
      • WordTenor
      • 8 days ago
      • 2
      • Reported - view

      Also to be clear, for most folks while a transaction may take 1-3 days to *clear,* your cleared balance in YNAB vs the bank will usually be spot-on, or at most, will take 12 hours to equal out. You don’t use the working balance to reconcile; that balance includes those 1-3 days waiting transactions. 

      Reply Like 2
    • satcook Yes, it makes sense. This is another thing which YNAB app should warn about during new account linkage. They only say "don't worry, you can change it later". I am pretty sure I used "current balance" as shown on the 4/1 when I started the account tracking, without paying attention to transactions pending on the same day.

      Found a missing transaction (statement credit) in YNAB, after adding it retroactively the balance matched. This is 2nd or 3rd missing transaction I found in just 2 months of using YNAB =\

      Two accounts are done, three more to go!...

      Reply Like
  • If your paycheck doesn’t come until the end of the month, then you can’t budget that money until the end of the month. Once your TBB number is $0, you stop budgeting until you receive more money. 

    Reply Like 5
  • Hi alexandroid !

    If your accounts in YNAB aren’t matching the bank (account balance and transactions), then you can’t trust your budget. If you have $1,000 in your account, but YNAB thinks there's only $800 in that account, you can't budget all of the funds you have.

    YNAB only imports your balance once. From there, the balance is updated by the transactions you enter and import. This means if your balance in YNAB isn’t matching your bank, there is a transaction problem. 

    To get this fixed, use the reconcile feature in the web app (on your computer). You could open a separate browser window for the YNAB account and your online statement to more quickly check them back and forth.

    You have total control of the balance—look for the following in your register, fix any discrepancies, and you’ll be back on track:

    - Transactions that have cleared the bank but have a gray C next to them

    - Missing transactions that need to be entered or imported

    - Transactions you entered or imported that have the wrong amount (maybe inverted, 0.34 instead of 0.43, for example)

    - Duplicate transactions

    - An incorrect starting balance

    When you have a moment, take a look at our Ultimate Get Started Guide and consider taking one of our free, 20-minute workshops. :)

    If you still have questions, please let us know! We'd be more than happy to walk through setup with you!

    Reply Like
    • Faness Please see my reply above.

      Reply Like
  • YNAB is an envelope budgeting system. It is quite simple to understand once that fact is understood, but it takes a good number of people a moment to really understand what that means, especially if you make a good income and generally don’t run out of money. YNAB is going to show you scarcity that you aren’t necessarily feeling,

    Judging from your statement about cycles not lining up, I’m going to guess you probably are relying on some amount of credit card float. To get things in order, step one is to get your accounts accurate. I don’t recommend using the reconciliation feature, except to lock the final value. Don’t let it make an adjustment for you: if the balances don’t match, go through and match your transactions one by one with the bank until the cleared balances match. It’ll take a good minute, but understanding this aspect is vital.  

    Once the cleared balance for each account matches YNAB, you need to ensure that:

    1. You have no categories overspent

    2. TBB is not overbudgeted

    3. Your credit card payment categories match, to the penny, the working balance on the associated card.

    When those three things are satisfied, what is left in your budget is what you truly have available for spending. It’s going to be less than what you make, possibly a lot less. If there’s not enough left, come back and we can tell you how to get off the float.

    Reply Like 4
      • Tif_Ann
      • Tif_Ann
      • 9 days ago
      • 2
      • Reported - view

      WordTenor It seems they might also be relying on "paycheck float" (new one to me) in that the paycheck they seem to be budgeting arrives on the last day of the month.

      The paycheck should be paying your expenses that come after the paycheck, not before. If you are budgeting July based on July 31st's paycheck, you are overbudgeting. If you are using credit cards to pay your expenses that you are budgeting with money that doesn't exist you are also using tomorrow's money for today's bills.

      Getting off the float is your first step. If you can't budget your entire credit card balance AND all expenses you need to pay until your next paycheck with money you have in hand today, you are on the float and living on debt. 

      Reply Like 2
    • Tif_Ann WordTenor Yes, it seems that we may have this float happening. My plan is to move some money from savings to checking to deal with it (I know I can do it via budget categories alone but it seems cleaner and easier to follow this way).

      Reply Like
Like Follow
  • 8 days agoLast active
  • 17Replies
  • 211Views
  • 6 Following