Westwood Sheds — Internal Tools

INVENTORY JOURNAL ENTRY

Monthly QBO Journal Entry Report — Upload files, enter prior values, generate

STEP 0 — DOWNLOAD FILES FROM SHEDSUITE
Follow these steps each month before uploading — log in at app.shedsuite.com
📦 File 1 — Inventory Report
  1. Go to Reports → Inventory
  2. Set Date to Date Ordered
  3. Set Date Range to All Time
  4. Click Select One or More Filters → Build Stage → select Finished
  5. Confirm active filters show: Build Stage: Finished  |  Date Field: Date Ordered  |  Date Range: All Time
  6. Click Export → Export as Excel and save the file
🧾 File 2 — Sales Report (WIP Orders)
  1. Go to Reports → Sales
  2. Set Date to Order
  3. Set Date Range to All Time
  4. Click Select One or More Filters → Order Status → select all four:
    Assigned To Driver  |  Finished At Shop  |  On Hold  |  Scheduled For Delivery
  5. Confirm 4 active Order Status filters are shown
  6. Click Export → Export as Excel and save the file
🧾 File 3 — Sales Report (Unprocessed Offlot) — only if orders exist
  1. Stay on Reports → Sales and click Clear All to remove previous filters
  2. Set Date to Order
  3. Set Date Range to All Time
  4. Click Select One or More Filters → Order Status → select Unprocessed
  5. Click Select One or More Filters → Order Type → select Offlot
  6. If any orders appear, click Export → Export as Excel and save the file
  7. If no orders appear, skip this file — the upload below is optional
STEP 1 — UPLOAD FILES
📦 Click or drag to upload Inventory Report .xlsx
No file selected
🧾 Click or drag to upload Sales Report WIP .xlsx
No file selected
🧾 Click or drag to upload Sales Report Unprocessed .xlsx
Optional — skip if no unprocessed offlot orders
STEP 2 — QUARTERLY COST SETTINGS
Update quarterly — cost % of retail and GL split % for each section group
%
%
%
GL SPLITS — SECTIONS 1 & 5 (Sheds, Playhouses & Greenhouses)
Must total 100% — used to split the journal entry delta across the three COGS accounts
#51190
%
#51290
%
#51490
%
Total: 100.0% ✓
STEP 3 — PRIOR MONTH COST VALUES FROM QBO

Enter the current cost value for each account as it exists in QBO — ordered by account number so you can go straight down the line

#13110 Raw Materials
#13210 New Inventory WIP — full QBO balance (used for assets total)
↳ Of that, prior Gazebo WIP portion (enter manually — tracked separately)
#13220 Used Inventory WIP
#13310 New Inventory (Except Gazebos)
#13320 Used Inventory
#13330 New Gazebos
#13000 Inventory Assets Total —

RESULTS

INVENTORY SUMMARY
#SectionQBO Account UnitsRetail ValueCost %Cost Value
JOURNAL ENTRIES

FILE VERIFICATION

SourceUnitsRetail Value