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, 16:40

Gross

€2,678.00

PSP fee

€43.59

Net to the bank

€2,634.41

Settlement journal

#382491

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a776-6351-744f-ae24-5575d3ec7c5b is already settled by stl_EUR_2989684 line 104
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
LineKindReferenceGrossFeeStatus
29capture01a1a770-525b-7f78-81d7-ac73beedc0fa€9.00€0.20fee difference
105capture01a1a776-7271-7a42-a016-7c632079297b€35.00€0.50duplicate line
1capture01a1a769-2250-75ed-ada8-987da9204d5e€49.00€0.67matched
2refund01a1a76b-a462-7f2a-acfa-9f3737245b58-€8.00€0.00matched
3capture01a1a76e-8ea8-76da-ba29-1e1e3c035d6d€35.00€0.50matched
4capture01a1a76e-9aeb-73ce-8d23-b22023c9d4ff€49.00€0.67matched
5capture01a1a76e-a557-70d3-834b-899cf0849534€15.00€0.26matched
6capture01a1a76e-bcd3-74fd-8637-457407e2c611€15.00€0.26matched
7capture01a1a76e-c57a-7c07-abe8-da25bb1e9d39€9.00€0.19matched
8capture01a1a76e-d8ba-7d66-83f9-2bc9d0535649€9.00€0.19matched
9refund01a1a76e-db0e-795d-8bd9-6506c7b7f105-€26.00€0.00matched
10capture01a1a76e-de2f-79f8-8ae3-919b179757b7€49.00€0.67matched
11capture01a1a76e-eaa0-7e73-869f-11a5ca504e9c€9.00€0.19matched
12capture01a1a76e-f090-702e-9e2f-ea46a1f312fc€9.00€0.19matched
13capture01a1a76e-e93c-7d2d-92df-5b36668514c4€15.00€0.26matched
14capture01a1a76f-1d96-7cb3-b0ce-bc7663567b7b€49.00€0.67matched
15capture01a1a76f-32e9-7815-a17d-95405ab7c63b€15.00€0.26matched
16capture01a1a76f-71c0-73c3-be18-ce5e7ca8ebac€15.00€0.26matched
17capture01a1a76f-7333-7e1c-b3b6-a05bc6008309€49.00€0.67matched
18capture01a1a76f-7849-7748-80f5-831c06364405€15.00€0.26matched
19refund01a1a76f-7eb8-7358-af3c-8df931a57b1f-€19.00€0.00matched
20capture01a1a76f-cf34-7000-9996-1a1359bb6e0f€15.00€0.26matched
21capture01a1a76f-e296-7cf1-bbcb-14f8b88281ad€35.00€0.50matched
22capture01a1a76f-e581-768c-99e7-366a356fbebc€15.00€0.26matched
23capture01a1a770-0376-7391-b632-fe6259e3b311€24.00€0.37matched
24capture01a1a770-0b19-7043-b7fa-0842db72bfe5€49.00€0.67matched
25capture01a1a770-176f-7d57-9485-d7b1124418a7€24.00€0.37matched
26capture01a1a770-1fa3-70e5-8580-d2d9f0370338€49.00€0.67matched
27capture01a1a770-2c5d-7d37-b9f1-d948a7a68cb3€24.00€0.37matched
28capture01a1a770-51c9-7ec6-aea4-902e0398735f€9.00€0.19matched
30capture01a1a770-54e5-71f5-bb65-2db7cb20a5f9€15.00€0.26matched
31capture01a1a770-65b3-70ae-9eec-514a7a3a9afc€15.00€0.26matched
32capture01a1a770-6913-76f1-95e2-28edfb44d3bb€15.00€0.26matched
33capture01a1a770-6fc8-7cf9-8ef7-67bc24c8dea5€35.00€0.50matched
34capture01a1a770-72c9-77e8-94eb-11345cfced76€24.00€0.37matched
35capture01a1a770-7ad0-7753-98a9-f259f2e9b963€15.00€0.26matched
36capture01a1a770-7ca4-72d2-9c32-0bcf9c42faeb€35.00€0.50matched
37capture01a1a770-9617-7d6f-b694-bc027bcbfb76€15.00€0.26matched
38capture01a1a770-a423-76a7-8707-87be8a7dda1f€9.00€0.19matched
39capture01a1a770-b1f4-7e23-9fda-fd49097e8d6b€15.00€0.26matched
40capture01a1a770-c6c5-7f33-94d5-7c124080c8a0€15.00€0.26matched
41capture01a1a770-ec22-78fb-8fd9-8b7a9e6220da€49.00€0.67matched
42capture01a1a771-3861-78ee-9523-2d8d8ff76c72€24.00€0.37matched
43capture01a1a771-5084-7e47-973a-78433ea9d5d9€35.00€0.50matched
44capture01a1a771-53d1-7287-a7f2-30e66ff9f9b4€15.00€0.26matched
45capture01a1a771-6e7c-7721-a2f3-3874a7316097€49.00€0.67matched
46capture01a1a771-7039-76db-bdb7-5e14699ab83d€9.00€0.19matched
47refund01a1a771-93ab-7214-bc34-3e547268bfcb-€7.00€0.00matched
48capture01a1a771-94ce-744c-871a-64189eb4ba9d€9.00€0.19matched
49capture01a1a771-a7ba-763a-8b58-c27b04809ae3€35.00€0.50matched
50capture01a1a771-ac88-707c-9f19-eeaa3f58d1a1€9.00€0.19matched
51capture01a1a771-c6d9-7f0f-80a7-c7695147f588€9.00€0.19matched
52capture01a1a771-cd0c-7c36-90b5-55c345a26cef€49.00€0.67matched
53capture01a1a771-e029-754d-a2f3-9e095c0d7f87€35.00€0.50matched
54capture01a1a771-e5f7-7554-92fc-7398d4607334€24.00€0.37matched
55capture01a1a771-ea39-78a0-98cc-30798d1d06b5€49.00€0.67matched
56capture01a1a771-eb8d-7912-b3d1-6b028a5e48b6€9.00€0.19matched
57capture01a1a771-ff75-7111-a31c-070281bcf984€9.00€0.19matched
58capture01a1a772-00ce-7897-9538-350504318597€49.00€0.67matched
59capture01a1a772-1a67-7046-95ea-d25153ca3b3f€15.00€0.26matched
60capture01a1a772-29bb-7fa0-bdf9-d7529f66b61b€35.00€0.50matched
61refund01a1a772-361d-7ec2-bc2d-0326b505f2e5-€14.00€0.00matched
62capture01a1a772-5149-7f07-aedf-ce6ca01e993d€35.00€0.50matched
63capture01a1a772-5966-78f8-b2bc-dec127fe8af7€35.00€0.50matched
64capture01a1a772-6a23-7137-87ae-0273f25680d3€35.00€0.50matched
65capture01a1a772-9336-739d-9fc2-455c10d379e7€24.00€0.37matched
66capture01a1a772-951b-7917-b04b-21199b839c1a€9.00€0.19matched
67capture01a1a772-9a4e-764b-8f34-e0cac0a6d4ea€35.00€0.50matched
68capture01a1a772-a2d4-7880-bb70-5aa152ca56dc€24.00€0.37matched
69capture01a1a772-a3b5-7450-b3d1-449960c8f523€24.00€0.37matched
70capture01a1a772-ab16-7618-8bbb-9cca6961462c€9.00€0.19matched
71capture01a1a772-af69-785c-a0f7-14a65cbe4369€15.00€0.26matched
72refund01a1a772-b1c0-7923-b8ea-0474a88d2286-€18.00€0.00matched
73capture01a1a772-c1a4-7797-b0a2-601638113b10€24.00€0.37matched
74capture01a1a772-d8e6-7299-a912-162d8ecefd0a€9.00€0.19matched
75capture01a1a772-d90f-7e7d-90ad-af35665ca31a€9.00€0.19matched
76capture01a1a773-1e8f-78fd-bca3-8bfa3f19a532€9.00€0.19matched
77capture01a1a773-63df-7133-b2dc-2b29fa54cea8€15.00€0.26matched
78capture01a1a773-c6a2-7a79-8191-abb86cb62b02€49.00€0.67matched
79capture01a1a773-d70d-720b-bbc7-db63b45122b9€15.00€0.26matched
80capture01a1a773-e8a6-7c24-9819-16e735f6c52a€15.00€0.26matched
81capture01a1a773-fd1f-7c86-a8c4-de94f3d5b9f1€15.00€0.26matched
82capture01a1a774-0f86-7a41-ad7e-29cd6ad36c34€9.00€0.19matched
83capture01a1a774-2c52-78be-b16f-cd20b5d4b967€24.00€0.37matched
84capture01a1a774-59b4-7060-976b-0fd61006489f€24.00€0.37matched
85capture01a1a774-6eb8-78ba-b854-34db0dd4431a€24.00€0.37matched
86capture01a1a774-8e5a-76ba-a986-b5f605b272e7€15.00€0.26matched
87capture01a1a774-b10f-7cca-b30a-3ca792bd47b0€49.00€0.67matched
88capture01a1a774-e468-7e28-b5e1-8d217467275b€35.00€0.50matched
89refund01a1a775-02a1-7703-aedb-f52ed7252b4b-€9.00€0.00matched
90capture01a1a775-0b42-724c-a776-52a3de97f7db€49.00€0.67matched
91capture01a1a775-0e75-76cf-ac74-3e0cb9a0d8e4€35.00€0.50matched
92capture01a1a775-2c7d-78ff-8be6-9256eedab0f2€35.00€0.50matched
93capture01a1a775-3165-7ff0-8c47-325a65328e79€15.00€0.26matched
94capture01a1a775-5020-7386-9c31-f7df6abbcc35€49.00€0.67matched
95capture01a1a775-55eb-7c77-bd9f-d53efd1550a0€24.00€0.37matched
96capture01a1a775-51b1-74e9-b011-5485c979b83b€49.00€0.67matched
97capture01a1a775-5afb-7d75-bbdf-1547b874d936€9.00€0.19matched
98refund01a1a775-8ae9-7486-8864-b97011457d3e-€46.00€0.00matched
99capture01a1a776-012d-7721-a83a-87c3326149c1€9.00€0.19matched
100capture01a1a776-12fe-70a0-ac98-379aa46170ad€35.00€0.50matched
101capture01a1a776-2743-79ea-843a-f0fb1bc96dc6€15.00€0.26matched
102capture01a1a776-2858-764d-93e4-5253bfb0b800€9.00€0.19matched
103capture01a1a776-351d-7299-9fad-abf3a5da37b3€9.00€0.19matched
104capture01a1a776-7271-7a42-a016-7c632079297b€35.00€0.50matched
106capture01a1a776-7402-76f4-bbb6-86a079ecefed€15.00€0.26matched
107capture01a1a776-9dd4-71b8-b17b-535849a6ae60€24.00€0.37matched
108capture01a1a776-a6fa-7e28-856f-73eb8151cb42€35.00€0.50matched
109capture01a1a776-b460-7653-af4d-b9e61e826e73€35.00€0.50matched
110capture01a1a776-bd5e-7c41-9164-4450d72ebdc2€15.00€0.26matched
111refund01a1a776-d4ea-7db3-9510-e7dc663d913b-€10.00€0.00matched
112capture01a1a776-e6c8-7396-b2fc-afa0b0e9e1bd€9.00€0.19matched
113capture01a1a776-eab5-7110-9f9f-f5f265a966d3€15.00€0.26matched
114capture01a1a777-1248-77f8-aa9d-b0f92921052d€9.00€0.19matched
115capture01a1a777-2956-7c99-a8d1-08bb47ff5a34€49.00€0.67matched
116capture01a1a777-3b39-7dbf-b0fc-946015a6f65f€24.00€0.37matched
117capture01a1a777-5a40-76ba-9aeb-08548a1b059d€9.00€0.19matched
118capture01a1a777-5de0-7c67-96c8-2b48b14c440e€15.00€0.26matched
119capture01a1a777-6b86-7dbe-a7d8-5a6f9387130d€49.00€0.67matched
120capture01a1a777-771c-7b18-98ea-b236219ab11c€24.00€0.37matched
121refund01a1a777-7f79-771b-acc5-d6f8458f0343-€19.00€0.00matched
122capture01a1a777-85f7-73e9-bf52-82a7deb9cd32€24.00€0.37matched
123capture01a1a777-8c25-7d68-989a-5b1c63dae081€24.00€0.37matched
124capture01a1a777-9618-732f-bdf4-d1ecbd190103€49.00€0.67matched
125capture01a1a777-a9db-7179-8771-812da629a8ca€49.00€0.67matched