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, 06:40

Gross

€3,114.00

PSP fee

€48.34

Net to the bank

€3,065.66

Settlement journal

#356748

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a029-c4ef-7eda-bf62-796035f4eff2 is already settled by stl_EUR_2989480 line 98
  • duplicate linethe file lists it twicecapture:01a1a02b-2205-7dec-a48e-4d3eb3e7cf36 is already settled by stl_EUR_2989480 line 115
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
LineKindReferenceGrossFeeStatus
62capture01a1a027-1abe-7a3d-8f35-664fd411117f€35.00€0.51fee difference
99capture01a1a029-c50e-7e24-b5d6-a9f723e970e8€24.00€0.37duplicate line
116capture01a1a02b-3c0d-7e28-8f4d-a7a18ed7da80€24.00€0.37duplicate line
1capture01a1a022-da52-73d8-bdd1-d71b6c8c4b0a€15.00€0.26matched
2capture01a1a023-108c-7059-899c-07fc9a71ca96€49.00€0.67matched
3capture01a1a023-26d5-71c0-abc1-5268b3084efc€24.00€0.37matched
4capture01a1a023-32f9-7326-9583-0e5d13fe6481€24.00€0.37matched
5capture01a1a023-3d24-700e-bd76-50b0f789cc08€35.00€0.50matched
6capture01a1a023-50cb-7366-85b5-b32768699f42€15.00€0.26matched
7capture01a1a023-58aa-7189-bb39-be9e35e24453€35.00€0.50matched
8capture01a1a023-6d27-7343-83f4-c6b7f239501f€35.00€0.50matched
9capture01a1a023-86cf-73b0-a28d-7e9aeb60069b€49.00€0.67matched
10capture01a1a023-9b53-7067-8b7e-aa15241d8f46€15.00€0.26matched
11capture01a1a023-aca3-7a97-be15-d225db96e00d€15.00€0.26matched
12capture01a1a023-bf63-7a75-b545-11141d809c44€9.00€0.19matched
13capture01a1a023-c73c-7483-bf6a-4ba926bfa518€15.00€0.26matched
14capture01a1a023-d64a-737b-b730-33e17d197081€35.00€0.50matched
15capture01a1a023-e2c4-7b45-a4c9-14965490ea2d€9.00€0.19matched
16capture01a1a023-ec5b-772a-ae8b-6adad08e7b29€15.00€0.26matched
17capture01a1a024-136f-7e10-84d2-c38bb6d53ee2€49.00€0.67matched
18capture01a1a024-3113-7c08-b432-a653d2fc4b39€15.00€0.26matched
19capture01a1a024-31bc-73e6-935a-cda48e003b88€49.00€0.67matched
20refund01a1a024-3f08-761f-8790-4e7af654fefb-€17.00€0.00matched
21capture01a1a024-4251-7f1e-b6af-1fa5b0fb5d40€15.00€0.26matched
22capture01a1a024-8163-7c8b-86c2-0137903d0d91€24.00€0.37matched
23capture01a1a024-96cc-713e-88a8-469080cd8e97€15.00€0.26matched
24capture01a1a024-978e-7e3f-bc32-6c12c72d7b89€35.00€0.50matched
25capture01a1a024-ae64-765a-b951-43c5de02ddc1€9.00€0.19matched
26capture01a1a024-c62b-77a1-9c2d-50facfc4e00d€24.00€0.37matched
27capture01a1a024-d895-7b86-8f4b-c72768b9f226€35.00€0.50matched
28capture01a1a024-f15a-7dd4-ae9a-57caff5782cc€9.00€0.19matched
29refund01a1a024-f398-73ee-9476-cc242f4a2bdd-€28.00€0.00matched
30refund01a1a025-0f6a-7a49-a222-cf9fa0b69ed9-€6.00€0.00matched
31refund01a1a025-2051-7321-bd95-4431b2a64cb3-€8.00€0.00matched
32capture01a1a025-2231-7875-bc0b-f333e30d568d€35.00€0.50matched
33capture01a1a025-3f71-7790-a116-1ab07f414d48€24.00€0.37matched
34capture01a1a025-40e3-7c48-8334-4369f30be918€24.00€0.37matched
35capture01a1a025-7a17-7329-9648-20f9ec692dc9€15.00€0.26matched
36capture01a1a025-851b-7f61-a464-4dda4a1ff901€15.00€0.26matched
37refund01a1a025-8fd1-7c41-87e4-e35b7b3b3e4a-€8.00€0.00matched
38capture01a1a025-a23a-79b6-a7bf-73345826e42b€15.00€0.26matched
39capture01a1a025-a2f7-7940-933a-422f15dfdf0f€24.00€0.37matched
40capture01a1a025-b4b2-7bea-b5fe-ca5d0d325665€49.00€0.67matched
41capture01a1a025-badb-733a-9068-dd9139a552ed€35.00€0.50matched
42capture01a1a025-bbba-7bfc-aeb2-d13c6b6ac33c€49.00€0.67matched
43capture01a1a025-bd96-785e-9d43-12fe415d5381€49.00€0.67matched
44capture01a1a025-c196-79a9-9d3f-0369fd0a0d36€9.00€0.19matched
45capture01a1a025-ca89-7362-9ea6-8be0f1f42734€24.00€0.37matched
46capture01a1a025-d973-7184-a99b-31bdc6c81003€49.00€0.67matched
47refund01a1a025-df4c-70cd-bf05-aef5ed8b2a34-€6.00€0.00matched
48capture01a1a026-2f32-7257-b1da-e1338f7cd250€49.00€0.67matched
49capture01a1a026-3815-77a2-b162-82e27be50419€24.00€0.37matched
50capture01a1a026-3ad8-7b78-b3eb-5ea4e9b76ac6€24.00€0.37matched
51capture01a1a026-47ff-7f44-a6e8-ba6ea43dbc2a€49.00€0.67matched
52capture01a1a026-55e3-7352-9abc-707d16ae1f4a€15.00€0.26matched
53capture01a1a026-7659-764b-bfdf-e7a61c4e4da4€24.00€0.37matched
54capture01a1a026-bbff-738e-9182-629b364541a2€9.00€0.19matched
55capture01a1a026-ab0c-7c66-975d-7a22902dfb6f€15.00€0.26matched
56capture01a1a026-cc35-7415-b969-5b09c6604186€24.00€0.37matched
57capture01a1a026-deca-7b5e-9f4c-dd582fbc2fc5€9.00€0.19matched
58capture01a1a026-dfe0-7c85-8dc2-20cace7040e0€15.00€0.26matched
59capture01a1a026-f8da-756a-931d-72fe30b479a0€35.00€0.50matched
60capture01a1a027-0496-7fd9-b7e6-a4a096f5f1c5€35.00€0.50matched
61capture01a1a027-119b-7bce-8e20-bdb4d1e65cfe€35.00€0.50matched
63capture01a1a027-39de-7196-953a-ae94f5acbe59€15.00€0.26matched
64capture01a1a027-6333-70fb-9bb1-31903e806376€35.00€0.50matched
65capture01a1a027-6dae-7b44-861a-3feee7980593€49.00€0.67matched
66refund01a1a027-7ab9-71f2-a72f-dade136e712d-€8.00€0.00matched
67refund01a1a027-91be-7cb9-8795-dac083a133a0-€3.00€0.00matched
68capture01a1a027-a58e-7c5d-8b67-071bce9efd28€24.00€0.37matched
69capture01a1a027-af05-757a-8e11-999d12dc2797€9.00€0.19matched
70capture01a1a027-dd37-76e4-b333-a5016dabc4f4€35.00€0.50matched
71capture01a1a027-f6f5-7397-9f6a-aa2455e49526€24.00€0.37matched
72capture01a1a027-fc9e-7b2c-8400-2d0778e3a7bb€35.00€0.50matched
73capture01a1a028-0fd9-7a3a-8133-3f00865eb90e€15.00€0.26matched
74refund01a1a028-2852-782a-ada6-251abc3673f0-€31.00€0.00matched
75capture01a1a028-41ed-74f8-bca4-50e786005f6d€24.00€0.37matched
76capture01a1a028-437a-79e6-9ff8-309cf202303b€9.00€0.19matched
77capture01a1a028-4aac-768b-9bf0-8bba18d1860c€49.00€0.67matched
78capture01a1a028-4be1-7f94-9db4-26eec177347d€24.00€0.37matched
79capture01a1a028-82e7-74be-8a88-24ea66d7a7a5€35.00€0.50matched
80capture01a1a028-8c94-7141-a049-4e2297e01716€24.00€0.37matched
81capture01a1a028-9654-7e42-99a0-b6c7d24351da€35.00€0.50matched
82capture01a1a028-a0f2-7466-abc8-f6afc9260dae€49.00€0.67matched
83capture01a1a028-a1b2-7a07-b2a0-c8f41ae6abe8€49.00€0.67matched
84capture01a1a028-a353-79fa-be2f-c52d53106928€49.00€0.67matched
85capture01a1a028-b8fa-795e-901f-a992e4c3ae9b€15.00€0.26matched
86capture01a1a028-ba0a-7459-94b6-337ce5e84dc4€35.00€0.50matched
87capture01a1a029-0746-7881-90ca-2bdceb6f3da5€49.00€0.67matched
88capture01a1a029-0f1f-7d4e-85ae-7e79f9698734€49.00€0.67matched
89capture01a1a029-10ef-7c5b-a7cb-619c7766f9cb€49.00€0.67matched
90capture01a1a029-11cb-7ab4-af63-7b673d66aba3€9.00€0.19matched
91capture01a1a029-4530-7e21-8af2-bc4c08db2b09€49.00€0.67matched
92capture01a1a029-48d2-7468-8df2-9eac73fa8c86€35.00€0.50matched
93capture01a1a029-773a-7a6e-9542-ad9429478900€35.00€0.50matched
94capture01a1a029-8a61-7a1f-a32f-e5d9f07c7421€24.00€0.37matched
95capture01a1a029-879e-7c57-b9f5-e5ed0159f99c€24.00€0.37matched
96capture01a1a029-8c78-7cbb-b8be-5c555add0e3c€35.00€0.50matched
97capture01a1a029-a6b7-712a-8f93-488448d2e06c€15.00€0.26matched
98capture01a1a029-c50e-7e24-b5d6-a9f723e970e8€24.00€0.37matched
100capture01a1a029-d1c8-7ddc-b743-02834fa1fa9b€49.00€0.67matched
101capture01a1a029-f75c-7467-9fbc-16dfca90a579€9.00€0.19matched
102capture01a1a02a-03d3-7c2f-aee6-3721ce6ee970€15.00€0.26matched
103capture01a1a02a-45cf-7d44-be94-397e2701f5c0€49.00€0.67matched
104capture01a1a02a-4702-7d97-8af7-d0d1faf29faf€9.00€0.19matched
105capture01a1a02a-5609-7e3c-80c5-4b142aeb8c32€15.00€0.26matched
106capture01a1a02a-68fe-75b2-9153-3b747f8b200c€24.00€0.37matched
107capture01a1a02a-7484-7d05-a923-0547d7d12225€24.00€0.37matched
108capture01a1a02a-9b9b-78f1-a7e0-be490361da9e€9.00€0.19matched
109capture01a1a02a-a2a1-7251-b4f4-ea8738712d80€49.00€0.67matched
110capture01a1a02a-e699-7fd9-b42b-1a0a4b20ccbb€9.00€0.19matched
111capture01a1a02a-edf2-7806-8053-a024cf2a01d3€15.00€0.26matched
112capture01a1a02a-ff32-70f4-9ceb-22e2f5294c82€49.00€0.67matched
113capture01a1a02b-172e-79e2-9310-a1383c29dde6€35.00€0.50matched
114capture01a1a02b-1d75-7cea-8d61-2f473a913d1d€9.00€0.19matched
115capture01a1a02b-3c0d-7e28-8f4d-a7a18ed7da80€24.00€0.37matched
117capture01a1a02b-6edd-7294-afed-580e7ab406d9€9.00€0.19matched
118capture01a1a02b-7219-749b-9a5b-66555edfc41b€49.00€0.67matched
119capture01a1a02b-721e-718e-a3d1-5e14e8175cbe€9.00€0.19matched
120capture01a1a02b-77ce-7eb1-b46d-94b84a439c0a€15.00€0.26matched
121capture01a1a02b-8da6-746c-88d2-20b946586895€49.00€0.67matched
122capture01a1a02b-9626-779d-a171-bc7e183c82a0€24.00€0.37matched
123capture01a1a02b-d169-783b-b444-c2c9e25d611a€9.00€0.19matched
124capture01a1a02b-d3c5-76c2-a2a0-c60aee98566a€49.00€0.67matched
125capture01a1a02b-d4ea-7df3-8c99-0dc62f30d2c1€15.00€0.26matched
126capture01a1a02b-e0af-77bf-9b47-c71c6ca5f528€24.00€0.37matched
127capture01a1a02b-f058-7baf-847e-7489947cb148€15.00€0.26matched