cancel
Showing results for 
Search instead for 
Did you mean: 
KenH999
Level 2

Paypal Transactions With Banking Transactions

New User handling wife's small business. Trying to get all this done so can get it to bookkeeper for first year's business taxes. I'm brand new to all this.

 

Need a little guidance on handling Paypal data to ensure I don't screw up previous work.

 

1. Did a "connect to Paypal" and got the data. Have not done anything, categorization/confirm, etc. on that data. 

2. I have done categorization/confirm on the business checking account's transactions. There were Paypal transactions there that I categorized and confirmed. While doing those I was logged into Paypal to check transactions' info so could accurately categorize them. 

 

Questions:

1. If I categorize/confirm the 42 transactions in the "Paypal Bank" will it interfere with, duplicate, etc. with the associated Paypal transaction in the checking account? 

2. It seems that doing a categorize/confirm on Paypal transactions in Paypal Bank AND in the Checking Acct. would be unnecessarily duplicated work?

 

What should I do?

 

Ken

 

 

9 Comments 9
MadelynC
Moderator

Paypal Transactions With Banking Transactions

I’m here to help you handle these transactions, Ken.


Since transactions are connected to a bank account, you'll want to add both transactions to your PayPal account. This way, you'll get more detailed information. Then, use the Record as transfer option to move the funds from your Checking account.


Here’s how:

  1. Open QuickBooks.
  2. Go to your Transactions or Banking menu, then Banking.
  3. Highlight your Checking account, then locate the entries.
  4. Select each to expand the view, then click Record as transfer.
  5. Choose your PayPal account in the Transferred to dropdown.
  6. You can add a memo if needed, then press Confirm after.
    Capture.PNG


Once done, you can now match or add the transactions to your books.

 

Here are some resources that provide insights on how to manage PayPal transactions in the program:


You can use this reconciliation guide to ensure your account are balanced and accurate: Learn the reconcile workflow in QuickBooks.


If you need further assistance about managing your bank transactions, just add them to your reply. I’ll be here. Take care always!

KenH999
Level 2

Paypal Transactions With Banking Transactions

In the checking account I searched for "Paypal" to show those transactions. See screenshot of one expanded transaction. I see no option to "Record as transfer". I checked several and they are all the same.

 

Is it because I had categorized and confirmed them?

 

How to proceed?

 

Thanks, Ken

 

 

KenH999
Level 2

Paypal Transactions With Banking Transactions

Bump. Please take a look at my last reply.

 

thanks. Ken

MadelynC
Moderator

Paypal Transactions With Banking Transactions

Thanks for reaching back out, Ken.


Yes, the Record as transfer option is only available if you haven’t added or matched the transactions yet. Since you already categorize them, you’ll want to select Undo to get the entries back in the For review section.

Capture.PNG


You can check the "What should I do with transactions connected to a bank account?" link in this reference to get more information: Use the Connect to PayPal app.


I’ve also added this guide to learn how transactions are handled and imported in QuickBooks: Differences between Connect to PayPal app, Sync with PayPal app, and PayPal Bank Feeds.


Don't hold back to drop a comment below if you have other questions about managing your bank transactions. I’m always here to help. Take care!

KenH999
Level 2

Paypal Transactions With Banking Transactions

I dearly need some plain language guidance to fully understand this process.

 

What I've done, on just one transaction so far. 

 

1.  Did UNDO on all of the Paypal transactions in my checking account as directed above.

2. Then did "record as transfer"

 

You said "Once done, you can now match or add the transactions to your books."

 

Please, simply, explain the steps to do that. Is that done in the checking account? Is that where I can categorize the expense?

 

I'm finding that many of your help pages and guidance here assumes some level of bookkeeping/accounting, or QB terminology, that I don't have.  A simple, brief, step by step would be sincerely appreciated.

 

Trying to learn,   Ken

 

MirriamM
Moderator

Paypal Transactions With Banking Transactions

Hi KenH999. Thanks for getting back and keeping us update.

 

Once you undo a transaction, it'll go back to the For Review tab on the Banking page. From there, you can add, match, and categorize the transactions. 

 

Here's how:

  1. On the Banking page, choose the tile for the account you want to review.
  2. Go to the For Review tab.

 

If you want to Match with an existing transaction:

  1. Look for a downloaded transaction with the Match option in the Action column.
  2. Note the DateDescriptionPayee, and amount spent or received.
  3. Choose the downloaded transaction to expand the view.
  4. Review the Matching records found in QuickBooks. This is the possible matching transaction you already entered in QuickBooks.
  5. Select the link next to each match to get more details.
  6. Make sure this is the correct match. 
  7. In particular, review the Deposit toPayment method, and Bank account fields on forms for the existing transaction in QuickBooks.
  8. If this is the correct match, close the open transaction.
  9. Click Match.

 

For more detailed steps, visit this article: Categorize and match online bank transactions in QuickBooks Online. It also tackles different ways in how you can manage downloaded transactions.

 

If you're ready to reconcile your bank account in the future, you can check this article for a guide: Reconcile an account in QuickBooks Online,

 

If you have more questions about handling accounts in QuickBooks, let me know and I'll get back to this thread and lay down a guide. Take care and have a great day.

KenH999
Level 2

Paypal Transactions With Banking Transactions

I appreciate ya'll's help but it just wasn't simple enough for me. Thankfully, I stumbled onto this from Steve Chase:   https://quickbooks.intuit.com/learn-support/articles/getting-the-most-out-of-quickbooks/paypal-and-...

 

For total newbies like me his post would be useful. It helped me understand and deal with Paypal expense transactions. I think I did them correctly. Guess when I get to reconciliation I'll find out.

 

Now, I have to deal with payments for services rendered (students paying for instruction) via Paypal.

 

Please describe how I handle, categorize [Sales?], etc.  each of these transactions. The simpler your advice the better.

 

1. In the Paypal account - Incoming payment

 

2. In the Paypal account - Withdrawal to bank checking account

 

3. In the checking account - the associated transfer from Paypal

 

Thanks,

 

Ken

Fiat Lux - ASIA
Level 15

Paypal Transactions With Banking Transactions


@KenH999 wrote:

Guess when I get to reconciliation I'll find out.

 

@KenH999 

As an additional option, explore this app to learn how it works reconciling PayPal transactions to QBO. You don't have to purchase it if you prefer to reconcile the transactions manually later.

https://synder.grsm.io/quickbooks

 

Another option, utilize the trial version of a backup restore app.

https://rewindio.grsm.io/quickbooks

 

KenH999
Level 2

Paypal Transactions With Banking Transactions

Bump

 

Please review the above post re: Sales of Service and Paypal. Some simple guidance on how to process them is appreciated. It appears that there are 3 items/transactions I'll have to handle, I listed them in the above post.

 

Thanks

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us