Hi Support, is there any ways to map cost of one purchase bill to two sales invoices?
It seems that the Cost of Goods Sold is matched to the wrong Income in P&L details report.
I failed to search for a related post.
Kindly advise on how to take care of these transactions.
You'll want to check the item set up, Joanneyanne.
This is to ensure that you have selected the correct income account it will be posted to. Here's how:
That's it! You can run the P&L Details report again to see if it's now added to the correct account. Check ut this article to learn how to customize reports: Common custom reports in QuickBooks Online.
I'll be here if you have additional questions.
Thanks for your prompt reply.
I have followed the steps and found that the account is correct.
Please see below:-
Inv. 11451 with sales amount $38,560.00 is now tagged to cost $67,120.00 and the same goes to Inv. 11452. What should I do to map Inv. 11451's sales amount $38,560.00 to its cost of $33,560.00 instead of $67,120.00?
Thanks for coming back here, Joanneyanne.
When you set up an inventory item, there's a section for Purchasing information. This field is where you will enter the cost you pay for the item, as well as the expense account you want the cost to track to.
To check why invoice 11451 with sales amount $38,560.00 is not mapped on the correct COGS amount $33,560.00, I'd recommend reaching out to our Customer Care Team. They can do a screen sharing session and help you map the transactions.
If you have the new QuickBooks Assistant help update, you can follow these steps:
Please feel free to leave a comment on this thread if you have any additional questions or other concerns. I'll be around to answer them. Thanks.