Importing manual transaction data in PitneyAnalytics

You can add multiple manual transactions to PitneyAnalytics by importing a CSV file with the transaction data.
Products affected: PitneyAnalytics

Use manual transactions to import transaction data from products that aren't supported directly by PitneyAnalytics. This helps you keep track of all the mailing and shipping expenses within the analytics tool, make all the transactions accountable in the system, and charge back the respective cost center.

You can add multiple manual transactions to PitneyAnalytics by importing a CSV file with the transaction data.

 

  1. Click the Analytics drop down menu.
    an-analytics-menu-manual-layered
  2. Click Accounting > Manual Transactions.
  3. Click the Add Manual transaction drop down menu and select Import.
    add manual transaction pulldown menu
  4. Download the Reference Data file and the CSV template from the Import Chargebacks dialog box. Refer to Reference data and CSV template for importing transactions for details about these files.
    Import Chargebacks dialog box
  5. Enter your manual transactions into the CSV template, using the Reference Data file to validate the enterprise data values.
  6. When you are ready to upload your transactions, click Browse in the Import Chargebacks dialog box.
  7. Navigate to your CSV file and select it.
  8. Once the file is uploaded, click Import Chargebacks. This action imports the file and generates a unique Job ID.
    Import Chargebacks showing Job ID
  9. Copy the Job ID.
  10. Click the Add Manual transaction drop down menu and select Job Status.
  11. Enter the copied Job ID to check the status of your import.
    imported transactions job status
  12. When the status (1) shows “Completed,” check for the number of failed records (2).
  13. If you find there are failed records, click the download icon (3) to export the error report.
  14. Open the report and check the error messages for missing or invalid values in any of these fields. These fields are case sensitive and should match the characters as seen in PitneyAnalytics. Refer to the Reference Data file for the correct values.
    on-import-error-report_500x51
    • Division
    • Location
    • User
    • Carrier
    • Service Level
    • Cost Account Name
  15. When you have corrected your CSV, import it again.

Related topics

UPDATED: 12 December 2023