Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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...
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:
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:
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.
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
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
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here