Invoice History
The Invoice History data model combines invoice level transactions with customer, salesperson, and product details to give a complete view of your sales activity. It includes measures like sales amount, cost of sales, profit amount, unit price, unit cost, and quantities for ordered, shipped, backordered, and on hand, along with prior year comparisons to track performance over time. Use it for sales reporting, profitability analysis, and monitoring trends across customers, products, and salespeople.
How to use this data model
- Identify top customers by purchase volume and how their buying patterns change over time.
- Measure salesperson performance by comparing revenue across the team for commission reviews.
- Track profitability trends by comparing sales against costs month over month to catch margin changes early.
- Analyze product mix to see which products and product lines generate the most sales for inventory planning.
- Review regional performance with the Sales Map USA view to compare sales by state for territory planning.
Available views
| View | Type | What it shows |
|---|---|---|
| Sales by Customer | Worksheet | Breaks down sales by customer account with revenue, costs, and profitability, making it easy to review accounts and spot changes in buying patterns. |
| Top 10 Customers | Funnel | Ranks customers by total revenue from highest to lowest. |
| Sales by Salesperson | Worksheet | Shows full sales activity by salesperson with revenue, margin, and quantity metrics for commission reviews and performance tracking. |
| Top 5 Salespersons | Horizontal Bar | Ranks the top 5 salespeople by revenue for a quick performance overview. |
| Sales Map USA | Map | Shows sales by state on a US map, making it easy to compare regional performance and spot coverage gaps. |
| Top 5 Products Sold | Doughnut | Shows the 5 best selling products by sales volume. |
| Monthly Sales vs. Costs | Line | Compares monthly sales against costs over time, showing how margins evolve month to month. |
| Top 5 Product Lines Sold | Doughnut | Shows the 5 top performing product lines by sales volume. |
| Sales by Year | Vertical Bar | Shows total sales by year for long term trend analysis. |
| Quarterly Sales and Profits | Combination | Compares sales and profit side by side each quarter, showing how profitability tracks against revenue over time. |