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

3 Nov, 04:30

Gross

€2,354.00

PSP fee

€36.78

Net to the bank

€2,317.22

Settlement journal

#355085

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19fb3-81ce-780e-99ca-3a94808037dc is already settled by stl_EUR_2989467 line 89
  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
LineKindReferenceGrossFeeStatus
22capture01a19fad-7170-7e3c-99ee-6614c7201e7e€24.00€0.42fee difference
25capture01a19fad-d243-7de9-bef0-c835c9322f80€9.00€0.21fee difference
90capture01a19fb3-81e9-748b-9f6f-1ff6acf37364€35.00€0.50duplicate line
1capture01a19fab-4656-7eb6-b59a-37c631215fe6€49.00€0.67matched
2refund01a19fab-d7b3-7c0a-85ad-d7168923823a-€7.00€0.00matched
3capture01a19fab-d985-7b5e-a1cc-21cf308ab443€9.00€0.19matched
4refund01a19fab-de95-7a08-bcf6-bb94bbe99710-€13.00€0.00matched
5capture01a19fac-0dfd-7c23-a736-6bc68c7fd353€49.00€0.67matched
6capture01a19fac-79e8-729b-9e9d-27907f8715f2€35.00€0.50matched
7capture01a19fac-7cd2-7f42-846a-2f525d9075db€49.00€0.67matched
8capture01a19fac-8c62-70de-a41f-0f026fa5b0fc€49.00€0.67matched
9capture01a19fac-8cb3-7091-80ae-65a1a99ef76d€35.00€0.50matched
10capture01a19fac-c96d-7860-9387-ab81e91a9040€9.00€0.19matched
11capture01a19fac-d4e8-7b06-b7c5-339adc8b0aba€35.00€0.50matched
12capture01a19fac-fa33-7a0c-8307-2b6b734cb228€24.00€0.37matched
13capture01a19fad-06b9-744c-b1e1-73dd7e8bdfaf€15.00€0.26matched
14capture01a19fad-13f7-7e23-b775-b55b90242b24€15.00€0.26matched
15capture01a19fad-1bba-7d83-9da5-3d41dac69110€9.00€0.19matched
16capture01a19fad-2628-7679-a558-d6e8cef22dd0€35.00€0.50matched
17refund01a19fad-3775-716a-88de-51109bdd1c18-€9.00€0.00matched
18capture01a19fad-4b08-7148-9384-03588aeba203€15.00€0.26matched
19capture01a19fad-5596-740b-a624-d7c7eb22afc5€15.00€0.26matched
20capture01a19fad-61cd-7d54-b6d3-28bb0e847467€35.00€0.50matched
21capture01a19fad-630b-71bf-ac11-78ff7d01948e€49.00€0.67matched
23capture01a19fad-aaea-78be-8997-78677fbd1503€49.00€0.67matched
24capture01a19fad-c67a-7825-ae27-5a5a7d0b8daf€35.00€0.50matched
26capture01a19fae-07e4-7b98-8bf4-2bb7799ae436€35.00€0.50matched
27capture01a19fae-1e05-763f-9389-137b02f75f19€9.00€0.19matched
28capture01a19fae-29af-7b2e-b40f-8359774a6308€49.00€0.67matched
29capture01a19fae-59c4-72a3-9a35-53ff6bf6c5fb€15.00€0.26matched
30capture01a19fae-8377-72cc-aa50-bd469b8f3469€49.00€0.67matched
31capture01a19fae-935b-7bbd-9d3e-21b784fdef0d€9.00€0.19matched
32capture01a19fae-ce27-78a6-847b-357d96054d45€49.00€0.67matched
33capture01a19fae-e2ca-72e4-9172-4d4e230385cb€9.00€0.19matched
34capture01a19fae-f7f9-7ff7-ad89-7659ae1138d2€49.00€0.67matched
35capture01a19faf-1b37-7d33-95ca-63b9a4691c9b€9.00€0.19matched
36capture01a19faf-216d-7242-9781-b13b59792c26€15.00€0.26matched
37capture01a19faf-284b-7f77-a990-e245a7a64ddd€24.00€0.37matched
38capture01a19faf-39ed-7923-8f83-ab1247e6cf4f€15.00€0.26matched
39capture01a19faf-49f2-7008-9ce8-997ee5e04e45€24.00€0.37matched
40capture01a19faf-5dac-7265-9d41-8827c6e9e675€49.00€0.67matched
41refund01a19faf-6614-7fd9-80ee-6231540b0815-€15.00€0.00matched
42capture01a19faf-8d6b-714c-a36f-5b902f806116€49.00€0.67matched
43capture01a19faf-bc0d-769a-a6a6-98bca4f78afd€24.00€0.37matched
44capture01a19faf-bd3e-71d7-810f-ffcf31319fab€49.00€0.67matched
45capture01a19faf-ec3d-7d7f-88f8-a36160900533€9.00€0.19matched
46capture01a19faf-f58f-7634-bd74-26cb8a1ad5b2€35.00€0.50matched
47capture01a19faf-f6d2-7c18-a9ac-7a5a69e4a9c8€49.00€0.67matched
48capture01a19faf-ffac-7d77-8fa3-bba1e348b1d8€9.00€0.19matched
49capture01a19fb0-115a-7080-b8ca-dc1ace27f42b€15.00€0.26matched
50capture01a19fb0-332f-78b5-8bb1-de27236ad433€49.00€0.67matched
51capture01a19fb0-45e5-7345-8234-086fe0236df2€9.00€0.19matched
52capture01a19fb0-4dc2-727b-aa5e-819fa103179d€9.00€0.19matched
53capture01a19fb0-65b3-7c4f-8c07-e11223af4922€49.00€0.67matched
54capture01a19fb0-9cb8-769d-8dfa-d40c59b57cea€24.00€0.37matched
55capture01a19fb0-a32c-7823-a5ed-971966f326e4€24.00€0.37matched
56capture01a19fb0-d0df-70e3-93dd-6eb493706a12€15.00€0.26matched
57capture01a19fb0-e2c1-78c5-acb3-b2c953812487€35.00€0.50matched
58capture01a19fb0-f8bc-7758-99af-354ff7d68193€9.00€0.19matched
59capture01a19fb1-0004-779b-a52b-bc3ddb12f5dc€15.00€0.26matched
60capture01a19fb1-1178-7e5c-822a-1b585149e82b€15.00€0.26matched
61capture01a19fb1-1990-753f-84b8-dd5f9b4c0f2c€9.00€0.19matched
62capture01a19fb1-49c6-7d0b-9191-afe51725cf6c€24.00€0.37matched
63capture01a19fb1-5449-7271-8160-2391fb207735€15.00€0.26matched
64capture01a19fb1-581d-7b9a-a777-b30c9ce6a409€9.00€0.19matched
65capture01a19fb1-66df-7947-99a6-92fc3ed528ef€9.00€0.19matched
66refund01a19fb1-85dd-700f-97af-1ec1a5d4c512-€7.00€0.00matched
67capture01a19fb1-9af3-71c0-995a-92705e118e92€35.00€0.50matched
68capture01a19fb1-a9d4-788b-94ef-813127a65083€49.00€0.67matched
69capture01a19fb1-bdd1-7722-b0c9-1f56993a0a43€24.00€0.37matched
70capture01a19fb1-bdea-7e3d-a7a3-cac4ef56c0ae€15.00€0.26matched
71capture01a19fb2-09da-7335-8de1-658a749bc227€49.00€0.67matched
72refund01a19fb2-1ef5-7ba2-b683-7c1ec1a0dd5d-€5.00€0.00matched
73capture01a19fb2-2ab8-788e-9e13-69e858ab4ead€9.00€0.19matched
74capture01a19fb2-31ca-7895-a17e-6968688550ff€35.00€0.50matched
75capture01a19fb2-5a68-729e-a07f-b42dc1b660fc€15.00€0.26matched
76capture01a19fb2-5fc1-79ac-a0e8-8a018df081f1€35.00€0.50matched
77capture01a19fb2-70c6-7977-ae85-2949cfd05770€9.00€0.19matched
78capture01a19fb2-9616-7983-9af7-f20aae06c3ed€9.00€0.19matched
79capture01a19fb2-a432-75bc-8d9d-ac2106ac56c1€9.00€0.19matched
80capture01a19fb2-a6ea-747b-9ebb-bf0054ad2496€9.00€0.19matched
81capture01a19fb2-b9c2-71f7-8f9a-cc5bc1a7673b€24.00€0.37matched
82refund01a19fb2-c6e7-746c-95ff-141472a9e619-€6.00€0.00matched
83capture01a19fb2-e026-7270-a478-38384cc109d8€35.00€0.50matched
84capture01a19fb2-f800-7e01-9581-a40b45e47dd5€24.00€0.37matched
85capture01a19fb3-123e-7749-8b5b-10086b601855€9.00€0.19matched
86capture01a19fb3-3102-7127-8393-4346b2e90392€35.00€0.50matched
87capture01a19fb3-650e-7791-bbf5-82ff2d6648f7€49.00€0.67matched
88capture01a19fb3-8013-7bf9-8385-c6ec22462bbc€9.00€0.19matched
89capture01a19fb3-81e9-748b-9f6f-1ff6acf37364€35.00€0.50matched
91capture01a19fb3-8a5c-7289-8568-65fd75cfef18€35.00€0.50matched
92capture01a19fb3-d7dd-726e-98fc-41e0f12e3b44€24.00€0.37matched
93capture01a19fb3-deb9-755b-aa42-8e1524349aa6€24.00€0.37matched
94capture01a19fb3-e4b8-7e37-8d31-d0b5b9be451d€24.00€0.37matched
95refund01a19fb3-f57d-71e9-9965-ebb30c3876d1-€10.00€0.00matched
96capture01a19fb4-0cca-7439-9fdc-2918d0e6c559€24.00€0.37matched
97capture01a19fb4-3f0f-7e95-a850-e32c6aed98d9€49.00€0.67matched
98capture01a19fb4-6e08-7c06-bd69-48f71ed18b67€35.00€0.50matched
99capture01a19fb4-96b0-7577-8005-93a4ce37b28d€24.00€0.37matched
100capture01a19fb4-9d5f-7fea-bb42-baf19cfa2e3b€9.00€0.19matched
101refund01a19fb4-dfaa-7e89-9f83-dc41075881bd-€3.00€0.00matched
102capture01a19fb4-ed85-7bb5-bbde-bd240feb6d09€9.00€0.19matched