Using Journal Loader

Note: If you do not have My Domain set up in your org, you must register the following URL as a trusted remote site in Remote Site Settings: https://YourInstance.salesforce.com (where YourInstance is your org's Salesforce instance, such as NA9). For more information, see "My Domain" in the Salesforce Help.

Before starting the process, ensure you are in single-company mode and the current company is the company for which you want to run Journal Loader. You must also be assigned to the Accounting and Billing Journal - Save permission set.

Loading journal data from a spreadsheet into Journal Loader

To load up to 50,000 journal lines using Journal Loader:

  1. Click the Journal Loader tab.
  2. Specify the Suspense GLA if one is not displayed, or amend the default if required.
  3. Select and copy your journal data from the relevant spreadsheet.
  4. In Journal Loader, click anywhere within the area bordered by the dotted line.
  5. Paste your journal data. If any errors occur, clear the data in Journal Loader, correct the errors in the source spreadsheet, and try pasting the data again.
Note: Use either your keyboard command for paste, or the brower’s Edit/Paste menu item. You can’t paste using the right-click action on your mouse.

When the journal data is uploaded successfully, a table is displayed. This shows the number of journals that will be created by the upload process.

You can click any journal row to display the Journal Details dialogue, where you can view a detailed list of the journal lines within that journal.

Saving the imported journal data to the FinancialForce database

To save the imported journal data to FinancialForce Accounting:

Warnings: You must not navigate to a different page within the application during the save process. Doing so might result in some journals not being saved. If this happens, discard these journals and start the save process again. You can move to other tabs within your browser while the save process completes.

After the save process, a message is displayed telling you how many journals and journal lines have been saved. To load journal data from another spreadsheet, clear the current data and start the process again.