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, 08:20124 lines1 break
- 3 Nov, 08:10121 lines1 break
- 3 Nov, 08:00114 lines2 breaks
- 3 Nov, 07:50128 lines3 breaks
- 3 Nov, 07:40100 lines1 break
- 3 Nov, 07:30122 lines3 breaks
- 3 Nov, 07:20116 lines1 break
- 3 Nov, 07:10128 lines3 breaks
- 3 Nov, 07:00139 lines4 breaks
- 3 Nov, 06:50108 lines2 breaks
- 3 Nov, 06:40127 lines3 breaks
- 3 Nov, 06:30120 lines1 break
- 3 Nov, 06:20131 lines3 breaks
- 3 Nov, 06:10131 lines2 breaks
3 Nov, 07:00
Gross
€3,375.00
PSP fee
€53.10
Net to the bank
€3,321.90
Settlement journal
#357006
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a1a03b-0e4b-7417-bcd0-8a7e2dd3bdd8 is already settled by stl_EUR_2989482 line 91
- fee differencethe fee is not the contract feethe fee is 29, the contract says 26
- missing linein the books, not in the filecapture:01a1a037-254f-7cac-b72d-0fb73c64add3 is in no file
- missing linein the books, not in the filecapture:01a1a03e-0b96-748f-8431-d581ea3a53e4 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 25 | capture | 01a1a036-3c1a-7bb1-8d9d-c7781ef7d9ac | €15.00 | €0.29 | fee difference |
| 92 | refund | 01a1a03b-0e4c-7939-b2fe-5ac7166c2b5d | -€16.00 | €0.00 | duplicate line |
| 1 | capture | 01a1a02c-16e2-7067-a17c-20600f9c6d8b | €15.00 | €0.26 | matched |
| 2 | capture | 01a1a031-a498-73bd-8f23-a3f671d4c1d1 | €24.00 | €0.37 | matched |
| 3 | capture | 01a1a033-5794-795c-8247-fa154106173a | €15.00 | €0.26 | matched |
| 4 | capture | 01a1a034-010a-78ab-bbe9-dac37f148d6f | €49.00 | €0.67 | matched |
| 5 | refund | 01a1a035-258c-70fd-91cd-b88e25b275a7 | -€29.00 | €0.00 | matched |
| 6 | capture | 01a1a035-2689-775f-b4e3-a534d691e19b | €24.00 | €0.37 | matched |
| 7 | capture | 01a1a035-2d13-744d-bd76-a5f324b40c2b | €9.00 | €0.19 | matched |
| 8 | capture | 01a1a035-348c-7f6d-8b03-a93e274233f3 | €9.00 | €0.19 | matched |
| 9 | refund | 01a1a035-5b73-7990-bcbf-6df897114965 | -€24.00 | €0.00 | matched |
| 10 | capture | 01a1a035-8078-7170-a259-f38c505ef1c7 | €49.00 | €0.67 | matched |
| 11 | capture | 01a1a035-88b1-7009-9250-fdb34f92722e | €35.00 | €0.50 | matched |
| 12 | capture | 01a1a035-95f3-74b9-8313-5b6b94084e38 | €49.00 | €0.67 | matched |
| 13 | capture | 01a1a035-9a21-7968-acc9-56881218daf7 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1a035-ad57-7831-a326-d2b0fb9e7a6c | €49.00 | €0.67 | matched |
| 15 | capture | 01a1a035-b7cf-7f82-97f4-bfd88d342b10 | €15.00 | €0.26 | matched |
| 16 | capture | 01a1a035-cf3d-7c99-80de-128886e9d392 | €35.00 | €0.50 | matched |
| 17 | capture | 01a1a035-d49e-7bb9-ae81-7d52fff5fcac | €15.00 | €0.26 | matched |
| 18 | capture | 01a1a035-d9b0-7942-80d3-5a8e1d55a1f7 | €24.00 | €0.37 | matched |
| 19 | capture | 01a1a035-e3c3-71d8-be9f-0d23171569b4 | €24.00 | €0.37 | matched |
| 20 | capture | 01a1a035-e721-7883-886b-b6fb2d84f3fa | €9.00 | €0.19 | matched |
| 21 | capture | 01a1a036-129a-7f63-9b43-f331d760cb0c | €35.00 | €0.50 | matched |
| 22 | capture | 01a1a036-23d9-73e4-905f-facf04d20070 | €24.00 | €0.37 | matched |
| 23 | capture | 01a1a036-38cc-730b-9832-1ad894836d08 | €15.00 | €0.26 | matched |
| 24 | refund | 01a1a036-3b5c-768c-acb7-23cf9b8c0394 | -€9.00 | €0.00 | matched |
| 26 | capture | 01a1a036-4368-7f4f-b9e4-e17dbe31b69f | €15.00 | €0.26 | matched |
| 27 | capture | 01a1a036-4ec6-7332-8d9d-3317adc1595b | €35.00 | €0.50 | matched |
| 28 | capture | 01a1a036-7b36-7911-b39e-801a5108e26b | €35.00 | €0.50 | matched |
| 29 | capture | 01a1a036-8445-715b-9677-5ad09bb03d1e | €35.00 | €0.50 | matched |
| 30 | capture | 01a1a036-9144-7da3-a487-a50c6575adb4 | €49.00 | €0.67 | matched |
| 31 | capture | 01a1a036-ac89-7165-8c07-84f4d9c0c40a | €9.00 | €0.19 | matched |
| 32 | capture | 01a1a036-b52f-73db-ba35-577468bc0e3d | €24.00 | €0.37 | matched |
| 33 | capture | 01a1a036-c724-7bd2-94cf-68eb75b78fd8 | €35.00 | €0.50 | matched |
| 34 | capture | 01a1a036-c5fc-7f64-914d-189e13cc1039 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1a036-dade-7e2f-a18f-8a6c375aad42 | €24.00 | €0.37 | matched |
| 36 | capture | 01a1a036-dbbd-791b-886d-187eff5fc4ae | €24.00 | €0.37 | matched |
| 37 | capture | 01a1a036-f53e-718e-8971-b2a225e8c90b | €49.00 | €0.67 | matched |
| 38 | capture | 01a1a036-fc4c-7be0-9844-e3b756773dcb | €24.00 | €0.37 | matched |
| 39 | capture | 01a1a037-14a8-7032-b951-928d83037192 | €15.00 | €0.26 | matched |
| 40 | capture | 01a1a037-16f9-7220-b801-9e2c8c13c37c | €35.00 | €0.50 | matched |
| 41 | capture | 01a1a037-1fcf-71d9-b2c5-225b7cc48139 | €15.00 | €0.26 | matched |
| 42 | capture | 01a1a037-2201-7fcc-9d1a-b44567996791 | €15.00 | €0.26 | matched |
| 43 | capture | 01a1a037-2212-7297-bee0-0ada8c6d6cff | €35.00 | €0.50 | matched |
| 44 | capture | 01a1a037-3f32-7e1a-9dca-adb1121210ba | €35.00 | €0.50 | matched |
| 45 | refund | 01a1a037-4d35-7281-8014-0316854689d6 | -€14.00 | €0.00 | matched |
| 46 | capture | 01a1a037-6362-744f-a38e-baf1d27ecb0d | €35.00 | €0.50 | matched |
| 47 | capture | 01a1a037-8617-7a6c-9fe6-97d9adef01d5 | €35.00 | €0.50 | matched |
| 48 | capture | 01a1a037-964e-7d95-adc6-dcc17cb6633f | €35.00 | €0.50 | matched |
| 49 | capture | 01a1a037-b03a-733e-a8d5-ade7da16bba5 | €9.00 | €0.19 | matched |
| 50 | capture | 01a1a037-e7bc-7bc8-b3e4-2667112f46f3 | €24.00 | €0.37 | matched |
| 51 | capture | 01a1a037-ea6e-7dab-940b-5af6946d03fe | €49.00 | €0.67 | matched |
| 52 | capture | 01a1a037-ea98-75c3-aa7d-d33e1dab44d7 | €49.00 | €0.67 | matched |
| 53 | capture | 01a1a037-fa10-7f8a-8a07-616b8f189553 | €9.00 | €0.19 | matched |
| 54 | capture | 01a1a038-0b50-717a-864d-1e142455f624 | €49.00 | €0.67 | matched |
| 55 | capture | 01a1a038-2de8-71a5-b1d1-10bd941d5b26 | €35.00 | €0.50 | matched |
| 56 | refund | 01a1a038-2dfa-7748-bcf6-18034a832a49 | -€9.00 | €0.00 | matched |
| 57 | capture | 01a1a038-41ac-7527-84a7-9cf8793067e7 | €9.00 | €0.19 | matched |
| 58 | capture | 01a1a038-47eb-74bf-a710-8204947a3069 | €15.00 | €0.26 | matched |
| 59 | capture | 01a1a038-4985-7bc5-9d37-6aeda47d1b1e | €9.00 | €0.19 | matched |
| 60 | capture | 01a1a038-5e6a-7e21-a361-52855a57b5bc | €35.00 | €0.50 | matched |
| 61 | capture | 01a1a038-7711-7748-941d-bf63166f17f2 | €49.00 | €0.67 | matched |
| 62 | capture | 01a1a038-794b-7fc8-bd0e-3b2fcc15e488 | €15.00 | €0.26 | matched |
| 63 | capture | 01a1a038-a5dd-73b3-966d-5c8477af71e7 | €49.00 | €0.67 | matched |
| 64 | capture | 01a1a038-acee-7c25-b450-3dbb59c32849 | €9.00 | €0.19 | matched |
| 65 | capture | 01a1a038-ccf8-7c75-87a0-0c5971727edf | €24.00 | €0.37 | matched |
| 66 | capture | 01a1a038-cddd-79e5-96cc-2e7df3666907 | €15.00 | €0.26 | matched |
| 67 | refund | 01a1a038-d0b8-797c-9519-7110b1e5aff2 | -€10.00 | €0.00 | matched |
| 68 | capture | 01a1a038-f053-7bb5-8dcd-96fb9eac9214 | €9.00 | €0.19 | matched |
| 69 | refund | 01a1a039-17ff-726e-b783-196bd5349af8 | -€3.00 | €0.00 | matched |
| 70 | capture | 01a1a039-31c3-7c6b-aa00-dd16861f8e97 | €15.00 | €0.26 | matched |
| 71 | capture | 01a1a039-3d9d-713e-9d5f-1ec651bf4792 | €15.00 | €0.26 | matched |
| 72 | capture | 01a1a039-4f25-7e93-a5fe-6499a19fc894 | €35.00 | €0.50 | matched |
| 73 | capture | 01a1a039-51b6-736e-98ea-a7f03db59a66 | €24.00 | €0.37 | matched |
| 74 | capture | 01a1a039-5a90-7eb2-9d26-27b172611a3a | €24.00 | €0.37 | matched |
| 75 | capture | 01a1a039-7329-76f7-aacf-ec9d9f75a2ae | €35.00 | €0.50 | matched |
| 76 | capture | 01a1a039-92fd-747f-8ca2-18a854eb12ea | €24.00 | €0.37 | matched |
| 77 | capture | 01a1a039-e12c-75c3-84d9-b7be10e11514 | €24.00 | €0.37 | matched |
| 78 | capture | 01a1a039-e61c-7cf7-8327-f050e70720bf | €24.00 | €0.37 | matched |
| 79 | capture | 01a1a03a-03e3-749e-b742-b9d459bad9a0 | €49.00 | €0.67 | matched |
| 80 | capture | 01a1a03a-1fb9-7f08-b625-14683e6a557e | €35.00 | €0.50 | matched |
| 81 | refund | 01a1a03a-3a04-7f45-b222-edd19813bbc3 | -€23.00 | €0.00 | matched |
| 82 | capture | 01a1a03a-3c99-7482-9417-3ec5daf085ff | €35.00 | €0.50 | matched |
| 83 | capture | 01a1a03a-593f-7a07-9894-116a19340438 | €49.00 | €0.67 | matched |
| 84 | capture | 01a1a03a-6d21-7b68-bb16-01f848c07864 | €15.00 | €0.26 | matched |
| 85 | capture | 01a1a03a-8cce-7d6b-9af7-ea4f799e7128 | €24.00 | €0.37 | matched |
| 86 | capture | 01a1a03a-96fc-7d84-90d0-0e5b8dd3af92 | €35.00 | €0.50 | matched |
| 87 | capture | 01a1a03a-a5e5-78b2-91ce-05a0883d97af | €24.00 | €0.37 | matched |
| 88 | capture | 01a1a03a-b2c8-747d-9e29-4c4de47c49fe | €15.00 | €0.26 | matched |
| 89 | capture | 01a1a03a-b0ad-7c2b-ac76-47f9a1512b18 | €35.00 | €0.50 | matched |
| 90 | capture | 01a1a03a-f896-7b87-9c0d-a6c7edb69c19 | €35.00 | €0.50 | matched |
| 91 | refund | 01a1a03b-0e4c-7939-b2fe-5ac7166c2b5d | -€16.00 | €0.00 | matched |
| 93 | capture | 01a1a03b-2849-7a68-af0b-2b676e24a3c7 | €9.00 | €0.19 | matched |
| 94 | capture | 01a1a03b-30cf-72b6-ad08-f1eb6a4f70db | €24.00 | €0.37 | matched |
| 95 | capture | 01a1a03b-4941-7fbf-837b-ebab207a7079 | €35.00 | €0.50 | matched |
| 96 | capture | 01a1a03b-835f-797d-ac69-1e42446ce11a | €15.00 | €0.26 | matched |
| 97 | capture | 01a1a03b-89b0-7fb6-b32e-6c2aeae07c98 | €35.00 | €0.50 | matched |
| 98 | capture | 01a1a03b-c89c-709f-b31e-dfab886ac7fc | €9.00 | €0.19 | matched |
| 99 | capture | 01a1a03b-cb45-789e-bb72-ec080cf3dd04 | €49.00 | €0.67 | matched |
| 100 | capture | 01a1a03b-d1cb-77ec-9689-0a3ca1af0659 | €35.00 | €0.50 | matched |
| 101 | capture | 01a1a03b-f4ee-7574-9664-c2110d6a0ee4 | €49.00 | €0.67 | matched |
| 102 | capture | 01a1a03b-f787-7252-9eec-364fdb0d70e6 | €15.00 | €0.26 | matched |
| 103 | capture | 01a1a03c-01c4-7451-b930-c71cfac17a96 | €24.00 | €0.37 | matched |
| 104 | capture | 01a1a03c-0691-7a07-b8e2-afa6be49ec13 | €24.00 | €0.37 | matched |
| 105 | capture | 01a1a03c-1e2d-70be-a7db-b67a61cdb027 | €35.00 | €0.50 | matched |
| 106 | capture | 01a1a03c-26f7-75ee-89d8-aadc418fb5f1 | €9.00 | €0.19 | matched |
| 107 | capture | 01a1a03c-284c-7462-b55c-2deb9ae708c3 | €35.00 | €0.50 | matched |
| 108 | capture | 01a1a03c-451d-7ed3-815a-9b618cafeb60 | €49.00 | €0.67 | matched |
| 109 | capture | 01a1a03c-5435-7b28-8830-f01e6c5aaa46 | €15.00 | €0.26 | matched |
| 110 | capture | 01a1a03c-7ed2-7389-8074-fd777f89be7e | €35.00 | €0.50 | matched |
| 111 | capture | 01a1a03c-884e-7f0e-b214-b1c942cd755b | €49.00 | €0.67 | matched |
| 112 | capture | 01a1a03c-a21b-72ec-bf68-9cb31fd85a65 | €35.00 | €0.50 | matched |
| 113 | capture | 01a1a03c-a8e3-71a7-b0aa-35bf488c3f64 | €35.00 | €0.50 | matched |
| 114 | capture | 01a1a03c-ae35-7bc0-9bd6-33378f75800c | €49.00 | €0.67 | matched |
| 115 | capture | 01a1a03c-afae-71b3-9ce8-ec47867ad36f | €9.00 | €0.19 | matched |
| 116 | capture | 01a1a03c-b022-7119-86c0-7b33b264534d | €35.00 | €0.50 | matched |
| 117 | capture | 01a1a03c-c045-7043-87b5-cbba4082319a | €49.00 | €0.67 | matched |
| 118 | capture | 01a1a03c-d64d-7ce6-97fb-b93ba2cecc2c | €24.00 | €0.37 | matched |
| 119 | capture | 01a1a03c-db68-7667-b411-6605b78e883f | €24.00 | €0.37 | matched |
| 120 | capture | 01a1a03c-fddf-7471-862f-4e806911fd76 | €49.00 | €0.67 | matched |
| 121 | capture | 01a1a03c-ff1e-76b7-bbc2-4884e02daa24 | €15.00 | €0.26 | matched |
| 122 | refund | 01a1a03d-0b53-79df-b523-eba628dc277e | -€30.00 | €0.00 | matched |
| 123 | capture | 01a1a03d-284b-7808-86c3-54014304a7b3 | €15.00 | €0.26 | matched |
| 124 | capture | 01a1a03d-541a-74d8-a2c4-98c5b364a2b9 | €49.00 | €0.67 | matched |
| 125 | capture | 01a1a03d-862d-7a29-b595-4e84bfc65fd2 | €24.00 | €0.37 | matched |
| 126 | capture | 01a1a03d-9143-7fb7-b413-274633090b5c | €15.00 | €0.26 | matched |
| 127 | capture | 01a1a03d-95a1-73c7-9e64-f2005adb25f1 | €35.00 | €0.50 | matched |
| 128 | capture | 01a1a03d-afdf-745e-a57e-11b8edee8a64 | €35.00 | €0.50 | matched |
| 129 | capture | 01a1a03d-cd21-7638-9b91-06b8a3cf75e4 | €9.00 | €0.19 | matched |
| 130 | capture | 01a1a03d-cac5-7ff2-8f06-39db973898c5 | €24.00 | €0.37 | matched |
| 131 | capture | 01a1a03d-ce9e-749b-9933-68bd93f34bab | €49.00 | €0.67 | matched |
| 132 | capture | 01a1a03d-dbab-79ce-8d27-c0a141aea34e | €9.00 | €0.19 | matched |
| 133 | capture | 01a1a03d-dd69-7c09-8be3-08cb4cee2922 | €35.00 | €0.50 | matched |
| 134 | capture | 01a1a03d-f3cb-74db-bb4b-49e26aa31288 | €35.00 | €0.50 | matched |
| 135 | capture | 01a1a03e-0a6c-7e97-a691-ba6adc57b9a4 | €24.00 | €0.37 | matched |
| 136 | capture | 01a1a03e-1ae5-7119-9ed8-b3b0405df9a2 | €24.00 | €0.37 | matched |
| 137 | capture | 01a1a03e-359d-75ef-ac5e-a338533a3375 | €15.00 | €0.26 | matched |
| 138 | capture | 01a1a03e-35f7-7180-b04b-07ec1be6ac12 | €24.00 | €0.37 | matched |
| 139 | capture | 01a1a03e-4423-72cd-877c-f4819515f255 | €49.00 | €0.67 | matched |