In SAP, the vendor line item display FBL1N and the customer line item display FBL5N give the transaction list you need for reconciliation. Select the account and company code, choose “All items” with a posting date range (not only open items), use a layout with document date, reference, document type, amount and clearing document, then export to Excel.
Settings that matter
- All items, not open items only: cleared invoices and payments are needed to explain the balance.
- Include the reference (external invoice number) column; it is what the counterparty sees.
- Show amounts in document currency and local currency for foreign-currency accounts.
- Include special G/L items (down payments, guarantees) if the counterparty records them.
Exporting
- Run FBL1N / FBL5N with the account, company code and posting date range.
- Choose or save a layout with the columns above.
- List > Export > Spreadsheet, and save as .xlsx.
- Upload the file to mutabakat.com as it is, together with the counterparty's statement.
Frequently asked questions
Why does my FBL1N balance differ from the supplier's statement?
Usually because of invoices not yet posted, payments in transit, or special G/L items excluded from the selection.
Reconcile your next statement in minutes
Start with one account. If the differences are not clearer than in your spreadsheet, you have lost nothing.
Start free trial →Last updated: November 14, 2026 · mutabakat.com