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:50

Gross

€2,827.00

PSP fee

€44.05

Net to the bank

€2,782.95

Settlement journal

#371221

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a444-a162-7d13-b7b4-851ed295d641 is already settled by stl_EUR_2989595 line 69
LineKindReferenceGrossFeeStatus
70capture01a1a444-a179-7307-be85-8c784e96ac8f€49.00€0.67duplicate line
1capture01a1a43e-0e2e-739d-81f6-5e3b5cd0cd8e€49.00€0.67matched
2capture01a1a43f-b4fb-7963-9815-4e3b4f01c559€15.00€0.26matched
3capture01a1a43f-c3aa-7d55-addd-cc832e7821dd€15.00€0.26matched
4capture01a1a43f-e5c4-79db-8a46-dbab37c6afae€9.00€0.19matched
5capture01a1a43f-f5df-7792-8041-020afeba3512€24.00€0.37matched
6capture01a1a43f-f64c-7fa5-9c44-53f2fc99e3d7€35.00€0.50matched
7capture01a1a440-03a7-771d-9b95-aa88799dc2bd€9.00€0.19matched
8capture01a1a440-1224-74e0-8907-2bd6d3aece3d€15.00€0.26matched
9capture01a1a440-2adc-79c4-a475-c4f43bb10b2a€15.00€0.26matched
10capture01a1a440-3d1b-75d7-bfd9-b138235a5139€49.00€0.67matched
11capture01a1a440-5db6-7015-a2c8-a4906202c019€9.00€0.19matched
12capture01a1a440-77cd-733e-869e-1d8bae8d9f0f€49.00€0.67matched
13capture01a1a440-9227-7de6-9f90-b3344b0fd277€24.00€0.37matched
14capture01a1a440-a256-7cf8-aede-2a2d21b13eca€15.00€0.26matched
15capture01a1a440-a390-7394-b248-e0ab91ea122a€49.00€0.67matched
16capture01a1a440-bbde-7b65-aff7-6ab67bc97b68€15.00€0.26matched
17capture01a1a440-d86e-7183-b4c0-f9311557e80b€15.00€0.26matched
18capture01a1a440-e7cb-7d9a-8e50-b73c704ffd31€15.00€0.26matched
19capture01a1a440-ef16-70cb-9260-5a576760b4e8€35.00€0.50matched
20capture01a1a441-18d1-7104-967f-122e184b975d€35.00€0.50matched
21capture01a1a441-2ced-71c6-acc9-7af783feef1c€15.00€0.26matched
22capture01a1a441-3514-7eef-88e5-73b0a1fe7a0c€24.00€0.37matched
23capture01a1a441-4157-78b6-b4d6-c8b456296765€24.00€0.37matched
24capture01a1a441-52dc-77ff-a0cc-77d16e636699€35.00€0.50matched
25capture01a1a441-7929-7e49-b9af-bcd096ec0a73€9.00€0.19matched
26capture01a1a441-8268-7eb4-86e7-3dcf1c0d5031€15.00€0.26matched
27capture01a1a441-92b0-72e8-9f37-1521a8602060€9.00€0.19matched
28capture01a1a441-9aef-7f14-b457-7b0e931aecb8€24.00€0.37matched
29capture01a1a441-b8b1-7ded-a005-4103eca5a10a€24.00€0.37matched
30capture01a1a441-c689-7825-bae3-7d3246e1381e€49.00€0.67matched
31capture01a1a441-d965-7a6a-b6ff-34420861a986€9.00€0.19matched
32capture01a1a442-3333-763b-8e51-7619ec305789€35.00€0.50matched
33capture01a1a442-3cc5-74d6-be06-349630d57477€24.00€0.37matched
34capture01a1a442-42d7-7fdf-b467-6bf4f057fb6f€24.00€0.37matched
35capture01a1a442-5689-7ca8-9751-7ea8499ce4a9€15.00€0.26matched
36capture01a1a442-552b-763f-906d-6d2941147adb€49.00€0.67matched
37capture01a1a442-665d-780b-a8b3-69a0ccb08656€9.00€0.19matched
38capture01a1a442-8b7d-758f-825a-75eb46535ca6€15.00€0.26matched
39capture01a1a442-a481-7543-b1c8-9ab94bc8807c€15.00€0.26matched
40capture01a1a442-a9a1-74a4-b028-0a30cf0936bb€9.00€0.19matched
41capture01a1a442-b620-77cc-9f0f-afd0248e2ac0€24.00€0.37matched
42capture01a1a442-c4e4-7a19-8724-05a8ee4a4255€9.00€0.19matched
43capture01a1a442-ce55-7ca5-ab92-e273b7b5fb7b€35.00€0.50matched
44capture01a1a442-d892-74db-8048-ec9e7051cfe9€9.00€0.19matched
45capture01a1a442-dac8-7460-8b20-95e86f831f4e€15.00€0.26matched
46capture01a1a442-db0f-7943-bd7d-452c5f701df6€9.00€0.19matched
47capture01a1a442-edc5-7316-9c9f-03a575ce3459€15.00€0.26matched
48capture01a1a442-f70a-777a-a471-26fd14f56c31€15.00€0.26matched
49refund01a1a443-0b57-748f-a906-414b41c4bd5f-€14.00€0.00matched
50capture01a1a443-27ab-7bdd-9afd-37a0629cc7a5€35.00€0.50matched
51capture01a1a443-3b14-7502-b6c8-9ed9ca04a579€49.00€0.67matched
52capture01a1a443-8dfc-733d-be20-e84a6746560a€35.00€0.50matched
53capture01a1a443-a04f-7240-aebd-023908ec7b0b€15.00€0.26matched
54capture01a1a443-a2e2-764f-b0b8-ba4612453e5b€35.00€0.50matched
55capture01a1a443-da07-7f75-9e02-57e1642d246d€49.00€0.67matched
56capture01a1a443-db14-7625-97c4-82e941a7effa€24.00€0.37matched
57capture01a1a443-f80d-770b-95ca-c10c6b98c3b4€49.00€0.67matched
58capture01a1a443-fc69-734d-8e56-bd6045a3a2d1€9.00€0.19matched
59capture01a1a444-0650-727c-a079-a405b42c93f6€9.00€0.19matched
60capture01a1a444-2248-74c2-8dee-e8f1be901a95€9.00€0.19matched
61capture01a1a444-2258-7168-92b1-87b8488c21a1€15.00€0.26matched
62capture01a1a444-2a04-72c3-b79c-fe0ceadccfa3€15.00€0.26matched
63capture01a1a444-42e5-7845-acc9-34f7b0448b40€24.00€0.37matched
64refund01a1a444-5cc7-77f2-b309-061db95c6d2e-€6.00€0.00matched
65capture01a1a444-7757-7fe3-b311-52bd1bf7bb6a€49.00€0.67matched
66capture01a1a444-8d12-7957-9eed-616709ce7a83€9.00€0.19matched
67capture01a1a444-8e4b-7aa1-8516-40a5acd30a1f€49.00€0.67matched
68capture01a1a444-9a7b-7baf-a07d-07242efefe2f€24.00€0.37matched
69capture01a1a444-a179-7307-be85-8c784e96ac8f€49.00€0.67matched
71capture01a1a444-a9c0-7e1a-9522-34aa3476d698€35.00€0.50matched
72capture01a1a444-b93e-702c-ab96-ab4801eed10b€49.00€0.67matched
73capture01a1a444-d80f-78f8-b0d5-8ed1a9d91fdb€35.00€0.50matched
74capture01a1a444-d8a7-7ef4-bb47-a2fef2cd4d43€15.00€0.26matched
75capture01a1a445-1207-7947-bb4f-859c15aeacdf€9.00€0.19matched
76refund01a1a445-1311-74b1-bb4c-652588a864b9-€26.00€0.00matched
77capture01a1a445-148e-79dd-b66b-95dcc2cdf93a€49.00€0.67matched
78capture01a1a445-1a87-7e01-a0ca-16c447ccb3f5€35.00€0.50matched
79capture01a1a445-2c72-7972-a323-a3e95181915c€35.00€0.50matched
80capture01a1a445-345b-7d3f-89e0-e7c1b1e8d778€24.00€0.37matched
81capture01a1a445-4453-7eb7-80ea-b90f251f6832€9.00€0.19matched
82refund01a1a445-45f6-76c5-aeb3-c23bc2f4ed8b-€2.00€0.00matched
83capture01a1a445-5667-7185-adb5-d3b14a81b163€35.00€0.50matched
84capture01a1a445-8afd-7fb7-b462-7db2b0aaa347€24.00€0.37matched
85capture01a1a445-c081-7cdd-8ed9-12d88df141f9€9.00€0.19matched
86capture01a1a445-ef73-7cc9-92ff-47a87446ae97€15.00€0.26matched
87capture01a1a445-f881-79c1-bd32-d445b3539494€35.00€0.50matched
88capture01a1a445-fd9a-7d8f-a458-cad8676f175c€24.00€0.37matched
89capture01a1a445-fdaa-765e-893b-c2505a98de1d€15.00€0.26matched
90capture01a1a446-0ba6-71a6-a434-3a639ab64bce€9.00€0.19matched
91capture01a1a446-2055-7bdf-b602-4de774e676ed€9.00€0.19matched
92capture01a1a446-5001-7692-8857-cd0ec6c20a9c€35.00€0.50matched
93capture01a1a446-60a2-71ce-9c5e-efcbc46954ec€9.00€0.19matched
94capture01a1a446-6718-7e64-b616-d8db97017cdf€9.00€0.19matched
95capture01a1a446-7296-7f96-9350-b797050446ce€49.00€0.67matched
96capture01a1a446-8675-7d21-9208-3efe54616c5f€49.00€0.67matched
97capture01a1a446-957b-7a92-a246-36450cf6e23b€15.00€0.26matched
98capture01a1a446-9de9-7170-8767-be91985809c7€24.00€0.37matched
99capture01a1a446-b6a3-7a0d-8305-b3abf00d4b94€35.00€0.50matched
100capture01a1a446-b9a7-7df8-8793-1220212229b4€15.00€0.26matched
101capture01a1a446-c511-799b-a39c-be9f63cc5928€35.00€0.50matched
102capture01a1a446-ca30-7b69-a857-1099bf17a9d5€24.00€0.37matched
103capture01a1a446-e94a-7c42-980e-03eefc53f1db€9.00€0.19matched
104capture01a1a447-025c-7cee-84bf-4317f95c8b6c€35.00€0.50matched
105capture01a1a447-20c8-708e-a9c9-f41839320fc6€49.00€0.67matched
106capture01a1a447-3882-7461-81ac-993149390440€49.00€0.67matched
107capture01a1a447-41ae-7691-b530-e33d6a993ce6€24.00€0.37matched
108capture01a1a447-58d8-7e68-9ffc-e6312938f16a€49.00€0.67matched
109capture01a1a447-732f-77cd-9f9c-59f19f35284e€9.00€0.19matched
110capture01a1a447-a2df-7a35-8dc5-6cfd171a8249€9.00€0.19matched
111capture01a1a447-dc50-75bc-a626-cc99f01d60b5€9.00€0.19matched
112capture01a1a447-e8f0-7537-85d9-520a034d08a6€49.00€0.67matched
113capture01a1a448-1e7e-75d9-956a-46105545a0f6€24.00€0.37matched
114capture01a1a448-429d-7738-bcde-d112d8eba0f5€9.00€0.19matched
115capture01a1a448-494a-7308-9d5e-917349722e84€24.00€0.37matched
116capture01a1a448-66d1-7a27-ab23-4163de111ba1€15.00€0.26matched
117capture01a1a448-7479-7022-b7c0-ccb0788ae12e€9.00€0.19matched
118capture01a1a448-88bb-7047-a5e1-fbfee103d7ed€35.00€0.50matched
119refund01a1a448-9645-70e7-9bf3-50d2870bcdb6-€11.00€0.00matched
120capture01a1a448-c2d7-7e8d-9547-8bcdfbfd944e€35.00€0.50matched
121capture01a1a448-c519-7e26-b281-4cfa289733b0€15.00€0.26matched