Solavel Docs
English

I run two showrooms. How do I track sales and expenses by branch and see profit per branch?

Last updated

App: SolaCount. Outcome: every invoice and bill is tagged with its showroom, and reports show revenue, expenses and profit for Dubai and Sharjah separately.

#The situation

Palm Grove Furnishings LLC runs two showrooms, Dubai and Sharjah, from one SolaCount organization and one chart of accounts. The owner wants to know in October 2026 which showroom earns money. Rent and utilities are billed per showroom; fit-out services are invoiced to Bayside Café's two cafés. This practice case uses service lines and account lines only, in AED, and excludes tax to keep the numbers short. Configure VAT as usual on real documents.

#Desired result

October 2026 Dubai Sharjah
Revenue 10,000 6,000
Expenses 4,600 3,400
Profit 5,400 2,600

#Before you start

  • Dimensions are part of the Professional plan and above (feature Reporting Dimensions). Without it the pages and report cards below do not open.
  • Layla Haddad (accountant) needs dimensions.assign to tag lines when she saves a document. Mona Fares (finance manager) needs dimensions.manage to set up the dimension and dimensions.view and reports.view to open the reports.
  • Use one dimension for the branch. A dimension called Branch is a reporting tag; it never creates or changes accounts.

#Workflow overview

Create the Branch dimension and its two values once. Optionally require it on the revenue and expense accounts so nobody can post without it. Choose the branch in the document header on every invoice and bill. Month end: run P&L by Dimension, grouped by Branch. It shows Revenue, Expenses and Profit for each branch.

#Exact steps

#1. Create the dimension and its values

  1. Open Settings → Accounting & Tax → Dimensions.
  2. In Create dimension type enter Name Branch. Leave Allow multiple values per line unticked, so each line belongs to exactly one branch. Click Create.
  3. In the Branch card, under Values, type New value name Dubai and click Add Value. Repeat for Sharjah. The optional code field next to the name is a short code for your own use.
  4. The card shows Single-value only and the status Active. Use Deactivate on the card or on a value to stop offering it on new documents; Activate brings it back.
  1. In the Branch card, expand Settings, required accounts and import / export.
  2. Under Required accounts pick an account, for example Service Revenue, and click Require. Repeat for each revenue and expense account you use in the showrooms (Rent, Utilities, and so on). Remove deletes a rule.
  3. From now on a line posted to those accounts without a Branch is refused with "Missing required dimensions: Branch." or, on a document line, "a dimension required for this account would be left empty. Select a value for it."

#3. Tag a sales invoice

  1. Open Sales → Invoices → New Invoice and choose Bayside Café.
  2. In the header, next to Project, the Branch field shows — None —. Choose Dubai. This sets Dubai on every line, and any line you add later starts with Dubai too.
  3. Add the lines: Fit-out service, Dubai showroom, 1 × 10,000. Save and post as usual.
  4. Create a second invoice for the Sharjah café: header Branch → Sharjah, one line of 6,000.

#4. Tag the bills

  1. Open Purchases → Bills and click New Bill. Choose the supplier and set Branch → Dubai in the header.
  2. Use Account lines: Rent 4,000 and Utilities 600. Both inherit Dubai. Save and post.
  3. Repeat for Sharjah: Branch → Sharjah, Rent 3,000 and Utilities 400.

Expenses and sales receipts work the same way. A manual journal has no header field: pick the Branch on each line instead (see the line field below).

#5. When one document has lines for both branches

If a single invoice or bill covers both showrooms, set each line on its own. Click the small sitemap icon at the end of the line (tooltip Project & dimensions; Allocation assigned once something is set) to open that line's allocation row and pick the Branch. A header that shows different values across lines reads Mixed (per line). Choosing a value in the header again overwrites every line. For splitting one cost, see Split a shared expense between branches.

#6. Read the reports

  1. Open Reports → Business Overview → P&L by Dimension. (Reports → Purchases → Revenue by Dimension and Expenses by Dimension show one side only.)
  2. Set the dates From 1 October and To 31 October 2026.
  3. Open Group by, tick Branch (a report can group by at most two dimensions), and click Apply.
  4. Each branch row shows Revenue, Expenses and Profit, and the headline is Net Profit: Dubai 10,000 / 4,600 / 5,400 and Sharjah 6,000 / 3,400 / 2,600. A loss shows as a negative number.
  5. The grand total, including any Unassigned row, equals the net profit of the standard Profit & Loss report for the same dates.

The report shows a summary by branch, the total, and a Transaction details table (the latest 300 lines) with the date, journal, account, amount and the dimension labels. PDF, Print and Excel buttons export the same view. Under Group by you can also choose a second dimension (for example Department): the report then shows a matrix with row and column totals.

To look at one branch only, tick Branch under Group by, then open the Branch filter that appears and select Dubai. Use the Accounts filter to narrow to specific accounts, for example only Rent.

#Check your result

Check Expected
P&L by Dimension, group by Branch Dubai 10,000 / 4,600 / 5,400, Sharjah 6,000 / 3,400 / 2,600
Net Profit (grand total) 8,000, the same as the Profit & Loss net profit for the same dates
An Unassigned row Absent. If it appears, some posted lines have no Branch; its profit is still part of the grand total

Compare the grand total with the standard Profit & Loss for the same period. If a figure sits under Unassigned, find those lines in the transaction details and correct them (see below).

#How the report reads

P&L by Dimension shows, for each branch, Revenue, Expenses and Profit (revenue minus expenses). A loss is a negative profit. If a line carries several values of a multi-value dimension, it counts 1/n under each value, so the grand total is never counted twice. The report only counts posted journals in the dates you choose; drafts, voided documents and year-end closing entries are excluded.

#Common mistakes

  • Tagging only the header for a mixed document. A line you changed individually keeps its own value; check the header reads one branch, not Mixed (per line).
  • Allowing several values per line for Branch. A line with two branch values is split equally between them (1/n under each), which is rarely what a branch report needs. Keep Branch single-value and split the amount into lines instead.
  • Editing a posted document's branch. On a posted invoice or bill the header field is locked. Use the posted-document line review (Review line projects, divisions and dimensions), which re-tags lines without changing any amount, quantity or tax. Some lines, such as stock lines and tax legs, cannot be re-tagged this way; the page explains why and what to do instead. See Posted corrections.
  • Adding the dimension after the fact. Documents already posted keep the tags they had. Start tagging from the first day of the period you want to report.
  • Stock items. This case uses service and account lines. When you sell stock items on an invoice or sales receipt, the cost of goods sold and inventory lines keep the sales line's branch tag, and the same item on two lines for two branches is kept separate. With SolaStock connected, cost of sales is posted from the stock shipment. Those COGS and inventory lines take the branch of the invoice lines the shipment fulfils, and a SolaStock return takes the branch of the credit or invoice line. When one shipment or return covers lines from different branches, each branch receives its line's actual stock cost. A SolaStock shipment or return journal posted before this update reached SolaCount (the evening of 20 November 2026) keeps no branch, appears under Unassigned and is not changed automatically. A review of all customer companies found no tagged stock sales before the update, so no customer history is affected; only internal test entries were posted earlier.

Split a shared expense between branches, Dimensions & custom fields, Invoices, Bills, Expenses, Reports, Business Solutions & Examples.