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
- 15 Oct, 01:50145 lines4 breaks
- 15 Oct, 01:40147 lines7 breaks
- 15 Oct, 01:30122 lines1 break
- 15 Oct, 01:20118 lines3 breaks
- 15 Oct, 01:10122 lines2 breaks
- 15 Oct, 01:00130 lines2 breaks
- 15 Oct, 00:50129 lines4 breaks
- 15 Oct, 00:40120 lines2 breaks
- 15 Oct, 00:30137 lines3 breaks
- 15 Oct, 00:20123 lines7 breaks
- 15 Oct, 00:10109 lines2 breaks
- 15 Oct, 00:00117 lines4 breaks
- 14 Oct, 23:50126 lines5 breaks
- 14 Oct, 23:40154 lines1 break
15 Oct, 00:50
Gross
€2,980.00
PSP fee
€46.91
Net to the bank
€2,933.09
Settlement journal
#5727
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13d0a-f2d3-70aa-a9cf-9d0c31b0653a is already settled by stl_EUR_2986709 line 19
- fee differencethe fee is not the contract feethe fee is 42, the contract says 37
- missing linein the books, not in the filecapture:01a13d0a-652b-7b36-9dc0-b358ecca6036 is in no file
- missing linein the books, not in the filecapture:01a13d10-155d-72b5-9d56-76260efa1350 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 20 | capture | 01a13d0a-f306-7625-9767-8e36b13cf866 | €49.00 | €0.67 | duplicate line |
| 25 | capture | 01a13d0b-7a14-7c46-9a78-89941dea32ff | €24.00 | €0.42 | fee difference |
| 1 | capture | 01a13d01-43b3-761d-93f7-fa116c337293 | €9.00 | €0.19 | matched |
| 2 | capture | 01a13d03-e559-7849-bd6d-ad37aeeb21ed | €24.00 | €0.37 | matched |
| 3 | capture | 01a13d04-eec6-740b-bc41-8b42ca6b4aca | €24.00 | €0.37 | matched |
| 4 | capture | 01a13d09-58c7-72a4-8298-ab283f1daf94 | €35.00 | €0.50 | matched |
| 5 | capture | 01a13d09-a3f4-75e7-959d-68c26f24cfee | €35.00 | €0.50 | matched |
| 6 | capture | 01a13d09-b3d1-7db2-9161-afd048326005 | €9.00 | €0.19 | matched |
| 7 | capture | 01a13d09-ba59-7040-8790-48ed9215129f | €15.00 | €0.26 | matched |
| 8 | capture | 01a13d09-bc43-7f93-8604-924a870f8ec1 | €49.00 | €0.67 | matched |
| 9 | capture | 01a13d09-f350-74ea-9715-c17d164a2373 | €49.00 | €0.67 | matched |
| 10 | capture | 01a13d09-f5f5-79e9-99f0-189e4205a409 | €24.00 | €0.37 | matched |
| 11 | capture | 01a13d09-f682-76fb-b149-d6a0366ec1d6 | €9.00 | €0.19 | matched |
| 12 | capture | 01a13d0a-1e14-72e0-a01f-8225928492f5 | €49.00 | €0.67 | matched |
| 13 | capture | 01a13d0a-35c4-7fbf-8f93-69bd57547fa2 | €35.00 | €0.50 | matched |
| 14 | capture | 01a13d0a-35ef-7cb6-9621-928b0138f406 | €49.00 | €0.67 | matched |
| 15 | capture | 01a13d0a-3b11-7dab-9b2c-1f8ec008808c | €9.00 | €0.19 | matched |
| 16 | capture | 01a13d0a-6241-7d3c-ab9a-837ebe26e69a | €24.00 | €0.37 | matched |
| 17 | capture | 01a13d0a-9a19-702b-b99f-63229700faf0 | €15.00 | €0.26 | matched |
| 18 | capture | 01a13d0a-c0e1-762e-829d-934eb3f8edf5 | €35.00 | €0.50 | matched |
| 19 | capture | 01a13d0a-f306-7625-9767-8e36b13cf866 | €49.00 | €0.67 | matched |
| 21 | capture | 01a13d0b-1dcf-70d4-82ff-92ab5ca5b6ea | €15.00 | €0.26 | matched |
| 22 | capture | 01a13d0b-331c-765a-a73b-7fbff672445f | €15.00 | €0.26 | matched |
| 23 | capture | 01a13d0b-4146-70c5-9e01-2a1311f61d8a | €15.00 | €0.26 | matched |
| 24 | capture | 01a13d0b-78da-7356-9510-dd6e22b5583b | €35.00 | €0.50 | matched |
| 26 | capture | 01a13d0b-8599-72b2-81f2-1b82f524c842 | €15.00 | €0.26 | matched |
| 27 | capture | 01a13d0b-89ff-7e4d-9b72-36f749b461e5 | €24.00 | €0.37 | matched |
| 28 | capture | 01a13d0b-8d94-7524-b378-3c1a68396422 | €35.00 | €0.50 | matched |
| 29 | capture | 01a13d0b-93fe-7e62-8456-3d8fcc4bf47f | €9.00 | €0.19 | matched |
| 30 | capture | 01a13d0b-9ca5-7f82-bf92-1e03655f368f | €35.00 | €0.50 | matched |
| 31 | capture | 01a13d0b-a85b-7ac4-be6a-e6390e8d2d61 | €24.00 | €0.37 | matched |
| 32 | capture | 01a13d0b-e791-746c-a8c1-d09cc8679a4e | €15.00 | €0.26 | matched |
| 33 | refund | 01a13d0c-065e-744d-9cec-fb31551eef1e | -€18.00 | €0.00 | matched |
| 34 | capture | 01a13d0c-197e-7ec8-bbaf-7c71c68f2be8 | €15.00 | €0.26 | matched |
| 35 | capture | 01a13d0c-2285-7367-b94a-577d07f7f607 | €35.00 | €0.50 | matched |
| 36 | capture | 01a13d0c-3978-7bc0-a319-3558e9e379b4 | €24.00 | €0.37 | matched |
| 37 | capture | 01a13d0c-42dc-729a-9ac4-244e2e0755e3 | €35.00 | €0.50 | matched |
| 38 | capture | 01a13d0c-5720-7655-8ffe-0816613e045f | €24.00 | €0.37 | matched |
| 39 | capture | 01a13d0c-5734-7e53-95b1-b01b4d456098 | €9.00 | €0.19 | matched |
| 40 | capture | 01a13d0c-5c3e-718c-90a3-7ea97fff1d25 | €35.00 | €0.50 | matched |
| 41 | capture | 01a13d0c-7393-7af1-8b74-ac8c5068cab8 | €24.00 | €0.37 | matched |
| 42 | capture | 01a13d0c-6fa6-77ce-bdf7-96c4dd9cfd9b | €35.00 | €0.50 | matched |
| 43 | capture | 01a13d0c-9cb1-7aeb-84c2-adf2dd011c94 | €24.00 | €0.37 | matched |
| 44 | capture | 01a13d0c-c554-7ff4-bac2-31f62a7c1ff6 | €24.00 | €0.37 | matched |
| 45 | capture | 01a13d0c-c6da-75c8-a002-cc3827e8a0ae | €49.00 | €0.67 | matched |
| 46 | capture | 01a13d0c-d98e-7768-b05e-e85c0926fd5c | €15.00 | €0.26 | matched |
| 47 | refund | 01a13d0c-de22-7198-8ed2-1fe21bc413dc | -€8.00 | €0.00 | matched |
| 48 | capture | 01a13d0c-f7b2-7e53-93ae-7a5b6f041287 | €35.00 | €0.50 | matched |
| 49 | capture | 01a13d0d-1e98-7600-913f-43f9b499bde7 | €49.00 | €0.67 | matched |
| 50 | capture | 01a13d0d-24b3-7998-92db-fe6274e32871 | €24.00 | €0.37 | matched |
| 51 | refund | 01a13d0d-2ab2-738f-9187-6f14aea78fb8 | -€22.00 | €0.00 | matched |
| 52 | capture | 01a13d0d-3826-7415-b24c-2b794a513827 | €9.00 | €0.19 | matched |
| 53 | capture | 01a13d0d-42ce-7815-831b-9bc8e2868c72 | €24.00 | €0.37 | matched |
| 54 | refund | 01a13d0d-50a0-74a6-abff-28105022dec0 | -€9.00 | €0.00 | matched |
| 55 | capture | 01a13d0d-587e-7869-8231-94402174b68f | €9.00 | €0.19 | matched |
| 56 | refund | 01a13d0d-61f4-780e-a29f-d63f221707af | -€25.00 | €0.00 | matched |
| 57 | capture | 01a13d0d-718e-77c5-af05-f9b5fb5da2cc | €49.00 | €0.67 | matched |
| 58 | capture | 01a13d0d-9fb8-73b3-b1bf-4369ca907a0e | €24.00 | €0.37 | matched |
| 59 | capture | 01a13d0d-a6b0-7c90-9d5e-32530c36f289 | €15.00 | €0.26 | matched |
| 60 | capture | 01a13d0d-cb6d-7c75-9bed-5c77d49c70b6 | €35.00 | €0.50 | matched |
| 61 | capture | 01a13d0d-cf3c-7f25-bce1-292f4da0466b | €49.00 | €0.67 | matched |
| 62 | capture | 01a13d0d-d9f3-755f-9a3a-97a1a393fa74 | €15.00 | €0.26 | matched |
| 63 | capture | 01a13d0e-1a87-7687-ba07-bb417aaa0ef5 | €9.00 | €0.19 | matched |
| 64 | capture | 01a13d0e-2816-74fb-8f25-1bba8e32d81a | €15.00 | €0.26 | matched |
| 65 | capture | 01a13d0e-41d6-7f62-bb1a-322ec0e63e69 | €35.00 | €0.50 | matched |
| 66 | capture | 01a13d0e-5447-7aca-8890-8c3ad322ac34 | €9.00 | €0.19 | matched |
| 67 | capture | 01a13d0e-7459-7cc8-a227-c2d907d74bf8 | €15.00 | €0.26 | matched |
| 68 | capture | 01a13d0e-9535-7902-9766-92ad1865bab5 | €15.00 | €0.26 | matched |
| 69 | capture | 01a13d0e-9e96-7e39-87e0-e0176d19eec4 | €49.00 | €0.67 | matched |
| 70 | capture | 01a13d0e-a3d8-772c-a885-f96592d9ce26 | €24.00 | €0.37 | matched |
| 71 | capture | 01a13d0e-a8f2-7cbd-ad9a-c856fd22a973 | €49.00 | €0.67 | matched |
| 72 | capture | 01a13d0e-c13b-7e6b-89aa-cb86ba532052 | €24.00 | €0.37 | matched |
| 73 | capture | 01a13d0e-c2f5-7583-a6e7-c5c3b6ebf1d0 | €49.00 | €0.67 | matched |
| 74 | capture | 01a13d0e-d167-7555-be34-84cf4932c0cd | €24.00 | €0.37 | matched |
| 75 | capture | 01a13d0e-d2e4-780d-8533-845302c331b5 | €9.00 | €0.19 | matched |
| 76 | capture | 01a13d0e-ea5e-7524-a2a0-aea52d3e89d5 | €15.00 | €0.26 | matched |
| 77 | capture | 01a13d0f-2465-7954-a201-cf1f05608876 | €15.00 | €0.26 | matched |
| 78 | capture | 01a13d0f-2a27-7232-9106-6fe64705005a | €49.00 | €0.67 | matched |
| 79 | capture | 01a13d0f-2df5-72cc-a287-f73cd55463a8 | €49.00 | €0.67 | matched |
| 80 | capture | 01a13d0f-2d5b-7658-97ae-aaae9e2989c3 | €9.00 | €0.19 | matched |
| 81 | capture | 01a13d0f-6e5c-71a4-bc35-92303f11e45b | €9.00 | €0.19 | matched |
| 82 | capture | 01a13d0f-7db2-7982-b772-2f85b80b604e | €49.00 | €0.67 | matched |
| 83 | capture | 01a13d0f-82b3-7130-bf77-57e2cab3cf9e | €9.00 | €0.19 | matched |
| 84 | capture | 01a13d0f-902d-7c36-8e19-278b59c47536 | €24.00 | €0.37 | matched |
| 85 | capture | 01a13d0f-9b44-7b9a-bdcc-6fe42d1f941b | €15.00 | €0.26 | matched |
| 86 | capture | 01a13d0f-cb9b-7f15-85f7-a389cf4c9fa9 | €49.00 | €0.67 | matched |
| 87 | refund | 01a13d0f-cccc-7ec8-b34a-bed7023d4def | -€6.00 | €0.00 | matched |
| 88 | capture | 01a13d10-0423-7a64-86d9-fa6c9a22e9c9 | €24.00 | €0.37 | matched |
| 89 | capture | 01a13d10-48e7-74c8-b572-47a8d46d008b | €15.00 | €0.26 | matched |
| 90 | capture | 01a13d10-4a67-7d08-9ab5-0b4d8910d14c | €24.00 | €0.37 | matched |
| 91 | capture | 01a13d10-5081-7747-a8bc-b0da73c8e144 | €15.00 | €0.26 | matched |
| 92 | capture | 01a13d10-50e5-781c-a5d6-58bf751d4cf0 | €49.00 | €0.67 | matched |
| 93 | capture | 01a13d10-6e3a-744d-ae3a-63b4f431099d | €9.00 | €0.19 | matched |
| 94 | capture | 01a13d10-7670-7b7b-a099-dc11ee574dd7 | €24.00 | €0.37 | matched |
| 95 | capture | 01a13d10-8348-74f6-a178-0a69cf1d8804 | €49.00 | €0.67 | matched |
| 96 | capture | 01a13d10-9d03-766e-a87b-471880f8d21a | €9.00 | €0.19 | matched |
| 97 | capture | 01a13d10-d0e3-71d5-8961-9867b29b92d2 | €15.00 | €0.26 | matched |
| 98 | capture | 01a13d10-f285-7d10-837d-f55e6adb7a05 | €24.00 | €0.37 | matched |
| 99 | capture | 01a13d10-f8be-7b6b-848e-c7db415877a6 | €24.00 | €0.37 | matched |
| 100 | capture | 01a13d11-09fc-719a-85e0-a2a208b8a5c9 | €24.00 | €0.37 | matched |
| 101 | capture | 01a13d11-166d-705e-bb95-1fbdfe91f6dd | €49.00 | €0.67 | matched |
| 102 | capture | 01a13d11-1b0b-74ab-bd5e-1a21c9533e2a | €9.00 | €0.19 | matched |
| 103 | capture | 01a13d11-3736-7d79-ab91-a999affb12ea | €49.00 | €0.67 | matched |
| 104 | capture | 01a13d11-3a51-75a6-b501-a90eb5d75757 | €24.00 | €0.37 | matched |
| 105 | refund | 01a13d11-4673-7609-aeb1-0a6da3f81698 | -€5.00 | €0.00 | matched |
| 106 | capture | 01a13d11-5f62-791f-ae88-d0eabe4b204f | €9.00 | €0.19 | matched |
| 107 | refund | 01a13d11-72ce-790f-ad6e-5ec07eb88a4d | -€11.00 | €0.00 | matched |
| 108 | refund | 01a13d11-8457-7d7b-aa28-ad9cc7a10ea5 | -€8.00 | €0.00 | matched |
| 109 | capture | 01a13d11-8b9a-7251-8bcf-6c851fe2e01e | €24.00 | €0.37 | matched |
| 110 | capture | 01a13d11-8f8b-78e2-a3f4-47542e364101 | €9.00 | €0.19 | matched |
| 111 | capture | 01a13d11-9018-77db-9054-94174b3019b9 | €24.00 | €0.37 | matched |
| 112 | capture | 01a13d11-93ae-7ddb-9af2-931c19860429 | €49.00 | €0.67 | matched |
| 113 | capture | 01a13d11-a1cd-7e93-a43d-1f4eadb42e7a | €49.00 | €0.67 | matched |
| 114 | capture | 01a13d11-ae9f-77f2-9faa-48abcb066c84 | €15.00 | €0.26 | matched |
| 115 | capture | 01a13d11-bbee-7e90-a0cb-1b34269f5c53 | €24.00 | €0.37 | matched |
| 116 | capture | 01a13d11-bfea-7416-a797-ec485623f289 | €24.00 | €0.37 | matched |
| 117 | capture | 01a13d11-d7b5-7be8-bd79-a7302ca59dfe | €15.00 | €0.26 | matched |
| 118 | capture | 01a13d11-deb4-780f-a285-f2afbc373d16 | €15.00 | €0.26 | matched |
| 119 | capture | 01a13d11-ffc3-7b1d-9d53-245d10814fcb | €9.00 | €0.19 | matched |
| 120 | capture | 01a13d12-2467-71d7-b52f-10e5febc9916 | €24.00 | €0.37 | matched |
| 121 | capture | 01a13d12-26be-7370-84d0-0af76932e32a | €49.00 | €0.67 | matched |
| 122 | capture | 01a13d12-426d-7195-8a81-535606b39411 | €35.00 | €0.50 | matched |
| 123 | capture | 01a13d12-5f0b-7639-9f99-2c66b4eebd5e | €24.00 | €0.37 | matched |
| 124 | capture | 01a13d12-65d0-7630-abcd-f8b9ab576bc3 | €15.00 | €0.26 | matched |
| 125 | capture | 01a13d12-7d62-72a1-b5ee-329e04e7c49d | €15.00 | €0.26 | matched |
| 126 | capture | 01a13d12-94de-7c2c-af36-fd3ea9711682 | €9.00 | €0.19 | matched |
| 127 | capture | 01a13d12-9f7b-7780-898c-866e5b499cec | €35.00 | €0.50 | matched |
| 128 | capture | 01a13d12-b505-751c-895f-7ee7753860af | €9.00 | €0.19 | matched |
| 129 | capture | 01a13d12-b97d-73a0-a0de-bc30c04870e2 | €15.00 | €0.26 | matched |