David Stephen
10-31-2006, 09:27 AM
How to get your Cost of Goods (COG)
To determine your cost for items the item acquisition method must be purchased (if the items weren’t purchased there would be no cost associated with the item). Unfortunately, Liberty does not have one report that will get you the Cost of Goods. Comparing a Transaction Detail and an Items Description with Sales History report can get this information for you. This is a step by step guide. If you prefer a summarized description on how to get you COG please see this message board article. (http://www.resaleworld.com/forums/showthread.php?t=741)
1 - Go to the Reports Module
2 - Click on the report category “Payout”
3 - Click on the report name “Transaction Detail”
4 - You will see 4 “filters” on the right. Set the third filter “Transaction Code” to “Equals”.
5 - Click the box with the three dots, to the right of the filter you just set, and then double click on “Purchased Item” so it moves from the left side to the right.
6 - Click OK. You should now see “Purchased Item” in that filter field (to the right of equals).
7 - Set the fourth filter “Transaction Date” to “Between.”
8 - Click the first dropdown menu, to the right of the filter you just set, and select a date from the calendar. Repeat the same for the second date (field). This will set the date range you want to find your Cost of Goods for.
9 - In the reports option section (lower right) click the first three check boxes to suppress the detail info, group header and group footer. This report will now just show you a summary (the figure you are looking for).
10 - Either print or preview. Either way you will need the “Transactions Total.” This, Transaction Detail, report displays all transactions related to items purchased. In other words, all money you spent on purchased items that are available and sold.
Now we will need to get the cost of sold items then compare that with the cost of all items which will get us the cost of goods available. Thus, Cost of Goods (COG)
11 - Click on the report category “Sales”
12 - Click on the report name “Item Description with Sales History”
13 - Set the seventh filter “Item Disposition” to “Equals”
14 - Click the box with the three dots, to the right of the filter you just set, and then double click on “Sold” so it moves from the left side to the right.
15 - Click OK. You should now see “Sold” in that field.
16 - Set the ninth filter “Item Sold Date” to “Between.”
17 - Click the first dropdown menu and select a date from the calendar. Do the same for the second date.
18 - Set the 14th filter (you will have to scroll down to see it) “Purchase Method” to “Equals”
19 - Click the drop down box and select “PURCHASED OUTRIGHT”
20 - Either print or preview. Either way you will need the total (on last page). This, Item Description with Sales History report displays the purchased item you sold and how much you sold them for.
When we compare this total (total money amount for purchased items that have been sold) with the total from the Transaction Detail report (all money you spent on purchased items that are available and sold) we get your Cost of Goods of available items.
I hope this helps!
To determine your cost for items the item acquisition method must be purchased (if the items weren’t purchased there would be no cost associated with the item). Unfortunately, Liberty does not have one report that will get you the Cost of Goods. Comparing a Transaction Detail and an Items Description with Sales History report can get this information for you. This is a step by step guide. If you prefer a summarized description on how to get you COG please see this message board article. (http://www.resaleworld.com/forums/showthread.php?t=741)
1 - Go to the Reports Module
2 - Click on the report category “Payout”
3 - Click on the report name “Transaction Detail”
4 - You will see 4 “filters” on the right. Set the third filter “Transaction Code” to “Equals”.
5 - Click the box with the three dots, to the right of the filter you just set, and then double click on “Purchased Item” so it moves from the left side to the right.
6 - Click OK. You should now see “Purchased Item” in that filter field (to the right of equals).
7 - Set the fourth filter “Transaction Date” to “Between.”
8 - Click the first dropdown menu, to the right of the filter you just set, and select a date from the calendar. Repeat the same for the second date (field). This will set the date range you want to find your Cost of Goods for.
9 - In the reports option section (lower right) click the first three check boxes to suppress the detail info, group header and group footer. This report will now just show you a summary (the figure you are looking for).
10 - Either print or preview. Either way you will need the “Transactions Total.” This, Transaction Detail, report displays all transactions related to items purchased. In other words, all money you spent on purchased items that are available and sold.
Now we will need to get the cost of sold items then compare that with the cost of all items which will get us the cost of goods available. Thus, Cost of Goods (COG)
11 - Click on the report category “Sales”
12 - Click on the report name “Item Description with Sales History”
13 - Set the seventh filter “Item Disposition” to “Equals”
14 - Click the box with the three dots, to the right of the filter you just set, and then double click on “Sold” so it moves from the left side to the right.
15 - Click OK. You should now see “Sold” in that field.
16 - Set the ninth filter “Item Sold Date” to “Between.”
17 - Click the first dropdown menu and select a date from the calendar. Do the same for the second date.
18 - Set the 14th filter (you will have to scroll down to see it) “Purchase Method” to “Equals”
19 - Click the drop down box and select “PURCHASED OUTRIGHT”
20 - Either print or preview. Either way you will need the total (on last page). This, Item Description with Sales History report displays the purchased item you sold and how much you sold them for.
When we compare this total (total money amount for purchased items that have been sold) with the total from the Transaction Detail report (all money you spent on purchased items that are available and sold) we get your Cost of Goods of available items.
I hope this helps!