How do I reconcile my bulk payment with inidividual transactions

[Marksw76]

Hello forum!

I'm trying to generate some sort of report that identifies and breaks down each transaction relating to my recent payment so I can reconcile this in my accountancy software.

As a relatively new trader, Paypal only started 'releasing' held money 21 days after I started trading, meaning that I can't for the life of me work out which individual transactions it has 'released' that form part of my recent payout and which it hasn't.

There are loads of reports that states all sales, but they have absolutely no correlation to 'released' and 'held' transactions and the seemingly random payment it has made to my bank.

I have spent hours and hours trying to get my head around this.

I simply want a report that states two things:

a) the transactions were 'released' and belong to this bulk payout

b) the fees charged that are relevant to this payout

thats it! It seems so simple but I cant see it anywhere

Anyone have any ideas on this?

[jxwalter]

I feel your pain...this is a ridiculously complicated issue for not just held/released transactions, but for any and all payouts that can have multiple sources of additions and subtractions to that payout.  The numbers do add up, but only after painstakingly figuring out each and every total.  Here is an example of what I'm finding as I'm trying to automate this process (the type is a code that indicates what kind of transaction, but the source data is not so easily segregated

type: T0006  Express Payment (a sale, but not the only way sales show up - a T0000 General Payment can be a sale too)

type: T1107  Payment Refund (which can pull directly from the bank, or from the current balance in the account)

type: T0300  Bank Deposit (to directly pull from bank account to pay for a refund)

type: T0003  Pre approved payment for services

type: T0700  General Card Deposit (for an external payment for services)

type: T0000 General Payment (for PayPal Capital that gets pulled out of payout)

type: T0400  General Withdrawal (actual payout that has transaction fees removed, again, not attached to individual sales)

type: T0600  General Card Withdra//wl (using the instant transfer to bank feature, but now with additional cc fees deducted)

type; T0200  General Currency Conversion (for overseas payments, modifying the original currency to US Dollars, again, not clear which ones)

type: T0201  User Initiated currency Conversion (not sure the difference, esp cause it was tied to a USD transaction)

and so forth.  How each of these shows up in the transaction file is really difficult to isolate and total up to reconcile activity with payouts.    

and yes, referring to the payment Hold/Release (T2101 and T2102) mess, theres definitely no way to easily figure out when and where those get applied.

I figured out some coding to parse the file to find ways to link the transactions, and it gets it right through some really creative manipulations, but it still throws curve balls, such as when its combining a USD payment refund with a EUR sale, where currency conversions just dont add up.

All we need is a direct transaction ID link for what transactions are included in what payout.  You still need to code it for automation, but even manually, it would simplify how to reconcile, and for all the weird permutations that can occur in your PayPal transactions, it would take the guesswork out of reconciling.  As far as I know, this information is not available in the user interface transaction download, nor is it in an API download that ReportPundit, a third party service, offers.  

any idea on how to find that link ID (assuming it exists?)