financial-reporting-dashboard

What this skill does

# Financial Reporting Dashboard

## Overview

A financial reporting dashboard consolidates your three core financial statements — P&L (Income Statement), Balance Sheet, and Cash Flow — into an interactive view that management, investors, and board members can navigate without requesting custom reports from finance.

For ecommerce businesses, the most valuable feature is drill-down: the ability to see total gross margin and then click through to gross margin by product category, channel, or geography. This transforms static financials into an investigation tool.

This skill guides you through connecting your accounting system to a dashboard layer, structuring the ecommerce-specific P&L, and building drill-down reports using your platform data.

## When to Use This Skill

- When your CFO or investors request monthly P&L and cash position reports
- When replacing manual spreadsheet-based financials with an automated dashboard
- When you need drill-down from consolidated totals to channel, product category, or SKU level
- When preparing for a board meeting, fundraise, or M&A process
- When your accounting system does not produce ecommerce-specific breakdowns
- When you need to reconcile revenue in your ecommerce platform against your GL

## Core Instructions

### Step 1: Connect your accounting system to your platform

A financial reporting dashboard must be built on your accounting system (QuickBooks, Xero, NetSuite), not on your ecommerce platform data alone. Platform revenue data diverges from GAAP financials due to recognition timing, payout lags, and adjustments.

**Ecommerce platform → accounting system integrations:**

| Ecommerce Platform | Accounting System | Recommended Integration |
|-------------------|------------------|------------------------|
| Shopify | QuickBooks Online | **A2X** (Shopify App Store) — reconciles Shopify payouts to period-matched QBO journal entries |
| Shopify | Xero | **A2X for Xero** — same; creates summary journal entries per payout period |
| Shopify | Both | **Finaloop** (Shopify App Store) — automated bookkeeping designed for Shopify; handles COGS, inventory, and financial statements |
| WooCommerce | QuickBooks Online | **WooCommerce QuickBooks plugin** (WooCommerce.com, $79/yr) |
| WooCommerce | Xero | **WooCommerce Xero extension** (WooCommerce.com, $79/yr) |
| BigCommerce | QuickBooks Online | **Webgility** (BigCommerce App Marketplace) |
| BigCommerce | Xero | **Amaka** (BigCommerce App Marketplace) |

**A2X setup for Shopify (most common workflow):**
1. Install A2X from the Shopify App Store
2. Connect A2X to your QuickBooks Online or Xero account
3. Map Shopify transaction types (sales, refunds, shipping, discounts, fees) to your chart of accounts
4. A2X creates one summary journal entry per Shopify payout period — matches what hits your bank account with the accounting entries

### Step 2: Structure the ecommerce P&L

The ecommerce P&L has a specific structure that differs from a generic income statement:

```
INCOME STATEMENT
─────────────────────────────────────────
Gross Revenue (total selling price × units)
  - Returns & Refunds
  - Discounts & Promotions
= Net Revenue

  - Cost of Goods Sold
    Product cost (weighted average or FIFO)
    Inbound freight & duties
= Gross Profit
  Gross Margin % = Gross Profit / Net Revenue × 100

Operating Expenses
  - Fulfillment & Shipping (outbound, 3PL)
  - Marketing & Advertising (Meta, Google, TikTok, email)
  - Technology & Platform fees (Shopify, apps, SaaS)
  - Customer Service payroll
  - G&A (salaries, rent, legal, accounting)
  - Depreciation & Amortization
= Total Operating Expenses

= EBITDA (Net Revenue - COGS - OpEx + D&A)
= EBIT  (Net Revenue - COGS - OpEx)

  Interest income / expense
  FX gains/losses
= EBT
  Income tax
= Net Income
```

**Set up chart of accounts in QuickBooks / Xero** with separate accounts for each ecommerce-specific line item. This is what enables channel and category drill-down later.

### Step 3: Build the financial reporting dashboard

---

#### Shopify

**Option A: QuickBooks Online Reporting (recommended starting point)**
1. Connect Shopify to QuickBooks via A2X (see Step 1)
2. In QuickBooks, go to **Reports → Profit and Loss** — generate monthly P&L with comparison to prior period or budget
3. Go to **Reports → Profit and Loss Detail** for transaction-level drill-down
4. For board reporting: use **QuickBooks Advanced** which provides customizable dashboards and scheduled report emails

**Option B: Xero Reporting**
1. In Xero, go to **Accounting → Reports → Profit and Loss** — configure date range, comparison period, and layout
2. Enable **Tracking Categories** in Xero (Settings → Advanced → Tracking Categories) — create categories for "Channel" (DTC, Amazon, Wholesale) and "Department" to get drill-down in P&L
3. Tag transactions by channel as they are entered; Xero P&L then shows margin by channel automatically

**Option C: Google Looker Studio (free, for visual dashboards)**
1. Connect QuickBooks or Xero to Google Sheets using **Coupler.io** or **G-Accon** (exports accounting data to Google Sheets on a schedule)
2. Build a Looker Studio report on top of the Google Sheet data: add scorecards for Net Revenue, Gross Margin %, and EBITDA; add a time-series chart for monthly P&L trend; add a bar chart for expense category breakdown
3. Share the Looker Studio URL with board members — auto-refreshes when the Google Sheet updates

**Option D: Finaloop (fully automated Shopify bookkeeping + reporting)**
1. Install **Finaloop** from the Shopify App Store
2. Finaloop handles all bookkeeping automatically: categorizes Shopify transactions, tracks COGS, and generates GAAP-ready P&L, balance sheet, and cash flow statements
3. Financial statements are available in the Finaloop dashboard and exportable to PDF; integrates with QuickBooks and Xero

---

#### WooCommerce

1. Connect WooCommerce to your accounting system (QuickBooks via the WooCommerce QuickBooks plugin or Xero via the Xero extension)
2. Use your accounting system's reporting (**QuickBooks Reports → P&L** or **Xero → Profit and Loss**) as the primary financial reporting layer
3. For WooCommerce-specific drill-down by product/category, use **Metorik** alongside your accounting system — Metorik provides product-level and category-level revenue and margin, while your accounting system provides the GAAP-accurate totals
4. For a unified view: export monthly P&L from QuickBooks/Xero to Google Sheets and export Metorik channel/product breakdown to a second sheet; build a Looker Studio dashboard that combines both

---

#### BigCommerce

1. Connect BigCommerce to accounting via **Webgility** (QuickBooks) or **Amaka** (Xero)
2. Use your accounting system for financial statements
3. **Glew.io** (BigCommerce App Marketplace) provides ecommerce-specific financial analytics including gross margin by product, channel, and customer segment — complement your accounting system's P&L with Glew's operational margin view

---

### Step 4: Add drill-down capabilities

The value of a financial reporting dashboard over static statements is drill-down. Set up these dimensions in your reporting:

**By channel (DTC vs. Amazon vs. Wholesale):**
- In QuickBooks: Use **Classes** (QuickBooks Advanced) to tag transactions by channel; run P&L by class
- In Xero: Use **Tracking Categories** as described above
- In Looker Studio: Add a channel filter that refreshes all charts based on the selected channel

**By product category:**
- Map your product categories to your accounting system's chart of accounts
- Alternatively, use your ecommerce platform's analytics (Shopify Analytics → Sales by product, Metorik → Products) for product-level margin, and your accounting system for company-level totals

**By time period:**
- All accounting systems support P&L comparison: current month vs. prior month, current month vs. prior year same month, YTD vs. prior YTD
- For trailing-12-month views and rolling period ana