Ways to subtotal transaction reports

acs2

I've encountered a circumstance where I need to look at the details of multiple SPLIT transactions within an account. I'd like to subtotal by Transaction each of which has the same payee (online transfer) and multiple splits. The sort would be by date. This would give a total for each transaction and list each item and the amount within that transaction

I can get close by selecting the one account in which I'm interested, the date range, sorting by date and subtotaling by week. This gets close but the report would be most useful if there were a Total by transaction option. A total by date option gets close if there is only one transaction on a given day

Any ideas?

The Keeper

Unfortunately, Quicken’s built-in reports don’t offer a “Subtotal by Transaction” feature, even though the data model supports it. However, there are a few effective workarounds depending on how detailed you need the information and how comfortable you are with exporting data.

Here’s a step-by-step guide with the best available methods:

Option 1: Use the “Transaction Report” and Show Splits

1. Go to Reports → Banking → Transaction (or Transactions by Category if you want category info).
2. Click Customize:
   • On the Accounts tab, select the specific account you want.
   • On the Date Range tab, set the desired period.
   • On the Payees tab, filter for the specific payee (e.g., “Online Transfer”).
3. In the Display tab, make sure Include splits is checked.
4. Sort the report by Date (click the Date column header or set it in the sort options).

Result:
You’ll see each split line separately, in date order, grouped visually under the transaction — but Quicken will not show a subtotal per transaction.

Workaround:
You can visually read each transaction’s subtotal in the register or note it, but Quicken won’t sum it automatically within the report.

📊 Option 2: Export to Excel and Group by Transaction

If you want the totals per transaction, Excel is the cleanest solution.

1. Run the Transaction Report as above (with splits included).
2. Click Export → Export to Excel Worksheet.
3. In Excel:
   • Use the Transaction Date and Memo (or Num, or a unique field that identifies the main transaction line) as the grouping keys.
   • Create a PivotTable:
     • Rows: Payee, Date, Transaction Memo (or Check #).
     • Values: Sum of Amount.
   • Expand each transaction to see its splits and the total at the top level. This gives you exactly what you described: “Total for each transaction, listing each split item and amount within that transaction.”

Option 3: Use the Account Register + Print

If you prefer staying in Quicken:

1. Open the Account Register.
2. Use the Filter bar at the top to select the payee (e.g., “Online Transfer”) and date range.
3. Click the Gear icon → Print transactions (or Export to Excel).
4. When you print or export, choose Include split details.

Again, this provides a readable list — but no built-in subtotal per transaction. Still, it’s often good enough if you just need to review rather than compute. If this is something you do often, you can save the customized Transaction Report as “Splits by Transaction (Manual Review)” so you don’t have to rebuild it each time.