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

6 Nov, 10:50

Gross

€2,918.00

PSP fee

€46.57

Net to the bank

€2,871.43

Settlement journal

#414802

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b07b-6edf-7c65-aac3-e1eca3384b8a is already settled by stl_EUR_2989937 line 18
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
LineKindReferenceGrossFeeStatus
12capture01a1b07b-1ff3-7934-93c9-7efb3c18e782€9.00€0.24fee difference
19capture01a1b07b-6f23-7656-ab4d-29ad6ac2838b€9.00€0.19duplicate line
119capture01a1b083-171b-7e75-826b-b09596fb6f72€15.00€0.28fee difference
1refund01a1b072-b7e9-7da4-9215-2a7f447dbc92-€13.00€0.00matched
2capture01a1b075-33ea-7698-9259-6b5ecd824a53€15.00€0.26matched
3capture01a1b075-e4db-7004-9dce-0b5c4dee51db€24.00€0.37matched
4capture01a1b078-9b86-7383-b1db-381e4f231c48€24.00€0.37matched
5capture01a1b07a-ce35-7e19-88dd-b56ce0aeca8a€15.00€0.26matched
6capture01a1b07a-daec-7346-bfab-78ddedbef007€35.00€0.50matched
7capture01a1b07a-ea1d-74ae-a117-745254ff23b9€24.00€0.37matched
8capture01a1b07a-e820-70ee-b709-9b677e52967e€9.00€0.19matched
9capture01a1b07a-f84e-7665-8f7f-2da88e8c8805€15.00€0.26matched
10capture01a1b07b-1954-70a0-8b8b-d274d17114e5€35.00€0.50matched
11capture01a1b07b-1ef3-7ccc-87bc-31eb09bdf21c€15.00€0.26matched
13capture01a1b07b-2822-79f1-b283-88ca36864b37€15.00€0.26matched
14refund01a1b07b-2d29-7a8b-9dcf-52f7dea1b0ee-€6.00€0.00matched
15capture01a1b07b-2e64-75a3-9841-50fa891f9752€9.00€0.19matched
16capture01a1b07b-3347-70a3-9fd2-c1df9ffbe4f1€49.00€0.67matched
17capture01a1b07b-5d6d-7a8b-a60e-059d50f5f800€35.00€0.50matched
18capture01a1b07b-6f23-7656-ab4d-29ad6ac2838b€9.00€0.19matched
20capture01a1b07b-7790-776e-9562-d68f516a740e€49.00€0.67matched
21refund01a1b07b-a7cf-75f6-8af8-e127be39e945-€29.00€0.00matched
22capture01a1b07b-cc99-7a6c-8d6b-0935485d2f01€9.00€0.19matched
23capture01a1b07b-d49b-7ba9-ad18-2b682251a2f9€15.00€0.26matched
24capture01a1b07b-d8a6-74e5-8a5f-4ec24ef01c41€9.00€0.19matched
25capture01a1b07b-da01-77bd-a500-787cd2017ed3€35.00€0.50matched
26capture01a1b07b-f019-758b-a479-dcaa3816eea3€49.00€0.67matched
27capture01a1b07b-f61e-71cf-a3e7-48702a84c6a8€9.00€0.19matched
28capture01a1b07c-0151-7b8d-997d-859fef37d259€35.00€0.50matched
29capture01a1b07c-0fb9-7c9d-8db4-d92e25e1124d€35.00€0.50matched
30capture01a1b07c-1adb-7bd0-8a7e-e5a9dc8a20b5€15.00€0.26matched
31capture01a1b07c-44da-7e49-9ab1-d17f3309b970€9.00€0.19matched
32capture01a1b07c-4671-7eef-9ac8-65d161541a47€49.00€0.67matched
33refund01a1b07c-834d-78e5-a3fa-6460c49af993-€5.00€0.00matched
34capture01a1b07c-8d29-7725-8d9d-758720b5b7c0€49.00€0.67matched
35capture01a1b07c-8e86-79d7-a53a-826a0addc95f€35.00€0.50matched
36capture01a1b07c-92e8-70c0-89cd-717714fb539c€15.00€0.26matched
37capture01a1b07c-9f8b-74b7-adaf-868104109c29€15.00€0.26matched
38capture01a1b07c-a142-703f-b644-9a15fd67e2be€35.00€0.50matched
39capture01a1b07c-addd-7d46-96cc-933068a620ba€49.00€0.67matched
40capture01a1b07c-bfd1-77bd-b4e2-6ae18d2e297b€24.00€0.37matched
41capture01a1b07c-cfe8-7e05-b1ca-33003c078727€24.00€0.37matched
42capture01a1b07c-d162-735f-89e5-7978b8124242€9.00€0.19matched
43refund01a1b07c-e3f4-77f4-8c6c-71c412bd22a5-€23.00€0.00matched
44refund01a1b07c-f11e-7f33-afa3-890031028835-€7.00€0.00matched
45capture01a1b07c-ff23-7c4a-83f3-97de687992ec€24.00€0.37matched
46refund01a1b07d-0598-7176-ac11-a3d54968431c-€12.00€0.00matched
47capture01a1b07d-0743-7b4f-a8c1-0524e3bdfe4c€9.00€0.19matched
48capture01a1b07d-15bc-780e-a23d-57055ce8d31f€15.00€0.26matched
49capture01a1b07d-2809-7158-9949-a02537ccf909€49.00€0.67matched
50capture01a1b07d-4775-7aa2-8567-3100a2278241€15.00€0.26matched
51capture01a1b07d-4f61-719b-9c8e-5ce9c517cb2f€24.00€0.37matched
52capture01a1b07d-537a-7078-837c-b3cc4211b6eb€35.00€0.50matched
53capture01a1b07d-663f-7fdc-9b86-1ca7d82bd053€49.00€0.67matched
54capture01a1b07d-66c4-7c55-9317-446bced312ae€15.00€0.26matched
55capture01a1b07d-7799-72e6-9ab8-81ae6fc0e604€15.00€0.26matched
56refund01a1b07d-90bc-770f-81d8-c2c973066d18-€9.00€0.00matched
57capture01a1b07d-9728-73fb-a1c0-a98ab9b8c96b€35.00€0.50matched
58capture01a1b07d-a6b2-7203-97b6-0944a14a42a4€24.00€0.37matched
59capture01a1b07d-af4f-74af-b446-448de79fd06d€24.00€0.37matched
60capture01a1b07d-db8a-786b-a0a8-ef8b76ba24d8€24.00€0.37matched
61capture01a1b07d-e3ba-7c81-8c7a-a05dac2638de€35.00€0.50matched
62capture01a1b07d-f808-7b9c-8867-e2e3f1d05868€9.00€0.19matched
63capture01a1b07e-195f-7e74-9340-16741fb65192€24.00€0.37matched
64capture01a1b07e-1c78-7107-857e-39588db8ccda€9.00€0.19matched
65capture01a1b07e-21dd-7634-b68b-6201127e47d1€24.00€0.37matched
66capture01a1b07e-28ea-74eb-b857-ce8a0e511de0€15.00€0.26matched
67capture01a1b07e-4cc3-7c84-bd6b-9d67c291996c€9.00€0.19matched
68capture01a1b07e-6d69-7f5e-b2fd-c461d5fe2e69€49.00€0.67matched
69capture01a1b07e-763e-7c21-82ea-f1506a6d3075€15.00€0.26matched
70capture01a1b07e-8577-7f3f-a031-53c0c2b5a3b0€9.00€0.19matched
71capture01a1b07e-881b-7121-85d0-188a70c46605€24.00€0.37matched
72capture01a1b07e-9bce-79dc-bf53-4eb809bb3c3d€35.00€0.50matched
73capture01a1b07e-daad-7365-859a-666d4bdf7f2c€24.00€0.37matched
74refund01a1b07e-dc39-735a-a3bd-31be2722e2f1-€3.00€0.00matched
75capture01a1b07f-082b-7a77-a9e9-a2429fd2c4b7€35.00€0.50matched
76capture01a1b07f-1fa8-7e57-9d10-322b4b4b2479€35.00€0.50matched
77capture01a1b07f-4128-7315-b300-568d444e1895€49.00€0.67matched
78capture01a1b07f-4aa8-7915-b974-e6f34b327112€49.00€0.67matched
79capture01a1b07f-763b-7036-87c4-5fa04547ac50€35.00€0.50matched
80capture01a1b07f-7671-766f-b70d-4c26f05b409a€24.00€0.37matched
81capture01a1b07f-7c05-71d4-87c6-3739c8e31cfb€49.00€0.67matched
82capture01a1b07f-903b-7383-a1c6-ffee41d9b72f€35.00€0.50matched
83capture01a1b07f-c01b-793f-8e1f-5c55149fa7b0€49.00€0.67matched
84capture01a1b07f-c489-78a7-9cda-aff5b0fc8081€24.00€0.37matched
85capture01a1b07f-df01-788c-b740-2248b74f873d€9.00€0.19matched
86capture01a1b07f-e4fc-7df3-a8da-deb5f1194711€49.00€0.67matched
87capture01a1b07f-ff1e-75b7-a0f4-eb71d28086f8€35.00€0.50matched
88capture01a1b080-0eb4-74c3-81ba-9d9ecaee4970€49.00€0.67matched
89capture01a1b080-23d5-7ef0-a9f3-6ff2d87d81c4€24.00€0.37matched
90capture01a1b080-5d40-725a-994d-2a848fc79107€24.00€0.37matched
91capture01a1b080-752e-784b-8dcc-2d78df25d613€35.00€0.50matched
92capture01a1b080-8ed5-7b68-9c53-18d69e79c8e4€15.00€0.26matched
93capture01a1b080-982e-725d-a532-ce654322c4bf€35.00€0.50matched
94capture01a1b080-d606-70ea-b79f-75129cca2d44€49.00€0.67matched
95capture01a1b081-0e36-7604-a0b0-c825d677aa86€24.00€0.37matched
96capture01a1b081-4baf-7574-a28f-de828e778caf€15.00€0.26matched
97refund01a1b081-7749-740a-928e-1a6ed6fd60f3-€10.00€0.00matched
98capture01a1b081-7b9c-789a-a8c9-ff0e189a7848€24.00€0.37matched
99capture01a1b081-e898-752d-b8d1-96f0b0c8385c€9.00€0.19matched
100capture01a1b081-fc7e-7508-b1ef-7f8985958fda€15.00€0.26matched
101capture01a1b082-000a-70b9-9719-a44af22f0a3e€49.00€0.67matched
102capture01a1b082-0257-7946-902d-6a405ce6446a€24.00€0.37matched
103capture01a1b082-0cd6-7c84-a1d5-8d7f34fab643€15.00€0.26matched
104capture01a1b082-1e9a-7ab1-a04d-3c448a027dc4€35.00€0.50matched
105capture01a1b082-28ea-7aa4-83f7-7c8b87a6b2b7€49.00€0.67matched
106capture01a1b082-30de-7811-8968-cae97eee4a7a€35.00€0.50matched
107capture01a1b082-378a-7f68-930f-1f5dd80145c6€15.00€0.26matched
108capture01a1b082-4683-7769-bc5e-d49137a6241d€35.00€0.50matched
109capture01a1b082-48d8-7f90-80d3-006b2ee6d918€35.00€0.50matched
110capture01a1b082-7d1b-7c70-8eb9-6cfc5b0ce9c0€24.00€0.37matched
111capture01a1b082-80ba-7301-9d9d-738458a61df5€49.00€0.67matched
112refund01a1b082-92f0-765c-ba1d-0306c25e62eb-€12.00€0.00matched
113capture01a1b082-abd4-76e5-a16f-ba14ba6ba3d4€35.00€0.50matched
114capture01a1b082-ccc6-7218-b721-649d7a052f51€24.00€0.37matched
115capture01a1b082-d52f-748a-bb23-7de1550fa696€24.00€0.37matched
116capture01a1b082-f395-7391-9992-7d8e5e102c6a€15.00€0.26matched
117capture01a1b082-ff2e-7e13-9a16-38d34dee1be5€15.00€0.26matched
118capture01a1b083-0994-7e45-8556-81aaa9818941€35.00€0.50matched
120refund01a1b083-1e75-75ab-9bb0-17fe946100c4-€30.00€0.00matched
121capture01a1b083-3318-734f-88e0-bd520ba5a4a3€24.00€0.37matched
122capture01a1b083-3434-7e66-96d5-68abb4e066ce€9.00€0.19matched
123capture01a1b083-955b-71ee-b2ee-01a88fcd4679€9.00€0.19matched
124capture01a1b083-995a-76d4-a8d9-4576bb53df70€49.00€0.67matched
125capture01a1b083-a348-73af-9fc9-a374b22b9b82€35.00€0.50matched
126capture01a1b083-a871-7e2f-a9ff-226e5ef11324€35.00€0.50matched
127capture01a1b083-b582-72a2-9bed-5a653fd021a4€15.00€0.26matched
128capture01a1b083-e98b-7056-a0af-eb5211a4634f€35.00€0.50matched
129refund01a1b083-ef3e-7c0e-aa3c-26b60161f7ee-€8.00€0.00matched
130refund01a1b083-f1e6-7c06-a64c-d18f99d394d6-€6.00€0.00matched