Thanks, katherinejoyceO. I am not looking for this in a report though, and even so, sorting by date and then by number will not put them in the same order as they are on the statement, it would just be lucky if they turned out that way.
The real fix, if it were possible, would be if hours and minutes would be attached after the date "2021-07-12 14:44" would sort before "2021-07-12 14:48". Then I would just put an arbitrary hour & minute with each transaction so they would fall in the proper order. But this is not an option in QB. So after date, QB should for the transaction type, which would be check, transfer, journal entry, deposit, etc.
Within "date, type, number/ref" I want to see it fall in the order I prefer in the register. It's a given that all the transactions are on the same date. What is the order the transactions will appear when considering the type? For example, do deposits always come before checks on the same date? Is there a type that is between deposits and checks? There should be a hierarchy, like deposits, then checks, then transfers, then journal entries. Not sure of the order or the logic and would think this would be documented somehow. Can you help?
-OR-
If using sorting of "date & order entered", please provide instructions on how to change the "order entered" to change several entries on the same date so I can make each entry fall where I want in the proper order.
I hope I have made it clear what I am trying to achieve.
Hello there, @QuietEnjoyment.
I appreciate you for getting back to us with additional information about what you're trying to achieve. Allow me to step in and share some clarification about the QuickBooks Desktop's capability.
I know how beneficial being able to set your transactions in the same order as your statement. This feature will make the reconciliation process easier for you.
To clarify, yes, you're right about attaching hours and minutes after the date. As of now, the ability to add the information is unavailable.
When using the Date, Type, Number/Ref option, there's a default order for the transaction types. Currently, the system shows Deposits first, followed by Checks, Bill Payments, Paychecks, General Journal, then Transfer. As far as I know, there's no transaction between Deposits and Checks (see screenshot below).
You can also create a sample file in the program. This way, you'll be able to verify the order, as well as how the transactions will reflect in the register.
For the Date and Order Entered option, QuickBooks follows the created date of your existing transactions. Editing or making changes to the details will not change the order.
In the meantime, you can follow the workaround provided by @john-pero. Since you enter the data manually, I suggest adding them once the statement from your bank is available.
Though, it would be beneficial to have this feature in QuickBooks Desktop, too. Our engineers might be working to bring this over to the platform in the future. While we assess this, please send you feedback through these steps:
Here's how:
- Click the Help option in the upper-right corner.
- Hover your cursor to Send Feedback Online.
- Select Product Suggestion.
- Fill in the necessary information.
- Hit Send Feedback.
Additionally, I've attached an article you can use to learn more about which accounts QuickBooks sets up on your behalf: Learn about the chart of accounts in QuickBooks.
Glad to answer any other questions you might have related to the accounts in your company file. Just visit the Community space again, and I'll help you out.
