How Do I Download Just Outgoing Payment History?

[WebsiteORM]

I need to download every outgoing payment so that I can report them as expenses on my taxes for last year. I downloaded a CSV of all balance effecting transactions for last year but it has multiple entries for some expenses.

For instance, a payment to a telephone company resulted in more than just one debit to my account being recorded in the CSV. If I were to program the spreadsheet to simply add up all debits my numbers would not be right due to multiple entries for the same transaction. Here are the names of the entries all of which are of the same negative value but show up like three transactions in the CSV even though they are all caused by just one payment:

Account Hold for Open Authorization

PreApproved Payment Bill User Payment

Reversal of General Account Hold

How do I limit the entries to just one per payment?

[sharpiemarker · Accepted solution]

@WebsiteORM 

I doubt it. The reports parameters aren’t very sophisticated. You download a report and edit to preference on spreadsheet.

Make a copy of the csv as back up, then open the copy in spreadsheet app. Do a sort by the column that contain those names/entries and delete the rows you don’t need according to those names. Repeat for any other entries you don’t need.

There are the default custom report fields (that can not be removed from the report) for the Activity Download and that’s about it in terms of report settings:

Date

Time

Time zone

Type

Status

Currency

Gross

Fee

Net

To email address

Transaction ID

Reference transaction ID

Name

From email address

Receipt ID

Or try the Custom option on the Statements page.