I got that part but it’s just a lot of work. If upload a quicken file from Paypal, it just imports the gross amount, transaction fees are not included, neither transfer and other administrative transactions. while I reconcile balance don’t match.
I have expend hours trying to figure this out.
Quicken neither Quickbooks files are imported correctly, I got the chance to see the raw text and found this:
LShopping Cart Payment Received
SShopping Cart Payment Received
This is just one item notice how many of the information is ignored, will be nice to get the Gross amount and fees on one then we can send the changes to the right accounts.
Transfers transaction, Refunds, Chargebacks and Holds are been ignored on the monthly download if you us the download option from Paypal.
If I use the coma delimited ( All transaction affecting balance) option I see all transactions on a spreadsheet, I can match all conciliate on the spreadsheet manually.
I used a program I purchase online called csv2qbo it converts my coma delimited file on qbo, same situation, once i import the file, I get incomplete information.
I have tested creating many business to be able to make this Paypal work, no success, all information needs to be almost entered manually, on my case is a problem after 1k transactions to enter fees and assign to an account.
Is there a better way to do this? reconcile Paypal is a pain.