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
- 1 Nov, 12:10143 lines1 break
- 1 Nov, 12:00113 lines4 breaks
- 1 Nov, 11:50139 lines2 breaks
- 1 Nov, 11:40130 lines5 breaks
- 1 Nov, 11:30139 lines6 breaks
- 1 Nov, 11:20114 lines2 breaks
- 1 Nov, 11:10121 lines2 breaks
- 1 Nov, 11:00126 lines3 breaks
- 1 Nov, 10:50119 lines5 breaks
- 1 Nov, 10:40124 lines4 breaks
- 1 Nov, 10:30107 lines3 breaks
- 1 Nov, 10:20136 lines3 breaks
- 1 Nov, 10:10113 lines2 breaks
- 1 Nov, 10:00137 lines4 breaks
1 Nov, 10:40
Gross
€2,807.00
PSP fee
€45.40
Net to the bank
€2,761.60
Settlement journal
#323154
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a196b4-497b-7533-ab47-f8a8309ac7ad is already settled by stl_EUR_2989216 line 36
- fee differencethe fee is not the contract feethe fee is 52, the contract says 50
- missing linein the books, not in the filecapture:01a196ba-13f0-7e45-aaa4-6a11c44e9c72 is in no file
- missing linein the books, not in the filecapture:01a196ba-4118-7eac-a560-4de02037616d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 37 | capture | 01a196b4-49b1-7a46-ac4d-9f90d5fcbee0 | €9.00 | €0.19 | duplicate line |
| 57 | capture | 01a196b6-068f-7ea3-a26d-c30239fb2f3e | €35.00 | €0.52 | fee difference |
| 1 | capture | 01a196a9-3339-76b6-8825-d546153af794 | €49.00 | €0.67 | matched |
| 2 | capture | 01a196ae-eb6c-76d3-b50b-2ec6d07b5fbc | €49.00 | €0.67 | matched |
| 3 | capture | 01a196b0-8883-7f71-b30f-a7a96ecfbe07 | €49.00 | €0.67 | matched |
| 4 | capture | 01a196b0-e0a8-7d37-955f-f45f0d1c25d2 | €24.00 | €0.37 | matched |
| 5 | capture | 01a196b1-e29f-7e7d-ba19-8386899e1570 | €15.00 | €0.26 | matched |
| 6 | capture | 01a196b1-f183-7c2e-a984-faa212115179 | €15.00 | €0.26 | matched |
| 7 | capture | 01a196b2-0ab1-7a38-a0fc-811b05baa750 | €24.00 | €0.37 | matched |
| 8 | capture | 01a196b2-1190-732a-8deb-d66a957ee3b4 | €35.00 | €0.50 | matched |
| 9 | refund | 01a196b2-0e6e-762e-a2e1-61b8f01948ef | -€14.00 | €0.00 | matched |
| 10 | capture | 01a196b2-3a77-7607-9ab6-3e46250d8a92 | €24.00 | €0.37 | matched |
| 11 | capture | 01a196b2-51a3-7409-9ace-e4b7ccd2c796 | €9.00 | €0.19 | matched |
| 12 | capture | 01a196b2-8eed-73c2-a2e2-96343173831d | €15.00 | €0.26 | matched |
| 13 | capture | 01a196b2-9bc3-7f0d-a3fd-5b3c87f603dc | €35.00 | €0.50 | matched |
| 14 | refund | 01a196b2-a641-7793-b921-f407acabd9dd | -€18.00 | €0.00 | matched |
| 15 | capture | 01a196b2-c6e9-7fca-927b-879c5294caf4 | €35.00 | €0.50 | matched |
| 16 | capture | 01a196b2-c8d0-795b-8fb0-375c791059ce | €49.00 | €0.67 | matched |
| 17 | capture | 01a196b2-dacc-7571-af55-1ad80c74cd37 | €49.00 | €0.67 | matched |
| 18 | capture | 01a196b2-f7d5-7799-8dca-bc365a1bd7d8 | €35.00 | €0.50 | matched |
| 19 | capture | 01a196b2-fb2d-7f0b-80d5-7d0f11e3850a | €35.00 | €0.50 | matched |
| 20 | capture | 01a196b3-0177-7633-8e43-527d7781fc7d | €49.00 | €0.67 | matched |
| 21 | capture | 01a196b3-1862-7dab-b0e3-d8479410f831 | €24.00 | €0.37 | matched |
| 22 | capture | 01a196b3-1eee-79c8-85e3-e7f2c58a7609 | €15.00 | €0.26 | matched |
| 23 | refund | 01a196b3-524c-7324-b169-cd357e2684f9 | -€19.00 | €0.00 | matched |
| 24 | capture | 01a196b3-68cb-723a-b7f9-c80efe290e53 | €24.00 | €0.37 | matched |
| 25 | capture | 01a196b3-6fdd-788d-8e74-f7b7616a912d | €9.00 | €0.19 | matched |
| 26 | capture | 01a196b3-99c8-7881-afaa-556b9514dff4 | €15.00 | €0.26 | matched |
| 27 | capture | 01a196b3-a712-74c2-9eae-ac89a72714e7 | €24.00 | €0.37 | matched |
| 28 | capture | 01a196b3-a966-7984-bef8-acb24fc65b71 | €9.00 | €0.19 | matched |
| 29 | capture | 01a196b3-e105-7950-bac9-2b8abb7ebfe5 | €49.00 | €0.67 | matched |
| 30 | capture | 01a196b4-13bf-72ef-afce-549e7275193e | €15.00 | €0.26 | matched |
| 31 | capture | 01a196b4-21bb-787f-a5d4-b1a954a480a8 | €24.00 | €0.37 | matched |
| 32 | capture | 01a196b4-2ee2-7695-85ce-c5f3f8f09467 | €15.00 | €0.26 | matched |
| 33 | capture | 01a196b4-31d1-7746-a367-8dc5d56fddf6 | €9.00 | €0.19 | matched |
| 34 | capture | 01a196b4-3594-7f62-b95d-516a529e7f11 | €35.00 | €0.50 | matched |
| 35 | capture | 01a196b4-3b93-7ba7-9aa7-7d3d4372949c | €49.00 | €0.67 | matched |
| 36 | capture | 01a196b4-49b1-7a46-ac4d-9f90d5fcbee0 | €9.00 | €0.19 | matched |
| 38 | capture | 01a196b4-4fe2-798d-8574-cd71b811fb1e | €35.00 | €0.50 | matched |
| 39 | capture | 01a196b4-5103-7901-9ae2-d1aae89651f7 | €24.00 | €0.37 | matched |
| 40 | capture | 01a196b4-6ca3-78cd-a3a8-19a0bee6e915 | €24.00 | €0.37 | matched |
| 41 | capture | 01a196b4-aa9a-7568-84ee-94d771d0cb0d | €24.00 | €0.37 | matched |
| 42 | capture | 01a196b4-bf77-754a-801c-44297bd42e37 | €9.00 | €0.19 | matched |
| 43 | capture | 01a196b4-dbe7-709a-9192-350e08cf142c | €9.00 | €0.19 | matched |
| 44 | capture | 01a196b4-e4cf-77c2-992f-1cdcbd12070e | €15.00 | €0.26 | matched |
| 45 | capture | 01a196b5-0854-7728-9ed9-47bc97bb7113 | €9.00 | €0.19 | matched |
| 46 | capture | 01a196b5-2176-7994-a104-e9364e0fa93c | €49.00 | €0.67 | matched |
| 47 | capture | 01a196b5-3663-74e2-a4fe-94757551b1fc | €15.00 | €0.26 | matched |
| 48 | capture | 01a196b5-6ecc-7994-ac16-6a416c1d4bb5 | €9.00 | €0.19 | matched |
| 49 | capture | 01a196b5-7280-79bb-a39c-f8bd94cb912e | €35.00 | €0.50 | matched |
| 50 | capture | 01a196b5-ac97-7935-be38-9ab39300befb | €9.00 | €0.19 | matched |
| 51 | capture | 01a196b5-b0bd-738e-8228-7147bc4802b1 | €9.00 | €0.19 | matched |
| 52 | capture | 01a196b5-b792-73ce-a890-499ed89fc722 | €15.00 | €0.26 | matched |
| 53 | capture | 01a196b5-cf4e-7e44-a23e-bb154bea2910 | €9.00 | €0.19 | matched |
| 54 | capture | 01a196b5-e619-7779-a371-98105ddf0b57 | €35.00 | €0.50 | matched |
| 55 | capture | 01a196b5-ee49-7ea7-94ed-21630c3d7781 | €15.00 | €0.26 | matched |
| 56 | capture | 01a196b6-02e9-7ab5-a978-d85f32e7f2e0 | €35.00 | €0.50 | matched |
| 58 | capture | 01a196b6-07f3-7de7-973e-c8e254269535 | €9.00 | €0.19 | matched |
| 59 | refund | 01a196b6-0a9f-7b25-b3fb-6bd0a11e34d6 | -€7.00 | €0.00 | matched |
| 60 | capture | 01a196b6-29c4-73c3-8cce-24d532260a7f | €35.00 | €0.50 | matched |
| 61 | capture | 01a196b6-3750-7a14-8689-410957d13ceb | €49.00 | €0.67 | matched |
| 62 | capture | 01a196b6-3b8c-79a9-826d-629440c9549e | €9.00 | €0.19 | matched |
| 63 | capture | 01a196b6-3e4f-7f79-9cd5-23d526854541 | €35.00 | €0.50 | matched |
| 64 | capture | 01a196b6-7ee9-7829-9836-5f01affd5d92 | €9.00 | €0.19 | matched |
| 65 | capture | 01a196b6-8a75-7d77-9ba9-c2393ba0d525 | €24.00 | €0.37 | matched |
| 66 | capture | 01a196b6-8fe1-7ded-a77c-fbf710a2024b | €9.00 | €0.19 | matched |
| 67 | capture | 01a196b6-9cac-779e-b84b-7795fa447a1f | €49.00 | €0.67 | matched |
| 68 | capture | 01a196b6-a93e-7047-8207-3bdb989f0960 | €49.00 | €0.67 | matched |
| 69 | capture | 01a196b6-b3e8-7f03-b5e0-880b54e6b69b | €24.00 | €0.37 | matched |
| 70 | capture | 01a196b6-b447-70a9-a97a-544fe1a3e146 | €9.00 | €0.19 | matched |
| 71 | capture | 01a196b6-e261-70db-ac38-dfdb8f97e774 | €24.00 | €0.37 | matched |
| 72 | capture | 01a196b7-4ab4-7508-a68a-b93d975968ea | €9.00 | €0.19 | matched |
| 73 | capture | 01a196b7-4cc5-7cca-aad8-6f6c7c2e312a | €15.00 | €0.26 | matched |
| 74 | capture | 01a196b7-5238-711b-a5e5-c7190cba47de | €9.00 | €0.19 | matched |
| 75 | capture | 01a196b7-5e6a-7e9d-b073-4033af2ea34d | €15.00 | €0.26 | matched |
| 76 | capture | 01a196b7-8d6d-7475-90dc-b772ef2a0573 | €35.00 | €0.50 | matched |
| 77 | capture | 01a196b7-b1ce-7892-abcf-c7e6d58f6c3d | €15.00 | €0.26 | matched |
| 78 | capture | 01a196b7-b4c7-720a-ae59-beb7af6e56f3 | €9.00 | €0.19 | matched |
| 79 | capture | 01a196b7-dcf0-75df-862d-18334963c1d4 | €49.00 | €0.67 | matched |
| 80 | capture | 01a196b7-e61d-7903-95b3-9a9c5ba144d9 | €15.00 | €0.26 | matched |
| 81 | capture | 01a196b8-0ad6-75d4-8b4e-1e2d4904a828 | €35.00 | €0.50 | matched |
| 82 | capture | 01a196b8-5243-7e69-ae22-8e5d16d3bd0c | €49.00 | €0.67 | matched |
| 83 | capture | 01a196b8-62de-77b6-bd1c-39e89f526a14 | €49.00 | €0.67 | matched |
| 84 | capture | 01a196b8-6779-77ae-885f-06fc1835ba6f | €49.00 | €0.67 | matched |
| 85 | capture | 01a196b8-7dd9-7979-9704-110e147c484d | €35.00 | €0.50 | matched |
| 86 | capture | 01a196b8-7e11-7ef3-84f7-0f5fea786d04 | €35.00 | €0.50 | matched |
| 87 | capture | 01a196b8-8780-7e31-b716-fec2cd7e8a32 | €24.00 | €0.37 | matched |
| 88 | refund | 01a196b8-8ce4-7e2c-b563-01c8ebd47445 | -€32.00 | €0.00 | matched |
| 89 | capture | 01a196b8-a5b8-7789-b457-684e451dff62 | €35.00 | €0.50 | matched |
| 90 | capture | 01a196b8-aa25-75e3-a4ca-1473db1eee9e | €49.00 | €0.67 | matched |
| 91 | capture | 01a196b8-c4c8-77d8-b35a-1ae420599f1a | €35.00 | €0.50 | matched |
| 92 | capture | 01a196b8-c66d-71d6-a6d9-08e92e2eba98 | €49.00 | €0.67 | matched |
| 93 | capture | 01a196b9-3214-70c0-afae-d16be82707f5 | €49.00 | €0.67 | matched |
| 94 | capture | 01a196b9-54ad-73ab-9c5d-ea51e48608be | €35.00 | €0.50 | matched |
| 95 | capture | 01a196b9-5656-7456-879b-f461c0db7aa8 | €9.00 | €0.19 | matched |
| 96 | capture | 01a196b9-5862-7316-93b8-2dd31169ba86 | €9.00 | €0.19 | matched |
| 97 | capture | 01a196b9-6976-7395-b043-7305a245a286 | €35.00 | €0.50 | matched |
| 98 | capture | 01a196b9-757f-7723-b02d-61c226702966 | €35.00 | €0.50 | matched |
| 99 | capture | 01a196b9-84a2-7bf7-93ae-c4e2dd5b5160 | €49.00 | €0.67 | matched |
| 100 | capture | 01a196b9-b87d-72b0-a2bd-bfebab1f726c | €9.00 | €0.19 | matched |
| 101 | capture | 01a196b9-c1b8-7c0d-9ee8-0155fb89ac61 | €15.00 | €0.26 | matched |
| 102 | capture | 01a196b9-c0b7-70e5-8f7e-66131286d8df | €35.00 | €0.50 | matched |
| 103 | capture | 01a196b9-fbfe-7069-a156-d8fbea3218dc | €49.00 | €0.67 | matched |
| 104 | capture | 01a196ba-1637-73a9-8e4c-b73da032ed0e | €35.00 | €0.50 | matched |
| 105 | capture | 01a196ba-196a-7554-b07d-033f659a6a32 | €9.00 | €0.19 | matched |
| 106 | capture | 01a196ba-198c-76fe-9e6c-9496b8a4940e | €9.00 | €0.19 | matched |
| 107 | capture | 01a196ba-2029-7c6f-97c8-9b5b9b47edcb | €49.00 | €0.67 | matched |
| 108 | capture | 01a196ba-244a-71f9-a6ee-2c2b3e6bccb8 | €9.00 | €0.19 | matched |
| 109 | capture | 01a196ba-27f0-7dbf-872f-bb39e4f3e3ee | €15.00 | €0.26 | matched |
| 110 | refund | 01a196ba-4015-722c-9dc9-5ad73405215e | -€29.00 | €0.00 | matched |
| 111 | refund | 01a196ba-4240-7b5b-935e-951f858b5b3c | -€23.00 | €0.00 | matched |
| 112 | capture | 01a196ba-42aa-7765-9834-cf04964c78e0 | €24.00 | €0.37 | matched |
| 113 | capture | 01a196ba-5ec0-7085-ad10-6bd29d0d61c7 | €35.00 | €0.50 | matched |
| 114 | capture | 01a196ba-684a-7e07-b2df-a37d271e8208 | €9.00 | €0.19 | matched |
| 115 | refund | 01a196ba-68af-7453-a9a3-56d1ef10c108 | -€42.00 | €0.00 | matched |
| 116 | refund | 01a196ba-6ec4-7204-9894-d59b7287737b | -€9.00 | €0.00 | matched |
| 117 | capture | 01a196ba-77e8-7d84-9caf-7b26035f16c8 | €24.00 | €0.37 | matched |
| 118 | capture | 01a196ba-98a1-7a6b-af66-2467e8f17d76 | €49.00 | €0.67 | matched |
| 119 | capture | 01a196ba-bca5-7368-946c-5749b1a5a998 | €9.00 | €0.19 | matched |
| 120 | capture | 01a196ba-c4fb-7db5-a024-8bde35806818 | €49.00 | €0.67 | matched |
| 121 | refund | 01a196ba-c5fa-76c4-a8b3-0a46bf15106a | -€10.00 | €0.00 | matched |
| 122 | capture | 01a196ba-d155-7c18-957e-774c7a863fd5 | €15.00 | €0.26 | matched |
| 123 | capture | 01a196ba-e18c-7ea8-ab2a-3acb6f89504e | €35.00 | €0.50 | matched |
| 124 | capture | 01a196ba-ef95-7440-9efb-31ea8d2d99fe | €9.00 | €0.19 | matched |