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

Gross

€2,408.00

PSP fee

€39.02

Net to the bank

€2,368.98

Settlement journal

#339883

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19b6f-cae2-7fc6-8913-42941f76bceb is already settled by stl_EUR_2989348 line 66
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
LineKindReferenceGrossFeeStatus
58capture01a19b6e-f3a4-70cc-8626-7cd02a879f5c€9.00€0.22fee difference
67capture01a19b6f-cd9a-7ba6-8eb3-c6af7125e5a9€35.00€0.50duplicate line
1capture01a19b65-b555-7751-af69-4cc4344642cc€24.00€0.37matched
2capture01a19b66-d50e-7906-89b1-6b4ad36c57ce€9.00€0.19matched
3capture01a19b6a-5be3-70f6-a6de-37119ba9ebd3€35.00€0.50matched
4capture01a19b6a-5e97-7fc0-81e1-8873b640ca1d€24.00€0.37matched
5capture01a19b6a-6a12-7ffa-af17-9cd72e5dad3a€15.00€0.26matched
6capture01a19b6a-6df8-7797-ac96-dfe78f1f1393€35.00€0.50matched
7capture01a19b6a-77b6-7619-97be-c6aeebc61135€24.00€0.37matched
8capture01a19b6a-818c-7fde-ad43-c40df812ee36€15.00€0.26matched
9capture01a19b6a-952a-71f5-b3c6-7fd0dd42c26c€35.00€0.50matched
10capture01a19b6a-c6de-74b1-8ce4-5914eb1192e6€35.00€0.50matched
11capture01a19b6a-fbb0-75c5-85cf-6153951e4d45€24.00€0.37matched
12capture01a19b6b-68ee-7226-ba68-ea90e8e741b0€24.00€0.37matched
13capture01a19b6b-8cd3-7bdb-97b5-22ee5abbc32f€35.00€0.50matched
14capture01a19b6b-9cbf-72db-b650-f84c42fed9b2€49.00€0.67matched
15capture01a19b6b-b54f-7bdd-9c01-9b21001300c2€35.00€0.50matched
16refund01a19b6b-bca6-78a8-93e1-ddedc3dee4b0-€20.00€0.00matched
17capture01a19b6b-d5cf-744d-9538-2615d8824932€15.00€0.26matched
18capture01a19b6b-da46-7f96-9507-884fc447e404€24.00€0.37matched
19capture01a19b6b-fa92-7984-9b82-0b4c02af23ef€15.00€0.26matched
20capture01a19b6c-11b5-7cd2-b02d-74468685f3e0€35.00€0.50matched
21capture01a19b6c-5810-77db-bb1d-ed636019efa6€9.00€0.19matched
22capture01a19b6c-5a21-7dc7-9265-b17aa011409f€9.00€0.19matched
23capture01a19b6c-5a33-73aa-b71c-945227af41cc€15.00€0.26matched
24capture01a19b6c-6d24-745e-b474-e7de12688ce7€9.00€0.19matched
25capture01a19b6c-7a46-71ee-9855-6edefc561eb9€15.00€0.26matched
26capture01a19b6c-7ca0-7482-be8d-8934f6fe56d3€15.00€0.26matched
27refund01a19b6c-8a99-7197-84e2-32b1bb93a980-€4.00€0.00matched
28capture01a19b6c-8f4e-79ec-a65f-722cc14e5b29€9.00€0.19matched
29capture01a19b6c-cbf4-7371-8b95-25132ccb4a5d€35.00€0.50matched
30capture01a19b6c-cce9-78d0-bfa5-299a99edbdf0€35.00€0.50matched
31capture01a19b6c-df9e-75ad-8e6c-85c63a0674d4€35.00€0.50matched
32capture01a19b6c-e4c3-7a14-be84-2b288b6a78b0€15.00€0.26matched
33capture01a19b6c-eba7-7fc2-90f7-42f69912fe44€35.00€0.50matched
34capture01a19b6c-f195-718c-a01b-fdf4f6202d81€49.00€0.67matched
35refund01a19b6c-fa35-7780-ae5b-0a373db40b1b-€20.00€0.00matched
36capture01a19b6c-fca1-7a1e-ab36-a9c42e874bb6€9.00€0.19matched
37capture01a19b6d-303f-7403-a32a-ba6b1d5078a2€15.00€0.26matched
38capture01a19b6d-3093-7633-a833-f29aa9021301€15.00€0.26matched
39capture01a19b6d-46c0-7e6e-8d3b-155bcc2cb2ea€24.00€0.37matched
40capture01a19b6d-570f-7393-81ab-2f350dfe31e5€24.00€0.37matched
41capture01a19b6d-82cf-7469-ab25-5b9302d59839€15.00€0.26matched
42capture01a19b6d-a84f-702f-8337-11b1313a99d4€9.00€0.19matched
43capture01a19b6d-ae52-7992-8c28-e5c3e59213f1€15.00€0.26matched
44capture01a19b6d-d5ab-7d26-8498-d9ea1e90dd3f€49.00€0.67matched
45capture01a19b6d-efa5-778d-833b-ad56e95b359c€9.00€0.19matched
46capture01a19b6e-0ec0-7876-b422-46e012e4a8a1€9.00€0.19matched
47capture01a19b6e-0a3b-7f9f-a928-9a3b880fd3d3€24.00€0.37matched
48capture01a19b6e-14a1-7914-91e4-872b8eb15c44€49.00€0.67matched
49capture01a19b6e-18c0-71ef-9422-6cb882ad62b3€15.00€0.26matched
50capture01a19b6e-225c-717c-a062-2529a45e6adc€49.00€0.67matched
51refund01a19b6e-7f61-7517-9a6b-bde4348a5a6d-€20.00€0.00matched
52capture01a19b6e-8c0e-7e29-8c8e-771f58862ba6€24.00€0.37matched
53capture01a19b6e-9e55-7d33-b26d-1c6aee9593e0€35.00€0.50matched
54capture01a19b6e-a9d6-74c9-b2c7-19fd3e9d43bc€9.00€0.19matched
55capture01a19b6e-c908-76c9-bf38-4e948f64e632€15.00€0.26matched
56capture01a19b6e-cd01-7b3c-8d45-69126d4e563e€49.00€0.67matched
57capture01a19b6e-efb3-7bb9-ad72-c869f3aa72db€49.00€0.67matched
59capture01a19b6f-0e02-711f-9d6e-98dbac70b77e€24.00€0.37matched
60refund01a19b6f-11c8-72f5-a0aa-1e93e05fa182-€32.00€0.00matched
61capture01a19b6f-35f0-7185-bf8e-4cb6f22a1ec1€15.00€0.26matched
62capture01a19b6f-3e24-7706-82d5-a7c620f616e4€24.00€0.37matched
63capture01a19b6f-7517-7df4-ac91-84d02911cedf€9.00€0.19matched
64refund01a19b6f-8319-76d1-b695-cd8c16bd3b50-€7.00€0.00matched
65capture01a19b6f-a60e-72e8-a693-abc203622bb2€15.00€0.26matched
66capture01a19b6f-cd9a-7ba6-8eb3-c6af7125e5a9€35.00€0.50matched
68capture01a19b6f-cdce-7164-b6d3-15ecebb3580e€15.00€0.26matched
69capture01a19b6f-d28d-77fc-8aa8-3f6a4f6b7e4e€35.00€0.50matched
70capture01a19b6f-dec2-7c46-adcb-b90f77dff421€35.00€0.50matched
71capture01a19b6f-f306-72cf-8978-a39ae507c096€15.00€0.26matched
72capture01a19b70-11f8-77e3-8f0c-9cf44ecefdab€49.00€0.67matched
73capture01a19b70-36e6-7f14-9f3c-352edd0678eb€9.00€0.19matched
74capture01a19b70-3ab4-773b-ac6b-c232c12d7707€9.00€0.19matched
75capture01a19b70-5b34-7006-97de-a1a7dd3c9f17€35.00€0.50matched
76capture01a19b70-8ab1-705d-92af-bc05f6aefecd€9.00€0.19matched
77capture01a19b70-b25a-7d6e-84ab-a4582e6d6571€15.00€0.26matched
78capture01a19b70-b752-7471-a3d7-99b09b701d1b€15.00€0.26matched
79capture01a19b70-ca9c-79f8-91c6-cef747be546f€35.00€0.50matched
80capture01a19b70-ce86-7dda-8d2f-15305cdc9f7c€9.00€0.19matched
81capture01a19b70-d14c-767f-b287-8df374c9fd8e€15.00€0.26matched
82capture01a19b70-d2c4-7294-bfc8-b9274b393bf3€9.00€0.19matched
83capture01a19b70-edf8-7683-8837-25d21de1cb1e€35.00€0.50matched
84capture01a19b71-07f7-7226-94b5-10fc23f71aa1€49.00€0.67matched
85capture01a19b71-12c3-7a1b-9caa-e36dd05f7333€15.00€0.26matched
86refund01a19b71-20c8-74d8-90a8-51f8fc98747d-€7.00€0.00matched
87refund01a19b71-315d-7efe-87f3-be3df344ffb2-€3.00€0.00matched
88capture01a19b71-4781-7ee0-91fc-9866ee7be60d€24.00€0.37matched
89capture01a19b71-4dbc-797b-98ad-409789e2d00c€15.00€0.26matched
90capture01a19b71-5ac9-76c6-ad0c-cf81d20f0769€15.00€0.26matched
91capture01a19b71-6346-7a9b-9ad2-d85de8f35bd1€49.00€0.67matched
92capture01a19b71-859c-789e-a3d6-634678deabe5€35.00€0.50matched
93capture01a19b71-8d18-7fde-8e54-a288eabc82bb€15.00€0.26matched
94capture01a19b71-a7ad-78e8-afe0-26fdd014a4dd€35.00€0.50matched
95capture01a19b71-c7e3-7dac-9fcf-c8daac0b2108€15.00€0.26matched
96capture01a19b71-cc94-7912-9601-8ab85e874777€35.00€0.50matched
97capture01a19b71-e765-7dd4-99d5-34980df7eb01€35.00€0.50matched
98capture01a19b72-02bb-754c-a49c-f65edc9fc74a€49.00€0.67matched
99capture01a19b72-03a5-72a8-af4e-f8a0f79decc4€9.00€0.19matched
100capture01a19b72-1830-7f9a-87cb-b18584f956be€49.00€0.67matched
101capture01a19b72-1df7-77dc-81a8-b4fadd762d5c€49.00€0.67matched
102capture01a19b72-2fe6-7928-a2f3-e992eebb7e3e€15.00€0.26matched
103refund01a19b72-4b93-79a0-b8b9-fba7cb33bbc5-€14.00€0.00matched
104capture01a19b72-7766-79a0-ba8b-123732389f2f€15.00€0.26matched
105capture01a19b72-79d2-7a96-93a2-dd8b13853c9d€15.00€0.26matched
106capture01a19b72-89f2-7057-bdf0-748080040b7a€24.00€0.37matched
107capture01a19b72-941c-73f2-9a18-33662e68e6f6€9.00€0.19matched
108capture01a19b72-a098-7024-a3fd-0f939760d66b€35.00€0.50matched
109capture01a19b72-aed0-74e7-b3c0-72fe5b2d71bf€35.00€0.50matched
110capture01a19b72-d49a-7ab6-97fb-481f3e22b68f€15.00€0.26matched
111capture01a19b72-dabe-744c-a352-b985948af373€9.00€0.19matched
112refund01a19b73-1489-7381-a285-ae602fc9b3d7-€6.00€0.00matched
113capture01a19b73-1539-7274-a40c-11aa2a866fc5€15.00€0.26matched
114capture01a19b73-242d-7977-b16a-c137c73b0a39€24.00€0.37matched
115capture01a19b73-4e07-723d-b7ec-92c952c0661c€24.00€0.37matched