weird ROI / PROFIT issue

[2southpaws]

Can anyone offer any insight into why this occurred?

The ROI and Profit for one of my downloaded sales is waaaay off. I have tried troubleshooting it every which way but can't figure out what's causing the problem. I'm attaching a screenshot of the fields. You can see that the ones above and below it are fine.

Here are the numbers in the spreadsheet for this item:
     Purchase price - $6.46
     Postage - $7.25
     Final Value Fee - $2.28
     Paypal fee - 1.08
     Sale price - 15.72
     Shipping - $9.20
     Sales tax - 2.06

I've verified that the formulas in these two fields are the same as in the other fields in the rest of the two columns. Any thoughts would be greatly appreciated.

Larissa

[Scott]

2southpaws,
I cant tell from the screenshot but recommend unhiding all of the cells (especially in the expenses section) and seeing if there are any huge costs that got put in somehow...

To unhide the columns:
 1. Turn the Click Layout Assist button ON
 2. Click the double triangles at the top of a bookmark column, this will toggle the hidden columns
 3. Turn the Click Layout Assist button back OFF while not in use
Animated gif of this process --> https://mycostpro.com/images/sold-list.gif

If you cant figure it out without spending too much time, please send the file to support@mycostpro.com and I will investigate.

[2southpaws]

Yep, that did it. Somehow, shipping supplies were $43,000! Thanks for your help, Scott.

[Scott]

You should really try to get some cheaper supplies!