Suggestion - Drag and Drop Transaction order for easy Reconciliation
Reconciling can sometimes be a a pain because the order of my transactions on my statement is different to the order in YNAB. When I have multiple transactions that are the same amount then it becomes even more difficult to cross reference them. This could be easily solved if I could drag and drop the transactions to match the order of my bank statement.
I would welcome any other tips. And yes, I do it everyday and I enter transactions manually. Even then I waste time. At the moment it has become difficult because I had about 10 uncleared transactions over the weekend, and some were the same price. And the dates are different on my bank statement to what I entered at the time of purchase.
Any help on offer? Thanks
Hi Pink Unicorn !
I run into this issue, too! I bank with Chase and transactions import with the Cleared date rather than the date they took place - so, usually, all of my weekend transactions are dated for Monday and out of order.
The Selected Total feature helps me keep track of things. I select each transaction as I go - I follow the order on Chase's website, which means clicking on them out of order in YNAB, but it lets me track the total as I go.
You can also edit the dates of the transactions to match your bank and use the Filter options to help pinpoint dates ( I find it easier to work with a smaller view of transactions).
Lastly, my colleague Jen (who has been using YNAB for 9 years now) shared her budgeting workflow in this Five Minute Fix blog post.
Give those options a try and let us know what you think! :)
Thanks for the response. Yes, I can do it that way, but I have lots of transactions that are the same amount. For example, I get lots of $1 coffees at my 7 eleven. I eat lots of $8 subways. Because the dates d not match up, I cannot remember if I have already marked off the transaction or not. I enter everything manually, so then I have to work out which transactions I may have forgotten. At the moment it is very much guess and check.
I'm a bookkeeper so I do a lot of reconciliation using various software. I've never come across a system that has the sort of drag and drop functionality you're discussing, but I do understand wanting to be able to resort the order when there are multiple, confusing entries to check. In that case, I usually put something at the beginning of the memo like a date and/or a sequential number, then sort on the memo.
I realise this isn't what you ultimately want, but maybe it might help as a workaround?
I would also like to be able to move transactions around, or at least have them stay in the order in which I entered them - which is sometimes not how they seem to wind up. It seems as though when you sort by date, YNAB does a secondary sort by payee name or something. A transaction time field might be helpful here.
I also think this should be a feature
I am currently looking at some transactions that all happened on the same day and brought an account balance back to 0, then the balance went back up again, but based on the order they are in in YNAB I cannot see that the account balance was actually ever 0, and I do actually need to know that it was
I have logged the following with the Design Team:
Due to the default ordering of transactions, YNAB shows that my cheque account goes into overdraft when it in fact doesn't, as I have transferred funds in on the same day to cover the expense. I love YNAB more than any other budgeting tools because the psychological/habit aspects of money management are built into the way the application works. Because of YNAB I have conquered my overdraft (thank you!). So being able to look at my cheque account in the register and not see any red balances is a matter of pride for me and a big motivation to keep it that way. But because YNAB sorts by biggest outflow to biggest inflow it shows overdrafts when there are not any. So there are two suggestions to solve this. 1] Have a settings option to sort by either biggest outflow to biggest inflow OR biggest inflow to biggest outflow 2] Allow for drag an drop manual sorting on each day. Pretty please.