What's the best way to handle PayPal?

Robert Heller heller at deepsoft.com
Sat Dec 3 14:47:07 EST 2016


*I* treat PayPal like just another "account", pretty much the same as a
"Checking Account".

When someone pays me via PayPal it looks something like (as a split):

Date       Num   Descr         (Account) Tot Deposit  Tot Withdrawal   Balance
                 Joe's payment   
12/03/2016 ---                 PayPal             95
                               Service Charges     5
                               Bank Account       95
                               PayPal                            95
                 Payment       Receiviables                     100
                               
("Receiviables" is a special account used by the invoicing system to record 
receiviables -- eg money you send an "invoice" for.)

What is going on is:

You get paid 100 to "Receiviables".  95 lands in your PayPal account, 5 lands 
in "Service Charges" (an account I set up to "catch" various service charges 
(banking, PayPal, whatever)).  Then 95 gets transfered from PayPal to my bank 
account.  PayPal net: 0, bank account net +95.
                               
Note: you don't actually create this transaction directly. You send an invoice
(for 100). When the person (Joe) pays you, you *process* the payment
(Business=>Customer=>Process Payment). You record that the payment was 100 and
the transfer account is PayPal. *Then* you go to your PayPal account, select
the created transaction, select "Split", and then edit the transaction to
adjust things for the PayPal fee (Service Charge): change the PayPal amount
from 100 to 95, add the 5 to the Service Charge account (restoring balance),
and record the transfer to your bank account: add the 95 withdrawal from
PayPal and the 95 deposit to bank account, causing the PayPal to net 0, and 
the bank account to net +95.

At Sat, 3 Dec 2016 14:14:47 +0000 "Dr. David Kirkby (Kirkby Microwave Ltd)"  <drkirkby at kirkbymicrowave.co.uk> wrote:

> 
> If I sell something for £100 and someone pays £100 into the bank
> account, then its fairly easy to reconcile that, as one can import the
> bank transactions.
> 
> When PayPal get involved, I'm not sure how to handle this. In the
> simplest possible case
> 
> * Balance of PayPal is £0.00
> * Balance of bank is £2000.
> * Someone buys something for £100
> * PayPal take £5 commission
> * £95 is in my PayPal account
> * I transfer the £95 to the company bank account, bringing it up to
> £2000+£95=£2095
> 
> I can import the bank transactions, but are unsure how to handle the
> PayPal side of it. Should I set up a separate account for PayPal?
> Should the transaction be split? What the best way to handle this,
> which is least subject to human error.
> 
> Although I'm in the UK, very often I buy items from the USA, and so
> pay USD. PayPal does the conversion from USD to GBP.
> 
> Just to add one more complication, there's a good chance I will want
> to sell more on eBay in USD. I've sold the odd few things there before
> in USD. Despite charging more, some people would rather payin their
> own currency.
> 
> One further problem is that the Import of QIF files from PayPal seems
> to crash GnuCash
> 
> https://bugzilla.gnome.org/show_bug.cgi?id=775567
> 
> but the bug is not my biggest problem. My real problem is knowing how
> best to handle the use of another account (PayPal) in addition to a
> normal company bank account.
> 
> Dr. David Kirkby Ph.D CEng MIET
> Kirkby Microwave Ltd
> Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT, UK.
> Registered in England and Wales, company number 08914892.
> http://www.kirkbymicrowave.co.uk/
> Tel: 07910 441670 / +44 7910 441670 (0900 to 2100 GMT only please)
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.
> 
>                                                                                                            

-- 
Robert Heller             -- 978-544-6933
Deepwoods Software        -- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
heller at deepsoft.com       -- Webhosting Services
                                                                                                   


More information about the gnucash-user mailing list