Ways to Transfer Your Accounting Data

Export via Reports

Export accounting data into a CSV file, edit that file as needed, and then import it into the destination system. We recommend this method when you want to review accounting data before import.

To have the latest accounting data, you can start the Accounting Subledger job manually to generate transaction journal records.

Refer to your accounting software's documentation for information on required data and formatting.

Integration

There are multiple ways to import Accounting Subledger's data automatically into your accounting system.

• Develop a custom integration solution to send or retrieve accounting data on a defined cadence, typically using Apex on the Salesforce side. Some accounting software allows for code execution on the same server.
• Use a middleware solution (such as Mulesoft) that moves data between systems automatically.
• Some accounting systems are built directly on the Salesforce platform. Additional development can be required to ensure data compatibility.

You can automate as much or as little of the process as you like. If you're not sure where to begin, contact Salesforce Customer Support for recommendations on partners experienced in automation, specifically with Accounting Subledger. Keep in mind these considerations when setting up an integration.

• Custom solutions offer greater control over the integration, but require someone to write and maintain them over time. Don't think of a developed solution as a one-and-done solution.
• Middleware is often simple to set up and maintain, but comes with additional cost. And not all middleware solutions are alike; some solutions are more complicated and require advanced expertise.

Considerations for Reports and Integration

In Accounting Subledger, you can create custom objects and fields to generate transaction journal records. Make sure that you add your new custom fields to your integration or export reports.

If you enable multiple currencies, you can add currency-related fields to your integration or export reports. Keep in mind these behaviors.

• Salesforce adds a Currency field to every object with a field of the currency data type. This field contains the currency code of the record's primary currency, such as USD, MXN, or GBP.
• Every field of the currency data type has a counterpart with (converted) appended to the field label. For example, Accounting Subledger has a Debit Amount field, and enabling multiple currencies creates a Debit Amount (converted) field.

To display the conversion rate on a record, create a custom field on the Transaction Journal object with these values:

• Name: Exchange Rate
• Type: Formula (Number)
• Formula: CURRENCYRATE(TEXT(CurrencyIsoCode))

See Manage Multiple Currencies.