Step 1: Create a gross profit section with the following values to calculate the COGS and then deduct it from the net revenue: You can copy and paste the formulas for gross and net revenue (seen above) into the gross and net revenue columns for all other months. In this screenshot, I have used the function =B10-B8-B9 to subtract the sales returns and allowance from the gross revenue.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |