Revenue by Department — where the sales come from

Splits your period sales across departments — Front Desk, Bar, Kitchen, Housekeeping, whatever your setup has — with Gross, Discount, Tax, and Net side by side. A % share column on the right shows each department's contribution to total Net revenue.

Use it to answer "which parts of the business paid the rent this month?" and to spot departments where the discount rate is heavier than expected.

Before you start

• You need Ledger Reports permission (same access as General Ledger and Day Book).
• The report groups invoices by their Selling Department (the department that made the sale, from the invoice header).
• Every invoice needs a Selling Department set at save time. If any don't, they roll up as (unassigned) in an amber-tagged row so they're not silently dropped.
• Totals here match the P&L's Revenue section for the same date range (Net column ties to P&L Revenue).

Steps

1. Open Reports → Revenue by Department.
2. Pick a From / To date. Defaults to the last month.
3. Read left-to-right:
   • Invoices — how many the department raised.
   • Gross — total customer paid, before anything.
   • Discount — total of Invoice.DiscountAmount in this dept.
   • Tax — total tax on invoices in this dept (pass-through, not income).
   • Net — Gross − Discount − Tax; the real top-line contribution.
   • Share — Net ÷ Total Net, as a percentage.
4. Rows sort by Net biggest-first, so your top earners are always at the top.
5. Export → Excel for management pack or budget-variance analysis.

Tips

• A department showing high Discount relative to Gross is often running promotions or has a lot of complimentary comps — worth checking if the promo has been going on too long.
• (unassigned) — invoices with no Selling Department. Usually the fix is to add a Selling Department default on the POS Settings / Preferences page.
• Compare month-over-month by running the report twice with the same export column names — the sort naturally shows movers.

Common problems

• Totals don't match the P&L — Revenue on the P&L is the Net column here. Any discrepancy usually comes from voided invoices that were posted then reversed but still count in InvoiceCount; check Invoice Audit Trail for the period.
• All revenue is in "(unassigned)" — no invoices in the period had a Selling Department. Ensure POS Settings has a default set, and Invoice edit forms enforce the field for hand-keyed invoices.
• A department is missing entirely — the report only shows departments with at least one invoice in the period. A quiet department drops off; that's by design (keeps the grid tight).