ARM Help

Detailed Sales Report for Battery

The Detailed Sales Report for Battery (its heading reads Battery Detailed Sales Report) lists every battery sold on a finalized invoice in the date range, one line for the part and one line for the labor of each battery service, with what the battery cost you, whether it came from your inventory or was bought outside for the job, and what the customer paid for the part and the labor. ARM knows which services are battery services because each master service package carries a Static ARM Service Type in System Setup Tools → Add/Edit Master Service Package; every package set to Battery is included here. Use it to see how many batteries you sold, what margin you made on them, and how often you had to buy a battery from an outside supplier instead of stock.

4 how-to answers 1 screenshot Open in ARM Markdown

How do I run the Detailed Sales Report for Battery? #

  1. From the Home Screen, click Reports → Sales & Financial Reports → Detailed Sales Report for Battery.
  2. Click the From : … To : … date box and pick the first and last day. The report opens on the first day of the current month through today, and it selects invoices by their finalized date. The × beside the box clears the dates.
  3. Click Search to load the report, or Show All to reload it for the same dates.
  4. Read the summary above the table: Total Records is the number of lines listed, Total Part Amount and Total Labor Amount are the battery part sales and battery labor sales for the range, Total Parts Qty is the number of batteries sold, and OPP Count, in red, is how many of those batteries were outside part purchases rather than stock.
  5. Click Print to open a PDF copy of the report in a new tab.

How do I open an invoice from the Detailed Sales Report for Battery? #

  1. From the Home Screen, click Reports → Sales & Financial Reports → Detailed Sales Report for Battery, and run it for your date range.
  2. Click the blue Invoice # at the start of the line. The invoice opens so you can see the whole ticket the battery was sold on.
  3. Use the browser back button to return to the report.

How do I see which batteries were bought outside instead of from stock? #

  1. From the Home Screen, click Reports → Sales & Financial Reports → Detailed Sales Report for Battery, and run it for your date range.
  2. Check OPP Count in the red summary line for the number of outside purchases.
  3. Find the lines marked in the OPP column: OPP cost, OPP Supplier, OPP Purchase Date and OPP Part # tell you what was paid, to whom, when and for which part, and Part sales $ on the same line shows what the customer was charged for it.

How do I check the margin made on batteries for a period? #

  1. From the Home Screen, click Reports → Sales & Financial Reports → Detailed Sales Report for Battery.
  2. Set the From : … To : … box to the period and click Search.
  3. In the Total row, take Part sales $ and subtract Inv. Cost $ and OPP cost; the result is the profit on the batteries themselves. Labor sales $ in the same row is the labor earned installing them.
  4. Click Print to keep a PDF copy.
Detailed Sales Report for Battery with filters, results and Total row
Detailed Sales Report for Battery with filters, results and Total row
About this screen

Each line shows the Invoice # (a link that opens the invoice), the Date the invoice was finalized, the Package Name of the battery service, the Parts Qty sold on that line, and the Type, which is Part for the battery itself and Labor for the installation labor of the same service, so a battery replacement normally produces two lines with the same invoice number. Inv. Part # is the part number of the battery taken from your inventory. Inv. Cost $ is what that battery cost you: the purchase cost recorded on the part in inventory multiplied by the quantity sold; when part of the quantity was bought outside for the job, the outside purchase cost is used for that portion and the inventory cost for the rest. OPP marks a line whose battery was an outside part purchase, and for those lines the cost moves from Inv. Cost $ to OPP cost, with the OPP Supplier, OPP Purchase Date and OPP Part # taken from the expense entry recorded when the battery was bought; stock lines show a dash in all five OPP columns. Part sales $ is the amount charged to the customer for the battery and Labor sales $ is the labor charged for the service after any labor discount; a Part line carries the part sale and a Labor line carries the labor sale, the other being $0.00. The Total row at the foot sums Parts Qty, Inv. Cost $, OPP cost, Part sales $ and Labor sales $ for every line in the range. Your margin on batteries for the period is Part sales $ less Inv. Cost $ less OPP cost from that row, and Labor sales $ is the labor earned on top.

The Detailed Sales Report for Tire in the same section has the same layout for tire services. The Add To Favorites switch beside the heading saves the report under Favorites on the Reports page. Which reports you see depends on your admin group permissions.

Ask AI