Consolidated reporting across the holding

What this does

Consolidated reports combine financial and operational data from all product lines under your company into a single view. Instead of switching between product lines to check each one's performance, you can see the entire company's revenue, expenses, and inventory in one report.

Before you start

• You must have permission to view reports. Ask your administrator if you cannot access the Reports menu.
• Your company must have at least two product lines set up.
• All product lines must have current, valid data (recent transactions and inventory).
• For financial reports, the chart of accounts should be standardized across product lines so accounts match (e.g., account 400 is "Sales Revenue" everywhere).

How consolidated reports work

When you run a consolidated report:

1. The system scans all product lines under your company.
2. It pulls matching data (invoices, inventory, journal entries) from each product line.
3. It combines the data—for example, totals revenue from the pharmacy plus revenue from the clinic.
4. It displays the result in one report table or chart.
5. You can filter, sort, and export the consolidated data just like a single-product-line report.

Types of consolidated reports available

The exact reports available depend on your system configuration. Common consolidated reports include:

• Consolidated Profit & Loss: total revenue and expenses across all product lines.
• Consolidated Balance Sheet: total assets, liabilities, and equity for the entire company.
• Consolidated Cash Flow: cash inflows and outflows across all operations.
• Consolidated Sales Summary: gross sales by product line and by product type.
• Consolidated Inventory Value: total inventory value across all warehouses and product lines.
• Consolidated Aged Receivables: customers who owe money, summed across all product lines.
• Consolidated Aged Payables: vendors you owe money to, summed across all product lines.

Steps to run a consolidated report

1. Go to Reports in the top navigation menu.

   Open in Usystems

2. Look for a Consolidated Reports section or a Company-wide filter option.

3. Select the report type you need (e.g., "Consolidated Profit & Loss").

4. (Optional) Set a date range to limit the report to a specific period—for example, "January 1 to December 31, 2026."

5. (Optional) Choose a currency for the report (if your company uses multiple currencies). The system will convert all transactions to that currency at the applicable exchange rate.

6. Click Generate or Run Report to produce the report.

7. The report displays on screen. You can:

   • Print it by clicking the print button and saving as PDF.
   • Export it to Excel or CSV for further analysis.
   • Filter the data by clicking column headers.
   • Drill down into individual transactions by clicking row details (if available).

Reading a consolidated report

When you see a consolidated report:

• Header section: shows the report title, date range, and the company name.
• Summary line or panel: may show totals (e.g., "Total Revenue: 500,000 AFN").
• By-product-line breakdown: often a table or section showing each product line's contribution separately, so you can spot which product line is performing best.
• Detailed rows: individual line items (if not summarized) showing transactions, accounts, or inventory items.

Accounting impact

Consolidated reports are read-only. They do not create journal entries or change your data. They are a way to view your company's financial position across all product lines. If you need to adjust the financial records, you must return to the individual product line and edit the underlying transactions.

Tips & common mistakes

• Check the date range: consolidated reports often default to a date range (e.g., the current month). Make sure the range matches what you need—if you want a full-year report, explicitly set January 1 to December 31.
• Exchange rates matter: if your company uses multiple currencies, consolidated reports convert all amounts to a single reporting currency. Make sure the exchange rates are up-to-date, or the totals may be inaccurate.
• Product lines must have matching accounts: if one product line uses account 400 for "Sales Revenue" and another uses account 401 for the same thing, consolidated reports may show them separately. Ask your administrator to standardize account usage.
• Drill-down limitations: some consolidated reports summarize so heavily that you cannot drill down to the original transaction. If you need details, switch to the individual product line and run a single-product report.
• Performance comparison: consolidated reports are great for spotting trends (e.g., "the pharmacy is growing 20% faster than the clinic"). Use this to guide business decisions.
• Regulatory compliance: if you need to file consolidated financial statements to a regulator, ask your administrator about report certification and audit trails.