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
- 17 Oct, 13:30100 lines1 break
- 17 Oct, 13:20123 lines3 breaks
- 17 Oct, 13:10114 lines6 breaks
- 17 Oct, 13:00111 lines3 breaks
- 17 Oct, 12:50133 lines9 breaks
- 17 Oct, 12:40123 lines2 breaks
- 17 Oct, 12:30109 lines4 breaks
- 17 Oct, 12:20127 lines4 breaks
- 17 Oct, 12:10116 lines2 breaks
- 17 Oct, 12:00112 lines1 break
- 17 Oct, 11:50137 lines4 breaks
- 17 Oct, 11:40118 lines4 breaks
- 17 Oct, 11:30114 lines3 breaks
- 17 Oct, 11:20124 lines3 breaks
17 Oct, 12:20
Gross
€2,810.00
PSP fee
€45.09
Net to the bank
€2,764.91
Settlement journal
#51193
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a149ce-404e-77b3-b563-737818ffed98 is already settled by stl_EUR_2987066 line 8
- duplicate linethe file lists it twicecapture:01a149d1-1ddd-7840-bbd3-29a0a1d0eccc is already settled by stl_EUR_2987066 line 46
- fee differencethe fee is not the contract feethe fee is 53, the contract says 50
- missing linein the books, not in the filecapture:01a149d6-6144-751e-ac67-20684fb6be42 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 9 | refund | 01a149ce-4054-72ae-8e4a-32a8c4a786f3 | -€13.00 | €0.00 | duplicate line |
| 47 | capture | 01a149d1-1e34-7dcf-9255-c36072c8f84a | €24.00 | €0.37 | duplicate line |
| 65 | capture | 01a149d1-e9ff-7697-9002-49152fd63252 | €35.00 | €0.53 | fee difference |
| 1 | capture | 01a149c7-9b20-7c3d-837b-0bd215e8d8bb | €9.00 | €0.19 | matched |
| 2 | refund | 01a149cb-1e08-7711-b5b3-d764514414b5 | -€3.00 | €0.00 | matched |
| 3 | capture | 01a149cd-280e-7c21-8ada-96ab3c42fad1 | €35.00 | €0.50 | matched |
| 4 | capture | 01a149cd-49d2-72cc-a884-02bd7e992826 | €49.00 | €0.67 | matched |
| 5 | capture | 01a149ce-0975-7539-b751-f761ced53e26 | €9.00 | €0.19 | matched |
| 6 | capture | 01a149ce-0bad-7023-9220-683441b81cc7 | €24.00 | €0.37 | matched |
| 7 | capture | 01a149ce-300f-78a2-97b1-a014e1d0386f | €15.00 | €0.26 | matched |
| 8 | refund | 01a149ce-4054-72ae-8e4a-32a8c4a786f3 | -€13.00 | €0.00 | matched |
| 10 | capture | 01a149ce-4ab7-7842-b908-197bb3299802 | €35.00 | €0.50 | matched |
| 11 | capture | 01a149ce-6070-7dbe-81f0-54711333d072 | €9.00 | €0.19 | matched |
| 12 | capture | 01a149ce-725e-71c7-aa9e-6ff5f530cb0f | €9.00 | €0.19 | matched |
| 13 | capture | 01a149ce-ad74-7c39-9546-fe39af1196f3 | €15.00 | €0.26 | matched |
| 14 | capture | 01a149ce-becd-7dd5-800b-84e19fbe168f | €49.00 | €0.67 | matched |
| 15 | capture | 01a149ce-d3c7-7248-9cfe-59b18ed48d8f | €24.00 | €0.37 | matched |
| 16 | capture | 01a149ce-e487-7de0-9fa5-68cc6e135f87 | €49.00 | €0.67 | matched |
| 17 | capture | 01a149ce-e281-7615-b505-c23762a7026c | €49.00 | €0.67 | matched |
| 18 | capture | 01a149ce-e952-7c87-9439-21365ed77c05 | €9.00 | €0.19 | matched |
| 19 | capture | 01a149ce-f4af-78dd-b54a-2454e1479a6b | €35.00 | €0.50 | matched |
| 20 | capture | 01a149cf-05fd-74a0-b448-aa43fd3cb2d3 | €24.00 | €0.37 | matched |
| 21 | refund | 01a149cf-2673-7297-ae88-9a83c44ccaa2 | -€12.00 | €0.00 | matched |
| 22 | capture | 01a149cf-27c4-7389-8c5a-7d86d6a5a9f4 | €9.00 | €0.19 | matched |
| 23 | refund | 01a149cf-467e-750d-8c4e-6071534f0bf5 | -€9.00 | €0.00 | matched |
| 24 | capture | 01a149cf-6061-77db-8ce6-03dca7056c1e | €15.00 | €0.26 | matched |
| 25 | capture | 01a149cf-62f8-7be2-8b0b-f45c8b8dc3aa | €49.00 | €0.67 | matched |
| 26 | capture | 01a149cf-665f-7961-9b95-844d9fbdc5e3 | €15.00 | €0.26 | matched |
| 27 | capture | 01a149cf-74b0-740f-881f-713816d52132 | €35.00 | €0.50 | matched |
| 28 | capture | 01a149cf-7f43-778b-b57b-8eb165d96534 | €24.00 | €0.37 | matched |
| 29 | refund | 01a149cf-a3e5-7684-ba88-9c005e126df1 | -€6.00 | €0.00 | matched |
| 30 | capture | 01a149cf-b881-78b6-9921-4e18377ed6a5 | €9.00 | €0.19 | matched |
| 31 | refund | 01a149cf-d626-7308-b6c4-4e6561a7d8a1 | -€10.00 | €0.00 | matched |
| 32 | capture | 01a149d0-13d7-73ef-912e-e4b03f76fd13 | €9.00 | €0.19 | matched |
| 33 | capture | 01a149d0-1e5c-7b55-b430-8a0722109ef0 | €15.00 | €0.26 | matched |
| 34 | capture | 01a149d0-297d-70bf-a168-1f8a0f136251 | €9.00 | €0.19 | matched |
| 35 | capture | 01a149d0-4b68-7d9b-b3a9-3f1abe329c42 | €9.00 | €0.19 | matched |
| 36 | capture | 01a149d0-4dca-7b8b-82b0-4a1ef3aa2ffa | €24.00 | €0.37 | matched |
| 37 | capture | 01a149d0-5046-793c-8d76-a7874e34b671 | €15.00 | €0.26 | matched |
| 38 | capture | 01a149d0-677c-742f-9021-5f7165fc1c5d | €24.00 | €0.37 | matched |
| 39 | capture | 01a149d0-7f2e-71bc-856e-9e7a6fe26979 | €49.00 | €0.67 | matched |
| 40 | capture | 01a149d0-9c21-75ba-84ae-2a76c13436fb | €49.00 | €0.67 | matched |
| 41 | capture | 01a149d0-b84e-72a8-a054-40b33366ed40 | €24.00 | €0.37 | matched |
| 42 | capture | 01a149d0-ba09-7fa8-a999-17075d44b835 | €24.00 | €0.37 | matched |
| 43 | capture | 01a149d0-c0f3-7fd3-9388-2c59c31ad0f3 | €24.00 | €0.37 | matched |
| 44 | capture | 01a149d0-e658-77c3-b55b-d5c9433ab735 | €9.00 | €0.19 | matched |
| 45 | capture | 01a149d0-fcbd-7ae9-a2f2-9155e704eb88 | €49.00 | €0.67 | matched |
| 46 | capture | 01a149d1-1e34-7dcf-9255-c36072c8f84a | €24.00 | €0.37 | matched |
| 48 | capture | 01a149d1-3019-7216-a553-ed4334bb3ad6 | €9.00 | €0.19 | matched |
| 49 | capture | 01a149d1-6856-77ea-857e-337ff7b96952 | €35.00 | €0.50 | matched |
| 50 | capture | 01a149d1-8cdb-77c7-9a50-e1b4716e3af3 | €9.00 | €0.19 | matched |
| 51 | capture | 01a149d1-906b-7c3b-adf2-774d8bfdb628 | €9.00 | €0.19 | matched |
| 52 | capture | 01a149d1-9332-7c16-acb0-1ce69b92e722 | €9.00 | €0.19 | matched |
| 53 | capture | 01a149d1-95a0-75c8-89bc-0a257085a639 | €24.00 | €0.37 | matched |
| 54 | capture | 01a149d1-9b8b-78be-b637-670decc1a387 | €49.00 | €0.67 | matched |
| 55 | capture | 01a149d1-9dcc-75f9-a6df-a397878083f4 | €49.00 | €0.67 | matched |
| 56 | capture | 01a149d1-a52f-780a-a328-6bfe02b30b88 | €49.00 | €0.67 | matched |
| 57 | capture | 01a149d1-aaed-725f-8297-8b9d20e91ebc | €35.00 | €0.50 | matched |
| 58 | capture | 01a149d1-bce9-797c-a012-3e97a558f6d8 | €24.00 | €0.37 | matched |
| 59 | capture | 01a149d1-c599-7c59-af5b-191295a5e0a7 | €35.00 | €0.50 | matched |
| 60 | capture | 01a149d1-c9cb-7b86-81cb-626b67b88ae1 | €49.00 | €0.67 | matched |
| 61 | capture | 01a149d1-cff6-7e9e-9630-027e7ce76b06 | €9.00 | €0.19 | matched |
| 62 | capture | 01a149d1-d45a-796d-bd3c-bcb0bfcc755b | €15.00 | €0.26 | matched |
| 63 | capture | 01a149d1-e2e0-7ec6-819e-80307621f681 | €35.00 | €0.50 | matched |
| 64 | capture | 01a149d1-e5d6-7b83-b522-706e8288c6fb | €15.00 | €0.26 | matched |
| 66 | refund | 01a149d1-ece8-71ef-a264-68df7da3e4fe | -€32.00 | €0.00 | matched |
| 67 | capture | 01a149d2-0320-7e73-bc9e-4f933bfe0617 | €9.00 | €0.19 | matched |
| 68 | capture | 01a149d2-25c9-7ae4-9805-460a0ae8d8ab | €24.00 | €0.37 | matched |
| 69 | capture | 01a149d2-27b0-76a3-9a6e-8e0d0fccdc90 | €49.00 | €0.67 | matched |
| 70 | capture | 01a149d2-2b46-74ea-ae4c-feb921149934 | €35.00 | €0.50 | matched |
| 71 | refund | 01a149d2-2ff2-7084-bbad-88c1c5510db5 | -€11.00 | €0.00 | matched |
| 72 | capture | 01a149d2-32c8-76ef-afb5-cb331145823c | €9.00 | €0.19 | matched |
| 73 | capture | 01a149d2-6bf5-750a-ab54-fca20548fd27 | €35.00 | €0.50 | matched |
| 74 | capture | 01a149d2-70de-7d9b-a471-96e82d467be2 | €49.00 | €0.67 | matched |
| 75 | capture | 01a149d2-8596-755c-b3d5-2e2456f7a2e6 | €24.00 | €0.37 | matched |
| 76 | capture | 01a149d2-8ed2-74d5-9468-680e457e1640 | €15.00 | €0.26 | matched |
| 77 | capture | 01a149d2-9796-77f6-bf64-85181f09dff7 | €49.00 | €0.67 | matched |
| 78 | refund | 01a149d2-a0b4-717f-9369-a5d032bdf289 | -€18.00 | €0.00 | matched |
| 79 | capture | 01a149d2-ae35-7059-a5ab-0d62e6486fa9 | €15.00 | €0.26 | matched |
| 80 | capture | 01a149d2-c7a4-71e6-a14e-ad7eefd29449 | €49.00 | €0.67 | matched |
| 81 | capture | 01a149d2-cee9-78ff-8990-1a106a07025a | €15.00 | €0.26 | matched |
| 82 | capture | 01a149d2-e5c6-7f71-a66b-2b9cc0e62cb8 | €15.00 | €0.26 | matched |
| 83 | capture | 01a149d2-e89f-7f11-ae79-ec0f4b600b1c | €24.00 | €0.37 | matched |
| 84 | capture | 01a149d2-f508-79ac-a199-8d24d06b2c48 | €24.00 | €0.37 | matched |
| 85 | capture | 01a149d2-f7ac-78e8-89d3-1ed20ac36a1b | €24.00 | €0.37 | matched |
| 86 | capture | 01a149d2-fd22-7121-8632-526b465060a6 | €9.00 | €0.19 | matched |
| 87 | capture | 01a149d2-fe0c-7fa0-a605-5e6a56d86f8e | €24.00 | €0.37 | matched |
| 88 | capture | 01a149d3-1874-797c-9378-e98044f1e0da | €15.00 | €0.26 | matched |
| 89 | capture | 01a149d3-181a-767f-92d7-adcf297d4604 | €24.00 | €0.37 | matched |
| 90 | refund | 01a149d3-8ef7-7c16-a6ce-fa05fee1003c | -€13.00 | €0.00 | matched |
| 91 | capture | 01a149d3-d0d2-7834-8d83-6529d53cb9af | €35.00 | €0.50 | matched |
| 92 | capture | 01a149d3-d963-7ef9-81f8-48648d43d9c7 | €35.00 | €0.50 | matched |
| 93 | capture | 01a149d3-debd-7b3f-92ff-72ada4531a03 | €9.00 | €0.19 | matched |
| 94 | capture | 01a149d4-332a-759f-9970-914c73dc5f5b | €24.00 | €0.37 | matched |
| 95 | capture | 01a149d4-48a2-7d36-9429-9d51035adc66 | €35.00 | €0.50 | matched |
| 96 | capture | 01a149d4-5413-725a-854e-e208b4226883 | €24.00 | €0.37 | matched |
| 97 | capture | 01a149d4-b805-70ea-8f07-b2d24bf8f21a | €49.00 | €0.67 | matched |
| 98 | capture | 01a149d4-bb52-74fe-be1d-9e92f6f8a19f | €9.00 | €0.19 | matched |
| 99 | capture | 01a149d4-e976-713b-adeb-2f0cd42befee | €15.00 | €0.26 | matched |
| 100 | capture | 01a149d4-f930-74bf-86b7-bc1653e1ba12 | €9.00 | €0.19 | matched |
| 101 | capture | 01a149d5-034d-7908-9f05-b7423e8b0176 | €24.00 | €0.37 | matched |
| 102 | capture | 01a149d5-276c-76f1-8be4-417b87526161 | €49.00 | €0.67 | matched |
| 103 | capture | 01a149d5-433f-7d97-85d0-bb66eb9b422f | €49.00 | €0.67 | matched |
| 104 | capture | 01a149d5-50bc-748a-814d-7abedd382153 | €49.00 | €0.67 | matched |
| 105 | capture | 01a149d5-996d-70df-8022-89b4f69bac44 | €49.00 | €0.67 | matched |
| 106 | capture | 01a149d5-ad0d-7d7b-ac7a-58250ea5a4a2 | €35.00 | €0.50 | matched |
| 107 | capture | 01a149d5-abe5-7b3b-b6aa-514dd01ec304 | €15.00 | €0.26 | matched |
| 108 | capture | 01a149d5-b3a6-7eec-9c5c-4ac29aa53e4c | €35.00 | €0.50 | matched |
| 109 | capture | 01a149d5-c85d-72d7-84d5-09c52c9ff0e8 | €9.00 | €0.19 | matched |
| 110 | capture | 01a149d5-cb75-7945-873a-95dba9cc1d9f | €15.00 | €0.26 | matched |
| 111 | capture | 01a149d5-e427-70d3-9526-1371b672fd47 | €15.00 | €0.26 | matched |
| 112 | capture | 01a149d5-e86b-7f0f-90b6-0005eab0e241 | €9.00 | €0.19 | matched |
| 113 | capture | 01a149d6-1395-78f7-b44e-bdf4cb406494 | €15.00 | €0.26 | matched |
| 114 | capture | 01a149d6-2111-71f3-9ec5-6c29653ec9d3 | €35.00 | €0.50 | matched |
| 115 | refund | 01a149d6-224d-7580-911b-410521b5310a | -€26.00 | €0.00 | matched |
| 116 | capture | 01a149d6-3e2b-793a-bf44-04daaf53128e | €9.00 | €0.19 | matched |
| 117 | capture | 01a149d6-573f-7c7f-b731-fd5d2e6723e2 | €15.00 | €0.26 | matched |
| 118 | capture | 01a149d6-5cf5-7c5c-bb72-f7ea30380cc5 | €49.00 | €0.67 | matched |
| 119 | capture | 01a149d6-5e50-7bf1-ae2a-1cdd0c7a89d3 | €9.00 | €0.19 | matched |
| 120 | capture | 01a149d6-92eb-7b4e-95b4-a539c55c551c | €15.00 | €0.26 | matched |
| 121 | capture | 01a149d6-aa63-7540-b67f-1c01df719e39 | €35.00 | €0.50 | matched |
| 122 | capture | 01a149d6-afaa-7e59-b3b4-66619a940259 | €49.00 | €0.67 | matched |
| 123 | capture | 01a149d6-dfe4-706d-95c1-6bf92fcb63e9 | €24.00 | €0.37 | matched |
| 124 | capture | 01a149d6-e806-7857-b2f2-7cbe70ea97d5 | €35.00 | €0.50 | matched |
| 125 | capture | 01a149d6-ed29-7141-baba-4c51d66cd14b | €15.00 | €0.26 | matched |
| 126 | capture | 01a149d7-0d15-7e86-961d-3721ccb3420d | €24.00 | €0.37 | matched |
| 127 | capture | 01a149d7-12d1-74f6-ad01-71ed89849414 | €35.00 | €0.50 | matched |