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, 16:50

Gross

€3,268.00

PSP fee

€51.80

Net to the bank

€3,216.20

Settlement journal

#382630

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a77e-9e62-7701-bddd-c6e3a5b2a1e2 is already settled by stl_EUR_2989685 line 115
  • fee differencethe fee is not the contract feethe fee is 1, the contract says 0
  • missing linein the books, not in the filecapture:01a1a780-4255-78d8-a651-c4f0db17c090 is in no file
LineKindReferenceGrossFeeStatus
100refund01a1a77d-2701-7dcb-abf2-bf30c2a2d2d5-€15.00€0.01fee difference
116capture01a1a77e-9e8e-74de-8318-6248ae19a0a5€49.00€0.67duplicate line
1capture01a1a76e-cf0b-7e50-9964-0f80c20b22a7€49.00€0.67matched
2capture01a1a770-17a0-77fe-938f-d95ad38ba1be€15.00€0.26matched
3capture01a1a770-86aa-77f5-8dc8-cfc7deba8608€35.00€0.50matched
4capture01a1a777-ad99-76ea-8aa7-ecf0f4a417cf€24.00€0.37matched
5capture01a1a777-c36f-7d6c-92ef-1e8bb0f9e991€35.00€0.50matched
6capture01a1a777-e21e-73ce-92a2-31afa0c3f213€49.00€0.67matched
7capture01a1a778-0cb6-7463-9833-a6dfb85db90c€24.00€0.37matched
8capture01a1a778-147b-7905-9784-997df58256d9€15.00€0.26matched
9capture01a1a778-3355-7d21-9fa8-d70967c4221b€49.00€0.67matched
10capture01a1a778-451d-7d9c-be0c-2021f46b7c44€15.00€0.26matched
11capture01a1a778-66e7-72a1-a44c-78a9819810bc€24.00€0.37matched
12capture01a1a778-7191-751e-a0c3-3d2d39e3e9dd€35.00€0.50matched
13capture01a1a778-7834-704e-b5a1-517eccfeb53c€9.00€0.19matched
14capture01a1a778-8825-7fde-8dbb-fae0405b7518€24.00€0.37matched
15capture01a1a778-95b7-7238-a8e7-e05a5c6923ff€9.00€0.19matched
16capture01a1a778-98c9-72f6-b865-ea9116feafae€15.00€0.26matched
17refund01a1a778-bace-78ac-8c12-ac08ff81ec2f-€13.00€0.00matched
18capture01a1a778-ca0c-7f1d-8ece-f83024028956€49.00€0.67matched
19capture01a1a778-d02c-7a44-b4ef-c9f70d82eba8€15.00€0.26matched
20capture01a1a778-e649-7fa4-aae2-e9aba935ce70€15.00€0.26matched
21capture01a1a778-f739-78d9-9f6e-930b4cc120a3€35.00€0.50matched
22capture01a1a778-fd49-7a0b-bc52-3680cf38d7b7€15.00€0.26matched
23capture01a1a779-04b0-770c-9ca7-1a0105796ca8€24.00€0.37matched
24capture01a1a779-09ea-7117-a253-9f53fd76e576€49.00€0.67matched
25capture01a1a779-0db7-7e09-b2bf-65368bb7b07f€15.00€0.26matched
26capture01a1a779-2597-769e-a1d7-4b43b00d7674€24.00€0.37matched
27capture01a1a779-26d1-7a09-8ce4-d982708c0e6a€24.00€0.37matched
28capture01a1a779-30fc-79b7-a6bf-260334d75504€35.00€0.50matched
29capture01a1a779-3785-769c-af14-176b55e83ba1€15.00€0.26matched
30capture01a1a779-3a50-7855-a63b-1ebf49fca520€49.00€0.67matched
31capture01a1a779-3e42-7bd6-b805-fc7747ec4493€24.00€0.37matched
32capture01a1a779-3ec8-7646-982c-c0cbc926d598€35.00€0.50matched
33capture01a1a779-50a5-73cb-ba65-52923daedd46€24.00€0.37matched
34capture01a1a779-588e-708d-a420-6cd8708a2769€24.00€0.37matched
35capture01a1a779-98aa-79e8-af0d-e552e8517526€24.00€0.37matched
36capture01a1a779-9923-794d-b7eb-30837e314943€15.00€0.26matched
37refund01a1a779-9d5f-7e6a-981f-2eb4970d3c11-€30.00€0.00matched
38capture01a1a779-a10f-793e-9f25-a515f21fd0c7€9.00€0.19matched
39capture01a1a779-bc76-7cfc-9ff0-3cf8808a1f7b€15.00€0.26matched
40capture01a1a779-c718-7c54-846c-e07045fad04e€24.00€0.37matched
41capture01a1a779-d57a-7b30-a168-c6a3df56cb6a€15.00€0.26matched
42refund01a1a779-e06a-78f7-bb8f-9ae0437d16e4-€15.00€0.00matched
43capture01a1a779-e742-75c3-949b-0b68689050d8€49.00€0.67matched
44capture01a1a779-ec07-7df1-8ff9-d311fbfab355€15.00€0.26matched
45capture01a1a779-f3c6-76b9-ba8d-8c10dfffb538€9.00€0.19matched
46capture01a1a77a-2f74-77da-b7b2-a4c5db4855aa€24.00€0.37matched
47capture01a1a77a-373d-7da9-9dd0-12ebbac7e9bb€24.00€0.37matched
48capture01a1a77a-47a0-7cb2-8314-92d877729654€15.00€0.26matched
49capture01a1a77a-47ea-7a6b-bb84-97a886ed3d52€49.00€0.67matched
50capture01a1a77a-5b64-736a-99b5-e66ada964ebb€24.00€0.37matched
51capture01a1a77a-8eb2-7218-aed7-70085fd31562€9.00€0.19matched
52capture01a1a77a-97ee-73c1-ac09-fd9930cd0491€24.00€0.37matched
53capture01a1a77a-b092-7a42-ade9-5f400862d96b€49.00€0.67matched
54capture01a1a77a-ba42-76d9-9863-35addf8d45df€24.00€0.37matched
55capture01a1a77a-c1df-74c0-834d-98cd5b7dba86€35.00€0.50matched
56capture01a1a77a-cb6c-732e-94c7-61a8e3a1839e€24.00€0.37matched
57capture01a1a77a-cc38-74da-92fc-3ee43f4c6865€9.00€0.19matched
58capture01a1a77a-d8a6-78aa-8e4b-02f92b9514cb€15.00€0.26matched
59capture01a1a77a-e4e1-702a-939a-33d8b80d727f€49.00€0.67matched
60refund01a1a77a-ed13-7672-9b2a-892197f8fc70-€11.00€0.00matched
61capture01a1a77b-0244-74d3-b378-70840cc64ca1€9.00€0.19matched
62capture01a1a77b-0ddf-7474-b0d3-0da73e1efe27€15.00€0.26matched
63capture01a1a77b-0f18-7d65-9382-adabfe1fc670€35.00€0.50matched
64capture01a1a77b-1800-799d-b684-c4c220b75f9c€15.00€0.26matched
65capture01a1a77b-1c9c-7c3d-a530-c3066caea8ae€49.00€0.67matched
66refund01a1a77b-29e3-7862-8f75-83ed00e13517-€15.00€0.00matched
67capture01a1a77b-3244-7f14-8736-5a94df5a96b0€35.00€0.50matched
68capture01a1a77b-42db-72ab-b735-eb301560f26f€15.00€0.26matched
69capture01a1a77b-5c6b-7f67-be26-36691424526e€24.00€0.37matched
70capture01a1a77b-7458-7971-9190-d7e6d68b2587€9.00€0.19matched
71capture01a1a77b-8fdc-7bb9-aceb-fc21bf9c5373€15.00€0.26matched
72capture01a1a77b-95c1-77ea-a3c0-63c62942cff0€15.00€0.26matched
73capture01a1a77b-960c-7eb0-a023-0a7b21d5b459€24.00€0.37matched
74capture01a1a77b-a581-7fb9-ab07-fe3c19e494fc€49.00€0.67matched
75capture01a1a77b-b90a-7a14-b5ad-5c3d31626ec1€49.00€0.67matched
76capture01a1a77b-ed0d-7ee5-b3eb-c28e93582cd1€9.00€0.19matched
77capture01a1a77c-014e-7a3b-b058-624549ad4719€35.00€0.50matched
78capture01a1a77c-0a05-7494-bf51-2b325f9fec47€24.00€0.37matched
79capture01a1a77c-1814-74c4-9f2f-0ddf144b57d1€35.00€0.50matched
80capture01a1a77c-2ea2-7d72-8e36-620cde7f7bf3€49.00€0.67matched
81capture01a1a77c-39f8-7c17-aae1-6a0f9159e831€35.00€0.50matched
82refund01a1a77c-3d7a-78d9-b418-b979b5615fc7-€5.00€0.00matched
83capture01a1a77c-4113-7315-9979-ef25407c4d84€35.00€0.50matched
84capture01a1a77c-5e8c-7ec7-bfc9-f265fc2bb369€24.00€0.37matched
85capture01a1a77c-768c-76db-9064-c39574d1765d€24.00€0.37matched
86capture01a1a77c-7832-7f5f-b9ad-342184390c6c€9.00€0.19matched
87capture01a1a77c-79eb-79ce-9bb3-2d5bd07fafae€49.00€0.67matched
88capture01a1a77c-81f2-771a-adc7-46402233bfa7€15.00€0.26matched
89capture01a1a77c-93dd-7f31-9951-efb56445b775€9.00€0.19matched
90capture01a1a77c-a3e7-7a50-b7dc-2c8fac321979€9.00€0.19matched
91capture01a1a77c-ac4e-7792-ba30-77d236eb4b68€49.00€0.67matched
92capture01a1a77c-b2f8-7f41-be5d-0b9f17a9c2c6€24.00€0.37matched
93capture01a1a77c-e3fd-768a-af69-f1d969c0c5d6€15.00€0.26matched
94capture01a1a77c-e90c-7171-abd5-4249503dd3bd€24.00€0.37matched
95capture01a1a77c-fd29-7bf5-9e66-17376a1963d7€24.00€0.37matched
96capture01a1a77d-0387-7d16-bb17-0edd9ea104b7€35.00€0.50matched
97capture01a1a77d-18ea-74c9-a0ed-13e239d8fdda€24.00€0.37matched
98capture01a1a77d-1ec0-7ccf-8a38-5f7560ea9e05€24.00€0.37matched
99capture01a1a77d-2211-754f-b4aa-e36b101ad031€24.00€0.37matched
101capture01a1a77d-3609-76aa-a7f7-a6b511522bd6€35.00€0.50matched
102capture01a1a77d-46a4-72c7-b8d6-bc9d4bc148be€49.00€0.67matched
103capture01a1a77d-6bc4-74e3-b422-edf4d93b68bc€49.00€0.67matched
104capture01a1a77d-7cb5-78da-a3ec-5a314673968e€15.00€0.26matched
105capture01a1a77d-7f5f-75f5-a36e-496d5caa648e€35.00€0.50matched
106capture01a1a77d-84f2-7e03-b277-b90fb056b298€15.00€0.26matched
107capture01a1a77d-be48-7733-9136-2cc7c913aecb€35.00€0.50matched
108refund01a1a77d-dae0-7f41-8c3e-3b6ca917bf6f-€28.00€0.00matched
109capture01a1a77d-fa7c-7a49-8de0-74d48db18855€15.00€0.26matched
110capture01a1a77e-2316-7061-bd27-54b8f7d4ae6b€15.00€0.26matched
111capture01a1a77e-2ba7-7de4-864a-7b223da748ff€15.00€0.26matched
112capture01a1a77e-4400-71c1-87ec-ffdf49d4a111€9.00€0.19matched
113capture01a1a77e-7bce-7a0a-a59b-3811c9f71615€24.00€0.37matched
114capture01a1a77e-7c48-772c-9159-0573566bce13€24.00€0.37matched
115capture01a1a77e-9e8e-74de-8318-6248ae19a0a5€49.00€0.67matched
117capture01a1a77e-a17d-714a-9d8a-bd9846276cf0€35.00€0.50matched
118capture01a1a77e-a5c1-7fa3-85d0-d61ce526a9d6€9.00€0.19matched
119capture01a1a77e-a68b-7c9b-bac9-4460d0d096e0€49.00€0.67matched
120capture01a1a77e-ec6e-7d21-9a49-b8ee7ccead0c€24.00€0.37matched
121capture01a1a77e-ed01-70fc-a0fb-b4cae27a6b3c€9.00€0.19matched
122refund01a1a77f-03e5-7e87-9c9f-73517c3ef082-€43.00€0.00matched
123capture01a1a77f-0bcd-7f01-8f3f-9880b3dc4893€35.00€0.50matched
124capture01a1a77f-14a0-7a94-99bb-e8d6c2538bf4€15.00€0.26matched
125capture01a1a77f-1e51-7a66-8f41-827f8b603194€15.00€0.26matched
126capture01a1a77f-2dbc-7494-9783-c1a17bb8454d€49.00€0.67matched
127capture01a1a77f-58f3-7233-af8a-1527165834fd€49.00€0.67matched
128capture01a1a77f-95c8-769b-8e00-713a6e3e33c3€24.00€0.37matched
129capture01a1a77f-ac1c-7b62-8769-5c41717b7a77€49.00€0.67matched
130capture01a1a77f-d6a9-7e41-859c-2854cd815bc3€15.00€0.26matched
131capture01a1a77f-d94d-7ddf-8d57-81993ad38f45€49.00€0.67matched
132capture01a1a77f-f913-7314-a35e-0ea3dfa397b9€15.00€0.26matched
133capture01a1a780-28ba-7215-b197-be8461645ec4€9.00€0.19matched
134capture01a1a780-3b71-7432-a488-dc9c24ce9962€49.00€0.67matched
135capture01a1a780-3d11-7e4d-ab9b-7360a5fb5dc3€15.00€0.26matched
136capture01a1a780-65c4-7b65-9bec-0d61cbb52db3€24.00€0.37matched
137capture01a1a780-b473-763e-8042-9e4fd7ab0fca€49.00€0.67matched
138capture01a1a780-ca8f-7a9e-9e45-3955efa66e06€15.00€0.26matched