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

Gross

€3,136.00

PSP fee

€51.32

Net to the bank

€3,084.68

Settlement journal

#369868

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a3e3-5670-75cc-8f6c-623443d857ad is already settled by stl_EUR_2989584 line 133
  • fee differencethe fee is not the contract feethe fee is 4, the contract says 0
LineKindReferenceGrossFeeStatus
119refund01a1a3e2-5496-74c5-b0fb-0b526fdac7b2-€9.00€0.04fee difference
134capture01a1a3e3-56a9-706b-9d21-15611cc814fd€9.00€0.19duplicate line
1capture01a1a3d5-4efa-766c-ac77-bcb9ffce6404€49.00€0.67matched
2capture01a1a3d8-e37f-7e55-862f-440aa6f4353c€9.00€0.19matched
3capture01a1a3db-0d56-7793-a327-317c32c0a5d2€9.00€0.19matched
4capture01a1a3db-14dc-7724-a9a7-acc0268526c5€9.00€0.19matched
5capture01a1a3db-1704-7790-b4a1-d21fe4f7cc9d€9.00€0.19matched
6capture01a1a3db-156d-7cea-b162-db9cd9b4c310€15.00€0.26matched
7capture01a1a3db-2d39-7537-8f71-6989da446798€24.00€0.37matched
8capture01a1a3db-3291-7ca0-a39c-804c56490475€9.00€0.19matched
9capture01a1a3db-41a7-74e2-98ec-43fdf856dd58€15.00€0.26matched
10capture01a1a3db-59d1-7fe7-ae71-2416ad36e31a€9.00€0.19matched
11refund01a1a3db-8697-7e39-8642-4a98c89ee0fb-€5.00€0.00matched
12capture01a1a3db-9d14-713a-90d9-fd05c96ea2ee€49.00€0.67matched
13capture01a1a3db-a66f-7ff8-bf8b-39fd3d23eec6€49.00€0.67matched
14capture01a1a3db-afc5-7ecf-bc63-6186ddbca440€15.00€0.26matched
15capture01a1a3db-bc56-7a28-a9dd-26d78c3d72be€9.00€0.19matched
16capture01a1a3db-c80c-78d9-aa3c-6f694da4fc2d€9.00€0.19matched
17capture01a1a3db-d624-76f9-adc2-1d00307d29ef€35.00€0.50matched
18capture01a1a3db-dc14-778f-b8cd-e1fe037c9762€9.00€0.19matched
19capture01a1a3db-e2bb-71d7-911a-a6ec0907ce92€9.00€0.19matched
20capture01a1a3db-e829-7a10-869a-e68aa2d610a9€9.00€0.19matched
21capture01a1a3db-f2aa-72b1-846e-dc80a6d165c4€49.00€0.67matched
22capture01a1a3db-f110-78e7-833c-e21b923e2372€24.00€0.37matched
23capture01a1a3db-fce2-7a3c-9cb5-5d105cb3bdaf€24.00€0.37matched
24capture01a1a3dc-1381-7171-9dd5-0f034a142818€49.00€0.67matched
25capture01a1a3dc-1e1d-749a-9aac-a19d3573f158€15.00€0.26matched
26capture01a1a3dc-2bba-7f3d-9850-b2a599def09a€49.00€0.67matched
27capture01a1a3dc-3cd3-7593-835a-6e28dd11a2d5€35.00€0.50matched
28capture01a1a3dc-4430-7089-9eba-183d868b0629€24.00€0.37matched
29capture01a1a3dc-46ee-720a-b2cd-5452ea02e02e€9.00€0.19matched
30refund01a1a3dc-4714-735c-baaf-a5695c808fb0-€10.00€0.00matched
31capture01a1a3dc-4daa-7dd1-9be4-531cf5df90fc€9.00€0.19matched
32refund01a1a3dc-5221-7f33-8bf0-cf6681697e49-€4.00€0.00matched
33capture01a1a3dc-5a04-78d0-ba12-4496d749a4f1€35.00€0.50matched
34capture01a1a3dc-619e-75a7-a9ad-7bb4d6c969a4€9.00€0.19matched
35capture01a1a3dc-85cd-763d-aeaf-590df89e2d31€35.00€0.50matched
36capture01a1a3dc-8ec6-77e8-b3a5-2ba3d826d5bc€49.00€0.67matched
37capture01a1a3dc-a3fd-7d27-bd1a-bf4aa78f0d1b€15.00€0.26matched
38capture01a1a3dc-b753-7d84-b905-c4290e41a724€49.00€0.67matched
39capture01a1a3dc-d4ed-7099-b599-26ccbace4a66€9.00€0.19matched
40capture01a1a3dc-db37-70fd-9002-05f8065e53a6€35.00€0.50matched
41capture01a1a3dd-04ec-7791-9e98-e61715e6dee1€15.00€0.26matched
42capture01a1a3dd-20c1-7e33-b8e6-cb8a091a8857€9.00€0.19matched
43capture01a1a3dd-379b-7316-8aba-7120bd637526€9.00€0.19matched
44capture01a1a3dd-6bff-7579-95cc-627f39e00f5e€49.00€0.67matched
45capture01a1a3dd-6f02-7a4b-a28e-df5d6a9ea8c0€35.00€0.50matched
46capture01a1a3dd-8185-71fa-bd15-86adfccb30dd€35.00€0.50matched
47capture01a1a3dd-97ea-7d96-8d7e-78a5e591d1ba€35.00€0.50matched
48capture01a1a3dd-b93d-7728-8408-47caa4468408€49.00€0.67matched
49capture01a1a3dd-c983-7436-8c29-eea405f96744€15.00€0.26matched
50capture01a1a3dd-e4ff-7227-a182-9b2af9f9b97d€49.00€0.67matched
51capture01a1a3dd-e99b-7f3f-86ab-32ac2b29de12€24.00€0.37matched
52capture01a1a3dd-f2c3-7168-8f19-2ae7ec664ddc€49.00€0.67matched
53capture01a1a3de-0192-7041-ba36-b55d6cbeca7f€15.00€0.26matched
54capture01a1a3de-0cfc-72a8-924b-fc7ae2e138b5€35.00€0.50matched
55capture01a1a3de-0e3c-70ee-99fb-229ed446ab06€24.00€0.37matched
56capture01a1a3de-133e-7bcc-b68b-c71b37b4cfa7€9.00€0.19matched
57capture01a1a3de-1b00-7df3-b543-eae6d948fb18€35.00€0.50matched
58refund01a1a3de-2bc3-77d8-bdd2-9cfa8ab5e8fd-€38.00€0.00matched
59refund01a1a3de-4c42-76fb-8183-88fe120cd597-€43.00€0.00matched
60capture01a1a3de-5b84-7933-95a9-79f28c5d1589€35.00€0.50matched
61capture01a1a3de-6e82-7988-a1dd-7a62c890f1f1€35.00€0.50matched
62capture01a1a3de-77c0-7066-b207-4644f3c96840€24.00€0.37matched
63capture01a1a3de-8576-7a76-b544-ad9f7e3f01e1€9.00€0.19matched
64capture01a1a3de-ab2a-7623-bcee-3ead8b23972c€9.00€0.19matched
65capture01a1a3de-ac05-7641-aab6-599c84174be4€9.00€0.19matched
66refund01a1a3de-b0ac-7466-9613-9d618c33bf37-€2.00€0.00matched
67capture01a1a3de-b0db-70aa-8121-fb54b7c8c0a2€49.00€0.67matched
68capture01a1a3df-0086-7858-82c9-bfeb2f3bb7c0€24.00€0.37matched
69capture01a1a3df-00f7-7af5-a1e9-403559309c9c€24.00€0.37matched
70capture01a1a3df-15aa-7548-b29c-3a0f2a775a18€9.00€0.19matched
71capture01a1a3df-3c23-7610-b317-dd0afb227497€9.00€0.19matched
72capture01a1a3df-42e1-713f-b55b-6c7659cc2b71€49.00€0.67matched
73refund01a1a3df-43e8-7a06-b914-93f3c5308a7b-€13.00€0.00matched
74refund01a1a3df-6b60-7723-92c3-1b6d61f4ebee-€3.00€0.00matched
75capture01a1a3df-6e94-75fe-9488-3fe96550df5c€35.00€0.50matched
76capture01a1a3df-792c-755b-bdbb-5be6a9fcd567€49.00€0.67matched
77capture01a1a3df-8d12-7244-a8e4-5c4ea427d7ef€35.00€0.50matched
78capture01a1a3df-bf2f-7274-87ed-0331611fbdf7€15.00€0.26matched
79capture01a1a3df-ced5-7a30-8cde-6ba161b5b5cc€15.00€0.26matched
80capture01a1a3df-db85-7ce0-ba59-2ea0c29d6d70€24.00€0.37matched
81capture01a1a3df-e8cc-7885-b6cb-b66187fcc30e€9.00€0.19matched
82capture01a1a3df-eebc-724e-8388-824fb31730ae€15.00€0.26matched
83capture01a1a3df-f186-7f4f-b5b8-2f397868479a€15.00€0.26matched
84refund01a1a3e0-235a-7f63-bae7-1fb433d2273d-€19.00€0.00matched
85capture01a1a3e0-2b5c-7601-b3e3-14a39869f051€15.00€0.26matched
86capture01a1a3e0-3f2e-7697-bd3c-740e286dd7bd€15.00€0.26matched
87capture01a1a3e0-40f7-73bd-ba9e-d644687a6f66€35.00€0.50matched
88refund01a1a3e0-492a-7e28-8af7-d89fd93d8251-€9.00€0.00matched
89capture01a1a3e0-5f4a-700b-ad73-c52c3c8cc7b6€49.00€0.67matched
90capture01a1a3e0-6dc6-7654-9906-a843cbc8d29e€15.00€0.26matched
91capture01a1a3e0-7d18-75cc-add2-2519833f96ee€9.00€0.19matched
92capture01a1a3e0-8998-731d-9295-0883a97ac907€49.00€0.67matched
93refund01a1a3e0-c5a4-7574-a1fe-edf448824b7c-€7.00€0.00matched
94capture01a1a3e0-c7d7-7635-b1eb-58d444f2ad7f€15.00€0.26matched
95capture01a1a3e0-daef-77b2-bced-e1ba0f2e8ab1€35.00€0.50matched
96capture01a1a3e0-ff22-7999-aa62-2ea4e11e70be€9.00€0.19matched
97capture01a1a3e1-000b-753b-8ad6-16a8e5cb53cc€9.00€0.19matched
98capture01a1a3e1-2188-76b4-85fe-5d83a321ea4f€35.00€0.50matched
99capture01a1a3e1-398e-7e8d-ad35-7dbf343e44c8€24.00€0.37matched
100refund01a1a3e1-6611-72a6-b9c6-e9b3b4f24b93-€4.00€0.00matched
101capture01a1a3e1-79ee-7bd7-9615-72492ae7896d€35.00€0.50matched
102capture01a1a3e1-83ab-7753-946f-3357dcae394e€49.00€0.67matched
103capture01a1a3e1-c08b-79ae-aa5d-4509c192a256€15.00€0.26matched
104capture01a1a3e1-c9cd-738c-8b8b-d7abc171b0e2€49.00€0.67matched
105capture01a1a3e1-cabd-7614-bf62-68029b57edb8€24.00€0.37matched
106capture01a1a3e1-d1a4-77b1-abd1-b9259790e4d6€15.00€0.26matched
107capture01a1a3e1-d2dc-7cf8-b4f5-071c3aa8b758€24.00€0.37matched
108capture01a1a3e1-dde7-71b1-b527-2375f8db6829€24.00€0.37matched
109capture01a1a3e1-de6c-7e1c-b49e-c445a515b737€9.00€0.19matched
110capture01a1a3e1-deab-7d10-b882-3c7b8f37ef90€49.00€0.67matched
111capture01a1a3e1-eaa4-72f9-8100-638431e06217€15.00€0.26matched
112refund01a1a3e1-eb1e-7a1a-ad83-631a909021cf-€19.00€0.00matched
113refund01a1a3e1-f56c-71a0-8814-210ce56e6765-€23.00€0.00matched
114capture01a1a3e2-09d1-7bb9-b5d1-f8a66fd283e9€15.00€0.26matched
115capture01a1a3e2-15db-797a-a0f6-bac199ff8f46€35.00€0.50matched
116capture01a1a3e2-2a2c-731e-a9f7-e347a5ce9062€15.00€0.26matched
117refund01a1a3e2-3ab5-7174-bbec-390b221463cb-€9.00€0.00matched
118capture01a1a3e2-3e13-7c4d-b3a9-051631c808dc€24.00€0.37matched
120capture01a1a3e2-5b9e-7c82-be00-4e8bbf736f6a€35.00€0.50matched
121capture01a1a3e2-8599-7eb4-854f-4139f3ac3b4d€49.00€0.67matched
122capture01a1a3e2-9882-7ddc-b6c7-94eeee384740€24.00€0.37matched
123capture01a1a3e2-cfe6-7306-93ca-9247344044c0€15.00€0.26matched
124capture01a1a3e2-d121-78e9-a938-e040c52da5f9€15.00€0.26matched
125capture01a1a3e2-dd61-75ac-8b14-29b235e2797e€24.00€0.37matched
126capture01a1a3e2-e826-7482-8e5b-ffca4f813a75€24.00€0.37matched
127capture01a1a3e2-f2ae-7463-b306-7ff659676a92€24.00€0.37matched
128capture01a1a3e3-0fb4-7071-979c-ae96b6a5b58c€24.00€0.37matched
129capture01a1a3e3-17ce-7ab0-b590-457fb75b7de9€49.00€0.67matched
130capture01a1a3e3-1f99-75c0-b9db-a4bd364b191a€49.00€0.67matched
131refund01a1a3e3-2b77-7d84-a9ee-4e8c510bbb0a-€10.00€0.00matched
132refund01a1a3e3-2dc5-7b63-bc1b-e41d0bdb811a-€12.00€0.00matched
133capture01a1a3e3-56a9-706b-9d21-15611cc814fd€9.00€0.19matched
135capture01a1a3e3-5ae1-7379-a685-4286e04d3bce€49.00€0.67matched
136capture01a1a3e3-5ca8-7fc2-9fee-1f19d400b5b1€35.00€0.50matched
137capture01a1a3e3-76cb-7e83-be4d-4faac291bd62€49.00€0.67matched
138capture01a1a3e3-7ea4-752e-a518-6c73a80a1ed6€35.00€0.50matched
139capture01a1a3e3-811c-7647-aa9d-6d64ce39ce3f€15.00€0.26matched
140capture01a1a3e3-9a5c-79f8-b118-3be53fd47349€35.00€0.50matched
141capture01a1a3e3-a412-72ef-81bf-d51309196abd€15.00€0.26matched
142capture01a1a3e3-a81c-7c56-9c5d-d832fed65a51€49.00€0.67matched
143capture01a1a3e3-af70-711b-948a-cf07546127e7€35.00€0.50matched
144capture01a1a3e3-c08c-7570-9a7a-67b21efccf07€15.00€0.26matched
145capture01a1a3e3-c4b7-7e50-8e11-6cd1e4fc101f€24.00€0.37matched
146capture01a1a3e3-c68e-717d-bc23-623ab9001b89€35.00€0.50matched
147capture01a1a3e3-d241-7dd1-929e-873fda59844a€24.00€0.37matched
148capture01a1a3e3-fd1f-7486-ae8e-6da9969d5536€35.00€0.50matched
149refund01a1a3e4-0c89-720a-9be8-f0a22cb5c020-€12.00€0.00matched
150capture01a1a3e4-1218-7fa8-8bda-cf142b82979d€15.00€0.26matched