Export your journal entries in bulk for a query to facilitate reporting purposes or to update other systems.

To export:

  1. Select Export to create a bulk export of journal entries that include headers and details from your system.
  2. The .CSV file contains:
RequirementAction
RecType

The file must contain the RecType column. 

  • H signifies the row as a header. 
  • D signifies the row as a detail.
JEID

Clear the JEID for each row of a journal entry. The JEID is repeated for the entire journal entry, including each RecType row labeled with a 'D'.

IDs with a negative sign show the journal entry has not been saved.

Header/Detail

The header comes before the details for each journal entry. 

The journal configuration file Header/Detail column and order determine the order of the dimensions in the export file.

Status

Displays status of the header of each journal entry:

  • Posted
  • Unposted
Balanced
  • True: If the journal entry's credit and debit amounts equal each other
  • False: If the journal entry's credit and debit amounts doesn't equal each other.
Attachment
  • True: If any attachment has been included in the journal entry.
  • False: If there isn't any attachment included in the journal entry.

Attachments don't get exported into the file.

DetailID

It displays a DetailID number for each detail for a journal entry.

For example, if you have one debit and one credit account, the DetailID fields would contain 1 for the first and 2 for the second.   

Debit and CreditIt displays numerical or currency amounts in the debit and credit columns.