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

5 Nov, 09:30

Gross

€2,770.00

PSP fee

€44.42

Net to the bank

€2,725.58

Settlement journal

#395357

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • missing linein the books, not in the filecapture:01a1ab0c-3d84-7f48-a371-87e6b05cd64e is in no file
LineKindReferenceGrossFeeStatus
36capture01a1ab0d-22f0-79a6-9416-7b6a8fe23966€15.00€0.28fee difference
1capture01a1ab04-3789-767e-8d39-5eab2cef32ed€35.00€0.50matched
2capture01a1ab04-8a66-71f3-8b40-48ae33a04fa5€49.00€0.67matched
3refund01a1ab0b-437f-7f7a-87f3-11b0e2f7135e-€13.00€0.00matched
4capture01a1ab0b-43e4-7d59-b7ee-2c7902e90542€9.00€0.19matched
5refund01a1ab0b-45e1-757c-a6f0-cc2f148cd1b2-€9.00€0.00matched
6capture01a1ab0b-4aed-7130-b6ba-a91276026be3€49.00€0.67matched
7capture01a1ab0b-5b97-7477-99be-ad03a5b48b71€49.00€0.67matched
8capture01a1ab0b-6798-7dba-8c4a-7409c6647bf9€15.00€0.26matched
9capture01a1ab0b-6ad7-73f9-9490-e1bc70da2aee€15.00€0.26matched
10capture01a1ab0b-6fcb-705b-b6f0-2f592e94b526€35.00€0.50matched
11capture01a1ab0b-7e3a-73c7-9b34-d0ce93b58037€35.00€0.50matched
12capture01a1ab0b-93d8-751a-87a4-fe4388e5153f€15.00€0.26matched
13capture01a1ab0b-a712-751b-a78b-0e9dc0618c4e€9.00€0.19matched
14capture01a1ab0b-acbf-7fec-a883-c9d5a8ea6a2b€49.00€0.67matched
15capture01a1ab0b-b183-7363-a5d2-ff7dea305128€15.00€0.26matched
16capture01a1ab0b-ee36-7e93-b1ee-4510818a0152€9.00€0.19matched
17capture01a1ab0b-f2cb-7a4c-bb3e-6f9c7ff1ba3e€9.00€0.19matched
18capture01a1ab0b-f84b-7052-bb57-5703d191ddfc€24.00€0.37matched
19capture01a1ab0b-fbaf-7545-9532-3c08e5dbf3c4€49.00€0.67matched
20capture01a1ab0c-0150-706d-afd7-f52cd6e8581a€15.00€0.26matched
21capture01a1ab0c-0765-71fa-ab41-467c402b3d9a€24.00€0.37matched
22capture01a1ab0c-0a76-7608-bec8-54e1008d1fdc€35.00€0.50matched
23capture01a1ab0c-19f0-7566-a335-6bf157899b38€9.00€0.19matched
24capture01a1ab0c-3513-7811-8350-81efa1c625f6€9.00€0.19matched
25capture01a1ab0c-4260-780d-85e3-d22697c7df0a€35.00€0.50matched
26capture01a1ab0c-47e2-75c9-ac61-b7978f93489e€49.00€0.67matched
27refund01a1ab0c-649c-7c6c-89a5-b1cfead5a1dc-€15.00€0.00matched
28capture01a1ab0c-90ba-7152-874a-f0651f85c7a6€15.00€0.26matched
29capture01a1ab0c-a5a2-7de3-a1b7-322675b0ca8c€15.00€0.26matched
30capture01a1ab0c-a824-725a-8bee-e11455029ad0€15.00€0.26matched
31capture01a1ab0c-c669-74b0-8de4-0e1e66cbe6ce€15.00€0.26matched
32capture01a1ab0c-d304-70ff-8daa-c7ec252d5faf€15.00€0.26matched
33capture01a1ab0c-d965-7d76-99ca-90b7fb02a6b9€35.00€0.50matched
34capture01a1ab0c-f6d3-76c1-bd40-cb3aa1b81742€24.00€0.37matched
35capture01a1ab0d-0f8e-7cb6-9fe7-2b9e71449f0c€24.00€0.37matched
37capture01a1ab0d-62c9-7d75-9015-dd0657ac5f85€24.00€0.37matched
38capture01a1ab0d-6a86-740a-9da1-9742174887e7€15.00€0.26matched
39capture01a1ab0d-7294-7ba3-9651-5c05a1ef6453€9.00€0.19matched
40capture01a1ab0d-7740-7967-bfe6-c8b1697d420a€9.00€0.19matched
41capture01a1ab0d-84f9-78a8-8db3-9b8c159c2f49€15.00€0.26matched
42capture01a1ab0d-8c68-7366-8162-1add73c5b1f1€24.00€0.37matched
43capture01a1ab0d-91ad-70c5-a9d2-36439ef869cd€15.00€0.26matched
44capture01a1ab0d-aa58-7de4-9c23-ce5c4b863fe8€35.00€0.50matched
45refund01a1ab0d-bd39-7a4c-9fd8-031aff32507e-€5.00€0.00matched
46capture01a1ab0d-d689-70a9-9502-15b17a562077€9.00€0.19matched
47capture01a1ab0e-1299-70a2-86c4-68335419561f€24.00€0.37matched
48capture01a1ab0e-31a3-7eb4-9a7f-fc47f0e0a8e8€24.00€0.37matched
49capture01a1ab0e-35dc-7ed9-87d1-c65ffaab9895€49.00€0.67matched
50capture01a1ab0e-41da-7730-b720-dd3016dd2a5e€15.00€0.26matched
51capture01a1ab0e-4463-7fa6-be63-845757fc805e€15.00€0.26matched
52capture01a1ab0e-5234-7134-b7ff-e489facb4ccf€15.00€0.26matched
53refund01a1ab0e-6c8e-7f8c-8e69-4c81f22c8de0-€22.00€0.00matched
54capture01a1ab0e-78db-705b-9cf9-d1987cac1fa7€24.00€0.37matched
55capture01a1ab0e-94a0-7d05-a93e-9b77c99477a3€35.00€0.50matched
56capture01a1ab0e-9ac7-7d1d-80a2-fb2ba9a2053a€24.00€0.37matched
57refund01a1ab0e-a4fd-7a32-a18a-bf9c920ec467-€18.00€0.00matched
58refund01a1ab0e-bc8c-7a15-9a67-3eb7b3df5794-€5.00€0.00matched
59capture01a1ab0e-cf87-7b38-a46b-de1e70b1017a€35.00€0.50matched
60capture01a1ab0e-deac-75c9-a613-1713bd1eefdf€9.00€0.19matched
61capture01a1ab0e-ffc2-794c-9e20-e5a6e331c685€15.00€0.26matched
62capture01a1ab0f-4216-7451-aa28-c5371181a406€35.00€0.50matched
63capture01a1ab0f-440e-769a-a9a9-f8cf6da0ce09€35.00€0.50matched
64capture01a1ab0f-5755-7453-9c69-bdd2e18045d2€15.00€0.26matched
65capture01a1ab0f-853c-76ab-a0b8-67fc85c856f6€15.00€0.26matched
66capture01a1ab0f-c1e4-7cf4-aad2-e38f50965483€15.00€0.26matched
67capture01a1ab0f-da55-7323-932a-3b6da671dd1b€24.00€0.37matched
68capture01a1ab0f-ecfe-7bf6-9ae0-e00bd1839f0a€15.00€0.26matched
69capture01a1ab10-0c75-791c-b8bf-eb0dc58df6f4€15.00€0.26matched
70capture01a1ab10-1039-7561-bfca-3da8e25f78c9€24.00€0.37matched
71capture01a1ab10-1f3c-7ef1-ac45-fb89d4122b61€35.00€0.50matched
72capture01a1ab10-2c25-7dea-839d-c4dc9832fa8d€49.00€0.67matched
73capture01a1ab10-2699-7abd-ad1b-f660839bca09€49.00€0.67matched
74refund01a1ab10-3027-7f67-8a12-3870a49a1397-€13.00€0.00matched
75capture01a1ab10-3547-7e0c-beed-e7856d10b157€35.00€0.50matched
76capture01a1ab10-5bc7-78e5-bef6-5097ae7be553€15.00€0.26matched
77capture01a1ab10-5ef7-78a4-9773-cd3ac96dcd06€49.00€0.67matched
78capture01a1ab10-6298-7c64-a630-0812d9f079aa€9.00€0.19matched
79capture01a1ab10-696a-7bf9-8752-e433feb4acd1€35.00€0.50matched
80capture01a1ab10-6c52-70a1-b816-4d4a7897d9b3€35.00€0.50matched
81capture01a1ab10-72dd-749c-aa31-06b3891817d2€35.00€0.50matched
82capture01a1ab10-7e88-75fd-b4b9-40e6d7ea5530€35.00€0.50matched
83capture01a1ab10-8266-708f-b12a-8db2bc8b9eef€49.00€0.67matched
84capture01a1ab10-8a8d-763a-a84f-e782d7a17e6a€15.00€0.26matched
85capture01a1ab10-9a86-7431-9ae7-717482b9516f€49.00€0.67matched
86refund01a1ab10-af38-76c1-8313-f3947d01380c-€16.00€0.00matched
87capture01a1ab10-bc54-7724-8e45-ae014acf0ab2€49.00€0.67matched
88capture01a1ab10-ed9f-7409-b7e7-e4fb22c5a86e€24.00€0.37matched
89capture01a1ab10-fce2-7ce3-a8fb-af553b3f5aba€35.00€0.50matched
90capture01a1ab11-1196-79c2-87f1-9745e6953fbc€35.00€0.50matched
91capture01a1ab11-4189-779f-8678-132f071c4f04€15.00€0.26matched
92capture01a1ab11-50cd-7a1a-8251-fc83425a7724€49.00€0.67matched
93capture01a1ab11-542d-75e8-9da1-5f590d2ef4e2€15.00€0.26matched
94capture01a1ab11-578e-7045-9a40-694f37d9be55€9.00€0.19matched
95refund01a1ab11-5925-7a60-ad90-b67490450713-€18.00€0.00matched
96capture01a1ab11-7140-735a-af8b-58210d0a559f€24.00€0.37matched
97capture01a1ab11-85ee-71e5-b4d0-e64c23fb5c02€15.00€0.26matched
98capture01a1ab11-a220-77ba-9058-e23f2cb0be09€9.00€0.19matched
99capture01a1ab11-cabe-7a51-9b12-cf5ed52369e7€15.00€0.26matched
100capture01a1ab11-e76e-7166-9592-e6478d3fd9a6€35.00€0.50matched
101capture01a1ab12-0c1f-71c0-a00a-915f35fb1004€24.00€0.37matched
102capture01a1ab12-3c45-7413-b4fe-80dcdc58147e€24.00€0.37matched
103capture01a1ab12-448c-7159-91fa-56e615667ec7€9.00€0.19matched
104capture01a1ab12-71da-7bbd-9c32-4561c1348491€35.00€0.50matched
105capture01a1ab12-7ac8-7c21-89e1-e6ccd61bf961€24.00€0.37matched
106capture01a1ab12-7d6b-7f06-98e8-d484df3b9e52€15.00€0.26matched
107capture01a1ab12-a21c-7be4-9f8b-3b2efe4ee0fb€24.00€0.37matched
108capture01a1ab12-aec8-7438-95eb-cf658af23101€49.00€0.67matched
109capture01a1ab12-b16c-71c5-87c6-020885a886b3€9.00€0.19matched
110capture01a1ab12-c57d-7a80-b1a8-88bdce457762€24.00€0.37matched
111capture01a1ab12-c65a-7bb2-b73b-7061df048f4d€24.00€0.37matched
112capture01a1ab12-e16d-7247-b137-fd19ffa7e351€9.00€0.19matched
113capture01a1ab12-fc85-7db4-92f3-c2f668bc771b€9.00€0.19matched
114capture01a1ab13-089a-771a-8c3b-b12456fe1f83€49.00€0.67matched
115capture01a1ab13-0ecf-7196-ae9a-8479c3c77360€35.00€0.50matched
116capture01a1ab13-2461-7932-b98b-d03b3be066fe€35.00€0.50matched
117capture01a1ab13-2272-7479-8c6b-bdb8f00f351e€9.00€0.19matched
118capture01a1ab13-35ac-7391-bf04-73ee24c298b3€24.00€0.37matched
119refund01a1ab13-5307-7d04-b2a4-721b3454552a-€6.00€0.00matched
120capture01a1ab13-5fd7-7a84-ba1e-113783f37a6a€35.00€0.50matched
121capture01a1ab13-90ad-7c55-9d61-ebb49ca0cc30€35.00€0.50matched
122capture01a1ab13-9274-7a0a-a1aa-511942c68fa6€49.00€0.67matched
123capture01a1ab13-b073-7666-8c2d-1269d229d954€15.00€0.26matched
124capture01a1ab13-ecd5-702a-ab55-1a3da77054d2€9.00€0.19matched
125capture01a1ab14-0095-7f5c-9217-e0732bc98509€9.00€0.19matched
126capture01a1ab14-179e-7ef4-aff5-ea993c9aeadc€35.00€0.50matched
127capture01a1ab14-3352-7e8b-bc23-e904c53a965e€9.00€0.19matched
128capture01a1ab14-3b97-7c32-9662-f35478677518€9.00€0.19matched