Importing POs / Actuals


POs and Actuals can be viewed and compared with the Planned and Forecasted spend in the Activity Plans. This gives the marketer visibility into their marketing spend and lets them know how they align with their top-down allocation, ensuring they do not go over or under their allocated spend. Importing POs and Actuals helps marketing organizations link Planned Spend to Actual Spend.

  1. On the Home tab, click Import and select your desired option from the drop-down menu
  2. On the Import window, click the Import Location drop-down menu and select the Folder, Sub-folder or Activity Plan that you would like to import into
  3. Browse to choose the File To Import
    Note: If you have prepared a template, click the Choose import template drop-down menu to select your desired template for this import
  4. Click Next
  5. Assign Fields and match your spreadsheet column headers to the associated import fields by selecting from the drop-down list. Select the Date Format and click Next
    Note: If the POs have both start and end dates, and the PO amount should be split across the date range, select the Amortize POs checkbox. After importing, POs will be allocated to the chosen date range. If there is no end date, and the PO should be split across a date range after the import is complete users can manually edit the PO through the PO Panel.
  6. Match your desired spreadsheet fields in the Duplicate Matching Field(s) Column then click Next
    Note: Marketers can import an updated version of a PO or Actual that already exists in the application. You need to select fields which never change using the Duplicate Matching Field(s) Column to identify a record that exists in Allocadia. The unselected fields will be updated.
  7. Apply Rule(s) once you have established your mapping rules
  8. Click the Action button and select Import from the drop-down sub-menu
    Note: If you would like to save your settings as an Import Template, select Import and Save Template As from the drop-down sub-menu.
    Tip: After Import, you can review which items in your spreadsheet were mapped, left unmapped, or considered duplicates by clicking the Import History icon on the Home tab in line with the Folder, Sub-folder or Activity Plan that you imported into.
For more information, please see the article Preparing Spreadsheets for PO/Actuals Import
Was this article helpful?



Please sign in to leave a comment.