When you are finished editing your spreadsheet in Excel, open Journal Entry Cross-Cy Excel Integration, right-click in the grid, and select Import from Excel. The cross-company entries defined in your spreadsheet are loaded into the grid in Journal Entry Cross-Cy Excel Integration.

When you click Save in Journal Entry Cross-Cy Excel Integration, the system creates journal entries for the source entity and for each of the corresponding postings for the target entities. It also performs all validation and defaults values if some key fields are blank. If you specify all required values, no defaulting occurs. See Validation and Defaulting for more information.

Two areas of the Journal Entry Cross-Cy Excel Integration screen indicate whether or not postings are processed successfully. The Posted field at Level 1 of the grid is automatically selected by the system as each transaction is processed and saved successfully. In addition, the processing status indicator at the bottom left of the screen indicates the status of records.