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
- 19 Oct, 16:00131 lines2 breaks
- 19 Oct, 15:50117 lines3 breaks
- 19 Oct, 15:40117 lines1 break
- 19 Oct, 15:30120 lines3 breaks
- 19 Oct, 15:20140 lines6 breaks
- 19 Oct, 15:10130 lines2 breaks
- 19 Oct, 15:0095 lines3 breaks
- 19 Oct, 14:50116 lines2 breaks
- 19 Oct, 14:40140 lines3 breaks
- 19 Oct, 14:30115 lines3 breaks
- 19 Oct, 14:20106 lines3 breaks
- 19 Oct, 14:10120 lines1 break
- 19 Oct, 14:00124 lines1 break
- 19 Oct, 13:50118 lines3 breaks
19 Oct, 14:20
Gross
€2,458.00
PSP fee
€39.21
Net to the bank
€2,418.79
Settlement journal
#88547
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a1548c-ef8e-7dc9-b487-456fd4c6d17d is already settled by stl_EUR_2987366 line 60
- fee differencethe fee is not the contract feethe fee is 54, the contract says 50
- missing linein the books, not in the filecapture:01a1548e-9d5e-71d1-9a3c-1a6919000bb7 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 57 | capture | 01a1548c-de82-7d74-b99b-bb78beff90e2 | €35.00 | €0.54 | fee difference |
| 61 | refund | 01a1548c-ef8f-7d87-8cd5-9404f542d43e | -€30.00 | €0.00 | duplicate line |
| 1 | capture | 01a15481-b3bd-7a8c-a98d-ba09aa299c11 | €9.00 | €0.19 | matched |
| 2 | capture | 01a15482-eedd-76e6-b8f1-6cf2be5e3f0f | €24.00 | €0.37 | matched |
| 3 | refund | 01a15483-4aac-7b98-8f17-9c05686b9eff | -€9.00 | €0.00 | matched |
| 4 | capture | 01a15483-b6e3-7e56-9d0a-449359b8236c | €9.00 | €0.19 | matched |
| 5 | capture | 01a15486-e510-75e7-a5d7-143b6921c9ff | €35.00 | €0.50 | matched |
| 6 | capture | 01a15487-79fd-7a8a-a63e-63c0a5dca489 | €24.00 | €0.37 | matched |
| 7 | capture | 01a15488-9f6c-7317-bdd2-bcd9e4ffd0f7 | €24.00 | €0.37 | matched |
| 8 | capture | 01a15488-a8c4-7499-9e6d-8aa365aaa75d | €15.00 | €0.26 | matched |
| 9 | capture | 01a15488-cf1b-7fef-9c61-cd5275158f35 | €49.00 | €0.67 | matched |
| 10 | capture | 01a15488-d8df-742f-8174-e2a8eb8d4148 | €9.00 | €0.19 | matched |
| 11 | capture | 01a15488-dd68-79b5-b085-19ea4ee8e2a5 | €49.00 | €0.67 | matched |
| 12 | capture | 01a15489-0b6f-779f-86f2-b01e89b5153d | €15.00 | €0.26 | matched |
| 13 | capture | 01a15489-0c2a-75e6-b264-7820c6b68caf | €49.00 | €0.67 | matched |
| 14 | capture | 01a15489-118d-7caa-a05a-b4fe50d1aef5 | €49.00 | €0.67 | matched |
| 15 | capture | 01a15489-34e2-7835-a649-c0683506cdd1 | €9.00 | €0.19 | matched |
| 16 | capture | 01a15489-48f1-7d34-beb3-6571db6807b2 | €15.00 | €0.26 | matched |
| 17 | capture | 01a15489-568b-7771-94be-f72f9d020ca4 | €49.00 | €0.67 | matched |
| 18 | capture | 01a15489-58f1-73be-a777-9c9e1c10e9f7 | €35.00 | €0.50 | matched |
| 19 | capture | 01a15489-8c0d-768a-91ad-d71393aca96a | €49.00 | €0.67 | matched |
| 20 | capture | 01a15489-9219-7d69-96b8-72a17efb4dfd | €24.00 | €0.37 | matched |
| 21 | capture | 01a15489-9e8d-7812-b456-92a83cbfd010 | €9.00 | €0.19 | matched |
| 22 | capture | 01a15489-a8b0-7709-ba12-2c7625798ab1 | €49.00 | €0.67 | matched |
| 23 | refund | 01a15489-adce-7396-8263-f77cb6fa6d19 | -€9.00 | €0.00 | matched |
| 24 | capture | 01a15489-aebe-75ae-95ec-394d4e701c7a | €9.00 | €0.19 | matched |
| 25 | capture | 01a15489-c419-72d7-a361-5eddbbd47780 | €15.00 | €0.26 | matched |
| 26 | capture | 01a15489-e19a-7104-8439-88714e3ef9e5 | €49.00 | €0.67 | matched |
| 27 | capture | 01a15489-f77a-716a-9383-52314d99d9c2 | €15.00 | €0.26 | matched |
| 28 | capture | 01a1548a-16ef-7a21-ba38-f385c521141e | €35.00 | €0.50 | matched |
| 29 | capture | 01a1548a-2253-7be7-84a5-bc36ff355a15 | €9.00 | €0.19 | matched |
| 30 | capture | 01a1548a-2f21-7643-b52a-b7ef39a11218 | €49.00 | €0.67 | matched |
| 31 | capture | 01a1548a-4192-708c-8290-6736ee29ba87 | €49.00 | €0.67 | matched |
| 32 | capture | 01a1548a-4836-7f24-a30c-51fdb4154fad | €35.00 | €0.50 | matched |
| 33 | refund | 01a1548a-a153-73a0-ba40-28a35b35940e | -€21.00 | €0.00 | matched |
| 34 | capture | 01a1548a-e893-7f0a-8b39-9fdddaa4ed27 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1548a-e9d4-73f8-99d3-952ad7b3b0bc | €49.00 | €0.67 | matched |
| 36 | capture | 01a1548a-ed29-748d-8521-aab60188bb8f | €49.00 | €0.67 | matched |
| 37 | capture | 01a1548a-fb06-70e5-b0a6-a55420dcf7f7 | €49.00 | €0.67 | matched |
| 38 | capture | 01a1548b-0697-7bbf-95e5-34f59b30990c | €35.00 | €0.50 | matched |
| 39 | capture | 01a1548b-1c83-70b5-bdad-6508a28784d8 | €35.00 | €0.50 | matched |
| 40 | capture | 01a1548b-62a4-788b-8e3c-72cdf91b9b45 | €35.00 | €0.50 | matched |
| 41 | refund | 01a1548b-705b-73d6-ad7b-de458a1df098 | -€15.00 | €0.00 | matched |
| 42 | capture | 01a1548b-a43a-7f8f-9777-e74ce00df04c | €15.00 | €0.26 | matched |
| 43 | capture | 01a1548b-b271-7a9a-a700-f85d91d682ac | €35.00 | €0.50 | matched |
| 44 | capture | 01a1548b-bc8a-7822-a068-1836475165f0 | €9.00 | €0.19 | matched |
| 45 | capture | 01a1548b-dc98-7fec-89ef-12ba9557ae80 | €15.00 | €0.26 | matched |
| 46 | capture | 01a1548b-ec6e-7a1e-afc9-4de7b4f1eb0a | €15.00 | €0.26 | matched |
| 47 | capture | 01a1548b-f67b-7015-a3c3-f9847c4cef51 | €49.00 | €0.67 | matched |
| 48 | capture | 01a1548b-f6b0-7e04-a2c2-5b0d39af043c | €35.00 | €0.50 | matched |
| 49 | capture | 01a1548c-2f6e-7d1e-92af-beed3076f89b | €15.00 | €0.26 | matched |
| 50 | capture | 01a1548c-4c96-7068-8314-2bf5c0a4ca60 | €35.00 | €0.50 | matched |
| 51 | capture | 01a1548c-524d-7424-9681-064b2b9cd077 | €9.00 | €0.19 | matched |
| 52 | capture | 01a1548c-882b-7685-9dde-1b581c087f81 | €24.00 | €0.37 | matched |
| 53 | capture | 01a1548c-90aa-7e59-ab95-8b30101bb6d1 | €15.00 | €0.26 | matched |
| 54 | capture | 01a1548c-b51b-77cc-bd67-a979afffa6c9 | €24.00 | €0.37 | matched |
| 55 | capture | 01a1548c-c7a4-730f-ab04-a76616e1b6b9 | €49.00 | €0.67 | matched |
| 56 | capture | 01a1548c-ddc4-7db2-bef4-78ce101eb08c | €9.00 | €0.19 | matched |
| 58 | capture | 01a1548c-e3eb-77e4-ab71-8115e9821a32 | €9.00 | €0.19 | matched |
| 59 | capture | 01a1548c-e5e7-7415-bb94-89a63c4f0f04 | €24.00 | €0.37 | matched |
| 60 | refund | 01a1548c-ef8f-7d87-8cd5-9404f542d43e | -€30.00 | €0.00 | matched |
| 62 | capture | 01a1548d-244f-7c24-86ea-6b605c64c85d | €24.00 | €0.37 | matched |
| 63 | capture | 01a1548d-5648-75b9-b2b1-13717d8c66e0 | €24.00 | €0.37 | matched |
| 64 | capture | 01a1548d-6a95-7102-85b1-6e6114485606 | €24.00 | €0.37 | matched |
| 65 | refund | 01a1548d-70ca-7394-b5f5-81c8c91649b5 | -€18.00 | €0.00 | matched |
| 66 | capture | 01a1548d-7416-724a-bc5b-2fa000c2efb4 | €49.00 | €0.67 | matched |
| 67 | capture | 01a1548d-7f4e-7298-be1a-f257ed955d41 | €9.00 | €0.19 | matched |
| 68 | capture | 01a1548d-819b-7224-844b-f99eec96960f | €49.00 | €0.67 | matched |
| 69 | capture | 01a1548d-a881-7937-b406-e13bdb23e96e | €15.00 | €0.26 | matched |
| 70 | capture | 01a1548d-d79f-7b89-891d-d149c9cf57c5 | €24.00 | €0.37 | matched |
| 71 | capture | 01a1548e-0a91-7d92-9043-65da39119787 | €15.00 | €0.26 | matched |
| 72 | capture | 01a1548e-1016-71f9-8735-e4ecba5343db | €9.00 | €0.19 | matched |
| 73 | refund | 01a1548e-18be-7200-af09-b43bc15fd358 | -€11.00 | €0.00 | matched |
| 74 | capture | 01a1548e-392f-7cd4-8f8d-4a29e87d572a | €15.00 | €0.26 | matched |
| 75 | capture | 01a1548e-5c36-7c80-bad2-e458140b9917 | €24.00 | €0.37 | matched |
| 76 | capture | 01a1548e-796a-7c48-af3e-f9e0f0fb22f4 | €15.00 | €0.26 | matched |
| 77 | capture | 01a1548e-7cc1-7fa1-82ad-f57c5cb02168 | €24.00 | €0.37 | matched |
| 78 | capture | 01a1548e-a886-7092-9c1b-6abb7fb1aa70 | €49.00 | €0.67 | matched |
| 79 | capture | 01a1548e-e36d-779d-b05f-4d300bfb1e9a | €24.00 | €0.37 | matched |
| 80 | capture | 01a1548e-f065-7889-87d1-44c9795f9636 | €15.00 | €0.26 | matched |
| 81 | capture | 01a1548f-0243-76ad-bc4c-86a77365570f | €9.00 | €0.19 | matched |
| 82 | capture | 01a1548f-22a7-7211-9e52-779d59b29962 | €15.00 | €0.26 | matched |
| 83 | capture | 01a1548f-29c8-7f3e-ba18-f889d085ba67 | €49.00 | €0.67 | matched |
| 84 | capture | 01a1548f-7467-761c-acb6-88b4209a78a5 | €24.00 | €0.37 | matched |
| 85 | capture | 01a1548f-8bb6-7d64-af5e-b0229fcf4618 | €24.00 | €0.37 | matched |
| 86 | capture | 01a1548f-ae53-76a7-970d-2ec61fe2ad41 | €15.00 | €0.26 | matched |
| 87 | capture | 01a1548f-e115-7a08-a1fb-2cd94ad45f58 | €15.00 | €0.26 | matched |
| 88 | capture | 01a1548f-f4d1-707f-9779-40112a305ed0 | €35.00 | €0.50 | matched |
| 89 | capture | 01a1548f-f605-7aac-a220-3aed94646819 | €49.00 | €0.67 | matched |
| 90 | capture | 01a15490-26d8-77ad-a573-1d9047cbfe5e | €24.00 | €0.37 | matched |
| 91 | capture | 01a15490-2ad2-74ac-a79f-578303a66dbb | €9.00 | €0.19 | matched |
| 92 | capture | 01a15490-2cb1-78c2-82ca-fbc9d8ef8394 | €9.00 | €0.19 | matched |
| 93 | capture | 01a15490-455c-7598-b3c4-2e7b863edda3 | €15.00 | €0.26 | matched |
| 94 | capture | 01a15490-65ae-7aad-b31b-1d3337623a71 | €24.00 | €0.37 | matched |
| 95 | capture | 01a15490-973a-7443-8770-41ed58ecf8de | €9.00 | €0.19 | matched |
| 96 | capture | 01a15490-ad05-78d5-9976-919a4eca8e59 | €49.00 | €0.67 | matched |
| 97 | capture | 01a15490-f137-7f42-9a9d-cd5e16b82610 | €9.00 | €0.19 | matched |
| 98 | capture | 01a15491-042f-7d32-bf2d-38a00f795807 | €15.00 | €0.26 | matched |
| 99 | capture | 01a15491-1850-78a8-9db3-0447938efe5e | €35.00 | €0.50 | matched |
| 100 | capture | 01a15491-1f91-7575-9434-aad0235460b3 | €15.00 | €0.26 | matched |
| 101 | capture | 01a15491-30cb-73cd-9c16-ee7c96a3c7f2 | €35.00 | €0.50 | matched |
| 102 | capture | 01a15491-4e96-7629-8d7a-39db417ac0bc | €35.00 | €0.50 | matched |
| 103 | capture | 01a15491-8c34-7f0e-8cac-64e3840a00dc | €24.00 | €0.37 | matched |
| 104 | capture | 01a15491-97fe-7091-9029-8fe41456d65a | €49.00 | €0.67 | matched |
| 105 | capture | 01a15491-aa99-7d70-9cc8-67e5babd512c | €15.00 | €0.26 | matched |
| 106 | capture | 01a15491-bb1d-733b-ae8c-963d2ed37712 | €35.00 | €0.50 | matched |