How to match invoices report to a line item report?

Problem Statement

Discount Reversal and AR Aging Balance use different bases (e.g. void date vs invoice date, service period), so summary and line-item reports can disagree. You need a way to match the invoices export to a line item report for consistent analysis.

Solution

Use VLOOKUP in Excel or Google Sheets to link the invoices export to a line item report. Use Invoice number as the common key in both sheets. Add a column in the line item sheet for invoice date (pulled via VLOOKUP from the invoices export), then run your analysis. This aligns data at the line item level and avoids the discrepancy between summary and AR balance caused by different date filters and service periods.