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.
| Subscription | Accounts Receivable Accounts Payable |
|---|---|
| User type | Business |
| Permissions | AR sales invoices: View, Edit, Add |
| Configuration | Multi-entity shared company |
| Prerequisites | Make sure you've set up the necessary permissions to create AP purchase invoices directly in the second entity. |
| Restrictions |
|
| Previous step | Set up inter-entity bill back |
- Go to Accounts Receivable > All and select Add (circle) beside AR sales invoices.
- In the Customer field, select the customer associated with a bill back entity.
- 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.
- 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
- 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.
- 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. - 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 configuration Description Post bills directly Posting 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 draft Posting 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.
| Subscription | Accounts Receivable Accounts Payable Multi-Entity > Affiliate entity dimension Consolidation |
|---|---|
| User type | Business |
| Permissions | AR sales invoices: View, Edit, Add |
| Configuration | Multi-entity shared company |
| Prerequisites | Make sure you've set up the necessary permissions to create AP purchase invoices directly in the second entity. |
| Restrictions |
|
| Previous step | Set up inter-entity bill back |
Enable affiliate entity dimension on the Multi-Entity Management page.
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.
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:
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:
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.
