Importing PSP payments
- 3 min.
OK, so now I've set up the PSP Agreement. Can I just see how it all works with a payout file?
Ester, Cronus Accounts Payable
Scenario
Ester, the bookkeeper, 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.
To import the PSP file:
- Search Cash Receipt Journals and open the page.
- Click the three dots in the Batch Name field to open General Journal Batches.
- 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.
- From the action bar, choose Import PSP Payments.
- 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.
- Click OK and choose the file. Continia hands the file to its CSV port and writes the lines straight into the cash receipt journal.
Consejo
You can see totals broken down by customer, bank account, currency, and G/L account before you post. From the action bar, open Actions > Journal Statistics. 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. Here are some common reasons and how to handle them:
| Problem | How to handle |
|---|---|
| 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
As soon as 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.