Reconciliation

Go to: Customization > Scripting > Scripts

There is several Scripts within NetSuite, so not all of these are related to the reconciliation process. Go to the script that has the name “Recon.js” and click either view or edit. Then there is a tab called “Execution log” and here you can find the log entries related to the funding’s files and funding files alone. 

These log entries are needed when you have any problems with the reconciliation and need to contact AltaPay support.

Setting up reconciliation in NetSuite

To ensure that reconciliation entries related to orders are populated on the correct accounts, you must have a custom record for each active AltaPay Payment processing profile in NetSuite

AltaPay reconciliation > Reconciliation Setup > Setup Accounts.

Subsidiary

Select the same subsidiary “Account for Payment and refunds” is related to

Terminal Name

The terminal name must match the terminal on which orders need to be reconciled

ACCOUNT FOR PAYMENT AND REFUNDS

select the account where entries are related to the order (payment, refund)

Other Asset Id

Select the account where entries are related to the flow of the transactions (refund/payment rejected, chargebacks (representment, pre arbitration)) that isn’t capture/refund

Transaction Type – Sales Orders

Select the relevant record types that are related to Sales order

Transaction Type – Refund

Select the relevant record types that are related to refund

 

There are also reconciliation entries that are not related to an order and need to be populated on a different account. Here you would need to add these record types and decide which account they should be populated on. This can be done here:

AltaPay reconciliation > Reconciliation Setup > Setup record type.

Then add these (these are case sensitive):

  • rolling
  • fee
  • adjustment
  • roundoff
  • not_found

Payment method:

Go to: Setup -> Accounting -> Accounting lists 

Here the AltaPay payment methods should have the setting: “GROUP WITH UNDEPOSITED FUNDS”.

Uploading Funding Files

Download the funding files from the gateway. These can be found here: Finances > Funding files. Download the files that you want to reconcile.

Log in into NetSuite and then go to: AltaPay reconciliation > Import data > Upload files.

Click on the “Select file” and select a funding file that has been downloaded from AltaPay.

When the funding file is successfully uploaded, there will be a message “Funding files successfully handled” and there will be an option to upload another funding file. If the funding data couldn’t be populated within NetSuite, log entries will be shown, leading up to the error. For further details, see the log files.