When the Adjustment Line Feature is useful
When processing invoices, discrepancies in amounts can occur due to rounding differences between how suppliers issue invoices and how your accounting system calculates them.
The Adjustment Line feature fixes this by automatically adding a line item to balance the amounts. This ensures the TOTAL matches, keeping your invoice summary accurate and making it easier to reconcile payments.
How to use the Adjustment Line Feature
The Adjustment Line is part of Datamolino’s pre-export validation process and is available in Document Detail.
Set up Default Coding Preferences for Adjustment Line
Choose which ledger account and tax code should be assigned when creating an adjustment line in Datamolino.
Create Adjustment Line in Document Detail
How pre-export validation works in Datamolino
Main Rules
Datamolino validates that the overall invoice TOTAL matches the sum of the line items.
If the TOTAL doesn’t match, the export is blocked until corrected.
The Adjustment Line automatically clears the difference, ensuring the TOTAL matches the invoice.
NET discrepancies don’t block the export if the TOTAL is correct.
In more detail
Datamolino follows these rules:
If the TOTAL does not match:
The Adjustment Line automatically clears discrepancies between NET and TOTAL, enabling the export.
If the TOTAL matches but there is a difference on TAX:
TAX differences under 10p are allowed and the export proceeds without issue. These minor discrepancies are often due to rounding variations.
TAX differences exceeding 10p stop the export. You’ll need to review and adjust the tax codes on the line items causing the discrepancy.