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
- 1 Nov, 04:30123 lines2 breaks
- 1 Nov, 04:20124 lines2 breaks
- 1 Nov, 04:10133 lines1 break
- 1 Nov, 04:00126 linesclean
- 1 Nov, 03:50110 lines2 breaks
- 1 Nov, 03:40121 lines2 breaks
- 1 Nov, 03:30141 lines3 breaks
- 1 Nov, 03:20111 lines1 break
- 1 Nov, 03:10126 lines5 breaks
- 1 Nov, 03:00137 lines4 breaks
- 1 Nov, 02:50115 lines5 breaks
- 1 Nov, 02:40133 lines2 breaks
- 1 Nov, 02:30134 lines2 breaks
- 1 Nov, 02:20107 lines3 breaks
1 Nov, 03:30
Gross
€3,461.00
PSP fee
€53.91
Net to the bank
€3,407.09
Settlement journal
#317746
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19530-cf71-77c8-9e71-909e4c297726 is already settled by stl_EUR_2989173 line 136
- fee differencethe fee is not the contract feethe fee is 24, the contract says 19
- missing linein the books, not in the filecapture:01a19529-60ce-7ca7-95a0-2d3914c38847 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 20 | capture | 01a19528-e58f-7338-86f5-77f282fd108c | €9.00 | €0.24 | fee difference |
| 137 | capture | 01a19530-cfa3-7111-b680-9172a6bbdc9a | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a19520-1186-785f-afba-34f49aeb17e3 | €24.00 | €0.37 | matched |
| 2 | capture | 01a19520-2545-79a3-91a3-fe0846e2961f | €24.00 | €0.37 | matched |
| 3 | refund | 01a19524-a566-7722-ac53-f20517e46878 | -€19.00 | €0.00 | matched |
| 4 | capture | 01a19525-c6dd-7089-a5bc-eb62c7e04133 | €24.00 | €0.37 | matched |
| 5 | capture | 01a19527-050f-7368-adae-77faba8ebe3d | €49.00 | €0.67 | matched |
| 6 | capture | 01a19527-d9f8-76de-b5c7-88854c6a5d69 | €15.00 | €0.26 | matched |
| 7 | capture | 01a19528-258f-7fb4-9e0e-ce16c29deb7e | €49.00 | €0.67 | matched |
| 8 | refund | 01a19528-3715-7e05-bfe2-222d928eaaf8 | -€18.00 | €0.00 | matched |
| 9 | capture | 01a19528-6206-76ee-882e-094db1e134a0 | €24.00 | €0.37 | matched |
| 10 | capture | 01a19528-7eb9-7121-b9d6-0edfa7f64fed | €35.00 | €0.50 | matched |
| 11 | capture | 01a19528-85a1-7129-86b1-cb9f9d207e8f | €24.00 | €0.37 | matched |
| 12 | capture | 01a19528-8fc2-72df-9dbc-428481d7a442 | €35.00 | €0.50 | matched |
| 13 | capture | 01a19528-a2c7-7fde-a090-38186135fc5d | €15.00 | €0.26 | matched |
| 14 | refund | 01a19528-a32f-7589-b18b-65881ee0641d | -€8.00 | €0.00 | matched |
| 15 | capture | 01a19528-bcda-7e56-853d-b2622eff0597 | €15.00 | €0.26 | matched |
| 16 | capture | 01a19528-c307-7427-985b-d26942de24de | €35.00 | €0.50 | matched |
| 17 | capture | 01a19528-cd4f-72a1-b5b5-46c444a2cf61 | €49.00 | €0.67 | matched |
| 18 | capture | 01a19528-d26b-7524-a1f9-dd4cb86dec95 | €49.00 | €0.67 | matched |
| 19 | refund | 01a19528-db5f-7518-8bbf-409cae2a91cc | -€23.00 | €0.00 | matched |
| 21 | capture | 01a19528-ead3-7b53-8dd1-e8aba612f629 | €9.00 | €0.19 | matched |
| 22 | capture | 01a19528-ed00-710a-9859-3c3840f2b22e | €24.00 | €0.37 | matched |
| 23 | capture | 01a19529-03b4-7149-aeeb-076ccac3799e | €49.00 | €0.67 | matched |
| 24 | capture | 01a19529-0d3f-7c95-b963-7325f5059db0 | €35.00 | €0.50 | matched |
| 25 | capture | 01a19529-4307-747e-beae-71c7d56fab09 | €24.00 | €0.37 | matched |
| 26 | capture | 01a19529-483f-783b-a564-33a3132fa079 | €9.00 | €0.19 | matched |
| 27 | capture | 01a19529-4cc3-7699-a5c8-b40d325208ae | €15.00 | €0.26 | matched |
| 28 | capture | 01a19529-4f4a-75de-bb9e-a4a467058511 | €24.00 | €0.37 | matched |
| 29 | capture | 01a19529-50b0-71c2-abb4-426650a359ee | €49.00 | €0.67 | matched |
| 30 | capture | 01a19529-6e0d-7e82-ae8b-f7f1daf076cc | €9.00 | €0.19 | matched |
| 31 | capture | 01a19529-813e-7841-ad82-c2fc689097e5 | €24.00 | €0.37 | matched |
| 32 | capture | 01a19529-8689-717d-bb2c-5cbf865077e7 | €24.00 | €0.37 | matched |
| 33 | capture | 01a19529-8e80-7fdf-8fe1-9515ee8de541 | €15.00 | €0.26 | matched |
| 34 | capture | 01a19529-9318-7d80-96cc-aab3e6da4810 | €24.00 | €0.37 | matched |
| 35 | capture | 01a19529-aa86-7f1c-8c83-5b1879a0039c | €49.00 | €0.67 | matched |
| 36 | capture | 01a19529-b1b2-7809-bad5-9e50c75ae6db | €15.00 | €0.26 | matched |
| 37 | capture | 01a19529-e40d-7319-b874-a85a7b34c7ef | €24.00 | €0.37 | matched |
| 38 | refund | 01a19529-e708-724c-8f52-cbf46ebd0631 | -€11.00 | €0.00 | matched |
| 39 | capture | 01a1952a-07a1-72d5-b60d-11086a2b6406 | €9.00 | €0.19 | matched |
| 40 | capture | 01a1952a-0ba3-75ad-a177-84c8867db7e0 | €49.00 | €0.67 | matched |
| 41 | capture | 01a1952a-3d4e-7238-aeaf-21082e5e6ffa | €15.00 | €0.26 | matched |
| 42 | capture | 01a1952a-45ec-782e-b7db-d6413e919628 | €9.00 | €0.19 | matched |
| 43 | capture | 01a1952a-4e5b-768f-9944-08dbaecff556 | €49.00 | €0.67 | matched |
| 44 | capture | 01a1952a-5334-7398-abe1-934536a9e7fa | €35.00 | €0.50 | matched |
| 45 | capture | 01a1952a-56c3-745d-a018-d9b3b1883740 | €15.00 | €0.26 | matched |
| 46 | capture | 01a1952a-6a58-7744-bd9e-34bcca20e94b | €15.00 | €0.26 | matched |
| 47 | capture | 01a1952a-776b-7929-8904-ca927d0a77ff | €9.00 | €0.19 | matched |
| 48 | capture | 01a1952a-7d9b-7f94-9650-0c258007ab9d | €9.00 | €0.19 | matched |
| 49 | capture | 01a1952a-8840-7de5-a85e-0f859f7de812 | €35.00 | €0.50 | matched |
| 50 | capture | 01a1952a-a3fe-701d-b6da-9ca4728f1f2f | €24.00 | €0.37 | matched |
| 51 | capture | 01a1952a-b633-772d-bd64-fe0d28444651 | €9.00 | €0.19 | matched |
| 52 | capture | 01a1952a-b8b1-7cc6-b9b2-4c3f97609f6b | €24.00 | €0.37 | matched |
| 53 | capture | 01a1952a-c61c-7ab8-a8d8-212fe35b803f | €49.00 | €0.67 | matched |
| 54 | refund | 01a1952a-dfc9-7792-80e8-4cddb94910ac | -€2.00 | €0.00 | matched |
| 55 | capture | 01a1952a-e36e-7cfd-bbbe-179de44fba07 | €9.00 | €0.19 | matched |
| 56 | capture | 01a1952a-f6e4-7128-a6e2-288dd18bdcd6 | €15.00 | €0.26 | matched |
| 57 | capture | 01a1952b-10eb-7173-92c2-5e957c769877 | €9.00 | €0.19 | matched |
| 58 | capture | 01a1952b-1740-7055-b162-1d145de91d8b | €35.00 | €0.50 | matched |
| 59 | capture | 01a1952b-19a9-73bc-9761-9e971f010be6 | €35.00 | €0.50 | matched |
| 60 | capture | 01a1952b-339c-78c1-a665-a97a45618c16 | €35.00 | €0.50 | matched |
| 61 | capture | 01a1952b-466f-71da-82e2-103ad4e759ba | €49.00 | €0.67 | matched |
| 62 | capture | 01a1952b-5227-7ea5-94f1-2a6f319c04e0 | €49.00 | €0.67 | matched |
| 63 | capture | 01a1952b-5cdd-76c9-8c57-af8890702d05 | €49.00 | €0.67 | matched |
| 64 | capture | 01a1952b-646a-7483-8a7e-c84797b799fb | €9.00 | €0.19 | matched |
| 65 | capture | 01a1952b-7d89-7abe-990f-8733668961ad | €15.00 | €0.26 | matched |
| 66 | capture | 01a1952b-9a13-738b-8824-2ea3998f6f98 | €9.00 | €0.19 | matched |
| 67 | capture | 01a1952b-9dcb-7756-a253-ff4b7de9471b | €24.00 | €0.37 | matched |
| 68 | capture | 01a1952b-a45e-7f1c-8187-359e152ce38f | €49.00 | €0.67 | matched |
| 69 | capture | 01a1952b-b89e-76cc-baee-00ffe0f2bafd | €24.00 | €0.37 | matched |
| 70 | capture | 01a1952b-d3c1-75a0-aefc-8569cbe64c43 | €49.00 | €0.67 | matched |
| 71 | capture | 01a1952b-e7a9-73be-939c-bf41ba893b83 | €24.00 | €0.37 | matched |
| 72 | capture | 01a1952b-f26b-71f9-9578-3a42abcfa466 | €49.00 | €0.67 | matched |
| 73 | capture | 01a1952c-2b51-78ea-b1b1-8357f7a331b6 | €24.00 | €0.37 | matched |
| 74 | capture | 01a1952c-3e31-739a-8bfb-ae7bc26dbfff | €24.00 | €0.37 | matched |
| 75 | capture | 01a1952c-7cb2-7b95-b2d1-ae5ba06bd5c2 | €9.00 | €0.19 | matched |
| 76 | capture | 01a1952c-8dbc-7a18-995f-bc88644f4615 | €35.00 | €0.50 | matched |
| 77 | capture | 01a1952c-a862-76e6-8c27-f3906659f5f5 | €24.00 | €0.37 | matched |
| 78 | capture | 01a1952c-b302-75c0-88a2-34e6c1e53a7f | €15.00 | €0.26 | matched |
| 79 | capture | 01a1952c-b6b3-77ce-bbe0-9c768757909f | €9.00 | €0.19 | matched |
| 80 | capture | 01a1952c-d86c-7c5d-9f26-43f21e1ca2ce | €15.00 | €0.26 | matched |
| 81 | capture | 01a1952c-dc7e-7582-ad62-7bd643b44a5f | €49.00 | €0.67 | matched |
| 82 | capture | 01a1952c-fde5-759a-9cfd-1cf53d7509db | €24.00 | €0.37 | matched |
| 83 | capture | 01a1952d-13a7-724d-b976-4289eccf3981 | €15.00 | €0.26 | matched |
| 84 | capture | 01a1952d-15d2-74f4-ad5a-3e55a0cf2b63 | €49.00 | €0.67 | matched |
| 85 | capture | 01a1952d-1cf7-7a64-8935-d8dd28739894 | €35.00 | €0.50 | matched |
| 86 | capture | 01a1952d-1f1b-735e-a071-4087f9b8d866 | €15.00 | €0.26 | matched |
| 87 | capture | 01a1952d-2ae3-781a-8b99-19027e0a2647 | €35.00 | €0.50 | matched |
| 88 | capture | 01a1952d-386f-7538-9962-2135f2e16074 | €24.00 | €0.37 | matched |
| 89 | capture | 01a1952d-3974-7ef5-8346-f7ec9a5e3980 | €24.00 | €0.37 | matched |
| 90 | capture | 01a1952d-4dfb-72b9-9648-e8e598016375 | €49.00 | €0.67 | matched |
| 91 | capture | 01a1952d-56eb-71db-bdc5-1a0deb5230bf | €24.00 | €0.37 | matched |
| 92 | refund | 01a1952d-8fde-7147-b08b-70b351ed4547 | -€21.00 | €0.00 | matched |
| 93 | capture | 01a1952d-b67f-791b-9886-5a045dd01170 | €9.00 | €0.19 | matched |
| 94 | capture | 01a1952d-da3e-70b4-a4ee-8b202cc597a0 | €49.00 | €0.67 | matched |
| 95 | capture | 01a1952d-dc5b-777b-8478-b94061472bc2 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1952d-eb66-7176-a893-2b968ee235e7 | €24.00 | €0.37 | matched |
| 97 | capture | 01a1952d-f982-7e3b-80fe-563a8fa118c8 | €9.00 | €0.19 | matched |
| 98 | refund | 01a1952e-062b-776c-9eec-0c4668ab9f53 | -€24.00 | €0.00 | matched |
| 99 | capture | 01a1952e-0b23-7c07-a7af-d20563eb132f | €15.00 | €0.26 | matched |
| 100 | capture | 01a1952e-1945-7440-b50f-7b4bb39172d9 | €24.00 | €0.37 | matched |
| 101 | capture | 01a1952e-1e73-7ff9-9047-cf630df5b34b | €35.00 | €0.50 | matched |
| 102 | capture | 01a1952e-1eaa-775f-96b1-55aeda95689c | €49.00 | €0.67 | matched |
| 103 | capture | 01a1952e-1f42-70c1-97f6-e7d10ad233f9 | €49.00 | €0.67 | matched |
| 104 | capture | 01a1952e-2690-7203-b53e-9eee7440472e | €9.00 | €0.19 | matched |
| 105 | capture | 01a1952e-44e4-7130-96f8-3785d4245433 | €35.00 | €0.50 | matched |
| 106 | capture | 01a1952e-4ea5-787d-8f56-a6952b79b442 | €15.00 | €0.26 | matched |
| 107 | capture | 01a1952e-587a-7183-b63d-41b49270e85d | €24.00 | €0.37 | matched |
| 108 | capture | 01a1952e-689f-737a-8d94-eb256d232ca8 | €9.00 | €0.19 | matched |
| 109 | capture | 01a1952e-7247-71fe-bb4f-fd37a7388e3c | €35.00 | €0.50 | matched |
| 110 | capture | 01a1952e-8f7b-756b-8acc-be246d5e0176 | €49.00 | €0.67 | matched |
| 111 | capture | 01a1952e-9144-7538-a87f-3ff720875b26 | €24.00 | €0.37 | matched |
| 112 | capture | 01a1952e-a050-748c-8d17-328e7e0bc8e1 | €24.00 | €0.37 | matched |
| 113 | capture | 01a1952e-b958-789d-baea-f44b01fdb512 | €24.00 | €0.37 | matched |
| 114 | capture | 01a1952e-c53c-7a4e-bb51-177ba6bb3b04 | €49.00 | €0.67 | matched |
| 115 | capture | 01a1952e-cf41-7698-8d10-93aa7ced9bb0 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1952e-dc64-72c4-b2d3-ae08f5445c8b | €9.00 | €0.19 | matched |
| 117 | capture | 01a1952e-f3d8-7556-a086-b7372d5644db | €9.00 | €0.19 | matched |
| 118 | capture | 01a1952f-1a72-78be-a0e8-047c4978b161 | €24.00 | €0.37 | matched |
| 119 | capture | 01a1952f-28e6-7787-919c-fa803d80a84b | €35.00 | €0.50 | matched |
| 120 | capture | 01a1952f-2a57-7de3-8185-1dcdda53e5ef | €35.00 | €0.50 | matched |
| 121 | capture | 01a1952f-3a02-7d32-8b3f-2c3cf9ff17ae | €9.00 | €0.19 | matched |
| 122 | capture | 01a1952f-4983-722c-a241-b25b0d928a76 | €35.00 | €0.50 | matched |
| 123 | capture | 01a1952f-5818-7d76-80e3-7a9d54b66a07 | €49.00 | €0.67 | matched |
| 124 | capture | 01a1952f-b38f-7508-9a94-a8fed134e2d9 | €35.00 | €0.50 | matched |
| 125 | capture | 01a1952f-e5bb-7641-afca-9084004373b4 | €35.00 | €0.50 | matched |
| 126 | capture | 01a1952f-f196-7246-b8a6-ac26460d9908 | €24.00 | €0.37 | matched |
| 127 | capture | 01a1952f-fc8e-7d27-bd13-c0ce11c5d861 | €49.00 | €0.67 | matched |
| 128 | capture | 01a19530-0d7d-7cb0-9ea0-bafb15eab965 | €24.00 | €0.37 | matched |
| 129 | capture | 01a19530-0daa-7439-a920-56bf58ddae7d | €9.00 | €0.19 | matched |
| 130 | capture | 01a19530-2acc-73cd-87dd-41049a53055b | €15.00 | €0.26 | matched |
| 131 | capture | 01a19530-33af-7634-8823-6c8ce7060c2c | €9.00 | €0.19 | matched |
| 132 | capture | 01a19530-3c21-710f-9b7c-857af0019861 | €35.00 | €0.50 | matched |
| 133 | capture | 01a19530-8923-72ec-828b-0bc6c2efb8ec | €15.00 | €0.26 | matched |
| 134 | capture | 01a19530-9e41-7f71-bca6-80b8c7078b6e | €49.00 | €0.67 | matched |
| 135 | capture | 01a19530-9f6c-75a8-831d-868bd73332a0 | €15.00 | €0.26 | matched |
| 136 | capture | 01a19530-cfa3-7111-b680-9172a6bbdc9a | €15.00 | €0.26 | matched |
| 138 | capture | 01a19530-f087-7982-b9a9-7f7ce995628a | €35.00 | €0.50 | matched |
| 139 | capture | 01a19530-f53f-771f-b7e7-d5bb91e76a03 | €24.00 | €0.37 | matched |
| 140 | capture | 01a19531-2af5-7b63-8b61-676dec9f8b0a | €49.00 | €0.67 | matched |
| 141 | capture | 01a19531-4433-7898-b258-675ace7f13e9 | €24.00 | €0.37 | matched |