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

Gross

€3,159.00

PSP fee

€50.12

Net to the bank

€3,108.88

Settlement journal

#357132

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a044-65f5-7786-9cf1-b42e207ac521 is already settled by stl_EUR_2989483 line 88
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
LineKindReferenceGrossFeeStatus
75capture01a1a043-b2a1-73ed-9f96-18d25561a533€49.00€0.71fee difference
89capture01a1a044-6647-724c-9dda-5e1ff8f3956e€35.00€0.50duplicate line
94capture01a1a044-9cb5-79e3-9b1d-c832a7e7f34d€35.00€0.54fee difference
1capture01a1a038-5832-7e33-8e32-7811384028df€49.00€0.67matched
2capture01a1a038-f762-7365-aa1a-2e2b17efe1cf€15.00€0.26matched
3capture01a1a039-cf89-74e1-925b-71fd541a8843€35.00€0.50matched
4capture01a1a03a-4a58-7812-a135-3f6b2e3c53df€24.00€0.37matched
5refund01a1a03e-62a8-7f55-9d4a-7ec9116ed8d1-€21.00€0.00matched
6capture01a1a03e-650d-7d4f-a854-65f7dc55a368€24.00€0.37matched
7refund01a1a03e-8651-716f-bb69-28e3adb731dc-€16.00€0.00matched
8capture01a1a03e-a1cf-7891-a22d-f11aa5bc877c€15.00€0.26matched
9refund01a1a03e-a775-7503-a77e-92c015fdffae-€12.00€0.00matched
10capture01a1a03e-bd09-75c4-82d4-076205026a30€35.00€0.50matched
11capture01a1a03e-f9c7-7739-9e64-0fd1049ff556€24.00€0.37matched
12capture01a1a03f-058d-75f1-8f09-9deaf7c8a89d€15.00€0.26matched
13capture01a1a03f-0662-7c3f-9e8c-d21ace05acbb€9.00€0.19matched
14capture01a1a03f-11fe-7cb8-9798-6c9a9ed21294€15.00€0.26matched
15capture01a1a03f-19f6-7423-affb-683489849fbd€49.00€0.67matched
16capture01a1a03f-3cbb-71e3-8c1b-f28287577e3c€49.00€0.67matched
17capture01a1a03f-3d8c-788b-a9bc-3ec6bfaeeb56€49.00€0.67matched
18capture01a1a03f-4c58-72a4-b84c-1703fa5d0fe6€15.00€0.26matched
19capture01a1a03f-4d87-70cf-ba39-65b7fc3a5cba€49.00€0.67matched
20capture01a1a03f-5a2b-70ca-8ce4-1cf8dfb9cc74€35.00€0.50matched
21capture01a1a03f-75a5-7334-b710-0862e61db816€24.00€0.37matched
22refund01a1a03f-7c78-70f9-9133-6a3e5930759a-€32.00€0.00matched
23capture01a1a03f-7d47-7b9e-908b-67b4283824a8€35.00€0.50matched
24capture01a1a03f-8fcb-7188-a40a-86db7e19541e€49.00€0.67matched
25capture01a1a03f-a3e8-7e71-b919-f6373999931d€15.00€0.26matched
26capture01a1a03f-8efe-72b4-a49e-8d6c11f14c6e€9.00€0.19matched
27capture01a1a03f-b7e5-7743-8a38-f33163fdb510€15.00€0.26matched
28capture01a1a03f-d377-7e01-99e2-3be89d26430b€24.00€0.37matched
29capture01a1a03f-e7f6-79eb-9f4c-e126d000f82d€9.00€0.19matched
30capture01a1a040-02b4-7d2a-9cbb-91ffffd4a4b2€24.00€0.37matched
31capture01a1a040-0a5f-78bf-a12b-cf04c4295e85€24.00€0.37matched
32capture01a1a040-1336-79e0-8846-a4d8fc60ae69€9.00€0.19matched
33capture01a1a040-2b15-7666-87c8-7091d9e9ad50€24.00€0.37matched
34capture01a1a040-3433-717d-b7f6-74405608634b€24.00€0.37matched
35capture01a1a040-39cb-7867-b132-3b7f40e70483€9.00€0.19matched
36capture01a1a040-55b4-7d90-829f-cd2458449deb€15.00€0.26matched
37capture01a1a040-57e3-7bf9-9200-b8103d64f0c5€49.00€0.67matched
38capture01a1a040-5a2e-705e-bdd4-3fe30495b913€15.00€0.26matched
39capture01a1a040-8774-71cb-a155-fc689744dcfe€24.00€0.37matched
40capture01a1a040-bc40-723b-8248-5eaa360f8235€49.00€0.67matched
41capture01a1a040-c6cf-7667-8978-7bca3bb035ab€35.00€0.50matched
42capture01a1a040-d0ad-7df7-8849-bc0ebc8609c0€9.00€0.19matched
43capture01a1a040-d7db-7f34-aefc-b32c2bf9da19€9.00€0.19matched
44capture01a1a040-edc7-7667-adc9-fb6b62963f6d€15.00€0.26matched
45capture01a1a041-09d7-7546-8729-c332a43e9694€15.00€0.26matched
46capture01a1a041-1ec1-705d-9b76-f24adc6edae2€24.00€0.37matched
47capture01a1a041-1fe4-779a-b9d3-eebe65be95be€24.00€0.37matched
48capture01a1a041-20e6-7bdc-a387-48a88f729a5c€49.00€0.67matched
49capture01a1a041-2f1a-7855-a9bd-cc9f404dff72€9.00€0.19matched
50capture01a1a041-3785-72db-a295-8a2f9f912e0c€35.00€0.50matched
51refund01a1a041-4ea7-7720-8517-0c45b7681565-€24.00€0.00matched
52refund01a1a041-51ec-7364-a5cc-4a4b2f7a17a3-€15.00€0.00matched
53capture01a1a041-51fa-729e-9dfc-0c473ea96c04€35.00€0.50matched
54capture01a1a041-5f0f-7cdb-bced-295b84627c77€49.00€0.67matched
55capture01a1a041-8fb8-790c-8f5b-03a1fb6e16a2€15.00€0.26matched
56capture01a1a041-9b7d-7654-b31c-51c9b8e4595d€49.00€0.67matched
57capture01a1a041-bc77-7be1-a1ee-2573fb0f5886€35.00€0.50matched
58capture01a1a041-c244-7933-8f15-c0d75077f5d1€15.00€0.26matched
59capture01a1a041-cbe0-72d5-9e53-cfb1f7ee7406€49.00€0.67matched
60capture01a1a041-da2a-7f94-9b03-8450754bbece€35.00€0.50matched
61capture01a1a041-ec50-747e-b78e-eb823df0f476€35.00€0.50matched
62capture01a1a042-077c-7ba8-825e-ac0c8a2ae33c€9.00€0.19matched
63capture01a1a042-0e8f-720e-9be3-c5157f681e30€35.00€0.50matched
64capture01a1a042-2795-7579-9918-0b65e37c8509€24.00€0.37matched
65capture01a1a042-9c02-7c2a-93db-f17d8b7bcc31€24.00€0.37matched
66capture01a1a042-aef7-7988-b71e-c9ab3842d538€24.00€0.37matched
67capture01a1a042-b183-7c88-af04-a051e67bd546€49.00€0.67matched
68capture01a1a042-cc54-7225-ab2d-6f59df1a93c2€24.00€0.37matched
69capture01a1a042-e5b1-7417-ae14-f0d3e6bc7308€49.00€0.67matched
70capture01a1a043-02e6-7f2a-9e71-839a16a57b10€9.00€0.19matched
71capture01a1a043-1258-75be-aa24-41b2ba84c1a4€15.00€0.26matched
72refund01a1a043-6e94-7804-9002-889b9a73c932-€8.00€0.00matched
73capture01a1a043-8274-7a57-87c3-d6b7790866e6€24.00€0.37matched
74capture01a1a043-a0c4-7be6-858b-2e2148348132€49.00€0.67matched
76capture01a1a043-be03-7158-9a39-271ab155c5da€9.00€0.19matched
77capture01a1a043-c558-7927-a1ae-35b7b6cba6f1€24.00€0.37matched
78capture01a1a043-ceb6-7f83-89f4-38fc662454a7€15.00€0.26matched
79capture01a1a043-cf56-7695-9ad1-b1ad5e16c5dc€24.00€0.37matched
80capture01a1a043-ec2f-7f8a-b72e-fc30d97c3584€49.00€0.67matched
81capture01a1a043-f68b-7f6d-a7ab-8bc222fd5580€35.00€0.50matched
82capture01a1a043-fbf1-7771-a9c3-035ca11f39da€35.00€0.50matched
83capture01a1a044-0b1c-7519-9997-ff751ea7dc12€24.00€0.37matched
84capture01a1a044-0ec7-71d0-b3af-a7a4dad10785€49.00€0.67matched
85capture01a1a044-0ed3-7b56-856a-1c87320d2895€49.00€0.67matched
86capture01a1a044-448f-79cd-ac7b-f6351670f5d9€49.00€0.67matched
87capture01a1a044-47d0-75b0-acde-7690cf457fa7€24.00€0.37matched
88capture01a1a044-6647-724c-9dda-5e1ff8f3956e€35.00€0.50matched
90capture01a1a044-741a-73b2-82eb-fc9eb12ca84a€49.00€0.67matched
91capture01a1a044-8042-75f9-804c-2c9392a99f20€9.00€0.19matched
92capture01a1a044-848b-734c-a99c-30928d0410f4€49.00€0.67matched
93capture01a1a044-9c13-721b-b47b-09003f38c722€24.00€0.37matched
95capture01a1a044-9ffa-711e-a489-c5377860a031€24.00€0.37matched
96refund01a1a044-a975-7536-b7a5-2bedd3f7d7ed-€8.00€0.00matched
97capture01a1a044-aa45-7a9b-a763-c3a776ec7154€35.00€0.50matched
98capture01a1a044-ca23-7280-969d-8b18f1e021d8€35.00€0.50matched
99capture01a1a044-ccce-7814-b323-10ef6c071a23€49.00€0.67matched
100capture01a1a044-eee8-7d27-827e-aaf1a50e672e€9.00€0.19matched
101capture01a1a044-f443-79b7-a6ab-5b8ed313177e€35.00€0.50matched
102capture01a1a044-fddc-77e4-97f9-0b82e6bd961a€49.00€0.67matched
103capture01a1a045-0471-76ed-a883-4ac75eb7b3d6€15.00€0.26matched
104capture01a1a045-27f2-7677-9f42-45c86186ced6€9.00€0.19matched
105capture01a1a045-40a3-7754-bb54-704075acc3e1€49.00€0.67matched
106capture01a1a045-487f-7d8f-8def-9ee4f673fb0e€35.00€0.50matched
107capture01a1a045-5f79-795d-927a-47b4d19546db€9.00€0.19matched
108capture01a1a045-7883-7352-89d5-1d90e4b100d7€35.00€0.50matched
109capture01a1a045-81d2-73f4-a941-91bf3a591291€35.00€0.50matched
110capture01a1a045-8d37-79de-87cc-77fe629ef2a7€49.00€0.67matched
111refund01a1a045-b9e4-7f00-8f4b-cf44aed075e4-€31.00€0.00matched
112capture01a1a046-0022-705b-aa63-23f0d080e3f1€15.00€0.26matched
113capture01a1a046-10e5-7063-a4e1-87871b12a0e5€35.00€0.50matched
114capture01a1a046-1331-7ed9-8318-1f949101fe8e€35.00€0.50matched
115capture01a1a046-286c-70c7-bc4e-242503df34a2€24.00€0.37matched
116capture01a1a046-3918-74d3-a0a6-088b77e4f827€9.00€0.19matched
117capture01a1a046-4ef8-7b36-9e64-00b217efb001€9.00€0.19matched
118capture01a1a046-746f-7cc2-82ee-5804440c496b€9.00€0.19matched
119capture01a1a046-cf47-7ece-8647-a30f9ad236de€24.00€0.37matched
120capture01a1a046-f0b7-7526-b7ee-632fa15df476€24.00€0.37matched
121capture01a1a046-f7fa-7ddd-826a-850d525b7a63€49.00€0.67matched
122capture01a1a047-1cd0-74f7-9a10-da8ca34a9907€35.00€0.50matched
123refund01a1a047-2b46-7e63-b868-83ef5d7a9672-€45.00€0.00matched
124capture01a1a047-3356-7525-96ec-b02dd4bf2a2a€49.00€0.67matched
125capture01a1a047-3c2b-7456-895a-1064f4123757€24.00€0.37matched
126capture01a1a047-55f0-7a57-83c4-7143576f301e€9.00€0.19matched
127capture01a1a047-5863-70d5-921f-d17a2cd4b48e€15.00€0.26matched
128capture01a1a047-5bc7-74c7-838e-9733b72dbdef€35.00€0.50matched