Skip to main content

AR Invoices (Owner Invoices)

Agave Sync allows you to import Procore Owner Invoices to Sage Intacct AR Invoices and vice-versa.

Visual Mapping​

Subcontractor AR Invoices​

Procore and Sage Intacct Visual Mapping

Procore and Sage Intacct Visual Mapping

Procore and Sage Intacct Visual Mapping

Common Errors and FAQs​

How are the subtotal and retention amounts calculated for each Line Item?​

Subtotal Amount​

Agave Sync calculates the subtotal for a Procore Owner Invoice Line Item using this formula:

subtotal = work_completed_this_period + materials_moved + (materials_presently_stored - materials_previously_stored on the last Owner Invoice)

This ensures the subtotal reflects only the new work and materials completed or stored during the current billing period, by subtracting any materials already reported on the previous invoice.

Retention Amount​

Agave Sync calculates the retention amount for a Procore Owner Invoice Line Item as:

retention = work_completed_retainage_retained_this_period + materials_retainage_retained_moved + (materials_stored_retainage_retained_this_period - materials_preivously_stored_retainage_retained_this_period on the last Owner Invoice)

This formula accounts for new retainage amounts held during the current period, including any adjustments for materials that have moved categories (e.g., from stored to installed), while subtracting retention already reported in prior periods to avoid duplication.

Configuration in Sage Intacct​

Order Entry Transaction Definition for AR Invoices​

Configure a single Order Entry Transaction Definition in Sage Intacct for AR Invoices. You can find or configure these under Order Entry → Setup → More → Transaction Definitions.

The template name is flexible; the required settings are:

  • Workflow category: Invoice
  • Enable job contract billing: selected

Sage Intacct AR Invoice Order Entry Transaction Definition

Default Item ID for AR Invoice Line Items​

Since Procore does not assign Item IDs for AR Invoices, provide a single default Item ID that corresponds to a contract revenue GL Account. Your Agave Account Manager can apply this default for you.