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
- 25 Oct, 06:20128 lines1 break
- 25 Oct, 06:10132 lines1 break
- 25 Oct, 06:00126 lines3 breaks
- 25 Oct, 05:50130 lines2 breaks
- 25 Oct, 05:40123 lines3 breaks
- 25 Oct, 05:30114 lines1 break
- 25 Oct, 05:20118 lines1 break
- 25 Oct, 05:10125 lines4 breaks
- 25 Oct, 05:00121 lines5 breaks
- 25 Oct, 04:50128 lines4 breaks
- 25 Oct, 04:40133 lines1 break
- 25 Oct, 04:30120 lines2 breaks
- 25 Oct, 04:20143 lines3 breaks
- 25 Oct, 04:10132 lines2 breaks
25 Oct, 05:00
Gross
€2,506.00
PSP fee
€41.41
Net to the bank
€2,464.59
Settlement journal
#191025
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a17172-5b51-7da9-809a-ba2dc3b88aaf is already settled by stl_EUR_2988174 line 59
- duplicate linethe file lists it twicecapture:01a17172-a757-7b9a-a1c3-440689029a03 is already settled by stl_EUR_2988174 line 63
- fee differencethe fee is not the contract feethe fee is 70, the contract says 67
- missing linein the books, not in the filecapture:01a17171-d507-7d20-9e59-2f3535ed341b is in no file
- missing linein the books, not in the filecapture:01a17173-edc9-70fb-baa2-4511802a673f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 54 | capture | 01a17171-fce2-798e-978f-ba7f6f6ff006 | €49.00 | €0.70 | fee difference |
| 60 | capture | 01a17172-5c13-7a1e-a170-7df5eaa59d84 | €35.00 | €0.50 | duplicate line |
| 64 | capture | 01a17172-b268-79ee-a363-384cef2e0709 | €9.00 | €0.19 | duplicate line |
| 1 | refund | 01a17165-fe26-714e-b13d-10230ee1f421 | -€8.00 | €0.00 | matched |
| 2 | capture | 01a17167-2c72-7235-ab05-ca86496783b2 | €35.00 | €0.50 | matched |
| 3 | capture | 01a1716c-d889-7841-a2c0-114f0e666d48 | €24.00 | €0.37 | matched |
| 4 | capture | 01a1716e-1213-737b-be47-06894ebbc4d0 | €15.00 | €0.26 | matched |
| 5 | capture | 01a1716e-2d94-72d0-89eb-4170b95cce3d | €35.00 | €0.50 | matched |
| 6 | capture | 01a1716e-348d-733b-a0b0-db3e340d2754 | €9.00 | €0.19 | matched |
| 7 | capture | 01a1716e-5101-7956-befe-2de50037c058 | €15.00 | €0.26 | matched |
| 8 | capture | 01a1716e-6baf-746c-82a8-a9881d5f9a03 | €15.00 | €0.26 | matched |
| 9 | capture | 01a1716e-8bd1-7c3b-ac20-301d0b925de0 | €24.00 | €0.37 | matched |
| 10 | capture | 01a1716e-8f93-76ff-8d12-05ff0a47cddb | €15.00 | €0.26 | matched |
| 11 | capture | 01a1716e-9515-7d4b-bacd-4c6d50eb95c6 | €9.00 | €0.19 | matched |
| 12 | capture | 01a1716e-bb18-7970-8f32-fc90c9ab2a3c | €15.00 | €0.26 | matched |
| 13 | refund | 01a1716e-d215-798a-a688-acf47c22d9b9 | -€6.00 | €0.00 | matched |
| 14 | capture | 01a1716e-eb3e-7a8e-bd6d-9e25a41bf16f | €9.00 | €0.19 | matched |
| 15 | capture | 01a1716e-ef75-786d-9a81-0f4b6739f3e8 | €35.00 | €0.50 | matched |
| 16 | capture | 01a1716e-efe9-75b8-8558-7251169f017c | €49.00 | €0.67 | matched |
| 17 | capture | 01a1716e-f8c3-7a62-891f-bd54e90ea28f | €15.00 | €0.26 | matched |
| 18 | capture | 01a1716e-feb1-7a5b-9464-432df28abc09 | €49.00 | €0.67 | matched |
| 19 | capture | 01a1716f-0bab-7abd-b311-2cdfedb95fda | €35.00 | €0.50 | matched |
| 20 | capture | 01a1716f-173f-7f23-8050-b847e8df9c93 | €9.00 | €0.19 | matched |
| 21 | refund | 01a1716f-2753-75a7-ad8e-29eae5726cd4 | -€29.00 | €0.00 | matched |
| 22 | refund | 01a1716f-2b06-7d13-9306-a6cbb13442e8 | -€21.00 | €0.00 | matched |
| 23 | capture | 01a1716f-51a4-756d-833f-4cc218814280 | €15.00 | €0.26 | matched |
| 24 | capture | 01a1716f-7626-7931-9c57-04f1312a8f3a | €24.00 | €0.37 | matched |
| 25 | capture | 01a1716f-80ee-7088-b8f1-70a264f9d9b8 | €49.00 | €0.67 | matched |
| 26 | capture | 01a1716f-b08a-71d4-a9d4-b542fd66e359 | €35.00 | €0.50 | matched |
| 27 | capture | 01a1716f-bbe1-7a9f-8fa7-b15f8d2d0066 | €9.00 | €0.19 | matched |
| 28 | capture | 01a1716f-cc58-7356-a6ac-f1f8eb3b76ac | €15.00 | €0.26 | matched |
| 29 | capture | 01a1716f-e80b-7575-8a23-be216c47a7d3 | €49.00 | €0.67 | matched |
| 30 | capture | 01a1716f-ea11-7e9d-9810-23c488bfa2aa | €49.00 | €0.67 | matched |
| 31 | capture | 01a1716f-ec61-71c0-8af1-a9221c254a85 | €15.00 | €0.26 | matched |
| 32 | capture | 01a1716f-fb3f-743e-bd1e-b48bb404c19a | €49.00 | €0.67 | matched |
| 33 | capture | 01a17170-092b-7120-a1ff-2f1afba9b5b8 | €9.00 | €0.19 | matched |
| 34 | capture | 01a17170-22bc-7563-b0dc-2f4be6570c54 | €15.00 | €0.26 | matched |
| 35 | capture | 01a17170-351e-7f53-b881-1e87a95b91ee | €49.00 | €0.67 | matched |
| 36 | capture | 01a17170-35c2-7d6f-b076-c34cff4b7474 | €15.00 | €0.26 | matched |
| 37 | capture | 01a17170-6ad3-7558-8027-72ac06d22c92 | €35.00 | €0.50 | matched |
| 38 | capture | 01a17170-8e15-7c10-9674-59ad2016ffc9 | €15.00 | €0.26 | matched |
| 39 | capture | 01a17170-c5ff-7c2e-a94e-3a2394c5b805 | €9.00 | €0.19 | matched |
| 40 | capture | 01a17170-e2a3-731d-8f92-3f889f957ef1 | €49.00 | €0.67 | matched |
| 41 | capture | 01a17170-f04d-7332-be12-c6856333b913 | €35.00 | €0.50 | matched |
| 42 | capture | 01a17171-0e81-7585-ab80-4a7f7302e5fe | €9.00 | €0.19 | matched |
| 43 | capture | 01a17171-25b8-7871-8ebb-da2564a6dc7d | €35.00 | €0.50 | matched |
| 44 | capture | 01a17171-2f1f-72ba-b963-d6e5e9df3958 | €35.00 | €0.50 | matched |
| 45 | capture | 01a17171-83e3-728f-a142-d3c748eb06ac | €15.00 | €0.26 | matched |
| 46 | capture | 01a17171-90a1-71d6-aeab-02cebdf297fe | €9.00 | €0.19 | matched |
| 47 | capture | 01a17171-939e-7a37-93b9-fddf3f6112e6 | €15.00 | €0.26 | matched |
| 48 | refund | 01a17171-9928-782e-a735-3e34163579de | -€26.00 | €0.00 | matched |
| 49 | capture | 01a17171-ab3f-775c-abcb-c0a906db7af2 | €15.00 | €0.26 | matched |
| 50 | capture | 01a17171-cc01-76f0-87a5-8d5f810bf296 | €35.00 | €0.50 | matched |
| 51 | capture | 01a17171-cc87-7782-bde9-24e3c4e02fb8 | €24.00 | €0.37 | matched |
| 52 | capture | 01a17171-cca2-7808-90e5-be28e187c98d | €15.00 | €0.26 | matched |
| 53 | refund | 01a17171-d3a4-778f-9c98-dafed2ad7b2f | -€7.00 | €0.00 | matched |
| 55 | capture | 01a17172-13a0-7106-9b7e-0d2636d0a8bc | €9.00 | €0.19 | matched |
| 56 | refund | 01a17172-162f-7bf7-a060-fe7d2acfdb03 | -€10.00 | €0.00 | matched |
| 57 | capture | 01a17172-1e06-7ab6-b18a-5b8532224ebc | €15.00 | €0.26 | matched |
| 58 | capture | 01a17172-5bdd-723e-b245-f25061a9baa9 | €15.00 | €0.26 | matched |
| 59 | capture | 01a17172-5c13-7a1e-a170-7df5eaa59d84 | €35.00 | €0.50 | matched |
| 61 | capture | 01a17172-7699-7d9f-a3f7-51e21527566e | €24.00 | €0.37 | matched |
| 62 | capture | 01a17172-9e86-7f58-8300-e481b9679e52 | €9.00 | €0.19 | matched |
| 63 | capture | 01a17172-b268-79ee-a363-384cef2e0709 | €9.00 | €0.19 | matched |
| 65 | capture | 01a17172-e062-7fb8-80ea-21dff5c64fac | €24.00 | €0.37 | matched |
| 66 | capture | 01a17172-f576-7a84-afdc-1bd88af8ca9d | €9.00 | €0.19 | matched |
| 67 | capture | 01a17173-0afd-73bd-8ea0-a3f0ac7814d3 | €15.00 | €0.26 | matched |
| 68 | capture | 01a17173-42ef-7e1b-9ebe-5aac7af15deb | €24.00 | €0.37 | matched |
| 69 | capture | 01a17173-4e0e-7dbb-916e-f175e9f0140b | €24.00 | €0.37 | matched |
| 70 | capture | 01a17173-6b34-7390-b4a7-484853baa81c | €15.00 | €0.26 | matched |
| 71 | capture | 01a17173-6bd4-7223-b5bf-613ac9902ea2 | €35.00 | €0.50 | matched |
| 72 | capture | 01a17173-72db-7d7b-8dfb-63d256f9843b | €49.00 | €0.67 | matched |
| 73 | capture | 01a17173-7b01-73cd-8ba6-6179a466e2f9 | €35.00 | €0.50 | matched |
| 74 | capture | 01a17173-c714-754a-9295-d02c50ed7688 | €9.00 | €0.19 | matched |
| 75 | capture | 01a17173-d3c4-7cb0-bd72-f145a6a7e0cc | €35.00 | €0.50 | matched |
| 76 | capture | 01a17173-d8af-78b1-b747-a6b62ebf59f8 | €15.00 | €0.26 | matched |
| 77 | capture | 01a17173-dca1-7a39-957a-d20c6986e705 | €49.00 | €0.67 | matched |
| 78 | capture | 01a17174-1fee-7749-8397-096b1c83e22d | €35.00 | €0.50 | matched |
| 79 | capture | 01a17174-2396-722c-a550-b11cb41c9db7 | €15.00 | €0.26 | matched |
| 80 | capture | 01a17174-274d-7338-abcb-820d77ceea15 | €24.00 | €0.37 | matched |
| 81 | capture | 01a17174-2b1e-7c85-88ce-24dad614f8e0 | €15.00 | €0.26 | matched |
| 82 | capture | 01a17174-26b9-71cd-b0d0-f9ca0507b6a4 | €15.00 | €0.26 | matched |
| 83 | capture | 01a17174-46b2-742d-86fe-ec49a40ef525 | €15.00 | €0.26 | matched |
| 84 | capture | 01a17174-6fc1-739a-9ae6-56511e48edb6 | €35.00 | €0.50 | matched |
| 85 | capture | 01a17174-7407-7ee9-83cf-34ddbaff908d | €49.00 | €0.67 | matched |
| 86 | capture | 01a17174-7ddf-77be-b718-a2c2533832aa | €35.00 | €0.50 | matched |
| 87 | capture | 01a17174-8785-7197-91af-0ee6afd4aa75 | €49.00 | €0.67 | matched |
| 88 | capture | 01a17174-c999-7018-a41d-413961faaa28 | €15.00 | €0.26 | matched |
| 89 | capture | 01a17174-d040-78ae-a025-915b0056b369 | €9.00 | €0.19 | matched |
| 90 | refund | 01a17174-d09c-74c5-a4e5-e4ab9490138e | -€34.00 | €0.00 | matched |
| 91 | refund | 01a17174-d4c7-79f5-8584-7c14dda9bdbb | -€15.00 | €0.00 | matched |
| 92 | capture | 01a17174-e666-7159-a5fe-dd81139d40b1 | €24.00 | €0.37 | matched |
| 93 | capture | 01a17174-f305-76e7-a2f6-56ba94777898 | €49.00 | €0.67 | matched |
| 94 | capture | 01a17175-011d-7853-89d0-eeb03cf3b6a2 | €49.00 | €0.67 | matched |
| 95 | capture | 01a17175-023a-7367-8fdc-e40ab56d3f85 | €49.00 | €0.67 | matched |
| 96 | refund | 01a17175-0507-77bf-ae70-ecfb789ea306 | -€35.00 | €0.00 | matched |
| 97 | capture | 01a17175-18dd-70ed-bd40-ec2bd7d47871 | €24.00 | €0.37 | matched |
| 98 | capture | 01a17175-21df-719a-823a-7400a9b07013 | €49.00 | €0.67 | matched |
| 99 | capture | 01a17175-5312-72b0-b386-7e49ae67d3bd | €15.00 | €0.26 | matched |
| 100 | capture | 01a17175-92d1-7417-8353-86c5d1f5fa08 | €35.00 | €0.50 | matched |
| 101 | capture | 01a17175-9542-75dd-ac1b-bc747f02995e | €24.00 | €0.37 | matched |
| 102 | capture | 01a17175-a2f5-7277-a801-6782c610abc9 | €15.00 | €0.26 | matched |
| 103 | capture | 01a17175-c615-7247-b394-93323340b029 | €24.00 | €0.37 | matched |
| 104 | capture | 01a17175-cb6d-7cfe-abae-51c74516785f | €35.00 | €0.50 | matched |
| 105 | capture | 01a17175-d219-7e1d-ba69-c371e9fb6b24 | €35.00 | €0.50 | matched |
| 106 | capture | 01a17175-da59-7705-919e-c8dbb88589d4 | €35.00 | €0.50 | matched |
| 107 | capture | 01a17175-e6e1-7929-8afa-76ca4154d9cd | €15.00 | €0.26 | matched |
| 108 | capture | 01a17175-ff34-7720-9ae5-3755b1b82721 | €9.00 | €0.19 | matched |
| 109 | capture | 01a17176-0861-7719-a9f4-c060b836b4b5 | €15.00 | €0.26 | matched |
| 110 | capture | 01a17176-131e-7b76-85d7-ccc492a99ab6 | €9.00 | €0.19 | matched |
| 111 | capture | 01a17176-3f99-7491-84e4-fd8812fcc829 | €35.00 | €0.50 | matched |
| 112 | capture | 01a17176-70ff-77b5-b222-93c3293da7d4 | €24.00 | €0.37 | matched |
| 113 | capture | 01a17176-8cb3-7584-9018-9ef6827e1825 | €24.00 | €0.37 | matched |
| 114 | capture | 01a17176-a4f2-76b8-9403-e29c6194a2f9 | €9.00 | €0.19 | matched |
| 115 | refund | 01a17176-c23e-73f3-ac7b-befa2e61b11e | -€9.00 | €0.00 | matched |
| 116 | capture | 01a17176-d07e-751f-9cab-e0170cdb4493 | €15.00 | €0.26 | matched |
| 117 | capture | 01a17176-fcc4-7a07-b469-7d26501b4dfe | €24.00 | €0.37 | matched |
| 118 | capture | 01a17176-fcec-7e8c-a8a5-4aa88faae43e | €9.00 | €0.19 | matched |
| 119 | capture | 01a17177-017d-79c0-a145-0b7ea5693f22 | €15.00 | €0.26 | matched |
| 120 | capture | 01a17177-2b62-7721-aa09-8e5bcfcb076c | €9.00 | €0.19 | matched |
| 121 | capture | 01a17177-2c27-7d13-bfe6-a2b112f5ffb7 | €15.00 | €0.26 | matched |