Data Review
💾 Download backup
Unit reconciliation
Units received
1849
−
Units sold
208
=
Expected on hand
1641
vs
Actual on hand
1641
✓ Balanced
Cost reconciliation (excluding freight)
Total purchases at cost
$34,007.37
Less: cost of goods sold
− $4,059.32
Less: current inventory at cost
− $31,932.02
Variance
$-1,983.97 ⚠
Note: small variances (<$10) typically reflect rounding in shipping allocation across many line items.
Unit cost check 155 discrepancies
Compares Last Invoice unit cost (actual cost paid, no shipping, from Purchase History) vs Inventory unit cost (cost currently used to value your stock) for every item.
Item Description Vendor Last invoice cost Inventory unit cost Difference
MAX06BOXTRIO-MPM Trio Travel Candles Manhattan-Paris-Myko Baobab Collection Inc $68.60 $77.67 +$9.07
MAX06BOXTRIO-PMC Trio Travel Candles Provence-Monaco-Cote Baobab Collection Inc $68.60 $77.67 +$9.07
MAX06BOXTRIO-SAP Trio Travel Candles Singapore-Athens-Par Baobab Collection Inc $68.60 $77.67 +$9.07
MAX10ES Candle Eden Seaside (Max 10) Baobab Collection Inc $101.50 $111.65 +$10.15
MAX10PB Candle Pearls Black (Max 10) Baobab Collection Inc $101.50 $110.57 +$9.07
MAX10PCO Candle Pearls Coral (Max 10) Baobab Collection Inc $101.50 $110.57 +$9.07
MAX24PB Candle Pearls Black (Max 24) Baobab Collection Inc $269.50 $278.57 +$9.07
2218 VIDA Acrylic Double Old Fashioned Set of Beatriz Ball $30.75 $35.79 +$5.04
2419 VIDA Havana Large Salad Servers Beatriz Ball $11.00 $16.04 +$5.04
2703 VIDA Havana Extra Large Bowl Beatriz Ball $36.50 $41.54 +$5.04
2915 RESIN Rio Bubble Salad Servers Beatriz Ball $32.75 $37.79 +$5.04
2957 VIDA Havana Extra Large Platter Beatriz Ball $33.00 $38.04 +$5.04
3015 RESIN Rio Bubble Salad Servers Beatriz Ball $42.00 $47.04 +$5.04
3020 RESIN Rio Large Round Bowl with Base Beatriz Ball $120.50 $125.54 +$5.04
3024 RESIN Rio Small Round Bowl with Base Beatriz Ball $34.50 $39.54 +$5.04
3098 VIDA Acrylic Double Old Fashioned Set of Beatriz Ball $27.50 $32.54 +$5.04
3190 RESIN Giada Centerpiece Beatriz Ball $109.75 $114.79 +$5.04
3194 RESIN Giada Salad Servers Beatriz Ball $43.50 $48.54 +$5.04
3228 RESIN Sorbet Cheese Set of 3 Beatriz Ball $27.50 $32.54 +$5.04
3229 RESIN Sorbet Cheese Set of 3 Beatriz Ball $27.50 $32.54 +$5.04
3230 RESIN Sorbet Cheese Set of 3 Beatriz Ball $27.50 $32.54 +$5.04
3231 RESIN Sorbet Cheese Set of 3 Beatriz Ball $27.50 $32.54 +$5.04
3347 VIDA Acrylic Double Old Fashioned Set of Beatriz Ball $27.00 $32.04 +$5.04
16794CG Napkin Airlaid Cocktail Pebble Seafoam - Caspari, Inc. $2.75 $3.26 +$0.51
17461CG Napkin Airlaid Cocktail Algarve Aqua - P Caspari, Inc. $2.75 $3.26 +$0.51
17770C Napkin Cocktail Samsara Stone Blue Caspari, Inc. $2.75 $3.26 +$0.51
17792C Napkin Cocktail Pontchartrain Scallop Caspari, Inc. $2.75 $3.26 +$0.51
17880CG Napkin Airlaid Cocktail Bamboo Screen Ro Caspari, Inc. $2.75 $3.26 +$0.51
17880TCL Print Airlaid Tablecove Bamboo Screen Ro Caspari, Inc. $8.25 $8.76 +$0.51
17882CG Napkin Airlaid Cocktail Bamboo Screen Co Caspari, Inc. $2.75 $3.26 +$0.51
17883CG Napkin Airlaid Cocktail Bamboo Screen Ch Caspari, Inc. $2.75 $3.26 +$0.51
18310TCL Print Airlaid Tablecove Toile de Nantes Caspari, Inc. $8.25 $8.76 +$0.51
18311TCL Print Airlaid Tablecove Toile de Nantes Caspari, Inc. $8.25 $8.76 +$0.51
18350CG Napkin Airlaid Cocktail Toile de Nantes Caspari, Inc. $2.75 $3.26 +$0.51
18351CG Napkin Airlaid Cocktail Toile de Nantes Caspari, Inc. $2.75 $3.26 +$0.51
19000C Napkin Cocktail Hedgerow Moss Green Caspari, Inc. $2.75 $3.26 +$0.51
19030C Napkin Cocktail Boho Stripe Grey Caspari, Inc. $2.75 $3.26 +$0.51
19041CG Napkin Airlaid Cocktail Cafe Stripe Ligh Caspari, Inc. $2.75 $3.26 +$0.51
19041TCL Print Airlaid Tablecove Cafe Stripe Ligh Caspari, Inc. $8.25 $8.76 +$0.51
19044CG Napkin Airlaid Cocktail Cafe Stripe Aqua Caspari, Inc. $2.75 $3.26 +$0.51
19052CGDC Napkin Airlaid Cocktail Cafe Stripe Scal Caspari, Inc. $5.50 $6.01 +$0.51
19371CG Napkin Airlaid Cocktail Melograno Stripe Caspari, Inc. $2.75 $3.26 +$0.51
19372CG Napkin Airlaid Cocktail Melograno Stripe Caspari, Inc. $2.75 $3.26 +$0.51
92614CCU12 Correspondence C Size P Hello Script Caspari, Inc. $8.50 $9.35 +$0.85
93612CCU12 Correspondence C Size P Just A Note Caspari, Inc. $8.50 $9.35 +$0.85
95664CCU12 Correspond C Sz Print Just Spots Blue Caspari, Inc. $8.50 $9.35 +$0.85
95665CCU12 Correspond C Sz Print Just Spots Green Caspari, Inc. $8.50 $9.35 +$0.85
96608CCU12 Corresp C Sz Prt D/C 12 Scallop Border M Caspari, Inc. $8.50 $9.35 +$0.85
96609CCU12 Corresp C Sz Prt D/C 12 Scallop Border R Caspari, Inc. $8.50 $9.35 +$0.85
ACR101 Acrylic 12 oz Tumbler Emerald Caspari, Inc. $3.75 $4.26 +$0.51
ACR102 Acrylic 12 oz Tumbler Turquoise Caspari, Inc. $3.75 $4.26 +$0.51
ACR105 Acrylic 12 oz Tumbler Cranberry Caspari, Inc. $3.75 $4.26 +$0.51
ACR506 Acrylic Flared Wine Glass Caspari, Inc. $5.75 $6.26 +$0.51
ACR550 Acrylic Flared Water Glass Caspari, Inc. $6.55 $7.06 +$0.51
ACRPIT100 Ttop Acrylic Tall Pitcher Clear Caspari, Inc. $30.00 $30.51 +$0.51
ACRPIT106 Ttop Acrylic Tall Pitcher Caspari, Inc. $30.00 $30.51 +$0.51
FTN007B Fabric Cotton Napkin Set Block Print Lea Caspari, Inc. $17.50 $18.01 +$0.51
FTN009A Fabric Cotton Napkin Set Block Print Lea Caspari, Inc. $17.50 $18.01 +$0.51
FTN011B Fabric Cotton Napkin Set Trellis Green/W Caspari, Inc. $17.50 $18.01 +$0.51
JUG003 Ttop Acrylic Pitcher Turquoise Caspari, Inc. $15.50 $16.01 +$0.51
OMPH012A Fabric Oven Mitt/Pot Holder Pagoda Toile Caspari, Inc. $20.00 $20.51 +$0.51
OMPH015A Fabric Oven Mitt/Pot Holder Garden Trell Caspari, Inc. $20.00 $20.51 +$0.51
C002 Ivory Chrysanhemum Chive $18.54 $18.89 +$0.35
EG19 Milk Teal Poppy Chive $11.94 $12.29 +$0.35
FR33 Peach Pink Madonna Azalea Chive $19.64 $19.99 +$0.35
JA11 Peridot Sorbet Peony Chive $20.74 $21.09 +$0.35
JA12 Navy Sorbet Peony Chive $20.74 $21.09 +$0.35
NA06 Blue White Columbine Chive $14.14 $14.49 +$0.35
LC300CO Hand & Body Lotion Cotton Flower 10 fl o Cie Luxe Brands LLC $17.00 $17.94 +$0.94
LC300PA Hand & Body Lotion Pink Grapefruit 10 fl Cie Luxe Brands LLC $17.00 $17.94 +$0.94
LC300RO Hand & Body Lotion Wild Rose 10 fl oz Cie Luxe Brands LLC $17.00 $17.94 +$0.94
LC300VE Hand & Body Lotion Fresh Verbena 10 fl o Cie Luxe Brands LLC $17.00 $17.94 +$0.94
SL500CO Liquid Soap Cotton Flower 16.7 fl oz Cie Luxe Brands LLC $15.00 $15.94 +$0.94
SL500JD Liquid Soap Soft Jasmine 16.7 fl oz Cie Luxe Brands LLC $15.00 $15.94 +$0.94
SL500PA Liquid Soap Pink Grapefruit 16.7 fl oz Cie Luxe Brands LLC $15.00 $15.94 +$0.94
SL500RO Liquid Soap Wild Rose 16.7 fl oz Cie Luxe Brands LLC $15.00 $15.94 +$0.94
SL500VE Liquid Soap Fresh Verbena 16 fl oz Cie Luxe Brands LLC $15.00 $15.94 +$0.94
V157LB Blue Flower Vase CONTINENTAL HOME $35.00 $36.80 +$1.80
V157SG Green Flower Vase CONTINENTAL HOME $35.00 $36.80 +$1.80
V163C Cream Flower Bowl CONTINENTAL HOME $195.00 $196.80 +$1.80
V212W White Flower Vase CONTINENTAL HOME $29.00 $30.80 +$1.80
V303W White Butterfly Vase CONTINENTAL HOME $55.00 $56.80 +$1.80
CB07S4 Swirl Dinner Plates Set of 4 CP Squared Inc. $41.40 $45.44 +$4.04
CB30 Swirl Nesting Bowls CP Squared Inc. $20.70 $24.74 +$4.04
GL07S4 Swirl Dinner Plates Set of 4 CP Squared Inc. $41.40 $45.44 +$4.04
GL11S4 Swirl Sandwich Plates Set of 4 CP Squared Inc. $33.30 $37.34 +$4.04
GL30 Swirl Nesting Bowls CP Squared Inc. $20.70 $24.74 +$4.04
TP07S4 Swirl Dinner Plates Set of 4 CP Squared Inc. $41.40 $45.44 +$4.04
TP11S4 Swirl Sandwich Plates Set of 4 CP Squared Inc. $33.30 $37.34 +$4.04
TP30 Swirl Nesting Bowls CP Squared Inc. $20.70 $24.74 +$4.04
WW24 Solid Petite Colander CP Squared Inc. $17.10 $21.14 +$4.04
31987 Tea Towel Sous Les Etoiles Red 24 Le Jacquard Francais $12.45 $13.76 +$1.31
31988 Tea Towel Sous Les Etoiles Green 24 Le Jacquard Francais $12.45 $13.76 +$1.31
LIN40GRDN Mom's Garden preformed plate liners - Se Plate & Pattern (via Ivystone) $16.00 $20.00 +$4.00
LIN40SANDSTR Sandy Stripes preformed plate liners - S Plate & Pattern (via Ivystone) $16.00 $20.00 +$4.00
LIN40SEABLU Seascape Blue preformed plate liners - S Plate & Pattern (via Ivystone) $16.00 $20.00 +$4.00
PLTWHT01 White Metal Plates - 4 white metal plate Plate & Pattern (via Ivystone) $35.00 $39.00 +$4.00
25504W-750-09J Burlap Weave Small Wired Edge Ribbon Nat Reliant Ribbon Corp. $17.77 $18.16 +$0.39
25690-030-18C Twisted Paper Cord White Reliant Ribbon Corp. $10.67 $11.06 +$0.39
90411W-907-09J Web Natural Wired Edge Ribbon Coral Reliant Ribbon Corp. $14.26 $14.65 +$0.39
92975W-055-05F Dupioni Supreme Wired Edge Ribbon Navy Reliant Ribbon Corp. $6.50 $6.89 +$0.39
92975W-056-09H Dupioni Supreme Wired Edge Ribbon Mint Reliant Ribbon Corp. $11.45 $11.84 +$0.39
92975W-058-05F Dupioni Supreme Wired Edge Ribbon Orange Reliant Ribbon Corp. $6.50 $6.89 +$0.39
92975W-067-09H Dupioni Supreme Wired Edge Ribbon Dusty Reliant Ribbon Corp. $11.45 $11.84 +$0.39
92975W-092-09H Dupioni Supreme Wired Edge Ribbon Brown Reliant Ribbon Corp. $11.45 $11.84 +$0.39
92975W-688-09F Dupioni Supreme Wired Edge Ribbon Mustar Reliant Ribbon Corp. $6.90 $7.29 +$0.39
92975W-915-09H Dupioni Supreme Wired Edge Ribbon Jade Reliant Ribbon Corp. $11.45 $11.84 +$0.39
93156W-258-09F Field Plaid Stitch Wired Edge Ribbon Ora Reliant Ribbon Corp. $6.16 $6.55 +$0.39
93826W-177-40F Plaid Terra Grand Decor Canvas Wired Edg Reliant Ribbon Corp. $22.16 $22.55 +$0.39
93826W-577-40F Plaid Terra Grand Decor Canvas Wired Edg Reliant Ribbon Corp. $22.16 $22.55 +$0.39
93853W-053-09F Rustic Burlap Wired Edge Ribbon Blue Reliant Ribbon Corp. $14.72 $15.11 +$0.39
93908W-137-40F Aspen Dupioni Check Wired Edge Ribbon Ce Reliant Ribbon Corp. $10.60 $10.99 +$0.39
94359W-043-05F Custom Color Dupioni Wired Edge Ribbon M Reliant Ribbon Corp. $5.36 $5.75 +$0.39
94670W-077-09J Plaid Leon Ticking Wired Edge Ribbon Aqu Reliant Ribbon Corp. $26.17 $26.56 +$0.39
94755W-577-05D Plaid Tierra Sage Diagonal Dupioni Backe Reliant Ribbon Corp. $14.72 $15.11 +$0.39
31999 Calendrier 2027 Tea Towel 24x31 Rosse & Associates $8.00 $9.00 +$1.00
M1030011 Lente Tumbler Rosse & Associates $11.70 $13.11 +$1.41
M1030332 Lente Bowl Small Rosse & Associates $15.00 $21.41 +$6.41
M1031111 Lente Tumbler Rosse & Associates $11.70 $13.11 +$1.41
M1111120 Palla Glaze Pitcher Rosse & Associates $52.50 $58.91 +$6.41
M1111520 Palla Glaze Pitcher Rosse & Associates $52.50 $58.91 +$6.41
M1113320 Palla Glaze Pitcher Rosse & Associates $52.50 $58.91 +$6.41
M2111111 Fisheye Tumbler Rosse & Associates $13.50 $14.91 +$1.41
M2111511 Fisheye Tumbler Rosse & Associates $13.50 $14.91 +$1.41
2090.OL20S Striped Napkin 100% polyester SARO $3.35 $3.82 +$0.47
2521.BL20S Hand Block Print Napkin 100% cotton SARO $4.27 $4.74 +$0.47
5618.NB20S Striped Napkin 100% cotton SARO $4.21 $4.68 +$0.47
6605.N20S Stripe Fringe Napkin 50% cotton - 50% li SARO $3.42 $3.89 +$0.47
793.A20S Whip Stitched Design Napkin 100% cotton SARO $4.75 $5.22 +$0.47
793.GY20S Whip Stitched Design Napkin 100% cotton SARO $4.75 $5.22 +$0.47
793.NB20S Whip Stitched Design Napkin 100% cotton SARO $4.75 $5.22 +$0.47
8199.N20S Scalloped Stripe Napkin 100% cotton SARO $4.50 $4.97 +$0.47
NR509.BR Woven Rattan Napkin Ring 100% rattan SARO $3.65 $4.12 +$0.47
NR509.W Woven Rattan Napkin Ring 100% rattan SARO $3.65 $4.12 +$0.47
TH015.N5060B Diamond Woven Throw 75% cotton - 25% acr SARO $28.13 $28.60 +$0.47
TH292.N5060B Dashed Line Throw 100% cotton SARO $31.75 $32.22 +$0.47
TH505.N5060B Stripe Throw 100% cotton SARO $34.51 $34.98 +$0.47
J2543 Acrylic + Paper Fill - Leave A Message Schauben & Co $12.79 $16.31 +$3.52
J2544 Acrylic + Paper Fill - After Coffee Schauben & Co $14.25 $17.77 +$3.52
J2546 Acrylic + Paper Fill - Just Sayin Schauben & Co $14.25 $17.77 +$3.52
J2547 Acrylic + Paper Fill - Busy Bee Schauben & Co $14.25 $17.77 +$3.52
J5425 6 Acrylic + Paper Fill - Long Story Shor Schauben & Co $14.25 $17.77 +$3.52
1 Round Match Striker - Black Tart by Taylor Wholesale $27.00 $28.25 +$1.25
2 Round Match Striker - Royal Blue Tart by Taylor Wholesale $27.00 $28.25 +$1.25
3 Round Match Striker - Light Pink Tart by Taylor Wholesale $27.00 $28.25 +$1.25
4 Round Match Striker - Orange Tart by Taylor Wholesale $27.00 $28.25 +$1.25
5 Round Match Striker - Light Blue Tart by Taylor Wholesale $27.00 $28.25 +$1.25
6 Round Match Striker - Gold Tart by Taylor Wholesale $27.00 $28.25 +$1.25
7 Medium Bubble Lucite Tray Tart by Taylor Wholesale $42.00 $43.25 +$1.25
13038.DC.25 Dome Clear PVC Shrink Cellophange Bags 3 Willow Group $26.80 $27.90 +$1.10
1PBAG2530.C.100 Polypropylene Non-shrink Bag for Gift Ba Willow Group $68.90 $70.00 +$1.10
1WOOD.20 20# Shredded Wood Excelsior Gift & Displ Willow Group $34.15 $35.25 +$1.10
83173.11 RECT WOOD TRAY Willow Group $5.45 $6.55 +$1.10
8403.10 Seagrass Bowl Willow Group $5.55 $6.65 +$1.10
85645 Round Wood Stave Basket w/3 Drainage Hol Willow Group $3.95 $5.05 +$1.10
A difference means your inventory unit cost differs from what was actually paid on the most recent invoice. To correct, use the Edit button on the Products page to update the inventory unit cost.
Freight reconciliation ✓ Balanced
Compares total freight from invoice headers vs total freight allocated across all purchase line items (units received × per-unit shipping).
Total freight from invoice headers
$1,882.98
Total freight allocated to line items
$1,882.97
Variance
$0.01
Small variances (<$0.05) are normal due to per-unit rounding. Larger variances indicate freight was not fully allocated — use Edit Freight in Purchase History to correct.
Sales summary
Sales at retail
$7,005.57
Cost of goods sold
$4,059.32
Gross margin
$2,946.25
Current inventory
At cost
$31,932.02
At retail
$57,579.47
Total units on hand
1641
Total landed cost (incl. freight)
$35,890.34
Purchase history Filled orders Inventory Products