Credit card transactions failed to import for 2 months, except for balance payments: how to reconcile?

YNAB failed to connect to my CC account between early November and mid-January. I use this CC for a bunch of monthly subscriptions that were thus paid for, but these transactions were not recorded in YNAB. I auto-pay the full balance on that CC every month. YNAB did record the balance payments, probably because it got these transactions from my checking account (no linking problem there). Unless I'm missing something, I think I'm good "overall": the recorded balance payments ensure that YNAB shows me how much money I actually have in total, up to the last payment. 

Because CC balance payments were recorded but my CC usage was not, that CC's balance on YNAB was off, and the "amount available" corresponding to the CC in my budget went negative. I just managed to reconnect my CC account to YNAB. To adjust for the missing transactions, I added a reconciling transaction that makes my CC's balance on YNAB match with the actual one. That however did not change the budget part: the "amount available" on my CC is still at the same negative value. I don't understand why. Shouldn't the reconciling transaction raise my CC's "amount available" and reduce my amount "To be budgeted"?

Am I doing anything wrong here? 

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Arguably, the best approach is to change the category on the reconciliation adjustment to the most likely category. This will then automatically move funds from that category to the CC Payment category, avoiding the overspending there.

    However, if those purchases hit a lot of categories, probably easiest thing is to just reallocate manually. The red category indicates the funds the CC took as payment are still reserved elsewhere in the budget. The best place to take from is the lowest priority category with funds. That may or may not be the category the expenses would have hit had you recorded the transactions instead of the reconciliation adjustment.

    Like
    • dakinemaui Thanks!

      It's fine for me if the missing transactions are not categorized well. I can take their total amount from my "savings" category. 

      But something else is puzzling me now. My CC budget category had a available amount of -$250 when the reconciliation adjustment was categorized in "to be budgeted". I changed the category on the reconciliation adjustment, worth $475, to my "savings" category (which is just a regular, sufficiently funded category).  I did not do anything else, and no other transaction was recorded on that CC in the meantime. I expected the CC available amount to go up to -250 + 475 = $225. But it went up by less: it's now at -$22. Do you have any idea why that happens?

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

      Turquoise Crab if the Savings category is still green, I would have expected the CC Payment category to have increased by the transaction amount as well. I'm sure Support could look at your budget and explain it, though. They are always good about that sort of thing.

      Like
    • dakinemaui I think I figured it out. When the available amount in a CC category goes negative, YNAB interprets it as "income" and funds your "to be budgeted" with it. That behavior makes sense in normal cases, e.g. if you get a refund, or some form of cash reward on your CC (see https://docs.youneedabudget.com/article/728-credit-cards-with-a-positive-balance).  But it my case it was a little confusing. After playing around with "to be budgeted" and the CC budget, I think I'm back on track.

      Thanks for your help!

      Like 1
      • dakinemaui
      • dakinemaui
      • 6 mths ago
      • Reported - view

      Turquoise Crab it's actually when the CC account goes positive that that's considered income. (People often see the CC Payment category go negative without TBB being increased.) Regardless, glad you're sorted now. 🙂

      Like
  • Turquoise Crab said:
    I added a reconciling transaction that makes my CC's balance on YNAB match with the actual one. That however did not change the budget part: the "amount available" on my CC is still at the same negative value. I don't understand why.

    Hi, there! Just adding a bit more context here: Money will move credit card payment category from your spending categories when you make a purchase on your credit card and categorize it with a funded category. This is called "budgeted spending."

    Money isn't moving to the Credit Card Payment category in this case because your Reconciliation Balance Adjustment is simply a balance adjustment on the card. It's not budgeted spending because it's not categorized to a funded category.

    It seems like your best options for getting this back in line have been outlined by dakinemaui above! :)

    Like
Like Follow
  • 6 mths agoLast active
  • 6Replies
  • 72Views
  • 2 Following