Show transactions in order of entering
Is it possible to order transactions by the time I entered them, such that they are in the same order as on my bank statement?
Can you elaborate why you want those to match? The bank order isn't guaranteed to match the spending order because of variable delays in vendor processing.
If you're manually entering transactions while looking at the bank statement, you can clear them right then and there and reconcile. Outside of clearing/reconciliation, I can't think of a reason you would be comparing YNAB to the bank statement.
I know that I can reconcile by clearing, but this still requires a lot of searching:
- Sometimes I don't have time to enter all transactions of a given day, when I want to continue later I have to first go through all the transactions of that day on my bankaccount to find the first one that is not yet in YNAB, instead of just looking at the top one in YNAB and starting from there
- When reconciling I can indeed clear transactions in order, but because they are not in the right order I have to really search for every transaction before I clear it. Kind of a hassle, if they were in the right order I could easily spot which one is wrong.
- Actually, even entering the transactions themselves is very error prone, because the last transaction that I entered it. It happens to me quite often that I accidentally skip a transaction or enter one twice because of this.
I submitted a feature request now to match order of entering and/or provide functionality to reorder by dragging.
Thanks for the suggestion :). I have tried it before but I ended up having to correct so many things from the file my bank gave me that it took me more time than just manually entering. I also prefer to keep a close eye on my budget: if I have the time, I enter a transaction right after I do it (resulting in some of the inconveniences described above).
So, it is not that I have any real problems, I just think it would be more convenient if my transactions weren't automatically reordered. I can imagine that from a back end perspective there might be difficulties with what I'm requesting (or it might even be impossible), but I still wanted to submit the request in case other people might experience the same inconveniences.
I would like this so I can just look at the bank website, drag the purchase down/up and fee it would help me reconcile better.
I think you answered your own question. As soon as you find it -- in order to drag it -- just clear it then and there, and you're done with it. No need to drag AND clear when you can just clear.
I always manually enter transactions - YNAB apparently can't import from my bank - and I reconcile all accounts every day. (I have a husband and 3 teenaged kids who apparently can't remember for more than 24 hours what they purchased and why!) Takes me about 10 minutes while my coffee is brewing...
But before I did this I would just reconcile my credit cards from the bottom up (on the CC website). I would just find the running balance on the CC activity that matched my YNAB working balance and move up from there. Even if things weren't in the exact order they were usually within 2 or 3 transactions so not that hard to find... (I use QuickBooks at work and have the same issue but multiplied by 10 so maybe I'm just used to it)
Salmon Guitar said:
finding matching transactions in two list with different orders is just as easy as finding matching transactions in two lists that have the same order (I honestly don't even understand how you can seriously make that point).
About this specifically... I would not insist it is just as easy. However, you've assumed the order in the second case, which is not guaranteed to be true in the real world. I've pointed out how delays in entry can lead to a mismatch from transaction approval order.
So yes, I agree entry order would solve that assumed problem. I'm just more interested in addressing the actual problem.
Yes, I noticed in your case you said that you enter based on the bank app, which indeed means YOUR scenario is exactly the assumed problem. However, the overall goal is to reconcile. By clearing immediately, you completely side-step the transaction order issue without waiting on YNAB to do anything.
the order of transactions processed by banks on the same day is mandated by law to be largest inflow to largest outflow.
Thanks for this info. This is helpful as I am sometimes frustrated by the transaction lineup and wonder why it's in the order it is.
I sort by outflow amount when reconciling
Can you elaborate on this? I clicked on "Outflow" at the top of the screen, but the first transaction was months ago.
I would say +1 to this. Even more so since the partial balance column introduction. I usually keep track of my partial balance by dates. I would suggest that the "DATE" field had an optional "TIME" for the transaction. So, this way we can sort the transactions by the order they came up and compare the partial balance correctly... My biggest issue is that sometimes this column shows the running balance as negative but it was never negative, it's just because YNAB keeps sorting the inflows and then the outflows backwards.
This way if you don't set the time for the transaction it defaults to the current sorting algorithm, but if you set the time it will sort taking that into account.
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.