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

Gross

€2,890.00

PSP fee

€45.12

Net to the bank

€2,844.88

Settlement journal

#378803

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a666-1326-7e20-897c-4b6e6d37e4d8 is already settled by stl_EUR_2989655 line 15
  • duplicate linethe file lists it twicecapture:01a1a66c-c93f-77c1-b1b2-5624c587a459 is already settled by stl_EUR_2989655 line 99
LineKindReferenceGrossFeeStatus
16capture01a1a666-2a14-72b1-aec4-8e6c9f7f7384€15.00€0.26duplicate line
100capture01a1a66c-c957-7467-a06b-5bc355811120€24.00€0.37duplicate line
1capture01a1a65d-735c-76be-94d8-3255f9c966cf€15.00€0.26matched
2capture01a1a665-03e4-7e3d-b96a-94bdbb18efe1€15.00€0.26matched
3capture01a1a665-144e-72a7-af1d-9fb473280ac3€9.00€0.19matched
4capture01a1a665-1765-707a-99e0-945a50aa77cf€35.00€0.50matched
5capture01a1a665-3c8c-79f3-842c-cd33d9356f6c€24.00€0.37matched
6capture01a1a665-6ab4-77c4-b154-a3a60f5dad14€49.00€0.67matched
7capture01a1a665-7e4c-700e-a61f-d07bc713c527€49.00€0.67matched
8capture01a1a665-8042-7a3a-8cc8-66a898c35a87€35.00€0.50matched
9capture01a1a665-b9cc-7a3e-a7a4-ec2c83c1dac4€9.00€0.19matched
10capture01a1a665-c1a6-7a02-bd41-842879dbd336€35.00€0.50matched
11capture01a1a665-c718-783b-a375-88ddbae6bd25€49.00€0.67matched
12refund01a1a665-d0cc-7bc5-a112-415f0cbdf06f-€45.00€0.00matched
13capture01a1a666-13c9-7209-bcb6-a1d6697963eb€49.00€0.67matched
14capture01a1a666-1999-7162-9b05-eb147e892fd7€35.00€0.50matched
15capture01a1a666-2a14-72b1-aec4-8e6c9f7f7384€15.00€0.26matched
17capture01a1a666-3deb-7076-88fb-964dec46123e€9.00€0.19matched
18capture01a1a666-4583-7ecb-b858-4bfddaa2ac46€49.00€0.67matched
19capture01a1a666-8d99-7199-bc28-51b0ab3c5d36€35.00€0.50matched
20refund01a1a666-92c4-7526-9725-2c17ec318456-€47.00€0.00matched
21capture01a1a666-971e-7437-8ea3-63e07cb4cefa€49.00€0.67matched
22capture01a1a666-a4b3-7cc0-9154-3c6dd7acc4ce€35.00€0.50matched
23capture01a1a666-b6e2-719d-af86-acf90c207f42€49.00€0.67matched
24capture01a1a666-ccca-702a-b1a3-ef7d96ae778f€15.00€0.26matched
25capture01a1a666-d13d-7436-911e-5e5bf038e18e€49.00€0.67matched
26capture01a1a667-295d-7dc6-8f8b-73318324b629€15.00€0.26matched
27capture01a1a667-61cf-7700-b7e0-67ca12f9be9f€35.00€0.50matched
28capture01a1a667-62e2-7865-9637-cbf2c3b6add0€35.00€0.50matched
29capture01a1a667-94bc-761c-9bde-d977ca705878€49.00€0.67matched
30capture01a1a667-ad19-7c91-b4b3-243bd5afd552€49.00€0.67matched
31capture01a1a667-caa2-7cd7-8d0e-bb19b214d6f3€35.00€0.50matched
32capture01a1a667-e067-76d9-9d8c-29dde50c78be€49.00€0.67matched
33capture01a1a667-e658-7196-a087-c38b1c4e890f€49.00€0.67matched
34capture01a1a668-18c3-72ef-b96c-53caef32bec8€49.00€0.67matched
35capture01a1a668-1daa-7724-a82a-c6d59e1778be€35.00€0.50matched
36capture01a1a668-2677-7862-8ef9-e49caf54f4ef€9.00€0.19matched
37capture01a1a668-2e1b-746b-bc6c-e083d400c96b€49.00€0.67matched
38capture01a1a668-48a2-7c07-a1fa-70c56933a589€35.00€0.50matched
39capture01a1a668-58bd-731c-be77-322576d9f9be€9.00€0.19matched
40capture01a1a668-7a95-7f9a-a077-3e6a8746c77a€35.00€0.50matched
41capture01a1a668-81eb-7075-82d8-5157a2c488e0€49.00€0.67matched
42capture01a1a668-9197-793e-ae81-859382e9dc48€9.00€0.19matched
43capture01a1a668-96ba-7fd7-bd04-ff3342399d52€35.00€0.50matched
44capture01a1a668-bdd0-7a7c-982c-5fe6ac33ea68€24.00€0.37matched
45refund01a1a668-c8c4-7512-b2bf-36f0839957bf-€26.00€0.00matched
46capture01a1a668-d16b-72c5-a54a-96e3b6a756a4€9.00€0.19matched
47capture01a1a668-ed3f-7837-8c8f-cbc6372bd157€9.00€0.19matched
48capture01a1a668-f678-7bfb-acf9-d199898eb413€35.00€0.50matched
49refund01a1a668-fd3e-7715-a1b8-b33bae402fe9-€13.00€0.00matched
50capture01a1a669-036f-75a2-9d02-949402080f94€24.00€0.37matched
51capture01a1a669-2c4f-75ab-90f1-ce48612df613€15.00€0.26matched
52capture01a1a669-2c91-7942-9028-99b6e783a8b1€35.00€0.50matched
53capture01a1a669-3faf-7cc8-9711-22b07e3d1f5f€35.00€0.50matched
54capture01a1a669-4d7a-75ce-8f55-e2249c13f15e€49.00€0.67matched
55capture01a1a669-5594-7091-a115-df782ce258d1€24.00€0.37matched
56capture01a1a669-62cd-74d2-830d-61e1a60fe889€24.00€0.37matched
57refund01a1a669-7efa-7802-a39c-2a97464b571b-€16.00€0.00matched
58capture01a1a669-8078-7fec-afb5-5baf2a6924bc€9.00€0.19matched
59capture01a1a669-89c7-77b0-888c-fb588160ab26€35.00€0.50matched
60capture01a1a669-96e4-7a7c-9c6d-cd10e45c3087€49.00€0.67matched
61capture01a1a669-abb9-72e0-8140-f509493fb2f7€35.00€0.50matched
62capture01a1a669-be05-758d-b6cc-a25c93561031€35.00€0.50matched
63capture01a1a66a-253a-7cc2-af28-18f192a52053€49.00€0.67matched
64capture01a1a66a-2a4f-79cc-9272-44c0e6d4faae€9.00€0.19matched
65capture01a1a66a-42a0-7e0e-8852-555dcbc6bc54€49.00€0.67matched
66capture01a1a66a-43b2-78a8-b058-696e8c0987fe€24.00€0.37matched
67capture01a1a66a-4f0b-7bfb-8db9-7c68ffb11ae5€15.00€0.26matched
68capture01a1a66a-5aeb-7618-8e38-cfccca953cd2€15.00€0.26matched
69capture01a1a66a-5ce6-7e8b-a1f7-1c7373cec9ba€35.00€0.50matched
70capture01a1a66a-7639-7b68-92ce-d5e276d1ad94€35.00€0.50matched
71capture01a1a66a-9b0b-7102-8e7a-4071bec30df3€9.00€0.19matched
72capture01a1a66a-a0b7-70e6-871a-a528ff446298€15.00€0.26matched
73capture01a1a66a-b15a-7bfe-89ee-81e0eaafc59f€9.00€0.19matched
74capture01a1a66a-d1f0-77b3-a6ee-8e5d17eac3a3€9.00€0.19matched
75capture01a1a66a-da31-7cb3-9a54-23a0c8128650€24.00€0.37matched
76capture01a1a66a-df50-7f4e-96da-de43f977848c€15.00€0.26matched
77capture01a1a66a-e7b6-77ee-a74f-9627c493660c€49.00€0.67matched
78capture01a1a66b-14bc-7bda-93ad-f64d1ea1ac5b€35.00€0.50matched
79capture01a1a66b-2317-7812-ba5d-0769deae1615€35.00€0.50matched
80capture01a1a66b-26b6-7e4e-8048-492d215f7cdd€15.00€0.26matched
81capture01a1a66b-2d89-706f-a20f-5e7991bfbb98€15.00€0.26matched
82capture01a1a66b-4f73-7a7a-a3a4-5bdf5e38a2f4€9.00€0.19matched
83capture01a1a66b-5a05-77f0-b3b5-89c860b2a255€24.00€0.37matched
84capture01a1a66b-5b2a-7d72-9cb0-2511db84b038€35.00€0.50matched
85capture01a1a66b-8d7a-7fd8-b5dc-607e429c3146€49.00€0.67matched
86capture01a1a66b-9716-7fc6-90d6-612a94d7d5b3€49.00€0.67matched
87capture01a1a66b-993b-7ef0-84eb-8a258ab0c41f€24.00€0.37matched
88capture01a1a66b-def1-7d3c-bcb4-bbfc8f4d32d6€15.00€0.26matched
89capture01a1a66b-f197-7a5b-b79e-26331d89bb57€9.00€0.19matched
90capture01a1a66c-0e63-7d8f-9a2b-91d3d13df70f€24.00€0.37matched
91capture01a1a66c-6170-7a9a-904b-99ee050b719d€24.00€0.37matched
92capture01a1a66c-611b-7408-9a77-b18a11fa8fa2€49.00€0.67matched
93capture01a1a66c-77d4-7514-9fc9-7fc934b5190f€15.00€0.26matched
94capture01a1a66c-7ecb-7e09-aae1-b016570e99d3€49.00€0.67matched
95capture01a1a66c-853f-7e20-bfc7-0ece3f590b47€9.00€0.19matched
96capture01a1a66c-a46a-75f7-bd95-704f4e1c8b7b€15.00€0.26matched
97capture01a1a66c-c66d-7145-9b7e-7244d9899916€9.00€0.19matched
98capture01a1a66c-c8b4-7774-bc94-0fe13443f2c7€9.00€0.19matched
99capture01a1a66c-c957-7467-a06b-5bc355811120€24.00€0.37matched
101capture01a1a66c-eb74-7c5d-a0e5-91af75f1a0d5€9.00€0.19matched
102capture01a1a66d-00d3-72da-8c76-62c1b6bf4b57€35.00€0.50matched
103refund01a1a66d-06f1-776b-be39-cb4a276b509c-€6.00€0.00matched
104capture01a1a66d-0ee4-7e26-8b39-07e18452953f€49.00€0.67matched
105capture01a1a66d-538a-703f-b543-52713ed8282b€15.00€0.26matched
106capture01a1a66d-677a-7566-8b0a-cab5cc6323dc€35.00€0.50matched
107capture01a1a66d-70e5-778e-aa25-41264d70ac3a€24.00€0.37matched
108capture01a1a66d-b57f-7a7e-ab08-ae1b5b07a6b6€24.00€0.37matched
109capture01a1a66d-bb01-76d2-b882-153cc7f8640c€49.00€0.67matched
110capture01a1a66d-e317-7b59-a19b-750fa9f0950a€15.00€0.26matched
111capture01a1a66d-edc1-7c53-8aca-03cfec26bd72€49.00€0.67matched
112capture01a1a66e-0c8f-7179-b791-c344765bd02f€9.00€0.19matched