pypall contributions

[bjsbrown65]

Resurrecting an earlier post that I put on hold until I had more pay pal contributions. Set up pay pal following JohnDMeyers example dated 3/7/14. After noting the money had been deposited into the bank account, I entered the contributions giving the members full credit for $300 on a day different from normal contributions/deposits. In fund accounting made transaction for the fees and then transferred the remaining money of $290.10 from paypal checking to regular checking. This was later confirmed by the bank statement and the reconciliation screen. Before reconciliation, posted AP, Payroll, Fund Accounting, which included posted contributions. The pay pal contributions minus the fee showed separately on the posted report and the reconciliation screen; however, the $300 also showed as a separate deposit for the date entered on the posted report and on the reconciliation screen. I know this shouldn't happen but am clueless as to what I need to do. All help appreciated.

[JohnDMeyers]

In the reconciliation window, I take it you are seeing two deposits of $300 each (or possibly three entries, $300 plus $290.10 plus $9.90)?

If so, do all the entries show the Reference "CONTRIB."? (meaning that it came from the Contributions module).

My first guess is that someone made a second deposit entry in Fund Accounting. (in which case the Reference will be something other than "CONTRIB.")

[bjsbrown65]

Yes. In the reconciliation, there are several deposits for contributions for the various dates which are accurate. There is a pay pal deposit on the date and the correct amount of $290.10 which is what was transferred from pay pal bank to regular bank account and is on the bank statement. There is another entry contrib for 300 on the date entered so they are there twice. How can they not be since they were entered in the contributions module and also transferred from pay pal bank to regular checking. Maybe something is not set up correctly. When I set this up, I created a pay pal checking account and a pay pal expense fee account. Under maintain list of contribution funds, I have Pay pal Contribution debiting the pay pal bank account and crediting pay pal unrestricted contribution with contribution fund type general. I wait until the money hits the bank account from pay pal and then I give credit by entering the contribution amounts in the contribution module selecting pay pal as the type of contribution. In fund accounting I credit the pay pal bank account and debit the pay pal fee account for the fee. Then I transfer the money from pay pal checking to checking by crediting the pay pal checking account to the primary checking account. The only entry made in fund accounting is when I transfer the money from pay pal checking to primary checking.

[JohnDMeyers]

Does your Pay Pal account and the checking account have the same 4-digit account number?

[bjsbrown65]

no, the checking account is 1110 and the pay pal account is 1140

[JohnDMeyers]

It is apparently the two Contributions entries that are incorrect.

You only need the one that Debits Pay Pal (1140) in Contributions for $300

The second one that transacts 1110 should be done in Fund Accounting for $290.10 since that is the only amount that actually makes it into checking.

[bjsbrown65]

I agree with you as this is what I believe I am doing. I'll go back thru everything again. Maybe I'll resolve. If not, I'll be back. Thanks for the input.

[bjsbrown65]

John - I noticed when I posted contributions to account funding, it listed all the types including online. Am I supposed to uncheck check this as I have already deposited the online payments into the bank account. I believe this is what creates the double deposit.

[JohnDMeyers]

I am not familiar with the online payment feature. If you are using it, then the manual Contribution entry would seem to be redundant.

[NeilZ]

I think I mentioned this in the other topic. I seem to recall that you had created manual transactions in Funds Accounting to account for the deposit that was created when you had PayPal send the money to your bank.

SO:

1. When you enter the Contributions make sure the PayPal contributions are listed as Online.
2. When you post, post everything but the Online contributions to Funds Accounting
3. Then post the Online Transactions to Contributions Only

This way would not create transactions in Funds Accounting for the PayPal contributions, but would reflect in the individual donor's statement.

[bjsbrown65]

Thank you Neil. This is what I did but appreciate your giving me assurance it was the right thing to do.