Revenue and COGS Reports

Screen_Shot_2018-04-23_at_1.38.38_PM.png

We strongly recommend you account for revenue based on closed tickets only, because once a ticket is closed the date will no longer change, and you know the ticket has been paid and reconciled. We went so far as to make those the default filters for the reports, because we feel it is the most reliable approach for this business model.

Revenue

The revenue report allows you to look at sold ticket items over a period of time. 

Sales revenue, sales taxes, restock fees, discounts returns, and returns tax are all displayed below the total net revenue number.

Hover your mouse over each value to pull up a tool tip explaining how the number was calculated.

Cost of Goods

This report allows you to look at all non-labor items sold during a time period. Non-labor items include all items where the associated Item Type is not flagged as "Labor". Check out How to Setup a Catalog to learn about Item Type settings.

The "Total Cost" column is the amount you paid for the item.

The items in red are returns and the individual item SKU's can be accessed by clicking the blue text in the SKU column.

Cost of Services

This report includes all item types that are flagged as "Labor" at the Item Type level. Check out How to Setup a Catalog to learn about Item Type settings.

The "Addt'l Cost" column (essentially this is any additional "fixed cost") is set by the catalog item cost. The "Labor Cost" column includes labor hours (logged in the ticket item qty field) multiplied by the hourly pay rate of the employee chosen for "repair credit" or "repaired by". 

"Total Cost" column sums the "Addt'l Cost" and the "Labor Cost".
 
You may choose to toggle on/off the "Labor Cost" if you wish to do so.
This setting is turned on by default.
 
Cost of Refurbs
 
This report shows cost of ticket items (parts, labor, accessories, etc.) added to refurbishment tickets. Clicking the "ticket" link will take you directly to the refurb ticket for that catalog item. The purpose of this report is to help you catch any costs that are not reported in the Cost of Goods Sold or Cost of Services Sold Reports.
 
In RepairQ, there is a setting related to refurbs that tells the system to transfer the cost associated with parts and labor consumed in the refurb process into the refurbished item's cost. This means that after refurbishment, the cost saved for the refurb item could equal the purchase price (for the refurb item) plus the cost of parts, labor, or otherwise. Then, when the refurbished item is sold, it will accurately reflect your cost invested in the item in the Cost of Goods Sold Report. If you see a zero cost reported for an item, then it means that either 1) the item had no cost or 2) the cost was transferred to the refurbished item, and will show up in your Cost of Goods Sold Report when the refurbished item is sold (it will not show up as a separate line item; it would be part of the refurbished item's total cost).
 
You may adjust the system's behavior regarding cost transfers on refurb tickets in your Location Info settings. Look for a section that looks like this:
Screen_Shot_2018-04-23_at_1.40.48_PM.png
 
NOTE: Each Report can be downloaded by clicking the "To Excel" Button located near the bottom of the page.

The download will consist of the information you have set through the filters.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk