I've been using YNAB for just over a year now but hadn't been reconciling - didn't understand what that little 'c' at the right meant. I should also say that I enter everything manually. I could see that my figures for actual account balances and the YNAB figures were out of whack so I went to reconcile last night and have made a bit of a mess! The cleared balance is now correct but the uncleared one is far from it. Is there any way to choose 'clear all transactions'?
My other option I suppose is to start over, but I don't want to lose my budgeting records as I may be retiring later this year and my income will drop significantly - I want to hold on to those figures to help me to be strategic with money into the future.
All suggestions welcome.
Orange Hammerhead said:
Is there any way to choose 'clear all transactions'?
Select all, then Clear. However, I would uncheck (before clearing) any recent transactions you've manually entered that you know haven't shown up at the bank. Optionally, delete any adjustment transaction you just made. Then do another Reconciliation / adjustment transaction.
It could end up being a ton of work, but if you are sure it's the transactions in the account that are the problem, not the category balances, here is what I would do:
1. Export your budget (option in the drop down menu gives you a zip file with a CSV for all transactions and one for the budget.
2. Extract the transactions CSV and save as xlsx (or favorite spreadsheet format)
3. Sort by account & pull all the items for the problem account into a new tab, along with headers. If multiple accounts are a problem, it might be worth doing this for all accounts.
4. Sort the account tab by date in the order that matches your bank statements.
5. Get all the bank statements for the time period covered by the account. For each month, highlight the transactions on the spreadsheet that match the statement. Figure out the total of those transactions. If that matches the statement, move on to the next month. If transactions are missing, check if they are there in a different month. They may need to be added to YNAB.
Keep going until it matches.
Hi Orange Hammerhead !
Since you mentioned that you haven't reconciled before, it’s best (or quickest) to enter a reconciliation balance adjustment and move on. Going forward, the more often you reconcile, the easier it’ll get! Once you’re in the habit, you’ll knock it out in a few minutes (or less!).
In the left column of your account register, there is a checkbox to Select All. In the Edit menu, you'll see the option to Mark as Cleared. I'll include a screenshot of those steps below! As dakinemaui mentioned, make sure to uncheck any transactions that haven't cleared your bank.
If a Fresh Start is something you're still considering, it will save a copy of your current budget. Check out that HelpDoc for more details! You will be able to view that historical data in a separate, archived budget any time you'd like.
Let me know if you have any other questions!
Thanks to everyone who helped me out with this along the way.
I now have made a Fresh Start and I have a query about my current account - I've always manually entered my spending into the App, into the appropriate category. But if I use my debit card, for example in the supermarket, and I spend let's say €50 on groceries but also get €100 cashback (not sure what this is called in the States). I enter €50 into the supermarket category, out of my current account, but what do I do with the €100 cash, how do I enter it?
For simplicity let's say I use this cash on my next two visits to the supermarket - €50 each time. In YNAB I enter the spend in the supermarket category and show it coming from my current account? But there is something off somewhere isn't there?
Has anyone yet written the Dummies Guide to YNAB?? Thanks in advance...