How to Generate a Line-Item Level Invoice Report in Brightflag

If you're trying to run a report in Brightflag that provides a detailed, line-item view of all invoices to cross-reference, follow the steps below to ensure the data matches correctly with the Overview tab.

Issue: Report Totals Do Not Match Overview Tab

You may notice discrepancies between the totals in your downloaded report and those displayed in the Overview tab for some firms. This guide will walk you through the correct steps to generate the report and verify that the totals match.

Steps to Generate a Line-Item Level Report in USD

Step	Action	Fields to Select
1	Click "Create Report" and select the "Invoices" template.
2	Under Core Fields, select:	- Invoice Number - PO Number - Vendor - Vendor Ref - Status - Matter - Matter Category - Matter Ref - Department - Entity - Internal Matter Lead Email
3	Under Date Fields, select:	- Invoice Date - Billing Period End Date - Billing Period Start Date - Invoice Received Date
4	Under Spending Fields, select:	- Net Fees Total - Discount - Total Expenses - Tax - Gross Total
5	Under Approvers, select:	- All Approvers - Approver Comments

Verify the Report Against the Overview Page

After running the report, follow these additional steps to ensure the totals match the Overview tab in Brightflag:

Filter the report status to "Approved" and "Pending" invoices – These are the invoices accounted for on the Overview page.
Filter by Vendor – This allows you to sum the Gross Total by vendor and cross-check it against the Overview tab.

For example, after filtering by the vendor sum, the Gross Total column to confirm that it matches the Overview tab.

Common Discrepancies and How to Troubleshoot

You might observe the following scenarios:

Matching Figures: In some cases, the total in your report will match the figure in the Overview tab perfectly.
Slight Differences: For some vendors, the figures may be slightly off. This could be due to rounding, currency conversion, or the inclusion of pending invoices in one view but not the other.
Significant Differences: If there’s a large discrepancy, ensure that all relevant fields are selected in the report and that the filters (such as date range, status, and vendor) are applied correctly.

Need Further Help?

If you're still seeing discrepancies after following these steps, or if you need assistance building the pivot table, feel free to reach out to support. We're happy to assist!