Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Export billing report from Adobe Sign: Reports > Create a new report > Set Creation Date to Last Month > Run Report

  2. Save Report (using a name containing the scoped month/year), then Export report data

    1. Wait a bit while report is generated, go back to main Reports screen, reload, will appear under My Export Report Data

  3. Download the CSV fileformatted report

  4. Use Excel to clean up the report to remove rows that don’t represent billed transactions from Adobe Sign

    1. Open CSV in Excel and Save As Excel Workbook

    2. Create new column A, copy

    3. Copy formula =AND(G2=V2,W2="",H2<>"Default Group",BQ2<>"FORM_FILLER") to all rows into cell A2

    4. Copy cell A2 to entire column A

    5. Select whole sheet, select Advanced Filter

    6. Filter on new column A, including only FALSE

    7. Filter on Agreement Status, including only Canceled, Completed, In Process

    8. Find & Select > Go To Special > Visible cells only

    9. Copy and Paste selected rows into a new Sheet

    10. Save As new CSV file (containing just the new Sheet, which is just the filtered rows we want to bill)

  5. Import into PCR-360 (Admin > Imports / Exports > Import Files > Import Files)

    1. Test import: Upload File(s) > search for “adobe” in Import File Format > Test Import File > select filtered file

      1. Wait a bit while file is processed, watch for green checkmark under Processed & total rows under Added Count

    2. Real import: Upload File(s) > search for “adobe” in Import File Format > Upload Import File > select filtered file

      1. Wait a bit while file is processed, watch for green checkmark under Processed

...