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

Gross

€3,218.00

PSP fee

€50.54

Net to the bank

€3,167.46

Settlement journal

#336899

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19a96-a9c0-730d-97bb-a03e9db1ba40 is already settled by stl_EUR_2989324 line 123
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
  • missing linein the books, not in the filecapture:01a19a93-77df-716d-aa87-724863e0d629 is in no file
LineKindReferenceGrossFeeStatus
47capture01a19a91-9e01-735d-8469-1215f3a8a72b€9.00€0.20fee difference
57capture01a19a92-4c4a-7d74-b953-700d5218925a€35.00€0.52fee difference
66capture01a19a92-a2fa-7c4a-a40d-1508ad76dca4€24.00€0.42fee difference
124capture01a19a96-a9e1-7b95-a187-7ac97b894e11€15.00€0.26duplicate line
1capture01a19a86-11ce-7199-872a-0a59513fee61€9.00€0.19matched
2capture01a19a88-152f-7493-b496-937f5bcdba79€9.00€0.19matched
3capture01a19a8d-3229-7d3e-b8a4-f094211ead6a€49.00€0.67matched
4refund01a19a8e-ab47-770f-8e16-7d2061e1fc3c-€6.00€0.00matched
5capture01a19a8e-b260-713c-b8bb-52be0b32cb63€9.00€0.19matched
6capture01a19a8e-b5bd-71ae-9ecf-468c894954db€49.00€0.67matched
7capture01a19a8e-c3e8-7930-8cbb-a642add90e49€24.00€0.37matched
8capture01a19a8e-d3d8-7158-8dc1-07793c100811€35.00€0.50matched
9capture01a19a8e-e3f1-76ea-abf6-b546d7cab438€35.00€0.50matched
10capture01a19a8e-e52d-74d8-ba80-9a0d56a43621€35.00€0.50matched
11refund01a19a8e-eb4a-75ef-9957-f14de444ed53-€24.00€0.00matched
12capture01a19a8f-0f75-7266-8d5a-8b8e7a102f5b€15.00€0.26matched
13capture01a19a8f-34fe-7ee5-89d5-072553f5dfba€35.00€0.50matched
14capture01a19a8f-38be-7061-b8dd-d48600c37354€35.00€0.50matched
15refund01a19a8f-451a-7410-a25a-d79ab17cbe32-€8.00€0.00matched
16capture01a19a8f-497b-76e7-97e2-0883d8e43212€49.00€0.67matched
17capture01a19a8f-4e61-761a-b752-2111eddf0c09€9.00€0.19matched
18capture01a19a8f-6249-730d-8f1c-c663bda4a5ee€24.00€0.37matched
19capture01a19a8f-8e53-7882-8981-396657e4402a€9.00€0.19matched
20capture01a19a8f-b24f-7c4b-94c8-8c10e75fa2a7€24.00€0.37matched
21capture01a19a8f-e69c-761b-9ded-3386efff6fef€24.00€0.37matched
22capture01a19a8f-f794-7f4a-ac66-d590ac1c6d0a€49.00€0.67matched
23capture01a19a90-1698-7e72-8770-81cf85b3e78d€35.00€0.50matched
24capture01a19a90-1923-79bf-9aca-ff47355dddb6€49.00€0.67matched
25capture01a19a90-26ba-7411-a3b3-4def41571573€24.00€0.37matched
26capture01a19a90-2728-75c5-9f02-4090d7427ce1€15.00€0.26matched
27capture01a19a90-328e-7843-ab3a-28de2003e799€15.00€0.26matched
28capture01a19a90-27a2-7dc4-8a1c-4f3442ded679€9.00€0.19matched
29capture01a19a90-42f9-7a53-a0d7-7bbed9b116de€49.00€0.67matched
30capture01a19a90-7ec4-7090-9315-3230f177973b€35.00€0.50matched
31capture01a19a90-8465-794a-bb10-230d6a081b71€24.00€0.37matched
32capture01a19a90-a451-70d8-a9f8-af491d9080df€9.00€0.19matched
33capture01a19a90-afe3-762e-a69a-3f9194d6e63e€15.00€0.26matched
34capture01a19a90-bc7b-7667-8eaa-235af4f1d812€49.00€0.67matched
35capture01a19a90-c929-710a-b633-16b7f2f2f596€35.00€0.50matched
36capture01a19a90-d2af-7c52-89eb-1813f0255e1e€35.00€0.50matched
37capture01a19a91-0d86-765d-9f6b-cd6c2a753d12€35.00€0.50matched
38capture01a19a91-123d-7230-a708-9fea51aba968€9.00€0.19matched
39refund01a19a91-1e46-72fb-95e3-fcc42b22e9c6-€17.00€0.00matched
40capture01a19a91-3c5c-7965-a325-c4635f852112€35.00€0.50matched
41capture01a19a91-4b26-784f-9b67-5a204bc2dd9e€9.00€0.19matched
42capture01a19a91-4d61-7f29-a7a6-fa13918aa004€35.00€0.50matched
43capture01a19a91-7664-73f7-823b-3f2e10838cde€49.00€0.67matched
44refund01a19a91-7d46-7b73-b725-6fb648c95476-€7.00€0.00matched
45capture01a19a91-8dfb-7851-974c-6770ba202b9f€15.00€0.26matched
46capture01a19a91-94f0-7212-b673-c5e7064f5b98€35.00€0.50matched
48capture01a19a91-a6b6-7366-8b18-c27abe195b74€35.00€0.50matched
49capture01a19a91-da16-7f1d-9e66-6c42a36ad9ba€15.00€0.26matched
50capture01a19a91-ee71-7404-8c73-ea4c71e1f56d€49.00€0.67matched
51capture01a19a91-ee90-767b-9a3b-6e56a52fa48b€35.00€0.50matched
52capture01a19a91-f527-7893-a1fe-6e20317383e7€35.00€0.50matched
53refund01a19a92-096a-7cb1-af74-339d16732016-€7.00€0.00matched
54capture01a19a92-2444-7253-8a2f-9e7f3dc374aa€15.00€0.26matched
55capture01a19a92-2493-7834-afce-72277ce8cd3b€15.00€0.26matched
56capture01a19a92-302a-7176-90d9-41731e3b7af9€24.00€0.37matched
58capture01a19a92-57cc-7e9a-bba1-535dbed011ad€15.00€0.26matched
59capture01a19a92-5c5c-7b7b-b01c-dfd6435dbc35€49.00€0.67matched
60capture01a19a92-5dff-7aa0-aac2-0576a9376bf2€24.00€0.37matched
61capture01a19a92-8a8a-7928-9870-03e7441cc427€49.00€0.67matched
62capture01a19a92-914f-7ef2-be54-7ac2d02eddae€15.00€0.26matched
63capture01a19a92-93d1-7908-99dd-1b5bfccd0511€24.00€0.37matched
64refund01a19a92-9a54-7411-99dd-c26a8665af68-€12.00€0.00matched
65capture01a19a92-9eb8-7984-a6b0-2c6e78a1eb51€49.00€0.67matched
67capture01a19a92-a9bd-737f-bda5-5d866520bb6f€49.00€0.67matched
68capture01a19a92-b5d4-7d79-954b-8999c0ebc2f4€9.00€0.19matched
69refund01a19a92-bf7a-7cfa-b7f7-00e7e7f63e63-€19.00€0.00matched
70capture01a19a92-c880-764f-bb67-376dfedba7aa€24.00€0.37matched
71capture01a19a93-0060-726f-9c32-f7d543b88f45€35.00€0.50matched
72capture01a19a93-2422-74a4-9500-a2e24c162e20€24.00€0.37matched
73capture01a19a93-2736-7751-866e-0f6da51b96f8€24.00€0.37matched
74capture01a19a93-6183-7668-a661-37729fe62c41€9.00€0.19matched
75capture01a19a93-7a40-76d1-9d5e-7e3da866e7d7€35.00€0.50matched
76capture01a19a93-8752-7f39-912d-fa8bf95ca598€9.00€0.19matched
77capture01a19a93-8aa8-754a-b11c-e204ecc4e4d6€49.00€0.67matched
78capture01a19a93-900d-7f5d-bfc2-fe63c670a5c9€49.00€0.67matched
79capture01a19a93-a496-71a0-a80c-30d17f4429e3€35.00€0.50matched
80refund01a19a93-b7d2-74ca-bc82-95c51fbf84d6-€9.00€0.00matched
81capture01a19a93-c15b-70d9-8127-a6d1778e120d€49.00€0.67matched
82capture01a19a93-c243-73f3-8974-ef21e8cb72f7€15.00€0.26matched
83capture01a19a93-cf2a-70d7-bb51-f3e803d05a2b€24.00€0.37matched
84capture01a19a93-d0cf-7f79-b7e2-15a6fe248c2e€9.00€0.19matched
85capture01a19a93-d6e4-74fe-b484-86c2cf797acd€9.00€0.19matched
86capture01a19a93-dfee-71a4-a043-293e703ab634€24.00€0.37matched
87refund01a19a93-fb89-7018-96d0-2115cec3ff45-€7.00€0.00matched
88capture01a19a94-01b4-7cc5-9863-3480e3c18e8c€9.00€0.19matched
89capture01a19a94-0d7d-7f1a-bb38-625486b75eae€24.00€0.37matched
90capture01a19a94-183f-7ff0-8c9c-2c127c1dec00€9.00€0.19matched
91capture01a19a94-3920-73fb-b816-e564fab6eab1€15.00€0.26matched
92capture01a19a94-55f7-7080-a646-55de8ce27adb€49.00€0.67matched
93capture01a19a94-82cf-7959-a632-f1747175ad1f€9.00€0.19matched
94capture01a19a94-8f6f-7cf3-ac38-359008db63a8€9.00€0.19matched
95capture01a19a94-c377-759a-a613-245bbbbb759d€15.00€0.26matched
96capture01a19a94-c84a-78b3-a3ff-371482eb9a0e€15.00€0.26matched
97capture01a19a94-e078-7206-88b3-2d51305a355b€24.00€0.37matched
98capture01a19a94-fdf8-7475-96f7-b41892672018€15.00€0.26matched
99capture01a19a95-00b7-7008-b59d-716b9a5de184€49.00€0.67matched
100capture01a19a95-1184-7da5-91e4-340b94807a40€35.00€0.50matched
101capture01a19a95-38fd-78d8-b1fb-f5b74fd63eba€9.00€0.19matched
102capture01a19a95-39f4-7efe-8ac4-880d4d45ffab€15.00€0.26matched
103capture01a19a95-58de-7841-b24d-583197f07704€49.00€0.67matched
104capture01a19a95-872e-7de3-8b48-49655f3d4779€35.00€0.50matched
105capture01a19a95-8b76-7c13-a0df-6656002781d4€9.00€0.19matched
106refund01a19a95-8e8a-74fc-9b96-c0d20014b26a-€6.00€0.00matched
107capture01a19a95-912b-7735-a596-b52daf5ae27a€24.00€0.37matched
108capture01a19a95-93b3-7e29-a12a-2f33d777cb16€15.00€0.26matched
109capture01a19a95-e190-73bb-806a-d468c3851e8b€15.00€0.26matched
110capture01a19a95-daa5-7850-a83c-50b1abf96aaa€15.00€0.26matched
111capture01a19a95-fd29-7432-b188-4666c0b19137€15.00€0.26matched
112capture01a19a96-0816-728e-b0ba-cbc02c489c50€24.00€0.37matched
113capture01a19a96-171b-709b-8427-020c17de43df€15.00€0.26matched
114capture01a19a96-13b1-758b-96ff-903f40f61a0c€49.00€0.67matched
115capture01a19a96-1fb3-7369-a9a6-2a716dcf6e05€35.00€0.50matched
116capture01a19a96-40b0-73c5-88cc-eb3a5ea86af8€15.00€0.26matched
117capture01a19a96-5279-7885-94b4-aa74bb925d3f€24.00€0.37matched
118capture01a19a96-653a-7938-be16-4499cebb9925€15.00€0.26matched
119capture01a19a96-8790-750a-a30f-f79c9bb423e9€24.00€0.37matched
120capture01a19a96-960c-7f96-9f93-4bb38eb09271€24.00€0.37matched
121capture01a19a96-9b42-79ab-bf8b-e494de611191€15.00€0.26matched
122capture01a19a96-a210-7cc7-a4a3-83751c960b10€24.00€0.37matched
123capture01a19a96-a9e1-7b95-a187-7ac97b894e11€15.00€0.26matched
125capture01a19a96-ac7e-7154-a5c1-088915f092be€35.00€0.50matched
126capture01a19a96-d66f-79cf-ac38-d01097b99ed4€35.00€0.50matched
127capture01a19a96-e319-71f9-bccb-42136b5c1b83€15.00€0.26matched
128capture01a19a96-e32e-78b8-9d3b-f9948ab42f77€15.00€0.26matched
129capture01a19a96-f1d8-780e-ab62-24e9f9e0cd18€35.00€0.50matched
130capture01a19a96-f7cd-71d3-89b1-a9b0328906db€35.00€0.50matched
131capture01a19a97-0f14-758e-9e7c-6caecda2b65b€24.00€0.37matched
132capture01a19a97-16ee-7517-bef9-54c527e1a226€24.00€0.37matched
133capture01a19a97-5ead-7e46-8b25-c7604087dd87€35.00€0.50matched
134capture01a19a97-77ef-71d3-bd38-2a3faddfe8ef€24.00€0.37matched
135capture01a19a97-7837-7576-ae61-d9e59e463fe9€24.00€0.37matched
136capture01a19a97-7622-7df7-84a6-74130d29bb6e€24.00€0.37matched
137capture01a19a97-a962-7eaa-838b-ad1282f6363c€15.00€0.26matched
138capture01a19a97-adee-7a09-bd58-90f6167dec67€49.00€0.67matched
139capture01a19a97-afa2-7346-aff7-d846d010d364€35.00€0.50matched