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. Here’s how it works to ensure your invoices are ready for export:
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 and NET amounts align.
NET discrepancies don’t block the export if the TOTAL is correct.
How It Works with 'Let Xero Calculate'
When using the Let Xero Calculate setting, 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.
Alternatively, you can switch to Send Exact Tax Amount to adjust the TAX manually:
How It Works with 'Send Exact Tax Amount'
In the Send Exact Tax Amount setting:
The TAX and TOTAL must match exactly for the export to proceed.
If there’s any difference, the export is blocked until you adjust the amounts manually or use the Adjustment Line button.
NET discrepancies do not block the export if the TAX and TOTAL are correct.