Solavel Docs

Reports

Last updated

SolaCount reports turn your posted accounting into financial statements, sales and purchase analysis, receivables and payables aging, VAT and tax summaries, banking, project, budget, inventory and fixed-asset reports. Reports are read-only: they never change your books. Use this page to find the right report, understand what it shows, and export it.

Where to find it

  • Click Reports in the left rail. The Reports panel opens with a Search reports box and the report groups listed below.
  • Reports → Business Overview → Reports Overview opens the report center at /reports, which shows every report as a card.
  • Each report has its own URL under /reports/… (for example /reports/balance-sheet). You can bookmark or share a report URL, including its filters.

You need the View reports permission (reports.view). Individual reports also depend on your plan (see Rules, limits and permissions).

The report center

The report center (/reports) is a searchable catalog.

Control What it does
Search… box Filters cards by report name, category and common alternative names (for example typing "p&l" finds the Income Statement).
All / Active All shows every card; Active hides reports your plan does not include.
Category menu (filter icon) Shows one category only, with a count of reports in it.
Counters Number of reports Available, Premium (need a higher plan) and Coming soon.

Each card shows the report name and category. Click an available card to open it. A card with a crown badge (for example Projects, Budgets, Fixed Assets, Dimensions, API, Scheduled) needs a plan feature you do not have; cards marked Soon are not yet available and cannot be opened.

Every available report

The groups below match the Reports panel in the sidebar. Report names are the exact labels you see.

Business Overview

Report What it shows Main filters
Reports Overview The report center described above. —
Income Statement / Profit and Loss Two entries for the same report. Income, Cost of Goods Sold, gross profit, other income, operating expenses, other expenses and net profit for a period, account by account. Defaults to the last 30 days. From → To, basis (Accrual Basis / Cash Basis), Compare
Balance Sheet Assets, liabilities and equity at a single date. Defaults to today. As-of date
Cash Flow Statement Cash flow using the Indirect Method: net profit adjusted for non-cash items and working-capital changes (including input and output VAT movements), then investing and financing activities. Defaults to year to date. From → To, Compare
P&L by Dimension Profit and loss split by your reporting dimensions (needs the Dimensions feature). Period, dimension

Also in the report center (Business Overview category):

Report What it shows
Cash Flow (Direct Method) Cash received from customers and paid to suppliers and for expenses, plus investing and financing cash, for the period (defaults to the current month to date). Shows opening and closing cash, the same-length prior period alongside, and whether the movement reconciles to your cash and bank balances.
Statement of Changes in Equity Movements in each equity account for the period. Supports Compare.
Business Performance Ratios Key ratios (liquidity, profitability, efficiency) for the period and as-of date.

Sales

Report What it shows
Sales Summary Sales totals for the period.
Sales by Customer Sales per customer.
Sales by Item Quantity and value sold per product or service.
Sales Tax Summary The Tax Report limited to sales (output tax).
Sales Tax Detail VAT Detail by Rate limited to sales transactions.

Receivables

Report What it shows
AR Aging Summary Each customer's unpaid balance split into Current, 1–30, 31–60, 61–90 and 91+ days overdue, as of a date.
AR Aging Detail The same aging, one line per open invoice: date, due date, total, balance due, days overdue and bucket.
Customer Statement A statement of a customer's invoices, payments and running balance.
Quote Details Quotes with status and amounts (needs Quotes).
Credit Note Details Credit notes issued and applied (needs Credit Notes).
Receivable Summary / Receivable Detail Receivables by customer, summary or line-level.
Open Invoices Every invoice with a balance still due.
Customer Balance Summary Invoiced, paid and outstanding per customer.
Invoice Details Invoice-level listing with amounts and status.
Payments Received Customer payments received in the period.

The report center also lists Time to Get Paid (how long customers take to pay).

Payables

Report What it shows
AP Aging Summary / AP Aging Detail What you owe suppliers, by aging bucket, summary or per document (open bills and unpaid expenses), with a Gross-to-net reconciliation to the Accounts Payable account.
Supplier Statement A supplier's posted AP movements (bills, expenses, debit notes, payments, refunds, applied advances) with opening, running and closing balance.
Vendor Credit Details Supplier credits (debit notes) and their use.
Payable Summary / Payable Detail AP increases, decreases and balance by supplier (summary, as of a date) or every ledger row (detail, a date range).
Open Bills Every bill with a balance still due.
Vendor Balance Summary AP increases, decreases and balance per supplier as of a date.
Bill Details Bill-level listing with amounts and status.
Payments Made Supplier payments made in the period.

The payables reports share one source, the posted accounts-payable ledger in base currency, so they agree with the supplier profile and the Purchases Overview. See Payables reports for each report's columns, the reconciliation block and worked examples.

Purchases

Report What it shows
Purchases by Supplier / Purchases by Item / Purchases by Category Gross purchase totals grouped as named: posted bills before supplier credits, with outstanding amounts at the end of the range (see Payables reports).
Expenses by Category Posted bill lines and posted direct expenses grouped by account, excluding tax and before supplier credits.
Expenses by Dimension / Revenue by Dimension Expenses or revenue split by dimension (needs Dimensions).
COGS Summary / COGS Detail Cost of goods sold, summarized or per transaction.
Purchase Tax Summary The Tax Report limited to purchases (input tax).
Purchase Tax Detail VAT Detail by Rate limited to purchase transactions.

