Here are the steps and the checklist for preparing data for the Bill.com and BQE Core for the SPRCHRGR Sync Tool Integration
Step 1: Choose and document the official start date: ________________________
Step 2: Decide which system is the "source of truth" for the initial sync for lists and transactions.
Decide which system is the "source of truth" for the following lists and transactions. Source of truth = the system that provides the most accurate and valid data.
| Data List |
Presumed Source of Truth |
YOUR Source of Truth: Bill.com or BQE Core |
| Chart of Accounts list (general ledger accounts) | BQE Core | |
| Classes | BQE Core | |
| Customer/Projects/Phases list | BQE Core | |
| Expense Items list | BQE Core | |
| Locations list | BQE Core | |
| Terms list | BQE Core | |
| Vendor list | Bill.com | |
| Transaction Data | ||
| Existing Unpaid Bills |
Bill.com |
|
| Existing Unapplied Vendor Credits |
Bill.com |
|
| Pending Payments | Bill.com |
Step 3: Review the Source of Truth lists.
Review lists for accuracy and completeness. Now is a good time to merge duplicate vendors or clean up the Chart of Accounts. Please add the bank account Bill.com Money Out Clearing to your Chart of Accounts. These lists will be synced to the other system as noted by your selection in the table above.
Step 4: Connect systems using Integrations
Step 5: Batch Update all vendors to have a default A/P account assigned.