Create REPORT numbers (Not graph)

psilversmith's Avatar

psilversmith

17 Jan, 2021 05:05 PM

For my accountant, I need a report of Expenses for Donations, Medical, Taxes paid, etc.
With "reports and graphs", I generate a very nice pie or line image with percentages of these catagories - but I need a REPORT. That is Numbers: for Each expense catagory I checked, totals for that catageory in the past year, and specific checks paid within that expense catagory. For example: "year 2020: Donations total : $xx,xxx.xx, Charity1 $x,xxx, Charity 2 $xxx Medical Expenses: Total $xx,xxx. Med expense 1 $x,xxx, Med expense2 ... You get the idea. Please let me know how to generate such a report.
Many thanks.
Peter

  1. 1 Posted by jeff_l on 17 Jan, 2021 05:50 PM

    jeff_l's Avatar

    You need to select Income & Expenses Detailed.

    Scroll down the list of available Graphs & Reports, past the ones showing a miniature graph icon, to the ones lower down that look like a clip board.

    I think that is what you require. You can select to Show just expenses, just income or both.

    Fellow user

  2. 2 Posted by mhoggie on 17 Jan, 2021 05:58 PM

    mhoggie's Avatar

    just a user,

    I ran into a similar issue myself and I found the only report where you can run where all transactions are subtotaled by category is the "Transaction Filter" report. But you can't filter out categories you don't want to see, unless you use and set the Tag for those transactions. But if you want the report to only include certain categories and have everything in the same report, you could use the "Find and Replace" extension to find the transactions in those categories and then add a tag. Then when you run the report you could filter by tag and only get those tagged categories subtotaled by category and the one tidy report for your CPA

  3. 3 Posted by psilversmith on 18 Jan, 2021 12:25 AM

    psilversmith's Avatar

    Many thanks!

  4. 4 Posted by psilversmith on 18 Jan, 2021 12:26 AM

    psilversmith's Avatar

    Many thanks!
    Peter

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac