Transfer PayPal Funds

The Party has a PayPal Pro account which allows supporters to use either their own PayPal account or VISA or MasterCard credit cards to join the Party or make a donation. Periodically (every week or two) this money needs to be transferred from the PayPal account to the Parties chequing account. At some point we may be able to 'spend' the money in this account, i.e. transfer money to suppliers. At the moment, the Treasurer keeps $200 in the PayPal account for such an eventuality. Unfortunately PayPal wont even allow us to transfer the monthly $35.00 fee for PayPal Pro to PayPal!

Transfer Funds from PayPal

The actual transfer of funds is simple. PayPal provides a function to transfer some or all of the funds in the account to our TD Canada Trust chequing account. It arrives in the account 2-3 days after the transfer is processed by PayPal.

Reconciling the donations and other fees (e.g. Conventions and AGMs) received by PayPal and recorded in CiviCRM is a little more complicated. (Fees and membership dues from members living outside of Ontario are not treated as donations.)

Download PayPal files

This procedure requires the PayPal Transaction workbook from the previous Treasurer.  

1. Log on to PayPal
2. Click on <Activity> in the top menu.
3. Note the date of the prevous Transfer to Bank Account. Note if there were transactions on the same date but before the Transfer.  You will need to adjust for such transactions. 
4. Click on the [Download] link on the right side of the screen just above the column headers. 
5. There is a note under the "Create new report" heading indicating that the report will not include transactions occurring prior to a specified date and time. If that includes any donations, wait until they will be included before proceeding. The Transfer Transaction does not need to be downloaded;
6. Select a Date Range that starts with the date of the last Transfer to Bank Account and ends with the current date. 
7. Select the CSV Format and click on [Create Report]. A new line will be added to the top of the list of Activity Reports with the Action Column on the left indicating Submitted, In Process, or Download.

• Select the PDF format and repeat the above process;

1. When it shows Download, click on it.  The CSV and PDF files will be downloaded to your "Downloads" folder. Open this CSV file. 
2. Open the PayPal Transaction workbook.This spreadsheet will sum the Donations, Fees and Net columns, and transfer the sums to a table showing the accounting transactions.  
3. Delete the columns in the Downloaded file that are nor included in the PayPal Transactions sheet.  Determine the number of donations in the file that occured after the last Transfer.  
4. If there are donations in the downloaded file that occurred prior to the previous Transfer. they must be inserted above the line that shows this Transfer in the PayPal Transaction sheet, and, if more than one, insert another lline to show the subtotal of these transactions. 
5. Adjust the lines for donations in the Paypal Transactions sheet to accommodate the number of (remaining) donations in the downloaded file. (Insert or delete lines in the middle of the list to preserve the format of the sheet.) 
6. Copy the donations that occured after the previous Transfer from the downloaded file to the PayPal Transaction sheet.  The Total in the Net column should match the amount transfered. 

This spreadsheet should be compared to the CRM report and any discrepancies corrected. 

Print CRM Report

1. Click on <Donations - Donation Reports> to bring up the list of Contribution Reports.
2. Select the <Report PayPal Donation>. This will show a list of the PayPal amounts from the last report.
3. Click on <Search Parameters>, look for the Received Date and change the From to the date in the To Date and the To date to the current date.
4. Click on [Preview Report]. If all of the amounts reported for the first date were included on the previous PayPal report, click on <Search Parameters> and add 1 day to the From date, and click on [Preview report].
5. Click on [Update Report].
6. If the total donations is NOT the same as on the PayPal Transactions sheet, identify and correct the discrepancies and restart from step 1.
7. If the totals and details match, click on [Print report].

PayPal Pro

PayPal Pro is the feature that allows our supporters to make donations by credit card without without having (or using) a PayPal account. The fee for this service is $35.00 per month. (As of May 2018, HST of $4.55 was added to the charge.) Unfortunately PayPal will not take payment from the Party's PayPal Account. Instead, it is charged to a credit card, currently Jim McIntosh's card.

To access PayPal Pro (to change the credit card, print invoices, change password), after logging in to PayPal, on the home page click on the PayPal Manager link, or log in to manager.paypal.com.

• Partner = PayPalCA
• Merchant Login = OLPppmanager