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, 18:50135 lines4 breaks
- 3 Nov, 18:40107 lines4 breaks
- 3 Nov, 18:30121 lines5 breaks
- 3 Nov, 18:20131 lines2 breaks
- 3 Nov, 18:10122 lines2 breaks
- 3 Nov, 18:00124 lines1 break
- 3 Nov, 17:50126 lines5 breaks
- 3 Nov, 17:40142 lines4 breaks
- 3 Nov, 17:3095 lines1 break
- 3 Nov, 17:20131 lines2 breaks
- 3 Nov, 17:10119 lines6 breaks
- 3 Nov, 17:00144 lines2 breaks
- 3 Nov, 16:50115 lines2 breaks
- 3 Nov, 16:40140 lines2 breaks
3 Nov, 17:40
Gross
€3,181.00
PSP fee
€51.00
Net to the bank
€3,130.00
Settlement journal
#365060
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a280-8e63-78ac-8e9e-f6c7d3b30807 is already settled by stl_EUR_2989546 line 19
- duplicate linethe file lists it twicecapture:01a1a282-b8b0-78e4-b7d1-a7a5ca95a4f6 is already settled by stl_EUR_2989546 line 63
- fee differencethe fee is not the contract feethe fee is 38, the contract says 37
- missing linein the books, not in the filecapture:01a1a27f-ca20-7bc8-a9b9-5740d3ae2098 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 17 | capture | 01a1a280-6475-7f35-a756-3501fa8a5056 | €24.00 | €0.38 | fee difference |
| 20 | capture | 01a1a280-8e80-7c4d-b192-b94d5b23b4cf | €24.00 | €0.37 | duplicate line |
| 64 | capture | 01a1a282-b8eb-7a7f-b283-caa4901cd50e | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1a27c-f659-7620-867d-380237679531 | €15.00 | €0.26 | matched |
| 2 | capture | 01a1a27d-8d5d-76ad-a40e-b5971b7039d5 | €24.00 | €0.37 | matched |
| 3 | capture | 01a1a27d-96b0-7d5a-89a4-654ffc42de41 | €15.00 | €0.26 | matched |
| 4 | capture | 01a1a27f-5f10-7f37-804f-10c16e893d4c | €49.00 | €0.67 | matched |
| 5 | capture | 01a1a27f-62eb-7711-84ac-895169311925 | €15.00 | €0.26 | matched |
| 6 | capture | 01a1a27f-6f8b-7dcc-88d9-d6522a1f7a3f | €35.00 | €0.50 | matched |
| 7 | capture | 01a1a27f-7a45-7d96-8057-c4d6a803f9b6 | €35.00 | €0.50 | matched |
| 8 | capture | 01a1a27f-91d5-7a0e-a567-16eb2e274750 | €24.00 | €0.37 | matched |
| 9 | capture | 01a1a27f-bc70-776a-9198-0a226ba0c7f9 | €35.00 | €0.50 | matched |
| 10 | capture | 01a1a27f-cc75-722d-8ad9-65ab1ed35534 | €15.00 | €0.26 | matched |
| 11 | capture | 01a1a27f-ea0e-7048-8ff2-92450d4736e3 | €9.00 | €0.19 | matched |
| 12 | capture | 01a1a280-31fd-7657-aab8-8a739bca1d2f | €15.00 | €0.26 | matched |
| 13 | capture | 01a1a280-38fa-7fd4-9a08-bc05418376f6 | €35.00 | €0.50 | matched |
| 14 | capture | 01a1a280-5862-719e-8b1b-e2b9bb8143ea | €9.00 | €0.19 | matched |
| 15 | capture | 01a1a280-597c-764a-a602-ae8217ae2d35 | €24.00 | €0.37 | matched |
| 16 | capture | 01a1a280-61e9-72da-ba0e-ed1ed94b83fa | €24.00 | €0.37 | matched |
| 18 | capture | 01a1a280-6be6-7648-80da-51fd93627d95 | €35.00 | €0.50 | matched |
| 19 | capture | 01a1a280-8e80-7c4d-b192-b94d5b23b4cf | €24.00 | €0.37 | matched |
| 21 | capture | 01a1a280-a2c9-7982-a849-fce63d50953b | €24.00 | €0.37 | matched |
| 22 | capture | 01a1a280-c2a8-7810-98e1-12bf4e9dbc55 | €15.00 | €0.26 | matched |
| 23 | capture | 01a1a280-d48f-7a3d-9920-0170c8b20752 | €49.00 | €0.67 | matched |
| 24 | capture | 01a1a280-da03-7bbf-8dbe-b210be3fae9d | €15.00 | €0.26 | matched |
| 25 | capture | 01a1a280-f518-7cd1-a52a-9170aeb7e850 | €35.00 | €0.50 | matched |
| 26 | capture | 01a1a280-fa3d-7884-a007-9efded109eef | €15.00 | €0.26 | matched |
| 27 | capture | 01a1a280-fcaf-7d90-a02f-b180d8405f71 | €15.00 | €0.26 | matched |
| 28 | capture | 01a1a280-fe69-7d20-a665-d721d36ad3d9 | €9.00 | €0.19 | matched |
| 29 | capture | 01a1a281-03e3-7921-b356-641c9f911ed6 | €49.00 | €0.67 | matched |
| 30 | capture | 01a1a281-0889-77e4-a773-41c3e20f814a | €24.00 | €0.37 | matched |
| 31 | capture | 01a1a281-2624-754e-99f5-fce1e64c7717 | €35.00 | €0.50 | matched |
| 32 | capture | 01a1a281-3f6e-7747-a3a1-621b11fa108d | €35.00 | €0.50 | matched |
| 33 | refund | 01a1a281-49b2-7e65-872c-797a121b5d40 | -€42.00 | €0.00 | matched |
| 34 | capture | 01a1a281-5a15-7461-b164-d7cd5669d3f5 | €35.00 | €0.50 | matched |
| 35 | capture | 01a1a281-6823-7e16-b37f-568a1d5e09c7 | €24.00 | €0.37 | matched |
| 36 | capture | 01a1a281-7620-7483-b6d1-b124eb784975 | €35.00 | €0.50 | matched |
| 37 | capture | 01a1a281-7a8e-745d-8702-505dc0b7705c | €15.00 | €0.26 | matched |
| 38 | capture | 01a1a281-9343-7fb7-b804-f10422a69b45 | €49.00 | €0.67 | matched |
| 39 | capture | 01a1a281-95b1-7187-bce4-0fe93181f30b | €24.00 | €0.37 | matched |
| 40 | capture | 01a1a281-a985-7231-955d-4385a11b8287 | €24.00 | €0.37 | matched |
| 41 | capture | 01a1a281-b446-7bca-9402-6c889d1480c4 | €49.00 | €0.67 | matched |
| 42 | capture | 01a1a281-d854-753a-b490-849531fa7973 | €35.00 | €0.50 | matched |
| 43 | capture | 01a1a281-dd54-7ff7-b1d9-fd5cfab74502 | €49.00 | €0.67 | matched |
| 44 | capture | 01a1a281-dfb7-7e5e-af96-9f3a5c5dcddd | €49.00 | €0.67 | matched |
| 45 | capture | 01a1a281-ebd7-73b9-93c5-2a2c87181838 | €24.00 | €0.37 | matched |
| 46 | capture | 01a1a281-f599-717c-aff3-989e2bae61d6 | €49.00 | €0.67 | matched |
| 47 | refund | 01a1a281-fb83-78c8-a42b-906dfd2efc8e | -€13.00 | €0.00 | matched |
| 48 | capture | 01a1a282-114a-7525-8153-4f3a98415d32 | €35.00 | €0.50 | matched |
| 49 | capture | 01a1a282-11a7-7769-843c-f8ee1f18dbee | €24.00 | €0.37 | matched |
| 50 | capture | 01a1a282-1b0d-78df-a628-68232fa9ce55 | €15.00 | €0.26 | matched |
| 51 | capture | 01a1a282-37e4-74f8-8e1f-998e8f7120e2 | €9.00 | €0.19 | matched |
| 52 | capture | 01a1a282-4f6a-7d51-bbb6-210b12b51df9 | €9.00 | €0.19 | matched |
| 53 | capture | 01a1a282-6374-7e40-8d63-559ba8ebb0ed | €15.00 | €0.26 | matched |
| 54 | capture | 01a1a282-68b5-709f-83e1-073061b36182 | €49.00 | €0.67 | matched |
| 55 | capture | 01a1a282-6aa3-7441-9c89-2fd90f18e9b0 | €9.00 | €0.19 | matched |
| 56 | capture | 01a1a282-718c-7828-8a8d-51ccb75c27a3 | €9.00 | €0.19 | matched |
| 57 | capture | 01a1a282-80ff-7416-b02a-49682641620e | €15.00 | €0.26 | matched |
| 58 | capture | 01a1a282-88e8-7d17-a028-4b81fcd674f1 | €49.00 | €0.67 | matched |
| 59 | capture | 01a1a282-98c1-7f44-8cbc-c58ce7d7cb94 | €9.00 | €0.19 | matched |
| 60 | capture | 01a1a282-9a66-7727-9634-981b2e5a02ef | €9.00 | €0.19 | matched |
| 61 | capture | 01a1a282-a269-7e81-b834-6caa09b61809 | €9.00 | €0.19 | matched |
| 62 | capture | 01a1a282-af4e-71a8-89b1-ec13a9b932f4 | €49.00 | €0.67 | matched |
| 63 | capture | 01a1a282-b8eb-7a7f-b283-caa4901cd50e | €49.00 | €0.67 | matched |
| 65 | refund | 01a1a282-be5a-72d2-88d4-66c9dcbec222 | -€13.00 | €0.00 | matched |
| 66 | capture | 01a1a282-c309-7d40-8157-863f4d7bdede | €24.00 | €0.37 | matched |
| 67 | capture | 01a1a282-c60e-7aaf-83af-545bb49df157 | €15.00 | €0.26 | matched |
| 68 | refund | 01a1a282-c820-7b11-96c4-a5ab1996cc8f | -€2.00 | €0.00 | matched |
| 69 | capture | 01a1a282-e148-7409-81be-7522c75fb081 | €35.00 | €0.50 | matched |
| 70 | capture | 01a1a282-f804-7cef-b205-5c9be696d4f8 | €35.00 | €0.50 | matched |
| 71 | refund | 01a1a282-f9f7-7d9b-9604-c9b544411b5f | -€7.00 | €0.00 | matched |
| 72 | refund | 01a1a283-0d7c-77c0-86ee-35e1e7513bf4 | -€24.00 | €0.00 | matched |
| 73 | capture | 01a1a283-1880-7940-a7d0-aba761b71fef | €15.00 | €0.26 | matched |
| 74 | capture | 01a1a283-1cfe-7f0f-b2fa-ab65598d0bd3 | €49.00 | €0.67 | matched |
| 75 | refund | 01a1a283-2dbd-7943-8a4f-b45fb0bccaf7 | -€23.00 | €0.00 | matched |
| 76 | capture | 01a1a283-39c1-7a88-a471-6bfd53f73ace | €49.00 | €0.67 | matched |
| 77 | capture | 01a1a283-5e95-7124-a3eb-3b76186f33f9 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1a283-6a53-7477-961e-cdf4c6502601 | €49.00 | €0.67 | matched |
| 79 | capture | 01a1a283-6daa-7e13-951c-40f3aaa4126d | €9.00 | €0.19 | matched |
| 80 | capture | 01a1a283-7660-7fca-a265-da3a60c992c4 | €15.00 | €0.26 | matched |
| 81 | capture | 01a1a283-7d34-7a61-bdb3-cf95bb7fd5f3 | €9.00 | €0.19 | matched |
| 82 | capture | 01a1a283-7fd4-78c0-971a-542dc0430bb2 | €24.00 | €0.37 | matched |
| 83 | capture | 01a1a283-96e6-798e-b233-3269afb25f60 | €49.00 | €0.67 | matched |
| 84 | capture | 01a1a283-ac3c-71d1-8717-ef39d767d779 | €24.00 | €0.37 | matched |
| 85 | capture | 01a1a283-ae72-7998-ab79-038d2468f9a0 | €24.00 | €0.37 | matched |
| 86 | capture | 01a1a283-bba9-7cab-81b7-85b274a5414e | €24.00 | €0.37 | matched |
| 87 | capture | 01a1a283-c05e-74c6-a366-de5279832194 | €9.00 | €0.19 | matched |
| 88 | capture | 01a1a283-da5a-7f80-b641-aa076078169e | €15.00 | €0.26 | matched |
| 89 | capture | 01a1a283-e4a5-7f23-9c29-98a941b33584 | €9.00 | €0.19 | matched |
| 90 | capture | 01a1a283-e801-7650-94e6-47fe35bac917 | €49.00 | €0.67 | matched |
| 91 | capture | 01a1a284-06e1-7863-a2a9-92865c7fd366 | €15.00 | €0.26 | matched |
| 92 | refund | 01a1a284-0868-7c53-98ba-c1be44f68a5e | -€9.00 | €0.00 | matched |
| 93 | capture | 01a1a284-1293-76ea-8792-25a7c95ad2ee | €9.00 | €0.19 | matched |
| 94 | capture | 01a1a284-32f3-7e60-a734-e3adf66b79c2 | €49.00 | €0.67 | matched |
| 95 | capture | 01a1a284-6440-76fa-abf0-b84d2e5cc6ec | €9.00 | €0.19 | matched |
| 96 | refund | 01a1a284-6f8e-7a63-af85-5f22079aa9e0 | -€11.00 | €0.00 | matched |
| 97 | capture | 01a1a284-8f06-77bc-be52-6c6c586b7fee | €15.00 | €0.26 | matched |
| 98 | capture | 01a1a284-d07c-7dee-97e3-98db444185d2 | €24.00 | €0.37 | matched |
| 99 | capture | 01a1a285-3422-7f3f-ad5d-7a7238b773e5 | €15.00 | €0.26 | matched |
| 100 | capture | 01a1a285-375b-7587-b817-48acdfd1dc18 | €15.00 | €0.26 | matched |
| 101 | capture | 01a1a285-4acb-740f-ad96-aa23bf2904da | €24.00 | €0.37 | matched |
| 102 | capture | 01a1a285-60a1-71bf-aac9-0566590df71c | €9.00 | €0.19 | matched |
| 103 | capture | 01a1a285-62dd-7a5e-913f-694fdc236200 | €9.00 | €0.19 | matched |
| 104 | capture | 01a1a285-65cb-7973-a66d-3e111f990a57 | €15.00 | €0.26 | matched |
| 105 | capture | 01a1a285-6a40-705d-8c38-0b4c4a1f2180 | €9.00 | €0.19 | matched |
| 106 | refund | 01a1a285-7a83-7c71-b5ff-1714e11ff385 | -€7.00 | €0.00 | matched |
| 107 | capture | 01a1a285-9477-7d48-ad1e-1e532953f0eb | €49.00 | €0.67 | matched |
| 108 | capture | 01a1a285-b168-779c-9ecf-ab7ab63e17dd | €9.00 | €0.19 | matched |
| 109 | capture | 01a1a285-b539-7be3-8a44-edcd24944bc6 | €49.00 | €0.67 | matched |
| 110 | capture | 01a1a285-b9f7-702c-9b32-b7023c8a2115 | €35.00 | €0.50 | matched |
| 111 | capture | 01a1a286-118c-7a52-bbe6-1a7b69999e10 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1a286-2429-7554-bb64-e35c8415a1ef | €15.00 | €0.26 | matched |
| 113 | capture | 01a1a286-273e-7db7-b6b0-2b33e114176c | €15.00 | €0.26 | matched |
| 114 | capture | 01a1a286-27fd-754a-b8ac-59b36667cf94 | €15.00 | €0.26 | matched |
| 115 | capture | 01a1a286-4440-7820-a282-3cb4e271c911 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1a286-8b2c-716b-bc13-105b65885cfb | €24.00 | €0.37 | matched |
| 117 | capture | 01a1a286-970b-70aa-bfd9-06c15c9b8292 | €24.00 | €0.37 | matched |
| 118 | capture | 01a1a286-ad24-75e2-a2e9-19f8e7d7a0bf | €49.00 | €0.67 | matched |
| 119 | capture | 01a1a286-af81-740a-8f52-3cc0ecf73892 | €24.00 | €0.37 | matched |
| 120 | capture | 01a1a286-b143-7cf1-b55b-13f3ef31a6d2 | €9.00 | €0.19 | matched |
| 121 | capture | 01a1a286-cda6-75ca-9419-8bcee9e93fa7 | €15.00 | €0.26 | matched |
| 122 | capture | 01a1a286-e532-75af-b76f-78893cc9b8e8 | €15.00 | €0.26 | matched |
| 123 | capture | 01a1a286-fcfb-7fef-9fa7-97dc48969696 | €9.00 | €0.19 | matched |
| 124 | capture | 01a1a287-0aeb-71bd-8ce7-e64fb3d97130 | €15.00 | €0.26 | matched |
| 125 | capture | 01a1a287-144b-761a-aafa-311b375f9ef5 | €49.00 | €0.67 | matched |
| 126 | refund | 01a1a287-23f6-711e-9cbf-043e2574c57e | -€14.00 | €0.00 | matched |
| 127 | capture | 01a1a287-28dd-7603-b9e9-70623b8856a8 | €24.00 | €0.37 | matched |
| 128 | capture | 01a1a287-2a4c-7217-b013-180e7c2d4545 | €9.00 | €0.19 | matched |
| 129 | capture | 01a1a287-31d1-7075-9671-89edc95d2a48 | €49.00 | €0.67 | matched |
| 130 | capture | 01a1a287-3b27-7404-b239-0f757c746a58 | €24.00 | €0.37 | matched |
| 131 | capture | 01a1a287-3eeb-79cf-8338-694822f78d99 | €15.00 | €0.26 | matched |
| 132 | capture | 01a1a287-5bda-7637-9b4d-565372c49e13 | €35.00 | €0.50 | matched |
| 133 | capture | 01a1a287-61c2-730c-8ef0-edd0ccb112f6 | €24.00 | €0.37 | matched |
| 134 | capture | 01a1a287-a296-7850-831a-46f8784ff90b | €35.00 | €0.50 | matched |
| 135 | refund | 01a1a287-a5ea-71f6-9da8-a2bbf00e81bb | -€23.00 | €0.00 | matched |
| 136 | capture | 01a1a287-c250-7513-a85e-4d9fa61db780 | €49.00 | €0.67 | matched |
| 137 | capture | 01a1a287-d1cd-7deb-a070-4a7b0b092e49 | €35.00 | €0.50 | matched |
| 138 | capture | 01a1a287-d8f3-78b9-a8ed-d754884381a0 | €9.00 | €0.19 | matched |
| 139 | capture | 01a1a287-dade-7fc3-836f-cab34d5df677 | €49.00 | €0.67 | matched |
| 140 | capture | 01a1a287-e05f-7048-9a82-516653d021f2 | €49.00 | €0.67 | matched |
| 141 | capture | 01a1a288-0a4f-75be-b866-bc32e59c4632 | €9.00 | €0.19 | matched |
| 142 | capture | 01a1a288-1cd9-7248-b7d3-5b1760c0e738 | €9.00 | €0.19 | matched |