See the transactions behind a report figure

Open a linked report amount, check its supporting total and return to the same report.

Who can do this
Owners, or people with View financial reports
Where
Reports
On this page

Open a report figure

  1. Open the report you want to check.
  2. Apply the dates and filters you need.
  3. Select a linked amount.
  4. Read the matching-total message above the supporting list.

An account amount opens that account's posted lines for the selected column's dates. A group total opens all contributing accounts. A prior-period, month or quarter amount opens its own dates.

On the Nonprofit activities, financial position, functional expenses and fund trial balance statements, an account name also opens account activity. It uses the row’s total scope, statement dates and selected coding filters. This needs View financial reports; names stay plain when you cannot open account activity.

Check what opened

Balance-sheet and trial-balance amounts open a balance view: earlier history appears in the opening balance, followed by activity through the selected date. Profit-and-loss amounts open period activity without closing entries.

Aging amounts open unpaid invoices or bills for the selected contact and bucket. Taxable-sales and tax amounts open invoice lists for the selected rate, month or state. These are document lists rather than account activity.

Calculated figures, such as gross profit, show an information control explaining the calculation. A linked net income on the balance sheet opens profit and loss. A dash means there are no supporting lines to open; a zero can be linked when entries cancel out.

Check the total and return

The matching message counts every included line, even when only the first page is loaded. If the figure differs, the warning shows both amounts. Changed filters or later postings can explain it. Select Refresh the report to check the source again.

Use the back link above the drilled page or your browser's Back command to return with the report's dates and filters. Document numbers open records directly when you have permission. Locked numbers remain readable without a record link.

You need View financial reports to use account activity. Viewing a source invoice, bill or journal entry needs its own permission. Next, use account activity or preview a transaction.

From Nonprofit changes and spending

With Compare on, financial position, activities and functional expenses offer Explain. Its reasons group changes by donor, grantor or vendor within the statement's coding filters. Grant receipts and recognitions use their award's grantor. A reason's linked prior or current amount opens that contact's lines for its own dates.

Restriction movement links contributions and releases for the row's restriction, fund, class and period, keeping the selected program and grant filters. Grant budget and actuals links Spent for the line's account, fund, program and spending dates. The total Spent amount opens the award's expense lines for the report dates. Spending outside these lines stays plain. Liquidity amounts stay plain because the worksheet is a reviewed snapshot.

Explain needs View Nonprofit reports or View financial reports in a Nonprofit business. Opening account activity still needs View financial reports.

Was this helpful?

Reviewed · View as Markdown