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
- 22 Oct, 16:50133 lines3 breaks
- 22 Oct, 16:40115 lines1 break
- 22 Oct, 16:30119 lines2 breaks
- 22 Oct, 16:20118 lines2 breaks
- 22 Oct, 16:10114 lines1 break
- 22 Oct, 16:00120 lines3 breaks
- 22 Oct, 15:50135 lines3 breaks
- 22 Oct, 15:40133 lines1 break
- 22 Oct, 15:30129 lines2 breaks
- 22 Oct, 15:20109 lines2 breaks
- 22 Oct, 15:10135 lines4 breaks
- 22 Oct, 15:00137 lines2 breaks
- 22 Oct, 14:50124 lines4 breaks
- 22 Oct, 14:40131 lines2 breaks
22 Oct, 15:30
Gross
€2,484.00
PSP fee
€41.71
Net to the bank
€2,442.29
Settlement journal
#144069
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1643d-c139-783c-9260-490605e611d2 is already settled by stl_EUR_2987805 line 26
- missing linein the books, not in the filecapture:01a16444-9c83-759b-90a1-e45e1bc800d2 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 1 | refund | 01a16436-20f1-7856-a916-dbf192f2ef3b | -€19.00 | €0.01 | fee difference |
| 27 | capture | 01a1643d-c1c3-7865-97dd-a243c0cb3be0 | €35.00 | €0.50 | duplicate line |
| 2 | capture | 01a16436-8244-71fc-9bb0-736151dd4275 | €9.00 | €0.19 | matched |
| 3 | capture | 01a16439-4332-7783-9133-b78261996ce8 | €15.00 | €0.26 | matched |
| 4 | capture | 01a1643b-d185-73de-915b-63858a750587 | €24.00 | €0.37 | matched |
| 5 | refund | 01a1643b-d52d-7cd4-82c3-5eb63b2036a3 | -€22.00 | €0.00 | matched |
| 6 | capture | 01a1643b-dc2e-799f-9cf1-2090b3c36861 | €15.00 | €0.26 | matched |
| 7 | capture | 01a1643b-ddec-72f0-8533-8636269ab7c3 | €35.00 | €0.50 | matched |
| 8 | capture | 01a1643b-f47c-7ce6-9012-5b1501c8f4bc | €15.00 | €0.26 | matched |
| 9 | capture | 01a1643c-2aef-7843-8b6c-99eccacd1dd0 | €9.00 | €0.19 | matched |
| 10 | capture | 01a1643c-3950-7421-bb6b-d02ce6a6e6e1 | €9.00 | €0.19 | matched |
| 11 | capture | 01a1643c-62ce-7d0c-a4df-36ac554b4cc6 | €9.00 | €0.19 | matched |
| 12 | capture | 01a1643c-a7ce-7e31-9be4-4029931667c8 | €35.00 | €0.50 | matched |
| 13 | capture | 01a1643c-a841-758e-a102-83298a2b8646 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1643c-df9f-7a46-96d5-472eb6efcfed | €9.00 | €0.19 | matched |
| 15 | capture | 01a1643c-e21c-7db8-b3e1-3a4a2ed3cef1 | €15.00 | €0.26 | matched |
| 16 | capture | 01a1643c-edd2-7e33-ae2d-5558493a2c7a | €49.00 | €0.67 | matched |
| 17 | capture | 01a1643c-f4ac-7a74-be03-7a11ee1eb74f | €35.00 | €0.50 | matched |
| 18 | capture | 01a1643d-1b8d-7681-807e-c54c9850c0d6 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1643d-2dbb-7404-82fc-fbda6ebd363d | €49.00 | €0.67 | matched |
| 20 | capture | 01a1643d-5b91-7e99-9542-762004f0d2bd | €9.00 | €0.19 | matched |
| 21 | capture | 01a1643d-776a-701d-bf64-2700ca226801 | €49.00 | €0.67 | matched |
| 22 | capture | 01a1643d-89dd-7172-b635-f35cd36bc781 | €49.00 | €0.67 | matched |
| 23 | capture | 01a1643d-9114-7aab-9b1c-41937718ce40 | €35.00 | €0.50 | matched |
| 24 | capture | 01a1643d-9673-7e72-b11f-0b4c7cdc7922 | €24.00 | €0.37 | matched |
| 25 | capture | 01a1643d-ace1-7b1e-b307-09344705f69f | €15.00 | €0.26 | matched |
| 26 | capture | 01a1643d-c1c3-7865-97dd-a243c0cb3be0 | €35.00 | €0.50 | matched |
| 28 | capture | 01a1643d-c550-792a-8282-4e342b62acc9 | €9.00 | €0.19 | matched |
| 29 | capture | 01a1643d-ccf9-79b0-a2a8-b3c217acf005 | €24.00 | €0.37 | matched |
| 30 | capture | 01a1643d-e255-72f1-b941-fc23de4548e0 | €49.00 | €0.67 | matched |
| 31 | capture | 01a1643e-23d0-7997-b37c-f977b3fb1bbc | €15.00 | €0.26 | matched |
| 32 | capture | 01a1643e-2630-789a-bc42-927814131200 | €49.00 | €0.67 | matched |
| 33 | capture | 01a1643e-2bdf-7112-99ab-bdefa25b71b9 | €24.00 | €0.37 | matched |
| 34 | capture | 01a1643e-3c4a-7eaf-8738-74863c9de9b2 | €24.00 | €0.37 | matched |
| 35 | refund | 01a1643e-421d-72d4-bce5-5836da0700ac | -€37.00 | €0.00 | matched |
| 36 | capture | 01a1643e-5667-708d-b51a-ccf67fc4de7b | €35.00 | €0.50 | matched |
| 37 | capture | 01a1643e-59a4-7d26-bdf9-4eddca1a8bc9 | €49.00 | €0.67 | matched |
| 38 | capture | 01a1643e-87dd-73bb-a6a1-c4c1ed973d39 | €15.00 | €0.26 | matched |
| 39 | capture | 01a1643e-8eb5-7bed-b285-c49f977629c1 | €9.00 | €0.19 | matched |
| 40 | capture | 01a1643e-927c-7ceb-8e7d-ff83a71255ff | €49.00 | €0.67 | matched |
| 41 | capture | 01a1643e-9a53-7d20-a12c-c0247b495345 | €35.00 | €0.50 | matched |
| 42 | capture | 01a1643e-9bfa-7334-9a5d-7fb27e1a6696 | €24.00 | €0.37 | matched |
| 43 | capture | 01a1643e-c098-7f54-93ae-833361232a1a | €24.00 | €0.37 | matched |
| 44 | refund | 01a1643e-c9c2-722d-b0b0-c505af262fb5 | -€18.00 | €0.00 | matched |
| 45 | capture | 01a1643e-cfff-7c18-bedb-5fac8c8906d0 | €9.00 | €0.19 | matched |
| 46 | capture | 01a1643e-f87d-766c-8dae-9ffc21d1208c | €9.00 | €0.19 | matched |
| 47 | capture | 01a1643f-06d3-7552-b95a-f2a7c242b32d | €35.00 | €0.50 | matched |
| 48 | refund | 01a1643f-1af7-742b-82cd-e01979a63b7c | -€2.00 | €0.00 | matched |
| 49 | refund | 01a1643f-1f53-72bf-a01a-5fbf4d39d38e | -€11.00 | €0.00 | matched |
| 50 | capture | 01a1643f-22ae-77d9-831e-41dacea0c04f | €49.00 | €0.67 | matched |
| 51 | capture | 01a1643f-29bd-710d-9efa-3c1c8f528880 | €9.00 | €0.19 | matched |
| 52 | capture | 01a1643f-370a-7348-9cd2-e77a58c66e73 | €24.00 | €0.37 | matched |
| 53 | refund | 01a1643f-4c26-7c31-9080-44b005817154 | -€18.00 | €0.00 | matched |
| 54 | capture | 01a1643f-4fd0-7edd-8069-1424815b6645 | €15.00 | €0.26 | matched |
| 55 | capture | 01a1643f-5c89-76e1-b8e2-71b6dad0e5ce | €9.00 | €0.19 | matched |
| 56 | capture | 01a1643f-79aa-7fd2-828a-2acf29d17993 | €15.00 | €0.26 | matched |
| 57 | capture | 01a1643f-7ab0-756c-a8e1-2b0daf5781c4 | €9.00 | €0.19 | matched |
| 58 | capture | 01a1643f-7baa-7ee8-b2a5-ad2b16a5e61c | €9.00 | €0.19 | matched |
| 59 | capture | 01a1643f-9cb9-7fe4-881d-7ee17a6c0569 | €24.00 | €0.37 | matched |
| 60 | capture | 01a1643f-adcd-785b-909f-ca6e5e64ff0a | €15.00 | €0.26 | matched |
| 61 | capture | 01a1643f-b87b-7610-af2c-56d2c00521b4 | €9.00 | €0.19 | matched |
| 62 | capture | 01a1643f-c3ec-75d3-9adb-e5aa14373264 | €15.00 | €0.26 | matched |
| 63 | refund | 01a1643f-d219-776d-909f-e4651bad6531 | -€4.00 | €0.00 | matched |
| 64 | capture | 01a1643f-f5bb-7502-8ade-e428b29f2681 | €24.00 | €0.37 | matched |
| 65 | refund | 01a16440-048d-79d5-9143-1fe19ba9ecf2 | -€5.00 | €0.00 | matched |
| 66 | capture | 01a16440-1f55-72c5-9ebd-cbaa0fd8e539 | €9.00 | €0.19 | matched |
| 67 | capture | 01a16440-4abd-7827-ab7c-d0aae5da57c9 | €35.00 | €0.50 | matched |
| 68 | capture | 01a16440-4ffd-7d31-b18e-544bbc3a991b | €24.00 | €0.37 | matched |
| 69 | capture | 01a16440-6b81-7c57-9c6d-40c1ab9ce461 | €9.00 | €0.19 | matched |
| 70 | capture | 01a16440-7fa0-7ee9-a631-f447871c6e06 | €24.00 | €0.37 | matched |
| 71 | capture | 01a16440-81b6-76c2-9a11-9699ad885607 | €24.00 | €0.37 | matched |
| 72 | capture | 01a16440-8979-7146-afd1-ce0b9165ea46 | €35.00 | €0.50 | matched |
| 73 | capture | 01a16440-8d94-78ff-88c3-e5b77c159a72 | €9.00 | €0.19 | matched |
| 74 | capture | 01a16440-98ad-77c2-ad3a-8f07b91b99b7 | €35.00 | €0.50 | matched |
| 75 | capture | 01a16440-a628-7e97-9d8f-aa1a6640a6e1 | €9.00 | €0.19 | matched |
| 76 | capture | 01a16440-a6d6-72de-b1c6-dfbc362b90d8 | €15.00 | €0.26 | matched |
| 77 | capture | 01a16440-ab9a-7007-b4df-c95a84ada540 | €15.00 | €0.26 | matched |
| 78 | refund | 01a16440-acd5-713f-95cc-9505ff5cb24a | -€6.00 | €0.00 | matched |
| 79 | capture | 01a16440-d080-7bc8-90ec-4127e7b6b80a | €35.00 | €0.50 | matched |
| 80 | capture | 01a16440-d24b-752d-ad66-9a588262908d | €9.00 | €0.19 | matched |
| 81 | refund | 01a16440-d87c-72fc-9ea5-bb57854f099d | -€8.00 | €0.00 | matched |
| 82 | capture | 01a16440-f8cf-7f9e-b510-f50b37f904b9 | €9.00 | €0.19 | matched |
| 83 | capture | 01a16441-0ed0-7685-bfe5-12808b3c0616 | €35.00 | €0.50 | matched |
| 84 | refund | 01a16441-1032-752e-bad3-393eb15d45ae | -€6.00 | €0.00 | matched |
| 85 | capture | 01a16441-1e0a-7e4a-8732-95a7e535a064 | €49.00 | €0.67 | matched |
| 86 | capture | 01a16441-4086-7e77-a064-adf9d0f15644 | €24.00 | €0.37 | matched |
| 87 | capture | 01a16441-42b4-702e-b720-7ad68ec6b8e1 | €24.00 | €0.37 | matched |
| 88 | capture | 01a16441-5442-7042-8e76-46599e35baab | €9.00 | €0.19 | matched |
| 89 | capture | 01a16441-5447-7344-a3a3-816189ad6bf3 | €24.00 | €0.37 | matched |
| 90 | refund | 01a16441-74d3-7a8b-8dd9-5d656deca67d | -€22.00 | €0.00 | matched |
| 91 | capture | 01a16441-a5b6-732e-bc9d-01f2e7db2f29 | €49.00 | €0.67 | matched |
| 92 | capture | 01a16441-bb38-7b8b-89e2-1cd0a83fd32e | €49.00 | €0.67 | matched |
| 93 | capture | 01a16441-dc68-78e8-99bb-0176f03932bf | €15.00 | €0.26 | matched |
| 94 | capture | 01a16441-e62d-76b1-9ae1-73e03ed077a2 | €9.00 | €0.19 | matched |
| 95 | capture | 01a16441-f13e-761b-a494-a899edbf14f6 | €49.00 | €0.67 | matched |
| 96 | capture | 01a16442-029b-7d7d-82b4-68c1859035bc | €15.00 | €0.26 | matched |
| 97 | refund | 01a16442-3dac-7d00-a70e-d1a30ac596bb | -€8.00 | €0.00 | matched |
| 98 | capture | 01a16442-5023-7634-854f-454b3e668ff3 | €15.00 | €0.26 | matched |
| 99 | capture | 01a16442-5e74-7cb3-880a-b90c8d6e72b8 | €24.00 | €0.37 | matched |
| 100 | capture | 01a16442-7c0d-7edb-8ece-bd00a7ca6c60 | €9.00 | €0.19 | matched |
| 101 | capture | 01a16442-9e25-7c3d-9a3a-fb1b3520cdd8 | €49.00 | €0.67 | matched |
| 102 | capture | 01a16442-b32d-7d89-8af9-d09264057a4c | €15.00 | €0.26 | matched |
| 103 | capture | 01a16442-b67e-7d17-9cc3-fd7732098a47 | €24.00 | €0.37 | matched |
| 104 | capture | 01a16442-c394-7855-87d6-b5f213e034c4 | €9.00 | €0.19 | matched |
| 105 | capture | 01a16442-c8d4-7a30-a3e0-3c2408f4807e | €35.00 | €0.50 | matched |
| 106 | refund | 01a16443-07fe-757f-8ee6-eee018f53ba2 | -€17.00 | €0.00 | matched |
| 107 | capture | 01a16443-1f06-7c87-aa21-6fcfd6763e9e | €9.00 | €0.19 | matched |
| 108 | capture | 01a16443-2c76-737c-99ba-c9b321057af8 | €24.00 | €0.37 | matched |
| 109 | capture | 01a16443-40eb-7795-a6dc-50d433013b69 | €49.00 | €0.67 | matched |
| 110 | capture | 01a16443-4ec6-7dc7-99eb-34b482acfa1d | €49.00 | €0.67 | matched |
| 111 | capture | 01a16443-5165-7144-9d20-2c140525b844 | €24.00 | €0.37 | matched |
| 112 | refund | 01a16443-6adc-7007-a91d-7ecbff4d8a8c | -€23.00 | €0.00 | matched |
| 113 | capture | 01a16443-7005-72fe-a134-508012462bdf | €15.00 | €0.26 | matched |
| 114 | capture | 01a16443-89b4-7297-8418-345e1550a8c0 | €49.00 | €0.67 | matched |
| 115 | capture | 01a16443-a36b-7225-b0f1-a0d976a64f55 | €9.00 | €0.19 | matched |
| 116 | capture | 01a16443-a66f-7e73-90e5-19d0cec72534 | €15.00 | €0.26 | matched |
| 117 | capture | 01a16443-ac78-7d8e-a2d0-7b394f83054b | €15.00 | €0.26 | matched |
| 118 | capture | 01a16443-b45f-7262-9326-12de816c8b16 | €15.00 | €0.26 | matched |
| 119 | capture | 01a16443-bad9-7926-b735-f67a894fca9c | €49.00 | €0.67 | matched |
| 120 | capture | 01a16443-cdab-7605-8c2d-f754787fbfbf | €35.00 | €0.50 | matched |
| 121 | capture | 01a16443-eee8-75a1-a2ed-4b17257db836 | €24.00 | €0.37 | matched |
| 122 | capture | 01a16444-0262-7110-a095-b47cf3689a7a | €15.00 | €0.26 | matched |
| 123 | capture | 01a16444-1f90-724c-bbb6-180828568495 | €35.00 | €0.50 | matched |
| 124 | capture | 01a16444-4a51-7290-b268-a1c319fe3526 | €9.00 | €0.19 | matched |
| 125 | capture | 01a16444-80d9-76e5-9429-e8a71ed253bc | €49.00 | €0.67 | matched |
| 126 | capture | 01a16444-d103-7244-92e3-ec35b1262742 | €15.00 | €0.26 | matched |
| 127 | capture | 01a16444-d71f-7064-af1a-64dd1529869d | €9.00 | €0.19 | matched |
| 128 | capture | 01a16444-d9ef-723d-8854-b9fb1362c1f1 | €15.00 | €0.26 | matched |
| 129 | capture | 01a16444-da3a-7fdd-95b0-3bf8a88b77c3 | €35.00 | €0.50 | matched |