Home VAT/Sales Tax Reconciliation How do I upload and configure my Books and VAT / sales tax statement files for VAT reconciliation?

How do I upload and configure my Books and VAT / sales tax statement files for VAT reconciliation?

Last updated on Sep 08, 2026

Short Answer: Upload each file into the Books / ledger and VAT / sales tax statement panels, then open Configure file to map Header row, Date, Tax amount, and Reference / Identifier.

PreRequisites

  1. Be signed in to the app.

  2. Have your Books file and VAT / sales tax statement file ready.

  3. You can edit file mappings permission to configure files.

Steps

  1. Open the VAT / sales tax reconciliation setup page and confirm you see the Books / ledger and VAT / sales tax statement panels.
    Two panels labeled 'Books' and 'VAT / sales tax statement' and their file placeholders are visible.

  2. Add your Books file by clicking the dashed area or '+ Add more files to Books' and select the file example shown: UK_VAT_Internal.xlsx.
    The Books file appears in the Books panel.

  3. Add your VAT file by clicking '+ Add more files to VAT / sales tax statement' and select the file example shown: UK_VAT_Return.xlsx.
    The VAT / sales tax statement file appears in its panel.

  4. Open Configure file for the Books file by clicking the pencil icon on the Books file card.
    The 'Configure file - Books' modal opens with Data preview and mapping controls on the right.

  5. Map the Books file fields: set Header row if needed, Date e.g., 'Invoice Date', Tax amount = 'VAT Amount GBP', and Reference / Identifier = 'Invoice No'.
    Live normalized preview updates to show Date, Reference and Tax amount from Books file.

  6. Open Configure file for the VAT / sales tax statement and map Header row, Date = 'Return Date', Tax amount = 'VAT Amount GBP', and Reference / Identifier select 'Invoice No' and/or 'Column_4' as needed.
    Live normalized preview shows VAT rows with the chosen Reference and Tax amount.

  7. Close the configure modal and confirm both files remain in their panels.
    Both configured files are listed in their respective panels and ready for reconciliation.

Troubleshooting

  1. The column I need isn't listed in Reference / Identifier.
    LikelyCause: Header row index is incorrect or the file's header row is not selected.
    Action: Open Configure file and change the 'Header row' value to the row containing your column headers or use 'Add column' if you need to create a derived column.

  2. Live normalized preview shows wrong values.
    LikelyCause: Wrong mapping selected for Date or Tax amount.
    Action: Re-open Configure file and re-select the correct columns e.g., 'Invoice Date' and 'VAT Amount GBP'. Verify in 'Live normalized preview'.

  3. File doesn't appear in the panel after upload.
    LikelyCause: Upload failed or file was added to the wrong panel.
    Action: Re-run upload by clicking '+ Add more files to Books' or '+ Add more files to VAT / sales tax statement' and confirm the file name appears in the correct panel.