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

4 Nov, 13:40

Gross

€2,712.00

PSP fee

€43.25

Net to the bank

€2,668.75

Settlement journal

#380171

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a6cd-0488-7358-b8c4-35bc9ad9d055 is already settled by stl_EUR_2989667 line 3
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
  • missing linein the books, not in the filecapture:01a1a6d0-1fb2-74ab-bc1a-f0b064b93afd is in no file
LineKindReferenceGrossFeeStatus
115capture01a1a6d2-3b79-764c-bebd-466bc188cc7d€35.00€0.51fee difference
120capture01a1a6d2-a595-7ea3-9ac2-2a0fa8410c0e€24.00€0.41fee difference
1capture01a1a6c0-eaf1-76ca-8832-142ec5e873b1€24.00€0.37matched
2capture01a1a6c1-3a73-7059-bdb2-0167043a7fbd€49.00€0.67matched
3capture01a1a6c1-a28a-7d38-90bb-6ce9b88b6e41€15.00€0.26matched
4capture01a1a6c4-0068-7cf4-9dd5-30b988b1553e€15.00€0.26matched
5capture01a1a6c4-2869-7bf6-8f59-b56c5c24d9db€35.00€0.50matched
6capture01a1a6c4-6a32-7ca6-850e-183d1915e763€49.00€0.67matched
7capture01a1a6c8-7b26-76db-be89-3f70ed563f81€15.00€0.26matched
8capture01a1a6c9-cd88-700e-a1f8-46738219b70c€49.00€0.67matched
9refund01a1a6c9-e04b-7f64-a770-f467ae609c36-€4.00€0.00matched
10refund01a1a6ca-1937-7523-afa4-29fc8c358faf-€4.00€0.00matched
11capture01a1a6ca-3443-7a92-8c9e-87d3e9935c53€35.00€0.50matched
12capture01a1a6ca-348c-72f7-a5ca-f19f4ecd217a€24.00€0.37matched
13capture01a1a6ca-3d18-7bf0-852b-962dd1fb02d6€49.00€0.67matched
14capture01a1a6ca-3fa0-7d97-9fb8-a41377ab78b5€35.00€0.50matched
15capture01a1a6ca-6781-7355-ac37-92aa344212dd€35.00€0.50matched
16refund01a1a6ca-6866-7297-9e3c-6ef4455afc69-€13.00€0.00matched
17capture01a1a6ca-bc1d-7431-93b5-bf7501901b16€15.00€0.26matched
18capture01a1a6ca-c046-756c-9600-0cc12d18d50c€49.00€0.67matched
19capture01a1a6ca-de70-7671-9f12-290ed1b1c2a9€9.00€0.19matched
20capture01a1a6cb-2d18-706e-9623-e0862936d15a€35.00€0.50matched
21capture01a1a6cb-3059-7bb1-a4ba-93ee34face07€24.00€0.37matched
22capture01a1a6cb-3da1-7b5b-a142-05f48417c6cd€35.00€0.50matched
23capture01a1a6cb-6008-7eea-b27e-e760096901eb€49.00€0.67matched
24capture01a1a6cb-741c-7890-96c0-b652d32db8f2€15.00€0.26matched
25capture01a1a6cb-7d73-7d50-bb37-53ae634bf43b€24.00€0.37matched
26capture01a1a6cb-9eb0-7810-b562-2a95d5ec7e66€15.00€0.26matched
27refund01a1a6cb-a614-7423-b667-2558851932cb-€23.00€0.00matched
28capture01a1a6cb-c3ab-78d2-8fa9-c11b7092918e€49.00€0.67matched
29capture01a1a6cb-e247-73a7-a571-b9a642227899€9.00€0.19matched
30capture01a1a6cb-f3e0-7473-a0bd-c347b9267bae€24.00€0.37matched
31capture01a1a6cb-fdf7-7d6b-a9c4-8b966be35718€15.00€0.26matched
32capture01a1a6cc-01f8-76cc-acf0-5b8a21c1666b€9.00€0.19matched
33capture01a1a6cc-0567-726c-bc98-3f452a0240fe€9.00€0.19matched
34capture01a1a6cc-1483-7edf-a42c-4c2e2b07fff5€35.00€0.50matched
35capture01a1a6cc-2c38-7e82-a10f-f21b2c8dcb5a€24.00€0.37matched
36capture01a1a6cc-49c3-7957-a3b7-11dc97c543cc€49.00€0.67matched
37capture01a1a6cc-5142-793c-a70e-f7d1c89568ee€9.00€0.19matched
38capture01a1a6cc-bbba-7894-a140-4fcc37a0f396€49.00€0.67matched
39capture01a1a6cc-c485-72ec-b728-6bee48bda85f€15.00€0.26matched
40capture01a1a6cc-ca0b-70cb-bfa4-5c700d506825€49.00€0.67matched
41refund01a1a6cc-ecb0-71c2-91dc-165783899c8a-€29.00€0.00matched
42capture01a1a6cd-0908-7336-bd23-ca6c11abc3ca€15.00€0.26matched
43capture01a1a6cd-129e-7a95-9aed-5c66fc97d519€9.00€0.19matched
44capture01a1a6cd-138f-7b8b-8820-422312f23743€9.00€0.19matched
45capture01a1a6cd-6281-709b-aa12-49b3093bf78a€15.00€0.26matched
46capture01a1a6cd-7233-7fb1-9b9d-943e224c7bc1€9.00€0.19matched
47capture01a1a6cd-b54a-7869-aeb0-ec89f4f72072€24.00€0.37matched
48capture01a1a6cd-ba63-7024-8ca5-bba3ace014b7€15.00€0.26matched
49capture01a1a6cd-bad6-7262-add8-52e4880db96e€24.00€0.37matched
50capture01a1a6cd-cd6d-7037-92ab-d9e52456b31c€15.00€0.26matched
51capture01a1a6cd-dcdc-7b79-b5e9-345c49d5ddde€24.00€0.37matched
52capture01a1a6cd-e007-74b5-8e61-9a3689f1fe48€15.00€0.26matched
53capture01a1a6ce-0b04-710b-841b-372ccb84deda€9.00€0.19matched
54capture01a1a6ce-0b79-7e16-8e5b-be6245d3ac42€9.00€0.19matched
55capture01a1a6ce-0be4-7cd4-85e2-ef189d95cad7€9.00€0.19matched
56capture01a1a6ce-0c69-77f7-aa88-0a7f115c08b5€35.00€0.50matched
57refund01a1a6ce-113e-70ff-abf0-5eea126e14db-€5.00€0.00matched
58capture01a1a6ce-0e99-7079-8d50-1b303decab31€35.00€0.50matched
59capture01a1a6ce-120b-7072-b08c-5cd9afb8b2ea€24.00€0.37matched
60capture01a1a6ce-16b4-7f8a-8981-d0989d570ef6€24.00€0.37matched
61capture01a1a6ce-21d6-74e5-b235-7f4031ccfc37€24.00€0.37matched
62capture01a1a6ce-3470-79b1-8def-62bd282e25c2€9.00€0.19matched
63capture01a1a6ce-3c9a-74f2-8c99-72143c4088b4€15.00€0.26matched
64capture01a1a6ce-3ef7-7dea-ba4c-725827fcaa44€9.00€0.19matched
65capture01a1a6ce-4d2f-7c85-924f-17c2ebafe7df€49.00€0.67matched
66refund01a1a6ce-4e6c-7ccd-8bfe-7df31e54881d-€16.00€0.00matched
67capture01a1a6ce-7aca-7e06-87ee-f098e9fbfe58€49.00€0.67matched
68capture01a1a6ce-8951-78be-ad7e-afca83d6d7b6€9.00€0.19matched
69capture01a1a6ce-8d3b-7935-8364-65eb60296b1b€24.00€0.37matched
70capture01a1a6ce-8dd0-714c-9809-54d335830df7€24.00€0.37matched
71capture01a1a6ce-94f5-7590-9691-b48e348b40aa€35.00€0.50matched
72capture01a1a6ce-ec22-7b79-a45f-458afa316817€9.00€0.19matched
73capture01a1a6cf-1186-77fa-b9c8-a7d71c4d6707€15.00€0.26matched
74capture01a1a6cf-2341-7535-86c0-e110f1e7f571€49.00€0.67matched
75capture01a1a6cf-2db3-779e-9fea-2eb452f40857€35.00€0.50matched
76capture01a1a6cf-49c4-7db4-b9ee-60a6f5eecd50€35.00€0.50matched
77capture01a1a6cf-4b63-76ff-8e53-046a3efa7a20€24.00€0.37matched
78capture01a1a6cf-6c7f-764d-bd52-b13229857f5f€15.00€0.26matched
79capture01a1a6cf-8ea6-75b1-8e93-000fa134f1c7€24.00€0.37matched
80capture01a1a6cf-979c-758c-8230-c430d30a3336€49.00€0.67matched
81refund01a1a6cf-98b7-78c9-8ff4-2a7db66d11e2-€14.00€0.00matched
82capture01a1a6cf-c524-719e-a8f7-d4e6d1d391a8€49.00€0.67matched
83capture01a1a6d0-0145-7c5f-8efa-184cf9998120€15.00€0.26matched
84capture01a1a6d0-5a27-762e-983c-5112301b7272€15.00€0.26matched
85capture01a1a6d0-5c97-76da-a51d-143a5c4ad434€49.00€0.67matched
86capture01a1a6d0-7139-7251-aa3e-ed21337f311f€35.00€0.50matched
87capture01a1a6d0-858c-77fd-8aad-5545124d6fca€49.00€0.67matched
88capture01a1a6d0-89fe-72c6-8226-c13ed6f6d413€49.00€0.67matched
89capture01a1a6d0-a69c-7b4a-8786-96805a98017e€15.00€0.26matched
90capture01a1a6d0-b426-7969-9b70-ca087b614897€35.00€0.50matched
91capture01a1a6d0-b9f1-79cc-9501-b9a441cc0b67€15.00€0.26matched
92capture01a1a6d0-d328-757d-a22b-5a57c861b70e€24.00€0.37matched
93capture01a1a6d0-ee19-7a02-a0eb-4603d8e89519€35.00€0.50matched
94capture01a1a6d0-ef3f-76e3-ad7d-949d30686d9c€35.00€0.50matched
95refund01a1a6d1-095f-7442-8331-831582593149-€10.00€0.00matched
96capture01a1a6d1-0f6d-77bd-a66d-f7c9b6091ccb€24.00€0.37matched
97capture01a1a6d1-2351-7793-b704-7e752d9d4546€15.00€0.26matched
98capture01a1a6d1-42df-78a1-8ac5-187a801a0f1e€15.00€0.26matched
99capture01a1a6d1-4a54-7b4b-ba0c-969481ce138a€15.00€0.26matched
100capture01a1a6d1-57b7-7594-900c-8f113e009323€49.00€0.67matched
101capture01a1a6d1-65b7-78d5-94ad-04a4ed41e753€15.00€0.26matched
102capture01a1a6d1-7b70-7c78-b7f7-44d16077866a€24.00€0.37matched
103capture01a1a6d1-921a-7e97-89dc-d27d49fee59a€24.00€0.37matched
104capture01a1a6d1-9280-757a-93b6-bac94b3310e6€35.00€0.50matched
105capture01a1a6d1-a20d-78d2-b701-8e29c0dbd94d€9.00€0.19matched
106capture01a1a6d1-a35b-7219-94c6-a217e4f8aa9f€35.00€0.50matched
107capture01a1a6d1-ac5c-74a8-9cfe-44291b55c92b€49.00€0.67matched
108capture01a1a6d1-bdd8-7e22-9c1b-c72b98146492€9.00€0.19matched
109capture01a1a6d1-cd85-7fc8-834d-10effce25433€24.00€0.37matched
110refund01a1a6d1-dc8c-7db2-ae7d-3b2abedf0c6e-€19.00€0.00matched
111capture01a1a6d1-e1b2-7021-bdb8-a520b4760f00€9.00€0.19matched
112capture01a1a6d1-f607-7c50-9b75-a08424521a27€35.00€0.50matched
113capture01a1a6d2-02a2-77e1-8195-d049bb7cb149€9.00€0.19matched
114capture01a1a6d2-2c53-71a2-a33c-809abb57914b€9.00€0.19matched
116capture01a1a6d2-3bc2-7dd2-b8a2-708bc2907b8e€24.00€0.37matched
117capture01a1a6d2-5f2f-7787-a194-b15842e78035€9.00€0.19matched
118capture01a1a6d2-6dc0-78d3-924f-0421ceccda0d€24.00€0.37matched
119capture01a1a6d2-6fa4-76e4-9d3f-c060d816942b€35.00€0.50matched
121capture01a1a6d2-b51a-70f6-a3c2-09041cc831a9€9.00€0.19matched