cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Super Explorer ***

Why is my bank register sorting incorrectly?

To help me quickly find a transaction in my bank, I temporarily shifted from the usual sorting by DATE to sorting by PAYMENT. It appears to be getting the sort completely wrong. See the screenshot below where the red X's indicate out-of-order transactions.

 

badly-sorted-register.png

 

Now obviously the eye is drawn to the fact that all of the problem transactions have foreign currency sources. Of course this is just a portion of the whole account but I did a quick check across the entire account and I'm fairly sure that the mis-sorting occurs *only* among the transactions that have a foreign currency source. To be clear, the sort is wrong in USD terms; so it's still wrong. No matter how you look at it, $68,784.00 < $70,192.00. But I wonder if it's something as simple as the sort being done on USD values derived from the original foreign currency amounts converted according to a single (per currency) rate from today

 

Anyone seen this before?

 

2 Comments
Moderator

Re: Why is my bank register sorting incorrectly?

Hello there, ThomasK.

 

I'm here to get the help you need in running your Bank transactions in QuickBooks Online.

 

To get started, I'd recommend running a Bank report, then sort the amounts and verify if they are sorted the same. Once done, go bank to Bank register and check the Descending and Ascending sorting if the results are still the same.

 

To further isolate the issue, kindly open a private browsing window and run the same reports. This is to verify if this is caused by the system or your browser.

 

Here are the keyboard shortcuts that will help you accomplish this in all supported browsers:

  • Chrome: Ctrl+Shift+N
  • Internet Explorer: Ctrl+Shift+P
  • Firefox: Ctrl+Shift+
  • Safari: Command+Shift+N

To give you more of an idea about this process, here's a great resource that you can read:

I'd appreciate if you'd able to update me on how things goes. I'm always here to further assist.

Super Explorer ***

Re: Why is my bank register sorting incorrectly?

Hi Miriam, thanks for the input.

 

> To get started, I'd recommend running a Bank report, then sort the amounts

> and verify if they are sorted the same.

 

What exactly do you mean by a "Bank report"? In the Reports area, I did try running a Transaction Detail by Account report, filtering that so as to look only at the bank account in question. And that did give a list of transactions for that bank account. However, that report doesn't offer sorting by AMOUNT. I even tried adding CREDIT and DEBIT to the visible columns, to see if those would be offered as sort options (i.e. in the Sort drop-down menu at the top left of the report), but neither was. So what report did you mean when you recommended running a Bank report?

 

Now although I wasn't able to produce a report sortable by amount, I at least went ahead and tested the Register sorting in a private browsing window as you had suggested:

 

> To further isolate the issue, kindly open a private browsing window and run the same

> reports. This is to verify if this is caused by the system or your browser.

 

As I say, I did that but it did not solve the problem. When I brought up the bank account register and sorted it by PAYMENT (USD) (by clicking that column's header), it gave the same incorrect sort as I got in my main browser.

 

Also, for grins I tried looking at the register sorting in the QBO desktop app. It too shows the problem of incorrect sorting.

 

One other thing. I looked at an older bank account (now closed) to see if it showed the same problem and it did. But in that older account there were far fewer foreign currency transactions than there are in our current account. As a result it is much easier to see, in the older account, if the mis-sorting problem correlates only with the foreign currency transactions. And in fact it does. Again, I have not analyzed it in detail, but I am pretty sure that although not all foreign transactions produce the mis-sorting effect, many of them do; whereas native USD transactions are never mis-sorted. If I had to bet, I'd say that the cause of the problem is what I mentioned earlier. I suspect that for the purposes of displaying the transactions in the register, the USD values used for foreign currency sources are those corresponding with the myriad different FX rates actually used at the different times of the various transactions -- which is of course the right thing to do. But by contrast, it seems conceivable that for the purposes of sorting, the USD values used for foreign currency sources may actually be those corresponding with a single FX rate (well, one per currency) -- perhaps even the FX rates prevailing at the time the register is being viewed; i.e. the FX rates today. 

 

Shrug. It's a theory. :-) 

 

Anyway, if you still want me to run a Bank report, can you tell me what it is and how to run it.

 

Need to get in touch?

Contact us