Skip to main content
L
Lochkelly
October 10, 2024
Question

Sorting Transactions by Date after being Grouped by Account

  • October 10, 2024
  • 1 reply
  • 0 views

I have a transaction report broken down by a handful of accounts from our Chart of Accounts and grouped by account to see a total for each account.

 

However, we need the transactions sorted by date within each account.  If I choose to sort using the "Date" column heading it throws our accounts out of (numerical) order.

 

How can I sort transactions by date for each account?

 

Thanks,

Lisa

1 reply

A
AdonL
October 10, 2024

Hello there, @Lochkelly. I've got some details about sorting transactions on your reports in QuickBooks Online. 

 

I recognize you'd like to sort transactions within each account by date while keeping these accounts sorted in numerical order. However, QuickBooks Online (QBO) can only sort by one column at a time, either by date or by numerical order. Thus, sorting the transactions by date within each account while maintaining the numerical order of the accounts in the report is unavailable. 

 

Moreover, you can gain more control over organizing and presenting the transaction data for your report with the help of these resources: 

 

 

Furthermore, I'm leaving these articles if you want to save the current customization settings of the report to access in the future and export them: 

 

 

Feel free to get back to this thread if you have clarification on managing reports in QuickBooks. I'm always here to help you.

Q
quantjmf
November 26, 2024

Hello,

We purchased QBO Plus for our small company this past spring. Prior to that, we used Quickbooks Desktop (since 1994) and were very satisfied with that, but over the past year or so, there was pressure from Intuit for us to move away from QBD 2021 because it was no longer being supported. QBO Plus was recommended by Intuit to be closely aligned with QBD 2021, so we proceeded with the change. The Online Plus version is very disappointing. It seems very inflexible compared to what we were used to with QBD.

 

One obvious concern is that we cannot seem to sort transactions within each account sensibly by date for a General Ledger report, which I thought would be a simple report. When I use the standard General Ledger report by account, entries are not sorted by date correctly -- not even in the order in which they were entered. For example in our checking account, I see negative balances on the GL report, however the actual check register is showing the transactions in the order they were entered. Am I missing something? QBO Plus feels very cumbersome. At the very least, Intuit should not be pushing satisfied QBD users away from a good product to one that seems not ready for prime time.

C
Carneil_C
November 26, 2024

I appreciate you for chiming on this thread, @quantjmf. Allow me to join here and provide additional help to your queries regarding the general ledger report in QuickBooks Online (QBO).

 

When pulling up the report, the dates shown on the transactions will be based on the transaction date and not on when they were created. Thus, you'll want to export them to sort the transactions on the report by the date they were entered.

 

Also, the balance on your account register should match the general ledger report since it populates the balances shown on your account. A negative balance on a bank occurs when you withdraw more money than you have in your account.

 

That said, if you have balances on the report that don't match the account register, you'll want to ensure that you modified it with the correct dates and accounting method with the accurate filters. Here's how:

 

  1. Go to the Reports menu. 
  2. Search for the General Ledger report.
  3. On the header section, click the report period dropdown and choose a date.
  4. You can also modify some data depending on the information you need by clicking Customize in the upper left corner of the report.
  5. Choose the appropriate accounting method, whether it's cash or accrual.
  6. Click Run Report to save the changes.

 

To help you personalize them more, you can review this article: Customize your reports in QuickBooks Online.

 

On top of that, this great resource can help you save the current customization settings of your report for future use: Memorize Reports in QuickBooks Online.

 

If you still have any trouble modifying your reports or reviewing your bank account transactions, please let me know, and I'll do everything I can to help here in the Community. Take care always and best regards.

Terms & ConditionsAccessibility statement