Dan at YNAB Thanks, Dan.

Dan -pinging you per your comment above about @ing you…

D Twist I hope you don't mind if I jump in for Dan! Thank you so much for your frank and honest two cents, it is indeed appreciated! I'm going to pass it along to our Design team, and you are of course welcome to submit your feedback via the Feature Request Form. 

Faness I know there is some logic behind how the transactions are ordered, but I can't remember exactly what it is, but I think it would be good info to know, esp for this question. I think that for a given date, inflows show before outflows, and then by amount of  transaction.

Can you provide information on exactly how YNAB orders transactions? Does it put imported transactions in a different order?

Faness Basically you are saying (in a vague way) that you don't have a column in your database of Transaction Time, do you can't sort transaction apart from Date, then Amount.

It is a pretty basic design flaw.

Slate Blue Koala And what would be the overriding sort? CreationDatetime? LastUpdatedDatetime? If you import, should it be the order reported from the import process to override the manual timestamps? None of them are wrong, none of them are right. But there can be only one. Intradate sort order really doesn't matter much in the grand scheme of things.

I am not in the USofA so I can't import and have to reconcile by comparing the transactions in my bank app and the mobile YNAB app. My bank (oddly) doesn't sort transactions by value, so yes intradate order DOES matter to me. Maybe not to you. This was all clearly  covered in earlier posts. So I would be happy by Time Manually Entered. This is what this thread is about after all 

If the current ordering suits you then fine. But why lecture people with different needs/wants.

in a full functioned system you ought to be able to sort by whatever value you put in the Sort Order field. I reckon guys using the APIs would agree?

nolesrule But ManualEntryOrder would probably suit.

adriana01 By default, transactions are sorted by Date, then largest inflow to outflow - for transactions of the same amount, the Entity ID is the deciding factor (but this number isn't available for view, it's how YNAB identifies the transaction on the backend). 

Faness thanks!

Faness nolesrule Beige Koala  Jiří Heger     Sorry, I think I should start a new thread. My issue is that I manually enter my transactions then reconcile against my bank's online web application. I don't use a computer and do everything on my phone or tablet. As YNAB sorts the transactions by value, they are never in the same order as the actual records in my account. To reconcile I have to scroll up and down to find them and then find them again to set them as cleared. It is tedious. BTW You can't import transactions in the mobile app only in the browser. Again this is the way the app was designed, so it's not a 'defect'. 

Slate Blue Koala my transactions are almost never in the same order as the bank either when I reconcile. But it is a lot harder to clear a transaction on the mobile app than the web app, so I can see how that would become frustrating.

Do you have a browser that you can force YNAB to be in desktop mode with? I can do that with Chrome on my Android phone. The lines would probably be too small to use for reconciling, but maybe it would look better on your tablet?

adriana01 Sometimes it lets me use browser app and sometimes it just throws me into the mobile app, even I set to Desktop mode. Sigh...

Slate Blue Koala Thank you for explaining why you'd find this feature helpful! Reconciling on mobile currently isn't available, so I understand the extra steps currently needed. We want the app to be as functional as the web app, but we're not quite there yet.

Faness It would help if the YNAB browser version didn't automatically open the Mobile app even when I run Chrome in Desktop mode on my phone. I understand it would be ugly. But then I could import transactions. Which would make things much much easier. I used to he able to use the browser version on my phone, but it stopped happening a while sho. Seems to work for some people still tho?! Any idea how to implement this 'hack'?

adriana01 Faness Hi Adriana. I used to he able to use the browser version on my phone, but it stopped happening a while ago. I raised this in a chat and was told ' running the browser app on touch devices is deliberately not supported as the UI would not be usable' What phone are you using ? I have a Nokia 8 running plain Android.

Slate Blue Koala I have a Motorola G5 running Android 8. When I use the Chrome browser to go to the YNAB app page, when it first loads it has the error page to use the mobile app. Then I go to the menu & force desktop mode & it changes to the web view. 

I just opened my budget & cleared a couple transactions with no problem. I haven't tried to use it for extended periods of time so I don't know if everything works, but I do recall that if I try to go to account settings it throws me to the mobile app.

Slate Blue Koala The web app isn't suited for mobile browsers, which is why it defaults to the mobile app. Some mobile browsers are able to run it despite that, but I can't say for certain what allows that workaround. Even when the mobile browser is able to open the web app, we've learned some features don't work as planned. We're going to continue to work on bringing features to the mobile app, so hopefully you won't need that 'hack' in the future. 

