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, 19:20

Gross

€2,925.00

PSP fee

€48.75

Net to the bank

€2,876.25

Settlement journal

#384576

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a804-9168-71ed-b16f-6a5aab0aedcf is already settled by stl_EUR_2989700 line 69
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
LineKindReferenceGrossFeeStatus
31capture01a1a802-cc15-7ba9-8b65-2b946e388df5€15.00€0.28fee difference
70capture01a1a804-918e-70d7-91c8-85f12d410d9d€9.00€0.19duplicate line
110capture01a1a807-c8cf-792b-8749-a23af1ff65d8€35.00€0.54fee difference
1capture01a1a7ff-b62d-7053-8573-002a3684476d€35.00€0.50matched
2capture01a1a7ff-cb4f-7b8e-9428-770e9da5e75b€24.00€0.37matched
3capture01a1a800-7f04-7ef2-98e8-245b72ca47eb€9.00€0.19matched
4capture01a1a801-00b5-7205-82ed-81e75220de6c€15.00€0.26matched
5refund01a1a801-30c5-73a1-af30-8bb1cb38781b-€20.00€0.00matched
6capture01a1a801-4426-71f3-b963-b7966dd3c146€24.00€0.37matched
7capture01a1a801-6355-7028-a9a6-2d6e80cddf97€24.00€0.37matched
8capture01a1a801-6bed-7d0a-b87c-45190397483e€15.00€0.26matched
9capture01a1a801-736a-7c6d-b7c4-9987a39f3960€24.00€0.37matched
10capture01a1a801-9886-7440-b854-8a996fe00382€24.00€0.37matched
11capture01a1a801-a085-7826-ad47-c86ff864c797€49.00€0.67matched
12capture01a1a801-a160-78d0-ab76-c74320ff7956€9.00€0.19matched
13capture01a1a801-a4ab-7fed-afa1-c9fea8e58191€9.00€0.19matched
14capture01a1a801-b26f-76a0-9c96-3dd6a516be1d€49.00€0.67matched
15capture01a1a801-dbc6-724c-b86d-26c2e79257b5€24.00€0.37matched
16refund01a1a801-e0b0-71ac-87df-c5d84d2c1c67-€8.00€0.00matched
17capture01a1a801-ff21-7489-9d96-b7ef50eb30aa€15.00€0.26matched
18capture01a1a802-0fbb-7cca-b423-a0d5e0e5a2df€24.00€0.37matched
19capture01a1a802-244d-790b-8cc8-4c3380d0a6b2€35.00€0.50matched
20capture01a1a802-2e5d-7f22-967c-552e64fea1c8€9.00€0.19matched
21refund01a1a802-548c-7013-ba28-faba4aba97ce-€14.00€0.00matched
22capture01a1a802-64a3-7a2c-8ac8-d199da44e799€24.00€0.37matched
23capture01a1a802-75d4-7111-8662-64e7a58d7991€35.00€0.50matched
24capture01a1a802-7e67-732f-bc7a-8bd25f5b10d7€24.00€0.37matched
25capture01a1a802-7fcb-79b5-942b-61ebc4125b0a€24.00€0.37matched
26capture01a1a802-98a0-74b4-9a3e-2ce8c12c2c17€9.00€0.19matched
27capture01a1a802-9a82-70b2-b0b3-9f485471f7c1€49.00€0.67matched
28capture01a1a802-9f9c-76c0-853f-5891f52db712€49.00€0.67matched
29capture01a1a802-b751-7837-80dc-0c86d77e01fc€15.00€0.26matched
30capture01a1a802-b91e-7fa6-ab9c-08d9263c2efc€15.00€0.26matched
32capture01a1a802-cc57-724c-a20f-c7452f89ada3€35.00€0.50matched
33capture01a1a802-e0b1-7045-a341-8c9833722bba€24.00€0.37matched
34capture01a1a802-ed9d-7063-891b-79a9b490c934€49.00€0.67matched
35capture01a1a802-f565-78bb-8167-4ed7edf4812b€9.00€0.19matched
36capture01a1a802-f937-7a9d-83fe-fefadbdd1ae5€9.00€0.19matched
37capture01a1a803-0387-72ba-8718-60d2de9e1916€35.00€0.50matched
38capture01a1a803-1e90-77cf-9cc4-7d1ed16bae93€9.00€0.19matched
39capture01a1a803-22ed-7a9f-9d27-98f7287938ee€35.00€0.50matched
40capture01a1a803-2a1f-727d-984b-de29cb4ca178€35.00€0.50matched
41capture01a1a803-2f77-700d-a205-74c5947fe181€24.00€0.37matched
42capture01a1a803-2fa3-7d5a-b25e-720335933963€49.00€0.67matched
43capture01a1a803-5698-7542-abc1-d06afa8e746b€9.00€0.19matched
44capture01a1a803-5bde-7f39-9385-918fa8f65d56€35.00€0.50matched
45refund01a1a803-6aad-743f-a9eb-4e8a1178e542-€32.00€0.00matched
46capture01a1a803-886b-71fe-91ec-7d9c7c7d1e71€24.00€0.37matched
47capture01a1a803-897e-7f9d-a4f0-3b99908ed0ac€35.00€0.50matched
48capture01a1a803-9210-7ff7-b399-928167ac5a22€49.00€0.67matched
49capture01a1a803-9825-7851-b979-b779c0c0c152€24.00€0.37matched
50refund01a1a803-ade9-7e8b-8c9e-87c816608f94-€3.00€0.00matched
51capture01a1a803-af18-78e3-bf76-9652fe6baf34€49.00€0.67matched
52capture01a1a803-b00c-7912-b7e7-7321932f0059€24.00€0.37matched
53capture01a1a803-c5ca-7730-a443-11fad39b96bd€49.00€0.67matched
54capture01a1a803-d05e-70ba-9bb8-b4878a8f283a€15.00€0.26matched
55capture01a1a803-d530-7670-94f8-96477a4bda99€9.00€0.19matched
56capture01a1a803-d93c-7032-8fd3-472f9415a3d6€24.00€0.37matched
57capture01a1a803-de01-779b-9025-5997cc1dd6b4€9.00€0.19matched
58capture01a1a803-e3d1-7396-b29b-9f2eb25f4b0a€9.00€0.19matched
59capture01a1a803-eb97-7e8c-b4e6-83f422516572€24.00€0.37matched
60capture01a1a804-0439-7417-84fc-809260ff7723€49.00€0.67matched
61refund01a1a804-043f-796c-8519-0d6c993d22e3-€40.00€0.00matched
62capture01a1a804-0ff7-7583-8d07-2efaa5e822f6€15.00€0.26matched
63capture01a1a804-2609-7eaf-8ace-8faf8c162d0d€9.00€0.19matched
64capture01a1a804-2ba9-7e93-9fdb-26ca10028f37€24.00€0.37matched
65capture01a1a804-4c19-7f93-9899-756c8bbd930d€15.00€0.26matched
66capture01a1a804-6903-70c2-b003-54e38e1cec46€9.00€0.19matched
67capture01a1a804-7fd5-7803-9195-3c05c0186074€9.00€0.19matched
68capture01a1a804-87b2-759c-ab3b-71d8df45c925€9.00€0.19matched
69capture01a1a804-918e-70d7-91c8-85f12d410d9d€9.00€0.19matched
71refund01a1a804-9385-7a7f-9e51-21cd4b5ab43e-€20.00€0.00matched
72capture01a1a804-9705-77ec-b5f3-a01b3a8a3e58€9.00€0.19matched
73capture01a1a804-a639-7783-a75d-cca0d71858d8€9.00€0.19matched
74capture01a1a804-a9cc-7e60-9e4e-203f8cdd9bff€24.00€0.37matched
75capture01a1a804-bc79-7df5-96c8-702ef3ce8d99€35.00€0.50matched
76capture01a1a804-c9be-7641-9e5d-821ac5223737€15.00€0.26matched
77capture01a1a805-1a60-7927-bc5f-6c72282457c5€9.00€0.19matched
78capture01a1a805-4de6-700f-84de-222f28204255€35.00€0.50matched
79capture01a1a805-5f98-7783-ba03-a48e3d7e37ec€15.00€0.26matched
80capture01a1a805-623a-752a-9f94-14546d0b598d€15.00€0.26matched
81capture01a1a805-76d5-7e67-8d86-4c12edc9e254€15.00€0.26matched
82capture01a1a805-7ae7-76d6-b553-49735147b57f€15.00€0.26matched
83capture01a1a805-7b01-7fdd-9b9d-b3419ed91d43€15.00€0.26matched
84capture01a1a805-812d-7dc7-9174-e9400c88534c€24.00€0.37matched
85capture01a1a805-a098-7862-bce4-d7ea3b587f9c€15.00€0.26matched
86refund01a1a805-a8f8-71c6-a402-3990c889de39-€18.00€0.00matched
87capture01a1a805-afee-7518-9f5e-b0be95e9726e€24.00€0.37matched
88capture01a1a805-cc56-7903-bd18-19ad89748534€24.00€0.37matched
89capture01a1a805-ccdd-7924-b29f-88a324521b96€35.00€0.50matched
90capture01a1a805-db7d-79ef-a041-1993d764c162€35.00€0.50matched
91capture01a1a806-4835-7a54-9714-484ee2f26060€24.00€0.37matched
92capture01a1a806-82c9-7a99-b3a0-af6feeab59b8€15.00€0.26matched
93capture01a1a806-91f4-7448-aefc-84c49559e0fa€15.00€0.26matched
94capture01a1a806-b946-788c-bde7-b57f467a9c4c€35.00€0.50matched
95capture01a1a806-c08c-71ec-82ef-800a39722f49€24.00€0.37matched
96capture01a1a806-c4dd-7263-8926-85aa142e62f3€24.00€0.37matched
97capture01a1a806-f611-76be-876f-792d7e6f2be4€9.00€0.19matched
98capture01a1a806-f96e-76fe-aaab-c27f19dd8e0a€15.00€0.26matched
99capture01a1a807-026a-7935-bc27-25dfa85e6138€35.00€0.50matched
100capture01a1a807-05d7-7f12-b566-19b67dda7b4a€49.00€0.67matched
101capture01a1a807-1c67-72f1-a013-1efe4650a06a€9.00€0.19matched
102refund01a1a807-1f15-7cf1-9214-85be7d7dd881-€5.00€0.00matched
103refund01a1a807-4dbf-7a1f-9b4a-93f09dd15b59-€14.00€0.00matched
104capture01a1a807-7ae1-7339-a1d5-244649845529€9.00€0.19matched
105capture01a1a807-7f98-7dcf-8398-07999b249fad€35.00€0.50matched
106capture01a1a807-9ae4-7c91-bb4a-3809d4d1b4fe€49.00€0.67matched
107capture01a1a807-a47a-76bc-8926-238525ad6a22€35.00€0.50matched
108capture01a1a807-b8ef-7a61-ac59-04ac50eda696€15.00€0.26matched
109capture01a1a807-c578-7e6b-8fde-481f133850b8€35.00€0.50matched
111capture01a1a807-cc28-7776-8815-a0c6fbc594a8€49.00€0.67matched
112capture01a1a807-cb1e-7448-977d-8a9774704546€49.00€0.67matched
113capture01a1a807-f60c-7c6d-9d42-e95216248322€35.00€0.50matched
114capture01a1a807-fe7f-7c0b-89cf-7e4687a6991d€9.00€0.19matched
115refund01a1a808-0990-714b-9a68-353d8d19a471-€33.00€0.00matched
116capture01a1a808-1fa2-7841-88b4-481bf2bb9cd5€49.00€0.67matched
117capture01a1a808-2edd-702c-b604-e3010e07d3cc€49.00€0.67matched
118refund01a1a808-36fc-7265-a362-9f2ee8445b9f-€17.00€0.00matched
119capture01a1a808-43ed-715b-9357-0e4839e299ec€49.00€0.67matched
120capture01a1a808-44eb-7e16-9869-f82c261d26cf€49.00€0.67matched
121capture01a1a808-51eb-7c62-b911-7e44d5473a46€15.00€0.26matched
122capture01a1a808-755b-7508-b7f5-2312a9116430€24.00€0.37matched
123capture01a1a808-8a57-710c-9398-dc65f87d1bf7€24.00€0.37matched
124capture01a1a808-cb7f-7e9a-a8c6-f61062c148b3€9.00€0.19matched
125capture01a1a808-da44-7c2c-b9df-c19ac6c184d8€49.00€0.67matched
126capture01a1a808-da9b-710a-9032-f456d81bed09€15.00€0.26matched
127capture01a1a808-f3a3-7749-b7e1-bc879b34a596€15.00€0.26matched
128capture01a1a809-0ff9-7614-b0af-57df53a22db9€9.00€0.19matched
129refund01a1a809-1b18-7145-86b5-09f74f9a9842-€7.00€0.00matched
130capture01a1a809-1e7c-7c2d-964b-37898fdb2c09€9.00€0.19matched
131capture01a1a809-3d62-7256-aab9-a392c0725772€15.00€0.26matched
132capture01a1a809-5b49-768a-8af8-cdce0c33d500€15.00€0.26matched
133capture01a1a809-7aca-7b6d-a576-f9101af2f1c2€15.00€0.26matched
134capture01a1a809-8559-78e5-8cf0-6df855c04968€9.00€0.19matched
135capture01a1a809-95ec-71f1-b882-6c4b5ee3da3b€15.00€0.26matched
136refund01a1a809-9702-724c-8bcd-711ab98c7ab6-€15.00€0.00matched
137capture01a1a809-a68b-7439-b604-05fa89b3200c€9.00€0.19matched
138capture01a1a809-b4c6-751c-9b8b-68cb263478c7€9.00€0.19matched
139capture01a1a809-d23a-7e43-9fd2-1e72b15542bf€35.00€0.50matched
140capture01a1a809-ddc9-7e75-97dc-f594f7e5df56€9.00€0.19matched
141capture01a1a809-ee8f-75f6-8035-98ab8596bc49€35.00€0.50matched
142capture01a1a809-f199-7e76-accc-4138e8376f15€35.00€0.50matched
143capture01a1a80a-1234-7d30-aece-00fb78d2bc45€35.00€0.50matched
144capture01a1a80a-1d99-7063-84e9-bce125439b55€35.00€0.50matched
145capture01a1a80a-248a-73ec-939f-46d60eb852ac€24.00€0.37matched