Costing Reports
The Costing Reports provide comprehensive financial analysis and supplier quote comparison capabilities across all costings in your system. These reports are essential for pricing decisions, margin analysis, supplier negotiations, and range planning workflows, enabling teams to make informed sourcing decisions and maintain financial visibility throughout the product development lifecycle.
Costing Reports offer four main report types designed to support different aspects of financial management and supplier analysis:
- Costing Quotes: Compare supplier quotes across multiple costings for informed sourcing decisions
- Costing Summary: Track costing status, financial metrics, and supplier information across your product range
- Forecasted Margins: Analyze key financial metrics for forecasting and margin analysis
- Range Sign Off Summary: Review and approve costings at a collection or range level
These reports help teams:
- Compare supplier quotes and pricing across multiple costings
- Track financial metrics including margins, profits, and EBIT
- Make informed sourcing and pricing decisions
- Support range planning and approval workflows
- Export data for analysis and reporting
- Monitor costing status and completion across collections
All values in the costing reports are automatically synchronised with the corresponding fields in the Costing records, ensuring the reports always reflect the most current costing data.
Costing Quotes
The Costing Quotes report provides a comprehensive view of supplier quote data from all costings. This report displays quotes for all suppliers in each costing, enabling you to compare supplier quotes across multiple costings and make informed sourcing decisions.
Field Mappings and Data Sources
| Field | Source/Calculation |
|---|---|
| Buy Price Local | Costing > Supplier > Buy Price Local |
| Buy Price Local (Qty) | Buy Price Local × (Supplier) Quantity |
| Landed Cost | Costing > Supplier > Landed Cost |
| Landed Cost (Qty) | Landed Cost × (Supplier) Quantity |
| Gross Margin % | Costing > Supplier > Gross Margin % |
| Total Cost | Costing > Supplier > Total Cost |
| Total Cost (Qty) | Total Cost × (Supplier) Quantity |
| Gross Profit % | Costing > Supplier > Gross Profit % |
| RRP (Qty) | Costing > Style > RRP × (Supplier) Quantity |
| RRP Local (Qty) | Costing > Style > RRP Local × (Supplier) Quantity |
Data Accuracy
All values in the Costing Quotes report are automatically synchronised with the corresponding fields in the Costing, ensuring the report always reflects the most current costing data.
Report Configuration
| Section | Options |
|---|---|
| Filters | Agent, Base Currency, Brand, Category, Collection, Customer, Department, Designer, Factory, License, Season, Status, Story, Sub Category, Sub Type, Style, Type |
| Sort | Sort by 1st (Asc = Ascending; Desc = Descending) and Sort by 2nd (Asc = Ascending; Desc = Descending) |
| Group | Costings by: Type |
| Columns | Costing, Style, Description, Customer, Department, Season, Brand, License, Collection, Story, Designer, Type, Category, Sub Category, Sub Type, Est. ETD, Est. Qty, Base Currency, Buy Price Local, Buy Price Local (Qty), Landed Cost, Landed Cost (Qty), Gross Margin %, Total Cost, Total Cost (Qty), Gross Profit %, Required EBIT %, RRP, RRP Local, RRP Local (Qty), Agent, Factory, Quote, Est Buy Price, Quote Qty, Quote Price, Colour, Quote Notes, Select, Status |
Filter Descriptions
| Filter | Description | Related Documentation |
|---|---|---|
| Agent | The agent associated with the costing. | Costing > Supplier |
| Base Currency | The base currency used for the costing calculations. | Costing > Details |
| Brand | The brand associated with the style in the costing. Brands are used for reporting, filtering, and attribution. | Site Settings > Style > Brand |
| Category | The main product category (e.g., Womenswear, Menswear, Accessories). Categories help structure product libraries and support dashboard segmentation. | Site Settings > Style > Category |
| Collection | The seasonal or thematic grouping the style belongs to (e.g., SS24 Drop 1, Holiday 2024). | Site Settings > Style > Collection |
| Customer | The customer or retail channel for the costing. | Site Settings > Company > Customer |
| Department | The department responsible for the style (e.g., Menswear, Footwear, Kidswear). | Site Settings > Order > Department |
| Designer | The designer who created the style. | Site Settings > Company > Staff |
| Factory | The factory associated with the supplier quote. | Costing > Supplier |
| License | The licensing agreement related to the style. Used for tracking intellectual property rights. | Site Settings > Style > License |
| Season | The fashion season the style belongs to (e.g., SS25, FW24). Seasons serve as key reference points in planning and reporting. | Site Settings > Style > Season |
| Status | The current status of the costing (e.g., Draft, Approved, Completed). | Costing > Side Widgets > Status |
| Story | The design concept or theme associated with the style (e.g., Back to School, European Summer). | Site Settings > Style > Story |
| Sub Category | More specific product classification under the main category. | Site Settings > Style > Category |
| Sub Type | Further refinement of the product type. | Site Settings > Style > Type |
| Style | The style number associated with the costing. | Style > Details |
| Type | The style type that helps categorise products (e.g., Tops, Bottoms, Outerwear). | Site Settings > Style > Type |
Report Features
- Filter by multiple criteria to narrow down costing quotes
- Sort by any column in ascending or descending order
- Group costings by type
- Customise column visibility
- Export to Excel
- View detailed costing and supplier quote information
- Enable or disable visibility
Costing Summary
The Costing Summary report provides a comprehensive overview of all costings, enabling you to track costing status, financial metrics, and supplier information across your product range. This report offers a complete view of costings with key information including pricing, margins, and status.
Report Configuration
| Section | Options |
|---|---|
| Filters | Agent, Base Currency, Collection, Costing Description, Customer, Designer, Factory, Season, Status, Story, Style, Terms, Type |
| Sort | Sort by 1st (Asc = Ascending; Desc = Descending) and Sort by 2nd (Asc = Ascending; Desc = Descending) |
| Columns | Image, Costing, Style, Description, Type, Gender, Story, Costing Description, License, Collection, Designer, Season, Size Scale, Customer, Factory, Agent, Base Currency, Terms, Created by, RRP, Buy Price, Sell Price, Gross Margin, Gross Profit, Actual EBIT, Actual EBIT rate, EBIT, Download (pdf), Status |
Filter Descriptions
| Filter | Description | Related Documentation |
|---|---|---|
| Agent | The agent associated with the costing. | Costing > Supplier |
| Base Currency | The base currency used for the costing calculations. | Costing > Details |
| Collection | The seasonal or thematic grouping the style belongs to. | Site Settings > Style > Collection |
| Costing Description | The description field from the costing record. | Costing > Details |
| Customer | The customer or retail channel for the costing. | Site Settings > Company > Customer |
| Designer | The designer who created the style. | Site Settings > Company > Staff |
| Factory | The factory associated with the supplier quote. | Costing > Supplier |
| Season | The fashion season the style belongs to. | Site Settings > Style > Season |
| Status | The current status of the costing. | Costing > Sidebar > Status |
| Story | The design concept or theme associated with the style. | Site Settings > Style > Story |
| Style | The style number associated with the costing. | Style > Details |
| Terms | The trade terms associated with the costing. | Costing > Details |
| Type | The costing type (Retail, Import, or Component). | Costing Types |
Report Features
- Filter by multiple criteria to narrow down costings
- Sort by any column in ascending or descending order
- Customise column visibility
- Export to Excel
- Download costing PDFs
- View detailed costing information
- Enable or disable visibility
Forecasted Margins
The Forecasted Margins report displays key financial metrics automatically calculated and updated from the corresponding fields in the Costing. This report is essential for financial forecasting and margin analysis, providing visibility into profitability metrics including gross margins, EBIT, and total costs.
Field Mappings
| Field | Source Location |
|---|---|
| Quantity | Costing > Supplier > Quantity |
| Buy Price Factory | Costing > Supplier > Quote (Approved) |
| Buy Price Local | Costing > Final Buy Price |
| Component Total Local | Costing > Style > Total Component Cost |
| Landed Cost | Costing > Supplier > Landed Cost |
| Gross Margin % | Costing > Supplier > Gross Margin % |
| Total Cost | Costing > Supplier > Total Cost |
| Total Cost (including Overheads) | Costing > Supplier > Total Cost + Overhead Costs + Direct Selling Costs |
| Gross Profit | Costing > Supplier > Gross Profit $ |
| Required EBIT % | Costing > Widget > Required EBIT % |
| Actual EBIT $ | Costing > Supplier > Actual EBIT $ |
| Actual EBIT % | Costing > Supplier > Actual EBIT % |
Data Accuracy
All values in the Forecasted Margin section are automatically synchronised with the corresponding fields in the Costing, ensuring the report always reflects the most current costing data.
Report Configuration
| Section | Options |
|---|---|
| Filters | Agent, Base Currency, Costing Description, Customer, Department, Designer, Factory, Season, Status, Story, Style, Type |
| Sort | Sort by 1st (Asc = Ascending; Desc = Descending) and Sort by 2nd (Asc = Ascending; Desc = Descending) |
| Group | Costings by: Type |
| Columns | Costing, Style, Description, Customer, Department, Costing Description, Agent, Factory, Season, Story, Designer, Type, Base Currency, Quantity, Buy Price Factory, Buy Price Local, Components Total, Landed Cost, Landed Cost (Qty), Gross Margin %, Total Cost, Total Cost (Qty), Total Cost (inc. Overheads), Gross Profit %, Sell Price Local, Total Sales, Required EBIT%, Actual EBIT $, Actual EBIT %, EBIT $ (qty), RRP, RRP (Qty), RRP Local, RRP Local (qty), Customer Margin, Status |
Filter Descriptions
| Filter | Description | Related Documentation |
|---|---|---|
| Agent | The agent associated with the costing. | Costing > Supplier |
| Base Currency | The base currency used for the costing calculations. | Costing > Details |
| Costing Description | The description field from the costing record. | Costing > Details |
| Customer | The customer or retail channel for the costing. | Site Settings > Company > Customer |
| Department | The department responsible for the style. | Site Settings > Order > Department |
| Designer | The designer who created the style. | Site Settings > Company > Staff |
| Factory | The factory associated with the supplier quote. | Costing > Supplier |
| Season | The fashion season the style belongs to. | Site Settings > Style > Season |
| Status | The current status of the costing. | Costing > Sidebar > Status |
| Story | The design concept or theme associated with the style. | Site Settings > Style > Story |
| Style | The style number associated with the costing. | Style > Details |
| Type | The costing type (Retail, Import, or Component). | Costing Types |
Report Features
- Filter by multiple criteria to narrow down forecasted margin data
- Sort by any column in ascending or descending order
- Group costings by type
- Customise column visibility
- Export to Excel
- View detailed financial metrics and margin information
- Enable or disable visibility
Range Sign Off Summary
The Range Sign Off Summary is an interactive costing summary report that supports range planning and approval workflows, enabling teams to review and approve costings at a collection or range level. This report provides a comprehensive view of costing information including quantities, pricing, margins, and completion status, facilitating efficient range sign-off processes.
Field Mappings and Data Sources
| Field | Source/Calculation |
|---|---|
| Image | Style > Preview Image |
| Costing | Costing > Details > Costing Number |
| Style | Costing > Style > Style Number |
| Description | Costing > Style > Style Description |
| Customer | Costing > Customer |
| Department | Costing > Style > Department |
| Agent | Costing > Supplier > Agent |
| Factory | Costing > Supplier > Factory |
| Season | Costing > Style > Season |
| Brand | Style > Details > Brand |
| License | Costing > Style > License |
| Collection | Style > Details > Collection |
| Designer | Style > Details > Designer |
| Story | Costing > Style > Story |
| Type | Costing > Style > Type |
| Colourway | Costing > Style > Colours |
| Est. ETD | Costing > Style > Estimated ETD |
| Est. Qty | Costing > Style > Estimated Qty |
| Confirmed Qty | Costing > Supplier > Final Qty |
| RRP | Costing > Style > RRP |
| RRP Local Qty | RRP × Confirmed Qty |
| Buy Price | Costing > Supplier > Final Buy Price |
| Buy Price Local | Costing > Supplier > Buy Price Local |
| Landed Cost | Costing > Supplier > Landed Cost |
| Total Cost | Costing > Supplier > Total Cost |
| Total Cost Qty | Total Cost × Confirmed Qty |
| Gross Margin | Costing > Supplier > Gross Margin % |
| Gross Profit | Costing > Supplier > Gross Profit % |
| Complete | Updates the Costing status to Completed when ticked |
| Status | Costing Status |
| Action | Provides the Create Order functionality |
Data Accuracy
All values in the Range Sign Off Summary report are automatically synchronised with the corresponding fields in the Costing, ensuring the report always reflects the most current costing data.
Report Configuration
| Section | Options |
|---|---|
| Filters | Agent, Brand, Collection, Customer, Department, Designer, Factory, License, Season, Status, Story, Type |
| Sort | Sort by 1st (Asc = Ascending; Desc = Descending) and Sort by 2nd (Asc = Ascending; Desc = Descending) |
| Columns | Image, Costing, Style, Description, Customer, Department, Agent, Factory, Season, Brand, License, Collection, Designer, Story, Type, Colourway, Est. ETD, Est. Qty, Confirmed Qty, RRP, RRP Local Qty, Buy Price, Buy Price Local, Landed Cost, Total Cost, Total Cost Qty, Gross Margin, Gross Profit, Complete Status, Action |
Filter Descriptions
| Filter | Description | Related Documentation |
|---|---|---|
| Agent | The agent associated with the costing. | Costing > Supplier |
| Brand | The brand associated with the style. | Site Settings > Style > Brand |
| Collection | The seasonal or thematic grouping the style belongs to. | Site Settings > Style > Collection |
| Customer | The customer or retail channel for the costing. | Site Settings > Company > Customer |
| Department | The department responsible for the style. | Site Settings > Order > Department |
| Designer | The designer who created the style. | Site Settings > Company > Staff |
| Factory | The factory associated with the supplier quote. | Costing > Supplier |
| License | The licensing agreement related to the style. | Site Settings > Style > License |
| Season | The fashion season the style belongs to. | Site Settings > Style > Season |
| Status | The current status of the costing. | Costing > Side Widgets > Status |
| Story | The design concept or theme associated with the style. | Site Settings > Style > Story |
| Type | The costing type (Retail, Import, or Component). | Costing Types |
Report Features
- Filter by multiple criteria to narrow down range sign off data
- Sort by any column in ascending or descending order
- Customise column visibility
- Export to Excel
- View detailed costing and range information
- Enable or disable visibility
- Interactive sign off actions