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

Gross

€3,237.00

PSP fee

€51.60

Net to the bank

€3,185.40

Settlement journal

#386611

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a894-1dfb-7f46-aa6a-b7d834d94f04 is already settled by stl_EUR_2989716 line 19
  • duplicate linethe file lists it twicecapture:01a1a899-ee75-7488-8c66-9f6c59bee70c is already settled by stl_EUR_2989716 line 103
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • missing linein the books, not in the filecapture:01a1a89c-65b0-7544-9ab0-463d5aa969e3 is in no file
LineKindReferenceGrossFeeStatus
9capture01a1a893-b9d4-7f9e-9888-743efeffd751€15.00€0.28fee difference
20capture01a1a894-1e24-779d-8eb5-46dc9474a3dd€24.00€0.37duplicate line
50capture01a1a896-150d-7e1f-8190-37978280ebc3€15.00€0.29fee difference
61capture01a1a897-0048-7001-824f-c90d472585ae€24.00€0.38fee difference
104capture01a1a899-eeb3-7137-a2f2-b46e1c0a44dd€35.00€0.50duplicate line
1capture01a1a88a-d9af-7827-8175-2baea6f39919€49.00€0.67matched
2capture01a1a88c-c079-744d-8f24-cd8da40c1926€24.00€0.37matched
3capture01a1a893-7279-7da3-8436-54600b5ee4aa€35.00€0.50matched
4capture01a1a893-83e9-7abe-a6d6-389abc3e4439€9.00€0.19matched
5capture01a1a893-992d-7126-8e92-6d8c7a36f1ee€35.00€0.50matched
6capture01a1a893-b496-7cd3-9692-e8c04fabcc40€24.00€0.37matched
7capture01a1a893-b4cd-7052-be11-780396cc2b7e€24.00€0.37matched
8capture01a1a893-b94a-7519-a973-804014c3fab6€24.00€0.37matched
10capture01a1a893-c936-785a-82af-27fea2265236€49.00€0.67matched
11capture01a1a893-cf72-72f5-8758-9dabcaa2c96a€24.00€0.37matched
12capture01a1a893-d750-75ab-a1a0-0a7779dc7cbb€9.00€0.19matched
13capture01a1a893-ddb4-7636-8aff-0e46ff50b3c9€15.00€0.26matched
14capture01a1a893-f2d3-7f59-9d86-065a0f35a8f1€49.00€0.67matched
15refund01a1a893-f78a-72a6-86ea-624ddd5d8adb-€11.00€0.00matched
16capture01a1a894-0a4c-74a2-9ae0-71d63f50de39€49.00€0.67matched
17capture01a1a894-0e2e-7831-9dfe-166b0d6019f5€9.00€0.19matched
18capture01a1a894-181d-7ce2-bdf7-026120ed467f€35.00€0.50matched
19capture01a1a894-1e24-779d-8eb5-46dc9474a3dd€24.00€0.37matched
21capture01a1a894-31b0-7478-bc62-ea4a9320e328€9.00€0.19matched
22capture01a1a894-437d-7756-af81-ce7fbbcc30ac€24.00€0.37matched
23capture01a1a894-5c85-739a-97ff-70ef35e072f4€49.00€0.67matched
24capture01a1a894-6529-7eb3-8d0c-e3a703e4e26c€9.00€0.19matched
25capture01a1a894-855e-78f1-9fb0-725ddf8bfbdf€35.00€0.50matched
26capture01a1a894-8612-7a17-994e-6712d74e68d2€35.00€0.50matched
27capture01a1a894-92e4-7312-84b3-b794e3a0727d€24.00€0.37matched
28capture01a1a894-9d36-7431-94e6-2d33122f2e6e€35.00€0.50matched
29capture01a1a894-a147-7d1d-860d-ab956c2e6f36€35.00€0.50matched
30refund01a1a894-a76f-731b-9432-d39ba8771036-€5.00€0.00matched
31refund01a1a894-bdec-7a9c-ad74-fb6f369c0d93-€6.00€0.00matched
32capture01a1a894-c5de-7e29-9c6a-eea5a3372061€24.00€0.37matched
33capture01a1a894-e6cf-77d1-aab4-c781f3ac0e3d€9.00€0.19matched
34capture01a1a894-eab7-703c-b303-a5721e55150d€49.00€0.67matched
35capture01a1a894-f876-7365-b225-1d60263cd6ed€35.00€0.50matched
36capture01a1a895-08d0-74c0-b0b5-f9cdcb42a132€49.00€0.67matched
37capture01a1a895-3c0d-7305-a56f-316f49eb65b5€9.00€0.19matched
38refund01a1a895-45b8-7341-a8ed-ccb19fece784-€5.00€0.00matched
39refund01a1a895-47bd-7ecd-8534-6dece1412a60-€33.00€0.00matched
40capture01a1a895-5f3a-739a-9064-26014c1d0f53€9.00€0.19matched
41capture01a1a895-64ec-74a9-a36e-aea9d5d5cc7e€24.00€0.37matched
42capture01a1a895-7d41-7426-a9b1-37dc9d915f86€15.00€0.26matched
43capture01a1a895-8a42-7f53-b028-bbb43a957599€49.00€0.67matched
44capture01a1a895-9303-7413-bff6-dd3188d71990€15.00€0.26matched
45capture01a1a895-d83b-72c0-97d4-af119ac83f84€9.00€0.19matched
46refund01a1a895-de03-7ee6-a99f-f7298abec397-€6.00€0.00matched
47capture01a1a895-ea4c-70cf-b644-efdb3ebbd040€49.00€0.67matched
48capture01a1a895-fc22-75f5-945f-403ef2f27222€15.00€0.26matched
49capture01a1a896-099e-7bfd-9506-7241258b8acc€35.00€0.50matched
51capture01a1a896-394f-77a6-a36c-92bd66836e79€15.00€0.26matched
52capture01a1a896-443a-7c51-bd51-597becc6cf8e€24.00€0.37matched
53capture01a1a896-5052-72a9-8dac-5c6eb8286846€9.00€0.19matched
54refund01a1a896-6a29-790f-99f8-a9bbce34e29b-€15.00€0.00matched
55capture01a1a896-8901-7ed9-bd6d-4a2e521b5ec5€35.00€0.50matched
56capture01a1a896-94bb-7912-995a-93611d1d8bc4€24.00€0.37matched
57capture01a1a896-b24d-70bd-8c45-49a4bb8b5ba3€24.00€0.37matched
58capture01a1a896-d9d4-74c6-9362-4fc5393e8142€9.00€0.19matched
59capture01a1a896-e4dd-74bf-959d-59503ae2fbc8€24.00€0.37matched
60capture01a1a896-efdd-7a0a-bbd3-5b7e59123966€24.00€0.37matched
62capture01a1a897-0187-7709-8be4-c1fe7aecfbab€9.00€0.19matched
63capture01a1a897-24b7-7553-9745-408d8e09ed3d€9.00€0.19matched
64capture01a1a897-4913-7c98-85ba-098bb5c5ead1€9.00€0.19matched
65capture01a1a897-55a2-7c65-a1ea-0c89d7dd6cf0€49.00€0.67matched
66capture01a1a897-66b3-7431-9738-a0fb0e26c639€24.00€0.37matched
67capture01a1a897-86cd-7686-b7b2-63eb8d3f02f6€49.00€0.67matched
68capture01a1a897-9588-74e8-87e8-562edb809388€35.00€0.50matched
69capture01a1a897-9948-71db-8458-f25d84de1dc9€24.00€0.37matched
70capture01a1a897-abe2-700f-a395-ec3dd1aeda69€35.00€0.50matched
71capture01a1a897-ea5b-7ceb-8c34-096dfb0e3a93€24.00€0.37matched
72capture01a1a897-f0b5-7470-890e-f3e8346acd0f€24.00€0.37matched
73capture01a1a897-f5b3-78a0-b37f-b63d65fcea90€15.00€0.26matched
74capture01a1a897-f5e6-7b84-a4f5-e7870466b9c4€9.00€0.19matched
75capture01a1a898-0441-70d5-bb9c-508bd7ba8bad€35.00€0.50matched
76capture01a1a898-0df2-71b5-b8cd-9fa6ed3fbd14€15.00€0.26matched
77capture01a1a898-27ca-7560-9e8b-891b3e390a07€35.00€0.50matched
78capture01a1a898-59f6-71c2-a4d2-38276579f6b9€35.00€0.50matched
79capture01a1a898-5dec-7052-b1f3-5ea885b02e72€9.00€0.19matched
80capture01a1a898-77a1-7383-9b66-d08f7f4808e2€9.00€0.19matched
81capture01a1a898-9025-701a-9256-2563b1243290€49.00€0.67matched
82capture01a1a898-c11d-7388-9a96-f12a283f6314€9.00€0.19matched
83capture01a1a898-c32f-7120-bf05-a6094385db64€35.00€0.50matched
84capture01a1a898-c3e5-7f89-bc44-59082330c0ae€15.00€0.26matched
85capture01a1a898-e800-77fc-8d79-c8d860f3ee7b€49.00€0.67matched
86capture01a1a898-e45d-7853-b806-58691a06e1df€15.00€0.26matched
87capture01a1a898-f8e3-7564-b7fe-bc4a00aac9d1€15.00€0.26matched
88capture01a1a899-0e73-7908-a23f-eeaa6efae68b€49.00€0.67matched
89capture01a1a899-1e2b-7281-8c37-a2796543cb11€15.00€0.26matched
90capture01a1a899-238b-7d66-b060-da7b55f4776d€24.00€0.37matched
91capture01a1a899-2ae9-778a-9b68-e54d8d6e5d39€49.00€0.67matched
92capture01a1a899-365a-79ba-ab78-a60f9c1cd0a8€15.00€0.26matched
93capture01a1a899-5bb7-784c-aa98-70202a5cf649€24.00€0.37matched
94refund01a1a899-5ee0-700b-8dc8-b4d1dfa5bac2-€11.00€0.00matched
95capture01a1a899-6d1b-7f04-a174-36a7a4386a3a€9.00€0.19matched
96capture01a1a899-7d58-76ed-9e75-ab56dabd8ee4€49.00€0.67matched
97capture01a1a899-8e4f-7397-9a31-f9d9f708ef80€35.00€0.50matched
98capture01a1a899-9847-79fb-8303-c3eb5ce9714b€15.00€0.26matched
99capture01a1a899-9ea1-77af-b335-31656a10188d€35.00€0.50matched
100capture01a1a899-b3fd-7628-ba1c-dd2c78d12e75€15.00€0.26matched
101capture01a1a899-d868-7333-8e49-8c1f43b3212d€24.00€0.37matched
102capture01a1a899-dfb6-77d2-851e-67c783df4f7e€49.00€0.67matched
103capture01a1a899-eeb3-7137-a2f2-b46e1c0a44dd€35.00€0.50matched
105refund01a1a89a-21c9-72dc-bb48-a909fc63b55f-€7.00€0.00matched
106capture01a1a89a-2af2-7e7e-88aa-3049da336b91€9.00€0.19matched
107capture01a1a89a-3b2c-7e50-b168-0067a76e26ce€35.00€0.50matched
108capture01a1a89a-5676-70cb-a9f0-650129555f46€35.00€0.50matched
109capture01a1a89a-5817-753d-994c-12f5930c5275€15.00€0.26matched
110capture01a1a89a-656b-7c15-a391-5b01a7c44aed€15.00€0.26matched
111capture01a1a89a-7182-7b68-8ab7-2e8e0960abd3€9.00€0.19matched
112capture01a1a89a-705c-7e92-8d03-fd610f0801db€9.00€0.19matched
113capture01a1a89a-7ab2-7e97-a313-d9f8ef16c014€35.00€0.50matched
114capture01a1a89a-8494-74c6-a924-198653d2def1€24.00€0.37matched
115capture01a1a89a-8c79-7e01-9312-e7ba601ee27c€49.00€0.67matched
116capture01a1a89a-9ac0-7d59-9756-ccf95084ec84€9.00€0.19matched
117capture01a1a89a-9c92-74f4-a979-a22d4d1eb9c7€15.00€0.26matched
118refund01a1a89a-af77-7b75-be21-b1b8010eb780-€23.00€0.00matched
119capture01a1a89a-b3f7-7936-b9af-a5fa668d3842€15.00€0.26matched
120capture01a1a89a-c0ec-71a4-970d-bf84fe658dd2€24.00€0.37matched
121capture01a1a89a-ee37-7e1f-bec5-5a0287f7eaed€9.00€0.19matched
122capture01a1a89a-ffa6-74e7-adde-1e064f5182fd€15.00€0.26matched
123capture01a1a89b-08af-7363-b929-944e54c90741€24.00€0.37matched
124capture01a1a89b-1e2d-70f0-8b6c-43f785d79efa€24.00€0.37matched
125refund01a1a89b-1fe7-78ae-8650-293524901bbd-€12.00€0.00matched
126capture01a1a89b-3266-7895-bf39-82f1aaf348ae€49.00€0.67matched
127capture01a1a89b-3cad-76c9-a825-d173605ab23c€24.00€0.37matched
128capture01a1a89b-4aef-73ea-a83c-6c6d3a08161d€24.00€0.37matched
129capture01a1a89b-51d0-7d3a-9eec-bec113ee3bb2€9.00€0.19matched
130capture01a1a89b-6c53-77da-9d27-215a57445e0f€15.00€0.26matched
131capture01a1a89b-6d27-755d-ab7c-3063986f9402€35.00€0.50matched
132capture01a1a89b-7840-7cee-af04-b72659b33ed6€49.00€0.67matched
133capture01a1a89b-9ceb-7941-ba2f-84a892d1cffc€9.00€0.19matched
134capture01a1a89b-afac-7ced-8c6f-57b3d1d67757€9.00€0.19matched
135capture01a1a89b-ff90-7732-b112-e84d9c727534€9.00€0.19matched
136capture01a1a89c-1e10-757d-9f2c-3342b7835724€9.00€0.19matched
137capture01a1a89c-4c52-7cbf-b52c-99b4b08719ad€49.00€0.67matched
138capture01a1a89c-672a-787e-84f6-3f1fa62a3940€24.00€0.37matched
139capture01a1a89c-6c5c-72c5-8be9-0d4ab4c06ce9€49.00€0.67matched
140capture01a1a89c-6cae-76df-908e-7c817afe00bf€49.00€0.67matched
141capture01a1a89c-6d30-7047-981a-e15124037033€24.00€0.37matched
142capture01a1a89c-7a2d-716e-b4bc-6eb2805cd9cd€35.00€0.50matched
143capture01a1a89c-8a2c-75ef-88a6-be45413a8f31€9.00€0.19matched
144refund01a1a89c-96d7-7603-9599-fc41a1736902-€23.00€0.00matched
145capture01a1a89c-9e30-7ceb-8079-0abe12dbe227€24.00€0.37matched