Skip to main content

Read Report Totals, Signs, Running Balances, and Age Buckets

Read Report Totals, Signs, Running Balances, and Age Buckets

Overview

This guide will help you interpret report values correctly before making an operational or accounting decision.

You can explain reported values and distinguish real exceptions from presentation conventions.

Who can do this

You need access to View access to the report and its underlying business scope.

Before you start

Know report grain, account/transaction type, date scope, unit/currency, set up decimal places, and expected normal balance.

Before saving, check that the correct company is open and that you have permission to complete this task.

Where to find it

Open and filter the selected report.

Read Report Totals, Signs, Running Balances, and Age Buckets

Step 1: Identify whether each row is a transaction, item, document, party,

Identify whether each row is a transaction, item, document, party, account, group, or period.

Step 2: Confirm unit and currency

Step 3: Determine how returns, refunds, credits, reversals, and negative quantities are

Determine how returns, refunds, credits, reversals, and negative quantities are signed.

Step 4: Recalculate one running balance from opening plus movements

Step 5: Verify subtotal and grand-total grouping

Step 6: For ageing, inspect due-date basis and bucket boundaries

Check your work

Representative row, subtotal, running balance, and ageing bucket reproduce from source data.

Take a moment to check your work before closing the window. This small check can save time later.

If something goes wrong

  • Do not assume parentheses, credit, or negative signs mean the same thing across reports.
  • Investigate rounding at line, document, and grouped levels.

What to do next

Back to top