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