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
- 2 Nov, 18:50111 lines1 break
- 2 Nov, 18:40148 lines3 breaks
- 2 Nov, 18:30123 lines2 breaks
- 2 Nov, 18:20139 lines1 break
- 2 Nov, 18:10132 lines7 breaks
- 2 Nov, 18:00123 lines1 break
- 2 Nov, 17:50120 lines2 breaks
- 2 Nov, 17:40130 lines1 break
- 2 Nov, 17:30121 lines4 breaks
- 2 Nov, 17:20125 lines3 breaks
- 2 Nov, 17:10148 lines2 breaks
- 2 Nov, 17:00117 lines5 breaks
- 2 Nov, 16:50138 lines6 breaks
- 2 Nov, 16:40111 lines2 breaks
2 Nov, 17:50
Gross
€2,999.00
PSP fee
€46.93
Net to the bank
€2,952.07
Settlement journal
#346899
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19d66-499f-7bce-a1f1-ed1482d6de1f is already settled by stl_EUR_2989403 line 58
- missing linein the books, not in the filecapture:01a19d67-dd33-7265-96ad-5eb65d8c3e9f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 59 | capture | 01a19d66-4f0a-73dd-b14d-603682c021bf | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a19d5b-8d37-7db1-a050-770f7c8d83d5 | €35.00 | €0.50 | matched |
| 2 | capture | 01a19d5d-678e-7fee-9b56-f3d531d42967 | €49.00 | €0.67 | matched |
| 3 | capture | 01a19d5f-6075-7126-bb0f-4bcb72a2f60c | €15.00 | €0.26 | matched |
| 4 | capture | 01a19d61-e83a-763e-8796-c1bb51dd5399 | €49.00 | €0.67 | matched |
| 5 | capture | 01a19d61-e843-75fc-9092-19106ad72244 | €24.00 | €0.37 | matched |
| 6 | capture | 01a19d61-f44e-7323-b105-2cd7b40fd634 | €35.00 | €0.50 | matched |
| 7 | capture | 01a19d61-fd2e-7aa2-adc4-f60731eea23c | €24.00 | €0.37 | matched |
| 8 | capture | 01a19d62-09a3-7390-bccf-76303b4ab6c9 | €35.00 | €0.50 | matched |
| 9 | refund | 01a19d62-2920-7b47-af0a-23bd94dff86c | -€31.00 | €0.00 | matched |
| 10 | capture | 01a19d62-31c5-7381-9724-fe4a375bb142 | €49.00 | €0.67 | matched |
| 11 | capture | 01a19d62-7a55-7935-9819-c7c39cfd1c45 | €15.00 | €0.26 | matched |
| 12 | capture | 01a19d62-cc43-71c0-8d7a-effb1289e396 | €15.00 | €0.26 | matched |
| 13 | capture | 01a19d62-de5e-7c97-8797-a4e356a3aeff | €9.00 | €0.19 | matched |
| 14 | capture | 01a19d62-e7f7-7668-a029-1dfc1d4cae68 | €15.00 | €0.26 | matched |
| 15 | capture | 01a19d62-f504-79cc-ae8f-c946ebbc88c9 | €24.00 | €0.37 | matched |
| 16 | capture | 01a19d63-2bfb-7a6d-ad60-d00ad89c7717 | €24.00 | €0.37 | matched |
| 17 | capture | 01a19d63-44df-7905-88f2-fc77e595c546 | €9.00 | €0.19 | matched |
| 18 | capture | 01a19d63-4794-7fde-a024-806182c51551 | €49.00 | €0.67 | matched |
| 19 | capture | 01a19d63-5968-71b2-a5e8-4fc9be80491b | €49.00 | €0.67 | matched |
| 20 | capture | 01a19d63-616b-778d-94aa-0087a8aaed10 | €9.00 | €0.19 | matched |
| 21 | capture | 01a19d63-63a2-7a36-b910-7b0355323189 | €24.00 | €0.37 | matched |
| 22 | refund | 01a19d63-729d-7172-94aa-6d7b062e8928 | -€6.00 | €0.00 | matched |
| 23 | capture | 01a19d63-bff3-7e4f-8551-82a023bea07a | €49.00 | €0.67 | matched |
| 24 | capture | 01a19d64-1fe0-7038-b508-5a5ed5ddb3a7 | €15.00 | €0.26 | matched |
| 25 | capture | 01a19d64-2817-7ffa-aec3-952215a912d9 | €49.00 | €0.67 | matched |
| 26 | capture | 01a19d64-3b45-705c-833c-b166f9bf5e67 | €35.00 | €0.50 | matched |
| 27 | capture | 01a19d64-4d0b-7434-8be8-33539ae4980c | €35.00 | €0.50 | matched |
| 28 | capture | 01a19d64-6b7c-7e91-8c5a-74d5c093e7ae | €24.00 | €0.37 | matched |
| 29 | capture | 01a19d64-aaf1-784a-8d92-6e4c871b2ecd | €35.00 | €0.50 | matched |
| 30 | capture | 01a19d64-cf26-76bc-a041-827c14491cb8 | €9.00 | €0.19 | matched |
| 31 | capture | 01a19d64-db55-7367-9c5d-63e3c3fe28db | €15.00 | €0.26 | matched |
| 32 | refund | 01a19d64-db35-701d-8a1c-4d8b39a19a8c | -€18.00 | €0.00 | matched |
| 33 | capture | 01a19d65-19f7-7023-9f02-7063962f702e | €49.00 | €0.67 | matched |
| 34 | capture | 01a19d65-2d81-7903-8cc6-52fb9e9ca62d | €35.00 | €0.50 | matched |
| 35 | capture | 01a19d65-3726-7787-a672-d40b40bb09e3 | €35.00 | €0.50 | matched |
| 36 | capture | 01a19d65-3874-72bc-b74d-bdcb4cd02ca9 | €24.00 | €0.37 | matched |
| 37 | capture | 01a19d65-3d16-7480-838f-a4444b327342 | €49.00 | €0.67 | matched |
| 38 | capture | 01a19d65-43cc-721c-b6c5-224ff5fbe670 | €24.00 | €0.37 | matched |
| 39 | capture | 01a19d65-537f-7f94-8f76-a0ffa0b4fc64 | €35.00 | €0.50 | matched |
| 40 | refund | 01a19d65-5a46-79dc-a705-8729b52bab4a | -€47.00 | €0.00 | matched |
| 41 | capture | 01a19d65-6530-7594-9ea1-56d05dc21ec4 | €9.00 | €0.19 | matched |
| 42 | capture | 01a19d65-7f98-73cf-9495-5ea53a40d59c | €35.00 | €0.50 | matched |
| 43 | capture | 01a19d65-844f-7d39-95fd-b394a7e63f27 | €15.00 | €0.26 | matched |
| 44 | capture | 01a19d65-8450-744e-8767-26c40b646996 | €49.00 | €0.67 | matched |
| 45 | capture | 01a19d65-89f3-7868-b4e4-3844dcf87f93 | €9.00 | €0.19 | matched |
| 46 | capture | 01a19d65-99e9-714b-8f78-2eefc4b15f5f | €49.00 | €0.67 | matched |
| 47 | capture | 01a19d65-99eb-7d84-b40a-1a07273ceece | €35.00 | €0.50 | matched |
| 48 | capture | 01a19d65-aa20-7a53-847b-02a08dba7d39 | €49.00 | €0.67 | matched |
| 49 | capture | 01a19d65-b237-7583-9da9-97dff0325f0f | €49.00 | €0.67 | matched |
| 50 | capture | 01a19d65-ba32-755d-9011-be98258c5dc8 | €35.00 | €0.50 | matched |
| 51 | refund | 01a19d65-bcc4-7c04-a5b6-ca59b56155a8 | -€9.00 | €0.00 | matched |
| 52 | capture | 01a19d65-ca0d-7790-8e6d-ba1f9a66a220 | €24.00 | €0.37 | matched |
| 53 | capture | 01a19d65-cbdd-77b5-a697-b5fdd1d333c8 | €24.00 | €0.37 | matched |
| 54 | capture | 01a19d65-d12c-7948-b297-b7f07f51e870 | €35.00 | €0.50 | matched |
| 55 | capture | 01a19d65-ebd5-722d-b864-01f0688145db | €15.00 | €0.26 | matched |
| 56 | capture | 01a19d65-f6f4-7ccc-b9b8-2780100eb6f0 | €24.00 | €0.37 | matched |
| 57 | capture | 01a19d66-1cbb-76f9-a8bf-c44e08f8eede | €15.00 | €0.26 | matched |
| 58 | capture | 01a19d66-4f0a-73dd-b14d-603682c021bf | €49.00 | €0.67 | matched |
| 60 | capture | 01a19d66-5527-7182-9fba-a4023a40a2e2 | €9.00 | €0.19 | matched |
| 61 | capture | 01a19d66-56d5-7482-bbfa-3d7427a3dbbc | €15.00 | €0.26 | matched |
| 62 | capture | 01a19d66-56bd-725e-876a-eaee227c6d81 | €49.00 | €0.67 | matched |
| 63 | capture | 01a19d66-6815-7de4-8057-3546283b59b0 | €15.00 | €0.26 | matched |
| 64 | capture | 01a19d66-8737-7bcd-a2e8-a22bbf8ae7b8 | €35.00 | €0.50 | matched |
| 65 | refund | 01a19d66-99f5-7a5a-ae21-37b2f6455897 | -€13.00 | €0.00 | matched |
| 66 | capture | 01a19d66-d24e-7910-86d7-35ec368a6f60 | €15.00 | €0.26 | matched |
| 67 | capture | 01a19d66-da87-7845-989c-852ce037b466 | €24.00 | €0.37 | matched |
| 68 | capture | 01a19d67-0331-7a0a-b887-12dd8892e835 | €24.00 | €0.37 | matched |
| 69 | capture | 01a19d67-2576-7172-bbfa-a846688b72e4 | €9.00 | €0.19 | matched |
| 70 | capture | 01a19d67-3311-73f0-9650-1caf99d3d913 | €35.00 | €0.50 | matched |
| 71 | capture | 01a19d67-363e-7e18-a32a-e119f8bf340e | €9.00 | €0.19 | matched |
| 72 | capture | 01a19d67-429e-72b8-b1cc-c14e24ed9e6c | €49.00 | €0.67 | matched |
| 73 | capture | 01a19d67-717a-72bd-84a5-456b391c3b6d | €24.00 | €0.37 | matched |
| 74 | capture | 01a19d67-98d7-7818-b573-24b7585d8265 | €49.00 | €0.67 | matched |
| 75 | capture | 01a19d67-af67-72eb-b68f-ae891bf6e647 | €24.00 | €0.37 | matched |
| 76 | capture | 01a19d67-b01d-76ed-8f23-00f3916575ea | €15.00 | €0.26 | matched |
| 77 | capture | 01a19d67-b3ad-7f33-ab30-9561834574c4 | €24.00 | €0.37 | matched |
| 78 | capture | 01a19d67-bfe8-7f59-b55a-e33a7167a554 | €15.00 | €0.26 | matched |
| 79 | capture | 01a19d67-e2f6-7e18-b0da-527799f2b271 | €9.00 | €0.19 | matched |
| 80 | capture | 01a19d67-e6d9-78e6-9e86-e9a7e82fbd76 | €15.00 | €0.26 | matched |
| 81 | capture | 01a19d67-ebd3-713f-9967-b32608303b32 | €15.00 | €0.26 | matched |
| 82 | capture | 01a19d68-0962-7069-8e12-f4941efdb4cb | €15.00 | €0.26 | matched |
| 83 | capture | 01a19d68-09b9-7dc1-97b2-3a95e6b12392 | €9.00 | €0.19 | matched |
| 84 | capture | 01a19d68-070e-794b-a163-bdec88c7f1bb | €35.00 | €0.50 | matched |
| 85 | capture | 01a19d68-1aa8-749a-9730-15c3bd7e0d45 | €49.00 | €0.67 | matched |
| 86 | refund | 01a19d68-20cc-714a-9451-1be3298d33b9 | -€14.00 | €0.00 | matched |
| 87 | capture | 01a19d68-3cf2-756f-a024-e2e8c1705677 | €49.00 | €0.67 | matched |
| 88 | capture | 01a19d68-57fc-7a7a-a939-967d2be2f7ae | €35.00 | €0.50 | matched |
| 89 | capture | 01a19d68-7841-7594-8b78-8c4856f48148 | €24.00 | €0.37 | matched |
| 90 | capture | 01a19d68-7e11-71fc-a27e-a3481299e42a | €35.00 | €0.50 | matched |
| 91 | capture | 01a19d68-884a-7862-8746-ce747f455a28 | €15.00 | €0.26 | matched |
| 92 | refund | 01a19d68-91b8-7549-9d27-c934790fba59 | -€14.00 | €0.00 | matched |
| 93 | capture | 01a19d68-d899-7838-a5dc-df5d9d0b76f0 | €24.00 | €0.37 | matched |
| 94 | capture | 01a19d68-df5b-724e-84bf-637128f07b10 | €35.00 | €0.50 | matched |
| 95 | capture | 01a19d69-0181-7d2f-8c8f-81faaab505af | €9.00 | €0.19 | matched |
| 96 | capture | 01a19d69-0f56-7878-a24e-1d0c6a67120a | €49.00 | €0.67 | matched |
| 97 | capture | 01a19d69-177a-7851-9dfd-be9d57402f85 | €9.00 | €0.19 | matched |
| 98 | capture | 01a19d69-190c-7f1d-9c0a-707fc48d81ed | €24.00 | €0.37 | matched |
| 99 | capture | 01a19d69-2c23-77bd-84a1-0ba35b5e0315 | €15.00 | €0.26 | matched |
| 100 | capture | 01a19d69-a9b5-7d53-8e36-a75a9eb9b87b | €35.00 | €0.50 | matched |
| 101 | capture | 01a19d69-aa4b-7cc5-b40d-72d9f4de2031 | €15.00 | €0.26 | matched |
| 102 | capture | 01a19d69-b787-7ede-8cb0-9e6d33aebbca | €24.00 | €0.37 | matched |
| 103 | capture | 01a19d69-bece-7033-af0c-89e8709c2a4c | €15.00 | €0.26 | matched |
| 104 | capture | 01a19d69-d519-7422-88fd-4f3336cd3497 | €49.00 | €0.67 | matched |
| 105 | capture | 01a19d69-e34e-79c8-92eb-6f8b9cdd9d28 | €49.00 | €0.67 | matched |
| 106 | capture | 01a19d6a-0881-7933-87fb-952e50454b11 | €35.00 | €0.50 | matched |
| 107 | capture | 01a19d6a-0aa8-75fa-88a9-6946a57aead4 | €9.00 | €0.19 | matched |
| 108 | refund | 01a19d6a-12f3-7b80-9cad-0433926fee15 | -€9.00 | €0.00 | matched |
| 109 | capture | 01a19d6a-2721-7104-9653-51ecd5eb73f2 | €49.00 | €0.67 | matched |
| 110 | capture | 01a19d6a-3a6e-778e-9f28-86731d1584c7 | €49.00 | €0.67 | matched |
| 111 | capture | 01a19d6a-47de-70e3-ae25-45c472b2270f | €35.00 | €0.50 | matched |
| 112 | capture | 01a19d6a-4750-75fb-8bb1-90ffb15abbbe | €9.00 | €0.19 | matched |
| 113 | capture | 01a19d6a-9208-7e4f-a2a8-53e99f2a53b3 | €24.00 | €0.37 | matched |
| 114 | capture | 01a19d6a-9d82-72a1-b757-c58bab524ec3 | €15.00 | €0.26 | matched |
| 115 | capture | 01a19d6a-9ddf-7869-bc66-3879d891ef15 | €49.00 | €0.67 | matched |
| 116 | capture | 01a19d6a-bbcd-7161-a431-76bc02be375a | €24.00 | €0.37 | matched |
| 117 | capture | 01a19d6a-be0c-7fa1-a0a4-25752dcab9ea | €24.00 | €0.37 | matched |
| 118 | capture | 01a19d6a-e7b9-7595-b599-66c57457238b | €35.00 | €0.50 | matched |
| 119 | capture | 01a19d6a-f1a8-7791-83bb-662be2acdd98 | €49.00 | €0.67 | matched |
| 120 | capture | 01a19d6a-f28a-7959-a2fe-088f41c82f5d | €15.00 | €0.26 | matched |