Solavel Docs
English

One expense is shared between branches. How do I split it on one bill?

Last updated

App: SolaCount. Outcome: one supplier bill, one payable and one payment, with the cost divided between Dubai and Sharjah in the branch reports.

#The situation

Harbor Point Properties sends one rent bill of AED 12,000 plus 5% VAT for the building that houses both Palm Grove Furnishings LLC showrooms. The accountant wants Dubai to carry 60% (it uses more floor area) and Sharjah 40%. The supplier is paid once. In October the same approach is used for a shared AED 1,000 marketing invoice split 50 / 50.

#Desired result

Dubai (60%) Sharjah (40%) Total
Rent before VAT 7,200 4,800 12,000
VAT 5% 360 240 600
Bill total 7,560 5,040 12,600

Branch reports show Dubai rent 7,200 and Sharjah rent 4,800. The payable to Harbor Point Properties is a single 12,600.

#Before you start

  • The Branch dimension exists with the values Dubai and Sharjah (see step 1 of the branch profit guide). Keep it Single-value only.
  • Layla Haddad needs dimensions.assign to save tagged lines. Plan: Professional or above.
  • There is no percentage or automatic split in the product. You divide the amount yourself and enter one line per branch. Work out the amounts first: 12,000 x 60% = 7,200 and 12,000 x 40% = 4,800.

#Workflow overview

Create the bill with one Account line per branch, each with its own amount and its own Branch. Post once. The bill stays a single document and a single payable; only the reporting lines are divided.

#Exact steps

  1. Open Purchases → Bills and click New Bill. Choose Harbor Point Properties, enter the supplier's Number and the dates.
  2. In Line Items add a first line with Type → Account, account Rent, description Rent October 2026 - Dubai 60%, Qty 1, Price 7,200, Tax VAT 5%.
  3. Add a second Account line, account Rent, description Rent October 2026 - Sharjah 40%, Qty 1, Price 4,800, Tax VAT 5%.
  4. Set the branch on each line. Click the sitemap icon at the end of line 1 (tooltip Project & dimensions), and choose Branch → Dubai. Do the same on line 2 with Sharjah. The header Branch field now reads Mixed (per line).
  5. Check the totals at the bottom: subtotal 12,000, VAT 600, total 12,600. Compare with the supplier's paper bill before posting.
  6. Click Save & Post.

If the organization has more than two dimensions, the header shows one compact Dimensions field (for example Branch: Mixed (per line) · 1 more). Click it to open a small panel with one select per dimension. The line allocation row still lists every dimension.

#Splitting into more than two parts

Add a line per branch or cost centre. To divide an amount that does not split evenly, calculate every part but the last, and make the last line the remainder, so the parts add up exactly. Example: 1,000 split three ways is 333.33, 333.33 and 333.34.

#Rounding and VAT

VAT is calculated on each line. With lines of 7,200 and 4,800 the VAT lines are 360 and 240 and add to exactly 600. With awkward percentages, compare the bill total with the supplier's total and adjust the last line before posting. For supplier invoices that must match to the fils, tick Match supplier invoice under the lines and enter the supplier's total and VAT (see Supplier invoice matching).

#A different dimension, such as department

If the same cost must also be tagged with another dimension, for example Department = Admin, pick it in the same line allocation row. Each line carries its own value for every dimension, so the 7,200 line can be Dubai and Admin while the 4,800 line is Sharjah and Admin.

#Check your result

  1. Open the posted bill. It shows two lines, a subtotal of 12,000, VAT 600 and a Balance Due of 12,600.
  2. Open Reports → Purchases → Expenses by Dimension, dates covering the bill, Group by → Branch, and Apply. Dubai includes 7,200 and Sharjah 4,800 from this bill. In Transaction details each line shows its own dimension label.
  3. Record one payment of 12,600 to Harbor Point Properties. The branch reports do not change when you pay, because they read the expense lines and not the cash.

#Shared costs without a supplier bill

  • Direct expense: an expense has the same lines and the same branch controls; use it when you paid immediately.
  • Already posted to one branch by mistake: post a manual journal moving the amount. Debit Rent with Branch Sharjah 4,800 and credit Rent with Branch Dubai 4,800; each journal line has its own Dimensions picker. Reverse or correct the original with the normal posted-document route if it should not stay.
  • Same split every month: create a recurring bill, or clone the posted bill and change only the dates and amounts. Copies keep the line values.

#Common mistakes

  • Entering the full 12,000 on both lines. The bill total and the payable double. Always compare the bill total with the supplier's document.
  • Using Allow multiple values per line to share a cost. Ticking both branches on one line does not divide the amount; the whole line counts under each branch in a report. Divide into lines instead.
  • Leaving the header on Dubai after changing the second line. The header should read Mixed (per line). If you choose a value in the header afterwards, it replaces every line.
  • Splitting the VAT by hand on the wrong account. Do not add a separate VAT line; use the Tax column on each rent line so VAT is posted correctly.
  • Expecting reports to split posted documents later. To re-tag a posted bill without changing amounts, use the posted-document line review; see Posted corrections. It re-tags existing lines, so it cannot divide one line into two. For that, correct the bill through the normal posted-document route.

Profit by branch, Dimensions & custom fields, Bills, Expenses, Journals, Recurring, Business Solutions & Examples.