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
- 3 Nov, 16:10138 lines2 breaks
- 3 Nov, 16:00109 lines1 break
- 3 Nov, 15:50147 lines5 breaks
- 3 Nov, 15:40140 lines2 breaks
- 3 Nov, 15:30144 lines6 breaks
- 3 Nov, 15:20114 linesclean
- 3 Nov, 15:10130 lines6 breaks
- 3 Nov, 15:00120 lines1 break
- 3 Nov, 14:50127 lines5 breaks
- 3 Nov, 14:40123 lines2 breaks
- 3 Nov, 14:30125 lines2 breaks
- 3 Nov, 14:20122 lines1 break
- 3 Nov, 14:10118 lines3 breaks
- 3 Nov, 14:00112 lines2 breaks
3 Nov, 15:10
Gross
€3,115.00
PSP fee
€49.30
Net to the bank
€3,065.70
Settlement journal
#363110
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a1f7-f031-770b-98bc-56063b71cee7 is already settled by stl_EUR_2989531 line 32
- fee differencethe fee is not the contract feethe fee is 54, the contract says 50
- fee differencethe fee is not the contract feethe fee is 69, the contract says 67
- fee differencethe fee is not the contract feethe fee is 1, the contract says 0
- fee differencethe fee is not the contract feethe fee is 24, the contract says 19
- missing linein the books, not in the filecapture:01a1a1f8-5abb-752a-88b8-43a1bced35a5 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 33 | capture | 01a1a1f7-f055-771e-9367-c35761303395 | €15.00 | €0.26 | duplicate line |
| 38 | capture | 01a1a1f8-2d9f-7028-b446-3effcb84893d | €35.00 | €0.54 | fee difference |
| 81 | capture | 01a1a1fa-ec11-7d7d-b27f-c07731552f36 | €49.00 | €0.69 | fee difference |
| 94 | refund | 01a1a1fb-f370-73d1-80ec-44fe94d1473e | -€28.00 | €0.01 | fee difference |
| 1 | capture | 01a1a1f3-240e-702d-beff-b0ab3857bedb | €9.00 | €0.19 | matched |
| 2 | capture | 01a1a1f5-da5b-727a-8fb2-b9e1cfc45756 | €35.00 | €0.50 | matched |
| 3 | capture | 01a1a1f5-e048-7896-a273-16d21bb857a9 | €49.00 | €0.67 | matched |
| 4 | capture | 01a1a1f5-e582-76f1-9c1c-c5707f9be0bf | €15.00 | €0.26 | matched |
| 5 | capture | 01a1a1f6-419a-77fa-81df-5dab2e8dc1dd | €35.00 | €0.50 | matched |
| 6 | capture | 01a1a1f6-4ca9-7529-9bea-1cbb9b7d3ccc | €24.00 | €0.37 | matched |
| 7 | capture | 01a1a1f6-50c4-7d3f-b6ba-946c0ece18d9 | €24.00 | €0.37 | matched |
| 8 | capture | 01a1a1f6-5174-73d9-81cc-8eda0017bf7b | €15.00 | €0.26 | matched |
| 9 | capture | 01a1a1f6-76d7-7194-95ad-1d2898bc0d9c | €49.00 | €0.67 | matched |
| 10 | capture | 01a1a1f6-7be1-73d6-8219-ee66321f10a9 | €35.00 | €0.50 | matched |
| 11 | capture | 01a1a1f6-95a3-7998-91d3-a641cc3bf09c | €49.00 | €0.67 | matched |
| 12 | capture | 01a1a1f6-aeb1-7010-9cdd-265284f713fd | €49.00 | €0.67 | matched |
| 13 | capture | 01a1a1f6-c35e-7185-b1ea-6670db7fb932 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1a1f6-daa3-7203-9639-355123d166f8 | €15.00 | €0.26 | matched |
| 15 | capture | 01a1a1f6-f432-7076-b42f-bb42828fc829 | €9.00 | €0.19 | matched |
| 16 | capture | 01a1a1f7-03c7-745a-9d13-ec155768f53d | €24.00 | €0.37 | matched |
| 17 | refund | 01a1a1f7-0ae1-71a8-8e7a-ce45033fa1d0 | -€26.00 | €0.00 | matched |
| 18 | capture | 01a1a1f7-0af8-79c6-8037-a1a5892a8ff7 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1a1f7-37a8-7010-9144-90227476906d | €15.00 | €0.26 | matched |
| 20 | capture | 01a1a1f7-437b-7ceb-bd90-3fba8e93de16 | €35.00 | €0.50 | matched |
| 21 | capture | 01a1a1f7-50ca-79b0-9b52-76728614192d | €24.00 | €0.37 | matched |
| 22 | capture | 01a1a1f7-54c8-735a-a178-628e217b1aa3 | €35.00 | €0.50 | matched |
| 23 | capture | 01a1a1f7-79f7-741f-ba17-6508f1a65fd0 | €24.00 | €0.37 | matched |
| 24 | capture | 01a1a1f7-919c-78d3-8903-73d65bdf1e3a | €35.00 | €0.50 | matched |
| 25 | capture | 01a1a1f7-9469-7f55-abad-33f6daf2d6f6 | €49.00 | €0.67 | matched |
| 26 | capture | 01a1a1f7-978b-74ee-b50f-6fc12687d812 | €24.00 | €0.37 | matched |
| 27 | capture | 01a1a1f7-ab0d-74c9-a395-bc5664b5b710 | €49.00 | €0.67 | matched |
| 28 | capture | 01a1a1f7-aef0-7d58-9dab-4cc922bedb65 | €35.00 | €0.50 | matched |
| 29 | capture | 01a1a1f7-ddad-7da0-a77c-a197a9490bff | €49.00 | €0.67 | matched |
| 30 | capture | 01a1a1f7-e4bf-775d-ba3d-fad9710c7939 | €24.00 | €0.37 | matched |
| 31 | capture | 01a1a1f7-f011-7035-a613-5ac14e4d06a7 | €49.00 | €0.67 | matched |
| 32 | capture | 01a1a1f7-f055-771e-9367-c35761303395 | €15.00 | €0.26 | matched |
| 34 | capture | 01a1a1f7-fda3-7f1e-bc7d-cbe3ce922209 | €49.00 | €0.67 | matched |
| 35 | capture | 01a1a1f8-087d-717b-af76-43f6fc0eff38 | €35.00 | €0.50 | matched |
| 36 | capture | 01a1a1f8-1605-7e16-8a93-c1c21dce5326 | €35.00 | €0.50 | matched |
| 37 | capture | 01a1a1f8-1b69-73b8-9cc5-dfab857e3dae | €49.00 | €0.67 | matched |
| 39 | capture | 01a1a1f8-4141-7fa8-89de-3e9e86e2c856 | €9.00 | €0.19 | matched |
| 40 | capture | 01a1a1f8-4911-7f3c-bb79-63e5da46eb65 | €49.00 | €0.67 | matched |
| 41 | refund | 01a1a1f8-5297-7623-96c7-08a2e24376ad | -€30.00 | €0.00 | matched |
| 42 | capture | 01a1a1f8-570c-7493-80ed-7dcfcd36dd5d | €24.00 | €0.37 | matched |
| 43 | capture | 01a1a1f8-583d-7bf6-8652-911dfebb394a | €15.00 | €0.26 | matched |
| 44 | capture | 01a1a1f8-687f-78fc-8f3e-bc60a9201c6e | €35.00 | €0.50 | matched |
| 45 | capture | 01a1a1f8-6534-7a39-8d75-39c0bdcdd97a | €15.00 | €0.26 | matched |
| 46 | capture | 01a1a1f8-740a-7d8c-aeab-b84a45dadac5 | €24.00 | €0.37 | matched |
| 47 | capture | 01a1a1f8-891c-7712-94c8-62197e61ae92 | €15.00 | €0.26 | matched |
| 48 | capture | 01a1a1f8-9075-7071-bc08-5f552749c102 | €9.00 | €0.19 | matched |
| 49 | capture | 01a1a1f8-a402-753a-b699-24ee4c44623b | €15.00 | €0.26 | matched |
| 50 | capture | 01a1a1f8-b755-71c1-bd10-18545e56e26f | €9.00 | €0.19 | matched |
| 51 | capture | 01a1a1f8-bd58-7ec1-b7fa-d744e3c4d0f3 | €35.00 | €0.50 | matched |
| 52 | capture | 01a1a1f8-d1da-7318-9fa1-908ce4eb2d80 | €15.00 | €0.26 | matched |
| 53 | capture | 01a1a1f8-d941-71a8-b5ef-32f4381525be | €35.00 | €0.50 | matched |
| 54 | capture | 01a1a1f8-e3b2-7361-8224-861927601c6e | €15.00 | €0.26 | matched |
| 55 | refund | 01a1a1f8-e571-7671-a623-40a58e9612bd | -€24.00 | €0.00 | matched |
| 56 | capture | 01a1a1f9-15f0-72e8-8741-5a64bd2d305f | €15.00 | €0.26 | matched |
| 57 | capture | 01a1a1f9-160d-7a42-b9fc-1a4ce81fe808 | €35.00 | €0.50 | matched |
| 58 | capture | 01a1a1f9-1902-73fc-9bab-5b35824f9dd3 | €49.00 | €0.67 | matched |
| 59 | capture | 01a1a1f9-1999-70ac-be7b-cb78c35d4a90 | €24.00 | €0.37 | matched |
| 60 | capture | 01a1a1f9-517e-7ed5-a7b0-179ce934d739 | €49.00 | €0.67 | matched |
| 61 | capture | 01a1a1f9-53e9-7457-b718-60c1dc4d0c2a | €15.00 | €0.26 | matched |
| 62 | capture | 01a1a1f9-5405-719d-ae18-c20165a94ae8 | €24.00 | €0.37 | matched |
| 63 | capture | 01a1a1f9-7efe-7252-beb8-29d98436b3ae | €24.00 | €0.37 | matched |
| 64 | capture | 01a1a1f9-83d5-7f27-a2b5-6b19e641fdbf | €24.00 | €0.37 | matched |
| 65 | capture | 01a1a1f9-9092-7197-8fee-fbcbe550cdcf | €15.00 | €0.26 | matched |
| 66 | capture | 01a1a1f9-d3c7-77e4-9109-59897ec6db24 | €35.00 | €0.50 | matched |
| 67 | refund | 01a1a1f9-d5dc-73d8-acbf-14b4639c3640 | -€3.00 | €0.00 | matched |
| 68 | capture | 01a1a1fa-0025-77f4-ae10-e9fa7c1427fd | €9.00 | €0.19 | matched |
| 69 | capture | 01a1a1fa-0f88-71eb-81a4-0c90ed078fd2 | €9.00 | €0.19 | matched |
| 70 | capture | 01a1a1fa-245d-71d1-8599-d5ab04393e20 | €35.00 | €0.50 | matched |
| 71 | capture | 01a1a1fa-523f-7242-88ae-dc647112b777 | €15.00 | €0.26 | matched |
| 72 | capture | 01a1a1fa-5f17-78b1-a678-472527d08e6a | €15.00 | €0.26 | matched |
| 73 | capture | 01a1a1fa-6a11-7847-9220-52dd1a30b871 | €35.00 | €0.50 | matched |
| 74 | capture | 01a1a1fa-7978-7abb-b60d-3aceee1a12b8 | €9.00 | €0.19 | matched |
| 75 | capture | 01a1a1fa-7a25-7983-93c9-4e4b8afbc6e0 | €35.00 | €0.50 | matched |
| 76 | capture | 01a1a1fa-90e9-7e71-b15a-91acb9890eec | €9.00 | €0.19 | matched |
| 77 | capture | 01a1a1fa-9906-7367-82c0-074c75fe1826 | €35.00 | €0.50 | matched |
| 78 | capture | 01a1a1fa-9c31-7e6b-a0df-d399d49eadaa | €15.00 | €0.26 | matched |
| 79 | capture | 01a1a1fa-b3ba-7ce3-b5b5-01c22d8f7750 | €15.00 | €0.26 | matched |
| 80 | capture | 01a1a1fa-c201-763a-86ed-ae4021bb475d | €9.00 | €0.19 | matched |
| 82 | capture | 01a1a1fb-125c-796f-aa28-11441264eb57 | €24.00 | €0.37 | matched |
| 83 | capture | 01a1a1fb-364c-7ce4-a8fb-acac9c2569a1 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1a1fb-3786-76e6-97b4-3da8b09464ed | €24.00 | €0.37 | matched |
| 85 | capture | 01a1a1fb-62d1-7a9e-ad21-e4177c0b20b8 | €35.00 | €0.50 | matched |
| 86 | capture | 01a1a1fb-614f-71f1-83f5-ce3d89315826 | €15.00 | €0.26 | matched |
| 87 | capture | 01a1a1fb-7775-7236-97ce-91cf41021f06 | €15.00 | €0.26 | matched |
| 88 | capture | 01a1a1fb-8af6-7f8a-9ebd-1a6acba9818a | €49.00 | €0.67 | matched |
| 89 | capture | 01a1a1fb-c09d-70cd-bda4-1f0eaf995718 | €9.00 | €0.19 | matched |
| 90 | capture | 01a1a1fb-cba2-713e-aee6-f59f1004e7b4 | €35.00 | €0.50 | matched |
| 91 | capture | 01a1a1fb-d288-7ba3-a7b0-32b8edb9206d | €9.00 | €0.19 | matched |
| 92 | capture | 01a1a1fb-de85-7161-8b8c-b4da90ac9d3c | €24.00 | €0.37 | matched |
| 93 | capture | 01a1a1fb-ec06-7294-be23-00b7546ecf14 | €24.00 | €0.37 | matched |
| 95 | capture | 01a1a1fc-1ac9-7480-91f3-39dbfd30fe1d | €24.00 | €0.37 | matched |
| 96 | refund | 01a1a1fc-23cd-7f95-af66-ac69ce026345 | -€2.00 | €0.00 | matched |
| 97 | capture | 01a1a1fc-603a-7e18-a931-a2ed67bf1890 | €9.00 | €0.19 | matched |
| 98 | capture | 01a1a1fc-7456-7071-b1c3-ad7ab0b191cc | €35.00 | €0.50 | matched |
| 99 | capture | 01a1a1fc-7abb-7be9-9506-170ed9f901e3 | €15.00 | €0.26 | matched |
| 100 | capture | 01a1a1fd-28ba-73c5-a3e4-126223605ade | €35.00 | €0.50 | matched |
| 101 | capture | 01a1a1fd-42c0-72eb-943e-d1b02b707479 | €15.00 | €0.26 | matched |
| 102 | capture | 01a1a1fd-8864-78f8-9ee5-68d9903a3ca1 | €49.00 | €0.67 | matched |
| 103 | capture | 01a1a1fd-8d0b-70f1-bb6a-56d3becd9361 | €49.00 | €0.67 | matched |
| 104 | capture | 01a1a1fd-90b4-700f-82df-3d956f369745 | €15.00 | €0.26 | matched |
| 105 | capture | 01a1a1fd-9e3e-76ee-8ed7-e75658f4e3d8 | €9.00 | €0.19 | matched |
| 106 | capture | 01a1a1fd-a6f4-72a8-8366-535e412d38a0 | €35.00 | €0.50 | matched |
| 107 | capture | 01a1a1fd-b1b4-7650-908e-f8f693aaa35f | €24.00 | €0.37 | matched |
| 108 | capture | 01a1a1fd-bdcd-7080-8838-d0e3dfd0355a | €24.00 | €0.37 | matched |
| 109 | capture | 01a1a1fd-c85d-7dc8-9337-88cec1535a76 | €49.00 | €0.67 | matched |
| 110 | capture | 01a1a1fd-cf59-7418-93ca-e0770b628b63 | €35.00 | €0.50 | matched |
| 111 | capture | 01a1a1fd-de4c-7f4b-9ee0-4e8311b8fc83 | €9.00 | €0.19 | matched |
| 112 | capture | 01a1a1fd-e81b-7a6b-abc8-28b6b1016b23 | €35.00 | €0.50 | matched |
| 113 | capture | 01a1a1fd-ef07-7f7c-bdd5-102e3b096be9 | €35.00 | €0.50 | matched |
| 114 | refund | 01a1a1fe-0514-720a-a3d6-b74608e98530 | -€26.00 | €0.00 | matched |
| 115 | capture | 01a1a1fe-0a2a-79e9-8e2d-d4386239388e | €49.00 | €0.67 | matched |
| 116 | capture | 01a1a1fe-6c78-75d7-9e7d-08d59c02f1c5 | €24.00 | €0.37 | matched |
| 117 | capture | 01a1a1fe-6e81-7631-8bf1-8a1fb7a38c30 | €24.00 | €0.37 | matched |
| 118 | capture | 01a1a1fe-7c30-702b-90c7-6264a2827770 | €24.00 | €0.37 | matched |
| 119 | capture | 01a1a1fe-8d05-7736-a561-d1ac5b22e264 | €24.00 | €0.37 | matched |
| 120 | capture | 01a1a1fe-904b-7390-b7fe-c550db733551 | €35.00 | €0.50 | matched |
| 121 | capture | 01a1a1fe-904c-7a46-ba15-9dccb204d46f | €49.00 | €0.67 | matched |
| 122 | capture | 01a1a1fe-91f0-7e06-bc29-f53db0ec9ac5 | €24.00 | €0.37 | matched |
| 123 | capture | 01a1a1fe-99e1-7457-860e-9f669816dce6 | €24.00 | €0.37 | matched |
| 124 | capture | 01a1a1fe-a7f0-7dd0-8a7e-58c190977ad1 | €49.00 | €0.67 | matched |
| 125 | capture | 01a1a1fe-b1aa-7723-8753-647b300c03f4 | €24.00 | €0.37 | matched |
| 126 | capture | 01a1a1fe-b322-708e-8a63-4fcd271bac1a | €35.00 | €0.50 | matched |
| 127 | capture | 01a1a1fe-badb-7e78-8145-2dbfcc75d5ab | €15.00 | €0.26 | matched |
| 128 | capture | 01a1a1fe-bccb-7f32-9ba6-45d5e8f96e82 | €24.00 | €0.37 | matched |
| 129 | refund | 01a1a1fe-bec8-7075-ba89-2c205f98d48e | -€21.00 | €0.00 | matched |
| 130 | refund | 01a1a1fe-d6b4-7eb9-b1ac-06b317403a27 | -€10.00 | €0.00 | matched |