Reports · April 2026
Monthly Asset Report
For accounting · cost + 30% retail basis · all warehouses
Total Items
18,240
348 SKUs
Total Cost Basis
$648,396
FIFO · as of Apr 20
Retail Value (+30%)
$842,915
▲ $194,519 markup
Aged (Green Tag)
$46,280
73 SKUs · aged 60d+
Asset line items
April 1 – April 20, 2026 · all warehouses
By SKU
By category
By warehouse
| Product # | Item | Qty | Unit cost | Cost basis | Retail (+30%) | Markup |
|---|---|---|---|---|---|---|
| SP-41002 |
Smart Closer Pro
Core Access · Closers
|
7 | $326.40 | $2,284.80 | $2,970.24 | +$685.44 |
| SP-20013 |
Flush Bolt Kit
Prime Door · Exit HW
|
12 | $57.00 | $684.00 | $889.20 | +$205.20 |
| SP-71120 |
Lever Handle Set SELL ME
DoorLine · Locksets
|
46 | $90.00 | $4,140.00 | $5,382.00 | +$1,242.00 |
| SP-31577 |
Panic Rim Touchbar
DoorLine · Exit HW
|
5 | $249.00 | $1,245.00 | $1,618.50 | +$373.50 |
| SP-55120 |
Mortise Cylinder LC
DoorLine · Locksets
|
4 | $80.00 | $320.00 | $416.00 | +$96.00 |
| SP-80021 |
Hinge 4.5" BB
Prime Door · Hinges
|
88 | $18.00 | $1,584.00 | $2,059.20 | +$475.20 |
| SP-41210 |
Electric Strike 12V
Core Access · Access
|
7 | $270.00 | $1,890.00 | $2,457.00 | +$567.00 |
| SP-72040 |
Door Coordinator
Prime Door · Closers
|
9 | $150.00 | $1,350.00 | $1,755.00 | +$405.00 |
| Shown subtotal | $13,497.80 | $17,547.14 | +$4,049.34 | |||
| All 348 SKUs total | $648,396 | $842,915 | +$194,519 | |||
Showing 1–8 of 348 SKUs
Send to accountant
One click · monthly close
Report period
Retail basis
Format
PDF
CSV
QuickBooks
Report includes: item, qty, cost, retail (cost + 30%), total value. Green-tag aged items flagged separately.
Value by category
Closers$214,080
Exit Hardware$186,344
Locksets$158,920
Access Control$142,150
Hinges + Kick$98,421
Other$43,000
Saved reports
March 2026 close
Sent Apr 3 · Karla · PDF
February 2026 close
Mar 2 · CSV · QuickBooks sync
January 2026 close
Feb 1 · PDF