BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
VTXtools
Level 2

CC batch deposit apply credit to customer account

I currently use stripe to capture my credit card sales. Stripe will batch the payments and deposit the day(s) payments into our bank account. We short ship a lot of our product so what happens is we will receive payment for four transactions but only three of the orders may be fulfilled and have pushed over to QBO. Currently I take the payment for product that hasn't shipped yet and place it in prepaid unearned income (liability). The issue I have with this is I then have to undo the transaction to when the order is fulfilled and then go through and split the payment and account for the stripe processing fee. 

 

The other option is I can go in to the prepaid unearned income liability account and then edit it and apply the payment to sale of product income account. But I don't believe this accounting for the stripe transaction fee.

 

The perfect solution would be that when I first split the stripe bank deposit and have applied the stripe transaction fee that I just apply the payment as a credit to the customer. This would allow me to see that the customer is still owed product and when the order synchs over to QBO then the transaction is just applied and since the transaction comes in as paid by credit card the account would automatically balance it self out. What would be the procedure to do this?

 

Or would I just apply it as sale of product income and then when the transaction does push over it just shows as invoice shows as paid and the payment as closed but the payment is already applied. This obviously is not following gap as I am not categorizing the payment as a liability until the invoice and payment are pushed over.

2 Comments 2
VTXtools
Level 2

CC batch deposit apply credit to customer account

After giving it some thought I could just book the income as "sale of product income" for that customer though not tied to specific invoice. When the order ships it would come over as "CC payment applied" and the "invoice as paid". This should still deplete inventory and the sales numbers are still rolled up. Does this sound correct?

 

banking>select transaction>find match>select the invoices>resolve difference>select customer>sale of product income.

 

Only issue is this doesn't provide a credit to the customer account so it is breaking GAP as it doesn't create a liability for the credit.

GlinetteC
Moderator

CC batch deposit apply credit to customer account

I appreciate the detailed information you've provided, VTXtools.

 

Yes, you're on the right track. Your options and solutions are good. And if you want the credit to post to the customer's account, and to post it to the liability account, you may create a Journal Entry. But, before proceeding, I highly suggest reaching out to your accountant. This way, they can provide other options and guide you through to ensure your books are accurate. 

 

Here are the steps on how to create a Journal Entry:

 

  1. Go to +New and select Journal Entry.
  2. Fill out the fields to create your journal entry.
  3. Select Save and new or Save and close.

 

I've also added this article if you need help with reconciling your account: Reconcile an account in QuickBooks Online.

 

You can get back and post additional concerns again here. The Community is always here to help.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us