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, 23:30

Gross

€2,521.00

PSP fee

€39.99

Net to the bank

€2,481.01

Settlement journal

#351313

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19e9e-e1f6-7881-b8b7-b9055c16b336 is already settled by stl_EUR_2989437 line 57
  • duplicate linethe file lists it twicecapture:01a19ea1-f5ef-7963-b7db-dc0466ad7be5 is already settled by stl_EUR_2989437 line 102
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
LineKindReferenceGrossFeeStatus
40capture01a19e9d-d270-7798-bd0a-82f1cc01954d€35.00€0.52fee difference
46capture01a19e9e-594e-7b19-a163-b2795a389a98€15.00€0.31fee difference
58capture01a19e9e-e20f-757e-aa34-fc3c74aa1f74€24.00€0.37duplicate line
78capture01a19ea0-72f8-76f3-b45e-2c69803c01b2€49.00€0.72fee difference
103capture01a19ea2-11c4-72bd-aa22-3556235319f8€9.00€0.19duplicate line
108capture01a19ea2-3c4e-77f5-bc61-08f98c433fc5€49.00€0.70fee difference
1capture01a19e90-a079-7ed4-847b-5f30d6b75779€15.00€0.26matched
2capture01a19e94-920e-7fb6-85e1-6c326bcf82ae€24.00€0.37matched
3capture01a19e97-7590-7e1f-bdbc-ee7c7440073c€49.00€0.67matched
4capture01a19e99-44ae-73fd-af87-472566198601€15.00€0.26matched
5capture01a19e99-60b5-7d08-b400-30301bde9dab€49.00€0.67matched
6capture01a19e99-6206-7eec-b21e-dd179c0d03c0€24.00€0.37matched
7capture01a19e99-6696-7ee3-90fb-cfd5526c8b34€24.00€0.37matched
8capture01a19e99-6f81-7b4d-918f-304a51bcec92€15.00€0.26matched
9capture01a19e99-7f66-71ad-ab56-be64185c87b7€9.00€0.19matched
10capture01a19e99-cfd9-72e8-9dfd-858dedd94bfd€35.00€0.50matched
11capture01a19e99-d9dc-7c0e-bfe2-10aca2bc0470€15.00€0.26matched
12capture01a19e99-f0b3-7238-9e52-b604b35af42a€49.00€0.67matched
13capture01a19e99-fda0-7e58-96f8-b9457a7ea7ce€9.00€0.19matched
14capture01a19e9a-019c-7436-a2b3-831b46a92669€15.00€0.26matched
15capture01a19e9a-36cf-7cc9-be6a-29e181b8323d€15.00€0.26matched
16capture01a19e9a-3933-7c8a-b4d7-dd4286853cf1€24.00€0.37matched
17capture01a19e9a-5cf9-7885-a02b-05c4e7947ae3€24.00€0.37matched
18capture01a19e9a-93b6-71c9-8c45-80f895f0ffcb€49.00€0.67matched
19capture01a19e9a-f388-7f25-bcbc-6f20d58454fd€35.00€0.50matched
20capture01a19e9b-3235-7047-b77d-5a31a6a160de€35.00€0.50matched
21capture01a19e9b-8f3c-7ff3-b303-e80a898a3ea3€15.00€0.26matched
22capture01a19e9b-8ffe-7918-9d5e-3dbc7eca125e€49.00€0.67matched
23capture01a19e9b-9162-7418-ab2d-835ef9c06f59€24.00€0.37matched
24capture01a19e9b-9b8e-7f23-87c8-71e5975dae78€35.00€0.50matched
25capture01a19e9c-153c-7d9b-b9a7-d33360dcbd0b€49.00€0.67matched
26capture01a19e9c-2bdc-751c-ba60-053b64101e4c€15.00€0.26matched
27capture01a19e9c-515c-79e4-9634-816a77a4c6f9€15.00€0.26matched
28capture01a19e9c-54f6-7246-ad52-e65b3a3dd0a8€15.00€0.26matched
29capture01a19e9c-602b-736c-ba27-2ea2d8f6f29a€35.00€0.50matched
30capture01a19e9c-645a-7a68-b2d9-2f48696fd558€15.00€0.26matched
31capture01a19e9c-6af7-7513-830b-cc55bd950d4b€24.00€0.37matched
32capture01a19e9c-7177-7e13-81c5-c170c126f0e9€15.00€0.26matched
33capture01a19e9c-9085-728d-88ba-31579a36ce74€9.00€0.19matched
34capture01a19e9c-9e6a-76ff-bb5b-60647ccce3b4€49.00€0.67matched
35capture01a19e9c-be72-7ff5-a0aa-3f6963429409€35.00€0.50matched
36capture01a19e9c-e1ad-770b-9333-7894ab7780ae€9.00€0.19matched
37capture01a19e9d-1312-7ed5-a5a2-357d92c4cda1€35.00€0.50matched
38capture01a19e9d-201b-729a-9997-1107594ba39d€35.00€0.50matched
39capture01a19e9d-a902-797e-b490-c4ee1e92ab77€15.00€0.26matched
41capture01a19e9d-dc13-7fc6-8e7d-b4bb67501e2c€9.00€0.19matched
42capture01a19e9e-086e-7a6d-b45f-7aa27a4417a3€9.00€0.19matched
43capture01a19e9e-0993-72a7-bccb-781e29bf6648€15.00€0.26matched
44capture01a19e9e-16b7-7e44-8b05-557ef6a3379c€49.00€0.67matched
45capture01a19e9e-4025-7def-b085-727e6e45edcc€49.00€0.67matched
47capture01a19e9e-6116-7e0e-8daf-d51bcf479544€24.00€0.37matched
48capture01a19e9e-7065-7490-ad02-1cd7a40e373c€15.00€0.26matched
49refund01a19e9e-8b9d-737f-bf92-809a8dfb9bc3-€10.00€0.00matched
50capture01a19e9e-9d13-7b2c-8187-6e7529a336a2€15.00€0.26matched
51capture01a19e9e-a75e-7c53-9884-8865dacc6c59€49.00€0.67matched
52capture01a19e9e-a7fb-7116-8a89-f962bbae3010€24.00€0.37matched
53capture01a19e9e-b375-7594-89d6-c33d400f9dc1€9.00€0.19matched
54capture01a19e9e-b621-7510-8f48-5bc9a9a03915€49.00€0.67matched
55capture01a19e9e-b912-703e-b495-6c801e54806f€15.00€0.26matched
56capture01a19e9e-c1b0-7f24-973b-a9224da739ee€35.00€0.50matched
57capture01a19e9e-e20f-757e-aa34-fc3c74aa1f74€24.00€0.37matched
59capture01a19e9e-e5be-7628-a1df-c5d2ade75b39€49.00€0.67matched
60capture01a19e9e-ee8e-7d68-baa2-9d4a87794c1d€15.00€0.26matched
61capture01a19e9e-fde2-7fbd-93e3-4a1406e910e3€24.00€0.37matched
62capture01a19e9f-1a4a-7a86-900e-f0652943eca8€9.00€0.19matched
63refund01a19e9f-26c7-7d15-b13b-25e0bede27c0-€32.00€0.00matched
64capture01a19e9f-3f1f-72bf-ae33-656835ccdff9€35.00€0.50matched
65refund01a19e9f-5695-7ab0-bd3b-35c7087dd5e0-€8.00€0.00matched
66capture01a19e9f-7c59-7472-8854-a79b70d8dab6€24.00€0.37matched
67capture01a19e9f-7ffe-7cb8-976a-6d24cf76c6f1€9.00€0.19matched
68capture01a19e9f-8e91-7a32-969c-2429142c76f0€49.00€0.67matched
69capture01a19e9f-8f43-7284-a77b-186b767b361a€49.00€0.67matched
70capture01a19e9f-c7f0-75e7-9e74-8353eec3ad88€49.00€0.67matched
71capture01a19e9f-cf42-74c1-b98b-981eed7b66f6€35.00€0.50matched
72capture01a19e9f-d9f1-7792-81c8-f50e8b6e281a€35.00€0.50matched
73capture01a19e9f-da9f-7c9c-a340-294bffbfe5de€9.00€0.19matched
74capture01a19e9f-ee07-7bde-831a-8db0cd51af3a€15.00€0.26matched
75capture01a19ea0-322c-7007-a845-cf9cacc212a1€35.00€0.50matched
76capture01a19ea0-3f63-7f40-96c0-78a2a4a0e2c8€15.00€0.26matched
77capture01a19ea0-6531-77ce-b1cd-ab1c0f79349a€24.00€0.37matched
79capture01a19ea0-7a18-7946-969f-7ba02a3ac7b1€49.00€0.67matched
80capture01a19ea0-9469-7c55-a8de-4d4a9fc8d591€15.00€0.26matched
81capture01a19ea0-964d-7ea7-aa80-4bf7555e5100€9.00€0.19matched
82refund01a19ea0-a5de-743a-9251-9edc38ca7859-€33.00€0.00matched
83capture01a19ea0-a910-7f96-9a56-6604cc6a038d€9.00€0.19matched
84capture01a19ea0-aed9-7f56-a683-21f211e0f2b3€49.00€0.67matched
85capture01a19ea0-b69b-7142-946f-bc10ef3b5f72€35.00€0.50matched
86capture01a19ea0-be9c-7297-87b7-41d550c35404€9.00€0.19matched
87capture01a19ea0-c5dd-7e63-ae4e-ad283cd5cd17€49.00€0.67matched
88capture01a19ea0-c71d-7798-b8ef-7c15f35acc62€49.00€0.67matched
89capture01a19ea0-c7bd-7d99-bb4a-1d38f3fab86e€35.00€0.50matched
90capture01a19ea0-c855-7e49-8ab9-9e7b7832bb2d€9.00€0.19matched
91capture01a19ea0-d110-7f0f-b4da-31be99e2dcd2€15.00€0.26matched
92refund01a19ea0-d181-75cc-a8d9-5bf0e5f9fb80-€12.00€0.00matched
93capture01a19ea1-1db7-755b-84aa-b9945d51145d€49.00€0.67matched
94capture01a19ea1-2010-7357-9413-4c87c3913a3f€15.00€0.26matched
95capture01a19ea1-2756-7faa-ad58-c6c2b15366b5€49.00€0.67matched
96refund01a19ea1-2e33-7306-9653-cfecf8d33fa1-€8.00€0.00matched
97refund01a19ea1-644a-79c6-80c5-629311489865-€13.00€0.00matched
98capture01a19ea1-6d9c-70e7-bfe4-b72802536819€9.00€0.19matched
99capture01a19ea1-ac3f-7881-b751-6a92b2f17bb4€9.00€0.19matched
100capture01a19ea1-dfb3-7daf-a7e5-89e0605036f7€35.00€0.50matched
101capture01a19ea1-ebbc-7c17-ad9d-43994ccd1d90€15.00€0.26matched
102capture01a19ea2-11c4-72bd-aa22-3556235319f8€9.00€0.19matched
104capture01a19ea2-159e-7923-9475-b336d99c2c76€9.00€0.19matched
105capture01a19ea2-2c58-756f-aed5-c57d82573289€9.00€0.19matched
106capture01a19ea2-31b6-71ad-b316-0699fcadbdf4€9.00€0.19matched
107capture01a19ea2-38eb-7a2d-b51e-ccd4549a5f1b€15.00€0.26matched