Report transactions with categories

ybahatybahat Member Posts: 4

I have a very simple need.
I would like to be able to export the transactions screen.
More specifically, I need to be able to have a CSV with all the transactions, including the category.

Right now I can make a report for each account, but without the transaction descriptions, or I can have a report for all the transactions, but without the category.

This is much needed.
Thank you

Comments

  • JordanFromWaveJordanFromWave Administrator Posts: 149 admin

    @ybahat While the transactions page is not exportable (because it is not a report), you can export your information through a data export (found through the settings tab). Once you have completed this, within the file that is sent to your email, you will find a document called "Accounting". This will include the in depth detailed account of your transactions that you are looking for.

  • ybahatybahat Member Posts: 4

    Unfortunately, that's not exactly true.

    The closest thing I have is the "detailed general ledger" file.
    In it, for each "category", I can see all the transactions under the category.

    This means that in order to get the following table:
    Date, Description, Category, Credit, Debit

    I have to do it manually, copying the transactions for each category, and filling the category column manually.

    Also - it seems you have a bug, and the details for the Credit and Debit columns are switched

  • JamieDJamieD Administrator Posts: 628 admin

    Hey @ybahat. If you could please send us a screenshot of what you are experiencing in terms of the transaction details between the credit and debit columns showing incorrectly, that would be extremely helpful. I'm sure you have, but I just thought I would ask regardless - have you made sure that your transactions have been categorized correctly so that they are showing as 'withdrawal' or 'deposit' based on the nature of the transaction?

  • ybahatybahat Member Posts: 4

    In the regular system (meaning, the Transactions page or even the Reports) everything is fine.

    However, when I do an export (through the settings page, like you suggested), all the things coming out of my pocket are shown as Credit, and all the things coming in are in the Debit column.

    Maybe I'm misunderstanding the nature of the columns?

  • busymumsybusymumsy Member Posts: 2

    Just to add to this a similar query, I would like to print, for my tax records, a report or a list of all transactions, all income and all expenses, in one report, not a page for each transaction list. And I'd love to show the detail notes I input. Any possibility? I've tried exporting some options to Excel, but nothing yet matches my need, that I have found.

  • Ryan_WRyan_W Administrator Posts: 460 admin

    Hey @busymumsy!

    For now, the closest thing to that is what you've already discovered (with the data export tool), but I respect that including transaction notes is something that you'd really like to see. I'm happy to pass along that feedback!

    As for the columns @ybahat, what type of account did those transactions come from? This guide to debits and credits may explain why they're appearing as such, but let us know if it doesn't! https://support.waveapps.com/hc/en-us/articles/208622086-Everything-looks-backwards-A-debits-credits-overview

  • richard_murphyrichard_murphy Member Posts: 1

    I also need this report, it seems like a HUGE oversight that this is not a common report. The transactions view under Accounting is the view I need, why is it not available as a report or export?

  • madhurimadhuri Member Posts: 6

    yes , being able to export the transactions screen will be of great help. or otherwise the "accounting " data from setting>> data export could include the remarks or transaction notes . this will help us find all the information of a sale at one shot

  • ErikErik Administrator Posts: 187 admin

    @richard_murphy @madhuri thank you for joining in and offering your feedback! I will include your sentiments when bringing this up to the team as a suggestion.

    @madhuri the file you receive from the Settings>Data Export function should include your transaction notes. If you are not seeing those notes, feel free to send me a private message with the file you received so that I can further troubleshoot!

  • vamshikothavamshikotha Member Posts: 1

    I agree. Seems like a wasted effort to categorize each expense when you can't export the categories. Would be extremely useful to be able to export all the transactions (like in a statement) with the categories in a separate column. I can;t imagine this would be very difficult. Need of the hour!

  • ErikErik Administrator Posts: 187 admin

    HI @vamshikotha, categorizing helps organize your reports, which can be organized by category. In any case, I will also bring your voice into the conversation with the team!

  • PTackettPTackett Member Posts: 1

    This is a massive oversight, and such a huge one that I'm likely going to find another option such as Mint, which I used before. The entire reason I was using Wave, which I liked thus far, was so that I could categorize my expenses and easily have a report. Otherwise, as noted in previous comments, what's the point of spending the entire year categorizing? I hope this is addressed soon as we're all doing taxes.

  • nlevitinnlevitin Member Posts: 3

    @Erik said:
    @richard_murphy @madhuri thank you for joining in and offering your feedback! I will include your sentiments when bringing this up to the team as a suggestion.

    @madhuri the file you receive from the Settings>Data Export function should include your transaction notes** If you are not seeing those notes, feel free to send me a private message with the file you received so that I can further troubleshoot!

    I too cannot find notes in any export using Settings>DataExport.

  • Ryan_WRyan_W Administrator Posts: 460 admin

    Hey @nlevitin thanks for mentioning that! The reason you're not seeing this is because your Wave account is currently still the original version, and hasn't been migrated to the new version which includes the notes in your data export. We're down to the final 7% (give or take) of accounts on the classic version of Wave, and the goal is to have everyone moved over in the next 2-4 weeks. Thanks for hanging in there while this is finishing up!

  • nlevitinnlevitin Member Posts: 3

    Wonderful news! Many thanks!

Sign In or Register to comment.