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

Gross

€3,198.00

PSP fee

€50.62

Net to the bank

€3,147.38

Settlement journal

#380440

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a6dc-b34e-7071-90bf-8e54774be4dc is already settled by stl_EUR_2989668 line 18
  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
LineKindReferenceGrossFeeStatus
19capture01a1a6dc-b387-786d-924d-149d79e8bd4e€9.00€0.19duplicate line
127capture01a1a6e4-7f97-74f1-9460-fdb7b9a0070a€24.00€0.42fee difference
1capture01a1a6d3-c60c-7788-ace5-cac5f887cf49€9.00€0.19matched
2capture01a1a6d5-5077-7a42-95a3-381f77d63a2e€9.00€0.19matched
3capture01a1a6d5-d4ba-78de-8bbb-7d5cafe087ed€15.00€0.26matched
4capture01a1a6d8-d44a-7219-ab59-a91e10422a55€49.00€0.67matched
5refund01a1a6d9-9efc-763f-b16e-5fbf757368be-€15.00€0.00matched
6capture01a1a6dc-1bf5-736c-9d57-4284d75c077a€35.00€0.50matched
7capture01a1a6dc-22c8-7cd4-8017-e35eff60caab€15.00€0.26matched
8capture01a1a6dc-2391-7f26-acbf-c26508ad047e€24.00€0.37matched
9capture01a1a6dc-2cc6-73d7-bcb0-171d96a293ee€24.00€0.37matched
10capture01a1a6dc-4dac-7153-91d0-49bdff7cffec€49.00€0.67matched
11capture01a1a6dc-54ae-78f8-8dc2-dd7773e0f5ae€24.00€0.37matched
12capture01a1a6dc-56e2-74b8-b210-b69f9d5280e7€24.00€0.37matched
13capture01a1a6dc-6523-7d11-8648-8e77bf601cca€49.00€0.67matched
14capture01a1a6dc-74ed-70fd-b005-c5e5f9868a06€15.00€0.26matched
15capture01a1a6dc-8418-7530-9ab4-c20aede0850d€49.00€0.67matched
16capture01a1a6dc-8a80-74ac-8ca4-85d8e74a86e2€49.00€0.67matched
17capture01a1a6dc-a49e-7813-b968-56ccfef6af4a€15.00€0.26matched
18capture01a1a6dc-b387-786d-924d-149d79e8bd4e€9.00€0.19matched
20refund01a1a6dc-b4b3-7719-a94d-1c98f87ee9ef-€5.00€0.00matched
21capture01a1a6dc-fe52-7674-81bc-835c6ac25b06€9.00€0.19matched
22capture01a1a6dd-1484-7df8-b9e9-80187fb32220€35.00€0.50matched
23capture01a1a6dd-1a8d-7f6e-988c-5a83d3aff0d4€15.00€0.26matched
24capture01a1a6dd-29de-7475-ad8d-91bf53c1128a€15.00€0.26matched
25capture01a1a6dd-3c5f-7d09-8344-3acc4cdcb37b€49.00€0.67matched
26capture01a1a6dd-4dc1-721e-801c-15a25e82a136€15.00€0.26matched
27capture01a1a6dd-545a-7d15-accf-3dab9a1f3358€9.00€0.19matched
28capture01a1a6dd-649f-7b8d-a210-770bf581bda0€49.00€0.67matched
29capture01a1a6dd-6fbe-7612-9453-7d69b7ad18b2€49.00€0.67matched
30capture01a1a6dd-95bf-77e9-b0fa-520cc8ee0882€35.00€0.50matched
31refund01a1a6dd-be7b-79f2-9a25-cd27401e875f-€16.00€0.00matched
32capture01a1a6dd-ccf5-7269-a6c4-efab887880dc€9.00€0.19matched
33capture01a1a6dd-ec07-7d3a-b877-df8166bfef44€49.00€0.67matched
34capture01a1a6dd-ed08-708b-8acb-5853c6365318€49.00€0.67matched
35capture01a1a6dd-fc79-7b06-8595-06973e57e5e5€15.00€0.26matched
36capture01a1a6dd-ff75-7eb8-903e-4fe708213f9f€49.00€0.67matched
37capture01a1a6de-1926-7c29-917e-b47e33c1f55b€35.00€0.50matched
38capture01a1a6de-1be4-73e7-904b-82748f8fee1a€49.00€0.67matched
39capture01a1a6de-253e-7293-bab9-fe655d0a7e45€24.00€0.37matched
40capture01a1a6de-394c-7922-b4ee-6b7d69bdf3f7€15.00€0.26matched
41refund01a1a6de-4891-7fe3-a047-edbee23a3b21-€14.00€0.00matched
42capture01a1a6de-500f-70b9-bcd3-96ced0f2aae4€35.00€0.50matched
43refund01a1a6de-5b81-7d25-86da-f3aeb9ae4930-€17.00€0.00matched
44capture01a1a6de-6b38-7825-9909-c0f428367c2d€9.00€0.19matched
45refund01a1a6de-7a5e-7c1a-9cb2-d2a681336e7c-€30.00€0.00matched
46capture01a1a6de-80b0-7730-a348-0bd745a33135€35.00€0.50matched
47capture01a1a6de-8b38-7944-a758-291eae3849f1€49.00€0.67matched
48capture01a1a6de-8dc2-7c4a-9b6a-8cca4fe21bb1€35.00€0.50matched
49refund01a1a6de-9548-7896-8366-9d3991652f7a-€22.00€0.00matched
50capture01a1a6de-afba-7717-9ba3-216dfb05d105€35.00€0.50matched
51capture01a1a6de-bf46-72d7-a929-d3194f522f2f€35.00€0.50matched
52capture01a1a6de-d40a-75d5-a687-81638bdc6842€9.00€0.19matched
53capture01a1a6de-d684-7a7b-b979-e976d7ab94f8€9.00€0.19matched
54capture01a1a6de-dae2-7c79-a6c0-4457138cb993€35.00€0.50matched
55capture01a1a6de-f209-72f5-b536-254ee0561d8d€9.00€0.19matched
56capture01a1a6df-0ee2-7b38-876c-fbe8776f68cc€35.00€0.50matched
57capture01a1a6df-316f-7b92-9a41-c30fcaf0264c€49.00€0.67matched
58capture01a1a6df-41e4-7a54-9ce3-b3a9624df638€35.00€0.50matched
59capture01a1a6df-4a2e-7698-bc50-8db691593746€49.00€0.67matched
60capture01a1a6df-5e92-7092-970c-b5e42abd84eb€35.00€0.50matched
61refund01a1a6df-6bd3-7b6b-af0f-3261bcedc23d-€25.00€0.00matched
62capture01a1a6df-6fb6-719f-8dc2-486d798e6393€24.00€0.37matched
63capture01a1a6df-8a05-735d-a088-c4edc24168a8€24.00€0.37matched
64capture01a1a6df-9f73-7d4a-be39-90f2041d05d1€24.00€0.37matched
65capture01a1a6df-a7bd-7bab-9461-3839012f1b15€9.00€0.19matched
66capture01a1a6df-ae30-7895-bfa0-ebedfa60d90d€24.00€0.37matched
67capture01a1a6df-d958-73df-ad57-b5a740920df1€9.00€0.19matched
68capture01a1a6df-dcf1-7375-9369-74fa95b4a84f€49.00€0.67matched
69capture01a1a6df-ecde-734f-a593-fea9e84065df€49.00€0.67matched
70capture01a1a6df-fa68-77ff-8d20-d4536211a76a€24.00€0.37matched
71capture01a1a6e0-0560-700b-bcbf-769c2b65e026€15.00€0.26matched
72capture01a1a6e0-1435-71f9-aa8d-b9bb3502d902€15.00€0.26matched
73capture01a1a6e0-14a6-7c6d-ab66-4b7932d80957€9.00€0.19matched
74capture01a1a6e0-1915-7918-b555-dee4bffee34a€49.00€0.67matched
75capture01a1a6e0-1b11-73bb-8fe2-bb475cb72fce€9.00€0.19matched
76capture01a1a6e0-5a06-7def-b1ba-0c3c041cd8d1€35.00€0.50matched
77capture01a1a6e0-60e2-7724-bfd9-38817b18bc00€49.00€0.67matched
78capture01a1a6e0-6a19-73ca-b482-3480ec25f4c2€49.00€0.67matched
79refund01a1a6e0-83ac-78bd-879f-1bcce1a0600c-€7.00€0.00matched
80capture01a1a6e0-9c05-744f-95d6-c7a8a682ff91€15.00€0.26matched
81capture01a1a6e0-cdd6-766f-99c5-977a3ff853ea€24.00€0.37matched
82capture01a1a6e0-d1c8-75b7-a967-95530ea35b72€49.00€0.67matched
83capture01a1a6e1-08cb-704e-9f07-ce15c7ab8dfe€24.00€0.37matched
84capture01a1a6e1-1756-72a2-bf25-b4523b60c1c5€9.00€0.19matched
85capture01a1a6e1-17c5-7e6d-b50e-c50962979f83€49.00€0.67matched
86capture01a1a6e1-2a1a-7ba8-810e-e1f18f5dba0f€15.00€0.26matched
87capture01a1a6e1-348b-7e91-951c-914c25a55435€24.00€0.37matched
88capture01a1a6e1-65ec-7e45-8857-eca3f447c8e1€15.00€0.26matched
89capture01a1a6e1-7d27-70c0-8413-8cd3d4763e30€15.00€0.26matched
90capture01a1a6e1-81ff-779e-8abb-67f8b7b246f2€9.00€0.19matched
91capture01a1a6e1-8e74-70d9-aa79-cae381477fca€15.00€0.26matched
92capture01a1a6e1-8ec5-7e4b-9f65-3e46300809fc€15.00€0.26matched
93capture01a1a6e1-92fc-7f8c-9df3-f05fccb0f5a7€35.00€0.50matched
94capture01a1a6e1-9409-7f8b-b6c4-17596cfbcd7a€9.00€0.19matched
95capture01a1a6e1-9d7d-77d4-a8e4-bfe62254562d€15.00€0.26matched
96capture01a1a6e1-bff5-7fea-8c18-9687de7096a3€24.00€0.37matched
97capture01a1a6e2-1f86-78cf-ac27-84dbe54e3e3f€49.00€0.67matched
98capture01a1a6e2-5023-7267-aed7-b96eaa57b79f€9.00€0.19matched
99capture01a1a6e2-7351-7d03-8046-6d34413ba173€15.00€0.26matched
100capture01a1a6e2-911b-7364-9c1f-f2c5a4c0f30e€49.00€0.67matched
101refund01a1a6e2-a7ba-7685-87ef-a5b51ce91eec-€11.00€0.00matched
102capture01a1a6e2-fc68-724a-b7a8-f2e1ff305266€24.00€0.37matched
103capture01a1a6e3-0073-7a2e-b413-33c2be2dc1ae€9.00€0.19matched
104capture01a1a6e3-063f-7d2f-a5e7-23d1cb1b22c5€49.00€0.67matched
105capture01a1a6e3-255f-791a-87af-462829604088€24.00€0.37matched
106capture01a1a6e3-2d09-706e-ab92-870e011fc054€49.00€0.67matched
107capture01a1a6e3-431a-719a-a499-12bd910157ae€49.00€0.67matched
108capture01a1a6e3-5ed3-723e-b680-53f53ef25ccc€9.00€0.19matched
109capture01a1a6e3-740a-7057-8582-5ba36d940c06€35.00€0.50matched
110capture01a1a6e3-786c-79ff-95f0-2695703b6a6f€15.00€0.26matched
111capture01a1a6e3-82f8-70bd-8e20-ca82d9fa0d3b€35.00€0.50matched
112capture01a1a6e3-9209-7be1-b66b-db3acc710fb6€9.00€0.19matched
113capture01a1a6e3-aca6-757f-8b6b-949b5e051c30€35.00€0.50matched
114capture01a1a6e3-b3c3-7f5f-808f-da7bab61091b€15.00€0.26matched
115capture01a1a6e3-d3ad-71de-929e-373c4df8cf59€24.00€0.37matched
116capture01a1a6e3-df5e-72c1-9b2a-f82ba80e1853€49.00€0.67matched
117capture01a1a6e4-04b3-720f-89cc-6ec8fd3b439a€24.00€0.37matched
118capture01a1a6e4-06c9-7fc1-b501-f7421676682a€9.00€0.19matched
119capture01a1a6e4-1071-746f-8cda-dff6f549465a€15.00€0.26matched
120capture01a1a6e4-2025-745b-97a5-b07170e7d892€15.00€0.26matched
121capture01a1a6e4-2b96-7518-8327-1b7a95731496€9.00€0.19matched
122capture01a1a6e4-3678-74d6-a12e-dd3a82a2c969€15.00€0.26matched
123capture01a1a6e4-3f33-7ba7-bd3b-ef11e90e666d€49.00€0.67matched
124capture01a1a6e4-452c-7098-a99b-fc8006e741a5€49.00€0.67matched
125capture01a1a6e4-6f23-77c6-a788-8ed3bb0c6b64€9.00€0.19matched
126capture01a1a6e4-79f0-7450-a542-75d3c2d15360€24.00€0.37matched
128capture01a1a6e4-8ec7-7d65-8ffe-a56100fa5cc8€49.00€0.67matched
129capture01a1a6e4-a283-7ed9-b443-09ebf10f7a7a€24.00€0.37matched
130capture01a1a6e4-b3b0-797d-964b-1cf4a8078562€24.00€0.37matched
131capture01a1a6e4-c72f-7a78-94c1-fd785e2121a5€49.00€0.67matched
132capture01a1a6e4-ec16-726e-9059-e7f24ca0bc61€24.00€0.37matched
133refund01a1a6e4-fb15-77ab-9118-07731dff6b30-€14.00€0.00matched
134capture01a1a6e5-0d7b-7461-b45c-dd181f02ac5b€24.00€0.37matched
135capture01a1a6e5-0e9f-7e17-abed-fe7ac95fa493€15.00€0.26matched