Recording product sale done through Paypal and cost of goods

You are on the right track on how these transactions should flow, DevgPhoto.

You can record these transactions in QuickBooks so you can match them in the in your Paypal bank feeds. Also, you have to set up your sales tax feature to track them. 

Here's how: 

Enter the income or sales ($21.96) as a Sales Receipt transaction and select the affecting income account. 

1. Go to the Plus icon and select Sales Receipt. 
2. Enter the customer's name the date of the transaction. 
3. Make sure to select the correct account in the Deposit to field. 
4. Input the PRODUCT/SERVICE and its Rate. 
   (Note: You'll have to manually calculate the item's rate to match the amount which is $21.96)
5. Once done, Save and close. 

Expense ($19.42 and $1.54)

1. Click the Plus icon again and choose Expense. 
2. Enter the necessary information. 
3. In the Category column, choose the expense account for the ($19.42) and on the second line, the expense account for ($1.54).
4. No sales tax should be tracked since this is an expense. 

After these transactions have been recorded, you'll have to match them to the downloaded Paypal transactions. 

I'm here to help you if you have additional questions. 

Thanks. I sort of understand what you are saying. But it's not 100% accurate reporting of the sales tax. Sadly the gallery service I use is a pain!

The customer ordered $33 of product

Shipping is $7.25

Total is $40.25. Sales tax is applied to this (which by law is correct)

Sales Tax paid is $2.67. This is what I have to report to the state.

So I'm still thinking this process but can you confirm or correct?

1) Generate an invoice (or sales receipt????) for $33. Include the $7.25 Shipping charge. And mark it as taxable. Quickbooks will record the total as the $42.92 and know I owe State Sales tax of $2.67

2) Download from Paypal feed $42.92 and record as "Income - Print sales"

3) Download from Paypal feed $1.54 expense and record as "Expense - merchant fees"

4) Download from Paypal feed the $19.42 payment made to gallery service as "Expense - ????"  (Materials and Supplies is ok???)

4) Download from Paypal/Checking account $21.96 as a transfer between accounts

At this point, I've recorded how much sales tax I owe via the invoice or sales receipt. And I've recorded the $42 income from sales, $1 merchant fees, and $19 expense. 

Now I just need to mark the invoice as paid/match to the "Income - Portrait Sales" I recorded?

Thanks for getting back to us, @DevgPhoto.

Allow me to chime in and share some additional insights about recording product sales.

Yes, you'll just need to mark the invoice as paid. This way, the sales tax for this invoice will be recorded in QuickBooks. Let me guide you the steps to get this done.

Here's how:

1. Click the Sales tab in the left navigation bar.
2. Choose Invoices.
3. Select the desired invoice from the list to open it.
4. Under the Balance Due amount, click the Receive payment button in the top right corner.
5. Enter the Payment method and any other necessary information.
6. Click Save and close.

This article offers additional info on recording customer payments: How to Record a Customer Payment.

You may also want to watch this YouTube video about receiving payments: https://youtu.be/wDb-KAgfeic

I wish you and your business continued success. Please let me know if you have any other questions about recording product sales.

OK so it sounds like I have the following correct:

1) How to record the sale amount through Paypal, how to record the fees paid, and how to report the transfer to my checking account.

2) How to generate an invoice that will be marked as paid. The purpose is only for sales tax recording.

The only question I have is what is the expense for what I had to pay the photo lab (prints and shipping) that they took out of my Paypal account. I don't think I can use "Cost of Goods sold".

Is it appropriate to use "Expense - Supplies and Materials" or should I create a new expense account such as "Expense - product purchase"

Hello there, DevgPhoto.

I appreciate you coming back to us for additional support. I'm here to help you correct your recordings in QuickBooks Online.

You can either enter the transaction as an invoice or sales receipt. It only depends on how you receive the payment. Enter it as an invoice if your customer agrees to pay you at a later date. On the other hand, you'll use a sales receipt when your customer pays on the spot for goods or services.

For more insights, check out this article: Should I use an Invoice or a Sales Receipt?.

When entering the transaction, make sure to select the Undeposited Funds account on the Deposit to field.

1. Click the Plus icon.
2. Choose Invoice or Sales Receipt.
3. Enter the customer name.
4. On the Deposit to field, enter Undeposited Funds.
5. Enter the necessary information.
6. Click Save.

If it's an invoice transaction, you have to enter and link its payment to mark it as paid. For the instruction, follow this link: Record a payment for an invoice.

Next, create a deposit transaction. You can add lines for the expense and merchant fee.

1. Click the Plus icon.
2. Choose Bank Deposit.
3. Select the transaction.
4. Enter the bank fee and expense as a line item in the "Adds fund to this deposit" section, select your new Bank Fee expense account and enter a negative value that reflects the bank fee amount. 
5. Click Save and new or Save and next.

That should already match your Paypal and QuickBooks transactions, DevgPhoto.

Let me know there's anything else you need. I'm still here to help you more. Have a good one.

I'm a bit confused. Here is what I am thinking:

1) I can create a sales invoice or a receipt.  (I never tried a receipt before)

2) The Paypal bank feed will be downloading the TOTAL sale, the payment I made for the prints and shipping, and the Paypal fee. The checking account bank feed will be downloading the deposit to the checking account from Paypal, which is just recorded as a transfer.

a) The invoice or sales reciept will be for the total amount, and this will record sales tax I owe

b) I think I know how to record the rest except for what I had to pay for the prints and shipping. I don't think I can use "cost of goods sold". Is it OK to make a new expense such as "Good Purchased" or "Prints Purchased".......OR should I use the "Supplies and Materials" expense?

Glad to have you back and thank you for the details you've shared, @DevgPhoto!

Allow me to chime in for a moment and share additional inputs about recording your sales.

To start, prints and shipping fee doesn't necessarily be recorded in any specific accounts. Because it must be included in the total cost of your purchased items.

In addition, it doesn't affect your Cost of Goods Sold either. Thus, there isn't a need to create a new expense account.

Lastly, here's an article you can read to learn more about your Cost of Goods Sold: What is FIFO and How is it Used for Inventory Cost Accounting?

Feel free to leave a comment below if you have any other questions about recording your sales and expense transactions. I'll be always around to lend you a helping hand.

---

@JonpriL wrote:

Glad to have you back and thank you for the details you've shared, @DevgPhoto!

 

Allow me to chime in for a moment and share additional inputs about recording your sales.

 

To start, prints and shipping fee doesn't necessarily be recorded in any specific accounts. Because it must be included in the total cost of your purchased items.

 

In addition, it doesn't affect your Cost of Goods Sold either. Thus, there isn't a need to create a new expense account.

 

Lastly, here's an article you can read to learn more about your Cost of Goods Sold: What is FIFO and How is it Used for Inventory Cost Accounting?

Feel free to leave a comment below if you have any other questions about recording your sales and expense transactions. I'll be always around to lend you a helping hand.

---

OK so I received $42 into my Paypal (total sale from the gallery), then Paypal immediately sent back $19  (cost to order the prints+shipping). 

The bank feed download will capture both.

I need to categorize the $19 paid as something. It's an expense.

I know it's not COGS. But I'm not sure what expense account it would be.