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
- 23 Oct, 10:00131 lines2 breaks
- 23 Oct, 09:50135 lines4 breaks
- 23 Oct, 09:40114 lines2 breaks
- 23 Oct, 09:30130 lines3 breaks
- 23 Oct, 09:20126 lines1 break
- 23 Oct, 09:10114 lines3 breaks
- 23 Oct, 09:00128 lines4 breaks
- 23 Oct, 08:50117 lines3 breaks
- 23 Oct, 08:40127 lines1 break
- 23 Oct, 08:30132 lines3 breaks
- 23 Oct, 08:20130 lines3 breaks
- 23 Oct, 08:10121 lines2 breaks
- 23 Oct, 08:00138 lines4 breaks
- 23 Oct, 07:50116 lines1 break
23 Oct, 09:50
Gross
€3,216.00
PSP fee
€49.99
Net to the bank
€3,166.01
Settlement journal
#158084
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a16831-8413-77e0-b6fd-6d19e53dbf8d is already settled by stl_EUR_2987915 line 97
- missing linein the books, not in the filecapture:01a1682e-1d4f-7a9a-9b93-cc30d92631ac is in no file
- missing linein the books, not in the filecapture:01a1682e-7a85-7eed-87c1-40dc30f0578b is in no file
- missing linein the books, not in the filecapture:01a16830-d2c2-7732-8f98-fae2ca86dcf4 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 98 | capture | 01a16831-848d-7555-9210-f69e1cc7c451 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a16825-69e2-7ef7-8360-8b22434fe0a4 | €35.00 | €0.50 | matched |
| 2 | refund | 01a16826-e13a-7d8b-ab68-f22a2379dcc7 | -€2.00 | €0.00 | matched |
| 3 | capture | 01a16828-e39a-7aa6-8b20-3fcab526c1cb | €15.00 | €0.26 | matched |
| 4 | capture | 01a1682a-e7b4-740c-ba34-91b9b3141182 | €49.00 | €0.67 | matched |
| 5 | capture | 01a1682a-e7dd-7f5b-885f-9323f6d5f7a7 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1682a-edf8-7a4d-a858-cbb017134974 | €49.00 | €0.67 | matched |
| 7 | capture | 01a1682a-fddb-785d-a09a-94984679cddd | €35.00 | €0.50 | matched |
| 8 | capture | 01a1682b-0054-75a6-ac2f-a0bdbc03b964 | €15.00 | €0.26 | matched |
| 9 | capture | 01a1682b-0970-77ab-9162-93471e1ecd9c | €24.00 | €0.37 | matched |
| 10 | capture | 01a1682b-5b25-7b43-97f1-8f594d4d924d | €9.00 | €0.19 | matched |
| 11 | capture | 01a1682b-6118-700f-b65c-cbcf224724c9 | €24.00 | €0.37 | matched |
| 12 | capture | 01a1682b-7632-7901-abe6-5ddda45468fd | €15.00 | €0.26 | matched |
| 13 | capture | 01a1682b-97a2-7107-a080-01a7d03ee740 | €49.00 | €0.67 | matched |
| 14 | capture | 01a1682b-a3b7-7d01-bcdd-f5029ac4c2ae | €15.00 | €0.26 | matched |
| 15 | capture | 01a1682b-a8e2-709b-85f0-f666fe8a64be | €49.00 | €0.67 | matched |
| 16 | capture | 01a1682b-bbf8-7750-84a1-918460e25315 | €49.00 | €0.67 | matched |
| 17 | capture | 01a1682b-c2e8-7166-bd2c-c6cce5703c8b | €24.00 | €0.37 | matched |
| 18 | capture | 01a1682b-c741-7190-b76f-0c303a6be109 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1682b-dbe7-78db-a165-fc14646d3d16 | €9.00 | €0.19 | matched |
| 20 | capture | 01a1682b-e100-709f-9f37-640a35d7e58c | €35.00 | €0.50 | matched |
| 21 | capture | 01a1682b-f503-7fa9-bc9f-d84b61763c9d | €49.00 | €0.67 | matched |
| 22 | capture | 01a1682c-02d6-7ff3-b00d-df22a65a65b8 | €49.00 | €0.67 | matched |
| 23 | capture | 01a1682c-04f0-7058-93d4-700a9f4528bf | €15.00 | €0.26 | matched |
| 24 | capture | 01a1682c-2dfb-7bc0-92b3-96752cf2d4eb | €15.00 | €0.26 | matched |
| 25 | capture | 01a1682c-2ef2-7330-a7b7-b0d4a05bc74f | €24.00 | €0.37 | matched |
| 26 | capture | 01a1682c-473a-7bf5-82da-0b5170c87b37 | €24.00 | €0.37 | matched |
| 27 | capture | 01a1682c-47c2-7656-ade0-a7993729fe57 | €15.00 | €0.26 | matched |
| 28 | capture | 01a1682c-53d2-73a5-b810-e92fdb7dc358 | €15.00 | €0.26 | matched |
| 29 | capture | 01a1682c-616f-7bc9-9f37-388c444a0885 | €24.00 | €0.37 | matched |
| 30 | capture | 01a1682c-97e1-7ba4-94d1-4eaba812036a | €24.00 | €0.37 | matched |
| 31 | capture | 01a1682c-a2e6-79e9-ba01-e4a18837b704 | €49.00 | €0.67 | matched |
| 32 | capture | 01a1682c-ba42-719f-870d-8c17cb4bf02c | €24.00 | €0.37 | matched |
| 33 | capture | 01a1682c-bb5b-775b-9bf3-7f0b1ab59214 | €35.00 | €0.50 | matched |
| 34 | capture | 01a1682c-ccb7-7936-8306-88b67e3e703f | €9.00 | €0.19 | matched |
| 35 | capture | 01a1682c-d0f9-71c6-ac6e-73c683e126a2 | €9.00 | €0.19 | matched |
| 36 | capture | 01a1682d-023d-7c89-8b9a-9b09744359f9 | €15.00 | €0.26 | matched |
| 37 | capture | 01a1682d-24a5-7347-a532-89b9aa7e84df | €49.00 | €0.67 | matched |
| 38 | capture | 01a1682d-300f-7f46-aebb-94359e1a952a | €15.00 | €0.26 | matched |
| 39 | capture | 01a1682d-476c-7619-8709-e975023db3c7 | €15.00 | €0.26 | matched |
| 40 | capture | 01a1682d-4d13-7896-8f97-42be45d01cea | €49.00 | €0.67 | matched |
| 41 | capture | 01a1682d-649f-711f-96c8-bde246f0b544 | €24.00 | €0.37 | matched |
| 42 | refund | 01a1682d-a32d-726d-9e29-c66a165bfb5e | -€4.00 | €0.00 | matched |
| 43 | refund | 01a1682d-bcfc-7487-bb3a-050eba76a8f0 | -€13.00 | €0.00 | matched |
| 44 | capture | 01a1682d-cd4b-75fe-b533-14ba8e5d7881 | €49.00 | €0.67 | matched |
| 45 | capture | 01a1682d-d6ae-725b-bc5e-098c79efdf19 | €15.00 | €0.26 | matched |
| 46 | capture | 01a1682d-fcd9-7814-a340-c11dcdf1e27b | €15.00 | €0.26 | matched |
| 47 | capture | 01a1682e-0af3-795a-a19e-1f2502ff5e67 | €35.00 | €0.50 | matched |
| 48 | capture | 01a1682e-25bb-72f3-9ba8-430cee2da6af | €49.00 | €0.67 | matched |
| 49 | capture | 01a1682e-3529-705c-a797-30bb46549b16 | €9.00 | €0.19 | matched |
| 50 | capture | 01a1682e-4262-7a14-b7e4-d7fb951710cb | €9.00 | €0.19 | matched |
| 51 | capture | 01a1682e-48dd-7051-a4ad-ba3022f6e775 | €9.00 | €0.19 | matched |
| 52 | capture | 01a1682e-4e7e-72e5-8511-7b9aa3f8be6d | €35.00 | €0.50 | matched |
| 53 | capture | 01a1682e-5238-7773-99d9-a86709ab3e46 | €15.00 | €0.26 | matched |
| 54 | capture | 01a1682e-6034-76f5-9c18-3a7a5ee76577 | €9.00 | €0.19 | matched |
| 55 | capture | 01a1682e-68ea-774d-a1ca-c35dfbf653da | €9.00 | €0.19 | matched |
| 56 | capture | 01a1682e-6daa-7be0-a42f-94ac2c571526 | €49.00 | €0.67 | matched |
| 57 | capture | 01a1682e-9a0a-7a49-821a-e64a87216289 | €9.00 | €0.19 | matched |
| 58 | capture | 01a1682e-a0ee-71e4-baf0-81762dca45e5 | €35.00 | €0.50 | matched |
| 59 | capture | 01a1682e-a9fd-7ff6-b51a-3381f6672c9f | €24.00 | €0.37 | matched |
| 60 | capture | 01a1682e-bd0f-7691-91a6-e93ce861e7fe | €15.00 | €0.26 | matched |
| 61 | capture | 01a1682e-c145-78f7-b882-2e9dd9c11948 | €9.00 | €0.19 | matched |
| 62 | capture | 01a1682e-c79c-779d-88d5-1af591c82bd2 | €35.00 | €0.50 | matched |
| 63 | capture | 01a1682e-d47b-7223-8501-01f8794c23b1 | €9.00 | €0.19 | matched |
| 64 | capture | 01a1682e-d58c-7106-b5ff-6cc9495dcb82 | €15.00 | €0.26 | matched |
| 65 | capture | 01a1682e-e64e-7474-9e69-30d4b9d07968 | €49.00 | €0.67 | matched |
| 66 | capture | 01a1682e-eb84-7720-a1b1-5f34d14aeab4 | €24.00 | €0.37 | matched |
| 67 | capture | 01a1682e-edd6-7521-a1d0-9519de85fe22 | €9.00 | €0.19 | matched |
| 68 | capture | 01a1682e-f8bc-70d4-9d54-7bd06322fe8f | €9.00 | €0.19 | matched |
| 69 | capture | 01a1682f-2a93-793e-aecd-1b0c8bb9d4de | €15.00 | €0.26 | matched |
| 70 | capture | 01a1682f-6695-74bd-a034-851e85b58a4b | €24.00 | €0.37 | matched |
| 71 | capture | 01a1682f-8650-7ea2-bb9e-3d9b49538c3d | €9.00 | €0.19 | matched |
| 72 | capture | 01a1682f-a672-7842-a332-b601f88186af | €15.00 | €0.26 | matched |
| 73 | capture | 01a1682f-ab22-729d-8a2f-dfa2c411af4c | €24.00 | €0.37 | matched |
| 74 | capture | 01a1682f-bd2c-7fd5-8fb1-5509236de86a | €35.00 | €0.50 | matched |
| 75 | capture | 01a1682f-dd79-7e83-84f9-144c85b902ec | €49.00 | €0.67 | matched |
| 76 | capture | 01a1682f-dfa5-7992-9199-a6fcc4b8dc61 | €15.00 | €0.26 | matched |
| 77 | capture | 01a16830-1068-75f4-8db2-9f5403b5d631 | €49.00 | €0.67 | matched |
| 78 | capture | 01a16830-12de-7931-abd1-f7e4c145f200 | €35.00 | €0.50 | matched |
| 79 | refund | 01a16830-2d63-7ddd-9d8a-55a186ca8894 | -€10.00 | €0.00 | matched |
| 80 | capture | 01a16830-40ab-77ef-9e1d-e5ffd233c44c | €49.00 | €0.67 | matched |
| 81 | capture | 01a16830-4cef-7f8d-9909-db058906532e | €24.00 | €0.37 | matched |
| 82 | capture | 01a16830-4f9c-7da2-a36f-b4196cb0ccc4 | €24.00 | €0.37 | matched |
| 83 | capture | 01a16830-5774-7f9b-b507-5aaa0e1b18a6 | €35.00 | €0.50 | matched |
| 84 | capture | 01a16830-6c25-7582-9ca7-a35d977d5be8 | €35.00 | €0.50 | matched |
| 85 | capture | 01a16830-a425-7ea5-849d-4f98380953ae | €15.00 | €0.26 | matched |
| 86 | capture | 01a16830-ca91-731d-800c-18d66cb3804c | €24.00 | €0.37 | matched |
| 87 | capture | 01a16830-cd4a-72e1-96aa-f5433c35369c | €9.00 | €0.19 | matched |
| 88 | capture | 01a16830-d591-7f85-a611-a00a030abed8 | €15.00 | €0.26 | matched |
| 89 | capture | 01a16830-eb2a-7a2f-aace-8cc507ce5db4 | €35.00 | €0.50 | matched |
| 90 | capture | 01a16831-1b43-709b-b7af-71f511bb674f | €24.00 | €0.37 | matched |
| 91 | capture | 01a16831-383f-787c-a5ce-5b96f938e5e1 | €9.00 | €0.19 | matched |
| 92 | capture | 01a16831-469d-7ff3-82a3-d527925aafcd | €35.00 | €0.50 | matched |
| 93 | capture | 01a16831-5157-7070-b623-c3d15452446d | €15.00 | €0.26 | matched |
| 94 | capture | 01a16831-5163-7d88-bf23-e4be5d5862b4 | €9.00 | €0.19 | matched |
| 95 | capture | 01a16831-54ce-79c0-b34b-ce9525c36120 | €35.00 | €0.50 | matched |
| 96 | capture | 01a16831-7d75-7a69-ae45-375705dd5b99 | €9.00 | €0.19 | matched |
| 97 | capture | 01a16831-848d-7555-9210-f69e1cc7c451 | €24.00 | €0.37 | matched |
| 99 | capture | 01a16831-9316-7189-81b0-5b441184043c | €15.00 | €0.26 | matched |
| 100 | capture | 01a16831-9dcf-7829-873c-285b341d0ffc | €24.00 | €0.37 | matched |
| 101 | capture | 01a16831-ac64-7c2f-bb4b-7239bc5b223a | €24.00 | €0.37 | matched |
| 102 | capture | 01a16831-b131-78fa-b4dc-8a9154fabfcd | €9.00 | €0.19 | matched |
| 103 | capture | 01a16831-bd4e-7153-9779-e362f00515dd | €49.00 | €0.67 | matched |
| 104 | capture | 01a16831-bdd4-7402-9ac7-cc87b6eed7c9 | €35.00 | €0.50 | matched |
| 105 | refund | 01a16832-13fe-7252-b5f9-dc33f9923ac6 | -€13.00 | €0.00 | matched |
| 106 | capture | 01a16832-35f2-76ac-a806-9ae68371f60c | €9.00 | €0.19 | matched |
| 107 | capture | 01a16832-3994-7357-9bb0-ec440581241f | €35.00 | €0.50 | matched |
| 108 | capture | 01a16832-682c-7dd6-b99d-bd9a30c85f01 | €35.00 | €0.50 | matched |
| 109 | capture | 01a16832-6908-74e2-b422-8fb7cbd8a542 | €24.00 | €0.37 | matched |
| 110 | capture | 01a16832-71c0-7139-a7bc-73c6d5fbb03f | €9.00 | €0.19 | matched |
| 111 | capture | 01a16832-8a27-7024-9ac1-b4abd6e027ac | €24.00 | €0.37 | matched |
| 112 | capture | 01a16832-8ff5-7630-b584-0fef2f057ab5 | €24.00 | €0.37 | matched |
| 113 | capture | 01a16832-9374-781e-8e0a-a9952afa1055 | €49.00 | €0.67 | matched |
| 114 | capture | 01a16832-adef-7870-b951-35c14a786215 | €15.00 | €0.26 | matched |
| 115 | capture | 01a16832-bcff-73b1-9c2b-590d199bed21 | €24.00 | €0.37 | matched |
| 116 | refund | 01a16832-beaf-7b2c-b8b7-f337bb9996e1 | -€10.00 | €0.00 | matched |
| 117 | capture | 01a16832-da13-7bc7-a177-a0205bf8d0e9 | €24.00 | €0.37 | matched |
| 118 | capture | 01a16832-de0b-74fd-b280-4d0add1902fe | €24.00 | €0.37 | matched |
| 119 | capture | 01a16832-fb70-70af-b4a9-fcc68d93458b | €9.00 | €0.19 | matched |
| 120 | capture | 01a16833-1ff1-7aa4-b85b-b8347f5a7053 | €49.00 | €0.67 | matched |
| 121 | capture | 01a16833-26f2-7960-b579-bfb40fdd3881 | €49.00 | €0.67 | matched |
| 122 | capture | 01a16833-2e88-760f-a4d9-306d2821ea06 | €49.00 | €0.67 | matched |
| 123 | capture | 01a16833-6158-7653-947f-62d5b4fd02d7 | €9.00 | €0.19 | matched |
| 124 | capture | 01a16833-6685-7080-9362-8fea8df899d5 | €49.00 | €0.67 | matched |
| 125 | capture | 01a16833-73c3-777c-b59c-39e830f4ad86 | €35.00 | €0.50 | matched |
| 126 | capture | 01a16833-7a7e-7994-915f-c24ea17dcaf9 | €9.00 | €0.19 | matched |
| 127 | capture | 01a16833-96c1-79e1-8bac-0d0cde073ce9 | €24.00 | €0.37 | matched |
| 128 | capture | 01a16833-9d93-749a-88a3-c6102715fbb5 | €35.00 | €0.50 | matched |
| 129 | capture | 01a16833-a78b-7cca-8320-5859b063a95e | €49.00 | €0.67 | matched |
| 130 | capture | 01a16833-a43a-7711-81ba-07188e876ac1 | €15.00 | €0.26 | matched |
| 131 | capture | 01a16833-a8d4-7ef4-9817-80d0bbdafc70 | €24.00 | €0.37 | matched |
| 132 | capture | 01a16833-e522-782b-a7ac-bc897f24efe6 | €24.00 | €0.37 | matched |
| 133 | capture | 01a16833-e2b9-7786-98cb-03a57bc9fd6d | €35.00 | €0.50 | matched |
| 134 | refund | 01a16833-e852-745e-9034-bf445d821036 | -€31.00 | €0.00 | matched |
| 135 | capture | 01a16833-edde-7781-a710-c5c6f6c0510d | €35.00 | €0.50 | matched |