Payroll Reconciliation: Jisr Payroll ↔ SAP B1 Journal Entries

Monthly matching, not posting. Reads the month's payroll transactions from Jisr and the payroll journal entries from SAP B1 (by memo/reference), sums both sides per employee cost centre, and reports every difference: missing in ERP, missing in payroll, or amount mismatch beyond the tolerance. Sends the discrepancy report by email; nothing is written to either system.

Steps in this flow

  1. Monthly: after payroll close
  2. Reconciliation config
  3. Jisr: Payroll Transactions
  4. SAP B1: GET /JournalEntries (payroll memo)
  5. Wait for both sides
  6. Sum payroll by cost centre
  7. Sum journal lines by cost centre
  8. Compare sides (tolerance)
  9. Any discrepancies?
  10. Email discrepancy report
  11. Log: reconciled

All templates