Virtual Bookkeeper Forum

Connect with other bookkeepers and find related resources and information.

Forum Sponsor (Advertise with us)
Reply
 
Thread Tools Display Modes
    #1 (permalink)  
Old 09-22-2009
New Member
 
Join Date: Feb 2009
Posts: 11
Default Reconciling paypal statments in QB?
My client accepts payment through Paypal (also check, cash too). I am ALMOST done entering all her 2009 history so that we can get to a 'maintence' level of bookkeeping. I'm wondering what you do for paypal reconciling in QB. Do you set it up as a separate bank account, accept payments into that account, then transfer funds into your operating account? or do you just accept a payment into your operating account, and for payment type select EFT or OTHER and list it as a paypal transaction?
Reply With Quote
    #2 (permalink)  
Old 09-22-2009
Banned
Company name: Assistance By Faye
 
Join Date: Jun 2009
Location: PA
Posts: 99
Default Re: Reconciling paypal statments in QB?
What I did for the company I work for was enter a Sale Receipt using PayPal as the payment type. And then when funds were transferred into the bank account I made a seperate deposit for those paypal tranacations including entering a line on the deposit for the merchant fees taken. So the deposit matches what was deposited into the checking or savings account.
Reply With Quote
    #3 (permalink)  
Old 09-23-2009
debhowardgreenleaf's Avatar
Contributing Member
Company name: Greenleaf Accounting Services
 
Join Date: Apr 2009
Location: Northwestern PA
Posts: 76
Default Re: Reconciling paypal statments in QB?
The best way, by far, to handle PayPal transactions is to setup up a separate "Bank"-type account called PayPal. When you receive a payment from a client, you "deposit" that payment into the PayPal account. At the same time, you can record the PayPal fee in the PayPal register. If and when you transfer money from PayPal to your business checking account, you simply use the "Transfer Funds" screen (Banking > Transfer Funds).

The problem with using any other method becomes obvious when you have lots of transactions. What if you have six payments over two days that add up to $601.50. For the sake of simplicity, you want to transfer $600 over to your checking account. Only if PayPal is setup as a separate bank account can you leave that $1.50 sitting in PayPal. This method will also allow you to "reconcile" your PayPal account in QB against your PayPal account to make sure that you both agree on the balance.

HTH!
Deb
__________________
Deb Howard Greenleaf, Certified QB ProAdvisor
Virtual Bookkeeping & QB Consulting
Reply With Quote
    #4 (permalink)  
Old 09-24-2009
New Member
 
Join Date: Sep 2009
Posts: 24
Default Re: Reconciling paypal statments in QB?
I think it would depend on the amount of transactions through Paypal but I agree with DebHowardGreanleaf, my first thought would be to set it up as a separate bank account for the simplicity of reconciliation.
__________________
_________________
Tracey
Reply With Quote
    #5 (permalink)  
Old 09-24-2009
Banned
Company name: Assistance By Faye
 
Join Date: Jun 2009
Location: PA
Posts: 99
Default Re: Reconciling paypal statments in QB?
Deb's posting does make a lot of sense, the company I worked for was a very small company... maybe 10 transactions a quarter and always transferred the full amount to their checking accounting. Good Luck with whichever method you choose.
Reply With Quote
    #6 (permalink)  
Old 09-27-2009
Contributing Member
Company name: Blue Water Business Services
 
Join Date: Mar 2009
Location: Iowa
Posts: 151
Default Re: Reconciling paypal statments in QB?
I agree with Deb, using Paypal as a separate bank account in QB will simplify future transactions and work flow for you. It will also allow you to reconcile easily - no matter how many Paypal transactions the business does now or in the future.
__________________
Angie
Blue Water Business Services
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paypal Fees - do you pass fees on to clients? Donovanassist Policies and Procedures 24 02-28-2010 08:56 AM
possible paypal alternative? My Office Zilla Payment Processing 16 10-04-2009 04:20 PM
Paypal Chat marylocke General Website Design and Development 14 01-07-2009 06:38 PM
phishy from paypal? My Office Zilla Work At Home Scams 8 05-13-2008 01:53 PM


All times are GMT -4. The time now is 11:07 AM.

International Virtual Assistants Association
Project Management for Virtual Assistants
Work from Home | Become A Virtual Assistant
Virtual Assistant Directory
Affordable Logo Design
Virtual Assistant Contracts
Virtual Assistant Forums Advertising

© Virtual Assistant Forums 2012
All content and images are protected under copyright law and may not be reproduced in any way without express written consent.