I have a major nightmare on my hands. My wife has a PayPal account that she uses for both personal and business use (stab me right here multiple times, she uses accounts that I know about and several ones that I do not).
Problem #1: I have no idea what financial institution she used, except the 3 I have access to. Problem #2: Determining business vs personal expense. Problem #3: PayPal transaction descriptions are only a little less cryptic than the financial institutions I have access to. Problem #4: Never can remember whether the gross from PayPal is a credit or debit to account:PayPal in the CSV import. Or whether to use Balance affecting or all-transactions. I used to have a script that would sort most of this mess out, and put it in all proper upper/lower case/foreign language (I edited it multiple times and somewhere introduced a heap error that I cannot locate). I assume that an account PayPal:Imbalance would be the right course for where I do not know where the funds came from. Right now I have the institutions that I know of throw all transactions into PayPal:Bank. And PayPal import throw All payments to financial institutions there as well, otherwise to PayPal:Expense. That means copy and paste between accounts to get things right. A major pain in the a$$ since I have to copy and paste from two separate accounts. Problem #4 rears it's head here in the midst of #2. I have to manually match the PayPal payments/returns individually. Especially since PayPal may have the actual company name in it's native language and what was actually shipped (generally in English). Then Problem #2, personal or business. Which get thrown into PayPal:Expense until I figure out which expense account it really goes to. The CSV format generally provides enough information, but not always, to determine if is a business or personal expense. Including who from and what for. Confused yet, I am. There has to be a simpler way to import PayPal CSV to preserve my insanity from escalating to the next level, beserkergang! And because I can never seem to remember it, is the gross sale amount a debit or credit to the PayPal account from the CSV (still assigned as a credit card since that was all she originally had). Signed, Driving fence posts with my forehead. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
