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
- 2 Nov, 12:00128 lines1 break
- 2 Nov, 11:50125 linesclean
- 2 Nov, 11:40105 lines5 breaks
- 2 Nov, 11:30136 lines2 breaks
- 2 Nov, 11:20137 lines1 break
- 2 Nov, 11:10127 lines1 break
- 2 Nov, 11:00138 lines2 breaks
- 2 Nov, 10:50121 lines4 breaks
- 2 Nov, 10:40109 lines2 breaks
- 2 Nov, 10:30111 lines8 breaks
- 2 Nov, 10:20130 lines5 breaks
- 2 Nov, 10:10116 lines1 break
- 2 Nov, 10:00116 lines3 breaks
- 2 Nov, 09:50124 lines2 breaks
2 Nov, 10:50
Gross
€3,158.00
PSP fee
€48.42
Net to the bank
€3,109.58
Settlement journal
#341549
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19be5-ff04-745c-8028-7f917f65ffe6 is already settled by stl_EUR_2989361 line 66
- duplicate linethe file lists it twicecapture:01a19be7-c49b-7ed4-ae35-1a7adf257808 is already settled by stl_EUR_2989361 line 85
- missing linein the books, not in the filecapture:01a19be5-d3b4-7606-b248-b6552f7bca88 is in no file
- missing linein the books, not in the filecapture:01a19be9-56a4-7903-97e2-5afabc7cea1a is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 5 | capture | 01a19bdd-c4fb-7f3d-86e6-3be69b3411ec | €35.00 | €0.54 | fee difference |
| 67 | capture | 01a19be6-02a1-7447-92c4-a33a5c01c3b0 | €49.00 | €0.67 | duplicate line |
| 86 | capture | 01a19be7-c815-7f7d-8948-057d089869fd | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a19bdc-3cad-764e-8ec5-486479383611 | €15.00 | €0.26 | matched |
| 2 | capture | 01a19bdc-4492-7b99-a5f4-6cbf18b70469 | €15.00 | €0.26 | matched |
| 3 | capture | 01a19bdd-1805-7236-95a6-ef77db9640f1 | €15.00 | €0.26 | matched |
| 4 | refund | 01a19bdd-6843-7e22-856e-b5b2ed339ffd | -€22.00 | €0.00 | matched |
| 6 | capture | 01a19bde-c8d3-7c32-87cd-8d35d8dab970 | €9.00 | €0.19 | matched |
| 7 | capture | 01a19be0-d8b9-76b7-a334-5820f1385a54 | €15.00 | €0.26 | matched |
| 8 | capture | 01a19be1-8462-72f3-8a2a-86341b4d5d8d | €24.00 | €0.37 | matched |
| 9 | capture | 01a19be1-89ca-7e92-8ad1-2d66267a44d7 | €15.00 | €0.26 | matched |
| 10 | capture | 01a19be1-a57a-7422-9ece-0a75a99ca043 | €35.00 | €0.50 | matched |
| 11 | capture | 01a19be1-a60d-72a1-bbaf-45dce4c65b86 | €24.00 | €0.37 | matched |
| 12 | capture | 01a19be1-ae44-7659-b0a8-c62959bb0104 | €35.00 | €0.50 | matched |
| 13 | capture | 01a19be1-c63d-7d06-9905-cf2fd5de5587 | €49.00 | €0.67 | matched |
| 14 | capture | 01a19be1-d2a8-7f53-911b-297ab42af134 | €49.00 | €0.67 | matched |
| 15 | capture | 01a19be1-e107-7c89-b494-be6a19709376 | €49.00 | €0.67 | matched |
| 16 | capture | 01a19be1-ebe1-7d33-8a6d-111a08f9510a | €9.00 | €0.19 | matched |
| 17 | capture | 01a19be2-0446-7416-be21-c3d1ff549b3a | €24.00 | €0.37 | matched |
| 18 | capture | 01a19be2-16ad-79ad-9da4-3f57314c82ca | €24.00 | €0.37 | matched |
| 19 | refund | 01a19be2-279f-7bd2-81c7-19d49eef8ed4 | -€40.00 | €0.00 | matched |
| 20 | capture | 01a19be2-2d3c-7f86-919b-b60e71d1d3d9 | €9.00 | €0.19 | matched |
| 21 | capture | 01a19be2-2df2-7607-83f4-374d3ea7141c | €24.00 | €0.37 | matched |
| 22 | capture | 01a19be2-4125-7b9e-a96e-67589dde3d39 | €35.00 | €0.50 | matched |
| 23 | capture | 01a19be2-4876-747e-9f95-a4a118baf81b | €15.00 | €0.26 | matched |
| 24 | capture | 01a19be2-6292-7ccb-8526-b49aea7a2834 | €9.00 | €0.19 | matched |
| 25 | capture | 01a19be2-7448-7fc2-8894-d841197ad7d8 | €35.00 | €0.50 | matched |
| 26 | capture | 01a19be2-8808-73bb-b61b-c61ba5199c06 | €35.00 | €0.50 | matched |
| 27 | capture | 01a19be2-b3f8-7f94-9dcc-f61431eadb7c | €15.00 | €0.26 | matched |
| 28 | capture | 01a19be2-c2fb-7be2-bf1a-73c31ed4838c | €9.00 | €0.19 | matched |
| 29 | capture | 01a19be2-d3b7-798f-8ca1-2b54ff03ffae | €24.00 | €0.37 | matched |
| 30 | capture | 01a19be2-e148-7c70-b9c6-6fbae9f75a44 | €24.00 | €0.37 | matched |
| 31 | capture | 01a19be2-e2cf-7e4a-a4a7-12b5fe8a8252 | €9.00 | €0.19 | matched |
| 32 | capture | 01a19be2-ea69-730c-b6ea-d0b2f0879392 | €9.00 | €0.19 | matched |
| 33 | capture | 01a19be2-f1d5-7ed8-9f1b-ab41c590807d | €35.00 | €0.50 | matched |
| 34 | capture | 01a19be2-f5cd-7420-90f7-0502e19605c5 | €15.00 | €0.26 | matched |
| 35 | capture | 01a19be3-0f03-7e2b-b8d1-c5ab50987ae0 | €49.00 | €0.67 | matched |
| 36 | capture | 01a19be3-160a-79de-aa92-bbda34ceb58a | €49.00 | €0.67 | matched |
| 37 | capture | 01a19be3-32d8-7843-9543-4af84763441a | €24.00 | €0.37 | matched |
| 38 | capture | 01a19be3-3b6e-7590-bfe8-3a8018cdcb67 | €15.00 | €0.26 | matched |
| 39 | capture | 01a19be3-4b72-766a-a502-88ae778d729d | €49.00 | €0.67 | matched |
| 40 | capture | 01a19be3-4de4-7ba6-8007-ea77a6877e4f | €24.00 | €0.37 | matched |
| 41 | capture | 01a19be3-4e13-72a0-8bba-e99b333e489b | €49.00 | €0.67 | matched |
| 42 | capture | 01a19be3-5cf3-7882-8da9-7ca11c1e3073 | €9.00 | €0.19 | matched |
| 43 | capture | 01a19be3-8507-762f-9d17-e66ea6d5b578 | €35.00 | €0.50 | matched |
| 44 | capture | 01a19be3-97c3-776d-9ee2-24f31a883179 | €35.00 | €0.50 | matched |
| 45 | capture | 01a19be3-9c88-7e09-98ff-55a2eafd10c4 | €49.00 | €0.67 | matched |
| 46 | capture | 01a19be3-b604-78ae-b0af-49d31ab6f4d3 | €49.00 | €0.67 | matched |
| 47 | capture | 01a19be3-d65d-7603-ad34-217151976a1a | €24.00 | €0.37 | matched |
| 48 | capture | 01a19be3-d81a-7b5d-996f-86face13df10 | €49.00 | €0.67 | matched |
| 49 | capture | 01a19be3-e115-7a51-a9cd-f1cf442d831b | €15.00 | €0.26 | matched |
| 50 | capture | 01a19be4-13c6-7e9d-81be-ecfced557ae1 | €35.00 | €0.50 | matched |
| 51 | capture | 01a19be4-38b3-7ce6-8cb5-088be5c0cfb9 | €35.00 | €0.50 | matched |
| 52 | capture | 01a19be4-52d0-7bda-967c-a7f279549aa6 | €9.00 | €0.19 | matched |
| 53 | capture | 01a19be4-74de-725f-acc2-6f1f225464d7 | €24.00 | €0.37 | matched |
| 54 | capture | 01a19be4-7ba4-7ec4-9cdf-ab3e26a00f81 | €49.00 | €0.67 | matched |
| 55 | capture | 01a19be4-b1cd-7ee5-8ad0-4da770f7f091 | €9.00 | €0.19 | matched |
| 56 | capture | 01a19be5-1574-75d5-a41c-6722de3ed5e0 | €15.00 | €0.26 | matched |
| 57 | capture | 01a19be5-1a2f-7778-a0a0-26137ad4ab9f | €49.00 | €0.67 | matched |
| 58 | capture | 01a19be5-1bed-7b8d-9ddf-f5cc46ce924d | €24.00 | €0.37 | matched |
| 59 | capture | 01a19be5-68e4-77ae-b4e8-fa68fcdaacfa | €24.00 | €0.37 | matched |
| 60 | capture | 01a19be5-7246-767c-8ba3-248d2216ea67 | €24.00 | €0.37 | matched |
| 61 | capture | 01a19be5-af6a-78e5-b9a2-346a1530061e | €9.00 | €0.19 | matched |
| 62 | capture | 01a19be5-b1ca-7ca0-bc3b-2676462ad611 | €49.00 | €0.67 | matched |
| 63 | capture | 01a19be5-b902-7811-8b79-4c51c347bfb8 | €35.00 | €0.50 | matched |
| 64 | capture | 01a19be5-bf2a-7506-86a7-727bf906dbe1 | €9.00 | €0.19 | matched |
| 65 | capture | 01a19be5-ca70-737f-9164-2d3a5dd0b7e2 | €35.00 | €0.50 | matched |
| 66 | capture | 01a19be6-02a1-7447-92c4-a33a5c01c3b0 | €49.00 | €0.67 | matched |
| 68 | capture | 01a19be6-0535-7eb0-aea6-75e9b3accded | €49.00 | €0.67 | matched |
| 69 | capture | 01a19be6-0696-71a4-bf9e-3de0bff4d56f | €49.00 | €0.67 | matched |
| 70 | capture | 01a19be6-16a1-727d-a711-c4e6aae85051 | €9.00 | €0.19 | matched |
| 71 | capture | 01a19be6-9f6f-729a-9b19-c3f444bd515e | €24.00 | €0.37 | matched |
| 72 | capture | 01a19be6-c1c8-7ee2-b2bf-be35b2ed3cff | €15.00 | €0.26 | matched |
| 73 | capture | 01a19be6-d06f-73ad-b66d-4f9bfa4c0482 | €35.00 | €0.50 | matched |
| 74 | capture | 01a19be6-d4dd-7006-8404-5187fe96de9d | €49.00 | €0.67 | matched |
| 75 | capture | 01a19be6-e9f4-7170-bc4a-2e3cc0491d4d | €35.00 | €0.50 | matched |
| 76 | capture | 01a19be6-ef1c-7856-b978-7267bb8dc1fa | €15.00 | €0.26 | matched |
| 77 | capture | 01a19be6-f571-71dd-a70f-1929d35e0a2d | €24.00 | €0.37 | matched |
| 78 | capture | 01a19be7-1c2f-7972-a37a-b2ec2a7dd8ea | €49.00 | €0.67 | matched |
| 79 | capture | 01a19be7-34c0-72e2-847b-01d088f5ee16 | €49.00 | €0.67 | matched |
| 80 | capture | 01a19be7-3a09-749f-9b25-cdaca670e3df | €15.00 | €0.26 | matched |
| 81 | capture | 01a19be7-4de9-743f-a2d6-9772b995f221 | €15.00 | €0.26 | matched |
| 82 | capture | 01a19be7-6a90-7667-b1de-196d46b61061 | €15.00 | €0.26 | matched |
| 83 | capture | 01a19be7-954d-7949-a5e9-9317b12954d1 | €49.00 | €0.67 | matched |
| 84 | capture | 01a19be7-9d3e-77f8-8572-da851dc30772 | €9.00 | €0.19 | matched |
| 85 | capture | 01a19be7-c815-7f7d-8948-057d089869fd | €24.00 | €0.37 | matched |
| 87 | capture | 01a19be7-dfdc-7180-936e-e04cdcd68eb3 | €35.00 | €0.50 | matched |
| 88 | capture | 01a19be8-1ee0-71d8-9e73-a02f264d53c4 | €49.00 | €0.67 | matched |
| 89 | capture | 01a19be8-547d-7607-b472-7e96db90fb52 | €15.00 | €0.26 | matched |
| 90 | capture | 01a19be8-6cff-7cd8-9dd3-2598e05c8021 | €35.00 | €0.50 | matched |
| 91 | capture | 01a19be8-6d6f-7296-8851-81fe2f591a3d | €49.00 | €0.67 | matched |
| 92 | capture | 01a19be8-718a-7e16-b9b7-05f4d800b9e3 | €49.00 | €0.67 | matched |
| 93 | capture | 01a19be8-742f-7996-9554-1756750c07c8 | €24.00 | €0.37 | matched |
| 94 | capture | 01a19be8-9c34-799b-8d36-b834276f9124 | €15.00 | €0.26 | matched |
| 95 | capture | 01a19be8-9e20-7b2b-9ca3-81bb0ba1ce09 | €9.00 | €0.19 | matched |
| 96 | capture | 01a19be8-a76d-7139-8956-822a62170531 | €9.00 | €0.19 | matched |
| 97 | refund | 01a19be8-d0e3-7a84-84d5-764e41e8adcc | -€6.00 | €0.00 | matched |
| 98 | capture | 01a19be8-ef47-7b2d-8ce4-47f605cf9931 | €49.00 | €0.67 | matched |
| 99 | capture | 01a19be8-f60c-7510-a9cd-41a1395c39c6 | €15.00 | €0.26 | matched |
| 100 | capture | 01a19be9-1885-7ff8-969e-a608ed03edd0 | €15.00 | €0.26 | matched |
| 101 | capture | 01a19be9-2c55-7888-a690-e01dda4d1853 | €15.00 | €0.26 | matched |
| 102 | capture | 01a19be9-33fd-7e21-ab18-87745c6b3c68 | €49.00 | €0.67 | matched |
| 103 | capture | 01a19be9-5afd-79d4-9647-0bebe78f5a09 | €35.00 | €0.50 | matched |
| 104 | capture | 01a19be9-61bd-7164-b325-6de4b4ad2ee8 | €35.00 | €0.50 | matched |
| 105 | capture | 01a19be9-86e6-7815-a560-d29e4e4c4fc2 | €9.00 | €0.19 | matched |
| 106 | capture | 01a19be9-91a4-75b8-ba08-e3d4ff4530e9 | €15.00 | €0.26 | matched |
| 107 | capture | 01a19be9-9242-7fdc-ba84-948bc6eaaf10 | €15.00 | €0.26 | matched |
| 108 | capture | 01a19be9-a0d5-7dad-bdcc-9cc407188981 | €35.00 | €0.50 | matched |
| 109 | capture | 01a19be9-beca-7146-a843-3f6704df5840 | €35.00 | €0.50 | matched |
| 110 | capture | 01a19be9-bf45-7315-9bd8-4fcdb4fb52bf | €24.00 | €0.37 | matched |
| 111 | capture | 01a19be9-c049-7cef-88fc-ad601bd30d79 | €9.00 | €0.19 | matched |
| 112 | capture | 01a19be9-f50a-7943-aff8-102923c48997 | €49.00 | €0.67 | matched |
| 113 | capture | 01a19be9-fe93-7fce-964d-62ad8ae9cde9 | €49.00 | €0.67 | matched |
| 114 | capture | 01a19bea-0943-7d70-a3fc-ce7d30ec53ba | €24.00 | €0.37 | matched |
| 115 | capture | 01a19bea-17b8-7231-95bf-e745c35ae442 | €15.00 | €0.26 | matched |
| 116 | capture | 01a19bea-347e-76ca-acaa-e898a62a9d77 | €24.00 | €0.37 | matched |
| 117 | capture | 01a19bea-3744-7742-85b6-e0b69d38ff21 | €9.00 | €0.19 | matched |
| 118 | capture | 01a19bea-3aec-70fb-ba38-7a8ea0c05885 | €24.00 | €0.37 | matched |
| 119 | refund | 01a19bea-3f3a-715a-bacb-72f74d8e4433 | -€14.00 | €0.00 | matched |
| 120 | capture | 01a19bea-624f-71f4-b8e4-74fd2a5ca4e2 | €15.00 | €0.26 | matched |
| 121 | capture | 01a19bea-723b-7a6f-8120-530811b68fb1 | €35.00 | €0.50 | matched |