Invoice Revenue Reconciliation Overview

Last reviewed: June 9, 2026

llms-full.txt
On this page

The Invoice Revenue Reconciliation report compares invoice detail amounts to revenue-related general ledger postings.

What this report is for

Use Invoice Revenue Reconciliation when finance needs to compare invoice product and shipping detail to GL revenue postings for the selected period.

The report is read-only. It does not change invoices, journal entries, revenue accounts, returns, discounts, or customer records.

Screen path

Dashboard > Finance > Reports > Invoice Revenue Reconciliation

Report controls

Control Use
Start Start date for the report. Defaults to the first day of the previous month.
End End date for the report. Defaults to the last day of the previous month.
Generate Runs the report.
Copy for Excel Copies the report after it is generated.

Start and end dates are required. The start date cannot be after the end date.

Report columns

Column What it shows
Inv # Invoice ID when the row is tied to an invoice.
Date Invoice date when available.
Status Invoice status.
Customer Customer code and name.
Inv Product Invoice product detail, excluding freight/shipping line items.
Inv Ship Invoice shipping detail from shipping lines and header shipping charge.
GL Product Revenue posted to product revenue accounts.
GL 4100 Revenue posted to GL 4100.
GL Returns Returns and allowances posted to GL 4300.
GL Disc. Sales discounts posted to GL 4500, shown only when present.
Net GL Product revenue, GL 4100, returns/allowances, and discounts combined.
Gross Diff. Invoice product plus shipping detail minus gross GL product and 4100 revenue.
Reason Explanation generated by PAX for matched or unmatched differences.

The footer shows totals for the numeric columns.

Difference reasons

PAX can show reasons such as:

  • Matched
  • Review difference
  • Manual/unmatched GL entry
  • Unmatched invoice detail
  • Void invoice reversed through 4300
  • Prior-period invoice adjusted in current period
  • Nonstock item posted to 4100
  • Shipping correction
  • Invoice line adjustment
  • Manual invoice adjustment
  • Return/allowance posted to 4300
  • Restocking fee posted to 4100
  • Sales discount posted to 4500

Use the reason as a starting point for review. Do not post an offsetting journal entry until the source invoice, RMA, payment discount, or GL posting has been reviewed.

What happens behind the scenes

Opening the report does not change records.

When Generate is selected, PAX:

  • Reads non-void invoices in the selected invoice date range.
  • Calculates invoice product detail from invoice lines, excluding line items with part number FREIGHT or SHIPPING.
  • Calculates invoice shipping detail from explicit freight/shipping lines and header shipping charge.
  • Reads revenue-related journal entry lines posted in the selected date range for accounts 4000, 4010, 4100, 4300, and 4500.
  • Matches revenue GL lines to invoices through invoice line journal links, RMA links, payment discount references, and known reference patterns.
  • Groups unmatched GL revenue lines separately.
  • Calculates gross and net GL revenue totals.
  • Generates reason text for matched rows, differences, adjustments, returns, discounts, and unmatched items.

Troubleshooting

The report is empty

Likely cause: No invoice detail or revenue GL activity exists for the selected period.

Safe fix: Confirm the invoice date range and GL posting dates. Use Invoice Report Overview and General Ledger Overview to compare source activity.

Contact support if: Invoices or revenue postings exist but the report is empty.

Rows show Review difference

Likely cause: Invoice detail and gross GL revenue do not match and PAX did not identify a more specific reason.

Safe fix: Review invoice lines, shipping charge, returns, discounts, and related journal entries before making any correction.

Contact support if: The source records appear correct but the difference remains unexplained.

A row says Manual/unmatched GL entry

Likely cause: Revenue GL activity exists without a matched invoice.

Safe fix: Review the journal entry reference and confirm whether it was an approved manual adjustment.

Contact support if: The GL entry should have matched an invoice but did not.

Was this page helpful?

Vote *