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

4 Nov, 01:10

Gross

€3,055.00

PSP fee

€49.03

Net to the bank

€3,005.97

Settlement journal

#370748

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a421-cf67-7d92-b337-54bbfaee9a4d is already settled by stl_EUR_2989591 line 97
  • fee differencethe fee is not the contract feethe fee is 3, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 69, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
LineKindReferenceGrossFeeStatus
47refund01a1a41d-e6cd-7e8f-82d6-210271b16c8f-€10.00€0.03fee difference
98capture01a1a421-cfb0-7fd0-87b2-de360d2f1290€15.00€0.26duplicate line
105capture01a1a422-5dc9-7b68-800c-437631ccda86€49.00€0.69fee difference
117capture01a1a423-399f-7479-87cc-4095acadb2b5€49.00€0.71fee difference
1capture01a1a415-2a34-7054-bc5d-e5bc4553fbe9€15.00€0.26matched
2capture01a1a419-86fb-79ca-a8e7-d9a1d2db6481€49.00€0.67matched
3capture01a1a41b-1723-737e-81f4-0432cd190ab3€24.00€0.37matched
4capture01a1a41b-2527-7c69-883a-4dde6fca7721€15.00€0.26matched
5capture01a1a41b-3ce0-78cd-9e78-bc66f69502f0€24.00€0.37matched
6capture01a1a41b-3094-7160-9615-311c0b51fa1a€24.00€0.37matched
7capture01a1a41b-9fd7-7961-a19d-bb6e0548114e€35.00€0.50matched
8refund01a1a41b-a05a-7240-9428-4a1263b62535-€22.00€0.00matched
9capture01a1a41b-bbba-7be5-b318-b9b8d91326b0€24.00€0.37matched
10capture01a1a41b-ca83-798e-a158-0e4fa19abaec€24.00€0.37matched
11capture01a1a41b-caf9-770c-9c8e-cdda338237c2€15.00€0.26matched
12capture01a1a41b-cdf4-7d2b-bf97-d6b86c647a4f€15.00€0.26matched
13capture01a1a41b-d3fe-7229-a41f-616db85482dd€9.00€0.19matched
14capture01a1a41c-156c-73e5-a9d2-3c5943ef5dd5€24.00€0.37matched
15capture01a1a41c-2037-747d-b16b-c2f738f5f261€15.00€0.26matched
16capture01a1a41c-32ee-7c91-be36-e42927f073cf€35.00€0.50matched
17capture01a1a41c-33b2-7a20-b695-7878cb752a38€15.00€0.26matched
18capture01a1a41c-486f-75b5-8a88-7207b1d4d24b€35.00€0.50matched
19capture01a1a41c-55e5-7152-b55e-ec91f4efccab€49.00€0.67matched
20capture01a1a41c-5966-7e22-82eb-5ff2d2515f5b€15.00€0.26matched
21capture01a1a41c-6563-7c6c-8a6f-70a210c70959€35.00€0.50matched
22capture01a1a41c-6f37-79fd-813e-ca608d71ff86€24.00€0.37matched
23capture01a1a41c-7e55-71c3-8ca6-768e249b33da€49.00€0.67matched
24capture01a1a41c-85a7-7457-bb29-5f2bcfc894a0€24.00€0.37matched
25capture01a1a41c-9396-7b57-81dd-b964bfacab01€15.00€0.26matched
26capture01a1a41c-a446-7dbb-8c8d-dc4d09da0549€35.00€0.50matched
27capture01a1a41c-ba61-786e-8965-191e780b22e6€35.00€0.50matched
28refund01a1a41c-d68b-71e2-bc46-a8c4db131118-€7.00€0.00matched
29capture01a1a41c-e6c6-77fa-adee-665da5e6390b€49.00€0.67matched
30capture01a1a41c-ee25-7c9d-af43-a254b4241892€49.00€0.67matched
31capture01a1a41d-11ef-7da4-a09e-2beb57cf9790€15.00€0.26matched
32capture01a1a41d-23af-7442-acd2-6a6077a3ab13€49.00€0.67matched
33capture01a1a41d-2af7-7258-ae68-b00f259be616€24.00€0.37matched
34capture01a1a41d-2f29-70c0-8c0c-df32bc81e670€24.00€0.37matched
35capture01a1a41d-3460-7821-8d38-95dcd6242840€49.00€0.67matched
36capture01a1a41d-3b46-75c4-b366-44e7e13eca78€15.00€0.26matched
37capture01a1a41d-5526-7a4f-a542-d7455034b9c6€24.00€0.37matched
38capture01a1a41d-5bb6-7e95-870f-3870cbca36b5€35.00€0.50matched
39capture01a1a41d-8410-7a2f-b55a-7f041c10a082€9.00€0.19matched
40capture01a1a41d-895a-7804-9c14-4663150a999c€49.00€0.67matched
41capture01a1a41d-9739-766c-8cd4-dfcadcb0550b€49.00€0.67matched
42capture01a1a41d-989e-7fe2-b969-0c2b65b64441€24.00€0.37matched
43capture01a1a41d-be76-783d-86ca-93ae7010ab80€35.00€0.50matched
44capture01a1a41d-c07f-7f78-b505-78b9640eed7e€24.00€0.37matched
45capture01a1a41d-dd26-7203-9904-df1ff42c4791€35.00€0.50matched
46capture01a1a41d-deb6-7a7a-b8b5-140c9e4b093f€15.00€0.26matched
48capture01a1a41d-e8bd-7bce-a601-bbbf9fdf8e8c€15.00€0.26matched
49capture01a1a41d-fc52-797f-a20c-abf18e2c32b9€9.00€0.19matched
50capture01a1a41e-02ae-79c1-8ebd-6caf698da1e9€49.00€0.67matched
51capture01a1a41e-14c1-75d7-bfb4-fc06cd21ac08€35.00€0.50matched
52capture01a1a41e-24d8-7555-9bc4-55c8ce3bc1a6€15.00€0.26matched
53capture01a1a41e-2978-7323-b9e5-ff884416d26b€49.00€0.67matched
54capture01a1a41e-3534-7d9c-8a00-1752841486ed€49.00€0.67matched
55capture01a1a41e-5c02-720c-bbbe-8ae169463cc0€9.00€0.19matched
56capture01a1a41e-6365-71e5-95b6-934feefc026d€49.00€0.67matched
57refund01a1a41e-6788-744c-8297-ef742ac242d1-€27.00€0.00matched
58capture01a1a41e-6985-7f4a-ae78-151a1fe2fde7€15.00€0.26matched
59capture01a1a41e-7b6e-7c3f-bd6e-d8a745aec98a€24.00€0.37matched
60capture01a1a41e-9144-79f2-a38a-7f65614305d9€35.00€0.50matched
61capture01a1a41e-98b9-7556-809f-1fe1f0882028€15.00€0.26matched
62capture01a1a41e-9d8b-70b5-b85b-db7a9a976d55€35.00€0.50matched
63capture01a1a41e-9e05-73cc-84b6-6ed836e3d80e€15.00€0.26matched
64capture01a1a41e-c52c-7d49-b101-a575bee0d6f1€35.00€0.50matched
65capture01a1a41e-c628-78cc-91a0-5a226e01c7c5€49.00€0.67matched
66capture01a1a41e-c7ab-7479-a3cd-13b314564952€15.00€0.26matched
67capture01a1a41e-d3a0-71ab-baf3-be2bd7e61627€9.00€0.19matched
68capture01a1a41e-f400-7a54-b749-3c3a9af5b49d€15.00€0.26matched
69capture01a1a41f-02e9-756c-9ac2-8852d0ffbf7d€49.00€0.67matched
70refund01a1a41f-335f-7569-a35c-f7e1e6478b9a-€15.00€0.00matched
71capture01a1a41f-38f5-7e67-8a66-58346d4f6afd€49.00€0.67matched
72capture01a1a41f-6780-7bb6-bf1d-a60bf4fbcf56€35.00€0.50matched
73capture01a1a41f-ada9-783e-a9b7-3178ad0506ce€35.00€0.50matched
74capture01a1a41f-d860-7298-aed3-82ebfa4a1e7a€24.00€0.37matched
75capture01a1a41f-daa1-7f51-9042-03c22be7e02b€9.00€0.19matched
76capture01a1a420-2a8e-7dfa-819a-7d9fef837bf0€35.00€0.50matched
77capture01a1a420-2ae0-7c21-b4e8-39cef4654d22€9.00€0.19matched
78capture01a1a420-2eb2-7441-b057-6487f70dd5ab€15.00€0.26matched
79capture01a1a420-6e6c-7ebb-b4d3-8e30779a83aa€24.00€0.37matched
80capture01a1a420-7b5d-7a7b-8427-ab8a8ad4ff86€15.00€0.26matched
81capture01a1a420-7d61-7d5a-9ced-8c42ec9405a1€35.00€0.50matched
82capture01a1a420-8a2c-74cc-bf8f-e27bcca19a03€35.00€0.50matched
83refund01a1a420-8bac-7127-ab64-3bbb0683248d-€13.00€0.00matched
84refund01a1a420-af76-7a32-9a11-f10cca26d450-€8.00€0.00matched
85capture01a1a420-d545-70d5-bd7b-e5e0c7fb3b81€9.00€0.19matched
86capture01a1a421-106b-7b7b-99f1-027052325d58€49.00€0.67matched
87capture01a1a421-1301-787b-b3c4-ae42196dc069€49.00€0.67matched
88capture01a1a421-2b89-781f-955c-1f1ad2865506€24.00€0.37matched
89capture01a1a421-5b56-7bfb-8039-1f79e3f7eb71€24.00€0.37matched
90capture01a1a421-7b31-763c-91c9-2ff81fcb0c93€49.00€0.67matched
91refund01a1a421-7b3e-75c9-9af5-8263de1a1f02-€8.00€0.00matched
92capture01a1a421-807c-75a1-afc8-a8a6e5887b12€49.00€0.67matched
93capture01a1a421-9552-7629-a4b3-9fae1d2924a5€35.00€0.50matched
94capture01a1a421-aaae-742f-a5dc-cda4034bcdd1€9.00€0.19matched
95capture01a1a421-b25a-721c-b007-1ae9a3ab12d6€35.00€0.50matched
96capture01a1a421-c917-7c5f-b7e1-1da9668fea42€9.00€0.19matched
97capture01a1a421-cfb0-7fd0-87b2-de360d2f1290€15.00€0.26matched
99capture01a1a421-d98b-7c09-baa1-f877d810f629€15.00€0.26matched
100refund01a1a421-f6ae-747e-9eb4-943dc4ed7578-€31.00€0.00matched
101capture01a1a422-1222-7ba8-8d2e-f4221c520ce9€9.00€0.19matched
102capture01a1a422-25fd-726e-b971-7937929d3a8d€9.00€0.19matched
103capture01a1a422-2730-7f33-8e80-d384e093d3a0€15.00€0.26matched
104refund01a1a422-5346-7b13-911a-58d4142db767-€4.00€0.00matched
106capture01a1a422-68d0-7ab3-99c8-43ec2b86a6ab€9.00€0.19matched
107capture01a1a422-6a81-7ed6-a87d-cf87a6371873€49.00€0.67matched
108capture01a1a422-7e55-7ea8-9b15-ccb2d7fd0828€24.00€0.37matched
109capture01a1a422-912d-7613-9103-c93c6e71dab6€9.00€0.19matched
110capture01a1a422-9ce7-7da8-81ca-f64b78c62a47€24.00€0.37matched
111capture01a1a422-b2ee-789b-8042-5a75a5a38a4a€35.00€0.50matched
112capture01a1a422-cdda-79a9-a142-1b1b4be35ed1€15.00€0.26matched
113refund01a1a422-d2d0-7a77-857a-491c54a2e155-€39.00€0.00matched
114capture01a1a422-e981-7f83-bf85-de59f8a40dd5€9.00€0.19matched
115refund01a1a423-1721-77ed-bc5b-f8d4740dadee-€11.00€0.00matched
116capture01a1a423-274d-7d25-b5f6-65f0bec33987€15.00€0.26matched
118capture01a1a423-4719-7a2a-8fad-6cfd44ecd67d€24.00€0.37matched
119capture01a1a423-49bf-7cb4-ac37-b118a1236c3d€24.00€0.37matched
120capture01a1a423-4c94-7432-98f7-0d30bcbee7b7€49.00€0.67matched
121capture01a1a423-5506-7032-9dfe-26e79f0203b7€15.00€0.26matched
122capture01a1a423-4afe-75a6-a3c4-107b8faaea3b€49.00€0.67matched
123capture01a1a423-677c-7e06-90f3-daf2dae71978€49.00€0.67matched
124capture01a1a423-7b7f-767b-9ec9-738dcf465713€15.00€0.26matched
125capture01a1a423-83ce-7076-814e-4bdfcb10c288€24.00€0.37matched
126refund01a1a423-92b2-796c-9bb1-64b6f276fe4b-€10.00€0.00matched
127capture01a1a423-968a-7c62-bad9-ab9a0bd0f3c1€15.00€0.26matched
128capture01a1a423-b9e5-7679-9209-8e671421f371€35.00€0.50matched
129refund01a1a423-bd18-745e-af35-f9d078dfc3ce-€7.00€0.00matched
130capture01a1a423-c0ec-72f2-9173-169f7fadba51€35.00€0.50matched
131capture01a1a423-df53-7116-b5c6-97458f3fb112€9.00€0.19matched
132capture01a1a424-095b-7cee-b443-2d09e9ae76d2€24.00€0.37matched
133capture01a1a424-1da0-7390-b361-b36155e9098a€9.00€0.19matched
134capture01a1a424-21b2-7dd1-95ae-2db269249e40€24.00€0.37matched