Banking

Report What it shows
Bank Summary / Bank Detail Balances and movements for bank accounts in base currency, with a Total Balance row that counts each ledger account once; Detail lists every transaction for a chosen account. Cash accounts are not included.
Cash Summary / Cash Detail The same for cash accounts.
Reconciliation Status Reconciliation progress per account (needs Bank Reconciliation). Translated, including the status words and dates.
Reconciliation Discrepancies Differences found during reconciliation (tiles: Discrepancies, Total Difference, Maximum Difference, Unmatched).

Taxes

Report What it shows
Tax Reports (Tax Summary) VAT Input Tax and VAT Output Tax account movements with debit, credit and balance, the Net VAT Position, the VAT control/suspense position, other taxes payable and Total Tax Liability, followed by the underlying VAT transactions. Defaults to the current month to date.
VAT Detail by Rate One row per tax rate with count, net amount, tax amount and total; expand a rate to see each transaction (date, source, net, tax, total). Choose all transactions, sales only or purchases only. Each line is classified by the direction of the transaction, so a purchase is never counted as output VAT.
Discounts Report Sales and purchase discounts by document type and status.
VAT Returns Opens the VAT returns workspace. See Taxes & VAT.

Accountant

Report What it shows
Trial Balance Debit and credit balance of every account at a date. Supports Compare.
Trial Balance (Comparative) Trial balance side by side for two dates.
General Ledger / Detailed General Ledger Every posting per account, with running balances.
Journal Report / Transaction Journal Journal entries and the transactions behind them.
Account Transactions Transactions for a chosen account.
Account Type Summary Balances grouped by account type.
Realized Gain / Loss Foreign-exchange gains and losses realized on settlement.
Account Balances Closing balance per account.
Audit Log Who changed what, and when.
API Usage API requests by your integrations (needs API integration).
System Mails Emails SolaCount sent on your behalf (documents, reminders, scheduled reports).

The report center also lists Unrealized Gain or Loss in the Currency category, which opens Base currency adjustments (needs Multi-Currency).

Budgets

Budget Summary, Budget vs Actuals, Budget Variance by Period, Budget Variance by Account and Project Budget Control Report. These need the Budgeting feature (the last one also needs Projects). See Budgets.

Projects & Timesheet

Timesheet Details, Timesheet Profitability Summary, Project Summary, Project details, Projects Cost Summary, Projects Revenue Summary and Projects Performance Summary. See Project profitability for what each one shows.

Fixed Assets

Fixed Asset Register, Asset Depreciation Summary, Asset Transfer History and Asset Disposal Report (needs Fixed Asset reports). The asset and journal references open the asset page and the journal, Excel keeps your filters and the page language, and the register reconciles to the ledger. See Fixed assets.

Inventory

Stock on Hand, Inventory Aging, Inventory Valuation Summary, Inventory Movement and Inventory Valuation Detail. See Inventory.

Automation

Scheduled Reports: email reports automatically. See Scheduled reports.

Run a report

  1. Click Reports in the rail, then click the report in the panel (or type part of its name in Search reports).
  2. Set the filters at the top-right of the report:
    • Period reports have two date fields (From → To).
    • Balance reports (Balance Sheet, aging, Trial Balance) have one as-of date.
    • Report-specific filters appear next to them, for example Accrual Basis / Cash Basis on the Income Statement or the sales/purchases scope on VAT Detail by Rate.
  3. Click Apply.

The page reloads with the new figures. The filters are kept in the address bar, so the URL reproduces the same report later.

Accrual basis or cash basis (Income Statement)

Basis What it counts
Accrual Basis (default) Income and expenses when the invoice, bill or expense is posted, whether or not it is paid.
Cash Basis Income and expenses only to the extent they were paid in the period. A supplier refund received in cash is treated as realizing the existing supplier credit: the refunded share of the debit note reduces cost in the period the money arrived, and is not counted as a second credit.

What is included

Reports read posted accounting only. Drafts, documents waiting for approval and voided documents are not included. Amounts are shown in your organization's base currency, converted at the exchange rate used when each document was posted. Amounts are displayed with the money precision configured for your organization; aging reports and their exports use the same precision.

Compare two periods

The Income Statement / Profit and Loss, Cash Flow Statement, Statement of Changes in Equity and Trial Balance have a Compare button in their filter bar.

  1. Open the report and set the current period.
  2. Click Compare. A panel opens under Comparison period.
  3. Enter the comparison dates (two dates for period reports, one Comparison date for the Trial Balance), or click Compare with previous year to fill the same dates one year earlier.
  4. Optionally type a Comparison label (for example "FY2025").
  5. Click Apply.

The report then shows, for every line: the current amount, the comparison amount, the difference (current minus comparison) and the difference percentage. A blue banner under the title shows Current Period, Comparison Period and the currency. When the comparison amount is zero but the current amount is not, the percentage shows as N/A instead of an infinite value.

