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

5 Nov, 12:50

Gross

€3,118.00

PSP fee

€47.12

Net to the bank

€3,070.88

Settlement journal

#397863

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1abc6-c2c5-7de3-a0e8-8f618351b817 is already settled by stl_EUR_2989805 line 59
  • duplicate linethe file lists it twicerefund:01a1abc7-b69f-745a-9a00-090a0ee2b1b5 is already settled by stl_EUR_2989805 line 75
  • duplicate linethe file lists it twicecapture:01a1abc7-b810-773e-8241-28379c305dfd is already settled by stl_EUR_2989805 line 77
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
LineKindReferenceGrossFeeStatus
14capture01a1abc3-bb5c-746e-98ae-46f768d7a6b1€35.00€0.55fee difference
60capture01a1abc6-d680-760d-9db6-edd851445fce€49.00€0.67duplicate line
76refund01a1abc7-b6a0-7734-8c7e-c4dfa8897f43-€11.00€0.00duplicate line
78capture01a1abc7-b858-7ff3-b1a7-4bc6712c3574€49.00€0.67duplicate line
1capture01a1abb9-dbae-74d1-97ba-6720bceb71b5€49.00€0.67matched
2capture01a1abbf-343d-7847-808e-4c3db501b371€35.00€0.50matched
3capture01a1abbf-60d5-7fec-a6f8-6667651e5363€35.00€0.50matched
4capture01a1abc2-8551-75d3-ac04-721397c6c8fb€49.00€0.67matched
5capture01a1abc2-aa91-7ec3-9a1c-4749c26b90c2€49.00€0.67matched
6capture01a1abc3-0e3f-7656-b214-263680113597€9.00€0.19matched
7capture01a1abc3-0e9c-7589-8bd5-31b3600f9d4e€24.00€0.37matched
8capture01a1abc3-1067-7723-ad9b-366035665f00€15.00€0.26matched
9capture01a1abc3-16b6-7a8f-b552-7b483f601584€15.00€0.26matched
10capture01a1abc3-1c63-7760-960e-00a94affae92€9.00€0.19matched
11capture01a1abc3-39f6-7893-911b-2dba1bea6de1€24.00€0.37matched
12capture01a1abc3-55ca-7514-8c5d-cfce8a97a413€15.00€0.26matched
13capture01a1abc3-865a-7956-bfd1-a07f8a6cb143€49.00€0.67matched
15capture01a1abc3-b9d8-78bf-b7ad-8a4796d710b1€9.00€0.19matched
16capture01a1abc3-d246-7593-a44d-d03a2502a194€49.00€0.67matched
17capture01a1abc3-dbf3-730f-aa53-455508ac27de€49.00€0.67matched
18capture01a1abc3-e1e2-7088-892d-9e1e441137fe€9.00€0.19matched
19capture01a1abc3-ed6c-76ca-9873-b8aa86a9c547€24.00€0.37matched
20capture01a1abc3-fc4f-7a91-83e4-d773d48dfbfd€35.00€0.50matched
21capture01a1abc4-0199-773c-a31c-629c01ba8119€15.00€0.26matched
22capture01a1abc4-088f-7f5b-89dd-8445025ced69€24.00€0.37matched
23capture01a1abc4-17b0-782a-91c4-ecea2c924e94€15.00€0.26matched
24capture01a1abc4-2fb2-7421-8033-e31b465b0373€49.00€0.67matched
25capture01a1abc4-5400-7ab0-b620-4899d9600283€49.00€0.67matched
26capture01a1abc4-5f13-7e97-ad3e-f869b42b2ae1€9.00€0.19matched
27capture01a1abc4-7fa6-7ab0-b112-746f47771111€49.00€0.67matched
28capture01a1abc4-7fe4-7a06-b35c-767d2d46759b€35.00€0.50matched
29capture01a1abc4-aab7-729f-8fc6-73ae18418cc6€35.00€0.50matched
30capture01a1abc4-aee3-7032-89f0-cf80fbc12163€24.00€0.37matched
31capture01a1abc4-cf26-7823-a479-cb173dd36c06€15.00€0.26matched
32capture01a1abc5-09a9-7ed3-8021-2ba410c89d4f€35.00€0.50matched
33refund01a1abc5-1004-78dc-a06c-835fc0437518-€8.00€0.00matched
34capture01a1abc5-2529-7a01-8c6c-1b61a10d9523€24.00€0.37matched
35capture01a1abc5-4b9d-79b4-80fd-15571578dd0c€49.00€0.67matched
36capture01a1abc5-547b-7c89-9f94-49179cba4099€9.00€0.19matched
37capture01a1abc5-5821-7120-ae3b-396e916ce495€35.00€0.50matched
38capture01a1abc5-6187-79b6-b27a-9a9daf880dc7€35.00€0.50matched
39capture01a1abc5-7887-7dbf-a944-fa7829014883€24.00€0.37matched
40capture01a1abc5-910d-7f7a-b0be-68f7f287f31f€49.00€0.67matched
41capture01a1abc5-9731-7ed2-8f8d-66c5201d543b€9.00€0.19matched
42capture01a1abc5-9de2-7dce-a65e-f48dbc1834ab€49.00€0.67matched
43capture01a1abc5-b2a0-72a9-aa79-303818a1209d€24.00€0.37matched
44capture01a1abc5-bf01-7002-bd24-697dfd9b27e6€49.00€0.67matched
45capture01a1abc5-dc32-720d-89b4-ecb64fafe9de€49.00€0.67matched
46capture01a1abc5-dd67-73c8-869e-9695f0761f16€24.00€0.37matched
47capture01a1abc5-ec8e-7601-990b-9e810f58255f€9.00€0.19matched
48capture01a1abc6-06cf-7b42-a71d-784d7fbceb09€35.00€0.50matched
49capture01a1abc6-0a66-7a33-a9fc-edcb750fc993€49.00€0.67matched
50capture01a1abc6-0dc8-7cae-b66b-f5a4647b2cf7€24.00€0.37matched
51capture01a1abc6-184e-7b80-8a30-b9d864ffcd6d€35.00€0.50matched
52refund01a1abc6-1d04-752a-b6b8-95c093e936c0-€12.00€0.00matched
53capture01a1abc6-2285-7ab1-b2b2-7d8e76942ec8€35.00€0.50matched
54capture01a1abc6-72e2-783c-b510-6c3e60dd4ee0€24.00€0.37matched
55capture01a1abc6-98a3-72d9-89f9-dfadece374e0€49.00€0.67matched
56capture01a1abc6-a604-76e6-8486-9a3d7d5123ee€15.00€0.26matched
57capture01a1abc6-a7e1-78ee-86d4-85c52bcb9f1e€24.00€0.37matched
58capture01a1abc6-a9a8-76da-a98b-eebcf0ff1c2f€15.00€0.26matched
59capture01a1abc6-d680-760d-9db6-edd851445fce€49.00€0.67matched
61capture01a1abc6-def2-756f-aa57-fd9ce810eb19€49.00€0.67matched
62capture01a1abc6-ea4c-7144-944a-8e5717db18e6€9.00€0.19matched
63capture01a1abc6-f984-783b-b819-7dbf41949627€49.00€0.67matched
64capture01a1abc6-ffd0-781c-97ed-7a4dbb218c76€35.00€0.50matched
65capture01a1abc7-06bb-7105-b87b-4bfd8e755834€35.00€0.50matched
66capture01a1abc7-12aa-7822-9737-90f55965057c€49.00€0.67matched
67capture01a1abc7-1b90-7c0a-b00f-738316c8dced€24.00€0.37matched
68capture01a1abc7-75fc-7bdb-8376-1992e4c3d8c8€15.00€0.26matched
69capture01a1abc7-84ea-71f7-900b-cdae84b96ca3€15.00€0.26matched
70capture01a1abc7-8881-7903-8145-894d9813e1a9€24.00€0.37matched
71capture01a1abc7-8c63-777f-b442-7828be4df049€24.00€0.37matched
72capture01a1abc7-951e-779a-87b3-c85935d8a489€15.00€0.26matched
73refund01a1abc7-aafd-7397-b89b-91911a489a48-€5.00€0.00matched
74capture01a1abc7-ac3e-7c93-9f25-f040e02133c3€24.00€0.37matched
75refund01a1abc7-b6a0-7734-8c7e-c4dfa8897f43-€11.00€0.00matched
77capture01a1abc7-b858-7ff3-b1a7-4bc6712c3574€49.00€0.67matched
79capture01a1abc7-f34b-73d3-8115-e4821b7e24f9€9.00€0.19matched
80capture01a1abc7-feba-7614-b7fd-924a724d3c59€35.00€0.50matched
81capture01a1abc8-13be-79f7-b8c1-9b1f8e76284f€15.00€0.26matched
82capture01a1abc8-2768-78f9-8889-1a7b010e32ba€35.00€0.50matched
83capture01a1abc8-291a-7f33-acfb-0eb69e510522€35.00€0.50matched
84capture01a1abc8-2c69-7f04-ac1a-f91395d9236f€35.00€0.50matched
85capture01a1abc8-4197-7056-9030-4052de01c4e6€35.00€0.50matched
86capture01a1abc8-64bc-7a74-a264-5c460a4d63c4€49.00€0.67matched
87capture01a1abc8-7acf-7c67-8c60-219bd99b686e€24.00€0.37matched
88capture01a1abc8-ab2b-7c54-bbaf-23e751f264e1€49.00€0.67matched
89capture01a1abc8-b080-7914-b64b-9efd3e7da806€9.00€0.19matched
90capture01a1abc8-e016-7dde-8604-7ead1cb97600€15.00€0.26matched
91capture01a1abc8-ef49-75dd-b28d-c6429f1487c2€49.00€0.67matched
92capture01a1abc9-23aa-7a2a-a556-d6eccd318f8c€24.00€0.37matched
93capture01a1abc9-3cb8-7474-8d3e-16d8639b897e€49.00€0.67matched
94capture01a1abc9-3e86-7525-9ffa-213ae49483ed€24.00€0.37matched
95refund01a1abc9-5c7b-7876-9ad4-4c8532c7ce6f-€32.00€0.00matched
96capture01a1abc9-b914-70f3-966d-c2f8b11b94b4€24.00€0.37matched
97capture01a1abc9-b9d0-76f1-ac5d-bc9a451e5f3d€49.00€0.67matched
98capture01a1abc9-bb2c-787b-9eb3-b68e798ed9c7€24.00€0.37matched
99capture01a1abc9-ca11-7dc7-88d8-240158a5b4ac€24.00€0.37matched
100capture01a1abc9-dd30-7ec7-bcaa-57edbe6a3c24€35.00€0.50matched
101capture01a1abc9-ee56-7711-9fa2-7f68d78285ae€15.00€0.26matched
102capture01a1abc9-f63c-75ca-a3a5-c4406c20619b€49.00€0.67matched
103capture01a1abca-22d9-7576-9505-6c4b1a0f2740€15.00€0.26matched
104capture01a1abca-4cf2-7e5a-97fe-b3cacc7fcb3b€15.00€0.26matched
105capture01a1abca-b87c-7aa9-ace1-9dfbb14a1894€35.00€0.50matched
106capture01a1abca-d058-71ea-9595-7c928cd44077€24.00€0.37matched
107capture01a1abca-ffab-701a-9595-dcf808c1f543€24.00€0.37matched
108capture01a1abcb-0447-7dad-8fd2-5d2b178c2668€49.00€0.67matched
109capture01a1abcb-10a4-7e94-817d-ebf2374ea4d3€49.00€0.67matched
110capture01a1abcb-4a3a-7c20-984d-23cdb4fbb66c€49.00€0.67matched
111refund01a1abcb-6c12-7f57-8e64-d5b13a7ba8cc-€21.00€0.00matched