Headers must match the template. * marks required columns.
- Entry Name*
- Rows with the same name and header values become one entry (one row per destination).
- Posting Date*
- MM/DD/YYYY. Every leg must be in an open, unlocked period.
- Currency*
- Entry currency (each leg posts in its subsidiary's currency).
- Customer/Vendor
- Optional name or id.
- Attachment URL
- Optional link (http/https).
- From Subsidiary* / From Amount* / From Account*
- The originating side; From Amount must equal the sum of To Amounts.
- From Line Description / From Intercompany Account
- Optional; the account defaults to the subsidiary's Due From.
- To Subsidiary* / To Amount* / To Account*
- One destination per row.
- To Line Description / To FX Rate / To Intercompany Account
- Optional; FX defaults to the org rate for the posting month, the account to Due To.
- From Field {x} / To Field {x}
- Optional dimension values for each side.
Your fields: From Field Department / To Field Department, From Field Location / To Field Location, From Field Stage / To Field Stage.