Overview

What the Integration Covers

1. Lists synchronization/mapping - Ensures that key data in your Bill.com account aligns with CustomBooks™. The synchronized lists include:
1. Vendors - Maintain an updated list of all vendors to ensure accurate payments.
2. Chart of Accounts (for expense categorization) - Map your Bill.com accounts to your CustomBooks™ chart of accounts for consistent financial reporting.
3. Products - Keep product information consistent between systems to simplify transaction entry.
4. Payments Terms - Ensure that vendor payment terms are synchronized to avoid errors in due dates or cash flow planning.
   
   
2. A/P Documents management - The integration also provides full management of accounts payable documents, including:
1. Bills - Create and manage bills directly in CustomBooks™ from your Bill.com account.
2. Bill Payments - Process payments to vendors, tracking them efficiently in both Bill.com and CustomBooks™.
3. Purchase Returns (Refunds) - Manage returns and refunds accurately to ensure both systems reflect the correct balances.
   
   

How the Integration Works (A/P Flow)

1. Lists created in CustomBooks™ (such as Vendors and the Chart of Accounts) can be synced to Bill.com to either match them with the existing accounts in Bill.com or create a new account. The same goes for lists created in Bill.com to CustomBooks™.
2. As for Products and Payment Terms, data created in Bill.com can be matched with the existing data in CustomBooks™, or you can create them as new data in the list.
   
3. A/P Documents created in Bill.com can be synced in CustomBooks™ to either match them to an existing document or create a new document.

Setup Requirements

1. An active Bill.com account with the following information needed:
   
1. Sync Token Name
   
2. Sync Token Password
2. Administrator access in both Bill.com and CustomBooks™
   

Activating the Integration

1. Navigate to Admin Panel → Integrations.
   
2. Click the gear Setting icon   on Bill.com.
   
3. Enable Bill.com for the company by checking the checkbox right above the connection window.
4. Click the "Connect to Bill.com" button.
   
5. Enter the Sync Token Name & Password that can be found in the Settings section in your Bill.com account.
   
6. Click the "Get companies list" button.
   
7. Once successful, select the Company you want to sync and enter the Feed start date.
   
8. Enable "Sync attachments for Bills" by checking the checkbox if you want to sync the files attached to the bills in Bill.com.
   
9. Click the "Connect" button.
   

Cloud Payables drives the synchronization of Accounts Payable data from Bill.com into CustomBooks™. This includes bills, bill payments, purchase returns (refunds), and related lists such as vendors, products, payment terms, and accounts.

For detailed steps on syncing Bill.com data into CustomBooks™, please refer to the Cloud Payables knowledge article. The article provides step-by-step guidance on how to review, match, and approve imported records from Bill.com.

Certain types of CustomBooks™ data can also be synced from CustomBooks™ to Bill.com. Currently, the following record types are supported for syncing to Bill.com:

1. Vendors
2. Chart of Accounts

This allows you to prepare and ensure your core reference data in CustomBooks™ is available in Bill.com before syncing or processing transactions.

Steps to Sync Vendors and Chart of Accounts from CustomBooks™ to Bill.com

1. Navigate to Lists and choose the list you want to sync:
   
1. Vendors
   
2. Accounts (Chart of Accounts)
   

2. On the list view for both Vendors and the Chart of Accounts, you may:
1. Send all unsynced records to Bill.com.
   - Click the Sync → Send all unsycned record to bill.com.
2. Select a specific record to sync.
   - Click or highlight a record to sync.
   - Then click Sync → Sync selected record.
3. Select multiple records to sync.
    - Click or highlight multiple records to sync. 
   - Then click Sync → Sync selected record.
      
   
   
3. After selecting the record/s to sync, you can either match (Sync) them to an existing record in Bill.com or Create New records in Bill.com.
                                         
   For sending all unsynced records or syncing multiple records, you have the option to skip the record if you decide not to include them.