Rules:

  • An explicit comparison period is never silently dropped. If a report URL contains comparison dates, the comparison runs, even if the Compare box was not ticked. To turn it off, open Compare and click Clear. This empties the date fields so the comparison cannot come back.
  • If you turn Compare on without entering dates, the previous year is used.
  • The comparison end date must be on or after its start date.
  • The Balance Sheet has no Compare button. A Balance Sheet link that already contains a comparison date still shows both dates.
  • PDF, Print and Excel exports keep the comparison, so the file matches the screen.

Export, print and share

Most reports have three buttons at the top-right, next to the filters:

Button What you get
PDF Opens the report as a PDF in a new tab.
Print Prints the PDF version once.
Excel Downloads an .xlsx file. Shown only for reports that have an Excel export.

Exports always use the same filters as the screen: dates, basis, scope and comparison. Aging exports (AR Aging Summary, AR Aging Detail, AP Aging Summary, AP Aging Detail) use the same balances, buckets and decimal precision as the screen, so the overdue figures in the file match what you saw; the AP aging files also carry the as-of date and the four reconciliation lines. Column headings, titles and summary labels in Excel and PDF follow the page language.

Banking and fixed-asset reports keep the same promise: the Bank Summary total on screen, in PDF and in Excel is one figure, and the fixed-asset report Excel buttons carry the report's date, status and category filters.

Project and budget reports have Export CSV instead. Some workspaces have their own exports, for example the project budget Export and the division financial report (CSV, Excel, PDF).

To share a report with a colleague who has access, copy the URL from the address bar. To send reports outside SolaCount on a schedule, use Scheduled reports.

Aging reports in detail

AR and AP aging work the same way:

  • As of date: the report shows balances still open at that date. Defaults to today.
  • Days overdue is counted from the due date (or the document date when there is no due date) to the as-of date.
  • Buckets: Current (not yet due), 1–30, 31–60, 61–90, 91+ days.
  • The open balance is the document total minus allocated payments and applied credit notes. A credit note that has been applied to an invoice reduces that invoice's aging balance.
  • Any document with a balance above zero appears, including very small balances. (AP aging ignores balances of AED 0.01 or less.)
  • Payments and credits count only up to the as-of date, so an aging report for a past date shows the position on that date even if you settled the document later.
  • AP aging also lists posted expenses that are unpaid or partly paid (aged from the expense date), and ends with a gross-to-net reconciliation to the Accounts Payable account (Payables reports).
  • Foreign-currency documents are converted to base currency using the document's exchange rate (or the revalued carrying amount where a revaluation applies).

Worked example

Al Noor Trading LLC (Dubai, base currency AED, 5% VAT) wants its Q1 2026 Income Statement compared with Q1 2025.

  1. Reports → Business Overview → Income Statement.
  2. From 2026-01-01 → To 2026-03-31, Accrual Basis.
  3. Compare → Compare with previous year (fills 2025-01-01 → 2025-03-31) → label "Q1 2025" → Apply.

Result (summary lines):

Line Q1 2026 (AED) Q1 2025 (AED) Difference %
Sales income 420,000.00 350,000.00 70,000.00 20.00%
Cost of goods sold 252,000.00 217,000.00 35,000.00 16.13%
Gross profit 168,000.00 133,000.00 35,000.00 26.32%
Operating expenses 96,000.00 90,000.00 6,000.00 6.67%
Net profit 72,000.00 43,000.00 29,000.00 67.44%

VAT is not income. The 21,000.00 AED output VAT on those sales (5% of 420,000.00) appears in Taxes → Tax Reports as VAT Output Tax, and in the Balance Sheet as a liability. It does not appear in the Income Statement.

Click Excel to download the comparative statement with the same columns.

Rules, limits and permissions

  • Permission: View reports (reports.view). Without it the Reports rail item and report pages are not available. Dimension reports also need View dimensions.
  • Plan features: each group needs its plan feature: Profit & Loss, Balance Sheet, Trial Balance, Cash Flow, Tax reports, Sales and Purchase reports, Asset reports, Budgeting, Projects/Timesheets, Dimensions, API integration, Scheduled reports. Reports your plan does not include show a crown badge in the report center and cannot be opened.
  • Read-only: reports never post, change or lock anything. Locked periods and lock dates do not hide data from reports.
  • Comparison validation: an invalid comparison range (end before start) is rejected with a validation message, and the report is not run.

Tips and common problems

  • A figure is missing. Check that the document is posted and not void, and that its date falls inside the period.
  • The Income Statement and Profit and Loss show the same numbers. They are the same report under two names.
  • Cash Flow (Direct) shows "not reconciled". Some cash movement is not classified (for example a manual journal to a bank account). Review the Bank Detail report for the period.
  • The Direct Method option is greyed out on the Cash Flow Statement. That page only produces the indirect statement. For the direct method, open Cash Flow from the report center (Business Overview).
  • The VAT Detail totals differ from the VAT return. VAT Detail by Rate covers the dates you choose; the VAT return covers its filing period and adjustments. Align the dates first.

Related