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, 10:40126 lines1 break
- 3 Nov, 10:30111 lines2 breaks
- 3 Nov, 10:20133 lines2 breaks
- 3 Nov, 10:10106 linesclean
- 3 Nov, 10:00123 lines1 break
- 3 Nov, 09:50140 lines6 breaks
- 3 Nov, 09:40117 lines6 breaks
- 3 Nov, 09:30142 lines5 breaks
- 3 Nov, 09:20130 linesclean
- 3 Nov, 09:10118 lines1 break
- 3 Nov, 09:00137 lines5 breaks
- 3 Nov, 08:50125 lines3 breaks
- 3 Nov, 08:40116 lines4 breaks
- 3 Nov, 08:30118 lines4 breaks
3 Nov, 09:30
Gross
€3,047.00
PSP fee
€49.89
Net to the bank
€2,997.11
Settlement journal
#358889
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a0c4-7cac-796d-a09d-6d29044f9c27 is already settled by stl_EUR_2989497 line 102
- duplicate linethe file lists it twicecapture:01a1a0c6-9395-72b2-bba2-6356ff60af46 is already settled by stl_EUR_2989497 line 131
- fee differencethe fee is not the contract feethe fee is 52, the contract says 50
- fee differencethe fee is not the contract feethe fee is 51, the contract says 50
- missing linein the books, not in the filecapture:01a1a0c1-f23b-7beb-b67e-536142dd34cf is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 35 | capture | 01a1a0c0-9cf2-796e-a251-3b22261f45a2 | €35.00 | €0.52 | fee difference |
| 103 | capture | 01a1a0c4-893d-7044-8330-31d59ff070d6 | €15.00 | €0.26 | duplicate line |
| 129 | capture | 01a1a0c6-53c5-7430-927c-d1d798763e70 | €35.00 | €0.51 | fee difference |
| 132 | capture | 01a1a0c6-93cd-7676-9e44-7bd628e282d3 | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a1a0b8-922a-7204-bae3-1073c4195a62 | €49.00 | €0.67 | matched |
| 2 | capture | 01a1a0b8-f9fb-70ce-aa91-0a8741dc89cf | €9.00 | €0.19 | matched |
| 3 | capture | 01a1a0b9-7549-72eb-a99d-fe78eb2ffb60 | €35.00 | €0.50 | matched |
| 4 | refund | 01a1a0ba-0a06-7d2b-b043-f4cc54fe42dc | -€21.00 | €0.00 | matched |
| 5 | capture | 01a1a0be-7a3f-74fd-af44-c7ae55ea5c5d | €15.00 | €0.26 | matched |
| 6 | capture | 01a1a0be-83c4-743c-a489-ec9624133e7d | €49.00 | €0.67 | matched |
| 7 | refund | 01a1a0be-9c1c-74dc-85a2-4f48f3a9463f | -€21.00 | €0.00 | matched |
| 8 | capture | 01a1a0be-9fbb-7c33-8e5a-9fbaee324608 | €9.00 | €0.19 | matched |
| 9 | capture | 01a1a0be-bfc1-7c61-b7e7-6d2895f6a53d | €15.00 | €0.26 | matched |
| 10 | capture | 01a1a0be-c44a-7675-a107-3c1f2ac2efed | €9.00 | €0.19 | matched |
| 11 | refund | 01a1a0be-cc8b-7cae-a60a-173f80e3d827 | -€4.00 | €0.00 | matched |
| 12 | capture | 01a1a0be-d97a-7bc0-9d30-f2f59d489830 | €15.00 | €0.26 | matched |
| 13 | capture | 01a1a0be-f7eb-74fa-a698-6aab846999cc | €24.00 | €0.37 | matched |
| 14 | capture | 01a1a0be-ff51-719c-bec2-91dbf93d55ed | €35.00 | €0.50 | matched |
| 15 | capture | 01a1a0bf-3592-7438-8892-e03ca5d2ec04 | €35.00 | €0.50 | matched |
| 16 | capture | 01a1a0bf-3baa-7340-ae65-990ac6535566 | €49.00 | €0.67 | matched |
| 17 | capture | 01a1a0bf-48d3-72ce-b726-cb15a5fe764f | €35.00 | €0.50 | matched |
| 18 | capture | 01a1a0bf-5c8b-70c6-82c0-8daf90fc2fb3 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1a0bf-72c8-7645-8eec-72b526038a4a | €9.00 | €0.19 | matched |
| 20 | capture | 01a1a0bf-7888-7703-85ae-c2860c176f7b | €49.00 | €0.67 | matched |
| 21 | capture | 01a1a0bf-7bba-7d6d-b4af-b92407758e8c | €35.00 | €0.50 | matched |
| 22 | capture | 01a1a0bf-7d1f-751a-85f4-218e30ec87d1 | €9.00 | €0.19 | matched |
| 23 | capture | 01a1a0bf-86a3-7390-903b-b9e63196d7ec | €49.00 | €0.67 | matched |
| 24 | refund | 01a1a0bf-c005-7143-a3d0-b2d31dc7875d | -€32.00 | €0.00 | matched |
| 25 | refund | 01a1a0bf-df37-7bc5-9ab8-6e5193030489 | -€43.00 | €0.00 | matched |
| 26 | capture | 01a1a0bf-e63c-75e5-a48d-daf184ee4146 | €24.00 | €0.37 | matched |
| 27 | capture | 01a1a0bf-f76b-7bd3-b435-6ef08bd1725b | €49.00 | €0.67 | matched |
| 28 | capture | 01a1a0c0-20ea-7422-960d-fe617dd9f1b8 | €24.00 | €0.37 | matched |
| 29 | capture | 01a1a0c0-3896-703f-b56c-606cb03fa6c5 | €15.00 | €0.26 | matched |
| 30 | capture | 01a1a0c0-419e-7676-97f6-8622707a6d9a | €24.00 | €0.37 | matched |
| 31 | capture | 01a1a0c0-4513-7a19-9aae-da53b348952f | €24.00 | €0.37 | matched |
| 32 | capture | 01a1a0c0-52f8-7a39-bc68-f44e9f8bf76c | €24.00 | €0.37 | matched |
| 33 | capture | 01a1a0c0-5b49-79d0-9ee1-899c36db3361 | €9.00 | €0.19 | matched |
| 34 | capture | 01a1a0c0-5e32-75dd-8075-5ea109b2490b | €35.00 | €0.50 | matched |
| 36 | refund | 01a1a0c0-a141-7ffc-993b-81a5b7ca2e93 | -€10.00 | €0.00 | matched |
| 37 | capture | 01a1a0c0-a82b-7446-a3e1-2d03f1be46a5 | €15.00 | €0.26 | matched |
| 38 | capture | 01a1a0c0-afb9-7cb1-b774-e58597c6ef46 | €15.00 | €0.26 | matched |
| 39 | capture | 01a1a0c0-b0b8-7901-bdf8-0d5494106050 | €49.00 | €0.67 | matched |
| 40 | capture | 01a1a0c0-c22f-764f-b52a-ef9d4ae221bf | €15.00 | €0.26 | matched |
| 41 | capture | 01a1a0c0-eaa3-7c2b-8f38-734c280fc404 | €9.00 | €0.19 | matched |
| 42 | capture | 01a1a0c0-ff41-7f7d-a033-af2f79c4c63a | €24.00 | €0.37 | matched |
| 43 | capture | 01a1a0c0-ff41-7d59-8ec0-ca7aad229323 | €35.00 | €0.50 | matched |
| 44 | capture | 01a1a0c1-09f6-7538-8331-2da2486181b0 | €49.00 | €0.67 | matched |
| 45 | capture | 01a1a0c1-1202-7049-bc2e-98904223cacb | €24.00 | €0.37 | matched |
| 46 | capture | 01a1a0c1-1572-7cee-8386-7465370bb7ab | €24.00 | €0.37 | matched |
| 47 | capture | 01a1a0c1-1fb5-7466-9129-35738e1cec74 | €35.00 | €0.50 | matched |
| 48 | capture | 01a1a0c1-27c9-754d-a07a-973ca10e8ae8 | €35.00 | €0.50 | matched |
| 49 | refund | 01a1a0c1-2ca2-7350-abc1-baa44fd4fbfd | -€4.00 | €0.00 | matched |
| 50 | capture | 01a1a0c1-2910-7277-980e-92ff8c62169b | €49.00 | €0.67 | matched |
| 51 | capture | 01a1a0c1-3b1e-7086-bd3d-078f4a7d0eac | €15.00 | €0.26 | matched |
| 52 | capture | 01a1a0c1-4d5a-708d-83aa-364898c61a52 | €35.00 | €0.50 | matched |
| 53 | capture | 01a1a0c1-4d84-759b-ae28-ad05aa7151de | €15.00 | €0.26 | matched |
| 54 | capture | 01a1a0c1-524c-7d18-9f2b-90904838c1dc | €24.00 | €0.37 | matched |
| 55 | capture | 01a1a0c1-59e4-7844-a3bc-b52d8c69e723 | €9.00 | €0.19 | matched |
| 56 | capture | 01a1a0c1-5b23-73ce-802f-f808b13c2cf3 | €24.00 | €0.37 | matched |
| 57 | capture | 01a1a0c1-6d9d-7dbc-9805-7861019991ee | €15.00 | €0.26 | matched |
| 58 | capture | 01a1a0c1-73a3-7888-917c-a73848e0b6e4 | €15.00 | €0.26 | matched |
| 59 | capture | 01a1a0c1-744a-7214-a45e-7a7b3010ae9f | €15.00 | €0.26 | matched |
| 60 | capture | 01a1a0c1-7da8-7bea-a91e-5b5b3a151e5a | €24.00 | €0.37 | matched |
| 61 | capture | 01a1a0c1-a434-7f7f-b553-f56ea70a2aa8 | €9.00 | €0.19 | matched |
| 62 | capture | 01a1a0c1-a872-7643-b157-7d3c645ac73e | €15.00 | €0.26 | matched |
| 63 | capture | 01a1a0c1-c095-76c7-8a40-106b5c5eb5f2 | €9.00 | €0.19 | matched |
| 64 | capture | 01a1a0c1-c8b3-7468-a710-2f83c90b3d33 | €35.00 | €0.50 | matched |
| 65 | capture | 01a1a0c1-e5b6-7f9c-97ac-e9f896acba89 | €35.00 | €0.50 | matched |
| 66 | capture | 01a1a0c1-ea9b-7f40-9026-e924c278aba9 | €24.00 | €0.37 | matched |
| 67 | capture | 01a1a0c1-f644-742e-9a4e-368f4e0e55c0 | €24.00 | €0.37 | matched |
| 68 | capture | 01a1a0c1-fab7-7dcd-b467-6ff2cb0bfb20 | €9.00 | €0.19 | matched |
| 69 | capture | 01a1a0c2-3f9a-743b-8664-fad498d53e73 | €24.00 | €0.37 | matched |
| 70 | refund | 01a1a0c2-5105-78a5-a8ba-8978ce6c3407 | -€38.00 | €0.00 | matched |
| 71 | capture | 01a1a0c2-5105-79c3-b925-e1844f86e52c | €15.00 | €0.26 | matched |
| 72 | capture | 01a1a0c2-5bf5-77a3-95ca-af3852970ccc | €15.00 | €0.26 | matched |
| 73 | capture | 01a1a0c2-6f17-77a9-89d6-b2f0b763a3a2 | €24.00 | €0.37 | matched |
| 74 | capture | 01a1a0c2-7565-7bce-943c-32f80bab5ebd | €35.00 | €0.50 | matched |
| 75 | capture | 01a1a0c2-8472-7e2a-8627-86e38f968ad7 | €35.00 | €0.50 | matched |
| 76 | capture | 01a1a0c2-8573-7487-ace5-ff4f32bf76de | €9.00 | €0.19 | matched |
| 77 | capture | 01a1a0c2-9a18-7d24-b18d-853cc78b4584 | €24.00 | €0.37 | matched |
| 78 | capture | 01a1a0c2-cdf1-7361-b47f-0a0e3d1c13f4 | €49.00 | €0.67 | matched |
| 79 | capture | 01a1a0c2-d894-7371-a970-f3055d69e452 | €35.00 | €0.50 | matched |
| 80 | capture | 01a1a0c2-ec1b-7b6a-9fb8-08add0eb8621 | €15.00 | €0.26 | matched |
| 81 | capture | 01a1a0c2-fd32-7600-a1b7-2ad12f88b454 | €24.00 | €0.37 | matched |
| 82 | capture | 01a1a0c3-0655-7619-9ed0-89891add9a0a | €15.00 | €0.26 | matched |
| 83 | capture | 01a1a0c3-0e80-7fef-9b1e-e738da67f2e2 | €15.00 | €0.26 | matched |
| 84 | capture | 01a1a0c3-4129-7085-b648-21532e0bbd62 | €35.00 | €0.50 | matched |
| 85 | capture | 01a1a0c3-4464-7230-9e5e-446206cba41e | €24.00 | €0.37 | matched |
| 86 | capture | 01a1a0c3-4662-7737-995e-acea59e082ac | €15.00 | €0.26 | matched |
| 87 | capture | 01a1a0c3-47cd-7821-88ea-28aace9b6c3a | €35.00 | €0.50 | matched |
| 88 | capture | 01a1a0c3-5e0c-70ad-b7c6-61e10542f69a | €49.00 | €0.67 | matched |
| 89 | capture | 01a1a0c3-968e-725c-b41e-6fc7cfecddb8 | €49.00 | €0.67 | matched |
| 90 | capture | 01a1a0c3-9c48-7cd8-afce-c184a3fa360c | €9.00 | €0.19 | matched |
| 91 | capture | 01a1a0c3-b44b-740d-975f-91d919755c67 | €9.00 | €0.19 | matched |
| 92 | capture | 01a1a0c3-e0c6-710c-ba14-7af5d8b7c3c3 | €15.00 | €0.26 | matched |
| 93 | capture | 01a1a0c3-f94b-7abd-b07d-8aba9d037c37 | €9.00 | €0.19 | matched |
| 94 | capture | 01a1a0c3-fb04-79e3-b342-a38368387bda | €24.00 | €0.37 | matched |
| 95 | capture | 01a1a0c4-1813-7fcf-a005-937edf65d933 | €15.00 | €0.26 | matched |
| 96 | capture | 01a1a0c4-39b9-757c-8c73-b3b9d7931818 | €35.00 | €0.50 | matched |
| 97 | capture | 01a1a0c4-4a6b-7c52-8589-195d5cc6ee90 | €35.00 | €0.50 | matched |
| 98 | refund | 01a1a0c4-4dc9-7261-9376-17aa3b861af9 | -€4.00 | €0.00 | matched |
| 99 | capture | 01a1a0c4-506b-7573-8785-bd33e98cba98 | €15.00 | €0.26 | matched |
| 100 | capture | 01a1a0c4-54b0-765f-a0ef-06600f859ae4 | €24.00 | €0.37 | matched |
| 101 | capture | 01a1a0c4-5c9f-7602-9a00-c4343685130c | €35.00 | €0.50 | matched |
| 102 | capture | 01a1a0c4-893d-7044-8330-31d59ff070d6 | €15.00 | €0.26 | matched |
| 104 | capture | 01a1a0c4-8973-7588-b33f-c696246574c8 | €49.00 | €0.67 | matched |
| 105 | capture | 01a1a0c4-8b6f-7f52-9b04-57aba924d854 | €49.00 | €0.67 | matched |
| 106 | capture | 01a1a0c4-902b-769e-8faa-ee9dc23822b7 | €15.00 | €0.26 | matched |
| 107 | capture | 01a1a0c4-993d-7795-a721-7f508dc463fc | €24.00 | €0.37 | matched |
| 108 | refund | 01a1a0c4-9b19-758e-8e6a-f9bf8671b636 | -€24.00 | €0.00 | matched |
| 109 | capture | 01a1a0c4-d521-7d8d-aad2-7329b6a96d94 | €49.00 | €0.67 | matched |
| 110 | capture | 01a1a0c4-da43-721f-958f-53568f8c89b5 | €24.00 | €0.37 | matched |
| 111 | capture | 01a1a0c5-0d62-760e-93d0-6428fa0fbc87 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1a0c5-2927-73cd-9db4-a81d14e5ca0c | €24.00 | €0.37 | matched |
| 113 | capture | 01a1a0c5-4cc2-7531-90b5-a200c935947e | €9.00 | €0.19 | matched |
| 114 | capture | 01a1a0c5-4ff6-74bf-85bf-89d69755679b | €49.00 | €0.67 | matched |
| 115 | capture | 01a1a0c5-60bd-76f1-9244-5971b0b64778 | €49.00 | €0.67 | matched |
| 116 | capture | 01a1a0c5-6199-7def-ad5b-f2ed7df24cce | €15.00 | €0.26 | matched |
| 117 | capture | 01a1a0c5-713e-73d4-b907-a956b6f3929f | €15.00 | €0.26 | matched |
| 118 | capture | 01a1a0c5-71d5-7b67-a03e-dc5fa8d16925 | €24.00 | €0.37 | matched |
| 119 | capture | 01a1a0c5-8e95-7866-9dbd-0c687100252c | €35.00 | €0.50 | matched |
| 120 | refund | 01a1a0c5-94b2-75e2-9e88-bb41108e093f | -€6.00 | €0.00 | matched |
| 121 | refund | 01a1a0c5-bece-7436-9ab4-e2c92dfab6d5 | -€18.00 | €0.00 | matched |
| 122 | capture | 01a1a0c5-c402-75eb-a925-b4ecfd12f47e | €9.00 | €0.19 | matched |
| 123 | refund | 01a1a0c5-c417-70aa-8093-8c4f7b155036 | -€10.00 | €0.00 | matched |
| 124 | capture | 01a1a0c5-d7df-7510-a827-d47e8efbc107 | €49.00 | €0.67 | matched |
| 125 | capture | 01a1a0c5-dde8-759d-965a-cc58a5174aec | €9.00 | €0.19 | matched |
| 126 | refund | 01a1a0c5-e0e6-7210-a78f-1d410f33f17b | -€8.00 | €0.00 | matched |
| 127 | capture | 01a1a0c5-e333-7ca8-8e75-011dd09399bc | €15.00 | €0.26 | matched |
| 128 | capture | 01a1a0c5-ed5f-79dc-b9d2-ae7ff07b14a2 | €49.00 | €0.67 | matched |
| 130 | capture | 01a1a0c6-5800-7c46-a650-a7a5d4ceb60e | €9.00 | €0.19 | matched |
| 131 | capture | 01a1a0c6-93cd-7676-9e44-7bd628e282d3 | €35.00 | €0.50 | matched |
| 133 | capture | 01a1a0c6-bc08-7bfd-a248-34591db969a6 | €9.00 | €0.19 | matched |
| 134 | capture | 01a1a0c6-c9e8-7dca-ae95-f46ba2993613 | €9.00 | €0.19 | matched |
| 135 | capture | 01a1a0c6-e5f9-7e9f-a557-31ea6fe7b43a | €24.00 | €0.37 | matched |
| 136 | capture | 01a1a0c6-ee08-7926-931f-69d4387d6963 | €35.00 | €0.50 | matched |
| 137 | capture | 01a1a0c6-f605-7569-be8e-b1b23a8df0eb | €49.00 | €0.67 | matched |
| 138 | capture | 01a1a0c7-07c7-738c-a91f-8a4a3b6eb1b2 | €9.00 | €0.19 | matched |
| 139 | capture | 01a1a0c7-2a6a-7b32-b219-999d00134b27 | €49.00 | €0.67 | matched |
| 140 | capture | 01a1a0c7-5eee-785d-8db3-8c089ff94762 | €35.00 | €0.50 | matched |
| 141 | capture | 01a1a0c7-6fce-7461-8813-c1c0d4d7e1b4 | €15.00 | €0.26 | matched |
| 142 | capture | 01a1a0c7-94df-73d0-8a9d-5ec2d14a378b | €35.00 | €0.50 | matched |