Support for subtotalling by individual date

Alan5
Alan5 Quicken Windows Subscription Member ✭✭✭
edited September 9 in Reports

I have a need to produce reports where the subtotalling needs to be by individual date not a range of dates like weekly, monthly, etc. I am looking for the total of all transactions selected by the date of that transaction. The results would therefore not have any totals (or zero totals) for dates which had no transactions.

Currently, I have export transactions to a spreadsheet and run a pivot table to aggregate transactions by individual dates.

Tagged:
1
Up
1 votes

Reviewed · Last Updated

Comments

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭

    You should be able to use the report at Reports > Net Worth and Balances > Net Worth.

    Set the interval to Daily and on the Advanced customization tab, un-check the Include unrealized Gains box. The report has a maximum of 250 columns, so you must set the date range accordingly.

    Export to Excel and subtract adjacent columns in the totals at the bottom to see the net transactions for each date.

    Does this work for you?

    QWin Premier subscription

Categories