When you are reviewing a date range and trying to reconcile sales and materials cost, it is common to compare the Invoice Cost Comparison report to your financial statements. If the totals do not match, it usually points to filters not lining up, credit memos being excluded, or transactions posting to different G/L accounts than you expect.

The goal is not to make the reports agree by force. The goal is to prove exactly which invoices and which postings are driving the difference so your revenue and COGS reporting stays consistent.

Run The Invoice Cost Comparison Report For The Date Range

In Cetec ERP, start from Sales and use the Invoices menu to open the Cost Comparison report for the same date range you are reviewing on your P&L. This report is typically where teams begin when they want to see invoice dollars alongside material dollars used on those invoices.

If you see a discrepancy, first confirm that your financial statement filters match the same date range and basis as the Cost Comparison report. Small differences in date filters can create large swings in totals.

Use The Invoice List To Reconcile Totals And Include Credit Memos

A practical way to reconcile the sales total is to run the Invoice List for the same date range, then make sure credit memos are included. In Cetec ERP, go to Sales, open the Invoices menu, select Invoice List, set the date range, then use More Options and set Credit Memos to Include.

From there, export the Invoice List to Excel and sum the Total column. This gives you a clean tie-out for invoice activity in the period, including credits. If that sum matches your P&L sales total for the same period, the difference you saw earlier was driven by exclusions or presentation in the cost comparison view.

Keep in mind there can still be differences between the Invoice List total and your Trade Sales account if revenue is being posted to a different account for specific parts or PRCs.

Confirm G/L Mappings For Invoices And Inventory Adjustments

If sales totals or materials cost totals still do not tie out after you confirm filters and credit memos, the next place to look is posting behavior. Differences are often caused by configuration around which accounts are credited and debited for invoice transactions and for inventory adjustments.

A good practice is to review the mappings where inventory, COGS, and revenue are impacted, then run a small test transaction to verify the postings are flowing to the accounts you expect. This helps you separate a reporting mismatch from a true accounting configuration issue.

Check Part And PRC Revenue And COGS Account Overrides

If you suspect part-level behavior is affecting totals, review whether specific parts or PRCs are set to post revenue and cost to a different G/L account than your default. These overrides can legitimately move revenue or COGS out of the account you are comparing against on the P&L.

To review part-level settings, go to Parts, open Lists, and select Part List. Make sure Revenue G/L Account and COS G/L Account columns are visible. To review PRC-level settings, go to Parts, open Lists, and select PRC List, then show the same columns.

How to decide where to focus: if your invoice list ties to the P&L after including credit memos, the issue is usually reporting filters or exclusions. If the invoice list still does not tie to the revenue or COGS accounts you expect, focus on mappings and on part or PRC account overrides.

Key Takeaways

• Match the date range and reporting basis between the Invoice Cost Comparison report and your financial statements.
• Use Invoice List with credit memos included, then export and sum totals to reconcile invoice activity for the period.
• If totals still differ, review invoice and inventory adjustment G/L mappings where revenue, inventory, and COGS are impacted.
• Check Part List and PRC List for Revenue G/L Account and COS G/L Account overrides that can move postings out of your default accounts.

Conclusion

Reconciling sales and materials cost totals starts with making sure you are comparing the same population of invoices, including credit memos, for the same date range. If the invoice population is correct but the numbers still do not tie, the next step is confirming the G/L mappings and any part or PRC account overrides that control where revenue and COGS post in Cetec ERP.