Skip to main content
Learn about AI for accountingJoin live workshops

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

Upload an Excel workpaper from the V1 Prepaid reporting tab and see which schedules were imported, their column mapping, and the first posting month.

Open the V1 Prepaid Expenses reporting tab and select the prepaid account that should receive the schedules. Choose Upload workpaper, then select your Excel workbook in the file picker. The button appears only when workpaper upload is enabled for your organization. The selected page account is the import target. The existing Import Schedules button continues to open the manual paste grid.

Wait while the workbook is validated. This can take several minutes. The result shows the imported count, any skipped rows and their reasons, the saved column mapping (for example, Col C → Total Amount), and Posting starts from the first open month. The reporting tab refreshes after a successful import.

If validation fails, nothing in the file is imported. The result lists the failing rows and reasons together. Correct the workbook and upload it again. Required columns must be confidently mapped, source totals must reconcile, and monthly terms must add up to the schedule total. If no open close period is configured, open the appropriate month before importing.

When uploading a Fixed Assets workpaper, disposal dates in or after the first open month reject the whole file. The row reason is: "Disposed on YYYY-MM-DD, which is in an open period. Import the asset as active and record the disposal in the app." These rows appear together with any other validation failures. Disposals before the first open month remain historical imports without journal entries.

Use Undo import in the result to remove a batch and its schedules and terms. The result explains any refusal. For an unchanged file, undo the previous batch before re-uploading it. If an upload response is interrupted, select the same file again to recover its result and Undo action safely.

Historical months are marked reconciled during import, without creating journal entries. Posting starts with the organization's first open close month; the upload itself does not post anything.

FAQ

Does uploading post journal entries?

No. Months before your organization's first open close period are marked reconciled. The result shows the first month eligible for posting through the module's usual posting workflow.

Can I upload the same workbook again?

Undo its previous batch first. Re-uploading the same file recovers that batch's result and Undo action without creating duplicate schedules.

Limitations

The workbook must be an .xlsx or .xls file no larger than 3 MB, with one nonempty schedule sheet, one header row at the top, and at most 2,000 data rows and 240 columns. Split larger workbooks before uploading.

Monthly term amounts must sum to the schedule total to the cent. Required fields and column mappings must be clear, and dates and months must be valid.

Undo is unavailable once a schedule has a journal entry or linked ledger transaction, including pending posting or sync.

Was this helpful?

Need more help?

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