Ask the support agent

Just ask a direct question or search related articles from the Knowledge Base.

Support Center / Prepaid Expenses / Import/Export

Import a Prepaid Expense workpaper

Import Prepaid Expense schedules from a workpaper when schedule data already exists in a spreadsheet, resulting in mapped schedules ready for review and posting.

Workflow

Step 1

Select Import WorkPaper

Use the highlighted import control to bring the source schedule data into Truewind.

Step 2

Select Click to upload or drag and drop…

Use the highlighted import control to bring the source schedule data into Truewind.

Step 3

Select "Startplaying Workpaper.xlsx" from file upload menu

Choose the option that matches the account, period, or schedule you are working with.

Step 4

Choose the corresponding tab in the excel you want to import

Choose the option that matches the account, period, or schedule you are working with.

Step 5

Use the dropdown to select what you are importing

Choose the option that matches the account, period, or schedule you are working with.

Step 6

Select 14040 Prepaid Expenses

Use the highlighted control to continue through the workflow.

Step 7

Select Extract Data

Use the highlighted control to continue through the workflow.

Step 8

Review extracted workpaper data

Use the highlighted control to continue through the workflow.

Step 9

Review payee mapping

Choose the option that matches the account, period, or schedule you are working with.

Step 10

Select Add a new payee "Eshares Bd Edc"

Use the highlighted control to continue through the workflow.

Step 11

Select Add

Use the highlighted control to continue through the workflow.

Step 12

Select Eshares Bd Edc…

Use the highlighted control to continue through the workflow.

Step 13

Review the schedule

Confirm the page shows the expected result before continuing to the next step.

Step 14

Under Action/Status, there are three status

Confirm the page shows the expected result before continuing to the next step.

Step 15

Select Click to import

Use the highlighted import control to bring the source schedule data into Truewind.

Step 16

This schedule has been successfully imported

Confirm the page shows the expected result before continuing to the next step.

Step 17

Resolve import warnings

Confirm the page shows the expected result before continuing to the next step.

Step 18

Review the schedule

Confirm the page shows the expected result before continuing to the next step.

Step 19

Review the schedule

Confirm the page shows the expected result before continuing to the next step.

Step 20

Now, the schedule is ready to post amortization JE

Confirm the page shows the expected result before continuing to the next step.

Step 21

Review the final import state

Use the highlighted control to continue through the workflow.

Before importing

Review the source workbook tab and required columns before importing schedules into Truewind.

Was this helpful?

Need more help?

Ask for human help about this article and provide any feedback.