We use paypal on shopify integrated to an inventory/invoicing system called DEAR. Shopify sends DEAR each sale transaction, which dear treats like an invoice. When funds arrive in our paypal account, we clear the deposit against the DEAR invoice. The problem is that the paypal account gets a deposit net of paypal's fee, but the sale transaction sent to DEAR is for the full amount so recociling the two is a pain. The data is available but the process requires manual input.
Ideally, paypal would send DEAR the fee amount and DEAR could use it to create a credit on the invice that would hit an expense account - but this does not seem to be available. So I am looking at writing some code that would use both the paypal and DEAR APIs:
1. get a list of transactions from paypal, using the API, where the data would include a number of elements like gross and net amounts.
2. match those transactions to what is in DEAR, using the DEAR API and matching based on some combination of common data elements (date, amount, customer...)
3. use the DEAR API to create a credit on the invoice so that the paypal account deposit matched the DEAR invoice, thus enabling a straightforward process of using the paypal deposit to close the invoice.
Does anyone know if the information I am looking for is exposed via the paypal API, and if so, what is the endpoint?
Thanks for your consideration.
