How To Import Credit Card Transactions Into Netsuite

by

NetSuite offers robust capabilities for managing your business operations, from financials and inventory to customer interactions. A notable advantage of using NetSuite is its functionality for directly importing credit card transactions into the platform. This feature streamlines your processes, saving valuable time and minimizing the potential for mistakes by removing the necessity of manual data input.

Step 1: Set Up Your Credit Card Processor

The first step in importing credit card transactions into NetSuite is to set up your credit card processor. This will allow you to connect your payment gateway to NetSuite and automatically import transaction data.

Setting Up Authorize.Net

If you use Authorize.Net as your payment gateway, you can follow these steps to set up the integration with NetSuite:

  1. Log in to your Authorize.Net account and navigate to the “Settings” tab.
  2. Click on “API Login ID and Transaction Key” and generate a new key if necessary.
  3. Copy the API Login ID and Transaction Key and save them for later use.
  4. Log in to your NetSuite account and navigate to “Configuration > Integration > Web Services.”
  5. Click on “New” and select “Authorize.Net” as the integration type.
  6. Enter your Authorize.Net API Login ID and Transaction Key in the appropriate fields.
  7. Save the integration settings and test the connection to ensure it is working properly.

Setting Up PayPal

If you use PayPal as your payment gateway, you can follow these steps to set up the integration with NetSuite:

  1. Log in to your PayPal account and navigate to “Profile” > “My Selling Tools.”
  2. Click on “Update” next to “API Access” and generate a new API signature if necessary.
  3. Copy the API username, password, and signature and save them for later use.
  4. Log in to your NetSuite account and navigate to “Configuration > Integration > Web Services.”
  5. Click on “New” and select “PayPal” as the integration type.
  6. Enter your PayPal API username, password, and signature in the appropriate fields.
  7. Save the integration settings and test the connection to ensure it is working properly.

Step 2: Import Your Transactions

Once you have set up your credit card processor, you can begin importing your transactions into NetSuite. This process will vary depending on the payment gateway you use, but in general, you will need to log in to your payment gateway account and export a CSV file containing your transaction data.

Importing Transactions from Authorize.Net

If you use Authorize.Net as your payment gateway, you can follow these steps to import your transactions into NetSuite:

  1. Log in to your Authorize.Net account and navigate to the “Transactions” tab.
  2. Click on “Export Transaction Data” and select the date range you want to export.
  3. Select “CSV” as the file format and click “Export.”
  4. Save the CSV file to your computer and log in to your NetSuite account.
  5. Navigate to “Transactions” > “Import Transactions” and select “Authorize.Net” as the integration type.
  6. Click on “Browse” and select the CSV file you exported from Authorize.Net.
  7. Map the fields in the CSV file to the corresponding fields in NetSuite and click “Import.”

Importing Transactions from PayPal

If you use PayPal as your payment gateway, you can follow these steps to import your transactions into NetSuite:

  1. Log in to your PayPal account and navigate to “Reports” > “Download Report.”
  2. Select the date range you want to export and click “Export.”
  3. Save the CSV file to your computer and log in to your NetSuite account.
  4. Navigate to “Transactions” > “Import Transactions” and select “PayPal” as the integration type.
  5. Click on “Browse” and select the CSV file you exported from PayPal.
  6. Map the fields in the CSV file to the corresponding fields in NetSuite and click “Import.”

Step 3: Review Your Transactions

Once you have imported your transactions into NetSuite, it is important to review them to ensure they are accurate and complete. You can do this by navigating to “Transactions” > “View Transactions” in NetSuite and selecting the appropriate filters to view your imported transactions.

Reviewing Authorize.Net Transactions

If you use Authorize.Net as your payment gateway, you can follow these steps to review your transactions:

  1. Log in to your NetSuite account and navigate to “Transactions” > “View Transactions.”
  2. Select “Authorize.Net” as the integration type and click on “Apply Filter.”
  3. Review the transactions that have been imported into NetSuite and compare them to your Authorize.Net account to ensure they are accurate.
  4. If you notice any discrepancies, investigate the cause and take appropriate action to resolve the issue.

Reviewing PayPal Transactions

If you use PayPal as your payment gateway, you can follow these steps to review your transactions:

  1. Log in to your NetSuite account and navigate to “Transactions” > “View Transactions.”
  2. Select “PayPal” as the integration type and click on “Apply Filter.”
  3. Review the transactions that have been imported into NetSuite and compare them to your PayPal account to ensure they are accurate.
  4. If you notice any discrepancies, investigate the cause and take appropriate action to resolve the issue.

Conclusion

Importing credit card transactions into NetSuite can save you time and reduce errors by eliminating the need for manual data entry. By following these steps, you can set up your payment gateway, import your transactions, and review them to ensure they are accurate and complete.