Store Sales Tracker Excel Spreadsheet v1.06

Fixed an issue on the cover page where a calculation regarding profit was not being performed correctly. This changed the formula on the cover page for all cells column in E.

Please send me a message if you need assistance updating your spreadsheet.

This update fixes an issue where the date and currencies are not displayed in a consistent format. Feel free to shoot me a PM if you need help updating your copy of the spreadsheet.

This update adds a tracker on the main Cover Page to track how much money you have paid in fees. You should have minimal issues with adding this update, but if you have any issues feel free to send me a PM. (You should be able to just copy the list of products and the sales information to the new version).

Hey!

This update corrects an error where the month of January would not correctly be displayed on the graph. Since this is a new year, it should have minimal affect on users, but if you need help updating your spreadsheet with this fix please send me a message.

Hey!

This update fixes an error in the example excel file. You do not need to download this update unless you want to see the fixed example excel file. The main template was not altered and is exactly the same as before.

Hey!

As a part of my testing process, I over looked a summation error. This error led to the gross revenue being listed as your monthly net revenue. I've caught this and corrected this mistake as quickly as possible and apologize for any confusion this might have caused.

If you haven't yet entered data into the spreadsheet yet, you can just download the update version to receive the fix.

If you have already entered data, fear not! The fix is relatively easy. There are two possible fixes you can use:
1. (easiest) copy the formula in cell I1 from the updated spreadsheet and paste it into I1 on all month sheets on your old copy. This will adjust the formula to properly sum your net earnings.

• If you'd prefer not to download the update, you can simply copy the formula:
  =SUM(E2:E1001)
  into cell I1

2. (harder) copy your data on each sheet over to the new spreadsheet. This might make sense if you only have a few pieces of data entered, but will be more difficult if you have lots of information entered.

Once again, I apologize for this update. I know data transferal is hard for changes like this. If you need any assistance or have questions do not hesitate to reach out to me. I can walk you through the steps for this fix.