Hi @FlscClmx,
Thank you for your post and welcome to the community! I'm sorry that the downloaded .CSV file is a little confusing. It's the way to accomplish what you're looking to do.
If you set the date range on the Activity Download page and create a report for either All transactions or Completed transactions, it will probably take a little time to generate it but it will send you an email when it's completed. Then you can download the file, and you can click Sort at the top of the Excel screen to set up a multi-level sort to find what you want. I believe the best parameters to find what you are looking for would be with these steps:
- First add a sort function based on Status to get only the completed transactions at the top (or you can skip this one if your report was specifically only Completed transactions.)
- Then add a level to next search based on Gross, to get only the ones that are in the negative, so they're all money out of your balance.
- Sort using those two levels in that order, then removed all the rows that are not "Completed" and are not negative under Gross.
- Click Sort again and delete the levels listed there.
- Add a new level for Date and another level for Time, so the transactions are arranged chronologically.
- Sort using those two levels in that order.
- Then Save As and give it a different name so you don't overwrite the original report, allowing you to try a different set of options for other types of results with the original file.
I think these should do it for you, but you can play around with other sort options to see more arrangements. You can even add a line at the bottom with a SUM function to total everything up from all the rest of the rows if you want.
I hope this works out for what you need!
Olivia
If this post or any other was helpful, please enrich the Community by giving kudos to its author, accepting it as a solution, and/or coming back to assist others. Members make this Community great!
