Solavel Docs
English

How do I analyse sales by channel and branch at the same time?

Last updated

App: SolaCount. Outcome: one report shows revenue for every combination of sales channel and branch, such as Online in Sharjah or B2B projects in Dubai.

#The situation

Palm Grove Furnishings LLC sells in three ways: from the Showroom, through its Online shop and as B2B projects (for customers such as Bayside Café). It has two branches, Dubai and Sharjah. Mona Fares (finance manager) wants October 2026 revenue by channel and by branch in one table. This is a separate practice case: AED, amounts exclude VAT.

#Why two dimensions

A dimension tags each line with one value. Two dimensions give two independent tags on the same line: Branch answers "where", Sales channel answers "how". The report can group by both at once. Do not build one dimension with six combined values such as "Dubai – Online": you could not then total a channel across branches.

#What you need first

  • Dimensions need the plan feature; check Settings → Dimensions exists.
  • dimensions.manage to create the dimensions, dimensions.assign to tag documents, dimensions.view to open reports.
  • A Branch dimension may already exist. Do not create a duplicate; add the missing values to the existing one.

#Steps

  1. Open Settings → Dimensions. Create Branch (values Dubai, Sharjah) if it is not there. Keep Allow multiple values per line off.
  2. Create Sales channel with values Showroom, Online and B2B projects. Keep multiple values off.
  3. Under Required Accounts for each dimension, choose the sales (revenue) account and click Require, so an invoice cannot post without both tags. Add the discount account too if you use sales discounts, because discount lines carry the same tags.
  4. Tag every sales document:
    • Walk-in sale: a sales receipt, Branch = Dubai, Sales channel = Showroom.
    • Online order invoice: Branch = Sharjah, Sales channel = Online.
    • Project invoice: Branch = Dubai, Sales channel = B2B projects. With one or two dimensions the document header shows each as its own field beside Project; with three or more they collapse into one Dimensions field that opens a small panel.
  5. When one invoice mixes channels, set Branch once in the header, then open each line's allocation control and set Sales channel per line. The header then reads Mixed (per line) for Sales channel. For example, an AED 5,000 invoice with a 2,000 line collected from the showroom and a 3,000 project line: Dubai on both, Showroom on the first, B2B projects on the second.
  6. Post the documents. Tags are copied to the posted revenue lines.
  7. Open Reports → Purchases → Revenue by Dimension. The report's name sits under Purchases in the report list, but it reads revenue accounts. Set From 1 October 2026 and To 31 October 2026. In Group By, choose Branch and Sales channel (the maximum is two). Click Apply.

#Worked numbers

October revenue, AED. The Summary Matrix shows rows for the first dimension in the list and columns for the second.

Branch Showroom Online B2B projects Row Total
Dubai 42,000 18,500 30,000 90,500
Sharjah 25,000 9,500 12,000 46,500
Column total 67,000 28,000 42,000 137,000

Read it as: Dubai brings 66% of revenue (90,500 of 137,000); the Showroom is the largest channel (67,000, 49%); Online is smallest in both branches. Change Group By to Sales channel only for a one-line-per-channel summary, or tick a value in the dimension's filter to drill in (the value filter appears for each dimension you group by). For example, group by Branch and filter Sales channel to Online to see only online sales by branch: Dubai 18,500, Sharjah 9,500.

#What to check

  • The report total equals the sales revenue for the period in your income statement (Reports → Business Overview), allowing for other-income accounts, which this report also includes.
  • No Unassigned row. If one appears, some revenue lines were posted without a tag, usually before the Required Accounts rule existed.
  • Revenue by Dimension counts posted revenue in base currency. Drafts, voided entries and VAT are excluded.
  • Credit notes: the sales return, discount, VAT and restock lines keep the tags of the original invoice line, so the channel's revenue is reduced where the sale was made. Tags you choose explicitly on the credit line win. If two lines of the invoice have the same item and price but different tags, SolaCount cannot tell which one is returned: tag the credit line yourself, otherwise it stays untagged.

#Common variations

  • Add costs and profit. Run Reports → Business Overview → P&L by Dimension with the same grouping. Each branch and channel shows Revenue, Expenses and Profit, and the headline is Net Profit. Costs only appear in the right cell if the bills and expenses were tagged. The automatic cost-of-sales and inventory lines posted with a stock invoice or sales receipt keep the sales line's tags, so stock margins land in the right branch and channel.
  • One-off analysis. Use the Accounts filter to compare only one revenue account (for example fit-out services) across channels.

#Mistakes to avoid

  • Allowing multiple values per line on either dimension. One line is then split equally (1/n) under each chosen value in the grouped report.
  • Tagging only the header on a mixed invoice and forgetting the line that differs. Check for Mixed (per line) before posting.
  • Adding a third dimension to Group By. The report keeps only two.
  • Reading Unassigned as zero. It holds untagged revenue and must be explained.
  • Editing tags on posted documents expecting history to move. Posted documents keep their original tags.

Dimensions & custom fields, Invoices, Sales receipts, Credit notes, Sales reports, Track costs by department and compare with a budget, Business Solutions & Examples.