A great way to see an overview of your sales activity is by running a “Daily Sales Summary” report. View gross sales, net sales, cost of goods sold, profit, and more.
Read this article to see how you can use this report to your advantage.
Accessing the Report
Select “Reports,” “Sales Reports,” and “Daily Sales Summary Report” from the toolbar.
Or, from the “Main Menu,” select “Reports.”
Click on “Sales Reports.”
Choose “Daily Sales Summary Report.”
Either way, you’ll end up at the following screen.
Report Fields
Enter a date range. Do so by manually typing in dates or selecting them from the calendar (accessed by the dropdown arrows next to the date fields).
Select which site you want to view data from. If you have more than one site, select “ALL Sites” if you want to view information from all sites, or select a specific one from the list.
View the report. As with most Artisan reports, you can choose “Save as Defaults” to save any fields, such as the site you select for “Sales Site.” The only fields that won’t save are date fields.
Reading the Report
The first column shows the date the sale occurred (ex. Fri, November 14th).
The # Slips column shows how many sales slips were created that day (ex. 10).
The # Units column shows how many products/items were sold that day.
The Gross Sales column displays the dollar amount of sales received that day (without any reductions).
The Discount column displays any discounts applied to the sale. This will affect the Net Sales column.
To calculate Net Sales, Gross Sales are subtracted from the Discounts column. (Ex. If you didn’t have any discounts applied to the sale, your Gross and Net Sales are the same).
The next three columns take into consideration any sales that were owned inventory, consignment, or rented out.
The COGS (cost of goods sold) column is the Gross Sales minus the profit. For example, we had a $640.00 in Gross Sales for November 4th, and $256.00 in Profit, leaving us with $384.00 for COGS.
The Margin Column is the Profit divided by the Net Sales, multiplied by 100. For example, our profit for November 9th is $1459.20. Our Net Sales is $3,738.00. That comes to .39, multiplied by 100, which gives us a 39% margin.
The Average Slip column is Net Sales divided by the number of slips. For November 9th, our Net Sales was $3738.00. We had four slip numbers that day, which gives us an average slip total of $934.50.
The Sales Tax column is the total amount of sales tax on all sales that day.