Small and medium business | Business Central, N...

Invoice line totals does not reconcile

(6) Share

Report

Posted on by Community member

Anyone have some troubleshooting tips when the line total and invoice totals of an imported document don't match on the document card? I am sure it must be an easy fix as the line totals on the imported document are inclusive of GST but the Invoice total is showing as EXGST??

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (3)

Report

Do you use out of box BC module to calculate the tax or use a 3rd party app ?

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

If the line totals on an imported document include GST but the invoice total appears to exclude it, the most likely cause is a mismatch in the “Prices Including VAT” setting, this should be enabled if GST is included in line prices.

Additionally, check that the correct VAT Posting Groups are applied, ensure VAT is calculated correctly on each line, and review Rounding Precision settings in the General Ledger Setup.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (1)

Report
Hello,

When the invoice line totals and the overall invoice total do not reconcile in Business Central, especially in the context of imported documents, the issue often stems from how tax (GST) is handled during import.

Here are a few troubleshooting steps to consider:

Check the tax setup on the vendor or customer card
Ensure that the correct GST calculation method is applied. If the lines are inclusive of GST but the invoice total is calculated as exclusive, this mismatch can occur.

Review the import logic or mapping
If the document is imported via a custom integration or external tool, verify whether the GST-inclusive amounts are being correctly parsed and mapped to the line and header fields.

Validate the “Prices Including VAT” flag
On the document card (e.g., purchase or sales invoice), check if the “Prices Including VAT” field is set appropriately. This flag affects how totals are calculated and displayed.

Inspect the VAT posting setup
Confirm that the VAT posting group and calculation type are consistent across the lines and header. Inconsistencies can lead to discrepancies in totals.

Use the “Statistics” page
The statistics view can help identify where the mismatch is occurring—whether in line amounts, VAT amounts, or rounding.

If the issue persists, it may be helpful to test the same scenario manually to isolate whether the problem is with the data or the import process.

Please let me know if this helps resolve the issue.

Best regards,
Daniele Incalza

Was this reply helpful? Yes No
Suggested answer

Ahmad Subhani 585 on at

Like (1)

Report

Hi,

In Line Level and in Total both the values comes. Simply just bring the fields from Design and then you can see the total's the way you want.

Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No
Suggested answer

techreviews.digital 376 on at

Like (1)

Report

It will be great if you can clarify, how are you importing the invoice in the Business Central. Either you are using configuration package or any customized solution.

Points to be considered while importing invoices:

- If using the configuration package, then in which column the user is adding the Amount Incl. GST, either in Amount column or Amount Incl. VAT. The amount column is used for importing the line amounts exclusive of GST.

- So, please make sure, you are using the right fields mapping while importing the invoices.

- VAT/ GST values are calculated based on the setup information in VAT Prod. Posting Group, please make sure you are updating these values in your import template.

For Checking the Line Amount Incl. of VAT/ GST on Line Level:

- Press ALT + CTRL + F1 or ALT + CTRL + Fn + F1 from your keyboard to open the Inspection Page. Or follow the below steps to open the Inspection Page Manually.

Step 1: Click on ? sign in the top-right corner.

Step 2: Click on Help & Support from Other Resources.

Step 3: Click on Inspect Pages and Data from the Troubleshooting in the pop-up window.

- Select the invoice line by clicking on any field of the related line.

- Click on the Search Icon below the Page Filters in the Page Inspection pane.

- Search for Amount Including VAT to check the amount inclusive of VAT/ GST for that specific line. Attaching the screenshot below for your reference. (This field is available in the backend not frontend)

I hope this will resolve all your concerns.

Best Regards,

Sheikh Muhammad Jawad

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (1)

Report

Hi, good day

Can you check if you are using the VAT-included prices feature.?

Best Regards
Gerardo

Was this reply helpful? Yes No