Car Wash Ledger

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, 22:50

Gross

€3,360.00

PSP fee

€54.04

Net to the bank

€3,305.96

Settlement journal

#332522

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a19957-3ab7-711b-96ff-b42cf459a298 is already settled by stl_EUR_2989289 line 148
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • missing linein the books, not in the filecapture:01a1994e-f882-7cce-a2e4-c03d408708e5 is in no file
  • missing linein the books, not in the filecapture:01a19953-9803-7203-91b2-46e2b9a0aec2 is in no file
LineKindReferenceGrossFeeStatus
79capture01a19953-94a8-7528-8985-b96741da2a9f€9.00€0.22fee difference
113capture01a19955-7fdd-77b2-9324-7d3409107bea€9.00€0.22fee difference
125capture01a19956-0a02-79c1-9473-af319e2582ed€35.00€0.52fee difference
149refund01a19957-3aba-730f-9b36-1995ec20a752-€10.00€0.00duplicate line
1capture01a19947-1499-76c4-af56-1cd713aa91fc€49.00€0.67matched
2capture01a1994a-6312-7a04-99f0-6813f0893693€9.00€0.19matched
3capture01a1994b-7e27-7fb4-8c50-00de1e645474€24.00€0.37matched
4capture01a1994e-30f7-77cd-82ce-c0dd0136f040€49.00€0.67matched
5capture01a1994e-386d-7a84-a826-6bed497fda3c€35.00€0.50matched
6capture01a1994e-53d7-7558-81a4-c3e84c713a21€9.00€0.19matched
7capture01a1994e-60aa-713e-b0b3-9a1c137e0040€35.00€0.50matched
8capture01a1994e-965c-7977-ace0-2595a26bb9f4€49.00€0.67matched
9capture01a1994e-9aa3-70c6-b400-cede824af526€35.00€0.50matched
10capture01a1994e-abf9-7dfe-a61a-e2f601f466de€35.00€0.50matched
11capture01a1994e-def1-71e2-90f3-84e8334937d8€49.00€0.67matched
12capture01a1994e-e7cb-7b79-95b3-da9585c9b827€49.00€0.67matched
13capture01a1994e-f9ec-757e-b288-a087fa011dac€15.00€0.26matched
14capture01a1994e-f8ae-782d-8b3a-73dfc912e99b€49.00€0.67matched
15capture01a1994f-06af-751c-941d-e68286715285€49.00€0.67matched
16capture01a1994f-0fff-73de-b6cc-aca73a146875€15.00€0.26matched
17refund01a1994f-2d57-743d-9072-8cfc33188fe3-€18.00€0.00matched
18capture01a1994f-4693-779a-96c8-9e3068080d0a€24.00€0.37matched
19capture01a1994f-5231-76b8-9e67-b8d3cae205d5€9.00€0.19matched
20refund01a1994f-61f2-7a46-93ce-8b4760688824-€49.00€0.00matched
21refund01a1994f-6579-7940-853a-df5d635cc03e-€11.00€0.00matched
22capture01a1994f-6a6e-7506-a36e-364dd89b5e56€24.00€0.37matched
23capture01a1994f-77e6-713c-a89f-4f22c3cbf8c3€35.00€0.50matched
24capture01a1994f-8a66-706c-972d-e8bff1ec8660€9.00€0.19matched
25capture01a1994f-8a8f-7e6c-8668-df8a0e585418€9.00€0.19matched
26capture01a1994f-a235-7910-ba5d-f64f1cab58f7€49.00€0.67matched
27capture01a1994f-b151-7777-aebd-8e506c97e4a8€35.00€0.50matched
28capture01a1994f-b35a-731e-ae2d-b2283d76b954€15.00€0.26matched
29capture01a1994f-b669-7a5f-a0b6-bc3b4002d5f4€49.00€0.67matched
30refund01a1994f-c046-7e96-a078-ffa976032d56-€7.00€0.00matched
31refund01a1994f-d092-7608-928c-383f91bf173b-€31.00€0.00matched
32capture01a1994f-ecd1-7f75-87fa-da4dba1d2b75€9.00€0.19matched
33capture01a1994f-f513-7827-8906-3613313b5b70€9.00€0.19matched
34capture01a19950-0a11-7756-8b1e-46f5439c9847€9.00€0.19matched
35capture01a19950-0e8a-74ba-83d9-3dcbecf804de€49.00€0.67matched
36refund01a19950-3a86-7cce-ab02-84d07dd4df5d-€6.00€0.00matched
37capture01a19950-3c05-7285-a5f3-ecdac4e98dfc€24.00€0.37matched
38capture01a19950-4953-7b00-8a77-68f8954327b9€15.00€0.26matched
39capture01a19950-479c-7692-ae0d-a582536ca233€9.00€0.19matched
40capture01a19950-5f8b-72ef-9c28-65e459199f82€49.00€0.67matched
41capture01a19950-6030-742d-8169-b5f23bdb8a09€24.00€0.37matched
42capture01a19950-793d-70d5-aca2-ce7cdfbb8d8c€49.00€0.67matched
43capture01a19950-7f7f-74cd-9356-2165cc38e00c€35.00€0.50matched
44capture01a19950-a1c9-78a0-95c9-af26f1d89188€35.00€0.50matched
45capture01a19950-a7b8-776f-b7cd-21e543239cca€49.00€0.67matched
46capture01a19950-a9ec-783d-8f20-3b417c208a1a€49.00€0.67matched
47capture01a19950-ad5f-70de-932c-73762078cb9c€15.00€0.26matched
48capture01a19950-b317-7eb0-b236-1554ee7b56c7€15.00€0.26matched
49refund01a19950-e111-7ed5-aff7-a7313a28c449-€26.00€0.00matched
50capture01a19950-fe5f-7a54-b915-6927e987c950€15.00€0.26matched
51capture01a19951-26af-7b73-a3a5-a4a7988672f1€49.00€0.67matched
52capture01a19951-41ce-7413-9147-983280bb523d€49.00€0.67matched
53capture01a19951-554c-7dc0-aa96-c16512ba6fd4€35.00€0.50matched
54capture01a19951-7439-7929-93e2-922e297af4a9€49.00€0.67matched
55capture01a19951-828f-70a6-bce6-7d68363a4759€15.00€0.26matched
56capture01a19951-8705-75fa-b430-bf756997ef94€24.00€0.37matched
57capture01a19951-99c7-7d23-bf2e-f26400363b0f€9.00€0.19matched
58capture01a19951-d5b9-7e17-b0ba-fe7ccd214f38€49.00€0.67matched
59capture01a19951-d972-7bb2-b03e-29f2077296ec€24.00€0.37matched
60refund01a19951-f53c-7ba5-b36e-91f41f9cc577-€5.00€0.00matched
61capture01a19951-f89f-74f8-b2b0-899d5fc8f4de€24.00€0.37matched
62capture01a19952-5647-7f0c-95a9-342e5073311c€15.00€0.26matched
63capture01a19952-7eb7-78ba-be80-2da8b81a5696€15.00€0.26matched
64capture01a19952-9048-7ce1-9638-fb417bdfe34e€15.00€0.26matched
65capture01a19952-9cb7-79da-864f-f3c57e5d80e5€49.00€0.67matched
66capture01a19952-a6f7-736b-998b-011ec9fa2b71€24.00€0.37matched
67capture01a19952-d570-7203-b46f-a17d9b36bc92€24.00€0.37matched
68refund01a19952-d83d-78fd-82d4-d0159c18b6c8-€8.00€0.00matched
69capture01a19952-e792-77ef-a99f-a2552e18abb8€49.00€0.67matched
70capture01a19952-f15d-7d77-96b4-97dba4efaf6a€35.00€0.50matched
71capture01a19952-f393-7962-a8e1-259467d6b59a€49.00€0.67matched
72capture01a19953-0bf0-772f-b3da-497f16b5724e€49.00€0.67matched
73capture01a19953-0e25-7218-b7f9-2c08eb07b9bc€24.00€0.37matched
74capture01a19953-14e7-79ea-834c-a6204474d7d7€15.00€0.26matched
75capture01a19953-1d9d-7eaa-b5cd-219a2b2d4540€15.00€0.26matched
76capture01a19953-380f-7cc4-99d3-e0bf53771c38€35.00€0.50matched
77capture01a19953-5e02-7ce9-9b2d-68df9aa1d6db€15.00€0.26matched
78capture01a19953-7caa-77af-86f2-ac9aec6c8adc€24.00€0.37matched
80capture01a19953-9664-74c3-859b-0ce29c31da46€15.00€0.26matched
81capture01a19953-a09f-7052-8037-25ae7d93e2a3€35.00€0.50matched
82capture01a19953-ba6c-70d6-b514-d926ad443051€9.00€0.19matched
83capture01a19953-c564-7d7a-a4c4-59b8890372a8€15.00€0.26matched
84refund01a19953-cc59-7e5d-a1ac-2a524b119585-€3.00€0.00matched
85capture01a19954-026f-76d2-890e-186584482349€24.00€0.37matched
86capture01a19954-02d2-7fc1-810b-b14d55581f20€24.00€0.37matched
87capture01a19954-036e-706c-8021-a06238ec8607€15.00€0.26matched
88capture01a19954-1da6-7e6a-8629-fccef970fdde€24.00€0.37matched
89capture01a19954-2248-7f07-acea-c2501749b455€15.00€0.26matched
90capture01a19954-2754-7e0c-bdca-5618473c2c60€24.00€0.37matched
91capture01a19954-2883-727d-9376-9814f21fd790€24.00€0.37matched
92capture01a19954-3334-7cfa-8cfb-f1de07f3a8c2€49.00€0.67matched
93capture01a19954-74bf-7d3d-b9ca-889186027106€15.00€0.26matched
94refund01a19954-8624-7586-b367-d0757d0d1074-€6.00€0.00matched
95capture01a19954-8767-7264-b45f-f18755226229€9.00€0.19matched
96capture01a19954-8d26-7545-9c1f-30b8cc3c76b6€49.00€0.67matched
97capture01a19954-97da-7001-806c-c4b50992a948€15.00€0.26matched
98capture01a19954-b8be-75b2-b6b5-c88adc8746d1€24.00€0.37matched
99capture01a19954-c23f-776d-9b2a-9068211a878f€9.00€0.19matched
100capture01a19954-c49f-7d68-8141-fcde15d796a7€35.00€0.50matched
101capture01a19954-c0a5-74e1-afa1-2c337fe9166a€35.00€0.50matched
102capture01a19954-c62d-78d2-b344-a43ca0bcd0e8€35.00€0.50matched
103capture01a19954-cac1-7479-9692-3645bb306a96€35.00€0.50matched
104capture01a19954-d982-7985-8da6-ddbd46fd3030€35.00€0.50matched
105capture01a19954-ea47-7f78-86a3-fdce5cb1ea52€35.00€0.50matched
106capture01a19955-213f-7933-8bb9-14caebe0f4d1€24.00€0.37matched
107capture01a19955-337b-7086-b779-88f133d9865d€15.00€0.26matched
108capture01a19955-3a1e-78ee-bcf4-24b5b0e4d32f€24.00€0.37matched
109capture01a19955-425a-773c-a9a0-a6f34f3bd265€9.00€0.19matched
110capture01a19955-5e0d-7127-86e7-388e153a6d4a€24.00€0.37matched
111capture01a19955-6dbf-7b40-8139-e73b09afc200€9.00€0.19matched
112capture01a19955-7afa-77f3-86da-26e7cbd322f6€35.00€0.50matched
114capture01a19955-81b6-736e-81f4-5e84a222c285€9.00€0.19matched
115capture01a19955-8d9f-767f-bc2a-2edbb82db63f€9.00€0.19matched
116capture01a19955-92f7-7327-bd4d-4150ab572a6c€49.00€0.67matched
117capture01a19955-b39b-74b6-9476-4f69d4d2c065€49.00€0.67matched
118capture01a19955-b91a-79bf-b11c-f3dc7b5d44e8€49.00€0.67matched
119capture01a19955-c7c7-76d6-a9a4-17d02288a297€15.00€0.26matched
120capture01a19955-d373-7e0e-97d3-ae97936f2be6€15.00€0.26matched
121capture01a19955-de29-71fc-9de1-6df49f8ff42b€15.00€0.26matched
122capture01a19955-e9ef-7988-b779-8fb2df1192bc€15.00€0.26matched
123capture01a19955-f8f4-791d-b2ff-8f6dbb94ee5b€15.00€0.26matched
124refund01a19956-06b8-75af-b017-183e57984dbd-€33.00€0.00matched
126capture01a19956-2679-763c-a3b3-b6b0d3a1a279€24.00€0.37matched
127capture01a19956-3429-700a-89f3-e14b5ec53aaa€49.00€0.67matched
128capture01a19956-4043-76c8-b07c-660b47c53400€15.00€0.26matched
129capture01a19956-44e4-7e75-ac6f-f8ef7c675b01€15.00€0.26matched
130capture01a19956-61e0-724b-87ae-a2418197b683€35.00€0.50matched
131capture01a19956-67b1-7d7d-bef8-5d831a4c5ae0€9.00€0.19matched
132capture01a19956-6ed1-7a7e-a888-1148e2e4fa95€9.00€0.19matched
133capture01a19956-9434-7ea4-adf8-6864673db780€49.00€0.67matched
134capture01a19956-9e6b-74cb-b422-3d1166b3bf80€9.00€0.19matched
135capture01a19956-b4d6-74ec-a62e-4bcebb4f59be€9.00€0.19matched
136capture01a19956-bac2-70b8-a0f6-283d2fec06ad€24.00€0.37matched
137capture01a19956-c9c0-7518-8b59-470617be6fbf€9.00€0.19matched
138capture01a19956-cac2-7724-b70f-b45b7a453ca3€9.00€0.19matched
139capture01a19956-cb5f-7a0d-8a33-195066f904d8€24.00€0.37matched
140capture01a19956-cedb-7746-bfc8-4e3b75048d08€9.00€0.19matched
141capture01a19956-cf3f-7382-b432-95e217ee8ca0€24.00€0.37matched
142capture01a19956-d345-727d-8b91-70a7ce903739€24.00€0.37matched
143capture01a19956-d428-7755-b10d-1783580fcf49€35.00€0.50matched
144capture01a19956-d58f-73f5-a00c-97afa7280783€49.00€0.67matched
145capture01a19956-fd93-70a1-9cbd-ddddc57bd887€15.00€0.26matched
146capture01a19957-14b7-75f4-97e1-4fb47f0b9bff€15.00€0.26matched
147capture01a19957-3852-7bb0-902d-9f351c7ebe8c€35.00€0.50matched
148refund01a19957-3aba-730f-9b36-1995ec20a752-€10.00€0.00matched