The attached spreadsheet will provide you with a sales report for your ezimerchant account. The data inside the spreadsheet is live linked to your sales information on the ezimerchant servers via the Internet (and protected by your password and a secure connection)
Steps on how to use the spreadsheet
Step 1: You will need to enter your merchant number in 'add here'
Step 2: You will then need to enable this spreadsheet, to do so you will need to click on options on top of the spreadsheet, and tick the 'enable this content' and click ok.
Step 3: It will then ask for your ezimerchant credentials (this is what you login with ezimerchant)
Step 4: You have two tabs that you can view first tab:Product sales cube(this will tell you your revenue and all your sales) second tab: Product sales data(this is where you can view all your orders)
Step 5: To view your review all you need to do click on the Product sales cube, once you click on it a Pivot table field will show up, this is where you can edit and filter to your desired reports.
You can learn more about getting questions about your online business answered via pivot tables here: http://office.microsoft.com/en-us/excel-help/pivottable-reports-101-HA001034632.aspx