Neoship

COD reconciliation

Reconciling COD payments with invoices in Omega

Neoship customers also have a list of paid-out COD payments available in the shipping system. For the purpose of matching COD payments with invoices, this data can be exported in various formats. In the OMEGA invoicing system, COD payments can be matched with invoices in bulk using SEPA XML.

Reconciling COD payments with invoices in Omega

Exporting the COD files in Neoship

In Neoship, choose Zoznam vyplatených dobierok (the list of paid-out COD payments) in the left-hand menu:

Zoznam vyplatených dobierok in the left-hand Neoship menu

Then enter into the VS platby field (= the variable symbol under which the COD payments were paid into your account) the VS you can see on the statement. Another very easy way of finding the COD payments is the platba na účte filter. The list then shows all the paid-out COD payments under the given variable symbol, i.e. in the bulk payment:

Filtering paid-out COD payments by variable symbol

Then choose the Exportovať SEPA option under EXPORT — it will let you match the payments with the invoices in OMEGA automatically:

Choosing the SEPA XML export in Neoship

Importing SEPA XML in Omega and matching the COD payments

You import the SEPA XML file in the records into kniha účet v banke through import BV:

Importing a bank statement in kniha účet v banke – Omega

From the options choose SEPA XML and upload the file you downloaded from Neoship:

Choosing the SEPA XML format during the import in Omega – step 1
Uploading the SEPA XML file in Omega – step 2
Processing the imported payments in Omega – step 3
Overview of the imported payments in Omega – step 4

Finally, one crucial thing remains to be done: the imported SEPA XML file also contains the bulk payment itself, which needs to be deleted. Once it is deleted, all that is left is to check the turnover and the balance of the bank statement:

Checking the bank statement after deleting the bulk payment in Omega

This is how you can very easily match COD payments (even though they arrived in your account as a bulk payment) with your issued invoices.

Need help with the setup?

We will get back to you within 24 hours and help you roll it out in your e-shop.