How do finance teams investigate inter-entity balances that do not agree?

John Stephenson Published

Business role: Finance and Accounting Workflow: Inter-Entity Period Close

Ask the AI Advisor about this topic

Start with the linked operating documents, not a balancing journal. Versa Cloud ERP's Inter-Entity Invoice Bill Reconciliation report compares the selling entity's invoice with the buying entity's bill so finance can identify amount, posting, currency and period differences before preparing eliminations.

An inter-entity receivable and payable can disagree even when both teams believe their work is complete. One side may be unposted, a bill may carry a different date, an amount may have been edited, or the two documents may use different currencies. A consolidated total alone shows that something is wrong but not which pair caused it.

Compare both sides of the linked transaction

Inter-Entity Transactions records the relationship between supported documents created for activity inside the same firm. The reconciliation report uses those links to present invoice and bill evidence together across entities.

For each pair, finance should review:

  • selling and buying entity;
  • invoice and bill numbers;
  • invoice and bill dates;
  • posted status on both sides;
  • currency on both sides;
  • invoice amount, bill amount and variance;
  • whether the documents fall in the same reporting period.

The report can be narrowed by date and entity pair, and an exceptions view helps the controller focus on mismatches. Because it is a firm-wide reconciliation tool, it is meant to compare both sides rather than silently reducing the result to whichever entity is active in the user's session.

Route the difference to the record that needs correction

The exception determines the next owner:

Finding Follow-up
Invoice posted, bill unposted Buying-entity finance reviews and completes or rejects the bill
Different amounts Both owners compare quantities, prices, taxes, freight and credits
Different currencies Finance confirms the intended currency and exchange-rate treatment
Different periods Controller applies the organization's cutoff policy
Missing link Operations confirms whether the documents represent the same inter-entity activity
Duplicate document The responsible entity corrects the duplicate through its approved process

An invoice for $18,400 is posted on March 30, while its linked bill for the same amount is dated April 2. The amount variance is zero, but the period does not match. Finance now has a cutoff decision to resolve with both entity owners before treating the pair as ready for March elimination.

Do not conceal an exception with an elimination

The assisted close preview includes only clean linked invoice and bill pairs: both documents are posted, not voided, use the same currency, fall in the same month and agree within the configured tolerance. A mismatched pair remains outside that clean set until its source issue is corrected.

That boundary prevents an elimination journal from becoming a substitute for accurate entity records. The software surfaces the pair and the difference; the finance team decides whether to correct a date, amount, posting state or relationship under its accounting policy.

Reconcile the balances before group reporting

After exceptions are resolved, rerun the reconciliation report and compare the inter-entity receivable and payable balances. Keep support for any timing or currency difference that properly remains. Only then should clean activity move into the elimination-draft workflow.

For a buyer, Versa Cloud ERP provides traceability from group-level disagreement back to linked invoices and bills. It helps finance find the responsible record and owner without claiming that every difference can or should be automatically corrected.

Ask the Versa Cloud ERP AI Advisor about inter-entity reconciliation

See an online demo.

Browse all how-to guides