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, 15:10

Gross

€2,585.00

PSP fee

€43.13

Net to the bank

€2,541.87

Settlement journal

#344848

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19cd3-9974-760b-944e-0e479339d5f7 is already settled by stl_EUR_2989387 line 47
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
LineKindReferenceGrossFeeStatus
28refund01a19cd1-ff4f-7981-8b6b-727308bf054b-€33.00€0.02fee difference
48capture01a19cd3-999b-7026-9660-e367372df088€49.00€0.67duplicate line
1capture01a19cc8-d767-74aa-83d6-a6fe2673816e€24.00€0.37matched
2capture01a19ccf-79c6-7649-8900-63e4b3280621€9.00€0.19matched
3refund01a19ccf-bc4a-7173-9895-61455575d456-€32.00€0.00matched
4capture01a19cd0-26c5-7782-89a2-0a6e12c06583€15.00€0.26matched
5capture01a19cd0-27a0-7e37-bd75-69b537fe852b€24.00€0.37matched
6capture01a19cd0-2ca7-7232-b1cc-ac254fa5d446€15.00€0.26matched
7refund01a19cd0-5e38-7cc3-8b29-6b9ae0ddc0c9-€9.00€0.00matched
8capture01a19cd0-699b-78b8-a4a0-6ad67d8181d9€35.00€0.50matched
9capture01a19cd0-6e2c-7f5c-bd7c-ddc00cb1a318€15.00€0.26matched
10capture01a19cd0-6e90-7675-9253-5e326b67306a€24.00€0.37matched
11capture01a19cd0-9698-7e51-8cb0-c9cafd2c5fa3€35.00€0.50matched
12capture01a19cd0-a928-7409-af83-9ec8d39dea00€15.00€0.26matched
13capture01a19cd0-ab4b-78db-90af-f91862af921b€49.00€0.67matched
14capture01a19cd0-ca89-75da-a2fc-eab078a45759€49.00€0.67matched
15capture01a19cd0-d047-7bb9-b91f-707f1e5ac65b€35.00€0.50matched
16capture01a19cd0-ff10-7119-9378-c88ccfa827d8€15.00€0.26matched
17capture01a19cd1-108a-7008-8609-0d286ed02467€15.00€0.26matched
18refund01a19cd1-36b0-70e9-86d8-effcb5887280-€25.00€0.00matched
19capture01a19cd1-5da0-7cef-8174-d7a1eb955bcb€35.00€0.50matched
20capture01a19cd1-6449-7d37-bec0-63d38743084a€15.00€0.26matched
21capture01a19cd1-6d36-7d47-9c25-1011b45cb149€15.00€0.26matched
22capture01a19cd1-75cb-7d09-beb2-ede8a439b42e€15.00€0.26matched
23capture01a19cd1-7f62-7035-9668-187636646943€15.00€0.26matched
24capture01a19cd1-b061-7827-826f-b8c9e039f02a€35.00€0.50matched
25capture01a19cd1-cc00-79cb-9870-2e8a179277e7€49.00€0.67matched
26capture01a19cd1-d612-72b9-866d-91ef832b4068€15.00€0.26matched
27capture01a19cd1-dc4b-79b9-ab37-ce6061672247€49.00€0.67matched
29capture01a19cd2-3725-7aaa-8b62-3657375a518d€24.00€0.37matched
30capture01a19cd2-46a9-7231-b262-2ccdc7f394b3€35.00€0.50matched
31capture01a19cd2-4e43-7d9f-ad98-e68cfed5c2a1€15.00€0.26matched
32capture01a19cd2-922d-7938-a606-bbd0cd22335a€9.00€0.19matched
33capture01a19cd2-9a6e-798d-b684-c0cc03c2870f€24.00€0.37matched
34capture01a19cd2-a0da-7c2e-b184-08e50fd3cd5d€24.00€0.37matched
35capture01a19cd2-bce6-760b-aeaa-1f14509e78ec€49.00€0.67matched
36capture01a19cd2-bd51-762e-8d38-3329006f5e20€35.00€0.50matched
37capture01a19cd2-c7d0-76cc-9656-d2aa949262b2€35.00€0.50matched
38capture01a19cd2-e33b-7d3e-92ac-c885103ee523€35.00€0.50matched
39capture01a19cd2-eb8c-7b70-80d3-0b97cf13c402€9.00€0.19matched
40capture01a19cd2-f244-79ac-8490-f2709eab4f51€15.00€0.26matched
41capture01a19cd3-0832-7130-9276-f7ca32b5c5b1€35.00€0.50matched
42capture01a19cd3-22cb-7b2f-baaa-37c65ecac555€35.00€0.50matched
43capture01a19cd3-53c6-7c4d-a7ba-28be0ab9c23e€35.00€0.50matched
44capture01a19cd3-58e8-7efa-9357-50a9fc95eaf3€9.00€0.19matched
45capture01a19cd3-7179-77f8-8d1d-e79102febcb4€49.00€0.67matched
46capture01a19cd3-92d5-7495-90f7-1c4938f2c108€9.00€0.19matched
47capture01a19cd3-999b-7026-9660-e367372df088€49.00€0.67matched
49capture01a19cd3-a47e-71ea-9838-6a85646cfd32€35.00€0.50matched
50refund01a19cd3-b650-7212-89ad-545f171e65e1-€30.00€0.00matched
51refund01a19cd3-bd77-7713-b034-7c416a482596-€28.00€0.00matched
52refund01a19cd3-d7be-77ac-b9fd-00bf68af83ce-€5.00€0.00matched
53capture01a19cd3-f1fc-7160-9435-e60116de765a€35.00€0.50matched
54capture01a19cd3-f24a-73e7-9784-fe91375583f0€24.00€0.37matched
55capture01a19cd3-f34a-70a7-be6c-e5ada4483eb8€9.00€0.19matched
56capture01a19cd4-09db-70e0-b418-992c7dd6d6a5€49.00€0.67matched
57capture01a19cd4-0ef4-7e33-9fb3-afa9477b5ff4€35.00€0.50matched
58capture01a19cd4-1c4e-738e-92f5-c62914ad3863€49.00€0.67matched
59capture01a19cd4-1e08-7cb1-af4c-93b3b23b4d0c€24.00€0.37matched
60refund01a19cd4-59f8-7b47-9ab3-e88c4b69c317-€23.00€0.00matched
61capture01a19cd4-6995-7066-815e-a99fc2ee6936€9.00€0.19matched
62capture01a19cd4-73ef-7b14-b5c7-055f6222cb4c€9.00€0.19matched
63capture01a19cd4-8763-7611-b7bb-11096184da47€35.00€0.50matched
64capture01a19cd4-a73f-7105-bb52-1f7581b30f83€24.00€0.37matched
65capture01a19cd4-a8f0-73e4-88b3-aa506e73d033€15.00€0.26matched
66capture01a19cd4-c5f2-7e69-bf5b-8d8821bc1f65€9.00€0.19matched
67capture01a19cd4-e5a3-715b-afe4-eb5bd57e456f€9.00€0.19matched
68capture01a19cd5-1452-7b95-b3b4-c8eb7964884b€24.00€0.37matched
69capture01a19cd5-22ff-7924-9277-ba265eeb21ea€9.00€0.19matched
70capture01a19cd5-5614-7244-8268-89ad0a7ceccd€9.00€0.19matched
71capture01a19cd5-5de6-71a6-8d56-4a5cd5533aa7€49.00€0.67matched
72refund01a19cd5-7c5d-776e-ace3-c920179a87d3-€8.00€0.00matched
73capture01a19cd5-aaed-7493-81c0-62e0c9b6371d€49.00€0.67matched
74capture01a19cd5-ad7c-73ca-b4eb-3f3a22cee3fc€24.00€0.37matched
75capture01a19cd5-bbb6-75a2-9843-5f3691a53e4e€15.00€0.26matched
76capture01a19cd5-bcdc-7244-aa4e-f9d29249fd33€24.00€0.37matched
77capture01a19cd5-c8f9-7c5e-a0a3-37a3d223b361€35.00€0.50matched
78capture01a19cd5-dcc8-7e76-a5a5-73f325646817€49.00€0.67matched
79capture01a19cd5-e646-7de6-8d12-133e67199e57€35.00€0.50matched
80capture01a19cd6-0da8-7615-8a92-18eb6bd1b7dc€49.00€0.67matched
81capture01a19cd6-1840-7397-95b1-f88c2815527e€9.00€0.19matched
82capture01a19cd6-21e6-714f-9f24-ed5bcc571740€24.00€0.37matched
83capture01a19cd6-2728-7ec0-855c-66d30b93960d€24.00€0.37matched
84capture01a19cd6-294f-7740-a0d2-dedb79c55bd3€15.00€0.26matched
85capture01a19cd6-2abc-7a6a-a47e-3613b5540d4c€24.00€0.37matched
86capture01a19cd6-3e8b-7fb6-8089-10f87bd67d1b€15.00€0.26matched
87capture01a19cd6-5626-7502-966e-3eb5ea8e9682€49.00€0.67matched
88capture01a19cd6-647c-713a-bf9d-12cb50a34ada€9.00€0.19matched
89capture01a19cd6-a01f-74e8-88e0-a3693e6cf664€35.00€0.50matched
90capture01a19cd6-a457-71b9-8951-05dea88a4910€9.00€0.19matched
91capture01a19cd6-e7be-77ee-9ab8-4f1001893056€35.00€0.50matched
92capture01a19cd6-ff48-7ea8-8286-cc0dda596098€24.00€0.37matched
93capture01a19cd7-0279-7455-80b8-20b91c5b12b4€15.00€0.26matched
94capture01a19cd7-15ce-70d0-96a1-d6401e6a6b7d€49.00€0.67matched
95capture01a19cd7-2689-7e67-8520-9ba73ea5fe7f€24.00€0.37matched
96capture01a19cd7-2db3-726e-b79e-4dfc52cc4dfd€24.00€0.37matched
97capture01a19cd7-38df-76c4-b805-c4e0e18b7ba7€35.00€0.50matched
98capture01a19cd7-5188-7c12-81a4-ccc572d8eebd€9.00€0.19matched
99refund01a19cd7-6ff9-789d-a560-65d54d1b460c-€16.00€0.00matched
100capture01a19cd7-79c1-7ff1-976f-e59b519f2f66€35.00€0.50matched
101capture01a19cd7-7a8f-7cf1-ba33-677c27da5304€15.00€0.26matched
102capture01a19cd7-7d88-7443-b981-2fdf0e76eefe€15.00€0.26matched
103capture01a19cd7-7f01-7a5f-a3c0-2097fd1f425f€9.00€0.19matched
104refund01a19cd7-7f7a-71b3-9a87-92251b3b4be9-€30.00€0.00matched
105capture01a19cd7-9cec-77b4-a2cc-5f81a962722e€24.00€0.37matched
106capture01a19cd7-9e01-75b7-aaf6-e4d942ea016f€49.00€0.67matched
107capture01a19cd7-ca6f-7ed9-8674-e34c429c8988€49.00€0.67matched
108refund01a19cd7-ebcc-712b-9e84-c1f207731383-€12.00€0.00matched
109capture01a19cd7-f5dd-7790-bdaf-0d66bbc2b42f€24.00€0.37matched
110capture01a19cd8-1343-7240-b70a-543dc2c16b1d€49.00€0.67matched
111capture01a19cd8-21a3-74fe-b734-d4170307d671€15.00€0.26matched
112refund01a19cd8-313f-76c2-b2d1-48592e79824c-€40.00€0.00matched
113capture01a19cd8-39fb-72e1-ae56-e161526d8f16€35.00€0.50matched
114capture01a19cd8-3b62-72e7-876b-d491df47d571€49.00€0.67matched
115capture01a19cd8-4c4f-70d9-a057-a091883c535a€49.00€0.67matched
116capture01a19cd8-5330-7094-8fa4-74ee27c2d8e0€9.00€0.19matched
117capture01a19cd8-54c7-77eb-a77d-e4fff11b963f€35.00€0.50matched
118capture01a19cd8-660e-753c-a053-86ea0e58079b€35.00€0.50matched
119capture01a19cd8-7124-7f06-a7ad-0da3932399a2€15.00€0.26matched