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

2 Nov, 03:30

Gross

€3,096.00

PSP fee

€48.81

Net to the bank

€3,047.19

Settlement journal

#335979

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19a51-bf1f-76c7-93ca-14446336b9c7 is already settled by stl_EUR_2989317 line 51
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • missing linein the books, not in the filecapture:01a19a52-38d4-71cc-894e-9e1e3fb08a46 is in no file
LineKindReferenceGrossFeeStatus
52capture01a19a51-bf4d-7a0f-978d-a38422f1f0dc€49.00€0.67duplicate line
54capture01a19a51-c853-76ab-9cf3-070b21a30a89€24.00€0.39fee difference
1capture01a19a46-ef5c-7324-b7a4-2da339c96df5€49.00€0.67matched
2capture01a19a4a-8fb6-7c38-ac57-8bcc1045c4a1€15.00€0.26matched
3capture01a19a4e-c5a3-75a9-8fa0-36522a3cbaa0€9.00€0.19matched
4refund01a19a4e-c655-7835-8542-48b3391e8a15-€18.00€0.00matched
5capture01a19a4e-c91e-7f24-8c5b-b5cdf962ae9e€15.00€0.26matched
6capture01a19a4e-cf52-7534-8e1c-9077e1a43205€35.00€0.50matched
7capture01a19a4e-d9a7-748f-b068-9c48a5c004e1€35.00€0.50matched
8capture01a19a4e-e597-7e58-b99a-fdf64dd50eb0€35.00€0.50matched
9capture01a19a4e-e597-7be5-8599-1970098da10a€9.00€0.19matched
10capture01a19a4e-eea0-7ebc-af0a-9bf0fa5b8849€15.00€0.26matched
11capture01a19a4f-0531-740e-859c-f66d83b2bc9f€24.00€0.37matched
12capture01a19a4f-11d6-7419-ab8b-0e82f6857b43€49.00€0.67matched
13capture01a19a4f-1398-792b-8ef7-e4a663dcb73f€15.00€0.26matched
14capture01a19a4f-13fd-7788-a593-95425ea8455e€9.00€0.19matched
15capture01a19a4f-19b8-7a69-b6b9-db2e665fc2bb€24.00€0.37matched
16capture01a19a4f-1e6e-741b-baf8-896239006498€49.00€0.67matched
17capture01a19a4f-3110-7585-8223-f537a7be45ac€49.00€0.67matched
18capture01a19a4f-62cc-718c-934b-71ee34e4b1df€24.00€0.37matched
19capture01a19a4f-847c-7fbd-b836-c25747184c51€15.00€0.26matched
20capture01a19a4f-b090-730e-9ab0-5720d8b31132€9.00€0.19matched
21capture01a19a4f-c656-7f30-bd83-949b8d45bc69€49.00€0.67matched
22capture01a19a4f-ecb4-742b-b0dd-6d27f37ccb20€9.00€0.19matched
23capture01a19a50-084f-779a-aba3-53bdcc531d5f€35.00€0.50matched
24capture01a19a50-1593-728b-a6f1-cb8b4b561bf4€24.00€0.37matched
25capture01a19a50-318f-73a1-ba37-271a7bfa039f€9.00€0.19matched
26capture01a19a50-34bf-787f-b291-07d6a05394fe€9.00€0.19matched
27capture01a19a50-4203-77c2-9499-0030ca9e43a2€24.00€0.37matched
28capture01a19a50-4d72-76b2-ac15-3b72621a1f7a€24.00€0.37matched
29capture01a19a50-5fb4-721a-aa7b-5077b3277761€15.00€0.26matched
30capture01a19a50-60a5-7980-8444-b38d29e50511€15.00€0.26matched
31capture01a19a50-88ac-70a0-8ffa-1bf98bda035d€35.00€0.50matched
32capture01a19a50-8cfd-7607-af98-9d479b1e369e€24.00€0.37matched
33refund01a19a50-8f65-7e69-96ab-5a674bc8fff9-€21.00€0.00matched
34refund01a19a50-a02c-7995-85e9-7c920a16883c-€45.00€0.00matched
35capture01a19a50-aa12-7690-ade3-d03976e09976€35.00€0.50matched
36capture01a19a50-bd84-7e54-baf4-dc0343d4f9c6€24.00€0.37matched
37capture01a19a50-dfc2-79bf-9089-30110c0a1125€9.00€0.19matched
38capture01a19a51-15bf-7bbc-adda-cdf929975f7b€49.00€0.67matched
39capture01a19a51-2ccf-7a93-b2d7-2f60ab82e524€35.00€0.50matched
40capture01a19a51-33e3-7227-a793-a2f6efd531e1€15.00€0.26matched
41capture01a19a51-3472-723c-aa8f-65dc57ef8af1€35.00€0.50matched
42capture01a19a51-36fc-72aa-9eca-33a01983f13b€35.00€0.50matched
43capture01a19a51-3af1-7f86-bacb-b428488e1746€35.00€0.50matched
44capture01a19a51-433b-73d2-a314-f50079e08fc9€49.00€0.67matched
45capture01a19a51-5011-719d-9b2b-399341c7cccf€35.00€0.50matched
46capture01a19a51-6be5-76ad-b3c8-dfe696f807d4€49.00€0.67matched
47capture01a19a51-7202-79f4-9226-011a31f0d6bd€15.00€0.26matched
48capture01a19a51-84e8-7e13-97d4-feaf81a92466€35.00€0.50matched
49refund01a19a51-97fb-7823-a9c0-1358f6bf9f36-€35.00€0.00matched
50capture01a19a51-ad79-7062-be3a-58ab6109ea71€24.00€0.37matched
51capture01a19a51-bf4d-7a0f-978d-a38422f1f0dc€49.00€0.67matched
53capture01a19a51-c488-7a2b-864d-89c683b094ac€15.00€0.26matched
55capture01a19a51-cf7a-72b9-a786-1c35817d99b5€24.00€0.37matched
56capture01a19a51-e4ce-7607-8f76-fe88e42d51af€24.00€0.37matched
57capture01a19a52-1d8a-7474-8a0d-f22e19753615€15.00€0.26matched
58capture01a19a52-2046-7e3b-83c6-784a356c0a09€35.00€0.50matched
59capture01a19a52-229e-7ca6-9c1f-1078aa33dbec€49.00€0.67matched
60capture01a19a52-44dc-7e08-985d-06ba7b9e811b€15.00€0.26matched
61capture01a19a52-4626-77fd-9a28-af2defaeed5e€9.00€0.19matched
62capture01a19a52-4749-763b-bf2c-bac977701e7e€49.00€0.67matched
63capture01a19a52-5449-70f1-a4fe-c6db62507a33€9.00€0.19matched
64capture01a19a52-5b81-7502-a80b-03e6941c32af€35.00€0.50matched
65capture01a19a52-5c78-7d17-8252-5347f097c5fe€49.00€0.67matched
66capture01a19a52-6c30-7c9e-8aef-7f1040982c5f€35.00€0.50matched
67capture01a19a52-89ab-7802-a26f-364f51a8baf4€49.00€0.67matched
68capture01a19a52-93b2-733d-b97e-b7b665b644b8€35.00€0.50matched
69capture01a19a52-9bc5-7c57-a562-da6d86e9bba2€49.00€0.67matched
70refund01a19a52-9c3e-798d-b422-ff56c09d3f11-€11.00€0.00matched
71capture01a19a52-c303-7627-b879-7c6207393e02€35.00€0.50matched
72capture01a19a52-c3e4-758e-87bb-887a84eed654€35.00€0.50matched
73capture01a19a52-d542-7774-bd34-6c3af3d33ce6€24.00€0.37matched
74capture01a19a53-5bf2-70ac-9496-c4ed8df069f0€49.00€0.67matched
75capture01a19a53-a8eb-7278-897e-ae9a87540225€35.00€0.50matched
76capture01a19a53-ae3f-76a7-a2c3-0222fe274184€49.00€0.67matched
77capture01a19a53-b61a-74d1-9317-7c391fdffe0d€35.00€0.50matched
78capture01a19a53-d637-759d-89c7-b261b9202b3f€49.00€0.67matched
79capture01a19a53-e85c-781f-ab9f-cf6b9b98562b€9.00€0.19matched
80capture01a19a54-0cd6-749b-bfb9-7e2205348d8b€9.00€0.19matched
81capture01a19a54-115a-708d-951c-3a4f04e9e549€9.00€0.19matched
82capture01a19a54-2bc3-78a0-b1e1-be23a7afaded€9.00€0.19matched
83capture01a19a54-2cff-73c4-9a31-13e0812c9df6€35.00€0.50matched
84capture01a19a54-30df-7e04-9181-1dd52630945d€35.00€0.50matched
85capture01a19a54-315c-7464-8849-5d142fb7ca6c€24.00€0.37matched
86capture01a19a54-32b2-7b9a-afd9-3eb1a0ca1028€49.00€0.67matched
87capture01a19a54-32c1-7311-9247-8467a8523cac€9.00€0.19matched
88capture01a19a54-3b2d-7609-bb28-bb6e980428e6€49.00€0.67matched
89capture01a19a54-3fb1-7738-8375-32f6c57f6a4a€9.00€0.19matched
90refund01a19a54-5866-78e7-a206-6d15b5f21549-€5.00€0.00matched
91refund01a19a54-5ce3-7589-9768-d67e72a3633f-€28.00€0.00matched
92capture01a19a54-7a7a-7f3e-9d4e-32e824b64be6€35.00€0.50matched
93capture01a19a54-9390-7fe4-8251-35476fefaa4b€35.00€0.50matched
94capture01a19a54-af47-7fd6-90d6-3d049a111f14€9.00€0.19matched
95capture01a19a54-b6c8-734c-8d88-e7f5c3c9e57a€24.00€0.37matched
96capture01a19a54-e340-73e3-b635-21fa4847091b€35.00€0.50matched
97capture01a19a54-fafe-7710-91aa-2a53175b81aa€35.00€0.50matched
98capture01a19a55-0c03-792a-a948-7fbc22a4fb08€49.00€0.67matched
99capture01a19a55-1620-75f1-a52b-6eaf7cd38e97€24.00€0.37matched
100capture01a19a55-282b-7ba6-80e1-413b2837e38b€15.00€0.26matched
101capture01a19a55-3fa6-75d4-bde7-8026a1382ff4€24.00€0.37matched
102capture01a19a55-4d27-74b2-a661-44387e6eed68€49.00€0.67matched
103capture01a19a55-6676-7915-bc1c-b1ba3fec45c0€24.00€0.37matched
104capture01a19a55-7bdd-7e76-939b-4a521571aa5d€49.00€0.67matched
105capture01a19a55-cdf9-78f5-8975-aa84bca87e98€15.00€0.26matched
106capture01a19a55-ed40-74c4-b30e-fe7a93cb420c€49.00€0.67matched
107capture01a19a55-ef43-7fb0-a652-3819b2709372€15.00€0.26matched
108capture01a19a55-f784-70e3-a14e-d97d0110d3fb€24.00€0.37matched
109capture01a19a56-0324-7589-a7c6-c33d24dc830f€35.00€0.50matched
110capture01a19a56-0610-7fd3-a8b2-709211832f0a€24.00€0.37matched
111capture01a19a56-1788-7b55-a596-54a77fdff083€49.00€0.67matched
112capture01a19a56-20de-7f67-8bfd-b4659dc821e0€49.00€0.67matched
113refund01a19a56-30a7-7807-bc03-826b3c914f26-€19.00€0.00matched
114capture01a19a56-89af-7841-bf45-941051af8107€15.00€0.26matched
115capture01a19a56-9018-793f-8ada-e66852f3ce63€35.00€0.50matched
116capture01a19a56-d2d1-72a0-9121-2d1eea776b27€15.00€0.26matched
117capture01a19a56-f783-7894-bc9f-046fcfd46737€49.00€0.67matched
118capture01a19a57-188a-77ab-b172-1917531582a7€15.00€0.26matched
119capture01a19a57-24ab-7ecd-8961-8b78aac78e1e€15.00€0.26matched
120refund01a19a57-2da4-7649-88ef-cfc724a308c2-€9.00€0.00matched
121capture01a19a57-2e1e-7021-a03b-75e375cea552€15.00€0.26matched
122capture01a19a57-41c7-75c1-ba3f-d551ce80ed22€24.00€0.37matched
123refund01a19a57-7f1c-7a6d-af5b-98a3eb6d71d0-€8.00€0.00matched
124capture01a19a57-ac2a-7185-8a7a-007b21564a71€35.00€0.50matched