Create an AR sales invoice with inter-entity bill back

Inter-entity bill back enables handling the following use case:

  • One entity provides goods or services to another entity.

  • You must generate an AR sales invoice and corresponding AP purchase invoice.

When you create an AR sales invoice for bill back, select the following:

  • A customer that's associated with an entity (in the entity record).

  • The Generate matching AP purchase invoice for AR sales invoice checkbox.

  • A Bill back template from the dropdown menu.

You can use the affiliate entity dimension to auto-tag the customer and supplier in your inter-entity bill back transaction. Ensure that your company is subscribed to Consolidation and the affiliate entity dimension is enabled in your company.

  1. Go to Accounts Receivable > All and select Add (circle) beside AR sales invoices.
  2. In the Customer field, select the customer associated with a bill back entity.
  3. Verify that Generate matching AP purchase invoice for AR sales invoice is selected.

    This option only appears when the customer is associated with a bill back entity.

  4. Select the template from the Bill back template dropdown.

    Some information is automatically entered in the line item detail of the AR sales invoice:

    • AR sales invoice GL account
    • Department (if you specified one)
    • Memo entered in the template
  5. Enter required information, such as due date, transaction and base currencies, and the amount.

    If the entity that's issuing the AR sales invoice uses a different base currency from the billed entity, you need to set the base and transaction currencies in the AR sales invoice.

  6. Select a Location for each line item.

    Intacct uses this dimension to determine the associated supplier for the bill back AP purchase invoice. The location for all line items must be either the same entity or share the same parent entity.

    If you select a child location or sublocation, Intacct refers to the parent entity of the location to find the associated supplier. The AP purchase invoice that Intacct creates in Accounts Payable shows the entity as the location.
  7. Select Post or Post & new.

    What happens next depends on the option you selected in your Accounts Receivable configuration.

    How AP purchase invoices are posted based on bill back configuration
    Inter-entity bill back configurationDescription
    Post bills directlyPosting the AR sales invoice automatically creates the AP purchase invoice in Accounts Payable for the invoiced entity, based on the inter-entity mapping from the template.
    Save bills as draftPosting the AR sales invoice creates a draft of the in Accounts Payable for the invoiced entity, based on the inter-entity mapping from the template.

    After the AR sales invoice is posted, the following fields in the AR sales invoice cannot be edited:

    • Account

    • Transaction amount

    • Base amount

    • Allocation

    • Department

    • Location

Next: If your company uses Taxes, add the tax solution to the bill back AP purchase invoice.

Auto-tag a bill back AR sales invoice with affiliate entity dimension

You can use the affiliate entity dimension with inter-entity bill back to auto-tag the customer and supplier in an inter-entity transaction. After you enable the affiliate entity dimension, Sage Intacct automatically records the affiliate entity dimension on AR sales invoice and AP purchase invoice detail records. The affiliate entity dimension records carry over to the General Ledger (GL) entries when you post the AP purchase invoice or AR sales invoice.

You can use this information throughout your reporting, reconciliation, and consolidation processes. This helps ensure accurate elimination during consolidation.

Use the affiliate entity dimension with inter-entity bill back under the following conditions: 

  • Accounting regulations require you to use Accounts Receivable bill back functionality instead of inter-entity transactions.

  • You want to track and report on inter-entity transactions using the affiliate entity dimension.

  1. Enable affiliate entity dimension on the Multi-Entity Management page.

  2. Use the bill back template on an AR sales invoice.

    Ensure that the customer and supplier entities are different, as this is the basis for an inter-entity bill back transaction.

  3. Enter the relevant entities in the Location column for each line item.
    The bill back template auto-populates the affiliate entity dimension as follows:

    • On the GL entry for the customer AR sales invoice, Intacct auto-populates the affiliate entity with the entity that's tied to the customer.

    • On the GL entry for the supplier AP purchase invoice, Intacct auto-populates the affiliate entity with the entity that's tied to the supplier.

Example: Auto-tagged inter-entity bill back journal entries with the affiliate entity dimension

Following is an example of a journal entry for an inter-entity bill back AR sales invoice that uses the affiliate entity dimension:

Journal entry for an inter-entity bill back AR sales invoice with auto-tagged affiliate entity dimension

Account

Dept

Location

Affiliate entity

Txn currency

Transaction debit

Transaction credit

Base currency

Base debit

Base credit

1250--IER

Marketing

E100

E101

AUD

200.00

--

AUD

200.00

 

4000--Sales

Marketing

E100

E101

AUD

--

200.00

AUD

 

200.00

In this journal entry, the affiliate entity dimension indicates that E101 is the customer entity for supplier entity E100.

Following is an example of a journal entry for the resulting bill back AP purchase invoice that uses the affiliate entity dimension:

Journal entry for an inter-entity bill back AP purchase invoice with auto-tagged affiliate entity dimension

Account

Dept

Location

Affiliate entity

Txn currency

Transaction debit

Transaction credit

Base currency

Base debit

Base credit

5000--COGS

Marketing

E101

E100

AUD

200.00

--

AUD

200.00

 

2060--IEP

Marketing

E101

E100

AUD

--

200.00

AUD

 

200.00

In this journal entry, the affiliate entity dimension indicates that E100 is the supplier entity for customer entity E101.

Next: If your company uses Taxes, add the tax solution to the bill back AP purchase invoice.