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.
filamentvintagelighitng
Level 1

Enter Sales on Outside platform?? (Chairish in my case)

Confused on how to enter this.   I am NOT an accountant.  

 

I sell through my own website.    No problem entering an invoice when I sell something in person.   But I also list products on other websites.  (Chairish and Ruby Lane in my case.)   There are no integration apps for those sites.  I have the etsy  app, and it set up various accounts for me.   But for these other sides without apps  How do I enter the sale, and account for the fees and commission?

 

For example:

Item listed on site for $100.   Customer paid this price.

Chairish takes 20% commission of the sale.

I receive $80 in my PayPal account, but in the transactions imported, there are no expenses.  So, only my profit is recorded (does  it matter?), and does not show original full sales price, commission, and any possibly fees.

So only the amount I receive is put into quickbooks when transactions are imported.    How/should I enter the rest?

2 Comments 2
JoesemM
Moderator

Enter Sales on Outside platform?? (Chairish in my case)

Hello there, @filamentvintagelighitng.

 

You can manually enter the transaction, so you can easily account for the fees and commission. To get started, you'll have to create an invoice for the sales and process receive payment. Let me show you how.

 

  1. Select + New, then select Invoice.
  2. From the Customer ▼ dropdown, select a customer. 
  3. Enter the necessary details.
  4. Select Save and send.

 

Then, record the invoice payments that you've created so it will show the original sales price. For more information, see this article: Record invoice payments in QuickBooks Online.

 

 Once done, make a bank deposit and create a negative amount on the Add funds to this deposit column to balance what you receive in your Paypal account.

 

Here's how:

  1. On the left navigation pane, go to +New.
  2. Under Other select Bank deposit.
  3. Put a checkmark on the checkbox beside the Payment to be deposited.
  4. In the Add funds to this deposit, enter the negative amount.
  5. Click Save and close.

For detailed steps and how to manage your bank deposit, click this article: Record and make bank deposits in QuickBooks Online.

 

Also, you can check out these articles that can guide you in categorizing and reconciling your accounts effectively in your QBO software: 

 

 

Keep me posted if you have other concerns managing your sales transaction. I'll be around to assist you. Have a great rest of the day.

Fiat Lux - ASIA
Level 15

Enter Sales on Outside platform?? (Chairish in my case)

@filamentvintagelighitng 

Prepare your Sales Receipt data with the following template

RefNumberCustomerTxnDateShipDateShipMethodNameTrackingNumLocationClassBankAccountPaymentMethodPaymentRefNumberBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgCurrencyExchangeRateBillEmailToBePrintedToBeEmailedShipAmtShipItemTipAmtDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y HandheldsPortable Game Player1100  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y Software1 Year Warranty125  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y Extended Warranty1 Year Extended Warranty15  TAX
103Lisa Smith01/10/2020     CheckingCheck459119 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256  We appreciate your business!  [email address removed]NY         Gift Certificate$50 Gift Certificate150  NON
103Lisa Smith01/10/2020     CheckingCheck459119 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256  We appreciate your business!  [email address removed]NY         Magazine SubscriptionAnnual Magazine Subscription212  NON

 

then utilize an importer tool

https://transactionpro.grsm.io/qbo

 

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

Need to get in touch?

Contact us