Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Memorial Day Sale 90% OFF QuickBooks for 3 months.* Limited time only
Buy now & saveSolved! Go to Solution.
You would have to edit dates or go back in time and perform tasks in a different order. Keep in mind that your bank does exactly this each day - they deduct checks and withdrawals from the night before and then add deposits from the night before so what you are seeing in QB is similar to real world. Rarely would you share actual transaction order information with anyone outside your organization - you would give them a report such as P&L or Bal Sheet that is an instantaneous single point in time look at your business. Even if it is over time it is a single set of numbers. Unless the dates are wrong I see no reason to change anything.
That being said - it sounds to me as if you did not enter the deposit in your records before printing the checks - that you relied on the bank feed to bring it in. This underlies the basic problem with bank feeds, that dates and order of actions has nothing to do with what you actually did. And if this is what happened you would have to go back in time to manually enter the deposit in QB prior to recording the money going out
You would have to edit dates or go back in time and perform tasks in a different order. Keep in mind that your bank does exactly this each day - they deduct checks and withdrawals from the night before and then add deposits from the night before so what you are seeing in QB is similar to real world. Rarely would you share actual transaction order information with anyone outside your organization - you would give them a report such as P&L or Bal Sheet that is an instantaneous single point in time look at your business. Even if it is over time it is a single set of numbers. Unless the dates are wrong I see no reason to change anything.
That being said - it sounds to me as if you did not enter the deposit in your records before printing the checks - that you relied on the bank feed to bring it in. This underlies the basic problem with bank feeds, that dates and order of actions has nothing to do with what you actually did. And if this is what happened you would have to go back in time to manually enter the deposit in QB prior to recording the money going out
Hello. I have the same situation (items on a QBO report, all with the same date, are sorted not in the order that I want).
However - my transactions were entered in the order that I want. So my situation is not like the bank example that this thread started with. I had control and I did enter a specific transaction last, because I knew that I wanted it to sort last on a printed report. Yet QBO still prints the transactions with the same date in a random order rather than the order that they were recorded in.
Specific example: dated July 31 there are 3 transactions:
an Expense entry, was recorded first, several days prior. QBO sorts it to the last line ??
Journal Entry #15, recorded second, at least a day ago QBO sorts it to second last line, which is correct per the order it was entered in.
Journal Entry #16, was recorded last, just today. QBO sorts it to the first of these three entries - WHY?
I tried work arounds, such as editing JE #16 to be # z16 - in case the z would sort last. No luck.
Please reply if you can suggest a work around.
Even the fact that I edited the entry (to add the z) after all other entries were made should make it sort last, but it did not.
I realize that in most situations the exact sort order is not a problem, but sometimes it is! This is not the first time that I have been frustrated with a printed report. I usually resort to saving in Excel and editing it. But I am hoping that someone has found a "within QBO" solution.
Thank you
iek
Hi irmkorody-shaw-c,
QuickBooks Online reports offer customization options. However, you can simply reorder the items in the report by clicking on the column header. This enables you to reorder by date, transaction number, and so on, as you feel necessary. If you don't have this option, open the report in 'modern view'.
Let us know if you have other questions. We would be happy to help!
Thank you for explaining custom reports, but it does not help in the situation that I described in my original question.
I often use custom reports.
In this situation, I would need to set up several custom reports, for each and all of the reports that these transactions would appear on.
And then all users would need to be aware of my custom reports and use them.
And I would need to be aware of all the reports that someone may someday use - and set up customization for it. This is not a solution.
Transactions should by default appear, and print, in the order that they were recorded, like a timestamp.
I am hoping that there is a workaround where I can force entries into their timestamp order so that they remain in that order, on any report. That is what I was trying to workaround by putting a z in front of journal 16, hoping it would force it to sort to the end. Journal 16 was made after 14 and 15, but it prints on reports before 14 and 15. All have the same date. Simply by being journal number 14, 15, 16 - they should print in that order without requiring any customization!
Customizations are for many things, including if the timestamp was not important and another order was desired; and in situations where all users are aware of when to look for custom reports.
Thanks again
Irm
"Transactions should by default appear, and print, in the order that they were recorded, like a timestamp."
Agreed. Unfortunately, there's no way to do that in QBO AFAIK. This is a common complaint. QB Desktop has the same issue - for example, bill payments appear before bills when posted on the same day and it's terribly irritating. At least that's been fixed in QB Online.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here