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

Gross

€2,608.00

PSP fee

€42.13

Net to the bank

€2,565.87

Settlement journal

#369328

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a3b8-3b98-797a-9b84-27f5d21b9f77 is already settled by stl_EUR_2989580 line 35
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
LineKindReferenceGrossFeeStatus
36capture01a1a3b8-40ac-7eab-b9c7-4fe3266be141€15.00€0.26duplicate line
106capture01a1a3be-88c7-7c3c-8ca1-3ca6cea076d6€9.00€0.23fee difference
1capture01a1a3ad-9371-7160-b9c8-fd3c974354e9€9.00€0.19matched
2capture01a1a3af-e0f9-75b9-ad35-6cc8d61543d7€35.00€0.50matched
3capture01a1a3b0-dbfd-7894-a9fb-7becd56c0606€9.00€0.19matched
4capture01a1a3b4-c361-7fbe-9795-7b3e59afe0c0€9.00€0.19matched
5capture01a1a3b6-61d1-7aa8-8983-4ad23e5346f0€15.00€0.26matched
6refund01a1a3b6-6d75-7f67-bcfe-892237000ff5-€32.00€0.00matched
7capture01a1a3b6-75c6-7d94-a792-7a3e294183c4€9.00€0.19matched
8capture01a1a3b6-89b9-75dc-825d-283758651c70€9.00€0.19matched
9refund01a1a3b6-8bb3-7806-be2a-ec2149a2cd84-€38.00€0.00matched
10capture01a1a3b6-8bbd-734b-8422-72e154b12533€15.00€0.26matched
11capture01a1a3b6-8e02-71f4-826e-ab4911ea6450€9.00€0.19matched
12capture01a1a3b6-90e4-7555-996a-e918ef7b0e28€49.00€0.67matched
13capture01a1a3b6-a781-7beb-951b-9f00e154c0c1€9.00€0.19matched
14capture01a1a3b6-a8d6-79f0-82ea-e4f6431195b9€49.00€0.67matched
15capture01a1a3b6-cdaf-7da5-b2a7-3791263d2edd€35.00€0.50matched
16refund01a1a3b6-e985-70bb-a299-2c3e5d6e63e7-€3.00€0.00matched
17capture01a1a3b6-ff43-722c-b937-123c6c09b2e4€9.00€0.19matched
18capture01a1a3b7-01e4-7c0d-bf17-e09b5d0ff6c2€9.00€0.19matched
19capture01a1a3b7-02e9-7954-8dfa-fd39935c3365€9.00€0.19matched
20capture01a1a3b7-2709-7492-a6f4-0569cc2d8c3a€49.00€0.67matched
21capture01a1a3b7-34a4-7847-a989-e8c5111c7491€9.00€0.19matched
22capture01a1a3b7-8e0c-7aa4-bbf4-6e2f7a2d0e7e€49.00€0.67matched
23capture01a1a3b7-9280-7906-87ab-95584d5e5547€24.00€0.37matched
24capture01a1a3b7-94dd-7361-8d65-c67b7c03dc37€9.00€0.19matched
25capture01a1a3b7-9b50-7e6e-a849-4ae36744f84a€9.00€0.19matched
26capture01a1a3b7-a3e0-7e00-9ce4-a4cdd0933433€35.00€0.50matched
27capture01a1a3b7-ad08-7e43-9a0f-0953b806020d€24.00€0.37matched
28capture01a1a3b7-bdea-7248-a204-7ae1ff2c5053€9.00€0.19matched
29capture01a1a3b7-c80e-7bd8-9401-e50e18efa30a€35.00€0.50matched
30capture01a1a3b7-d056-7861-97db-f2729a23f4a6€15.00€0.26matched
31capture01a1a3b7-e2d1-7651-9146-a87a28b04aca€24.00€0.37matched
32capture01a1a3b7-e379-7ee7-8976-64444026099e€15.00€0.26matched
33capture01a1a3b7-ec5f-7ee4-8a50-35a491163e59€49.00€0.67matched
34capture01a1a3b8-14e4-795b-846f-319d2232a4f5€24.00€0.37matched
35capture01a1a3b8-40ac-7eab-b9c7-4fe3266be141€15.00€0.26matched
37capture01a1a3b8-5a0f-78b3-a30e-fa7945d1a7bf€49.00€0.67matched
38capture01a1a3b8-609d-783b-8c94-c7a2b0b0fd23€9.00€0.19matched
39capture01a1a3b8-670e-7b43-a348-ded568dfb7ab€15.00€0.26matched
40capture01a1a3b8-7ae1-75c7-b12e-7fb11791b7bf€15.00€0.26matched
41capture01a1a3b8-7f67-7fdb-86fa-c38327f9ff65€49.00€0.67matched
42capture01a1a3b8-a268-787a-93fa-04d5c1a76f8f€49.00€0.67matched
43capture01a1a3b8-c22c-7ab7-85f4-d55538039d21€9.00€0.19matched
44capture01a1a3b8-c9b6-7dfe-a981-2897e51591f7€9.00€0.19matched
45capture01a1a3b8-d9ca-7841-b02f-6a44a06b2932€49.00€0.67matched
46refund01a1a3b9-0e36-7341-b9fd-3680d3caeea5-€13.00€0.00matched
47capture01a1a3b9-10fc-78c2-a133-6f74a3576aed€15.00€0.26matched
48capture01a1a3b9-2ee2-7fdb-8d18-83219aafd377€35.00€0.50matched
49refund01a1a3b9-595e-78fb-960a-212a4131a4c8-€17.00€0.00matched
50capture01a1a3b9-5fe6-72b8-bf2a-7f096c5a42bc€24.00€0.37matched
51capture01a1a3b9-92a2-719f-b794-07bc57d1534f€35.00€0.50matched
52capture01a1a3b9-942d-799c-9086-161bcd89d990€15.00€0.26matched
53capture01a1a3b9-95cd-7099-a236-b30903772e3e€15.00€0.26matched
54capture01a1a3b9-ac85-7f48-8786-d0801ecddb06€49.00€0.67matched
55capture01a1a3b9-b1b7-7480-9f1f-f86f74c16e70€35.00€0.50matched
56capture01a1a3b9-b81b-7d4a-9cbb-5d16e8a86725€24.00€0.37matched
57capture01a1a3b9-f41d-7673-aa8b-c02ecd1386e2€49.00€0.67matched
58capture01a1a3b9-fcbd-7d6c-adf7-c694d5935ef2€24.00€0.37matched
59capture01a1a3ba-48ca-7f91-a9cb-b5bfad95d2ab€49.00€0.67matched
60capture01a1a3ba-7e8a-7a62-9902-80c0198f1a1c€9.00€0.19matched
61capture01a1a3ba-c228-755b-be7b-9d5b20a31bdb€35.00€0.50matched
62capture01a1a3ba-daa9-7e4b-9d1d-5e1320c6bada€49.00€0.67matched
63capture01a1a3ba-e769-759a-bea6-1324102ead20€9.00€0.19matched
64refund01a1a3ba-ed94-7dfd-92f8-f9b67c4e0216-€10.00€0.00matched
65capture01a1a3bb-1115-7dbc-92fb-c109f96088c2€35.00€0.50matched
66capture01a1a3bb-16a5-7f7f-88ad-c74cd7f9cbdb€24.00€0.37matched
67capture01a1a3bb-3039-7a3f-8877-21fa5710fd8c€24.00€0.37matched
68capture01a1a3bb-3b99-73e8-ad29-2c51b0e9f005€15.00€0.26matched
69capture01a1a3bb-40e8-7df5-bd87-890d1bb83315€9.00€0.19matched
70capture01a1a3bb-60a9-7c4a-bb94-523d958ca1f1€9.00€0.19matched
71capture01a1a3bb-62b8-7e50-85d1-4e9b8f577618€35.00€0.50matched
72capture01a1a3bb-9d81-7e0f-b8f5-2b20b4db6da6€49.00€0.67matched
73capture01a1a3bb-b09f-73ae-ac68-c3fe00b6a4c8€9.00€0.19matched
74capture01a1a3bb-bd9e-743f-a6bc-c94285dfae11€24.00€0.37matched
75capture01a1a3bb-c0c7-7e44-95ce-47320b5bdc04€49.00€0.67matched
76capture01a1a3bb-e4cc-76f1-becc-041a40a87206€49.00€0.67matched
77capture01a1a3bc-1fec-7d6f-b61a-49171759f68c€9.00€0.19matched
78capture01a1a3bc-2df1-769f-a97c-72ccee5b2a11€35.00€0.50matched
79capture01a1a3bc-35f3-7582-87e6-2fe9e7419af1€24.00€0.37matched
80capture01a1a3bc-3b90-77c8-b923-f3a93a23a4c7€24.00€0.37matched
81capture01a1a3bc-61bf-7884-80f2-b11b466376ef€49.00€0.67matched
82capture01a1a3bc-72b9-7a79-80c3-7673b695f760€15.00€0.26matched
83refund01a1a3bc-8de1-70d0-890b-c27e68320a98-€7.00€0.00matched
84capture01a1a3bc-ab99-70b2-8fe4-b1fda6df688e€24.00€0.37matched
85capture01a1a3bc-c0cc-72d7-914b-4132c8c05ae4€15.00€0.26matched
86capture01a1a3bc-e276-787a-994f-d5b583dae219€35.00€0.50matched
87capture01a1a3bd-0e07-7c30-a166-870900f59bd7€24.00€0.37matched
88capture01a1a3bd-3a23-7b54-8a30-519a98d32784€24.00€0.37matched
89capture01a1a3bd-54a0-7184-bee1-96fcf64f4135€24.00€0.37matched
90capture01a1a3bd-7738-7353-b5b2-ad02dd842a77€15.00€0.26matched
91capture01a1a3bd-9aa0-7846-a0ba-fc4391fd2397€49.00€0.67matched
92capture01a1a3bd-a310-7d31-bb70-fd85adf62b76€15.00€0.26matched
93capture01a1a3bd-a472-711d-bd18-531cf0748d2c€15.00€0.26matched
94refund01a1a3bd-a5a0-7777-9bc7-9fb0e48e256c-€20.00€0.00matched
95capture01a1a3bd-c795-7ee3-9084-e1a400b480e0€9.00€0.19matched
96capture01a1a3bd-d1d4-73ca-8f59-a5294fe4dced€49.00€0.67matched
97capture01a1a3bd-e558-75c8-af85-da4c7510efd3€24.00€0.37matched
98capture01a1a3be-07ac-73cb-aaca-b335442887eb€49.00€0.67matched
99capture01a1a3be-10d5-7ff2-8ab2-1226c4b95177€15.00€0.26matched
100capture01a1a3be-2c0f-778d-8810-48840e2f78ad€15.00€0.26matched
101capture01a1a3be-3f1b-73a0-bbf9-85fb51c3d76f€24.00€0.37matched
102capture01a1a3be-4d8a-7e8d-9b30-8736fe4d4c5b€9.00€0.19matched
103capture01a1a3be-4e6b-70d2-b250-37c28a0997b9€24.00€0.37matched
104capture01a1a3be-5684-713f-abf7-2b73b09269d1€9.00€0.19matched
105capture01a1a3be-8d39-7461-a21c-d56c868ed40d€35.00€0.50matched
107capture01a1a3be-9844-705e-ab9b-53c440b11d87€49.00€0.67matched
108capture01a1a3be-99e4-7d5b-9a73-8ceb161b403d€9.00€0.19matched
109capture01a1a3be-aa1c-746d-ab90-532cf165199d€9.00€0.19matched
110capture01a1a3be-b300-70e3-83c6-8563d5136e4a€24.00€0.37matched
111capture01a1a3be-c964-7634-aefe-ccdce02955b7€15.00€0.26matched
112capture01a1a3be-ef13-7e85-acf9-e9da90cab8b3€49.00€0.67matched
113capture01a1a3bf-1414-70d0-bc4b-34d22e9f5959€9.00€0.19matched
114capture01a1a3bf-1578-7787-8210-1241a5f7106d€15.00€0.26matched
115capture01a1a3bf-2841-7a19-940f-0880598ffe9d€49.00€0.67matched
116capture01a1a3bf-2a8e-79ad-a7ab-2d99399265af€24.00€0.37matched
117capture01a1a3bf-4b95-74ab-aa1a-6d47e7f83ff1€24.00€0.37matched
118capture01a1a3bf-53aa-75f3-93be-66bb83bf5e10€9.00€0.19matched
119capture01a1a3bf-7ac1-7c63-922a-ff66c3fb1460€35.00€0.50matched
120capture01a1a3bf-7dd4-71f5-89e4-caadd494bb12€9.00€0.19matched