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, 14:50106 lines1 break
- 23 Oct, 14:40118 lines2 breaks
- 23 Oct, 14:30116 lines1 break
- 23 Oct, 14:20113 lines2 breaks
- 23 Oct, 14:10137 lines2 breaks
- 23 Oct, 14:00117 lines1 break
- 23 Oct, 13:50133 lines4 breaks
- 23 Oct, 13:40130 lines1 break
- 23 Oct, 13:30131 lines3 breaks
- 23 Oct, 13:20110 lines2 breaks
- 23 Oct, 13:10137 lines5 breaks
- 23 Oct, 13:00132 lines6 breaks
- 23 Oct, 12:50131 lines2 breaks
- 23 Oct, 12:40123 lines3 breaks
23 Oct, 14:40
Gross
€2,884.00
PSP fee
€45.11
Net to the bank
€2,838.89
Settlement journal
#161778
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a16935-e543-7853-b203-cbc48b35e4c9 is already settled by stl_EUR_2987944 line 21
- missing linein the books, not in the filecapture:01a16938-c573-7bf2-b388-fea45396456b is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 22 | capture | 01a16935-e573-786a-9674-9141323c1bf3 | €49.00 | €0.67 | duplicate line |
| 1 | refund | 01a16934-8c6e-7ec5-8511-77f182d97b27 | -€17.00 | €0.00 | matched |
| 2 | capture | 01a16934-a826-7a15-b657-7be33702a8e3 | €24.00 | €0.37 | matched |
| 3 | capture | 01a16934-bd09-7686-b8ab-f5b816865dfb | €24.00 | €0.37 | matched |
| 4 | capture | 01a16934-bf3c-76f7-be85-e7dddd059550 | €24.00 | €0.37 | matched |
| 5 | capture | 01a16934-d12f-7977-abd8-d74922aba266 | €9.00 | €0.19 | matched |
| 6 | capture | 01a16934-e3d3-70bb-a396-e097547f39e0 | €24.00 | €0.37 | matched |
| 7 | capture | 01a16934-f683-7e3e-8111-b070621e7dcc | €9.00 | €0.19 | matched |
| 8 | capture | 01a16934-fc6f-7847-8aa4-7b4ef4c8e3a7 | €24.00 | €0.37 | matched |
| 9 | capture | 01a16935-1271-729b-aea9-92b917682c4e | €49.00 | €0.67 | matched |
| 10 | capture | 01a16935-1f2b-7e16-bb8e-bb2750828270 | €15.00 | €0.26 | matched |
| 11 | capture | 01a16935-39e5-7f7e-9dce-1dfb05f9671c | €35.00 | €0.50 | matched |
| 12 | capture | 01a16935-3ffe-79db-9a50-43dc29ea6a15 | €49.00 | €0.67 | matched |
| 13 | capture | 01a16935-49c2-7e53-8049-d136cb3a324c | €9.00 | €0.19 | matched |
| 14 | capture | 01a16935-50f3-72f7-ad39-290fc3e84863 | €9.00 | €0.19 | matched |
| 15 | capture | 01a16935-7e8f-7ffc-bad5-1296d6ae417d | €15.00 | €0.26 | matched |
| 16 | capture | 01a16935-7470-7570-ae29-6aa92537770b | €9.00 | €0.19 | matched |
| 17 | capture | 01a16935-90f1-74ea-b933-b781beb5d2e9 | €9.00 | €0.19 | matched |
| 18 | capture | 01a16935-96d9-76e2-8587-837a2c61c576 | €9.00 | €0.19 | matched |
| 19 | capture | 01a16935-98d2-79cd-987e-0561f506259b | €35.00 | €0.50 | matched |
| 20 | capture | 01a16935-9ebe-7bd4-a3c3-ac4a054fe400 | €15.00 | €0.26 | matched |
| 21 | capture | 01a16935-e573-786a-9674-9141323c1bf3 | €49.00 | €0.67 | matched |
| 23 | capture | 01a16936-2adc-70e4-b06d-42138f752a05 | €35.00 | €0.50 | matched |
| 24 | capture | 01a16936-4278-77a3-8822-d41e6c55607d | €24.00 | €0.37 | matched |
| 25 | capture | 01a16936-64ec-7c04-b385-39e185d2e90e | €9.00 | €0.19 | matched |
| 26 | capture | 01a16936-7474-7106-a2ec-0425d379f798 | €15.00 | €0.26 | matched |
| 27 | capture | 01a16936-82b7-7abb-b0aa-c8d1788ee0a6 | €9.00 | €0.19 | matched |
| 28 | capture | 01a16936-8c4a-7e84-984d-b6773558559f | €49.00 | €0.67 | matched |
| 29 | capture | 01a16936-9df4-73bd-8bab-7c5434270639 | €49.00 | €0.67 | matched |
| 30 | capture | 01a16936-c742-7438-a92f-0b45d34561c7 | €15.00 | €0.26 | matched |
| 31 | refund | 01a16937-04c7-7bd7-91ab-9ee7bd866d68 | -€44.00 | €0.00 | matched |
| 32 | capture | 01a16937-11e0-7e12-8909-d40158ebaa54 | €35.00 | €0.50 | matched |
| 33 | capture | 01a16937-1d36-70d2-b0f8-f6619b9a567d | €15.00 | €0.26 | matched |
| 34 | capture | 01a16937-3fbd-73e2-b7fe-b2f8b186e5f0 | €35.00 | €0.50 | matched |
| 35 | capture | 01a16937-9b04-71ad-ad60-9bdeba731b87 | €35.00 | €0.50 | matched |
| 36 | capture | 01a16937-a6db-7d81-8d94-d8e02b3214ec | €9.00 | €0.19 | matched |
| 37 | capture | 01a16937-eb54-7298-ba88-4a7a17cfbcf2 | €35.00 | €0.50 | matched |
| 38 | capture | 01a16937-f53d-7516-85e6-bab93ae54438 | €24.00 | €0.37 | matched |
| 39 | capture | 01a16938-0b67-7180-8f19-6bbae89cb854 | €9.00 | €0.19 | matched |
| 40 | capture | 01a16938-134f-7f22-ade3-6d2d772c08d5 | €24.00 | €0.37 | matched |
| 41 | capture | 01a16938-1aaa-7487-b045-3b2138ced6b1 | €24.00 | €0.37 | matched |
| 42 | capture | 01a16938-34f2-792a-a146-32dedc561f16 | €35.00 | €0.50 | matched |
| 43 | capture | 01a16938-455d-777e-9daf-028917f77ab4 | €9.00 | €0.19 | matched |
| 44 | capture | 01a16938-4ed9-7037-8384-72f83be8d366 | €9.00 | €0.19 | matched |
| 45 | capture | 01a16938-7331-7f63-8146-46007fc07d69 | €35.00 | €0.50 | matched |
| 46 | capture | 01a16938-7d53-757c-bce5-5c93e4947e9f | €24.00 | €0.37 | matched |
| 47 | capture | 01a16938-964d-703e-a644-979d26490f30 | €49.00 | €0.67 | matched |
| 48 | capture | 01a16938-a272-7585-8901-8af3b6463020 | €9.00 | €0.19 | matched |
| 49 | capture | 01a16938-bdd3-7d7a-8c5f-258eb670a4e5 | €49.00 | €0.67 | matched |
| 50 | capture | 01a16938-c100-717e-8612-1221a28f7789 | €49.00 | €0.67 | matched |
| 51 | capture | 01a16938-c120-7e9d-8433-941e0596a9ef | €35.00 | €0.50 | matched |
| 52 | refund | 01a16938-d338-76a0-b8be-5e3a81ac110f | -€16.00 | €0.00 | matched |
| 53 | capture | 01a16938-dca3-7f33-bdd1-08ce11a0bd94 | €35.00 | €0.50 | matched |
| 54 | capture | 01a16938-de31-731a-a222-0f0ca15c9010 | €35.00 | €0.50 | matched |
| 55 | capture | 01a16938-e568-7d54-a500-eaa30f06c85b | €35.00 | €0.50 | matched |
| 56 | capture | 01a16938-fd9f-701e-8f89-3c799554b464 | €9.00 | €0.19 | matched |
| 57 | capture | 01a16939-1b78-7767-9df7-9d94f55e47db | €15.00 | €0.26 | matched |
| 58 | capture | 01a16939-2ba6-7682-9d0c-426e26bbcfe2 | €24.00 | €0.37 | matched |
| 59 | capture | 01a16939-2d61-7dc8-a7c7-5947cf798c22 | €9.00 | €0.19 | matched |
| 60 | capture | 01a16939-4c75-7068-87a3-6af7967ba0ea | €24.00 | €0.37 | matched |
| 61 | capture | 01a16939-5f57-76a0-bf52-a16ccd141de3 | €24.00 | €0.37 | matched |
| 62 | capture | 01a16939-78ae-75da-b876-5ba959606520 | €24.00 | €0.37 | matched |
| 63 | capture | 01a16939-bfd3-7792-a4a7-962fb1dd759f | €49.00 | €0.67 | matched |
| 64 | capture | 01a16939-cafe-7839-bc95-f22b9227c1af | €9.00 | €0.19 | matched |
| 65 | capture | 01a16939-de54-7d7b-9e9e-ad981f579196 | €35.00 | €0.50 | matched |
| 66 | capture | 01a16939-e452-7c10-8108-d5124718c264 | €15.00 | €0.26 | matched |
| 67 | capture | 01a16939-e92d-7b27-a499-49002eddc5a0 | €15.00 | €0.26 | matched |
| 68 | capture | 01a16939-f686-7f08-b06d-8ab1a150711f | €15.00 | €0.26 | matched |
| 69 | capture | 01a1693a-06ce-7de1-b8c0-20c197b1a143 | €35.00 | €0.50 | matched |
| 70 | capture | 01a1693a-07e3-7e0c-ab0c-652aa18f95f5 | €49.00 | €0.67 | matched |
| 71 | capture | 01a1693a-2269-7f36-b483-3dbb8732c8fd | €35.00 | €0.50 | matched |
| 72 | capture | 01a1693a-35e6-7744-b0a7-fcabc4186ee5 | €15.00 | €0.26 | matched |
| 73 | capture | 01a1693a-3851-76a2-9e30-e5da9a137e0e | €24.00 | €0.37 | matched |
| 74 | refund | 01a1693a-4626-7fb7-b62c-23276298e00e | -€29.00 | €0.00 | matched |
| 75 | capture | 01a1693a-7090-72bb-a0b7-a7478d43a437 | €9.00 | €0.19 | matched |
| 76 | capture | 01a1693a-70da-7bc0-8ce3-b7e1c841eee5 | €35.00 | €0.50 | matched |
| 77 | capture | 01a1693a-76dd-757b-8368-aed0a617b4b0 | €49.00 | €0.67 | matched |
| 78 | refund | 01a1693a-83d6-7d0c-9c0f-43afca1122cf | -€4.00 | €0.00 | matched |
| 79 | capture | 01a1693a-90b8-74a6-b2d3-42c7ec5f880b | €49.00 | €0.67 | matched |
| 80 | capture | 01a1693a-9297-7c96-95ba-ec787d7702f0 | €49.00 | €0.67 | matched |
| 81 | capture | 01a1693a-92c1-7f98-be6e-f2827c31568b | €35.00 | €0.50 | matched |
| 82 | capture | 01a1693a-9b44-7602-acbb-21dba419737e | €35.00 | €0.50 | matched |
| 83 | capture | 01a1693a-9cf6-73ec-90ec-1a6c4e547abd | €9.00 | €0.19 | matched |
| 84 | capture | 01a1693a-b4a2-747a-9f11-02ff897a5bea | €15.00 | €0.26 | matched |
| 85 | capture | 01a1693a-d604-7861-be1a-642a9c456f0c | €9.00 | €0.19 | matched |
| 86 | capture | 01a1693a-e986-7752-8f0a-b49f392753d4 | €9.00 | €0.19 | matched |
| 87 | capture | 01a1693b-109e-734c-8a8a-d9a348a2cf79 | €49.00 | €0.67 | matched |
| 88 | capture | 01a1693b-29f7-7f27-a2a4-d56a3a7593e2 | €24.00 | €0.37 | matched |
| 89 | capture | 01a1693b-2f4e-7eb1-9c64-778eac15af64 | €35.00 | €0.50 | matched |
| 90 | capture | 01a1693b-32cf-7823-8be9-485402a3bc6d | €9.00 | €0.19 | matched |
| 91 | capture | 01a1693b-719b-7f8b-9054-6b3fc04ae398 | €9.00 | €0.19 | matched |
| 92 | capture | 01a1693b-766a-7d6c-8601-4fbdc42a24b9 | €15.00 | €0.26 | matched |
| 93 | capture | 01a1693b-77c0-7681-a831-18297f90329b | €15.00 | €0.26 | matched |
| 94 | capture | 01a1693b-cecc-70da-bc9e-8535684d2477 | €24.00 | €0.37 | matched |
| 95 | capture | 01a1693b-e14a-7d59-9237-fd5e1bc65f55 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1693b-e822-7622-bce3-fe5b5f219dae | €24.00 | €0.37 | matched |
| 97 | capture | 01a1693c-1c24-7ec5-b596-288404b1df71 | €9.00 | €0.19 | matched |
| 98 | capture | 01a1693c-277a-747d-bab9-eacec33c23c3 | €24.00 | €0.37 | matched |
| 99 | capture | 01a1693c-324c-7b46-a24c-37d531668cc4 | €35.00 | €0.50 | matched |
| 100 | capture | 01a1693c-36c5-7ca4-b8ff-f2b313eb1ea9 | €15.00 | €0.26 | matched |
| 101 | capture | 01a1693c-3ba7-76f2-813d-d1e5ddea5ef3 | €49.00 | €0.67 | matched |
| 102 | capture | 01a1693c-503e-7753-ae54-72a88b5b9272 | €24.00 | €0.37 | matched |
| 103 | capture | 01a1693c-5355-738a-82cd-c99a3dbb78e7 | €35.00 | €0.50 | matched |
| 104 | capture | 01a1693c-5e5c-75b7-a9f0-0694956390ba | €35.00 | €0.50 | matched |
| 105 | capture | 01a1693c-72ef-7ab8-a7c5-e0a5cce38ae1 | €49.00 | €0.67 | matched |
| 106 | capture | 01a1693c-7608-7026-9ee5-6e8b39c68023 | €24.00 | €0.37 | matched |
| 107 | capture | 01a1693c-7e6c-722e-8a3c-1277d4658a6b | €49.00 | €0.67 | matched |
| 108 | capture | 01a1693c-9f80-72ce-b787-bdedd1189542 | €15.00 | €0.26 | matched |
| 109 | capture | 01a1693c-bd65-7a99-a77c-d079545eb44d | €35.00 | €0.50 | matched |
| 110 | capture | 01a1693c-f18e-73ec-968d-f18a888107d9 | €49.00 | €0.67 | matched |
| 111 | capture | 01a1693d-0562-7006-b32b-cd44a69ee7f5 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1693d-13dd-7a85-8cc5-165a11abe981 | €49.00 | €0.67 | matched |
| 113 | capture | 01a1693d-1663-7043-b358-837c396734f2 | €9.00 | €0.19 | matched |
| 114 | capture | 01a1693d-2167-79c5-b0d8-4a6463bf4ed2 | €49.00 | €0.67 | matched |
| 115 | capture | 01a1693d-224d-7d83-8360-da327c27a231 | €24.00 | €0.37 | matched |
| 116 | capture | 01a1693d-4197-7fad-b167-31934c3e51e9 | €35.00 | €0.50 | matched |
| 117 | capture | 01a1693d-570e-7e01-9a87-cb8b551444fd | €9.00 | €0.19 | matched |
| 118 | capture | 01a1693d-5814-75ed-abb8-727e5393831b | €49.00 | €0.67 | matched |