cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
catwingz1
Level 1

How to correctly record a fulfillment transaction where the payment is deposited to account via Stripe

Hi. Please note that I am using Quickbooks Pro 2012 for Windows and am not interested in upgrading at this time. 

 

First, I will clarify the transaction(s). A customer purchases a fulfillment item via Printify. This charge includes the actual cost of the item and its production, the shipping cost and the remaining profit.

The payment processing is handled by Stripe which also charges a fee. 

 

When accounting for a subscription service processed by Stripe I record the initial payment to Stripe as income and then write a check from Stripe to Stripe to subtract their fee. I then transfer the remaining funds from Stripe to the bank account.

 

In the case of the fulfilled product(s) this process still leaves me with the need to assign the costs of the goods and shipping to their appropriate accounts.

 

I am not seeing a way to split funds coming in as a transfer between accounts. Is there a way to do this which won't require the recreation of the fulfillment company numbers within my Quickbooks account? 

4 Comments 4
catwingz1
Level 1

How to correctly record a fulfillment transaction where the payment is deposited to account via Stripe

I had forgotten an additional layer of complication to this.

To speed up the fulfillment the cost of the goods, production and shipping are initially charged to the business credit card. Those costs are not broken down in the credit card statement so they wouldn't work well with reconciliation. It does offer another potential avenue for that part of the accounting though...

KimberlyS
QuickBooks Team

How to correctly record a fulfillment transaction where the payment is deposited to account via Stripe

We appreciate you providing the details of your concern, catwingz1. I'll ensure you can record your fulfillment transaction accordingly. Allow me to walk you through the process to keep you on the right path.

 

To begin with, let's create a fulfillment item in QuickBooks Desktop. After that, add it as another line item on your invoices or sales receipts.

 

Here's how to set up a new item:

 

  1. Head to the List menu, then Item List.
  2. Click on the Item dropdown and select New item.
  3. Choose the appropriate item type and supply the remaining details.
  4. You can use the custom fields feature to track specific information related to the item.
  5. Click OK.

 

Add Item_QBDT.jpg

 

Regarding the Stripe fee, make a processing fee account to track it in QuickBooks. You can then record this charge through the Write Checks feature.

 

On the other hand, splitting the funds during the transfer recording process is currently unavailable. This can be performed in the bank register after you move the remaining amounts from Stripe to your bank account within the program. Here’s how:

 

  1. In the Company menu, select Chart of Accounts.
  2. Locate and double-click the account used to record the transfer.
  3. Select the entry from the list and hit the Splits button.
  4. Provide the split details, then choose Record.

 

Split Transfer Funds_QBDT.jpg

 

Additionally, you'll want to add the cost of the goods, production, and shipping as a separate line item when entering credit card charges. This allows you to have them in a single transaction, as they're not broken down in your statements.

 

Moreover, you might want to explore this resource for guidance on reconciling your transactions for accurate reporting and tax calculation: Reconcile an account in QuickBooks Desktop.

 

Please reply on this thread or post directly on the Community page if you have additional concerns about splitting your funds transfer transactions in QuickBooks Desktop. We are always ready to offer further assistance.

catwingz1
Level 1

How to correctly record a fulfillment transaction where the payment is deposited to account via Stripe

Thank you @KimberlyS, I am discovering there are multiple ways to solve this, with the risk that I could duplicate pieces if it's not thought through first.

So far, the transfers from Stripe seem to be the most promising. When recording the deposit I can divide the funds between production costs, shipping and the remaining income.

While the credit card charge can be broken down, it also represents a debt to be repaid. I'm not so sure that it is a good idea to combine that with an expense, thus an argument in favor of doing that part via Stripe.

Another wrinkle entered the picture. I don't see this happening often but, in the case of refunds and voluntary additions, it is possible for the Printify account to have a balance on file. Part of one sale was partially paid for using this balance, with the remainder charged to the credit card. I am not at all sure how to account for this balance, but now I realize I need to because it is where a refunded amount was hiding. I am starting to consider options for this now and would welcome any suggestions.
Thanks again

catwingz1
Level 1

How to correctly record a fulfillment transaction where the payment is deposited to account via Stripe

Thank you @KimberlyS, I am discovering there are multiple ways to solve this, with the risk that I could duplicate pieces if it's not thought through first.

So far, the transfers from Stripe seem to be the most promising. When recording the deposit I can divide the funds between production costs, shipping and the remaining income.

While the credit card charge can be broken down, it also represents a debt to be repaid. I'm not so sure that it is a good idea to combine that with an expense, thus an argument in favor of doing that part via Stripe.

Another wrinkle entered the picture. I don't see this happening often but, in the case of refunds and voluntary additions, it is possible for the Printify account to have a balance on file. In fact, part of one sale was partially paid for using this balance, with the remainder charged to the credit card. I am not at all sure how to account for this balance, but now I realize I need to because it is where a refunded amount was hiding. I am starting to consider options for this now and would welcome any suggestions.
Thanks again

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us