Skip to help content
FolioPact.
Release pending7 min read · Reviewed

Review structured imports and download documents

The V1.x candidate supports reviewed structured CSV/XLSX imports and native CSV/XLSX/PDF/DOCX reports. These paths are separate from bank-statement reconciliation and private evidence uploads.

  1. Start with the correct template

    In Reports, open Import borrowers, loans and historical entries. Choose the import type and destination lender. Download the CSV or XLSX template and replace its fictional sample row. Borrower names are not identities: use stable external IDs or saved record IDs. Reference reports list existing lenders and source accounts.

  2. Choose dates and map columns

    Upload a UTF-8 CSV or one visible native XLSX worksheet, at most 1 MB and 2,000 data records. Select the delimiter, explicit YMD/DMY/MDY date interpretation, decimal/thousands separators and text encoding. Use FolioPact CSV template escaping for its CSV templates. Keep leading-zero references as text.

  3. Review each bounded batch

    Validate and preview at most 20 records. Inspect mapped source values, destination ownership, before/after balances and actual payment allocations. One confirmed batch is atomic; larger files need a separate review for each next batch. Choose either complete loan history or opening balances at cutover, with no double counting.

  4. Resolve the original request

    A cancelled review posts nothing. If a response is uncertain, use Recover / resolve an earlier import before starting again. Repeating the same file batch resolves its original result. A corrected row cannot overwrite an imported identity; use authorised linked corrections.

  5. Download the right document

    Preview the scoped saved report, choose PDF, Excel XLSX, CSV or editable Word DOCX, then download. A payment receipt records a saved receipt and its allocation; a statement records account movements; a settlement quote is dated and does not itself close the loan. The original and revised schedules remain available.

Check your result

  • Currency totals stay separate, and every download rechecks current owner access and report scope.
  • Word editing does not change the saved book. Native documents retain generation time and source revision.
  • XLSX formulas, macros, external links, merged cells, unsafe archives and unsupported date serials are rejected. Store large amounts and leading-zero IDs as text.
  • PDF embeds tested Latin, Greek, Cyrillic and Tamil fonts. Other scripts receive a useful format error; native Word and Excel retain Unicode text, with viewing support dependent on the reader.
Open private workspace