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

Gross

€2,591.00

PSP fee

€41.03

Net to the bank

€2,549.97

Settlement journal

#361984

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a1a9-237a-72e9-b9d3-ef928718aa6a is already settled by stl_EUR_2989522 line 75
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
  • 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 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
LineKindReferenceGrossFeeStatus
36capture01a1a1a5-d79b-74a3-9dbe-be4f85ba1915€35.00€0.51fee difference
40capture01a1a1a6-0a25-7bc0-9eb0-170f80f16534€35.00€0.52fee difference
76capture01a1a1a9-35e4-7511-8461-a070ca5bdc3c€15.00€0.26duplicate line
78capture01a1a1a9-4b86-72db-9fb1-4c090b1ee0ad€15.00€0.29fee difference
105capture01a1a1ab-7fdf-7389-906d-daa1d91332f5€35.00€0.52fee difference
1capture01a1a1a1-ffe5-7488-a990-6d33b691b865€49.00€0.67matched
2capture01a1a1a3-3794-7988-b995-c84df584b5e6€9.00€0.19matched
3capture01a1a1a3-612b-7d75-817a-e40ca44274be€15.00€0.26matched
4capture01a1a1a3-7041-7858-8518-7a2878c9de2f€49.00€0.67matched
5capture01a1a1a3-6c9b-7793-a8c4-5983ac079937€35.00€0.50matched
6capture01a1a1a3-777b-7459-a99a-dd85eaded32d€49.00€0.67matched
7capture01a1a1a3-dc70-7e14-8f17-2dd594c49108€49.00€0.67matched
8capture01a1a1a4-0e3f-7678-a3f7-393f5c9eeb93€49.00€0.67matched
9capture01a1a1a4-31fa-7520-a2ec-6a2a46e6535b€35.00€0.50matched
10capture01a1a1a4-41a1-71e0-b7ab-502abe85688a€15.00€0.26matched
11capture01a1a1a4-4bae-777d-893e-90c94a52e824€15.00€0.26matched
12capture01a1a1a4-5079-7d8f-bfd9-e16d8326ce95€15.00€0.26matched
13refund01a1a1a4-759b-7241-9c3e-b06875bd958b-€5.00€0.00matched
14capture01a1a1a4-72ea-7823-be29-ec084bdf3811€35.00€0.50matched
15capture01a1a1a4-8862-7cae-902d-0dcfba044600€15.00€0.26matched
16capture01a1a1a4-8cc9-7f0b-8202-569fe81e939c€35.00€0.50matched
17capture01a1a1a4-8d86-7d86-a2e0-0760694569ab€49.00€0.67matched
18capture01a1a1a4-aea3-71c4-b808-6cedf6b27362€24.00€0.37matched
19refund01a1a1a4-c525-7c00-8479-cf69e038b0a8-€8.00€0.00matched
20capture01a1a1a4-d3b0-7c77-a2cf-6e721d13b965€9.00€0.19matched
21capture01a1a1a4-eb9b-76bc-ab82-79d514bd2e7e€49.00€0.67matched
22capture01a1a1a4-fcaf-792b-b104-e55a1f6c2458€49.00€0.67matched
23capture01a1a1a5-00bf-7ede-bf54-ec5fb567fc5b€49.00€0.67matched
24capture01a1a1a5-12b5-7808-ad55-c8ca4550d819€49.00€0.67matched
25capture01a1a1a5-1b69-7efa-a821-637bf607f952€9.00€0.19matched
26capture01a1a1a5-1dfb-7237-8d12-cdb9d03f9cf5€24.00€0.37matched
27capture01a1a1a5-1d92-7940-b1f9-6514a0f28385€15.00€0.26matched
28refund01a1a1a5-464d-71cb-9b97-7af6744f4dfe-€21.00€0.00matched
29capture01a1a1a5-4d5c-781d-bf0c-4f650cdac0bb€24.00€0.37matched
30capture01a1a1a5-7433-7c1b-b1e6-8b2b89610b2b€35.00€0.50matched
31capture01a1a1a5-86f3-7991-9e3f-13570a1a7b2a€9.00€0.19matched
32capture01a1a1a5-b3c9-76fb-a25e-f43e0dac9306€49.00€0.67matched
33capture01a1a1a5-c277-73fe-a7aa-3242ace53032€24.00€0.37matched
34capture01a1a1a5-c4c8-762d-822e-6089f8a1ceb8€9.00€0.19matched
35capture01a1a1a5-cc09-78d7-869c-bbab24fbc950€49.00€0.67matched
37capture01a1a1a5-eb23-781c-9d89-61d2f3883c7f€49.00€0.67matched
38capture01a1a1a5-eb83-74d0-8723-b14c9520e5f8€15.00€0.26matched
39refund01a1a1a5-f711-7ca9-a2ba-582d1f044235-€4.00€0.00matched
41capture01a1a1a6-0b64-7977-a56c-3df259991e93€49.00€0.67matched
42refund01a1a1a6-107b-7725-84c5-8c3b45ca7215-€4.00€0.00matched
43capture01a1a1a6-13b5-7560-aecb-cb214c59c22c€24.00€0.37matched
44capture01a1a1a6-140b-7be0-ad55-f5774bf4c92b€9.00€0.19matched
45refund01a1a1a6-3ade-75a8-87ba-96f44c2bb57f-€14.00€0.00matched
46capture01a1a1a6-3940-7c08-a763-4a4d5a27c511€9.00€0.19matched
47capture01a1a1a6-4bce-7c59-b3d2-d567a1b6f2a6€9.00€0.19matched
48capture01a1a1a6-56d4-764b-80ee-df510f6dc32d€9.00€0.19matched
49capture01a1a1a6-5a56-7e76-ab60-8dea76361904€49.00€0.67matched
50capture01a1a1a6-5c69-7469-b605-be651741c2cc€49.00€0.67matched
51capture01a1a1a6-6656-7957-9aa3-e9f53c176396€35.00€0.50matched
52refund01a1a1a6-7ce5-79f6-a3a5-22f913417d9c-€21.00€0.00matched
53capture01a1a1a6-a77f-7401-b6d4-27568a067eb8€15.00€0.26matched
54capture01a1a1a6-a9b8-76f3-bcef-e0dd428aa607€49.00€0.67matched
55capture01a1a1a6-da2e-7f3b-89fa-5af9639dd6f4€15.00€0.26matched
56capture01a1a1a6-dedb-7ede-9ec2-ce10451af149€15.00€0.26matched
57refund01a1a1a6-f322-7e1e-8acc-ddab9a9a4a74-€13.00€0.00matched
58capture01a1a1a7-223c-7e8c-b056-3ee9a6aab413€15.00€0.26matched
59capture01a1a1a7-4031-7830-beb6-abee290962a4€15.00€0.26matched
60capture01a1a1a7-6df7-7ee3-918e-978549283c2e€9.00€0.19matched
61capture01a1a1a7-9b3b-7a61-970f-b4c08b527f4c€49.00€0.67matched
62capture01a1a1a7-a5a8-7566-b94a-0baa44e0284f€9.00€0.19matched
63capture01a1a1a7-c835-777e-b932-84718529346d€24.00€0.37matched
64capture01a1a1a7-fc50-70c5-8c42-71b662d09b95€9.00€0.19matched
65capture01a1a1a7-fe7d-7035-b3dd-39efc858840f€24.00€0.37matched
66capture01a1a1a8-0425-7b6c-a6fe-de4c699af104€35.00€0.50matched
67capture01a1a1a8-2aed-7ec6-a166-d0674a31bda0€35.00€0.50matched
68refund01a1a1a8-38a3-71d9-b676-6c1bdc2bd23b-€3.00€0.00matched
69capture01a1a1a8-480d-725b-8694-cadee28f16a9€24.00€0.37matched
70capture01a1a1a8-4b1f-7096-ba9b-2d21b4e535ff€9.00€0.19matched
71capture01a1a1a8-5047-738d-9888-4876c7c6761c€35.00€0.50matched
72refund01a1a1a8-73d9-7fb7-b0a1-a4708887eaa1-€16.00€0.00matched
73capture01a1a1a8-c2d1-7174-a221-432327008ee6€35.00€0.50matched
74capture01a1a1a8-dc89-73eb-89c1-42718a2ff861€35.00€0.50matched
75capture01a1a1a9-35e4-7511-8461-a070ca5bdc3c€15.00€0.26matched
77capture01a1a1a9-46c5-71fa-be21-3a9cbd3869a9€9.00€0.19matched
79capture01a1a1a9-4504-7a4c-8d03-2ba222153c74€35.00€0.50matched
80capture01a1a1a9-656f-75d4-af23-c5e0ed9a5334€15.00€0.26matched
81capture01a1a1a9-673d-7a07-a1aa-d0215332d4c9€9.00€0.19matched
82capture01a1a1a9-770a-7bbd-bae8-ca7f4932c859€35.00€0.50matched
83capture01a1a1a9-857c-707a-85fc-fbfc28545c66€24.00€0.37matched
84capture01a1a1a9-9cd3-7c28-8289-d1d485c2126b€24.00€0.37matched
85capture01a1a1a9-afd0-79c7-9ba8-52ea073cd815€49.00€0.67matched
86capture01a1a1a9-be8a-72bc-aad7-aecf54fb7720€15.00€0.26matched
87capture01a1a1a9-c560-7cc8-8f5d-bb5e014a2f62€9.00€0.19matched
88capture01a1a1a9-cd01-75ca-9e7d-ac5faeab0e39€49.00€0.67matched
89capture01a1a1a9-e1a9-7bc0-b4f1-1a0716020f1a€9.00€0.19matched
90capture01a1a1a9-e4fe-7caa-8e5f-830030a7e864€35.00€0.50matched
91capture01a1a1a9-ec24-7125-a57b-4e416caeee7f€9.00€0.19matched
92capture01a1a1aa-10b8-79da-ad09-add675194f20€9.00€0.19matched
93capture01a1a1aa-21b9-72f2-b13c-831f211de30e€35.00€0.50matched
94capture01a1a1aa-36f5-7e6c-9f91-a8af42e930b2€9.00€0.19matched
95capture01a1a1aa-50e4-736e-8a53-c4a0140c8d1d€24.00€0.37matched
96capture01a1a1aa-7439-7524-b7b8-1fd81afdc90b€9.00€0.19matched
97capture01a1a1aa-9122-74df-bb68-a576570754f3€15.00€0.26matched
98capture01a1a1aa-92f5-7690-bf08-6a806d1a049e€9.00€0.19matched
99capture01a1a1aa-ded6-712a-ae8f-db72847751fe€15.00€0.26matched
100capture01a1a1aa-f866-73a5-8d19-6ef1e77ecd57€49.00€0.67matched
101capture01a1a1ab-0282-7c9c-a5c6-14419c9f8cde€9.00€0.19matched
102refund01a1a1ab-0c22-780e-becf-79449af39ac5-€9.00€0.00matched
103capture01a1a1ab-30af-7e0f-8860-f058a9f64702€9.00€0.19matched
104capture01a1a1ab-7eaa-73ae-a493-8fe2243ce9ff€15.00€0.26matched
106capture01a1a1ab-f04f-79b8-be0d-4ef945bbb1f2€35.00€0.50matched
107capture01a1a1ab-f5bc-766d-aeaa-7e31f9a25e1c€49.00€0.67matched
108capture01a1a1ab-f72d-7319-86f1-6bc5ef04c598€15.00€0.26matched
109capture01a1a1ab-f98c-7bab-8d10-65d28ee8ba75€24.00€0.37matched
110capture01a1a1ac-13e0-7f15-9638-a76333ac10d2€24.00€0.37matched
111capture01a1a1ac-1f32-7ffd-bf9f-b8bf41f04c5e€15.00€0.26matched
112capture01a1a1ac-403b-7c20-97eb-0d9484e8b0c4€9.00€0.19matched
113capture01a1a1ac-53b1-73df-ae8d-13c5705bd2f0€35.00€0.50matched
114capture01a1a1ac-5b91-7035-8682-59058e82b014€15.00€0.26matched
115capture01a1a1ac-74cf-77b8-8527-81857bfd82d3€49.00€0.67matched