Skip to main content

Setup and Configuration

This phase covers the groundwork required before any production sync activity begins. Complete the steps in order and record progress in the onboarding tracker.

Step 0: Best practices for ServiceTitan data import

If you are new to ServiceTitan, the ServiceTitan team will migrate data such as customers and jobs from your legacy system. Agave uses the Legacy ID custom field to reconcile imported ServiceTitan records with those that already exist in your ERP, preventing duplicates.

Plan to populate Legacy IDs for:

  • Customers
  • Jobs

Confirm the field is populated prior to running the autolink process later in the project.

Step 1: Get access to Agave

  1. Share the list of required Agave users with your Agave account manager. At least one participant should be able to access both ServiceTitan and the ERP during testing.
  2. After the account manager provisions your user, reset your password:

Step 2: System connection

  1. Sign in to Agave and open ERP Sync from the left navigation to access https://app.agaveapi.com/admin/erp-sync.
  2. Review the appropriate system connection guide: https://sync-docs.agaveapi.com/docs/service-titan-and-acumatica/FAQs.
  3. Schedule a working session with your Agave account manager to finalize the connection:
    • The account manager enters the credentials and troubleshoots any permission issues.
    • Once connected, the account manager enables the required data syncs, feature flags, and sync trigger filters for the onboarding.

Step 3: Setup Integration Mappings

Agave maintains cross-system translations for business units, accounts, and additional segments. Collect mapping workbooks early so Agave can configure them before dry-run testing.

Business Unit Mapping

Map each ServiceTitan Business Unit to the equivalent ERP segment (for example, Acumatica Branches or Subaccounts, Spectrum Cost centers, Sage 100 Contractor Departments, Vista Departments).

  • Transactions and journal entries inherit the mapped ERP segment.
  • Multiple ServiceTitan business units can map to a single ERP segment if needed.

When establishing business units, choose a level of granularity that supports your ERP reporting strategy. Reference:

Share the completed mapping with your Agave account manager for configuration.

GL Account Mapping

Agave writes the GL account stored on each ServiceTitan pricebook item. Preparation is split into two parts.

Create ServiceTitan GL accounts

Create ServiceTitan GL accounts that match your ERP account numbers exactly.

Integration typeGL accounts required
DocumentIncome (AR), Expense (AP), Asset (AP)
Journal entryAll accounts used for AR invoices, AR payments, AP invoices, inventory adjustments, and inventory transfers

Confirm the accounts exist before configuring pricebook items.

Configure Pricebook Items

Ensure every service, material, and equipment item in the pricebook references the correct GL accounts.

  • When an item is flagged as inventory, populate all general ledger account fields.
  • For guidance, review Edit pricebook items.

Payment Method Mapping

Create a mapping of payment methods in ServiceTitan to your ERP.

Timecard Mapping

Schedule a meeting with your Agave account manager and payroll manager to review how Timecards map to your ERP.

Step 4: Configure auto-batching settings in ServiceTitan

Go to Settings > Accounting > Journal Entries and Auto-Batching to access the Journal Entries and Auto-Batching settings screen to enable the settings.

The table outlines the recommended settings

Transaction typeExport typeJournal entry cadenceSync frequencyBatch cadenceSeparate by business unitSeparate by payment type
InvoicesDocumentDailyN/ADailyYesN/A
Payments (Invoices)DocumentDailyN/ADailyNoNo
Applied paymentsDocumentDaily, Weekly, or MonthlyManualCannot be batchedNoNo
Bank depositsJournal Entry SummaryPer transactionManualCannot be batchedNoN/A
Vendor billsDocumentPer transactionManualDaily, Weekly, or MonthlyNoN/A
Inventory adjustmentsDocument**Daily, Weekly, or MonthlyN/ADaily, Weekly, or MonthlyNoN/A
ReturnsDocumentDaily, Weekly, or MonthlyN/ADaily, Weekly, or MonthlyNoN/A
Inventory transfersDocument**N/AN/ADaily, Weekly, or MonthlyNoN/A
ReceiptsDocument**N/AN/ADaily, Weekly, or MonthlyNoN/A

Step 5: Prepare data for a sync dry-run

Create the following records for end-to-end testing. The required data varies by integration type.

Document integrations

Data modelPrerequisitesData needed
VendorsVendor exists in ERPAt least one ERP vendor
CustomersCustomer exists in ServiceTitanAt least one ServiceTitan customer
Customer locationLocation exists in ServiceTitanAt least one customer location tied to the customer above
JobsJob type mapped to ERP segment (if applicable)At least one job for the test customer
AR invoicesGL accounts created; pricebook items mapped to income accounts; business units mappedAt least one posted AR invoice for the test customer and job; include an adjustment invoice
AR paymentsPayment methods mapped to ERPAt least one posted AR payment tied to the test invoice; consider adding a prepayment, overpayment, and refund
AP invoicesGL accounts created; pricebook items mapped to expense and asset accounts; business units mappedAt least one posted AP invoice for the test vendor; include an inventory return
TimecardsTechnicians created; timesheet activities and overtime rules (if applicable); pay periods configuredAt least one approved timecard

Journal entry integrations

Data modelPrerequisitesData needed
Journal entriesGL accounts created; pricebook items mapped to income accounts; business units mapped; auto-batching configuredAt least one journal entry in an open ERP period

Record the results of each test in the onboarding tracker and flag failures to your Agave account manager for remediation.