Report — Doanh thu (Rental Revenue)

Report — Doanh thu (Rental Revenue)

Chi tiết trang này: chỉ Rental Revenue Report. Overview đã có ở Báo cáo doanh thu Phần 4.

Menu

Báo cáo → Rental Revenue Report

Nguồn dữ liệu

• account.move type = out_invoice (KH invoices)
• State = posted (không draft, không cancelled)
• Có x_zone_contract_id != null (linked with Parkone contract, không phải HĐ bán hàng khác)
• Credit Notes (refunds) trừ negative

Filter options

Time period

• Date range: start_date → end_date
• Preset: This month / This quarter / This year / YTD

KCN

• Multi-select projects
• Default: All

Loại HĐ

• Lease land / RBF / Warehouse / Yard / Office / Cold storage

Khách hàng (partner)

• Specific KH (filter drill-down)
• FDI vs DDI (theo x_company_type)

State Invoice

• Posted (any payment state)
• Paid only (thu về thực tế)
• Overdue (đã post nhưng chưa trả)

View modes

List (default)

Table 10 columns:

• KCN, KH, Số HĐ, Số Invoice, Ngày Invoice, Amount untaxed, VAT, Total, Paid, Residual

Sort mọi column, filter search bar.

Pivot

Matrix:

• Rows: KCN × KH
• Columns: Tháng
• Cells: Revenue amount

Best cho MoM trends per KCN.

Graph

Bar chart / Line chart:

• Bar: Revenue per tháng
• Stack by: KCN / Lease type / Currency
• Line: Trend over time

Visual identify seasonality + growth.

Metrics quan trọng

Booked Revenue

• Sum Invoice posted trong period
• Không care KH đã trả chưa

Collected Revenue

• Sum Payment received trong period
• Cash-flow perspective

Difference = AR outstanding.

Revenue by lease type

• Lease land: 80%
• RBF: 15%
• Warehouse: 5%

Compare mix → decide investment focus.

Growth rate

• MoM: This month vs last month
• YoY: This year vs last year same month

Metric quan trọng cho CEO/Board.

Export options

• Excel (.xlsx) — full data, formulas
• CSV — raw data cho analysis Python/R
• PDF — branded report cho Board meeting

Attach vào Chatter của Company hoặc email Board.

Automation

Cron monthly (cuối mỗi tháng):

• Auto-generate revenue report month qua
• Save as PDF into shared drive
• Email Board members

Setup: Cấu hình → Technical → Scheduled Actions → Monthly Revenue Report.

Segment analysis

Filter theo:

• Top 20% KH → Pareto rule (thường 80% revenue từ 20% KH)
• Long-term (>10y contract) vs short-term
• FDI vs DDI

Identify:

• Concentration risk (nếu 1 KH > 30% revenue → risky)
• Customer segment profitable nhất
• Contract types under-performing

Forecast

Report show actual. Forecast dùng riêng:

• Cash Flow Forecast (từ Wizard Sinh lịch HĐ)
• Sum forecast 12 tháng tới
• Compare vs Actual để identify variance

FAQ

Doanh thu report khác doanh thu bank statement?

• Report = accrual (based on Invoice date)
• Bank = cash (based on payment date)

VN accounting thường dùng accrual → follow report.

Credit Notes ảnh hưởng report

Có. Credit Note → negative revenue → giảm total.

Filter “Exclude Credit Notes” nếu muốn gross revenue only.

Multi-currency

Nếu Đại có Invoice USD + VND:

• Report convert USD → VND theo tỷ giá Invoice date
• Show cả 2 currency columns nếu enable

Currency setup: Cấu hình → Kế toán → Currency Rates.

Sales rep dashboard

Sales rep muốn thấy chỉ HĐ của mình:

• Filter salesperson = me (auto apply nếu user không có full access)

Liên kết liên quan

• Executive Dashboard
• 5-tab charts
• Occupancy Report
• Wizard Sinh lịch HĐ