If you're struggling to reconcile your supplier's statements with your invoices, even after adjusting templates and correcting your statement table, the issue might lie in how the invoice numbers are formatted. You can customize the format of supplier invoice numbers using the Edit Supplier Format feature.

If there is a difference between how your supplier displays the invoice details on the Invoice and on the Statement, this information can be matched with this feature

Here’s how you can adjust the formatting:

1. Add Text to the Beginning of Invoice Number:

• To add a space before the invoice number, type \s in the field.
• To include a bracket, type \) or \(.

2. Remove Text from the Beginning of Invoice Numbers

• Use this feature to strip unnecessary characters, prefixes, or spaces from the start of invoice numbers.
• Example:
  • If a supplier adds "INV" before the number, you can remove it to match it.
  • 
    
    
    One useful tip is to use the \s sign to add spaces to the invoice number. This is helpful when a mismatch arises because the supplier's statement uses a format different from invoice numbers.
    Additionally, If your statements are not reconciling because hyphens are being included in the invoice numbers from the statement table, you can use the Edit Supplier Format feature to remove the hyphens. This adjustment helps ensure that the invoice numbers match correctly.