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
- 21 Oct, 05:3090 lines2 breaks
- 21 Oct, 05:20127 lines5 breaks
- 21 Oct, 05:10111 lines3 breaks
- 21 Oct, 05:00130 lines1 break
- 21 Oct, 04:50102 lines2 breaks
- 21 Oct, 04:40103 lines2 breaks
- 21 Oct, 04:30106 linesclean
- 21 Oct, 04:20129 lines1 break
- 21 Oct, 04:10129 lines7 breaks
- 21 Oct, 04:00121 lines4 breaks
- 21 Oct, 03:50116 linesclean
- 21 Oct, 03:40120 lines3 breaks
- 21 Oct, 03:30128 linesclean
- 21 Oct, 03:20137 lines3 breaks
21 Oct, 04:30
Gross
€2,500.00
PSP fee
€39.50
Net to the bank
€2,460.50
Settlement journal
#117543
Every line paired with the books, and every capture and refund of the day is in the file.
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 1 | refund | 01a15cb0-4c52-7963-a9eb-e53f47691150 | -€6.00 | €0.00 | matched |
| 2 | capture | 01a15cb6-bfe4-7040-a99b-e84592a47cfe | €35.00 | €0.50 | matched |
| 3 | capture | 01a15cb9-2fc1-779b-87fa-46d455ef1de8 | €49.00 | €0.67 | matched |
| 4 | capture | 01a15cb9-38da-7497-88a3-a87598297acc | €24.00 | €0.37 | matched |
| 5 | capture | 01a15cb9-3e80-77ae-ae2e-a80c4f41e603 | €35.00 | €0.50 | matched |
| 6 | capture | 01a15cb9-6b75-77a2-98b7-434341374720 | €9.00 | €0.19 | matched |
| 7 | capture | 01a15cb9-70cf-7779-96f8-b05d400213ae | €24.00 | €0.37 | matched |
| 8 | capture | 01a15cb9-7676-7b56-b296-3a22ef689e11 | €24.00 | €0.37 | matched |
| 9 | capture | 01a15cb9-889a-70da-a9ea-7695074acede | €15.00 | €0.26 | matched |
| 10 | capture | 01a15cb9-91b6-7b93-81b2-e9ed47253d8d | €35.00 | €0.50 | matched |
| 11 | capture | 01a15cb9-a3b7-7219-a49b-8673e4557419 | €24.00 | €0.37 | matched |
| 12 | refund | 01a15cb9-c919-7365-bf71-de6cd5bde80e | -€6.00 | €0.00 | matched |
| 13 | capture | 01a15cb9-ed3e-7eb9-b052-a0c86a0c3f14 | €49.00 | €0.67 | matched |
| 14 | capture | 01a15cb9-eea4-7cc9-a50e-853584b459e8 | €49.00 | €0.67 | matched |
| 15 | capture | 01a15cba-0d47-798a-abe3-e9bdf1738064 | €24.00 | €0.37 | matched |
| 16 | capture | 01a15cba-0da2-7d26-a98b-d37de5ebcdbe | €24.00 | €0.37 | matched |
| 17 | capture | 01a15cba-1db1-745d-8460-a1aa420c4197 | €15.00 | €0.26 | matched |
| 18 | capture | 01a15cba-26f4-7a2c-afa4-33604b326664 | €49.00 | €0.67 | matched |
| 19 | capture | 01a15cba-27fb-7e0c-b1f9-f408b1f07612 | €15.00 | €0.26 | matched |
| 20 | capture | 01a15cba-297c-7c5c-b9d5-29f56117635c | €15.00 | €0.26 | matched |
| 21 | capture | 01a15cba-329e-79b9-a5c5-ed881d5d51f1 | €49.00 | €0.67 | matched |
| 22 | refund | 01a15cba-3731-7e4d-9d67-54e55fd89074 | -€13.00 | €0.00 | matched |
| 23 | refund | 01a15cba-43fa-7cc0-9b49-a1bfc6f6c508 | -€31.00 | €0.00 | matched |
| 24 | capture | 01a15cba-44bd-7303-b1c7-92ae2dbb90e8 | €15.00 | €0.26 | matched |
| 25 | capture | 01a15cba-5335-7b64-9dbf-a98aeba67bb1 | €35.00 | €0.50 | matched |
| 26 | capture | 01a15cba-68a6-73b0-9ba6-7ea95d34fd5f | €24.00 | €0.37 | matched |
| 27 | capture | 01a15cba-69c8-79d1-ad68-2a873f2544ab | €35.00 | €0.50 | matched |
| 28 | capture | 01a15cba-7336-7a45-93f4-719ae8f7d27e | €9.00 | €0.19 | matched |
| 29 | capture | 01a15cba-9ee9-7361-9518-57c699f43fcc | €24.00 | €0.37 | matched |
| 30 | capture | 01a15cba-a763-7dd4-8a17-51484a06a643 | €15.00 | €0.26 | matched |
| 31 | capture | 01a15cba-bd18-7c54-b1f7-db920842a7bb | €35.00 | €0.50 | matched |
| 32 | capture | 01a15cba-f723-7d82-8bb8-4fbae566df9d | €49.00 | €0.67 | matched |
| 33 | capture | 01a15cbb-0759-7e34-a755-252e38d0c3d1 | €49.00 | €0.67 | matched |
| 34 | capture | 01a15cbb-20a0-771a-961f-d99b45f2136c | €24.00 | €0.37 | matched |
| 35 | capture | 01a15cbb-98d5-7cea-8e66-ad8754d255ad | €24.00 | €0.37 | matched |
| 36 | capture | 01a15cbb-af74-7744-adaf-870f14325222 | €24.00 | €0.37 | matched |
| 37 | capture | 01a15cbb-de9f-7fb2-8dab-247ab187336f | €35.00 | €0.50 | matched |
| 38 | capture | 01a15cbb-fbbd-7b45-9c8a-71598952379c | €9.00 | €0.19 | matched |
| 39 | capture | 01a15cbc-46d4-77f5-b833-95200bd7b6d2 | €49.00 | €0.67 | matched |
| 40 | capture | 01a15cbc-62ff-736b-930b-b3de458753b0 | €15.00 | €0.26 | matched |
| 41 | capture | 01a15cbc-6551-796b-8c92-d92109641af3 | €15.00 | €0.26 | matched |
| 42 | capture | 01a15cbc-a30a-73a1-9554-8387a87a7759 | €15.00 | €0.26 | matched |
| 43 | capture | 01a15cbc-ab31-7f4d-8241-91ae134fd985 | €15.00 | €0.26 | matched |
| 44 | capture | 01a15cbc-bfe3-7fe2-9f15-82213c3b5b42 | €49.00 | €0.67 | matched |
| 45 | capture | 01a15cbc-db39-7c2a-a7ea-2ee3dfa408fe | €24.00 | €0.37 | matched |
| 46 | capture | 01a15cbc-dcb7-71c9-abfb-90c10afbd368 | €49.00 | €0.67 | matched |
| 47 | capture | 01a15cbc-e423-7126-a6ff-2efb245ece81 | €9.00 | €0.19 | matched |
| 48 | capture | 01a15cbc-fe31-7f37-8a24-6fa5a5e875b6 | €15.00 | €0.26 | matched |
| 49 | capture | 01a15cbd-4955-7df5-8800-d9a01330a4ee | €35.00 | €0.50 | matched |
| 50 | capture | 01a15cbd-5d30-776e-ac69-b1f74f50a9a5 | €24.00 | €0.37 | matched |
| 51 | capture | 01a15cbd-5f94-774c-a162-3aeb0b941239 | €49.00 | €0.67 | matched |
| 52 | capture | 01a15cbd-7c03-736b-90ea-c9cfef398ca3 | €49.00 | €0.67 | matched |
| 53 | capture | 01a15cbd-8c15-7c85-b096-25c5d210656a | €35.00 | €0.50 | matched |
| 54 | capture | 01a15cbd-8e81-73e8-81d3-39bb533cab34 | €24.00 | €0.37 | matched |
| 55 | capture | 01a15cbd-9536-7d52-b15c-04d2a1a54615 | €9.00 | €0.19 | matched |
| 56 | capture | 01a15cbd-9fc2-75fe-9e6c-9e46ee5aa6e8 | €15.00 | €0.26 | matched |
| 57 | capture | 01a15cbd-b19c-7e2c-b18d-c30822b50fb1 | €35.00 | €0.50 | matched |
| 58 | capture | 01a15cbd-d69e-7784-9094-1649dc1a2699 | €49.00 | €0.67 | matched |
| 59 | capture | 01a15cbe-22e7-7fba-9e2c-46b8b395b094 | €49.00 | €0.67 | matched |
| 60 | capture | 01a15cbe-3837-738e-86ff-e61b07141e5d | €49.00 | €0.67 | matched |
| 61 | capture | 01a15cbe-5aeb-7eb1-b247-19531a51c30b | €35.00 | €0.50 | matched |
| 62 | capture | 01a15cbe-8329-7304-b19d-5d9ec5f0f30b | €15.00 | €0.26 | matched |
| 63 | capture | 01a15cbe-935d-74a6-9cc7-6d8f0ef47d32 | €24.00 | €0.37 | matched |
| 64 | capture | 01a15cbe-a781-70bf-9612-c0af6957c263 | €15.00 | €0.26 | matched |
| 65 | capture | 01a15cbe-d3ea-798d-9069-fc66b4a6ae76 | €15.00 | €0.26 | matched |
| 66 | capture | 01a15cbe-ed4d-7c94-9701-b2fbbcf9d346 | €35.00 | €0.50 | matched |
| 67 | capture | 01a15cbe-f27f-7a53-b3e5-7de5c3c71f8f | €49.00 | €0.67 | matched |
| 68 | capture | 01a15cbf-094f-7d4c-a486-242bcd184801 | €24.00 | €0.37 | matched |
| 69 | capture | 01a15cbf-1788-7b60-ac32-7dfe1d1edea7 | €24.00 | €0.37 | matched |
| 70 | capture | 01a15cbf-42f9-704a-abbb-9bc593ada4ff | €24.00 | €0.37 | matched |
| 71 | capture | 01a15cbf-4743-7748-99a2-941a9b8a4a5d | €9.00 | €0.19 | matched |
| 72 | capture | 01a15cbf-5e71-750d-b1ae-a6f0c8ceb5c0 | €24.00 | €0.37 | matched |
| 73 | capture | 01a15cbf-765a-7cc8-b142-74b26e52e657 | €24.00 | €0.37 | matched |
| 74 | capture | 01a15cbf-89bc-7ef6-a791-f2cb50da097f | €9.00 | €0.19 | matched |
| 75 | capture | 01a15cbf-8bf3-771c-9913-a50f1c45d987 | €15.00 | €0.26 | matched |
| 76 | refund | 01a15cbf-901e-70fb-9965-c8f96e995e8f | -€7.00 | €0.00 | matched |
| 77 | capture | 01a15cbf-d7a9-78a5-ad25-085326ddfe5e | €35.00 | €0.50 | matched |
| 78 | capture | 01a15cbf-e7ef-7b8f-842e-46e001e0beb5 | €35.00 | €0.50 | matched |
| 79 | capture | 01a15cc0-0f71-7353-b143-e25ecd7d45bb | €24.00 | €0.37 | matched |
| 80 | capture | 01a15cc0-153c-7131-aa2e-53ac8f916baa | €35.00 | €0.50 | matched |
| 81 | capture | 01a15cc0-1e67-7688-bc3e-45e7d90f7632 | €24.00 | €0.37 | matched |
| 82 | capture | 01a15cc0-223b-7987-b67d-c142a60c5312 | €49.00 | €0.67 | matched |
| 83 | capture | 01a15cc0-23f9-7dcd-92d7-97a802257800 | €9.00 | €0.19 | matched |
| 84 | capture | 01a15cc0-3419-7fcd-bcf5-59a304717d45 | €49.00 | €0.67 | matched |
| 85 | capture | 01a15cc0-7372-757e-9ce6-aea2ce722ee9 | €24.00 | €0.37 | matched |
| 86 | capture | 01a15cc0-863b-75c8-8eb5-6f85872761a0 | €35.00 | €0.50 | matched |
| 87 | capture | 01a15cc0-874b-782f-90f8-ba601098822c | €15.00 | €0.26 | matched |
| 88 | refund | 01a15cc0-8c05-734c-aff9-70fc4255ffbf | -€6.00 | €0.00 | matched |
| 89 | refund | 01a15cc0-a5a6-7700-a853-e55a6a9ced1a | -€47.00 | €0.00 | matched |
| 90 | capture | 01a15cc0-ae86-7a07-84c8-f4bdccaad728 | €24.00 | €0.37 | matched |
| 91 | capture | 01a15cc0-af22-7265-b03b-dfb34af2c1b4 | €49.00 | €0.67 | matched |
| 92 | capture | 01a15cc0-b2ef-7a57-8cac-83cb4ff6d416 | €9.00 | €0.19 | matched |
| 93 | refund | 01a15cc0-bdc7-7098-9eed-b16ce32085e3 | -€4.00 | €0.00 | matched |
| 94 | refund | 01a15cc0-d816-7897-aed2-e7a6238eb12a | -€15.00 | €0.00 | matched |
| 95 | capture | 01a15cc0-fa4b-7e3f-b7ee-6fcd2c865593 | €35.00 | €0.50 | matched |
| 96 | capture | 01a15cc0-fe93-775d-b326-fc5b2fce096c | €9.00 | €0.19 | matched |
| 97 | capture | 01a15cc1-1039-7f93-8d36-5ea73fbbfc95 | €9.00 | €0.19 | matched |
| 98 | capture | 01a15cc1-1e78-78d3-b19d-487d2ccd38dc | €15.00 | €0.26 | matched |
| 99 | capture | 01a15cc1-33de-7e48-9936-29e976d23226 | €15.00 | €0.26 | matched |
| 100 | capture | 01a15cc1-3c50-79d1-8771-fac82df6823e | €9.00 | €0.19 | matched |
| 101 | capture | 01a15cc1-a21a-7159-8332-b21f5bb96e3c | €49.00 | €0.67 | matched |
| 102 | capture | 01a15cc1-ee85-75aa-8b23-13e379e4eb43 | €9.00 | €0.19 | matched |
| 103 | capture | 01a15cc1-f4b9-716c-a57c-10b724394f3c | €9.00 | €0.19 | matched |
| 104 | capture | 01a15cc1-f7a1-77f4-9593-8425dd799743 | €9.00 | €0.19 | matched |
| 105 | capture | 01a15cc2-03de-7e45-aa89-e886becd19d3 | €15.00 | €0.26 | matched |
| 106 | capture | 01a15cc2-3e46-7b62-9eb5-5c7140d1f3cb | €49.00 | €0.67 | matched |