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

2 Nov, 01:40

Gross

€3,098.00

PSP fee

€47.32

Net to the bank

€3,050.68

Settlement journal

#334625

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a199ed-8d5d-7637-b8fe-97fd1b5b38e6 is already settled by stl_EUR_2989306 line 66
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
LineKindReferenceGrossFeeStatus
41capture01a199ec-3e61-7dcf-baef-6e7fb86b62e2€35.00€0.52fee difference
67capture01a199ed-8d88-7537-a01d-fc953a1f12e1€49.00€0.67duplicate line
1capture01a199e1-b411-717e-90a2-7e30b2bb7543€35.00€0.50matched
2capture01a199e4-74e6-7b86-8fe2-6890b828f61f€9.00€0.19matched
3capture01a199e4-c21a-7763-be2d-b6843371fc5b€24.00€0.37matched
4capture01a199e9-d308-7737-9037-6856c03e860e€15.00€0.26matched
5capture01a199e9-ef7e-7ec8-a300-d4dbf1f8b8fe€9.00€0.19matched
6capture01a199e9-f573-7833-a62e-f68e95dadbf7€9.00€0.19matched
7capture01a199ea-0278-77dc-8141-461513098668€49.00€0.67matched
8capture01a199ea-0410-7f25-a940-dcfcac7b79f3€15.00€0.26matched
9capture01a199ea-1657-7a0f-93fe-ef40a74d0b1d€35.00€0.50matched
10capture01a199ea-42e7-7f43-a391-1f66454f1ae9€24.00€0.37matched
11capture01a199ea-5848-75b4-948d-edb32a219e0a€9.00€0.19matched
12capture01a199ea-5a04-7517-8c91-f983d75e9aac€24.00€0.37matched
13capture01a199ea-7db1-79d9-b5bf-4f341e223c81€49.00€0.67matched
14capture01a199ea-716c-73d0-98c5-df0ed9225b0c€15.00€0.26matched
15capture01a199ea-9316-7a28-94d6-f24de5bfdff9€49.00€0.67matched
16capture01a199ea-d375-79c9-b4e8-e04d0ab47a78€35.00€0.50matched
17capture01a199ea-d5c1-75f6-8628-eb8395341c31€9.00€0.19matched
18capture01a199eb-18a1-794c-89ad-0873fddc3aba€24.00€0.37matched
19capture01a199eb-2ae2-7672-a496-0f3ce78d6685€35.00€0.50matched
20capture01a199eb-31b0-799e-85fb-b60325e2b230€49.00€0.67matched
21capture01a199eb-4795-72f3-bdfb-2c6095f344a3€9.00€0.19matched
22capture01a199eb-4ca1-7cd2-bac1-70b2671273fe€15.00€0.26matched
23capture01a199eb-4d38-7101-b3db-169cab8d4348€15.00€0.26matched
24capture01a199eb-55d0-7cb4-91c7-dc69ac787933€24.00€0.37matched
25capture01a199eb-5ffb-70a8-9922-0a24b13d8f86€49.00€0.67matched
26capture01a199eb-665e-78b6-b615-287f01603d58€35.00€0.50matched
27capture01a199eb-776c-773d-920d-32b1ee68f847€35.00€0.50matched
28capture01a199eb-99b8-7f02-b42c-0f2de5eaf90e€9.00€0.19matched
29capture01a199eb-c546-78ed-a8c8-2fa51687386a€49.00€0.67matched
30capture01a199eb-c75a-73ab-9b5c-cd73945ef0da€15.00€0.26matched
31capture01a199eb-ced0-730c-b716-b9d2b9ce0a67€49.00€0.67matched
32capture01a199eb-cf89-7d57-8d5d-a69c61ae457c€15.00€0.26matched
33capture01a199eb-e8dc-7f9a-b34a-14ae9fbfb09c€35.00€0.50matched
34capture01a199ec-142f-7c52-9c0f-0db6285cde3c€15.00€0.26matched
35refund01a199ec-16b8-7b05-9b4f-9b3f0ed1355a-€6.00€0.00matched
36capture01a199ec-1d06-7bf8-9512-1e5d5dab1077€35.00€0.50matched
37capture01a199ec-1fff-7cdb-a88b-d2dca111164e€24.00€0.37matched
38capture01a199ec-24db-7085-a2c7-4aa8085f7ca6€15.00€0.26matched
39capture01a199ec-349f-74b2-816c-fb87f0311618€35.00€0.50matched
40capture01a199ec-3e69-7f6c-9347-816550ff0235€24.00€0.37matched
42capture01a199ec-4211-7854-9074-d6f6223ff18a€35.00€0.50matched
43capture01a199ec-4304-71ee-8a9e-907914babf40€15.00€0.26matched
44capture01a199ec-57d2-7cdf-8dd4-c2e0ec4fcc1a€35.00€0.50matched
45capture01a199ec-57e3-731b-a644-b9514e41717d€24.00€0.37matched
46capture01a199ec-87b6-7c12-9f98-8c30b3b237f5€9.00€0.19matched
47capture01a199ec-898a-787c-ac77-af831dc7ae42€35.00€0.50matched
48capture01a199ec-a132-700a-b591-a3e4bbfa1313€9.00€0.19matched
49refund01a199ec-a528-7348-af85-d3117bd2f814-€6.00€0.00matched
50capture01a199ec-acab-7896-9a9b-942b600264f6€35.00€0.50matched
51refund01a199ec-a88c-724f-8e14-338af116136e-€26.00€0.00matched
52capture01a199ec-c0ba-7159-ac8c-48781d0cb4b1€9.00€0.19matched
53capture01a199ec-cc90-72f0-8e92-a4091cdc29c9€15.00€0.26matched
54capture01a199ec-da53-7c59-97bd-4fb2fe8c6cd7€49.00€0.67matched
55capture01a199ec-f7cb-7bf1-94d5-5c1afeec0168€24.00€0.37matched
56capture01a199ec-fa59-7796-b228-9ba994dc98e3€49.00€0.67matched
57capture01a199ed-1bb7-7bee-a712-f1c74127cb3e€15.00€0.26matched
58capture01a199ed-1c56-796d-ba06-e24f07f47651€9.00€0.19matched
59capture01a199ed-2253-7c5c-a11e-594e15e346ad€24.00€0.37matched
60capture01a199ed-2d36-7d4c-b5a3-e97a4531a8a2€35.00€0.50matched
61capture01a199ed-47b1-7b93-9f27-6b41ac3c1d3d€9.00€0.19matched
62capture01a199ed-4e89-7a03-aeb8-d06f2e788c57€35.00€0.50matched
63capture01a199ed-5830-7827-b8dd-a166fbf88542€35.00€0.50matched
64capture01a199ed-6a4d-72a7-a36c-a51dc78fafee€35.00€0.50matched
65capture01a199ed-799a-730a-ac92-b14911eb7ee6€35.00€0.50matched
66capture01a199ed-8d88-7537-a01d-fc953a1f12e1€49.00€0.67matched
68capture01a199ed-b31f-7b1d-8a2d-aac10dc89a5a€35.00€0.50matched
69capture01a199ed-d124-7c6f-8ddc-2fb43526a166€49.00€0.67matched
70capture01a199ed-d426-73db-a0ab-a50a6cba499e€35.00€0.50matched
71capture01a199ed-ebc0-72af-a7a8-3f5ff6961b2e€15.00€0.26matched
72capture01a199ee-0167-7e48-84e8-f0b311410d0c€35.00€0.50matched
73capture01a199ee-32d1-7b7a-88e8-739c7dcb46dc€35.00€0.50matched
74capture01a199ee-7737-79a4-8d45-cd62501e8a9d€35.00€0.50matched
75capture01a199ee-7982-7d14-82d0-66f3fbf08a8e€15.00€0.26matched
76capture01a199ee-8ef9-79cd-b287-fc7f01aa4c24€24.00€0.37matched
77capture01a199ee-92f9-785c-b95c-abcf88183899€24.00€0.37matched
78capture01a199ee-bd63-7c10-9736-92c54238205f€49.00€0.67matched
79refund01a199ee-e09b-7bef-879f-98f9d467fb59-€5.00€0.00matched
80capture01a199ee-fba8-7c1a-8bcc-65bc2fca1d3d€9.00€0.19matched
81capture01a199ef-18fb-7d9a-bc52-e51d2da92fdd€35.00€0.50matched
82capture01a199ef-c68c-7cf0-b119-57644d91687b€35.00€0.50matched
83capture01a199ef-c21f-74c0-83cd-25c4547c7ec0€24.00€0.37matched
84capture01a199ef-d9fd-7985-b060-18c447cc3a66€35.00€0.50matched
85capture01a199ef-e187-7ecc-8891-8d18b3f4e840€9.00€0.19matched
86capture01a199f0-09ba-7f00-890d-8bf83fcf7e98€15.00€0.26matched
87capture01a199f0-21a7-7bf0-acfc-c5a7a041f431€49.00€0.67matched
88capture01a199f0-2636-7c12-8969-b849bc05ec91€49.00€0.67matched
89capture01a199f0-31a6-785b-a84f-54c18596a8af€35.00€0.50matched
90capture01a199f0-3f5f-79c4-9478-726ace3d8ad7€24.00€0.37matched
91capture01a199f0-6e01-712f-9f0b-2c39e6f65836€15.00€0.26matched
92capture01a199f0-75ee-7168-92b8-ba762ed3bad2€35.00€0.50matched
93capture01a199f0-70a8-7e02-8426-b999dc8df7a9€35.00€0.50matched
94capture01a199f0-8874-72ce-b525-e8c23ff621da€9.00€0.19matched
95capture01a199f0-8f3d-7ec9-aed6-e09d1b1dda67€35.00€0.50matched
96capture01a199f0-a019-7e43-acd1-5b31bbf6183e€9.00€0.19matched
97capture01a199f0-a58e-7166-a77a-aa4c34ace358€49.00€0.67matched
98capture01a199f0-b0a7-746a-9244-9e604bf3d46f€15.00€0.26matched
99capture01a199f0-b9e9-7519-a1c8-ccc4ff9c8216€35.00€0.50matched
100capture01a199f0-dedd-7f40-8b10-1ae51e179992€24.00€0.37matched
101capture01a199f0-fe11-78a4-b45b-8aacbeb08bdd€49.00€0.67matched
102capture01a199f1-6286-7169-a2ce-8e21a2962959€35.00€0.50matched
103capture01a199f1-73da-7688-9cb5-5e184536bc86€9.00€0.19matched
104capture01a199f1-7e50-70b5-bb55-3a586aa6e042€35.00€0.50matched
105capture01a199f1-85aa-7692-92d3-3ba139639f8e€49.00€0.67matched
106capture01a199f1-ab96-7e87-ba55-c0fde0209101€15.00€0.26matched
107capture01a199f1-c960-71b2-952f-cc030d6bea70€24.00€0.37matched
108capture01a199f1-d1e9-7739-abd1-97e76a307b5a€24.00€0.37matched
109capture01a199f1-d40a-7eaf-823f-1539cbd9cc75€9.00€0.19matched
110capture01a199f1-d730-74aa-8510-b77a70b54b4e€9.00€0.19matched
111capture01a199f1-e134-714d-a4f4-fd987592f77f€9.00€0.19matched
112refund01a199f2-2e77-704e-8044-7153e9091ad0-€2.00€0.00matched
113refund01a199f2-403f-7114-ab7d-06e4ac4c3200-€3.00€0.00matched
114capture01a199f2-40b5-79bd-866b-ad13ab97553b€35.00€0.50matched
115capture01a199f2-44fe-74ea-9ece-cbb9fc979d23€35.00€0.50matched
116capture01a199f2-4df7-760e-a73f-afd87c31dfe5€35.00€0.50matched
117capture01a199f2-832c-7764-9795-043819dc3032€24.00€0.37matched
118capture01a199f2-9cf0-7072-a187-26a435fd85df€15.00€0.26matched
119capture01a199f2-bdf2-7db0-a6fa-1b960768e0cb€49.00€0.67matched
120capture01a199f2-c44f-776e-8e69-fe46832e05b0€49.00€0.67matched
121refund01a199f2-f61c-791a-97a0-912c06d14c29-€26.00€0.00matched