This guide walks you through configuring the GL Accounting Customization page in Confido. This is a critical setup step that ensures your accounting data maps correctly between Confido and your ERP (e.g., QuickBooks Online, NetSuite, SAP). Proper configuration here enables accurate check processing, deduction tracking, payment term validation, and automated billback handling.
Accessing GL Accounting Customization
Click Settings on the left-hand navigation bar.
Select GL Accounting Customization.
Direct link: https://app.confidotech.com/settings/gl-misc
This setting is divided into two main sections: Select Default Accounting Subsidiary and Manage Vendors and Customers.
Manage Vendors and Customers
This is the main configuration area where you map your Confido contacts (the distributors, retailers, and other trading partners you work with) to the corresponding customer and vendor records in your GL/ERP system. Accurate mapping here is essential for Confido to correctly process checks, match deductions, validate payment terms, and push journal entries to your accounting system.
Display GL Customer Names
At the top of this section, you will see a toggle:
"Display GL customer names throughout Confido instead of Confido contact names?"
When enabled, Confido will display the GL customer/vendor name (the name as it appears in your ERP) across the platform instead of the Confido contact name. This is useful if your team is more familiar with the names in your accounting system.
Searching for Contacts
Use the search bar at the top of the contact list to quickly find a specific contact by name. This is helpful when you have a large number of vendors and customers mapped.
Adding a New Contact
To add a new contact to Confido:
Click the Add Contact button in the upper right corner.
Fill in the required details (see the column descriptions below).
Click Save.
Tip: If you have many contacts to add at once, use the Import Contact Mapping CSV feature to bulk-import your contact mappings. Click the green Import Contact Mapping CSV button to upload a properly formatted CSV file.
Understanding the Contact Table Columns
Each row in the contact table represents a trading partner. Below is a detailed explanation of every column:
1. Name
The Confido contact name. This is the internal name Confido uses to identify this trading partner. It is typically the name of the retailer or distributor (e.g., UNFI, KeHE, Walmart, Costco).
2. GL Customer
The customer name as it appears in your ERP/GL system. Mapping this field correctly ensures that when Confido processes a check from this trading partner, it can match it to the right customer record in your accounting system for invoice matching and payment posting.
Note: If you do not see the customer you are looking for in the dropdown, make sure the customer exists in your connected ERP and that a GL Sync has been run recently.
3. GL Vendor
The vendor name as it appears in your ERP/GL system. This is relevant when the trading partner also acts as a vendor (e.g., when you receive billbacks or need to create vendor-side entries). Some trading partners may have both a GL Customer and GL Vendor mapping.
4. Type
Indicates whether the contact is a Customer, Vendor, or Both. It also specifies if the trading partner is a Retailer or Distributor. This classification impacts how Confido routes and categorizes transactions:
Customer: You receive payments from them (e.g., checks, remittances).
Vendor: You send payments to them (e.g., billbacks).
Retailer: A direct retail partner (e.g., Walmart, Costco, Target).
Distributor: A distribution partner (e.g., UNFI, KeHE, DOT Foods).
5. AR Email (Accounts Receivable Email)
The email address from which this customer sends checks or payment remittances as PDF attachments. When configured, Confido will automatically detect and process PDF check remittances sent from this email address, eliminating the need for manual uploads.
How it works:
The customer sends a check/remittance PDF to your configured Confido inbox.
Confido matches the sender email to the AR Email field for this contact.
The check is automatically ingested and appears in your Cash Application queue.
Note: Some customers (Aldi, Trader Joe's, Thrive Market, Ulta, UNFI, Vistar) have checks flow into Confido automatically without needing an AR Email configured.
6. AP Email (Accounts Payable Email)
The email address from which this vendor sends billback documents as PDF attachments. When configured, Confido will automatically process billback PDFs received from this address.
This is particularly important for vendors who send billback invoices via email. Once the AP email is set, Confido will automatically pull in and queue these billbacks for review under Accounting > Cash Application > Billback.
7. Customer and Vendor Checkboxes
These checkboxes indicate whether the contact is treated as a Customer, a Vendor, or both within Confido. A single trading partner may function in both capacities. For example, a distributor like UNFI may be a customer (they send you payment remittances) and also a vendor (they send you billbacks or charge-backs).
8. Payment Terms
Payment terms define the expected payment schedule for each customer. Setting payment terms enables Confido to validate whether payments are arriving on time and automatically flag potential early-pay discount disputes.
Common payment term formats:
Term | Description |
Net 30 | Payment is due 30 days after the invoice date. |
Net 45 | Payment is due 45 days after the invoice date. |
Net 60 | Payment is due 60 days after the invoice date. |
2/10, Net 30 | 2% discount if paid within 10 days; otherwise full payment due in 30 days. |
When payment terms are configured, Confido will automatically flag checks where the payment timing does not match the expected terms. This is critical for identifying and disputing early-pay discount deductions that may not be warranted.
Tip: Setting accurate payment terms for each customer is one of the most impactful configurations you can make. It enables Confido to automatically catch early-pay discrepancies and support your dispute process.
9. Fulfillment
The Fulfillment column tracks the fulfillment method or logistics details associated with a specific vendor or customer. This helps your team understand how products reach the trading partner and can impact how deductions related to logistics (e.g., freight, short-ships) are categorized.
10. Vendor Agreement
The Vendor Agreement column allows you to associate a vendor agreement or contract reference with each contact. This is useful for tracking contractual terms and having documentation readily available when reviewing deductions or processing disputes.
Vendor agreements can include details such as agreed-upon rates, allowances, promotional commitments, and penalty clauses. Having these visible alongside the contact helps your accounting and sales teams make informed decisions during the cash application process.
11. Distribution Centers (DCs)
The DCs column lets you map specific distribution centers to each retailer or distributor. This is important for tracking which distribution centers are associated with specific checks and deductions, enabling more granular reporting and analysis.
How to map distribution centers
Find the customer/vendor in the table.
Click Edit under the DCs column on the right-hand side.
Map the appropriate distribution center to the corresponding ledger field.
Click Save.
Mapping DCs ensures that deductions and payments are correctly attributed to the right location, which is especially important for brands that ship through multiple distribution centers for the same retailer.
Editing an Existing Contact
To edit any existing contact:
16. Find the contact in the table using the search bar or by scrolling.
17. Click the Edit (pencil) icon on the right-hand side of the row.
18. Update the desired fields.
19. Click Save to apply your changes.
Bulk Import: Contact Mapping CSV
For companies with a large number of trading partners, Confido supports bulk importing contact mappings via CSV. This feature is especially useful during initial onboarding when you need to set up dozens or hundreds of customer/vendor mappings at once.
How to use the CSV import
Click the green Import Contact Mapping CSV button.
Download the template CSV if needed to ensure proper formatting.
Fill in the required fields for each contact (Name, GL Customer, GL Vendor, Type, AR Email, AP Email, Payment Terms, etc.).
Upload the completed CSV file.
Review the imported contacts in the table and verify accuracy.
Note: Ensure that all GL Customer and GL Vendor names in the CSV exactly match the names in your ERP system. Mismatches will prevent proper invoice matching and payment posting.
Best Practices
Complete all mappings before processing checks: Ensure every trading partner that sends you payments or billbacks has been properly mapped with GL Customer/Vendor names before you begin processing checks in Confido.
Keep AR and AP emails up to date: If a trading partner changes the email address from which they send remittances or billbacks, update the AR/AP email fields immediately to avoid missed or unprocessed documents.
Set payment terms for all customers: Even if you only plan to dispute a few customers initially, having payment terms set for all customers gives you full visibility into potential early-pay discrepancies.
Map distribution centers early: If you ship through multiple DCs for a single retailer, set up the DC mapping during onboarding to ensure accurate reporting from day one.
Verify mappings after GL Sync: After running a GL Sync (which pulls the latest data from your ERP), check this page to ensure new customers or vendors in your ERP have been mapped correctly.
Frequently Asked Questions
I can't find a customer in the GL Customer dropdown. What should I do?
The dropdown pulls data from your connected ERP. If a customer is missing, first confirm it exists in your ERP. Then run a GL Sync to pull the latest data into Confido. If it still doesn't appear, contact your Confido support team.
Can a single contact be both a Customer and a Vendor?
Yes. Many trading partners function as both. For example, UNFI may send you payment remittances (Customer) and also send billbacks (Vendor). You can map both the GL Customer and GL Vendor for a single contact.
What happens if I don't map a contact's GL Customer?
If a contact is not mapped to a GL Customer, Confido will not be able to match incoming checks from that trading partner to invoices in your ERP. This means checks from unmapped customers will require manual intervention.
How often should I review this page?
We recommend reviewing your GL Accounting Customization settings whenever you onboard a new trading partner, after major ERP changes, and periodically (e.g., quarterly) to ensure all mappings remain accurate and complete.
