Sample Reports
Sales Analysis by department –
Customer Price List Order Form
STORE NO. 02 POS Solutions
DAILY REGISTER SUMMARY REPORT
DATE \@ "M/d/yyyy h:mm am/pm" 1/31/2006 11:18 AM PAGE 1
REGISTER 1
CASH 279.21
CHECK 111.46
COUPON 12.54
MC/VISA 172.34
DISCOVER 4.98
AMEX 134.94
------------
REGISTER TOTAL 715.47
NON TAXABLE 715.47
------------
SUBTOTAL (NET SALES) 715.47
------------
715.47
REFUNDS -5.96
VOID TRANS 1.80
STORE NO. 02 POS Solutions
DEPARTMENT SALES REPORT
DATE \@ "M/d/yyyy h:mm am/pm" 1/31/2006 11:18 AM PAGE 1
DESCRIPTION SOLD RETRN NET SOLD GROSS SALES RETURNS DISCOUNT COUPONS NET SALES COST MARGIN GM %
------------------------------------------------------------------------------------------------------------------------------------
MULCH 1 0 1 4.29 0.00 0.00 0.00 4.29 2.45 1.84 42.89
STONE 8 2 6 23.48 -5.96 0.00 0.00 17.52 9.65 7.87 44.92
FERTILIZER 2 0 2 41.57 0.00 0.00 0.00 41.57 24.23 17.34 41.71
CHEMICALS 2 0 2 21.48 0.00 0.00 0.00 21.48 10.81 10.67 49.67
GRASS SEED 6 0 6 249.88 0.00 0.00 0.00 249.88 136.75 113.13 45.27
PLANTERS 1 0 1 10.79 0.00 0.00 0.00 10.79 4.88 5.91 54.77
DEPARTMENT 26 1 0 1 50.00 0.00 0.00 0.00 50.00 25.00 25.00 50.00
DEPARTMENT 57 3 0 3 319.94 0.00 0.00 0.00 319.94 112.76 207.18 64.76
------------------------------------------------------------------------------------------------------------------------------------
TOTALS THIS DAY 24 2 22 721.43 -5.96 0.00 0.00 715.47 326.53 388.94 54.36
STORE NO. 02 POS Solutions
SALES BY CLERK ID
DATE \@ "M/d/yyyy h:mm am/pm" 1/31/2006 11:18 AM PAGE 1
CLERK NAME TRANS SALES AMT AVERAGE AMT COST $ MARGIN $ MARGIN % COM SALES NON-COM SALES
--------------------------------------------------------------------------------------------------------------------------------
1234 SAM 3 103.48 34.49 53.92 49.56 47.89 0.00 103.48
2315 POS SOLUTIONS LLC 1 247.21 247.21 95.73 151.48 61.28 0.00 247.21
4321 JOHN 3 124.96 41.65 44.01 80.95 64.78 0.00 124.96
9876 JUNE 6 239.82 39.97 132.87 106.95 44.60 0.00 239.82
--------------------------------------------------------------------------------------------------------------------------------
TOTAL 13 715.47 55.04 326.53 388.94 54.36 0.00 715.47
STORE NO. 02 POS Solutions
DAILY ACTIVITY REPORT
DATE \@ "M/d/yyyy h:mm am/pm" 1/31/2006 11:18 AM PAGE 1
REGISTER 1
SALES TOTAL TOTAL NET AVERAGE % TOTAL NO. OF
HOURS UNITS SALES RETURNS SALES SALE AMOUNT SALES TRANS
---------------------------------------------------------------------------------------------------------
13:00 TO 14:00 5.000 247.21 0.00 247.21 247.21 34.267 1
14:00 TO 15:00 17.000 474.22 -5.96 468.26 39.52 65.733 12
---------------------------------------------------------------------------------------------------------
TOTALS 22.000 721.43 -5.96 715.47 55.49 100.000 13
STORE NO. 02 POS Solutions
DAILY TRANSACTION POSTING REGISTER
DATE \@ "M/d/yyyy h:mm am/pm" 1/31/2006 11:18 AM PAGE 1
REGISTER 01
ITEM NO. DESCRIPTION TYPE QTY PRICE AMOUNT DISCOUNT VARIANCE MGR.
---------------------------------------------------------------------------------------------------------------
INVOICE NUMBER: 0 TRANSACTION: 109 CLERK: 9999 11/29/03 9:13 WAS VOIDED.
1 ***DO NOT USE*** SALE 1 0.00 0.90 -0.10 1.00
TAX 0.00 TOTAL 0.90
INVOICE NUMBER: 0 TRANSACTION: 110 CLERK: 9999 11/29/03 9:14 WAS VOIDED.
1 ***DO NOT USE*** SALE 1 0.00 0.90 -0.10 1.00
TAX 0.00 TOTAL 0.90
INVOICE NUMBER: 0 TRANSACTION: 111 CLERK: 2315 12/03/03 13:27 CUSTOMER: 103 -
103 MULCH BLACK HARDWOOD 3CF SALE 1 4.29 4.29
500 12" RED BRICK DESIGN SALE 1 2.98 2.98
600 GRASS SEED DE MIX 25 LB SALE 1 39.98 39.98
800 PHIPEN-65-09LC300X BLUE SALE 1 119.98 119.98
953 HIPEN-75-08 W PENCIL PNE SALE 1 79.98 79.98
TAX 0.00 TOTAL 247.21
CASH 247.21
INVOICE NUMBER: 0 TRANSACTION: 112 CLERK: 1234 12/03/03 14:11
1000 DOLL 12" BUNNY KID SALE 1 50.00 50.00
3000 MSQUTO-B-GON 32 OZ RTU SALE 1 14.99 14.99
3050 BBG INS KIL 24 OZ RTU SALE 1 6.49 6.49
TAX 0.00 TOTAL 71.48
CHECK 71.48
INVOICE NUMBER: 0 TRANSACTION: 113 CLERK: 9876 12/03/03 14:12
500 12" RED BRICK DESIGN SALE 1 2.98 2.98
200 SMALL WHT MARBLE STONE SALE 1 2.98 2.98
210 STONE LARGE RED 50LB SALE 1 3.29 3.29
210 STONE LARGE RED 50LB SALE 1 3.29 3.29
TAX 0.00 TOTAL 12.54
COUPON 12.54
INVOICE NUMBER: 0 TRANSACTION: 114 CLERK: 9876 12/03/03 14:12
5600 STEP 4 LAWN FERT 15M SALE 1 39.98 39.98
5620 PLANTER CORNER DECK TC SALE 1 10.79 10.79
5630 MIRACLE GRO SPIKES SALE 1 1.59 1.59
TAX 0.00 TOTAL 52.36
MC/VISA 52.36
INVOICE NUMBER: 0 TRANSACTION: 115 CLERK: 4321 12/03/03 14:13
500 12" RED BRICK DESIGN SALE 1 2.98 2.98
540 SLATE SALE 1 0.00 2.00 2.00
TAX 0.00 TOTAL 4.98
DISCOVER 4.98
INVOICE NUMBER: 0 TRANSACTION: 116 CLERK: 9876 12/03/03 14:13
600 GRASS SEED DE MIX 25 LB SALE 1 39.98 39.98
610 GRASS SEED K-31 25 LB SALE 1 34.98 34.98
615 GRASS SEED K-31 50 LB SALE 1 59.98 59.98
TAX 0.00 TOTAL 134.94
AMEX 134.94
STORE NO. 02 POS Solutions
DAILY TRANSACTION POSTING REGISTER
DATE \@ "M/d/yyyy h:mm am/pm" 1/31/2006 11:18 AM PAGE 2
REGISTER 01
ITEM NO. DESCRIPTION TYPE QTY PRICE AMOUNT DISCOUNT VARIANCE MGR.
---------------------------------------------------------------------------------------------------------------
INVOICE NUMBER: 0 TRANSACTION: 117 CLERK: 1234 12/03/03 14:15
500 12" RED BRICK DESIGN CRED 1 -2.98 -2.98
500 12" RED BRICK DESIGN SALE 1 2.98 2.98
500 12" RED BRICK DESIGN CRED 1 -2.98 -2.98
610 GRASS SEED K-31 25 LB SALE 1 34.98 34.98
TAX 0.00 TOTAL 32.00
CASH 32.00
INVOICE NUMBER: 0 TRANSACTION: 118 CLERK: 1234 12/03/03 14:15 NO SALE
TAX 0.00 TOTAL 0.00
CASH 0.00
INVOICE NUMBER: 0 TRANSACTION: 119 CLERK: 4321 12/03/03 14:15 NO SALE
TAX 0.00 TOTAL 0.00
CASH 0.00
INVOICE NUMBER: 0 TRANSACTION: 120 CLERK: 9876 12/03/03 14:15 NO SALE
TAX 0.00 TOTAL 0.00
CASH 0.00
INVOICE NUMBER: 0 TRANSACTION: 121 CLERK: 9876 12/03/03 14:16 NO SALE
TAX 0.00 TOTAL 0.00
CASH 0.00
INVOICE NUMBER: 0 TRANSACTION: 122 CLERK: 9876 12/03/03 14:16
600 GRASS SEED DE MIX 25 LB SALE 1 39.98 39.98
TAX 0.00 TOTAL 39.98
CHECK 39.98
INVOICE NUMBER: 0 TRANSACTION: 123 CLERK: 4321 12/03/03 14:17
800 PHIPEN-65-09LC300X BLUE SALE 1 119.98 119.98
TAX 0.00 TOTAL 119.98
MC/VISA 119.98
STORE NO. 2 POS Solutions
DAILY SALES SUMMARY
DATE \@ "M/d/yyyy" 1/31/2006 PAGE 1
ITEM QTY QTY NET DISCOUNT NET GROSS
ITEM NO. DESCRIPTION SOLD RETN'D SOLD ON HAND COST SALES AMOUNT SALES MARGIN G/M %
------------------------------------------------------------------------------------------------------------------------------------
113 MULCH CEDAR 3CUFT 1 0 1 546.000 2.000 3.290 0.00 3.29 1.29 39.21
500 12" RED BRICK DESIGN 1 0 1 25.000 1.140 2.980 0.00 2.98 1.84 61.74
600 GRASS SEED DE MIX 25 LB 1 0 1 3.000 20.250 39.980 0.00 39.98 19.73 49.35
610 GRASS SEED K-31 25 LB 1 0 1 1.000 19.250 34.980 0.00 34.98 15.73 44.97
4086 CHIM 44"RD BRICK W/STN&C 1 0 1 1.000 94.000 199.980 0.00 199.98 105.98 53.00
14405 24"BRICK PAPER CORRUGATE 1 0 1 29.000 1.870 4.980 0.00 4.98 3.11 62.45
17286 BOOK FLWRING TREES&SHRUB 1 0 1 5.000 6.760 11.950 0.00 11.95 5.19 43.43
18240 10"SANTA WATERING TREES 1 0 1 1.000 15.200 34.980 0.00 34.98 19.78 56.55
20517 11"SNWMN W/LITD TREE ACR 1 0 1 1.000 15.000 32.980 0.00 32.98 17.98 54.52
21560 10"BURG FEATHER BIRDS 2X 1 0 1 -1.000 1.400 3.590 0.00 3.59 2.19 61.00
24072 6" FLOWERING MAGNOLIA 1 0 1 -1.000 2.500 4.990 0.00 4.99 2.49 49.90
------------------------------------------------------------------------------------------------------------------------------------
TOTALS THIS DAY 11 0 11 179.370 374.680 0.00 374.68 195.31 52.13
INVENTORY VALUE - ON HAND AT COST RETAIL GROSS MARGIN G/M %
135,320.00 496,348.73 1,088,072.69 591,723.97 54.38
STORE NO. 2 POS Solutions
SALES HISTORY
DATE \@ "M/d/yyyy" 1/31/2006 PAGE 1
W-T-D M-T-D Y-T-D
----------------------------------------
CASH 167066.38 167066.38 957191.49
CHECK 73374.54 73374.54 985791.25
COUPON 12.54 12.54 258.06
CHARGE 4341.83 4341.83 117651.88
MC/VISA 374786.13 374786.13 3377651.35
DISCOVER -2572.02 -2572.02 -7691.24
AMEX 134.94 134.94 134.94
BANK CARD 4 0.00 0.00 0.00
DEBIT CARD 0.00 0.00 0.00
GIFT CERT 466.21 466.21 475.16
========================================
REGISTER TOTALS 617610.55 617610.55 5431462.89
NON TAXABLE 617610.55 617610.55 5422434.11
TAXABLE 1 0.00 0.00 0.00
TAXABLE 2 0.00 0.00 0.00
TAXABLE 3 0.00 0.00 0.00
TAXABLE 4 0.00 0.00 0.00
TAXABLE 5 0.00 0.00 0.00
TAXABLE 6 0.00 0.00 0.00
----------------------------------------
SUBTOTAL (NET SALES) 617610.55 617610.55 5422434.11
TAX 1 0.00 0.00 0.00
TAX 2 0.00 0.00 0.00
TAX 3 0.00 0.00 0.00
TAX 4 0.00 0.00 0.00
TAX 5 0.00 0.00 0.00
TAX 6 0.00 0.00 0.00
RCVD ON ACCT 0.00 0.00 9028.37
PAID OUT 0.00 0.00 0.00
DEPOSIT 0.00 0.00 0.00
========================================
REGISTER TOTALS 617610.55 617610.55 5431462.48
% DISCOUNT -128458.62 -128458.62 -270020.41
$ DISCOUNT 0.00 0.00 -0.02
REFUNDS -28392.07 -28392.07 -873667.20
FREIGHT 303.05 303.05 34229.38
VOID TRANS 1898420.62 1898420.62 13061495.99
ESTIMATES 0.00 0.00 0.00
TRAINING 0.00 0.00 441.92
PURCH REBATE 0.00 0.00 0.00
CERT. RECV 0.00 0.00 0.00
CERT. SOLD 0.00 0.00 0.00
LAYAWAY 0.00 0.00 0.00
LAYAWAY RECV 0.00 0.00 0.00
CASH ROUND 0.00 0.00 0.00
STORE NO. 2 POS Solutions
DEPARTMENT SALES REPORT
DATE \@ "M/d/yyyy" 1/31/2006 PAGE 1
DESCRIPTION SOLD RETRN NET SOLD GROSS SALES RETURNS DISCOUNT COUPONS NET SALES COST MARGIN GM %
------------------------------------------------------------------------------------------------------------------------------------
MULCH 29 0 29 120.59 0.00 0.00 0.00 120.59 81.40 39.19 32.50
STONE 49 2 47 213.84 -5.96 -5.54 0.00 202.34 111.57 90.77 44.86
FERTILIZER 14 0 14 182.84 0.00 0.00 0.00 182.84 112.50 70.34 38.47
TOOLS 6 0 6 81.00 0.00 -2.19 0.00 78.81 40.68 38.13 48.38
CHEMICALS 11 0 11 147.39 0.00 -31.45 0.00 115.94 69.73 46.21 39.86
GRASS SEED 8 0 8 324.84 0.00 0.00 0.00 324.84 176.25 148.59 45.74
CANDLES 2948 1 2947 18805.83 -11.00 -4588.32 0.00 14206.51 9229.57 4976.94 35.03
GIFTS 120 0 120 1087.47 0.00 -464.01 0.00 623.46 534