PayPal bookkeeping - net transactions doesn't equal balance..

Discussion in 'Accounts & Finance' started by TomUK, Aug 20, 2011.

  1. TomUK

    TomUK UKBF Regular Free Member

    Posts: 312 Likes: 18
    Guys, am I missing something...

    I downloaded the log of PayPal for the last 6 months.

    The balance from log matches balance in PayPal. For example say 10k

    Now when I add the net amount colunm up, I get 30k?

    How is this? Ive spent the last 4 hours and cant figure out whats going on.. the total net or gross colunm dont even come close to the balance..

    I looked deeper and there are some transactions that don't effect the balance, but these only come to 10k...


    Craziness is stressing me out, any ideas?
    Posted: Aug 20, 2011 By: TomUK Member since: Feb 24, 2008
    #1
  2. lynxus

    lynxus UKBF Contributor Full Member

    Posts: 1,147 Likes: 283
    I don't suppose you can post an example? screen shot or something?

    I assume your accounting for Paypal charges. SO im not sure what could affect the balance so much..
    Posted: Aug 20, 2011 By: lynxus Member since: Jul 5, 2011
    #2
  3. TomUK

    TomUK UKBF Regular Free Member

    Posts: 312 Likes: 18
    Accounting for PayPal charges --- no idea what you mean by this...

    In paypal when you download history log it shows you every transaction from PayPal...

    IT has many colunms but the 4 im talking about are:


    Grosss --- Fee --- Net --- Balance

    Now the remainign balance in PayPal is 10k, but when I add together the whole 'net colunm', its 30k, should the net colunm equal the balance colunm...

    So I thought perhaps maybe some transactions didnt effect balance, so I found these, which only equal 10k... still doesnt match

    extremely confused
    Posted: Aug 20, 2011 By: TomUK Member since: Feb 24, 2008
    #3
  4. lynxus

    lynxus UKBF Contributor Full Member

    Posts: 1,147 Likes: 283
    When I mean charges i meant "fee" so yeah evidently your accounting for it.

    Where are you seeing this?
    History > Reports > Monthly Sales Report > Month....

    if so then Im not sure if we can help :(

    id suggest talking to paypal if your balances are not matching up.
    ( Our's look ok and match our in and out.. )

    So either something is very wrong or your accounting has gone amiss..

    Again,
    Id suggest phoning them they are normally pretty good on the phone.
    Posted: Aug 20, 2011 By: lynxus Member since: Jul 5, 2011
    #4
  5. Tom McClelland

    Tom McClelland UKBF Regular Full Member

    Posts: 2,889 Likes: 789
    Check the right-hand column that has Debit/Credit/Memo in it. You don't want any "Memo" transactions included in your total.

    You need to watch things like chargebacks, currency conversions, reversals, echeques and so on. All of those can make simple adding up of the transactions pointless, because of the way that Paypal records them.
    Posted: Aug 20, 2011 By: Tom McClelland Member since: Feb 10, 2008
    #5