Money S3: invoice import and export

1. Move invoices from the portal into Money S3

Download received and issued invoices in bulk for a chosen period, or one at a time from the invoice detail.

1. 1
   In the portal open Exports (left menu, address /dashboard/exports). Choose the company; if you like, narrow the period From date / To date and the direction (Received and sent, Received only, Sent only).
2. 2
   In the Accounting software formats section click Download on the Money S3 (.zip) tile. The file peppol-money-s3.zip downloads.
3. 3
   Unzip the file. It contains:

   • money.xml – issued invoices (the SeznamFaktVyd list)
   • money_fp.xml – received invoices (the SeznamFaktPrij list)
   • money_adr.xml – partner address book (the SeznamFirem list)
   • _preskocene.txt – documents the format cannot carry, with the reason for each
4. 4
   In Money S3 open Agenda → Výměna dat XML (or the XML přenosy button directly in the Faktury vydané / Faktury přijaté list) → the Import wizard. Names follow the Czech Money S3 user manual (chapter XIII XML přenosy, version 24.900); the Slovak edition has the same menu in Slovak. Load the standard import definitions with the Připravený seznam button. On import choose money.xml for issued invoices, money_fp.xml for received invoices and money_adr.xml for the address book. Source: vendor documentation ↗
5. 5
   If a document is missing, look into _preskocene.txt: every omitted document has its reason there (see What the format cannot carry). Nothing is left out silently.

One invoice: in the invoice detail, section Accounting data, use Export this document to… and pick Money S3. A selection: tick documents in the invoice list, choose Money S3 in the Accounting software field of the bar below the list and click Download.

2. Send invoices issued in Money S3 through Peppol

You keep issuing invoices in your program. You upload its export to the portal and the portal delivers them to your customers through the Peppol network, with a delivery receipt and the report to the Financial Administration.

1. 6
   In Money S3 open Faktury vydané → select the documents with a filter → the XML přenosy button → the Export wizard (or Agenda → Výměna dat XML). The result is a MoneyData document with the SeznamFaktVyd list, which the portal reads. Source: vendor documentation ↗
2. 7
   In the portal open Send e-invoice and the Bulk send tab; the direct link /dashboard/invoices/new?tab=bulk opens the tab with the Money S3 tile already selected. Otherwise click the tile and choose Select.
3. 8
   Choose the Company (sender) and upload the exported files; you can select several at once. The portal imports only invoices you issued (supplier = your company); received invoices in the same file are skipped.
4. 9
   Check the preview: the portal reads the lines, recalculates the totals the same way as for a manually issued invoice and compares them with the totals in the file. If they differ by even a cent, the invoice gets an error and does not leave; fix it in the program and export again. The customer must be in the Peppol network, which you check on /overenie.
5. 10
   Click Send. Invoices leave one by one; the status and the delivery receipt are shown under Invoices – sent.

3. What the format cannot carry

The export never guesses values that the Money S3 format has nowhere to store. Such a document is listed in _preskocene.txt with the reason and stays available in the portal as PDF and original XML.

• a document in a foreign currency (the program would need an exchange rate the invoice does not carry)
• a document with an advance payment offset against it
• a document with three or more non-zero VAT rates (the Money S3 header has one reduced and one standard rate)