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
- 16 Oct, 01:40114 lines1 break
- 16 Oct, 01:30128 lines3 breaks
- 16 Oct, 01:20132 lines2 breaks
- 16 Oct, 01:10114 lines2 breaks
- 16 Oct, 01:00146 lines6 breaks
- 16 Oct, 00:50129 lines3 breaks
- 16 Oct, 00:40141 lines4 breaks
- 16 Oct, 00:30133 lines3 breaks
- 16 Oct, 00:20123 lines5 breaks
- 16 Oct, 00:10120 lines3 breaks
- 16 Oct, 00:00134 lines1 break
- 15 Oct, 23:50138 linesclean
- 15 Oct, 23:40123 lines2 breaks
- 15 Oct, 23:30133 lines5 breaks
16 Oct, 00:20
Gross
€3,205.00
PSP fee
€48.90
Net to the bank
€3,156.10
Settlement journal
#23845
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14218-b32b-7c31-8006-a7a87dbdcab8 is already settled by stl_EUR_2986850 line 65
- duplicate linethe file lists it twicecapture:01a14218-fe86-7215-9d4c-018b6fbfc25a is already settled by stl_EUR_2986850 line 72
- fee differencethe fee is not the contract feethe fee is 31, the contract says 26
- missing linein the books, not in the filecapture:01a1421a-eb01-7588-abcd-aafbd2c135d2 is in no file
- missing linein the books, not in the filecapture:01a1421b-93a4-78c1-be48-856b753aff7f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 8 | capture | 01a14215-2f1b-76a9-866b-1a9ff39cc8bf | €15.00 | €0.31 | fee difference |
| 66 | capture | 01a14218-b342-74a9-9634-336dd8b94bd8 | €24.00 | €0.37 | duplicate line |
| 73 | capture | 01a14219-0f42-708d-8016-8c33ff34e4b9 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a14210-cba2-78a7-aff4-d8ec20942902 | €9.00 | €0.19 | matched |
| 2 | capture | 01a14212-4aa2-77cd-9860-12e4ee8d96ae | €35.00 | €0.50 | matched |
| 3 | capture | 01a14214-935d-70fd-a1bc-6cc81db7c022 | €9.00 | €0.19 | matched |
| 4 | capture | 01a14214-ffd7-7098-bf3e-373e87901965 | €49.00 | €0.67 | matched |
| 5 | capture | 01a14215-0427-767e-af3b-69d9f4fd01e0 | €35.00 | €0.50 | matched |
| 6 | capture | 01a14215-10ff-778f-81b7-888f3a562f33 | €35.00 | €0.50 | matched |
| 7 | capture | 01a14215-1c35-7089-86f4-f6b5176b19eb | €35.00 | €0.50 | matched |
| 9 | capture | 01a14215-363a-73f0-b96c-049979d2deff | €9.00 | €0.19 | matched |
| 10 | capture | 01a14215-39e1-77a5-bfb2-c85f02e61e75 | €9.00 | €0.19 | matched |
| 11 | capture | 01a14215-52e8-72d5-af0d-0884a852ef49 | €15.00 | €0.26 | matched |
| 12 | capture | 01a14215-55c5-75a6-af60-da8fcbf4a95e | €49.00 | €0.67 | matched |
| 13 | capture | 01a14215-6855-76d1-93f8-7a7a14cd27ad | €9.00 | €0.19 | matched |
| 14 | capture | 01a14215-7721-77a4-994e-8712170e1734 | €35.00 | €0.50 | matched |
| 15 | capture | 01a14215-92d8-7c2a-aa65-c8db992ac23d | €35.00 | €0.50 | matched |
| 16 | refund | 01a14215-9504-73e2-b4d6-60db06b305fa | -€6.00 | €0.00 | matched |
| 17 | capture | 01a14215-9726-7da9-bfc2-7eaad36c4d01 | €15.00 | €0.26 | matched |
| 18 | capture | 01a14215-bffe-7740-870e-ce20c1acaaaf | €24.00 | €0.37 | matched |
| 19 | capture | 01a14215-c259-7575-a687-30d064db669c | €9.00 | €0.19 | matched |
| 20 | capture | 01a14215-d55d-70c4-8986-453e5524d5b5 | €24.00 | €0.37 | matched |
| 21 | capture | 01a14215-dc37-77b4-a7ec-f96dc6cb83ff | €15.00 | €0.26 | matched |
| 22 | capture | 01a14215-e43d-7b42-bad4-5d67739d9015 | €35.00 | €0.50 | matched |
| 23 | capture | 01a14215-e975-7ebb-a8f4-6b68aef63577 | €15.00 | €0.26 | matched |
| 24 | capture | 01a14215-f679-75f8-a2bb-267de5183efc | €49.00 | €0.67 | matched |
| 25 | capture | 01a14215-f6ec-707c-a40d-3edb99009116 | €9.00 | €0.19 | matched |
| 26 | capture | 01a14215-f62d-77df-a27e-2550632f5569 | €49.00 | €0.67 | matched |
| 27 | capture | 01a14216-0787-7c3b-aec6-9eb579bb64ee | €49.00 | €0.67 | matched |
| 28 | capture | 01a14216-1381-7321-a4ab-0825e8bcf4f1 | €9.00 | €0.19 | matched |
| 29 | capture | 01a14216-1711-78e5-b691-6e0babbc3134 | €9.00 | €0.19 | matched |
| 30 | capture | 01a14216-19f9-72af-804b-e034498d0329 | €9.00 | €0.19 | matched |
| 31 | capture | 01a14216-373f-7fee-9eac-b304cad960fb | €49.00 | €0.67 | matched |
| 32 | capture | 01a14216-50a9-7f05-a1e2-aec5a7d4a492 | €9.00 | €0.19 | matched |
| 33 | refund | 01a14216-7bd7-736b-8152-0ec69d626ee3 | -€6.00 | €0.00 | matched |
| 34 | capture | 01a14216-817d-7815-b443-e0ad87a7bf64 | €9.00 | €0.19 | matched |
| 35 | capture | 01a14216-8467-7d03-8c79-818b076765cf | €9.00 | €0.19 | matched |
| 36 | capture | 01a14216-8a0a-7b8b-b74d-a8af959497f6 | €15.00 | €0.26 | matched |
| 37 | capture | 01a14216-a457-7948-a627-f788e3f44199 | €9.00 | €0.19 | matched |
| 38 | capture | 01a14216-ae37-753e-8c92-9ff5c9c1c7e0 | €9.00 | €0.19 | matched |
| 39 | capture | 01a14216-b1bd-79bd-b371-5a0de43dbf43 | €24.00 | €0.37 | matched |
| 40 | capture | 01a14216-b797-7f5b-a1b1-3174e1ce75c5 | €49.00 | €0.67 | matched |
| 41 | capture | 01a14216-c46d-79bd-81ad-94765fa587fd | €24.00 | €0.37 | matched |
| 42 | capture | 01a14216-f3ef-7d40-a0d5-c902d670fec6 | €49.00 | €0.67 | matched |
| 43 | capture | 01a14217-155c-7835-b0d1-78fe385c9bbf | €35.00 | €0.50 | matched |
| 44 | capture | 01a14217-1bc5-7d2a-a487-78d28e20f1f7 | €24.00 | €0.37 | matched |
| 45 | capture | 01a14217-2517-7eee-be1e-80fbf6f3cff5 | €15.00 | €0.26 | matched |
| 46 | capture | 01a14217-2ab6-7175-8f2b-2605cb20aa2c | €49.00 | €0.67 | matched |
| 47 | capture | 01a14217-3fd7-7503-9826-bfe575c2ab41 | €49.00 | €0.67 | matched |
| 48 | capture | 01a14217-40b8-78ba-98bd-462e38b8a742 | €24.00 | €0.37 | matched |
| 49 | capture | 01a14217-4505-71a4-992a-fcc8032002a1 | €24.00 | €0.37 | matched |
| 50 | capture | 01a14217-50fc-7311-a6ac-5946a312363f | €35.00 | €0.50 | matched |
| 51 | refund | 01a14217-899f-74f0-a40f-84a4b29fe724 | -€12.00 | €0.00 | matched |
| 52 | capture | 01a14217-9f7e-7a95-9fee-213d568f4bc3 | €15.00 | €0.26 | matched |
| 53 | capture | 01a14217-a2f6-7998-a05e-e458d4da9607 | €49.00 | €0.67 | matched |
| 54 | capture | 01a14217-ac06-7f68-8346-d83e9c3c3b46 | €15.00 | €0.26 | matched |
| 55 | capture | 01a14217-b82e-7b52-bc35-755864975618 | €49.00 | €0.67 | matched |
| 56 | capture | 01a14217-d4ab-7957-8037-da828a9406ef | €15.00 | €0.26 | matched |
| 57 | capture | 01a14217-e72e-7b6b-8823-a53492054e55 | €15.00 | €0.26 | matched |
| 58 | capture | 01a14218-027b-703c-912f-6bff02c8e70b | €24.00 | €0.37 | matched |
| 59 | capture | 01a14218-1ff1-7bda-a401-47797cef11c9 | €15.00 | €0.26 | matched |
| 60 | capture | 01a14218-228c-7c5a-ac1e-b10c3f2e0c5a | €35.00 | €0.50 | matched |
| 61 | capture | 01a14218-24ef-733e-9b16-46e0b2ff4dd0 | €49.00 | €0.67 | matched |
| 62 | capture | 01a14218-47e0-7ddd-9535-0c6e815f7303 | €49.00 | €0.67 | matched |
| 63 | refund | 01a14218-60f2-759c-85eb-8dad217bd195 | -€34.00 | €0.00 | matched |
| 64 | capture | 01a14218-a8fe-752d-95c3-7ae4817218b8 | €49.00 | €0.67 | matched |
| 65 | capture | 01a14218-b342-74a9-9634-336dd8b94bd8 | €24.00 | €0.37 | matched |
| 67 | capture | 01a14218-d6b6-7011-8095-ecdb443f15dd | €9.00 | €0.19 | matched |
| 68 | capture | 01a14218-ec8c-708b-b724-d5bf1fa516f0 | €9.00 | €0.19 | matched |
| 69 | capture | 01a14218-eec2-759c-b517-ad84b04469bc | €24.00 | €0.37 | matched |
| 70 | capture | 01a14218-f03d-7ed3-9e79-0d6c426d0d4f | €49.00 | €0.67 | matched |
| 71 | capture | 01a14219-0ded-78a5-b781-53f0151c7a1b | €24.00 | €0.37 | matched |
| 72 | capture | 01a14219-0f42-708d-8016-8c33ff34e4b9 | €49.00 | €0.67 | matched |
| 74 | capture | 01a14219-2503-741e-bd43-3629af5ad8ce | €24.00 | €0.37 | matched |
| 75 | capture | 01a14219-4e31-785f-83d8-6f11a1b3f3b0 | €49.00 | €0.67 | matched |
| 76 | capture | 01a14219-634c-76db-bf9b-1a3227bf5c9f | €9.00 | €0.19 | matched |
| 77 | capture | 01a14219-bebe-754f-8bc8-476f01f61cf3 | €49.00 | €0.67 | matched |
| 78 | capture | 01a14219-fd06-7937-9569-09046dd8890a | €49.00 | €0.67 | matched |
| 79 | capture | 01a1421a-4c9e-7154-9e21-d33cc1c317b2 | €35.00 | €0.50 | matched |
| 80 | capture | 01a1421a-767f-74a0-9029-1273b9544d42 | €35.00 | €0.50 | matched |
| 81 | capture | 01a1421a-826c-751e-9b17-a503dcddddd3 | €9.00 | €0.19 | matched |
| 82 | capture | 01a1421a-86e2-79d7-87b4-98d4ce28e0cd | €24.00 | €0.37 | matched |
| 83 | capture | 01a1421a-a779-73b7-81d4-7f9a12f45a75 | €24.00 | €0.37 | matched |
| 84 | capture | 01a1421a-a98e-7193-972b-2355c0b797c4 | €49.00 | €0.67 | matched |
| 85 | capture | 01a1421a-e23e-7967-9e26-1c4daa8c56a8 | €24.00 | €0.37 | matched |
| 86 | refund | 01a1421a-f4c8-7161-ad16-8756aa709927 | -€8.00 | €0.00 | matched |
| 87 | capture | 01a1421a-fd56-7721-b6d4-1a47c4fcdb6e | €15.00 | €0.26 | matched |
| 88 | capture | 01a1421a-ff00-756d-ac01-a297dfb62098 | €49.00 | €0.67 | matched |
| 89 | capture | 01a1421a-f826-739b-924e-a109b9d81d80 | €9.00 | €0.19 | matched |
| 90 | capture | 01a1421b-0456-7bab-9fb9-71676465a88e | €15.00 | €0.26 | matched |
| 91 | capture | 01a1421b-4641-75bb-aa80-ee71e7a1ffdb | €49.00 | €0.67 | matched |
| 92 | capture | 01a1421b-4c1e-7b38-a439-8040235993f5 | €35.00 | €0.50 | matched |
| 93 | capture | 01a1421b-5098-7dd5-a549-48799bd224e0 | €49.00 | €0.67 | matched |
| 94 | capture | 01a1421b-62ba-740a-a3b1-e8c04887db0d | €9.00 | €0.19 | matched |
| 95 | capture | 01a1421b-6624-7bb6-a9c2-630303919529 | €49.00 | €0.67 | matched |
| 96 | capture | 01a1421b-6bad-7f2b-b5e4-7cf87f593c14 | €35.00 | €0.50 | matched |
| 97 | capture | 01a1421b-7421-76c1-a06c-82029d2b4d28 | €35.00 | €0.50 | matched |
| 98 | capture | 01a1421b-89b2-7dfa-9369-607198e2589c | €35.00 | €0.50 | matched |
| 99 | capture | 01a1421b-de4b-70a6-9393-b2e486d53136 | €49.00 | €0.67 | matched |
| 100 | capture | 01a1421b-e4c3-7e8b-90de-6a750ba2ddd1 | €9.00 | €0.19 | matched |
| 101 | capture | 01a1421c-22d0-7641-8957-a3a95e737aa3 | €35.00 | €0.50 | matched |
| 102 | capture | 01a1421c-2438-74e2-9721-f1a264aab7a4 | €24.00 | €0.37 | matched |
| 103 | capture | 01a1421c-2fab-72fe-a371-d047634f5da5 | €35.00 | €0.50 | matched |
| 104 | capture | 01a1421c-316e-7913-a98a-1ac7483728ea | €35.00 | €0.50 | matched |
| 105 | capture | 01a1421c-60e8-7c1a-93c9-70403e588d48 | €24.00 | €0.37 | matched |
| 106 | capture | 01a1421c-74e8-79c0-8a10-913f88e00b08 | €24.00 | €0.37 | matched |
| 107 | capture | 01a1421c-84f8-71d6-ab19-c0ae10c230b1 | €24.00 | €0.37 | matched |
| 108 | capture | 01a1421c-993e-7e70-a7e4-355537e93216 | €24.00 | €0.37 | matched |
| 109 | capture | 01a1421c-c1ec-7eff-9c3c-329ecbf83fba | €49.00 | €0.67 | matched |
| 110 | capture | 01a1421c-c571-766e-a5e9-95b763809a18 | €9.00 | €0.19 | matched |
| 111 | capture | 01a1421c-c75c-7023-8901-d60b1629296d | €24.00 | €0.37 | matched |
| 112 | capture | 01a1421c-c7b8-7f71-82d6-149d02f8e8fc | €35.00 | €0.50 | matched |
| 113 | capture | 01a1421c-ce96-727e-8a15-a231d56df2f4 | €15.00 | €0.26 | matched |
| 114 | capture | 01a1421c-d81a-70d6-8f56-c843f7b48ced | €24.00 | €0.37 | matched |
| 115 | capture | 01a1421c-e1aa-7873-a25b-6c82b8aa3b50 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1421d-1727-7ed5-97f3-d3292ec3c2da | €24.00 | €0.37 | matched |
| 117 | capture | 01a1421d-3bbd-76be-bfaa-eaba35ad4319 | €9.00 | €0.19 | matched |
| 118 | capture | 01a1421d-45de-7d44-9f6a-c8f895417ee0 | €35.00 | €0.50 | matched |
| 119 | capture | 01a1421d-846b-735c-8003-897c1a63de9b | €24.00 | €0.37 | matched |
| 120 | capture | 01a1421d-8ae2-7e32-b9c9-0027eee0ca77 | €15.00 | €0.26 | matched |
| 121 | capture | 01a1421d-98a3-7ce6-ae45-30717d164f27 | €9.00 | €0.19 | matched |
| 122 | capture | 01a1421d-9afb-7963-814b-2df276624533 | €15.00 | €0.26 | matched |
| 123 | capture | 01a1421d-9b3f-7360-99ad-c55e852fa6c0 | €49.00 | €0.67 | matched |