Previous

Importing PSP payments

  • 3 min.

Continia Banking allows you to directly import these payment files into the Cash Receipt Journal, streamlining reconciliation and reducing manual data entry. Automate the matching of payments to ledger entries, gain visibility into PSP fees and payment streams and save time and reduce errors in financial processes.

Scenario

Ester, the company admin is ready to import an existing Paypal payout into the PSP cash receipt journal, let's see how she does the following:

  • Selects the correct file batch.
  • Imports a PSP file.
  • Reviews and verifies correct line item allocations.

Mark the cash receipt journal as a PSP journal, you only do this once per journal.

  1. Search Cash Receipt Journals and open the page.
  2. Click the three dots in the Batch Name field to open General Journal Batches.
  3. Pick the batch you want to use and enable Payment Service Provider Journal. If no agreement exists yet, you'll be prompted to create one.
  4. From the action bar, choose Import PSP Payments.
  5. In the Import Payments dialog, the PSP Agreement is preselected. Optionally, add a manual document number to identify the import in the journal. Toggle Create balance line per posting date if you want one balancing line per payout date.
  6. Click OK and choose the file. Continia hands the file to its CSV port and writes the lines straight into the cash receipt journal.

Tip

From the action bar, open Actions > Journal Statistics to see totals broken down by customer, bank account, currency, and G/L account before you post. It's a fast sanity check before you commit

Review and Verify

Successful matching happens when the External Payment Reference on the imported line equals the External Payment Reference on a sales document or open customer ledger entry. You'll see this in two places:

  • On each journal line the customer is filled in and the line applies to the open invoice.
  • On the ledger entry pages the PSP External References FactBox shows the PSP code and the original reference once a payment has been imported and applied.

Lines that don't match automatically stay open in the journal. Common reasons and how to handle them

  • Reference mismatch: The format on the file differs from the ledger entry. Check the External Reference Rule Template.
  • Posting date drift: Increase Posting Date Tolerance on the agreement.
  • Missing customer: The line has no matching ledger entry. Either create the missing entry or fall back to the Default Customer No. set on the agreement and apply manually.

Post the journal

Banking PSP

Once you're happy with the lines, post the journal as you would any other cash receipt journal. The customer ledger entries close, the fees land on the right G/L accounts, and your bank balancing line offsets the actual payout.