Table of Contents

Bulk Reconciling Transactions

Jennifer Sneider Updated by Jennifer Sneider

All users can access this feature.

Bulk Reconciling Transactions to SOS Inventory

Note: This links multiple Transactions to existing Assets. All selected Transactions will be linked to all selected Assets.
  1. While logged in to your Series/Feature, click Transactions on the top navigation bar.
  2. Select your Transaction(s) using the checkboxes on the left.
  3. Click Bulk Reconcile > Match - SOS Inventory. This allows you to match the selected Transactions to Inventory imported from Crew Tools and found on the For Review tab of the Asset Index.
  4. On the next page, use the filter options to find the existing Asset(s) to match to your Transactions.
  5. When you find the Asset(s), select them using the checkboxes on the left.
  6. Choose how you want to assign the Cost (USD) value:
    1. By default, the Cost (USD) value automatically updates to the sum of all Transactions linked to the Asset.
    2. Check the box next to Keep Total shown in Cost (USD) to override the default and use the value displayed in that field.
      To manually update the Cost (USD) value, hold down shift on your keyboard and click the Cost (USD) field for the Inventory item you are matching to your Transaction(s). Press Return to save the value. This will allow you to update the cost displayed to reflect the total cost of the Transaction(s). 
Note: The difference in cost between the Asset and Transaction will be listed at the top of the page.
  1. When you are satisfied with the match, click Match.
  2. A green notification will appear at the bottom of the screen to confirm your match and you will be redirected to the Transactions Index. If all required fields are complete, the Asset will move to the Assets Index. If not, you will need to update the Asset information on the For Review tab and accept the Asset.
Pro Tip: To see a gif demonstrating how to override the default summing of Transactions, check out Matching a Transaction to SyncOnSet Crew Tools Inventory.

Bulk Reconciling Transactions To Existing Assets

Note: This links multiple Transactions to existing Assets. All selected Transactions will be linked to all selected Assets.
  1. While logged in to your Series/Feature, click Transactions on the top navigation bar.
  2. Select your Transaction(s) using the checkboxes on the left.
  3. Click Bulk Reconcile > Match - Existing Asset(s). This allows you to match the selected Transactions to existing Assets.
  4. On the next page, use the filter options to find the existing Asset(s) to match to your Transactions.
  5. When you find the Asset(s), select them using the checkboxes on the left.
  6. Choose how you want to assign the Cost (USD) value:
    1. By default, the Cost (USD) value automatically updates to the sum of all Transactions linked to the Asset.
    2. Check the box next to Keep Total shown in Cost (USD) to override the default and use the value displayed in that field.
      To manually update the Cost (USD) value, hold down shift on your keyboard and click the Cost (USD) field for the Inventory item you are matching to your Transaction(s). Press Return to save the value. This will allow you to update the cost displayed to reflect the total cost of the Transaction(s). 
Note: The difference in cost between the Asset and Transaction will be listed at the top of the page.
  1. When you are satisfied with the match, click Match.
  2. A notification will appear at the bottom of the screen to confirm that the Transactions have been successfully matched to the selected Assets.

Bulk Reconciling Transactions To A New Asset 

Note: This creates a single brand-new Asset from multiple Transactions.
  1. While logged in to your Series/Feature, click Transactions on the top navigation bar.
  2. Select your Transactions using the checkboxes on the left.
  3. Click Bulk Reconcile > Create 1 Asset. This allows you to create a new Asset with the selected Transactions.
  4. In the pop-up window, include information about your Asset and click Create Asset. Disposition is a required field and marked with an asterisk (*).
  5. A notification will appear at the bottom of the screen to confirm that the Asset has been successfully created.
  6. Now that your Asset has been created, click Assets on the top navigation bar. Find your Asset and update the cost to reflect the total cost of the Transaction(s).

How did we do?

Handling Returns

Bulk Updating

Contact