Hi Jiří Heger !

This currently isn't an option in YNAB, but you can submit a Feature Request to bring this to the attention of our development team. Transactions currently default to date and amount - factors all transactions need to be entered. Adding a time value to transactions would add an extra entry step for manual entry and an extra field for direct import. 

Faness That is true. But the transactions already have natural order.  

Herman Faness Hi, I'm glad its working for you. There are two main issues with the sorting of transactions implemented in YNAB. 1) If you *only* use the mobile app then you have to enter then reconcile all transactions manually which is painfully tedious as the transactions in YNAB will never be in the same order as the actual order in the account or the order you enter them. 2) If you use browser OR mobile version you don't have a running balance which doesn't worry me, but if you have a lot of transactions then it's close to deal breaker.

Herman @Faness  Here's another sorting issue that affects manual reconciliation. My online banking apps sort Pending and Cleared transactions separately. YNAB sorts them all together.

Slate Blue Koala Okay, but therein lies the main problem with any way YNAB is going to sort transaction: The order your bank posts transactions depends on when they clear, not necessarily the order you make them. That is based entirely on the merchant who is handling your transactions. For debit cards, the place you run your card at has to actually settle the transactions. That can take a while depending on the size of the company. 

For my cable bill, I use my debit card. That transaction will literally stay pending for a week every month. So while I marked the date in YNAB where I actually made the payment, my bank will post the transaction on the day it clears. This idea that your bank keeps your transactions in the exact order you did them is not true. So no matter how YNAB orders your transactions, they won't always match up.

I think YNAB really does need to prioritize adding reconciliation features to mobile, but any messing with the transaction sort order would be a complete waste of time.

Tobias Faness  "So no matter how YNAB orders your transactions, they won't *always* match up."

 I do understand that processing date and cleared date don't always match. We aren't talking about that. The discussion is about *intra date* order.  YNAB changes the order of both imported and manually entered transactions *within* a date.  This will *never* match up.  You *can* change the date to match either Processing or Effective date. But you cannot change the Intra Date order. This what the Request/Defect is about.     

Slate Blue Pilot (2903ac015cdb) When trying to match a bank transaction in YNAB, it is either present or is not regardless of order. When all matches are cleared (or entered & cleared if not matched) since the last successful reconciliation, the total will match... again regardless of order.

To answer your question, transactions within a given day are still ordered by amount.

Given your description, I suspect you erroneously cleared a transaction whose amount differs from the bank. I suggest you remove the cleared indication from all non-locked transactions and start again. Go systematically down the bank list. Again, you will either find a match within that subset of transactions or you won't.

If you repeatedly have similar issues, you might consider file based import or direct import to aid clearing. Neither will make such a mistake.

dakinemaui I do use the direct import and usually don't have any problems. But it would help me be a little more confident that I haven't missed something if i could see the transactions in YNAB in the same order the bank has them. If there is a way to reorder them in YNAB so they match, and the running balances match, it would be easy. I normally don't have any problems but it would help to troubleshoot. 

I did find .20 missing from my transactions somewhere and have been going through the transactions from YNAB and the transactions from the bank. It's hard figuring out how to get them to match up on a spreadsheet or other software outside of YNAB. 

Slate Blue Pilot (2903ac015cdb)  😂

Slate Blue Pilot (2903ac015cdb) There is no way to re-order (outside of fudging the dates, which I wouldn't recommend). You might try using the selected transactions total in lieu of the running balance (since you can skip over transactions):

1. Select all transactions in the register.

2. Deselect everything that is not locked. Hopefully that selected total now agrees with the running balance somewhere near the beginning of your statement.

3. Check off transactions in YNAB as you go along the bank's list. Each time the selected total should match the bank's running balance. If it ever doesn't, that's an issue.

dakinemaui I found my error. I was apparently missing two transactions from september of last year. Not sure how my math got all messed up. I was seeing I was missing .20 cents, but the two transactions were for 1.95. They were both an inflow and outflow though so they ended up canceling each other out. 

dakinemaui My balances are almost in agreement now.....i'll just check the ordering later. 

Slate Blue Pilot (2903ac015cdb) glad you're getting close... Good luck!

Superbone I was reconciling, and I must have had it covered by something else somewhere. Honestly I check YNAB at least once a day. Fixing one thing showed two other problems, which always seems to happen for me, but it's life.