Overview

The Accounting Performance Dashboard provides a complete view of financial performance and data accuracy for a selected period. It helps accountants and managers review revenue, cost of goods sold (COGS), inventory value, and identify any issues that may impact month-end close.

This dashboard is designed to answer two key questions:

  • What happened this month financially?
  • Can these numbers be trusted for closing the books?

Who this is for

  • Accountants responsible for month-end close
  • Owners and managers reviewing business performance

Access the Accounting Performance Dashboard

  1. Go to Insights > Accounting
  2. Select Close the Books
  3. Choose the period with This month, Last month, or Custom (the Close through month)

Review Month-End Summary

The top banner provides a quick snapshot of close readiness:

  • Date Range – Selected reporting period
  • Close Status – Ready, Not Ready, or Ready with Warnings
  • Sales Orders Missing COGS – Orders that may impact accuracy
  • Large Variances – Detected inconsistencies in financial data
  • Last Updated – Most recent data sync

image.png

Use this section to quickly assess whether the books are ready to close.

Understanding Status Indicators

  • Green checkmark – Check has passed
  • Red warning / BLOCKING – Issue must be resolved before closing
  • Progress indicator (e.g., 18/20 checks passed) – Shows overall readiness

If any section shows “Not Ready to Close”, at least one blocking issue remains.

Analyze Financial Performance

The Financial Snapshot highlights key metrics:

  • Total Revenue
  • Total COGS (with link to detailed report)
  • Gross Profit
  • Gross Margin %

Additional metrics may include:

  • Returns and refunds
  • Discounts applied
  • Ending inventory value
  • Inventory turnover

These metrics help evaluate profitability and overall performance.

Review Sales & Channel Performance

Understand how sales are distributed across channels:

Key metrics:

  • Total Net Revenue
  • Sales Count
  • Units Sold
  • Average Order Value (AOV)

Sales by Channel:

  • Shopify
  • Amazon
  • B2B / Wholesale

Each channel includes revenue, order volume, units sold, and AOV to compare performance.

Evaluate Returns, Refunds, and Discounts

This section highlights factors that impact margins:

  • Returns (count and percentage)
  • Returned COGS
  • Refunds (value and percentage)
  • Discounts Given

Use this data to understand revenue adjustments and margin changes.

Review Inventory & Fulfillment

Monitor inventory value and operational performance:

Inventory Metrics:

  • Ending Inventory Value
  • SKUs in Stock
  • Units in Stock
  • Inventory Turnover
  • Deadstock Value

Inventory Reconciliation:

  • Starting Value
  • COGS
  • Receipts
  • Adjustments
  • Ending Value

This ensures inventory balances match financial records.

Fulfillment Metrics:

  • Orders Received vs. Shipped
  • Unfulfilled Orders
  • Average Shipping Cost (if available)
  • Average Fulfillment Time

Identify Data Issues & Close Readiness

The dashboard highlights issues that may affect reporting accuracy:

  • Missing or incomplete data (e.g., orders without COGS)
  • Inventory discrepancies
  • Large financial variances

Each issue includes a link to investigate and resolve it.

Order Integrity

Validates that all sales order data is complete and accurate:

  • No unposted orders
  • No unmapped items
  • No zero-cost sale items
  • No negative quantity cancellations

How to fix the identified issues (highlighted in RED) in Order Integrity

  1. Click the field highlighted in red to view all SKUs that require correction.

Note: There should be either Estimated Landed cost or Cost Layer associated in your SKU to fix this error.

image.png

  1. Select SKUs to Fix

    • Tick the checkbox beside the SKUs to select SKU or tick multiple checkboxes to fix multiple SKU at once

  2. Choose a Fix Method
    There are two available options:

    Option 1: Use ELC (Estimated Landed Cost)

    • Refer to the Suggested ELC column
    • Refer to the displayed value to update the SKU

    Option 2: Use cost layer (Recommended)

    • Refer to the Suggested Cost Layer column
    • Refer to the indicated amount to correct the SKU

image.png

  1. Once you select the fix method, a pop up window will appear to confirm your action.

Inventory Integrity

Ensures inventory data is accurate:

  • No negative on-hand inventory
  • All SKUs have valid inventory valuation

How to fix Inventory Integrity Accuracy

Option 1: Fix Inventory Per SKU

  1. Navigate to the SKU with an error
  2. Click the SKU to open the SKU Details Page
  3. Click Edit
  4. Locate the Estimated Landed Cost (ELC) field
  5. Enter the correct value
  6. Click Save

Repeat this process for each affected SKU.

Option 2: Bulk Fix via Export & Import

Step 1: Export Products with Errors

  1. Go to the Close the Books page
  2. Click Export CSV
  3. Download the file containing all SKUs with errors

Step 2: Update the File

  1. Open the file in Excel
  2. Locate the Estimated Landed Cost column
  3. Enter the correct values for each SKU
  4. Save the file as .xlsx

Step 3: Import Updated File

  1. Return to the Close the Books page
  2. Ensure that you indicate the date rage before importing a file or your import will fail

    1. Apply SKU Costs to Period:

      • Each row maps a SKU to a unit cost
      • All sales items with that SKU and order date in the range will be updated
      • Cost = quantity × unit cost per line
      • Both from_date and to_date are required

      image.png

  3. Click Import Costs (under the SKUs with zero valuation check)
  4. Upload the updated .xlsx file

Step 4: Map Fields

  1. Map the following fields:

    • SKU → Master SKU
    • Estimated Landed Cost → Unit Cost

    image.png

  2. Click Next

Step 5: Review and Import

  1. Review for any errors
  2. Make corrections if needed
  3. Click Import to finalize

image.png

Accounts Payable

Confirms vendor-related financial data is complete:

  • No unposted bills
  • No open bill variances
  • All posted bills reconciled
  • No bills on hold
  • No uninvoiced receipts (GR/IR)
  • No unapplied vendor credits or prepayments
  • No QuickBooks sync errors

Sync & Integration Health

  • All channels syncing
  • No invoice sync errors
  • No failed webhooks

Invoice & Shipment Integrity

  • No partially invoiced shipped orders
  • No over-invoiced orders
  • No over-shipped orders

Tips & Best Practices

  • Review this dashboard before closing the books each month
  • Resolve all blocking issues before finalizing financials
  • Use drill-down links to validate key numbers
  • Pay close attention to missing COGS and inventory discrepancies

FAQs

Q: Why are my COGS incomplete?
A: Some sales orders may be missing cost data. Use the provided link to review and update affected orders.

Q: Can the dashboard be used for forecasting?
A: No. This dashboard is designed for financial review and close, not inventory planning or forecasting.

Q: Why don’t my numbers match external reports?
A: Check for missing data, sync delays, or unposted transactions that may impact totals.

Q: Upon import, it says there are no order on that date range for that SKU. What should I do?

A: Click the the download button, it will only download what is missing or SKU that has an error. Go back to the "Select a file" step and change the date range.

Need help?

Contact the support team for further assistance.