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

Open Import Workpaper

Start in Documents > Import Workpaper to review prior uploads and begin a new spreadsheet import.

Screenshot showing the Import Workpaper page with prior uploads and the Import button.

Step 2

Open a new upload

Use Import to start a new workpaper upload when the schedule data is in an Excel workbook.

Screenshot showing the new Import Workpaper upload page with the file drop zone.

Step 3

Select the workbook file

Upload the spreadsheet that contains the prepaid expense schedule rows you want Truewind to extract.

Screenshot showing an uploaded Excel workbook selected on the Import Workpaper page.

Step 4

Review upload details

Confirm the file opened successfully and that Truewind detected the workbook sheets before configuring extraction.

Screenshot showing upload details for an Excel workpaper with detected workbook sheets.

Step 5

Choose the workbook sheet

Select the tab that contains the prepaid expense schedule data, especially when the workbook includes multiple schedules.

Screenshot showing the Prepaid Expense workbook sheet selected for extraction.

Step 6

Review the upload type

Keep the upload type set to Prepaid Expense Schedule so the extracted rows map to prepaid expense fields.

Screenshot showing the upload type menu with Prepaid Expense Schedule selected.

Step 7

Open the prepaid account field

Use the Prepaid Expense Account field to choose the balance sheet account that will hold the imported schedules.

Screenshot showing the Prepaid Expense Account field on the workpaper upload details page.

Step 8

Search for the prepaid account

Filter the account list by account number or name to locate the account that matches the workpaper.

Screenshot showing the account picker opened for the Prepaid Expense Account field.

Step 9

Select the prepaid account

Choose the matching prepaid expense account before extracting rows so each imported schedule is assigned correctly.

Screenshot showing a prepaid expense account selected on the upload details page.

Step 10

Add AI instructions

Provide any context the extractor should use, such as preserving imported amortization terms from the source workbook.

Screenshot showing instructions entered for AI before extracting workpaper data.

Step 11

Review Extract Data

Confirm the sheet, upload type, prepaid account, and instructions are correct before starting extraction.

Screenshot showing the Extract Data action after workpaper import settings are complete.

Step 12

Review extraction details

After extraction completes, check the summary for the import type, selected sheet, row count, and any user instructions.

Screenshot showing extraction details for a completed prepaid expense workpaper import.

Step 13

Review extracted rows

Compare the extracted table to the source workbook before mapping values or importing schedules.

Screenshot showing extracted prepaid expense rows in the import review table.

Step 14

Review payee and account mapping

Check that each row is matched to the correct payee and expense account, and update any unresolved mappings.

Screenshot showing payee and expense account mapping columns for extracted workpaper rows.

Step 15

Open payee mapping

Use the payee selector on a row when the extracted payee needs to be matched to an existing vendor record.

Screenshot showing the payee selector opened from an extracted workpaper row.

Step 16

Search for the payee

Search by vendor name to choose the correct payee before importing the schedule row.

Screenshot showing a payee search in the payee selector for a workpaper row.

Step 17

Review dates and amounts

Confirm transaction dates, start and end dates, and total amounts before relying on the generated amortization schedule.

Screenshot showing extracted dates and amount columns for prepaid expense workpaper rows.

Step 18

Review imported terms

Use the imported terms column to check whether Truewind preserved the schedule terms from the workbook.

Screenshot showing imported amortization terms available for extracted prepaid expense rows.

Step 19

Open imported terms

Expand the terms preview when you need to inspect the monthly allocation amounts before importing.

Screenshot showing a monthly imported terms preview for a prepaid expense row.

Step 20

Review import actions

Resolve any warnings, then choose whether to import individual rows or all ready rows after the extracted data has been reviewed.

Screenshot showing row import actions and the Import All button for extracted workpaper rows.

Before importing

Review the workbook sheet, upload type, prepaid account, payee and account mappings, dates, amounts, and imported terms before importing schedules into Truewind.

Was this helpful?

Need more help?

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