Home Customer Reconciliation How do I configure the Books / ledger file columns for reconciliation?

How do I configure the Books / ledger file columns for reconciliation?

Last updated on Sep 08, 2026

Short Answer: Open 'Configure file - Books', set the header row, choose 'Posting Date' as Date, select 'Separate debit and credit columns', set 'Debit amount' and 'Credit amount', and choose identifiers like 'Invoice Ref', 'PO No', 'Doc No'.

PreRequisites

  1. Books file is uploaded and visible in the Books card.

  2. You know which columns contain Posting Date, Debit, Credit and identifiers Invoice Ref, PO No, Doc No.

Steps

  1. On the 'Customer reconciliation' page click the pencil icon on the Books card to open 'Configure file - Books'.
    'Configure file - Books' modal opens.

  2. Set 'Select the row number where the column headers are present' to the correct row example shows '5'.
    Data preview shows headers aligned to the selected row.

  3. Under 'Date (optional)' choose 'Posting Date'.
    'Posting Date' selected as the Date column.

  4. Under 'Amount' select 'Separate debit and credit columns' and note 'Net amount = Debit - Credit'.
    Separate debit/credit option selected and guidance visible.

  5. Set 'Debit amount' to 'Debit (USD)' and 'Credit amount' to 'Credit (USD)'.
    Debit and Credit dropdowns show the selected columns.

  6. Under 'Reference / Identifier' select 'Invoice Ref', 'PO No' and 'Doc No' as applicable.
    Chosen identifiers appear in the Reference / Identifier field.

  7. Close the modal by clicking 'X' and verify mappings saved in the Books card.
    Books mapping is applied for the next reconciliation run.

Troubleshooting

  1. Book totals are reversed compared to statement totals.
    LikelyCause: Wrong net amount interpretation. Books note says 'Net amount = Debit - Credit'.
    Action: Open 'Configure file - Books' and confirm the 'Separate debit and credit columns' option and that Debit/Credit dropdowns are correctly assigned.

  2. Expected identifier columns are missing from Reference / Identifier.
    LikelyCause: Header row chosen incorrectly.
    Action: Adjust the header row number until the correct column labels appear in the preview, or use 'Add column' to expose a missing column.

Note: Books modal help text reads 'Net amount = Debit - Credit' — use that to verify the correct debit/credit mapping.