Paypal calculation and tally entries

This query is : Resolved

Querist : Anonymous

Querist : Anonymous (Querist)

18 July 2016 Hi Expert,
I have one client how make software for foreign vendor, and he received money by paypal, USD, AUD, GBP,etc ( and paypal will transfer amt in bank after conversion), but don't know how to calculate paypal statement and entry in tally, kindly help me on the same it very great full. kindly send calculation on my email id. arvindm899@gmail.com
there are 1 day transaction as per paypal.
Date Name Type Currency Gross Fee Net Balance
30-04-2016 Mohammad Jahanp Web Accept Payment Received GBP 200 -7.6 192.4 192.4
30-04-2016 Mahmoud Ashrafabadi Web Accept Payment Received USD 300 -11.4 288.6 836.01
30-04-2016 Khameis Dhanhani Web Accept Payment Received USD 200 -7.7 192.3 547.41
30-04-2016 Megha Sharma Web Accept Payment Received AUD 200 -7.7 192.3 192.3
30-04-2016 Shabir Ahmed Web Accept Payment Received USD 150 -5.85 144.15 355.11
30-04-2016 yathish thota Web Accept Payment Received USD 100 -4 96 210.96
30-04-2016 Nouf Alotaibi Web Accept Payment Received USD 70 -2.89 67.11 114.96
30-04-2016 HANAN Web Accept Payment Received USD 50 -2.15 47.85 47.85
30-04-2016 From US Dollar Currency Conversion INR 51,283.87 0 51,283.87 51,283.87
30-04-2016 To Indian Rupee Currency Conversion USD -798.69 0 -798.69 0
30-04-2016 Bank Account Withdrawn to: hdfc (India) INR -51,283.87 0 -51,283.87 0
30-04-2016 From British Pound Currency Conversion INR 11,725.97 0 11,725.97 11,725.97
30-04-2016 To Indian Rupee Currency Conversion GBP -124.99 0 -124.99 0
30-04-2016 Bank Account Withdrawn to: hdfc (India) x INR -11,725.97 0 -11,725.97 0
30-04-2016 From Australian Dollar Currency Conversion INR 64,081.19 0 64,081.19 64,081.19
30-04-2016 To Indian Rupee Currency Conversion AUD -1,312.69 0 -1,312.69 0
30-04-2016 Bank Account Withdrawn to: hdfc (India) x-2102 INR -64,081.19 0 -64,081.19 0

Thanks

Amol S Joglekar

Amol S Joglekar (Expert)
Follow

18 July 2016 01. Relate these amounts with the BILLs raised by your client........
02. Debit bank.... credit the concerned client.
03. Paypal is a gateway....you need not worry much unless they are charging you some money for transfer