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
- 15 Oct, 20:30142 lines1 break
- 15 Oct, 20:20134 lines3 breaks
- 15 Oct, 20:10122 lines5 breaks
- 15 Oct, 20:00119 lines1 break
- 15 Oct, 19:50129 lines1 break
- 15 Oct, 19:40120 lines2 breaks
- 15 Oct, 19:30140 lines1 break
- 15 Oct, 19:20141 lines3 breaks
- 15 Oct, 19:10133 lines3 breaks
- 15 Oct, 19:00111 lines3 breaks
- 15 Oct, 18:50121 lines2 breaks
- 15 Oct, 18:40127 lines3 breaks
- 15 Oct, 18:30122 linesclean
- 15 Oct, 18:20115 lines4 breaks
15 Oct, 19:30
Gross
€2,990.00
PSP fee
€49.10
Net to the bank
€2,940.90
Settlement journal
#20086
Breaks for a person to look at
- missing linein the books, not in the filerefund:01a14111-04fe-70cc-a6b2-01556bcd8f18 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 2 | capture | 01a14104-ff21-7af6-a349-5f5b6d1c9214 | €9.00 | €0.20 | fee difference |
| 1 | capture | 01a14101-fc26-74a1-9c96-2822e0cde97c | €35.00 | €0.50 | matched |
| 3 | capture | 01a14106-73d5-7739-ba07-1fe779b70b4e | €24.00 | €0.37 | matched |
| 4 | capture | 01a14108-aeb9-7849-b323-cd8509810d95 | €24.00 | €0.37 | matched |
| 5 | capture | 01a14109-e707-7216-8348-14e51ef491ba | €24.00 | €0.37 | matched |
| 6 | capture | 01a1410a-e114-7610-880d-3c8b2de79f69 | €24.00 | €0.37 | matched |
| 7 | capture | 01a1410b-1d94-7b44-b139-dae68d981713 | €49.00 | €0.67 | matched |
| 8 | capture | 01a1410b-3114-75d3-8f1f-de992300def5 | €49.00 | €0.67 | matched |
| 9 | capture | 01a1410b-5d8b-7ccc-9c6f-dd8d7828f049 | €9.00 | €0.19 | matched |
| 10 | capture | 01a1410b-6c6b-7882-a37b-39092c5af377 | €9.00 | €0.19 | matched |
| 11 | capture | 01a1410b-7104-7d9b-8e32-46b76ff140d9 | €15.00 | €0.26 | matched |
| 12 | capture | 01a1410b-94ed-7174-9fe1-71b79b820d9e | €9.00 | €0.19 | matched |
| 13 | capture | 01a1410b-a081-7067-a18d-ab4dbeaaaa24 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1410b-abf6-7921-82f3-3d66c6646545 | €24.00 | €0.37 | matched |
| 15 | capture | 01a1410b-ce7d-7ebf-bba9-20ae03270c1c | €35.00 | €0.50 | matched |
| 16 | capture | 01a1410b-dfa1-786a-a8a4-7a65b6836386 | €9.00 | €0.19 | matched |
| 17 | capture | 01a1410c-13af-74fe-af26-04ae2b735e94 | €9.00 | €0.19 | matched |
| 18 | capture | 01a1410c-2e45-72d6-9326-7acc7d209129 | €49.00 | €0.67 | matched |
| 19 | capture | 01a1410c-37ea-7c95-959c-fb000eddec5b | €24.00 | €0.37 | matched |
| 20 | capture | 01a1410c-4a6a-75ca-8bef-b8b6490279ca | €35.00 | €0.50 | matched |
| 21 | capture | 01a1410c-4fed-78d0-9205-1588bac6d7ab | €35.00 | €0.50 | matched |
| 22 | capture | 01a1410c-5172-717c-87ed-eec33222c073 | €35.00 | €0.50 | matched |
| 23 | capture | 01a1410c-70e9-7324-be51-a69e7ae93f6e | €9.00 | €0.19 | matched |
| 24 | capture | 01a1410c-75d4-7f51-adfb-5d3a5fc375ec | €49.00 | €0.67 | matched |
| 25 | capture | 01a1410c-7d7b-70a2-87dd-5c232afba642 | €9.00 | €0.19 | matched |
| 26 | refund | 01a1410c-d885-7dcd-996b-ebf4ecbd2052 | -€20.00 | €0.00 | matched |
| 27 | capture | 01a1410c-eb4f-73d6-87f7-87d9bc6600ac | €15.00 | €0.26 | matched |
| 28 | capture | 01a1410c-f952-734a-bb2f-1352a141672c | €24.00 | €0.37 | matched |
| 29 | capture | 01a1410c-fcb5-7e82-b7e8-f8cedf035536 | €24.00 | €0.37 | matched |
| 30 | capture | 01a1410d-1b48-72e7-8441-30b1c5ac092c | €49.00 | €0.67 | matched |
| 31 | capture | 01a1410d-3c22-7c56-adbc-a97dc15cc998 | €35.00 | €0.50 | matched |
| 32 | capture | 01a1410d-5f51-774a-bcad-fd616ef302f3 | €15.00 | €0.26 | matched |
| 33 | capture | 01a1410d-6b84-74de-b832-4e6fea392be9 | €9.00 | €0.19 | matched |
| 34 | capture | 01a1410d-70bf-71bd-ad13-1f9ad275de8d | €24.00 | €0.37 | matched |
| 35 | capture | 01a1410d-7ece-71b2-b249-e503e459ce6f | €35.00 | €0.50 | matched |
| 36 | capture | 01a1410d-878e-7785-9502-be5c472c5d79 | €9.00 | €0.19 | matched |
| 37 | capture | 01a1410d-94d3-7633-b586-d2b14e6a0303 | €49.00 | €0.67 | matched |
| 38 | capture | 01a1410d-9c9b-7665-87f9-72916507ce31 | €9.00 | €0.19 | matched |
| 39 | capture | 01a1410d-add0-7187-9abc-39bd89d5e676 | €9.00 | €0.19 | matched |
| 40 | capture | 01a1410d-c537-73db-b125-c2be3fd3d551 | €15.00 | €0.26 | matched |
| 41 | capture | 01a1410d-cc65-7fc4-a696-a8d8923ca021 | €15.00 | €0.26 | matched |
| 42 | capture | 01a1410d-e43e-7289-8f8c-0fdfa63c67db | €49.00 | €0.67 | matched |
| 43 | capture | 01a1410e-03f9-73f3-bab1-f02ba6cf9eca | €35.00 | €0.50 | matched |
| 44 | capture | 01a1410e-1dea-7168-bdc8-f690f182008d | €9.00 | €0.19 | matched |
| 45 | capture | 01a1410e-4fed-7eea-9ee9-af6953dae3bc | €24.00 | €0.37 | matched |
| 46 | capture | 01a1410e-5967-74d3-940c-0eba00b57329 | €49.00 | €0.67 | matched |
| 47 | capture | 01a1410e-89b9-71bd-8b96-c56cd3031a92 | €15.00 | €0.26 | matched |
| 48 | capture | 01a1410e-8f4f-73ee-a7a7-e8f49eb8b009 | €15.00 | €0.26 | matched |
| 49 | capture | 01a1410e-9cd4-7104-9867-1a5a9e554b72 | €24.00 | €0.37 | matched |
| 50 | refund | 01a1410e-a5f4-7f95-9b6a-63de27b06687 | -€33.00 | €0.00 | matched |
| 51 | capture | 01a1410e-a7c9-78e0-9e90-42c170ed1cb0 | €24.00 | €0.37 | matched |
| 52 | capture | 01a1410e-afcf-7378-87ad-947610d43ed9 | €49.00 | €0.67 | matched |
| 53 | refund | 01a1410e-b074-7c33-bfcc-710de23d8037 | -€13.00 | €0.00 | matched |
| 54 | capture | 01a1410e-b59d-7102-a53f-8672a2c370db | €49.00 | €0.67 | matched |
| 55 | capture | 01a1410e-bbb4-749a-9da9-88f83aa12e4d | €9.00 | €0.19 | matched |
| 56 | capture | 01a1410e-c5dc-7534-94b8-89c4269c15db | €49.00 | €0.67 | matched |
| 57 | capture | 01a1410e-ec40-7326-9438-995f777f755c | €24.00 | €0.37 | matched |
| 58 | capture | 01a1410e-f43a-7c6d-8fbc-f39280a82b4b | €9.00 | €0.19 | matched |
| 59 | capture | 01a1410e-f8b1-7522-b3b4-f1395053db8a | €15.00 | €0.26 | matched |
| 60 | capture | 01a1410e-fbd5-77ff-a288-5a7d36b93e1b | €15.00 | €0.26 | matched |
| 61 | capture | 01a1410f-077f-7a7f-b20d-343faf0092d2 | €49.00 | €0.67 | matched |
| 62 | capture | 01a1410f-0924-7553-9e60-2218018922a5 | €24.00 | €0.37 | matched |
| 63 | refund | 01a1410f-12c8-75b7-8a67-58f2758ec32b | -€4.00 | €0.00 | matched |
| 64 | refund | 01a1410f-185d-73c7-a411-0ad076b4ae1f | -€45.00 | €0.00 | matched |
| 65 | capture | 01a1410f-18b2-7527-80be-eb1e67fbf407 | €35.00 | €0.50 | matched |
| 66 | refund | 01a1410f-3899-7554-b16d-9eddcab52175 | -€21.00 | €0.00 | matched |
| 67 | capture | 01a1410f-3919-7799-b3b2-2d38c6816de4 | €49.00 | €0.67 | matched |
| 68 | refund | 01a1410f-4ad9-7e20-bd5c-ca49651d3c21 | -€14.00 | €0.00 | matched |
| 69 | refund | 01a1410f-6200-7717-ac41-96b2323aaeb2 | -€21.00 | €0.00 | matched |
| 70 | capture | 01a1410f-6f24-7997-bc39-df78787626d0 | €9.00 | €0.19 | matched |
| 71 | capture | 01a1410f-872b-7c63-bb66-fee14658b06a | €35.00 | €0.50 | matched |
| 72 | capture | 01a1410f-ad90-73c4-bd63-ab71bb14b38c | €35.00 | €0.50 | matched |
| 73 | capture | 01a1410f-b896-7ed1-926f-215d4d1ed34c | €24.00 | €0.37 | matched |
| 74 | capture | 01a1410f-cbc7-7150-96c4-6223feeb9f03 | €49.00 | €0.67 | matched |
| 75 | capture | 01a1410f-e825-73e9-8efb-6a35e699b1ce | €49.00 | €0.67 | matched |
| 76 | capture | 01a1410f-ea5a-7d59-9339-5ea0d0638a10 | €24.00 | €0.37 | matched |
| 77 | capture | 01a1410f-ec6a-7114-8e8f-e4ffec754c4b | €35.00 | €0.50 | matched |
| 78 | capture | 01a1410f-f968-7c1d-aa50-51f04abc58f4 | €15.00 | €0.26 | matched |
| 79 | capture | 01a14110-0a84-739e-bd92-af0844019aee | €15.00 | €0.26 | matched |
| 80 | capture | 01a14110-0efa-7a40-8412-91a840d546d0 | €24.00 | €0.37 | matched |
| 81 | capture | 01a14110-1c94-73c8-9f4a-1f5487764569 | €15.00 | €0.26 | matched |
| 82 | capture | 01a14110-27ba-70c8-9a90-1ac113736f0a | €9.00 | €0.19 | matched |
| 83 | capture | 01a14110-4329-79d6-8961-f93344f1c4b2 | €24.00 | €0.37 | matched |
| 84 | capture | 01a14110-5161-72c6-b351-3e1daebc6888 | €35.00 | €0.50 | matched |
| 85 | capture | 01a14110-5bec-7823-b226-7ef11d8f7ed3 | €49.00 | €0.67 | matched |
| 86 | capture | 01a14110-63d1-7a58-a407-5525825ab50c | €9.00 | €0.19 | matched |
| 87 | refund | 01a14110-68c9-7b4e-a899-543e0c49b11b | -€6.00 | €0.00 | matched |
| 88 | capture | 01a14110-902d-7539-b14f-0abf7b19ab38 | €9.00 | €0.19 | matched |
| 89 | capture | 01a14110-a081-7098-9594-9ad7a6ed0aa0 | €9.00 | €0.19 | matched |
| 90 | capture | 01a14110-d27b-7c85-8288-91c44a3ecadd | €35.00 | €0.50 | matched |
| 91 | capture | 01a14110-e346-7f01-9c3d-eb1c7d90bd8b | €35.00 | €0.50 | matched |
| 92 | capture | 01a14110-f3fc-70e4-b9a2-4b7866724ca4 | €49.00 | €0.67 | matched |
| 93 | capture | 01a14111-2582-7366-8c98-622783669f24 | €24.00 | €0.37 | matched |
| 94 | capture | 01a14111-31d4-7617-8828-e916c6455407 | €49.00 | €0.67 | matched |
| 95 | capture | 01a14111-4677-7987-9f57-8bc580e0f440 | €24.00 | €0.37 | matched |
| 96 | capture | 01a14111-5841-7c4c-89fa-28b78fef34b4 | €35.00 | €0.50 | matched |
| 97 | capture | 01a14111-54d4-7a94-a2fd-6f869419ec85 | €49.00 | €0.67 | matched |
| 98 | capture | 01a14111-7fee-7784-8491-df5ccad335d7 | €24.00 | €0.37 | matched |
| 99 | capture | 01a14111-89e7-73dd-a214-74e9018b8cd4 | €9.00 | €0.19 | matched |
| 100 | capture | 01a14111-9212-7d3e-9d72-107364189bb3 | €9.00 | €0.19 | matched |
| 101 | capture | 01a14111-9359-70a3-99bc-569900e43e43 | €15.00 | €0.26 | matched |
| 102 | capture | 01a14111-9801-73aa-add9-49f06b62fc03 | €9.00 | €0.19 | matched |
| 103 | capture | 01a14111-a0eb-7e6a-86c4-36ba94b3619d | €24.00 | €0.37 | matched |
| 104 | refund | 01a14111-b565-7100-81e3-3f1fad95b4fc | -€9.00 | €0.00 | matched |
| 105 | capture | 01a14111-bad0-71b6-9375-e7d947e3ab87 | €15.00 | €0.26 | matched |
| 106 | refund | 01a14111-d415-7945-a42d-59a838bcc2b9 | -€11.00 | €0.00 | matched |
| 107 | capture | 01a14111-f3be-7c35-9278-f333805a24cc | €15.00 | €0.26 | matched |
| 108 | capture | 01a14112-0264-7d31-97fc-cb1d3b7cc8f6 | €15.00 | €0.26 | matched |
| 109 | capture | 01a14112-194c-7771-bd28-90eb8bd6e0c9 | €35.00 | €0.50 | matched |
| 110 | capture | 01a14112-1c04-7565-8ad1-3fbfcef29451 | €35.00 | €0.50 | matched |
| 111 | capture | 01a14112-25b5-7976-bf27-be8892ecb554 | €9.00 | €0.19 | matched |
| 112 | capture | 01a14112-29df-750e-8d33-84793a2f6d35 | €9.00 | €0.19 | matched |
| 113 | capture | 01a14112-3ace-78ec-9dca-42d90b3f7ab9 | €15.00 | €0.26 | matched |
| 114 | capture | 01a14112-56ac-7e2d-b299-8bf4177ce6ba | €24.00 | €0.37 | matched |
| 115 | capture | 01a14112-3bc4-77a4-8036-ea36aeff6d29 | €24.00 | €0.37 | matched |
| 116 | capture | 01a14112-7436-7a81-990d-af8832a5c57e | €35.00 | €0.50 | matched |
| 117 | capture | 01a14112-7813-7f2f-8381-7225697bb0af | €35.00 | €0.50 | matched |
| 118 | capture | 01a14112-88d7-7300-a3d2-74c996eb10d5 | €9.00 | €0.19 | matched |
| 119 | capture | 01a14112-9378-7caf-b36d-837bac813c9d | €9.00 | €0.19 | matched |
| 120 | capture | 01a14112-a067-7380-bca3-254179cb7ddc | €24.00 | €0.37 | matched |
| 121 | capture | 01a14112-c27e-7cd8-8426-29b2b59068f3 | €15.00 | €0.26 | matched |
| 122 | capture | 01a14112-cdf6-7840-bed7-9a108978ab3c | €24.00 | €0.37 | matched |
| 123 | capture | 01a14112-e2a8-70ac-b176-308e0c431165 | €35.00 | €0.50 | matched |
| 124 | capture | 01a14112-ed7c-77f6-8caa-0295e5d3cc7e | €24.00 | €0.37 | matched |
| 125 | capture | 01a14112-f864-75bc-babe-3aecf1f6d4f8 | €49.00 | €0.67 | matched |
| 126 | capture | 01a14112-fdae-753e-9a53-4ec0be820098 | €24.00 | €0.37 | matched |
| 127 | refund | 01a14113-0c3f-7116-92ef-2a4376b0939f | -€35.00 | €0.00 | matched |
| 128 | capture | 01a14113-0d47-7d05-9ba3-8cb98a7a1b52 | €9.00 | €0.19 | matched |
| 129 | capture | 01a14113-18b6-77d8-ba6c-185b9bf6dbf5 | €49.00 | €0.67 | matched |
| 130 | capture | 01a14113-249b-730b-b323-a43e10a51bf0 | €35.00 | €0.50 | matched |
| 131 | capture | 01a14113-438d-77d1-a666-3ed4e4c1da16 | €49.00 | €0.67 | matched |
| 132 | capture | 01a14113-4a76-70af-b924-a12637bfb64a | €15.00 | €0.26 | matched |
| 133 | capture | 01a14113-76d1-7982-a181-56b3ae74d7a5 | €9.00 | €0.19 | matched |
| 134 | capture | 01a14113-7ba1-7bb7-bbc8-46f50fd9a717 | €49.00 | €0.67 | matched |
| 135 | capture | 01a14113-88f2-7560-b5b5-1ca693b4fced | €9.00 | €0.19 | matched |
| 136 | refund | 01a14113-8b09-73c0-8806-480523a7aa06 | -€8.00 | €0.00 | matched |
| 137 | capture | 01a14113-9bf5-7441-ac91-5d031856342c | €49.00 | €0.67 | matched |
| 138 | capture | 01a14113-cf44-7896-800a-4eb4d9eb9f46 | €24.00 | €0.37 | matched |
| 139 | capture | 01a14113-eac5-7821-a966-362fc0bd03cc | €9.00 | €0.19 | matched |
| 140 | capture | 01a14113-ef4d-7358-8b43-bea45fe47d01 | €9.00 | €0.19 | matched |