Use this article to understand how Confido matches invoice payment lines on a check to open invoices in your ERP (enterprise resource planning system, such as QuickBooks Online or NetSuite), and to fix an invoice payment line that won't link or shows "does not exist in the GL". This article is for Confido users who process checks in Cash Application.
How does Confido match invoice payment lines to invoices?
Confido matches each invoice payment line on a check to an open invoice in your ERP for the customer on that check. For an invoice payment line to link automatically, the invoice number on the remittance must match an invoice that is open in your ERP and belongs to the same customer as the check.
What does "does not exist in the GL" mean on an invoice payment line?
In Cash Application, "does not exist in the GL" means the invoice number on the remittance didn't match any open invoice in your ERP for the customer on the check. Common causes include the following:
The invoice is already closed or paid in your ERP, so it is no longer open.
The invoice sits under a different customer in your ERP than the customer on the check (for example, a sub-location instead of the parent distributor).
The invoice number on the remittance is different from the invoice number in your ERP.
How do I fix an invoice payment line that won't link?
To link an invoice payment line that shows "does not exist in the GL":
Open the check in Cash Application.
Click Refresh Check Invoices at the top of the check. This re-pulls the invoice numbers from your ERP for that remittance.
If an invoice payment line still doesn't link, open the Invoice Number dropdown on that line and select the matching open invoice manually.
Confirm the customer on the check is the customer the invoices sit under in your ERP (for example, the parent distributor rather than a sub-location). You can check how customers are mapped under Settings → Directory.
When the invoice payment line links, it shows the matched invoice number instead of "does not exist in the GL". If the line still shows "does not exist in the GL", open the invoice in your ERP and confirm it is open and belongs to the check's customer. If the invoice is open and under the right customer, contact [email protected] with the check number and one example invoice number that won't link.
Limitations
Confido can only link an invoice payment line to an invoice that is open in your ERP for the customer on the check.
Affected: invoices that are closed, paid, or held under a different customer record in your ERP.
Limitation: Confido won't auto-link these invoice payment lines, even if the invoice number matches.
Workaround: reopen or correct the invoice or its customer in your ERP, then click Refresh Check Invoices on the check in Cash Application.