To enable Payout Reconciliation, navigate to PayPack → Setup → Configuration.
- Check the Update Configuration checkbox
- Click on the Payout Reconciliation Subtab
- Check the Enable Payout Reconciliation checkbox
- Select NetSuite Bank Deposit Account
- Select NetSuite Account to Track Stripe Fee
- Select NetSuite Account to Track Unreconciled Deposits
- Enter Stripe Charge Field ID (optional for custom field)
- Enter Stripe Refund Field ID (optional for custom field)
- Enter JSON data for Deposit Field Mapping
- Select the Filter Payouts by Status (optional)
- Select the Filter Payouts by Date Parameter
Filter Payouts by Status
In the PayPack configuration → Payout Reconciliation, users will find a dropdown Filter Payouts by Status. This is an optional configuration and will grab all statuses by default when field value is not set.
- Blank (default) - Returns all payout statuses including failed and canceled.
- Pending - The payout is waiting to be sent to the bank.
- Paid - The transaction was successful and the funds have been transferred to the merchant's bank account.
- Failed - The bank was unable to receive the funds and they were sent back to Stripe.
- Canceled - The payout was canceled, usually by the seller or Stripe.
Filter Payouts by Date Parameter
For the flexibility and accuracy of payout management, this feature allows businesses to retrieve payouts from Stripe by either the created or arrival date.
In the PayPack configuration → Payout Reconciliation, users will find a dropdown Filter Payouts by Date Parameter. This dropdown allows users to select either "Created Date" or "Arrival Date" for filtering payouts.
Once a selection is made and saved in the configuration, the payout retrieval script will use the chosen parameter to fetch payouts accordingly. If no selection is made, the system will default to using the created date for fetching payouts from Stripe.
- Created (default) - Only return payouts that were created during the given date interval.
- Arrival Date - Only return payouts that are expected to arrive during the given date interval.