Skip to content

Import guide for your accountant — Money S3 XML

Hand this document to your accountant together with the generated XML file. It describes the procedure for importing Money S3 XML transfers into the program Money S3 (UTF-8 encoding).

Prerequisites

  • A working installation of Money S3 (the currently published version) on a Windows workstation.
  • A target accounting agenda with the standard Czech chart of accounts for businesses (311, 321, 343, 518, 602, …).
  • The export file downloaded from Danito (name typically money-RRRR-MM.xml or similar).

Import guide

  1. In Money S3, open the target accounting agenda.
  2. File → Tools → XML transfers → Load XML (or Agenda → Accounting → XML transfers → Import depending on the Money S3 version).

Placeholder for a screenshot.

  1. Select the exported .xml file.
  2. Confirm that the XML transfers version is recognised (version="1.0", root element <MoneyData>, encoding UTF-8).
  3. Click “Load” and capture any warnings or errors (screenshot or exact text + Money S3 error code).

Placeholder for a screenshot.

Checks by agenda

a) Issued invoices

Documents of type INVOICE are imported into the Issued invoices agenda. For each randomly selected record, check that:

  • The business partner / Addressee (company, VAT ID (DIČ), country) matches the content of the <Adresat> element (<Firma>, <DIC>, <Stat>).
  • The date of issue, VAT supply date and accounting-case date match the values <DatVyst>, <DatPlnenDPH>, <DatUcPr> (all derived from the supply date in Danito).
  • The VAT breakdown matches the Money S3 code (UD domestic output, DD EU B2B output or reverse charge — EU, VS output to a third country, UN outside the scope, third country).
  • The MD / Dal posting in the accounting entry matches the mapping (default 311 / 602 for domestic output or an override from the mapping editor in Danito).
  • The Currency / Exchange rate / Currency quantity for foreign invoices (EUR / USD etc.) matches <Mena>, <Kurz>, <MnozMen>. The values CelkemCM and ZakladCM / DPHCM in <DPHTab><DPHTabRow> show the amounts in the foreign currency.

b) Received invoices

Documents of type COST_DOCUMENT are imported into the Received invoices agenda. VAT breakdown: PK (reverse charge — EU), PZ (reverse charge — third country), PD (domestic input), UN (input from a non-payer). The addressee is in the <Dodavatel> element instead of <Adresat>. The default posting for domestic input is 518 / 321.

c) Internal documents

Documents of type PLATFORM_INCOME (income from platforms) are imported as Internal documents. Check that:

  • The header has <DatVyst> filled in and the VAT breakdown UN (output from a non-payer).
  • The MD / Dal posting reflects the stamped account (default for platform income 311 / 602).
  • The <Doklad> field contains the row identifier (Money S3 uses it as the document number; if the platform does not provide its own document number, a fallback identifier is placed here).
  • The element for the counterparty is called <Partner> (not <Adresat> nor <Dodavatel>).

VAT check

For each VAT rate present in the export (0%, 12%, 21%), verify that:

  • In <DPHTab><DPHTabRow>, for rows with the 21% rate, <Zaklad> and <DPH> match the Base / VAT columns in Danito.
  • For rows with the 12% rate, <SazbaDPH> has the value 12.00 and <DPH> the corresponding amount.
  • For rows with a zero rate (typically reverse charge and outside the scope of VAT), <SazbaDPH> has the value 0.00 and <DPH> is 0.00 CZK.

Diacritics and UTF-8

Money S3 XML transfers use UTF-8 encoding (the XML header declares <?xml version="1.0" encoding="UTF-8"?>). Diacritics should not present any problem, but open a random record with Czech diacritics anyway and verify that:

  • Addressee / Company displays everything without lost characters (no ? nor empty spaces in place of háčky / čárky).
  • Document number displays including uppercase letters with a háček (e.g. Š, Č, Ž).

If the diacritics are lost, the problem is most likely in the Money S3 import dialog (an incorrectly chosen or automatically detected encoding). The file is always in UTF-8 without BOM.

What to do on an import error

If Money S3 reports an error during import or one of the checks above fails, record:

  • The path to the field in Money S3 (e.g. Issued invoices → Header → VAT ID (DIČ) or XML transfers module → import log).
  • The expected value (from the corresponding row in Danito or directly from the XML file).
  • The value imported into Money S3.
  • The Money S3 version (e.g. Money S3 26.000) and the database type (SQL / FoxPro).
  • Any Money S3 error message (code + text).

Placeholder for a screenshot of the error message.

Send this information to the Danito user, who will pass it on to support. For typical errors (an incorrectly set VAT breakdown, an account not existing in the chart of accounts) the fix is in the Money S3 chart of accounts or in the account mapping editor in Danito.