Exporting transactions in a particular account

Satish
Satish Member ✭✭
edited December 12 in Registers & Transactions (Windows)

How can I export transactions, to Excel, in a particular account between selected dates? I'd like to bring this data into Excel so I can calculate gains/losses in those transactions.

Tagged:

Best Answers

  • Satish
    Satish Member ✭✭
    Answer ✓
    image.png

    Where do I "include or exclude" specific accounts?

    I'm looking for transactions in one investment account in Quicken.

  • q_lurker
    q_lurker Quicken Windows Subscription SuperUser ✭✭✭✭✭
    Answer ✓

    Click the 'gear' icon right side just above the X for the window below, then the Accounts tab

    image.png

Answers

  • Quicken Anja
    Quicken Anja Moderator mod
    edited December 12

    Hello @Satish,

    To export transactions from an Account Register to an Excel file, please follow the instructions provided below.

    1. Open the Account you wish the export
    2. Click on the Gear icon on the top-right
    3. Select Export Excel Workbook (.xlsx)
      image.png

    Hope this helps!

    -Quicken Anja
    Make sure to sign up for the email digest to see a round up of your top posts.

  • Satish
    Satish Member ✭✭

    Thanks for your reply
    I have version R60.15 for Windows. "Export to Excel" is not available. Any ideas?

    image.png

  • Quicken Anja
    Quicken Anja Moderator mod

    @Satish Thank you for following up.

    Based on the menu options displayed in your screenshots, is this an Investment account you are trying to export? If so, unfortunately, this option is not available in the Investment account registers. However, you can Export to Excel from the Portfolio in the Investment tab.

    image.png

    Although, this will require some more customization with the filters and by clicking the Customize button next to the filter settings. There you will find an Account tab where you can select which specific account(s) to view before you export.

    -Quicken Anja
    Make sure to sign up for the email digest to see a round up of your top posts.

  • splasher
    splasher Quicken Windows Subscription SuperUser ✭✭✭✭✭

    Depending on the information you are looking to export, look at Reports→banking→Transaction. It can be restricted to an account and date range, it just depends if it has enough information.

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • q_lurker
    q_lurker Quicken Windows Subscription SuperUser ✭✭✭✭✭

    You can also call up an Investments Transactions Report and export that Excel, or copy it to the Clipboard and paste it into a spreadsheet. That report likely has more detail than the Banking Transaction report.

    What is going on that the capital gains computed by Quicken are inaccurate or insufficient? The Capital Gains report can also be exported or copied to a spreadsheet.

    image.png

  • Satish
    Satish Member ✭✭

    Thank you splasher and q_lurker

    How can I limit these exports to specific quicken accounts? I realize that I can do this filtering in Excel.

  • q_lurker
    q_lurker Quicken Windows Subscription SuperUser ✭✭✭✭✭

    You can customize reports to include or exclude specific accounts (or securities).

  • Satish
    Satish Member ✭✭
    Answer ✓
    image.png

    Where do I "include or exclude" specific accounts?

    I'm looking for transactions in one investment account in Quicken.

  • q_lurker
    q_lurker Quicken Windows Subscription SuperUser ✭✭✭✭✭
    Answer ✓

    Click the 'gear' icon right side just above the X for the window below, then the Accounts tab

    image.png

Categories