Sage 50 CA General Journal XML

The following tasks use the Sage 50 CA Sales Order XML format.

Tasks

• Exporting General Journals from Sage 50 CA
• Importing General Journals into Sage 50 CA

XML Overview

Any Sage fields not documented below are not supported with our imports/exports. Examples of where in the XML the fields should appear are shown in the samples below.

Minimal General Journal File

<?xml version="1.0" encoding="utf-8"?>
<GeneralJournals xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <GeneralJournal>
    <Source>121</Source>
    <LineItems>
      <LineItem>
        <Account>18550</Account>
        <Credit>2500</Credit>
      </LineItem>
      <LineItem>
        <Account>56600</Account>
        <Debit>2500</Debit>
      </LineItem>
    </LineItems>
  </GeneralJournal>
</GeneralJournals>

Complete General Journal File

<?xml version="1.0" encoding="utf-8"?>
<GeneralJournals xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <GeneralJournal>
    <ExternalId>5230</ExternalId>
    <Source>121</Source>
    <Date>2024-07-31T00:00:00</Date>
    <Comment>Month end entries</Comment>
    <Currency>USD</Currency>
    <ExchangeRate>1.523</ExchangeRate>
    <LineItems>
      <LineItem>
        <Account>18550</Account>
        <Credit>2500</Credit>
        <Comment>Building</Comment>
      </LineItem>
      <LineItem>
        <Account>56600</Account>
        <Debit>2500</Debit>
        <Comment>Amortization</Comment>
      </LineItem>
    </LineItems>
    <AdditionalInfo>
      <AdditionalDate>2026-06-02T00:00:00</AdditionalDate>
      <AdditionalField>Test</AdditionalField>
    </AdditionalInfo>
  </GeneralJournal>
</GeneralJournals>

In each of the following sections most of the XML has been omitted to make the samples easier to read. The whole structure of the GeneralJournals schema is used below as a reference of where fields should be in the object model.

Header Information

The following fields can be populated at the header level of the general journal record.

When importing general journals into Sage, we recommend that the ExternalId field be populated by the unique id of the general journal from the external system. Zynk uses this field to track general journal already imported into Sage, and it can be used in conjunction with the Prevent Reprocessing task setting to prevent duplicate general journals being created in Sage.

Sage Field	XML Field	Field Type	Input	Notes
-	ExternalId	string(255)	Optional	Provide the ID of the general journal from the source system
Source	Source	string(20)	Required
Date	Date	datetime	Optional	Will default to the current date if not specified
Comment	Comment	string(75)	Optional
Currency	Currency	string(3)	Optional	Will default to the base currency if not specified
Exchange Rate	ExchangeRate	double	Optional	Will default to the stored rate if not specified

<?xml version="1.0" encoding="utf-8"?>
<GeneralJournals xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <GeneralJournal>
    <ExternalId>5230</ExternalId>
    <Source>121</Source>
    <Date>2024-07-31T00:00:00</Date>
    <Comment>Month end entries</Comment>
    <Currency>USD</Currency>
    <ExchangeRate>1.523</ExchangeRate>
  </GeneralJournal>
</GeneralJournals>

Line Items

The following fields can be populated at the line level of the general journal record. The total amount debited and total amount credited must match.

Sage Field	XML Field	Field Type	Input	Notes
Account	Account	string(8)	Required
Debit	Debit	double	Dependant	Either Debit or Credit must be specified
Credit	Credit	double	Dependant	Either Debit or Credit must be specified
Comment	Comment	string(75)	Optional

<?xml version="1.0" encoding="utf-8"?>
<GeneralJournals xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <GeneralJournal>
    <LineItems>
      <LineItem>
        <Account>18550</Account>
        <Credit>2500</Credit>
        <Comment>Building</Comment>
      </LineItem>
      <LineItem>
        <Account>56600</Account>
        <Debit>2500</Debit>
        <Comment>Amortization</Comment>
      </LineItem>
    </LineItems>
  </GeneralJournal>
</GeneralJournals>

Additional Information

The following fields can be populated on the additional information screen.

Sage Field	XML Field	Field Type	Input	Notes
Additional Date	AdditionalDate	datetime	Optional
Additional Field	AdditionalField	string(75)	Optional

<?xml version="1.0" encoding="utf-8"?>
<GeneralJournals xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <GeneralJournal>
    <AdditionalInfo>
      <AdditionalDate>2026-06-02T00:00:00</AdditionalDate>
      <AdditionalField>Test</AdditionalField>
    </AdditionalInfo>
  </GeneralJournal>
</GeneralJournals>