Headers must match the template. * marks required columns.
- Date*
- MM/DD/YYYY. Entries dated in a closed period are rejected.
- JE Name*
- Rows with the same name and header values become one entry.
- Currency*
- 3-letter code, e.g. USD.
- FX Rate
- Required when the currency differs from the subsidiary's.
- Debit Amount* / Credit Amount*
- Exactly one per row.
- Account Number or Name*
- Account number (preferred) or exact name.
- Description
- Line description.
- Vendor Name / Vendor Id, Customer Name / Customer Id
- Optional customer or vendor for the entry.
- Reversal Date
- Creates a reversing entry on that date.
- Subsidiary Id
- Defaults to the default subsidiary.
- Field {name}
- One column per field, e.g. Field Department.
Your fields: Field Department, Field Location, Field Stage.