Enhanced interface

Tips for reconciling reports with inter-entity bill back transactions

Inter-entity bill back transactions might impact your reconciliations when you run the following reports:

AP Ledger
Supplier Aging
AR Ledger
Customer Aging

Here are tips to help make your reconciliations easier.

Use entity-mapped customers and suppliers exclusively for bill back transactions

We recommend that you set up suppliers and customers to use exclusively for inter-entity bill back transactions only. This will help you identify your bill back transactions when you run reports and distinguish bill back transactions from other transactions.

Create bill back customer and supplier types to filter when you run reports

Subscription	Accounts Receivable Accounts Payable
User type	Business
Permissions	Customer Type: List, Add Vendor Types: List, Add
Configuration	Multi-entity company
Prerequisites	Set up inter-entity bill back

Create a customer type specific for bill back customers.
How to create a customer type.
1. Go to Accounts Receivable > Setup > Customers and select Add (circle) next to Types.
2. Enter a Name for the customer type.
  
  For example, you can name it Bill back customers.
3. Leave the Status set to Active.
  
  You cannot assign customers to customer types that are Inactive.
4. Select Save.
Assign this customer type to all bill back customers associated with an entity.
How to assign a customer type.
1. Go to Accounts Receivable > All > Customers.
2. Find the customer associated with an entity.
3. Select More actions > Edit at the end of the row.
4. On the Additional information tab, select the bill back customer type from the Type ID dropdown.
5. Select Save.
6. Repeat these steps for each customer associated with an entity.
Create a supplier type specific for bill back suppliers.
How to create a supplier type.
1. Go to Accounts Payable > Setup > Suppliers and select Add (circle) next to Types.
2. Enter a Name for the supplier type.
  
  For example, you can name it Bill back suppliers.
3. Leave the Status set to Active.
  (You cannot assign suppliers to supplier types that are Inactive.)
4. Select Save.
Assign this supplier type to all bill back suppliers associated with an entity.
How to assign a supplier type.
1. Go to Accounts Payable > All > Suppliers.
2. Find the bill back supplier.
3. Select More actions > Edit at the end of the row.
4. On the Additional information tab, select the bill back supplier type from the Type ID dropdown.
5. Select Save.
6. Repeat these steps for each supplier associated with an entity.

Create a customer type specific for bill back customers.
How to create a customer type.
1. Go to Accounts Receivable > Setup > Customers and select Add (circle) next to Types.
2. Enter a Name for the customer type.
  
  For example, you can name it Bill back customers.
3. Leave the Status set to Active.
  
  You cannot assign customers to customer types that are Inactive.
4. Select Save.
Assign this customer type to all bill back customers associated with an entity.
How to assign a customer type.
1. Go to Accounts Receivable > All > Customers.
2. Select Edit beside the bill back customer.
3. On the Additional information tab, select the bill back customer type from the Type ID dropdown.
4. Select Save.
5. Repeat these steps for each customer associated with an entity.
Create a supplier type specific for bill back suppliers.
How to create a supplier type.
1. Go to Accounts Payable > Setup > Suppliers and select Add (circle) next to Types.
2. Enter a Name for the supplier type.
  
  For example, you can name it Bill back suppliers.
3. Leave the Status set to Active.
  
  (You cannot assign suppliers to supplier types that are Inactive.)
4. Select Save.
Assign this supplier type to all bill back suppliers associated with an entity.
How to assign a supplier type.
1. Go to Accounts Payable > All > Suppliers.
2. Find the bill back supplier.
3. Select Edit.
4. On the Additional information tab, select the bill back supplier type from the Type ID dropdown.
5. Select Save.
6. Repeat these steps for each supplier associated with an entity.

When you run an aging or ledger report, use these customer and supplier types to filter for inter-entity bill back transactions.

Use filters to subtract bill back transactions from your reconciliation amount

Subscription	Accounts Payable Accounts Receivable
User type	Business
Permissions	AP Ledger: Run Supplier aging reports and graphs: Run AR Ledger: Run Customer aging reports and graphs: Run
Configuration	Multi-entity company
Prerequisites	Set up inter-entity bill back

Follow these steps for the report that you want to reconcile.

Run the report as usual to find the overall report balance.
Run the report again, this time filtering for the bill back supplier or customer type only.

This gives you the net amount for inter-entity bill back transactions.
Subtract the net amount for inter-entity bill back transactions from the overall report balance.

This total should match the amount to reconcile in either the Accounts Payable or Accounts Receivable configured GL offset accounts, depending on the report you run.