SUMMARY OF SERVICES (Mangement Report) has one pair of lines per package sold in the week: … (QTY) counts the finalized invoices that included the package on each day, and ($) below it is the parts and labor charged for that package on those invoices. The day columns are headed with the date and weekday, and the totals columns are WEEK TOTAL for the Sunday to Saturday shown, LAST 30 DAYS DATA, MTD TOTAL for the month to the end of the week, LAST 365 DAYS and YTD TOTAL for the year to the end of the week. With By Sub Packages chosen the same lines are shown for each sub-package instead.
SUMMARY OF REVENUES (Accounting Report) is the lettered revenue statement, with a DESCRIPTION for each line and the same day and totals columns. A GIFT CARDS SOLD QTY and B GIFT CARDS SOLD $$$ count and value the gift cards sold, kept apart because a gift card is not a sale until it is used. C GROSS REPAIR REVENUES is the gross sales of the invoices finalized that day, and the lines D MINUS SALES TAX, E MINUS STATE TIRE TAX, F MINUS STATE BATTERY FEE, G MINUS SMOG CERT FEES, H MINUS VEHICLE INSP. CERT FEES, I MINUS BRAKE/LAMP CERT FEES and J MINUS VEHICLE STATE SAFETY INSP. CERT FEES are the tax and pass-through fees the shop only collects, so K=C-D-E-F-G-H-I-J NET SALES is what the shop actually earned. L CAR COUNT is the number of invoices and M=K/L TICKET AVERAGE the net sales per invoice. N COGS (INVENTORY) is the stock cost of the parts drawn from inventory for those invoices, O COGS (OPP) what was paid for parts bought outside for them, P=N+O TOTAL COST OF GOODS and Q=K-P GROSS PROFIT. The people lines follow from the time sheets and commissions: R TOTAL REGULAR HOURS, S TOTAL OVERTIME HOURS, T SALES COMMISSIONS, U TECH COMMISSIONS, V TOTAL PAY Q+R+S+T (the pay for the hours plus the commissions), W PAYROLL % of net sales and X GROSS PROFIT - TOTAL PAY. The refund lines count by the refund date: Y NUMBER OF INVOICES REFUNDED, Z TOTAL AMOUNT REFUNDED, AA NET SALES AMOUNT REFUNDED and AB NET SALES AFTER REFUNDS. AC COUPON AND DISCOUNTS is every discount given on the invoices, and AD FLEET PAYMENTS RECEIVED the payments received on fleet accounts that day.
COMPOSITION OF NET SALES (Accounting Report) breaks net sales into what the customer paid for: Total Parts After Discount, Total Labor After Discount, Shop Supply Fee, Hazardous Waste Fee, Oil Surcharge Fee, Electronic Transfer Fee, Tire Disposal Fee and Battery Disposal Fee, with Net Sales (Equals J above) as their sum, which matches the net sales line of the revenue table. Its totals columns are WEEK TOTAL, LAST 30 DAYS DATA and YEAR TOTAL.
SUMMARY OF DEPOSITS (Accounting Report) lists every PAYMENT TYPE the store has, such as Cash, VISA and Fleet Charge, with the money received by that method on the invoices finalized each day, shown on the day the invoice was finalized whenever the payment was taken. TOTAL RECEIPTS FROM FINALIZED INVOICES adds the methods. PLUS FUTURE DEPOSIT ON DRAFT INVOICES is money taken that day on invoices not finalized that day, LESS PRIOR DEPOSIT APPLIED ON FINALIZED INVOICES is the part of the day's receipts that had actually been collected on an earlier day, and ACTUAL RECEIPTS is the first line plus the second less the third, the money that really came in that day. CASH USED FROM TODAYS REVENUES is the cash paid out of the drawer for expenses that day and CASH LEFT OVER FROM TODAYS REVENUES the cash taken less the cash used. STARTING CASH DRAWER, ENDING CASH DRAWER and CASH DEPOSIT TO BANK come from the day's End of Day cash count; the drawer figures show N/A in the totals columns because a drawer balance is a snapshot, not a sum, while the bank deposits are added.
The Add To Favorites switch beside the heading saves the report under Favorites on the Reports page. The report also opens as WEEKLY SALES JOURNAL from the End of Day Report. Which reports you see depends on your admin group permissions.
