T
TrueColorOnline report

Uploads and checks

Upload each report once per quarter. The dashboard recalculates and checks every number.

Drag and drop reports here
CSV, XLSX or tab-separated files from QuickBooks, Shopify, Faire and Google Ads (Google exports are UTF-16)
Reports
The dashboard recognizes each file by its columns
ReportFileStatus
Profit and Loss by month (accrual)QuickBooksQB_PL_Q3_2026.CSVReady
P&L filtered to ONLINE SALES 0001QuickBooksQB_PL_CUSTOM_FILTER.CSVReady
Sales by Customer SummaryQuickBooksQB_SALES_CUSTOMER_SUM.CSVReady
Inventory Valuation (Jun 30, Sep 30)QuickBooksTyped inManual
Total sales by sales channelShopifyTotal_sales_by_sales_channel.csvReady
Billing charges exportShopifycharges_export.csvReady
Performance by marketing channelShopify3 monthly filesReady
Payouts summaryFairefaire-payouts-summary.csvReady
Campaign report (all campaigns)Google AdsCampaign_report.csvReady
Billing summaryGoogle AdsTyped inManual
Checks
Run automatically after every upload
  • Model ties to QuickBooks to the centPass
  • Campaign total equals Google account totalPass
  • Faire: 80 Shopify orders = 77 paid + 3 unpaidPass
  • Online sales match Shopify within $1,107Pass
  • Google cost is $1,374 above QuickBooks (payments booked a month late)Review
  • Freelancer fee not entered yetReview
  • Card terminal fees counted as online (cautious setting)Setting

Last upload: October 6, 2026