The bank's file against the books.
At the end of each day the payment provider sends a settlement file: every capture and refund it settled, with its fee. The matcher pairs each line with the ledger by reference. Whatever doesn't pair is a break, and a person looks at it. In the demo a day is compressed to a few minutes.
Settled days
- 18 Oct, 04:30130 lines3 breaks
- 18 Oct, 04:20128 lines6 breaks
- 18 Oct, 04:10131 lines3 breaks
- 18 Oct, 04:00137 lines3 breaks
- 18 Oct, 03:50119 lines2 breaks
- 18 Oct, 03:40109 lines3 breaks
- 18 Oct, 03:30125 lines3 breaks
- 18 Oct, 03:20122 lines3 breaks
- 18 Oct, 03:10130 linesclean
- 18 Oct, 03:00124 lines4 breaks
- 18 Oct, 02:50136 lines1 break
- 18 Oct, 02:40103 lines4 breaks
- 18 Oct, 02:30122 lines4 breaks
- 18 Oct, 02:20104 lines5 breaks
18 Oct, 03:30
Gross
€3,030.00
PSP fee
€47.93
Net to the bank
€2,982.07
Settlement journal
#62578
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14d14-652d-76c6-9d5b-e6692512f367 is already settled by stl_EUR_2987157 line 76
- fee differencethe fee is not the contract feethe fee is 22, the contract says 19
- missing linein the books, not in the filecapture:01a14d14-d9f7-7f06-a112-fd0a80ac151c is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 7 | capture | 01a14d0f-8559-71a2-8b90-e1b2c4e64b14 | €9.00 | €0.22 | fee difference |
| 77 | capture | 01a14d14-668c-7273-897e-b97e3a03f501 | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a14d0f-34f5-70fe-8de0-dfa1f8f77d51 | €35.00 | €0.50 | matched |
| 2 | capture | 01a14d0f-5dbc-7684-8275-a98bf7a9d993 | €9.00 | €0.19 | matched |
| 3 | capture | 01a14d0f-681b-7d1b-9201-d77ce78c3e81 | €15.00 | €0.26 | matched |
| 4 | capture | 01a14d0f-6a5a-782b-aaad-88a6d2f8f083 | €49.00 | €0.67 | matched |
| 5 | capture | 01a14d0f-7a41-7839-afdb-a5b180e2df4c | €9.00 | €0.19 | matched |
| 6 | refund | 01a14d0f-7e74-7773-8987-23d76b09cebd | -€21.00 | €0.00 | matched |
| 8 | capture | 01a14d0f-9d30-7199-80f1-76d0421e8873 | €24.00 | €0.37 | matched |
| 9 | capture | 01a14d0f-a2eb-7204-abd0-f35fa6455707 | €9.00 | €0.19 | matched |
| 10 | capture | 01a14d0f-e11d-7f00-8d9e-d1cdfc2e60ac | €9.00 | €0.19 | matched |
| 11 | capture | 01a14d0f-ec73-7e15-a8eb-4fba4ac0b176 | €35.00 | €0.50 | matched |
| 12 | capture | 01a14d0f-ee95-7af6-a90a-97e4f3019f25 | €9.00 | €0.19 | matched |
| 13 | capture | 01a14d0f-f504-7d90-9a83-937fe4aa60f3 | €24.00 | €0.37 | matched |
| 14 | capture | 01a14d0f-f953-7f09-ae47-9235f6a871f7 | €49.00 | €0.67 | matched |
| 15 | capture | 01a14d10-12a8-7b2a-a5a0-56f7b7be7305 | €49.00 | €0.67 | matched |
| 16 | capture | 01a14d10-189c-7993-8aaf-93d2efdcd729 | €9.00 | €0.19 | matched |
| 17 | capture | 01a14d10-3d29-7ff3-bf66-7e1eb48f4b0c | €49.00 | €0.67 | matched |
| 18 | capture | 01a14d10-55aa-748f-8866-b173c4f15bc8 | €9.00 | €0.19 | matched |
| 19 | refund | 01a14d10-5a6a-7f42-b9e2-55392cc17c0b | -€29.00 | €0.00 | matched |
| 20 | capture | 01a14d10-5b07-7184-b5c4-c2df1a3afe74 | €49.00 | €0.67 | matched |
| 21 | refund | 01a14d10-6582-7cef-b558-89e73412d3e8 | -€43.00 | €0.00 | matched |
| 22 | capture | 01a14d10-6d80-7163-a10e-87331d9f1cf6 | €49.00 | €0.67 | matched |
| 23 | capture | 01a14d10-6f57-7185-884b-a446c2cfd76b | €49.00 | €0.67 | matched |
| 24 | capture | 01a14d10-6fdc-7b56-8fea-3184272f233b | €15.00 | €0.26 | matched |
| 25 | capture | 01a14d10-72ab-73e0-8d2c-57f5f49716fa | €15.00 | €0.26 | matched |
| 26 | capture | 01a14d10-859d-7c52-a396-8b7463860270 | €35.00 | €0.50 | matched |
| 27 | capture | 01a14d10-a639-7d9f-9708-af88da5a3658 | €15.00 | €0.26 | matched |
| 28 | capture | 01a14d10-b373-7012-9db2-560367649e42 | €49.00 | €0.67 | matched |
| 29 | capture | 01a14d10-b5c7-7ea8-868a-63802cd552de | €9.00 | €0.19 | matched |
| 30 | capture | 01a14d10-d853-7c58-96f4-9ae541b7353e | €24.00 | €0.37 | matched |
| 31 | capture | 01a14d10-dab7-7fa1-ab33-b8cd3ba13a54 | €15.00 | €0.26 | matched |
| 32 | capture | 01a14d10-f254-796c-8cfc-056e344ca32d | €49.00 | €0.67 | matched |
| 33 | capture | 01a14d10-fb84-7db8-812c-e4fc0290b204 | €35.00 | €0.50 | matched |
| 34 | capture | 01a14d11-0749-79e2-9d49-9017cd655730 | €15.00 | €0.26 | matched |
| 35 | capture | 01a14d11-0a2d-7b5a-b03c-a0a5396a91ba | €24.00 | €0.37 | matched |
| 36 | capture | 01a14d11-180e-70b8-9e5d-bc1cecce7fc4 | €35.00 | €0.50 | matched |
| 37 | capture | 01a14d11-1c12-709d-9134-90302683e7ad | €24.00 | €0.37 | matched |
| 38 | capture | 01a14d11-4bf3-7dd4-b7aa-dd46c253d8d6 | €15.00 | €0.26 | matched |
| 39 | capture | 01a14d11-6774-7850-9046-8f939a736e8a | €35.00 | €0.50 | matched |
| 40 | capture | 01a14d11-6cca-7f04-9ed0-1d8626d32190 | €35.00 | €0.50 | matched |
| 41 | capture | 01a14d11-ac66-7623-880c-b0cbd9cafe11 | €15.00 | €0.26 | matched |
| 42 | capture | 01a14d11-b54f-73f7-bdaa-08866a02a916 | €35.00 | €0.50 | matched |
| 43 | capture | 01a14d11-ba3c-7f72-8351-f39c567ff176 | €9.00 | €0.19 | matched |
| 44 | capture | 01a14d11-d0df-7c6c-9c74-d3373919d9ee | €9.00 | €0.19 | matched |
| 45 | capture | 01a14d11-d25f-72c9-99b9-f262df755204 | €49.00 | €0.67 | matched |
| 46 | capture | 01a14d12-1bb8-7b1d-94de-e5c50b60589e | €9.00 | €0.19 | matched |
| 47 | capture | 01a14d12-3200-7d42-9da3-c51896fcd251 | €15.00 | €0.26 | matched |
| 48 | capture | 01a14d12-8948-718e-a09f-eb6a41935ac4 | €15.00 | €0.26 | matched |
| 49 | capture | 01a14d12-9798-7c13-b348-06a0a1f6a320 | €15.00 | €0.26 | matched |
| 50 | capture | 01a14d12-952e-749b-89a2-3f45d06fa892 | €49.00 | €0.67 | matched |
| 51 | capture | 01a14d12-a4df-705f-95e7-6e4f38b28af0 | €49.00 | €0.67 | matched |
| 52 | capture | 01a14d12-daf6-7354-bce8-4b18d200bb18 | €9.00 | €0.19 | matched |
| 53 | capture | 01a14d12-f014-7ff5-9167-d089a8e59eca | €49.00 | €0.67 | matched |
| 54 | capture | 01a14d12-f91e-7063-a2f2-19bf8d80c1d5 | €49.00 | €0.67 | matched |
| 55 | capture | 01a14d12-fa8e-790a-8626-03f5aaf8ece1 | €49.00 | €0.67 | matched |
| 56 | capture | 01a14d13-1a4a-731c-b471-4d12b7e6e019 | €49.00 | €0.67 | matched |
| 57 | capture | 01a14d13-563c-7e27-8861-253bd3aa9214 | €24.00 | €0.37 | matched |
| 58 | refund | 01a14d13-67f5-7744-a037-83b1c0fd466c | -€20.00 | €0.00 | matched |
| 59 | capture | 01a14d13-6efa-708c-810e-3ee247c6cb7d | €15.00 | €0.26 | matched |
| 60 | capture | 01a14d13-78ec-7098-8fae-666c1513083a | €35.00 | €0.50 | matched |
| 61 | capture | 01a14d13-9153-72ca-87ac-23df587e6716 | €15.00 | €0.26 | matched |
| 62 | capture | 01a14d13-9952-74b2-a847-a966bfbcf1df | €15.00 | €0.26 | matched |
| 63 | refund | 01a14d13-a3cc-7cb3-a4c0-3fa699889815 | -€4.00 | €0.00 | matched |
| 64 | capture | 01a14d13-ac88-728f-ab0e-4205914b07b9 | €49.00 | €0.67 | matched |
| 65 | capture | 01a14d13-b32a-7521-bde9-e38a83bfedc4 | €9.00 | €0.19 | matched |
| 66 | capture | 01a14d13-e302-7178-b87f-13291ab6e9e0 | €15.00 | €0.26 | matched |
| 67 | capture | 01a14d13-e473-7d2e-ad78-194017c6c66d | €35.00 | €0.50 | matched |
| 68 | capture | 01a14d13-ee18-7675-bcd0-ee1ab03d4379 | €35.00 | €0.50 | matched |
| 69 | capture | 01a14d13-ee74-7708-8d3d-801b33f8efe0 | €24.00 | €0.37 | matched |
| 70 | capture | 01a14d13-fa50-7437-a6a5-775bf7561246 | €35.00 | €0.50 | matched |
| 71 | capture | 01a14d14-01c2-7c80-bba8-fa612d19e872 | €35.00 | €0.50 | matched |
| 72 | capture | 01a14d14-2204-7e69-a7e8-29b45eac99c2 | €15.00 | €0.26 | matched |
| 73 | capture | 01a14d14-249a-7d3f-996f-0d4c08b10f36 | €24.00 | €0.37 | matched |
| 74 | capture | 01a14d14-3148-758b-93a4-abaf7dfab9fc | €15.00 | €0.26 | matched |
| 75 | capture | 01a14d14-5e84-77e3-854d-512363dcc496 | €49.00 | €0.67 | matched |
| 76 | capture | 01a14d14-668c-7273-897e-b97e3a03f501 | €35.00 | €0.50 | matched |
| 78 | capture | 01a14d14-7eb1-7529-94e8-286dd0923ee1 | €9.00 | €0.19 | matched |
| 79 | capture | 01a14d14-938b-7bb5-9ad9-4af6b22266b3 | €49.00 | €0.67 | matched |
| 80 | capture | 01a14d14-9412-7959-bbfb-7d8c945db857 | €9.00 | €0.19 | matched |
| 81 | capture | 01a14d14-aca9-7914-b623-89ff10229e45 | €49.00 | €0.67 | matched |
| 82 | capture | 01a14d14-ae1a-78e5-a327-bdaeb6acf254 | €9.00 | €0.19 | matched |
| 83 | capture | 01a14d14-c095-7694-b387-66fde70d11bb | €24.00 | €0.37 | matched |
| 84 | capture | 01a14d15-18fc-7393-a4af-f4412c4482f2 | €9.00 | €0.19 | matched |
| 85 | capture | 01a14d15-159a-7e3c-a9b6-7e6192c55e66 | €15.00 | €0.26 | matched |
| 86 | capture | 01a14d15-2204-793a-86f1-c3a28467af31 | €15.00 | €0.26 | matched |
| 87 | capture | 01a14d15-227f-7e22-896a-d518accbdb1f | €49.00 | €0.67 | matched |
| 88 | capture | 01a14d15-3729-7d9b-9152-ca8948ca1ad1 | €9.00 | €0.19 | matched |
| 89 | capture | 01a14d15-406b-788b-a101-cab1ba2627ae | €49.00 | €0.67 | matched |
| 90 | capture | 01a14d15-5232-7b9a-a84d-a55bc319ab0f | €35.00 | €0.50 | matched |
| 91 | capture | 01a14d15-5353-7336-81d1-0535c938f6fd | €49.00 | €0.67 | matched |
| 92 | capture | 01a14d15-8cec-781a-92d9-b36da77bcb5a | €35.00 | €0.50 | matched |
| 93 | capture | 01a14d15-b4c9-73f7-a003-4048a1a89659 | €15.00 | €0.26 | matched |
| 94 | capture | 01a14d15-bd36-78f6-b497-6a5800f92661 | €49.00 | €0.67 | matched |
| 95 | capture | 01a14d15-be8f-703a-8484-ae20c887a8e7 | €24.00 | €0.37 | matched |
| 96 | capture | 01a14d15-eac7-7846-aa96-f05f4673a15f | €35.00 | €0.50 | matched |
| 97 | capture | 01a14d15-ea99-7dd4-b795-a1a3bbdef4a9 | €35.00 | €0.50 | matched |
| 98 | capture | 01a14d16-04a5-7305-ab90-bbd2cb1393e4 | €15.00 | €0.26 | matched |
| 99 | capture | 01a14d16-1eca-7116-b756-ce9447ee30d6 | €15.00 | €0.26 | matched |
| 100 | capture | 01a14d16-3699-7bca-8a83-e7466ac485a6 | €15.00 | €0.26 | matched |
| 101 | capture | 01a14d16-46eb-7507-9c16-d3f08dce4cf4 | €9.00 | €0.19 | matched |
| 102 | refund | 01a14d16-4c1f-709a-a808-f20ff72b729f | -€13.00 | €0.00 | matched |
| 103 | capture | 01a14d16-508f-728c-ab07-d867d07846f3 | €35.00 | €0.50 | matched |
| 104 | capture | 01a14d16-539b-7e7d-880d-78d74fdea031 | €49.00 | €0.67 | matched |
| 105 | refund | 01a14d16-5d77-7720-9442-440b3224e461 | -€13.00 | €0.00 | matched |
| 106 | capture | 01a14d16-89ae-7cb9-aec7-76ece24c371f | €49.00 | €0.67 | matched |
| 107 | capture | 01a14d16-9943-79af-bea7-812ca462891b | €35.00 | €0.50 | matched |
| 108 | capture | 01a14d16-b108-77af-80db-433834d0e5d2 | €49.00 | €0.67 | matched |
| 109 | capture | 01a14d16-b92f-71bd-b14d-d16d7fd8f8da | €15.00 | €0.26 | matched |
| 110 | capture | 01a14d16-b279-732a-b4e0-1d7050e3b384 | €15.00 | €0.26 | matched |
| 111 | capture | 01a14d17-011f-7116-97df-82e2f50101c2 | €24.00 | €0.37 | matched |
| 112 | capture | 01a14d17-0638-7ae9-b125-a2f15f189972 | €35.00 | €0.50 | matched |
| 113 | capture | 01a14d17-1446-73c3-b78d-b8e01e6db422 | €24.00 | €0.37 | matched |
| 114 | capture | 01a14d17-1e22-71c3-8415-36c0797b00b6 | €15.00 | €0.26 | matched |
| 115 | capture | 01a14d17-3425-78fb-90cf-017b3d6a219d | €9.00 | €0.19 | matched |
| 116 | capture | 01a14d17-4df9-7c25-956a-12da73932c74 | €24.00 | €0.37 | matched |
| 117 | capture | 01a14d17-52bf-792d-ab18-509f427b9071 | €35.00 | €0.50 | matched |
| 118 | refund | 01a14d17-6217-7626-aea2-65e184ae14d3 | -€28.00 | €0.00 | matched |
| 119 | capture | 01a14d17-9156-7169-b99f-fc0fb5b20ff0 | €35.00 | €0.50 | matched |
| 120 | capture | 01a14d17-a78f-792a-b160-54770ea7276c | €9.00 | €0.19 | matched |
| 121 | capture | 01a14d17-b7b3-7827-8785-538b59414aaa | €24.00 | €0.37 | matched |
| 122 | capture | 01a14d17-c55f-76d2-a636-aef33e7c3a58 | €35.00 | €0.50 | matched |
| 123 | capture | 01a14d17-f5ba-7977-b06f-7f27cffe8803 | €15.00 | €0.26 | matched |
| 124 | capture | 01a14d17-f638-7ec7-86fd-ababc0249463 | €15.00 | €0.26 | matched |
| 125 | capture | 01a14d18-1eb0-7160-b4cd-8f4d07e17f5c | €49.00 | €0.67 | matched |