Skip to main content
Version: Current

Troubleshooting: Statement Lines Not Matching Transactions

Problem

When reconciling a supplier statement in Zudello (Purchasing > Statements), specific lines on the statement (left side) are not automatically matching (linking with a coloured line) to the expected Invoice or Credit Note transactions in Zudello (right side).

Common Causes

  1. Incorrect Supplier Match: The statement header is linked to the wrong Supplier record in Zudello. Matching only occurs between the statement and transactions linked to the same Supplier.
  2. Missing/Incorrect Data on Statement Line: Key matching data (Document Number, Date, Amount, Type) was not extracted correctly from the statement line, or is missing.
  3. Missing/Incorrect Data on Zudello Transaction: The corresponding Invoice or Credit Note in Zudello has incorrect data (e.g., wrong Document Number, Date, Total Amount) or is missing entirely.
  4. Date Tolerance: The date on the statement line falls outside the acceptable date tolerance range compared to the Zudello transaction date (influences Green vs. Blue/Yellow matches, but significant differences might prevent matching).
  5. Amount Mismatch: The amount (Debit/Credit) on the statement line does not match the total amount on the Zudello transaction (within a small tolerance).
  6. Document Type Mismatch: The type extracted from the statement line (e.g., "INV", "CR") does not align with the submodule of the Zudello transaction (Invoice vs. Credit).
  7. Transaction Already Reconciled: The corresponding Invoice/Credit in Zudello might have already been reconciled against a different statement.
  8. Autocomplete Extension Disabled: The Autocomplete statement line extension is not enabled for the Statement Document Type. See Configure Statement Reconciliation Rules.

Troubleshooting Steps

  1. Verify Statement Supplier: Check the Supplier linked in the statement header. Is it the correct one? If not, manually select the correct Supplier and Save. This should re-trigger the matching process.
  2. Review Statement Line Data: Examine the specific statement line that isn't matching. Compare the extracted Document #, Date, Type, Debit, and Credit values shown in Zudello against the statement image. Are they accurate? Correct any extraction errors manually and Save.
  3. Find and Verify Zudello Transaction:
    • Manually search for the expected Invoice or Credit Note in the Purchasing module (Invoices or Credits submodule). Does it exist?
    • Open the transaction. Verify its Document Number, Date Issued, and Total Amount. Do they match the statement line details (considering potential date tolerance and amount matching)? Is the correct Supplier linked? Is the status appropriate (usually COMPLETE)?
    • Correct any errors on the Zudello transaction and Save.
  4. Check Document Type Alignment: Does the type on the statement line (e.g., "INV") correspond to the submodule of the Zudello transaction (e.g., Invoice)?
  5. Check Previous Reconciliations: Has the Zudello transaction already been reconciled on another statement? (Future functionality might make this easier to see).
  6. Verify Autocomplete Extension (Admin Task): Go to Settings > Document Types > Edit Statement > Extensions. Ensure Autocomplete statement line is enabled.
  7. Manual Matching (If Available): If future functionality allows manual linking on the reconciliation screen, attempt to manually link the statement line to the correct Zudello transaction.
  8. Request Copy: If the Zudello transaction is genuinely missing, use the Request Copy button (if configured) or contact the supplier to obtain the missing document and upload it to Zudello. Once processed, it should appear for matching.

Need Help?

If statement lines consistently fail to match despite correct data, contact Zudello support. Provide:

  • The Document UUID of the Statement.
  • Details of the specific statement line(s) not matching.
  • The Document UUID or Number of the expected Invoice/Credit Note in Zudello.
  • Screenshots of the reconciliation screen showing the mismatch.