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

Gross

€3,026.00

PSP fee

€47.12

Net to the bank

€2,978.88

Settlement journal

#394053

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aab2-6007-7a27-bbfe-004d3e425b3e is already settled by stl_EUR_2989775 line 38
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
LineKindReferenceGrossFeeStatus
5capture01a1aaaf-ced7-72db-b5d2-39326956f548€35.00€0.54fee difference
39capture01a1aab2-602f-7bbe-8453-b5017f1c5fbe€49.00€0.67duplicate line
44capture01a1aab2-b391-7649-be7c-e822eb3ec2a0€35.00€0.53fee difference
1capture01a1aaa6-c39c-79d3-b7fa-d145fe2e06a9€49.00€0.67matched
2capture01a1aaa8-c8cc-7434-8a87-6b787b4387d9€9.00€0.19matched
3capture01a1aaab-6a3e-77d5-908e-9cb988cf6693€15.00€0.26matched
4capture01a1aaaf-c16e-77d3-b542-a1e037c20066€9.00€0.19matched
6capture01a1aaaf-e527-7ced-98d5-ad47ad7973dd€15.00€0.26matched
7capture01a1aaaf-f958-7d49-8fe1-71832a64ba25€15.00€0.26matched
8capture01a1aaaf-fdf5-73e1-8a19-54758f035a8c€49.00€0.67matched
9capture01a1aab0-2162-7bb4-a6d8-9997c030354d€49.00€0.67matched
10capture01a1aab0-3502-79d1-a6a6-a7f3eecf077f€24.00€0.37matched
11capture01a1aab0-3a5b-7107-bf80-ef4f2567857d€9.00€0.19matched
12refund01a1aab0-526d-769d-8b43-2018585d2cf5-€6.00€0.00matched
13capture01a1aab0-7f76-7506-a5c4-54457e4b673e€15.00€0.26matched
14capture01a1aab0-8621-73d0-a75f-9b4bb44fc320€24.00€0.37matched
15capture01a1aab0-9690-7b4c-8851-5b5196ad8f91€9.00€0.19matched
16capture01a1aab0-ca82-7072-803b-40d158e8b6ac€24.00€0.37matched
17capture01a1aab0-e38a-7839-92dd-2f74a003cec4€9.00€0.19matched
18capture01a1aab1-2161-78f3-bdf1-fed09f80a0fe€15.00€0.26matched
19capture01a1aab1-262e-7262-ab2e-1710925f4c02€9.00€0.19matched
20capture01a1aab1-4623-78ab-905c-3a6fbd92936f€24.00€0.37matched
21capture01a1aab1-79a8-7e06-92be-c7d0f07f01c7€49.00€0.67matched
22capture01a1aab1-7e38-7dd8-8c2e-f2b84207de45€35.00€0.50matched
23capture01a1aab1-904d-76e2-a900-9c98837af6e6€35.00€0.50matched
24capture01a1aab1-9b1b-72d7-8533-d28220740bcf€24.00€0.37matched
25capture01a1aab1-aea7-738e-90ec-25df340be387€24.00€0.37matched
26capture01a1aab1-bca9-79e2-8cd9-8706ccdcb128€15.00€0.26matched
27refund01a1aab1-dd9c-7069-aa78-73a11657d782-€20.00€0.00matched
28capture01a1aab2-04f4-7ff4-9828-9b169d1f4413€24.00€0.37matched
29capture01a1aab2-1427-7602-9c76-d751d390bbb4€35.00€0.50matched
30capture01a1aab2-1619-734d-ae01-56d7a9c16577€24.00€0.37matched
31capture01a1aab2-1d38-738f-af09-e373a9c0ae9e€49.00€0.67matched
32capture01a1aab2-1f3e-7b9d-8f99-508a58d61bb3€49.00€0.67matched
33capture01a1aab2-384f-761d-8cad-3e6ce6695764€24.00€0.37matched
34capture01a1aab2-38e9-76f6-830d-d6cb77d529e5€9.00€0.19matched
35capture01a1aab2-520a-77ba-8d4f-06df0942e852€35.00€0.50matched
36refund01a1aab2-5493-7532-abc3-8ee5fa590463-€31.00€0.00matched
37capture01a1aab2-5d36-75eb-b55a-5b4c42278ff2€35.00€0.50matched
38capture01a1aab2-602f-7bbe-8453-b5017f1c5fbe€49.00€0.67matched
40capture01a1aab2-7753-733a-bc96-120297d13f5a€15.00€0.26matched
41capture01a1aab2-789b-7f4d-8b2d-b6c8b364adcd€9.00€0.19matched
42capture01a1aab2-793c-7200-a8c6-c875323b8931€15.00€0.26matched
43capture01a1aab2-b26f-762e-8448-5146896823eb€9.00€0.19matched
45capture01a1aab2-bc5b-723d-ba8d-307f5decf71f€15.00€0.26matched
46capture01a1aab2-eddd-74df-9bb8-92d025cc6e83€9.00€0.19matched
47capture01a1aab2-f842-772c-9384-8521362ce26f€24.00€0.37matched
48capture01a1aab3-42e9-72fa-aa3e-fe14eae66569€9.00€0.19matched
49capture01a1aab3-59b5-76f0-a439-6baa5febcd36€49.00€0.67matched
50refund01a1aab3-68a6-795c-a35e-8f6da1c4b2c9-€19.00€0.00matched
51capture01a1aab3-841f-73c7-a52e-94430f107954€49.00€0.67matched
52capture01a1aab3-9551-7c23-830c-0a9a2b11d662€49.00€0.67matched
53capture01a1aab3-ae41-7f05-8b50-946cfac0e4ff€9.00€0.19matched
54capture01a1aab3-be13-7fab-a555-765db243426e€15.00€0.26matched
55capture01a1aab3-d80c-7a74-a36b-6d10f756289b€35.00€0.50matched
56capture01a1aab3-fe6c-70da-a2fc-abcb40e4b290€15.00€0.26matched
57capture01a1aab3-fb17-7de4-9735-c450b92887a5€24.00€0.37matched
58capture01a1aab4-0264-7bb4-946e-c810e7656d0d€24.00€0.37matched
59refund01a1aab4-0d51-7629-9f1b-f48d33dd36a9-€14.00€0.00matched
60capture01a1aab4-2582-7f95-abcf-4fa09e56639e€24.00€0.37matched
61capture01a1aab4-2bf2-7857-a874-6a04c1e1f350€9.00€0.19matched
62capture01a1aab4-49a7-7517-a510-69d48b10c31e€35.00€0.50matched
63capture01a1aab4-770c-7878-8f67-91f3810d9f48€24.00€0.37matched
64capture01a1aab4-8e07-79c3-bcc2-6556bd3994c8€49.00€0.67matched
65capture01a1aab4-969c-75c8-a8eb-fd27e8c1453a€24.00€0.37matched
66capture01a1aab4-a6bc-7878-beb0-c20b7d1e3781€49.00€0.67matched
67capture01a1aab4-bbc1-7a7d-bda2-8e1e3b728d91€24.00€0.37matched
68capture01a1aab4-be8b-7cde-b195-f83d2e6e4b41€49.00€0.67matched
69capture01a1aab4-ea21-7fa6-9485-b9d199eb433f€49.00€0.67matched
70capture01a1aab4-eb25-73d3-8ee4-3d305e2a6f5d€9.00€0.19matched
71capture01a1aab5-1035-74ce-821a-391147f2955d€49.00€0.67matched
72capture01a1aab5-1d66-72b4-8376-b3854ab1fdf3€35.00€0.50matched
73capture01a1aab5-3514-7075-bdb1-8f6854aca28b€24.00€0.37matched
74capture01a1aab5-4c2f-7069-8cb2-03e0bf0e7fdc€35.00€0.50matched
75refund01a1aab5-5f90-760b-8fd4-99e6d818e355-€8.00€0.00matched
76capture01a1aab5-967a-7169-b630-3ff416db0191€35.00€0.50matched
77capture01a1aab5-99db-7e81-a63a-417a0e62df0c€49.00€0.67matched
78capture01a1aab5-accb-738f-a6a1-e8b74b89e83e€15.00€0.26matched
79capture01a1aab5-ab5e-76fd-91e9-f21f10e004bd€15.00€0.26matched
80capture01a1aab5-b114-7e90-9b34-e54374be1600€35.00€0.50matched
81capture01a1aab5-c440-7c37-afed-8567968de4bc€9.00€0.19matched
82capture01a1aab5-c493-7c63-a1bd-5dfaf5f51bcf€35.00€0.50matched
83capture01a1aab5-c58d-70ea-9553-89ccd3a8b2c7€49.00€0.67matched
84capture01a1aab5-c9cb-7ab2-98db-594fe57d6ed7€9.00€0.19matched
85capture01a1aab5-caa5-7019-8125-c9a4eaaf1ccf€49.00€0.67matched
86refund01a1aab5-fad6-7046-b706-75bc0ffbef1d-€31.00€0.00matched
87capture01a1aab5-fcad-7f71-b90d-1ac5690b3b83€15.00€0.26matched
88capture01a1aab5-fe35-752d-86b6-95496246b3a4€49.00€0.67matched
89capture01a1aab6-1fce-71dd-8c0b-bd84b3cc54f4€15.00€0.26matched
90capture01a1aab6-3848-718f-a0d0-6ce58aff9f31€15.00€0.26matched
91capture01a1aab6-400f-7614-b601-d97892c376b6€35.00€0.50matched
92capture01a1aab6-8e3d-7dad-bd63-f1644f078d9f€49.00€0.67matched
93capture01a1aab6-97f5-7561-86cf-b744fc2b9506€49.00€0.67matched
94capture01a1aab6-bde4-78a6-8cb4-2b7b5a08f718€24.00€0.37matched
95capture01a1aab6-d42c-7669-ba95-294d38c062b8€24.00€0.37matched
96capture01a1aab6-d555-7ead-bb30-983710636a77€15.00€0.26matched
97capture01a1aab6-e0b4-72f2-857e-b9a617c5619f€35.00€0.50matched
98capture01a1aab7-1e79-70bb-a944-eccadfef2b73€24.00€0.37matched
99capture01a1aab7-1f5a-7975-a2d9-51206503a005€35.00€0.50matched
100capture01a1aab7-20cd-7f7c-bbd3-085433b495a0€49.00€0.67matched
101refund01a1aab7-26ce-790d-8d5e-06b99fc2d5fd-€7.00€0.00matched
102capture01a1aab7-2bfe-7a95-a434-a3d707c43a37€24.00€0.37matched
103capture01a1aab7-4418-7daa-8fef-4f85b05ae5ac€24.00€0.37matched
104capture01a1aab7-555a-7c32-bb18-a687471ffd84€9.00€0.19matched
105capture01a1aab7-55ef-708d-b06c-fd0dc51cb311€49.00€0.67matched
106capture01a1aab7-57da-7cd5-8f24-1aa601ed9c32€9.00€0.19matched
107capture01a1aab7-61b4-79bc-8109-bcaa8579fb36€15.00€0.26matched
108capture01a1aab7-7525-7575-bab4-a64e29f43f7b€15.00€0.26matched
109capture01a1aab7-8a75-72f0-b722-cf92f5398800€24.00€0.37matched
110capture01a1aab7-95e1-7157-9b64-8bdac7253c2e€9.00€0.19matched
111capture01a1aab7-bd80-785e-ba64-585f7bdff172€49.00€0.67matched
112capture01a1aab7-ef3d-76f2-bd92-e3b059b987cb€24.00€0.37matched
113capture01a1aab8-0cf5-7e2e-bf27-d9d47bc302bb€49.00€0.67matched
114capture01a1aab8-1030-7049-91d7-1a19bf2f75cc€49.00€0.67matched
115capture01a1aab8-12e0-708b-a9b8-996734fa2114€35.00€0.50matched
116capture01a1aab8-63a0-7a7b-b8dd-2d78e99ba3dc€49.00€0.67matched
117capture01a1aab8-7312-7f5f-8da8-1ef1467c1a38€9.00€0.19matched
118capture01a1aab8-9b33-7ed0-ace0-34264f92b78a€35.00€0.50matched
119capture01a1aab8-a0d2-7d44-87cf-1c26264fc0b4€49.00€0.67matched
120capture01a1aab8-aa15-7caf-840a-74e53d797e38€35.00€0.50matched