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

6 Nov, 09:20

Gross

€2,657.00

PSP fee

€42.54

Net to the bank

€2,614.46

Settlement journal

#413614

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b02c-1474-7c4b-8cf8-c5b6c7db239a is already settled by stl_EUR_2989928 line 48
  • missing linein the books, not in the filecapture:01a1b030-ba32-7602-9722-8fb9e59ed248 is in no file
LineKindReferenceGrossFeeStatus
49capture01a1b02c-2ba2-7d0a-8dd0-aff132a73ee7€15.00€0.26duplicate line
1capture01a1b028-6b29-746a-bcbd-673892a78b11€35.00€0.50matched
2capture01a1b028-5591-7138-b31b-31099c376d47€49.00€0.67matched
3capture01a1b028-b1e5-7a25-b50d-5df9ba6ad619€24.00€0.37matched
4capture01a1b028-bf36-73c6-97df-dad0c2375296€24.00€0.37matched
5capture01a1b028-c3de-7ea9-99fa-77c12ddc51ad€35.00€0.50matched
6capture01a1b028-d661-7057-a3d4-5ed97d94a77f€9.00€0.19matched
7capture01a1b028-f2df-7fea-9aec-715b1bdfede8€9.00€0.19matched
8capture01a1b029-1754-7922-861f-bc00b9b15c14€9.00€0.19matched
9capture01a1b029-2887-7701-a73c-15d54292e40c€24.00€0.37matched
10capture01a1b029-43a2-78f8-9743-30c39fab6a8b€15.00€0.26matched
11capture01a1b029-43c3-7bc7-a275-4081e32ddc85€15.00€0.26matched
12capture01a1b029-4e65-786b-a2a4-4f46bf43e2bd€15.00€0.26matched
13capture01a1b029-5496-7751-a478-e322822ccccc€9.00€0.19matched
14capture01a1b029-792b-713e-a09c-0fa3b9db3335€49.00€0.67matched
15capture01a1b029-7c76-70d3-aeb2-14266be0658c€24.00€0.37matched
16capture01a1b029-8d7d-798a-9d13-4ee034338f21€9.00€0.19matched
17capture01a1b029-a100-7460-ba1f-7f66ab8ed215€49.00€0.67matched
18capture01a1b029-a36e-7a3c-ad69-087be8164327€35.00€0.50matched
19capture01a1b029-a6dc-7007-a5c5-e595d6a299a0€24.00€0.37matched
20capture01a1b029-b067-7772-ba6a-331fb7bbb6b6€24.00€0.37matched
21capture01a1b029-c2da-7c4d-ba17-4a7313ae55d1€9.00€0.19matched
22refund01a1b029-da78-723a-a99f-9ed20da3c5f0-€7.00€0.00matched
23capture01a1b02a-0325-706e-a60c-8b6ffbe47536€24.00€0.37matched
24capture01a1b02a-0462-72eb-b25d-65933297d771€9.00€0.19matched
25capture01a1b02a-1641-786a-b2a2-20d2fc7dedb2€35.00€0.50matched
26capture01a1b02a-43b0-77b7-972b-1b55627d9d62€35.00€0.50matched
27capture01a1b02a-5f78-7071-bb4b-53b1db63b835€24.00€0.37matched
28capture01a1b02a-6608-7281-8d6b-5de16f341bed€49.00€0.67matched
29capture01a1b02a-7250-7198-a659-d9f95f45d0a9€49.00€0.67matched
30capture01a1b02a-9688-70d3-b623-63803317066f€49.00€0.67matched
31refund01a1b02a-b0d9-7ff6-9ca8-570571a0347f-€16.00€0.00matched
32capture01a1b02a-b7d5-7fbc-a471-37b232812485€9.00€0.19matched
33capture01a1b02a-babe-7137-835f-117a611fb0d1€9.00€0.19matched
34capture01a1b02a-de11-77b2-855c-173a43dc5186€35.00€0.50matched
35capture01a1b02a-fe83-7cc2-a76f-60118c3bb05b€49.00€0.67matched
36refund01a1b02b-23dd-7a9e-a902-99ecbecdff8b-€4.00€0.00matched
37capture01a1b02b-46cf-7a7e-80a3-36b8fd57abf2€24.00€0.37matched
38capture01a1b02b-47de-7dbd-a517-862397c82177€49.00€0.67matched
39capture01a1b02b-8203-7d7c-94dc-f6e19593a03e€9.00€0.19matched
40capture01a1b02b-8a59-7175-b702-60c9867eb61f€24.00€0.37matched
41capture01a1b02b-8f39-71d0-bae2-460369ba2a54€24.00€0.37matched
42capture01a1b02b-98b1-79d2-995f-11af3070c881€35.00€0.50matched
43capture01a1b02b-a3ab-797f-9f00-acc0f4965f71€15.00€0.26matched
44capture01a1b02b-b6bb-7673-9f59-5fc0093f1d84€49.00€0.67matched
45refund01a1b02b-fca7-70b0-a652-41876980f7fb-€9.00€0.00matched
46refund01a1b02c-0250-70ee-ae48-f2c7f57433e2-€34.00€0.00matched
47capture01a1b02c-2018-76aa-a401-995a2cb38e25€35.00€0.50matched
48capture01a1b02c-2ba2-7d0a-8dd0-aff132a73ee7€15.00€0.26matched
50capture01a1b02c-4695-772f-bed8-ae5820cda088€35.00€0.50matched
51capture01a1b02c-4b0f-7229-ad85-0a1686975edf€24.00€0.37matched
52capture01a1b02c-5d8e-71e2-a271-4f0925ee6a3d€15.00€0.26matched
53capture01a1b02c-5ea7-7a73-ad4a-5e3087f046b1€15.00€0.26matched
54capture01a1b02c-6090-769c-a808-a095169aa4c6€35.00€0.50matched
55refund01a1b02c-6b73-7912-8b72-4159b812a378-€12.00€0.00matched
56capture01a1b02c-890a-721f-a386-03889a918d56€15.00€0.26matched
57capture01a1b02c-8ad2-79ed-8765-2364aad16052€49.00€0.67matched
58capture01a1b02c-9d32-7d66-aaeb-435b8463a140€49.00€0.67matched
59capture01a1b02c-b4ad-7eff-8a2f-0f59e816ecad€35.00€0.50matched
60refund01a1b02c-bcf9-77ed-94c1-b18a3d9957af-€7.00€0.00matched
61refund01a1b02c-cb29-7541-a42b-c9940d474ed9-€7.00€0.00matched
62capture01a1b02c-d13d-7c3f-a1c2-67602355f6e3€9.00€0.19matched
63capture01a1b02c-ddd1-76ce-a7d2-424f8f575fc8€9.00€0.19matched
64capture01a1b02c-e567-717e-a6b5-d6fa97dce327€9.00€0.19matched
65capture01a1b02c-fb26-730d-8d59-fecfeb4e0bb8€35.00€0.50matched
66capture01a1b02d-0bae-7850-ada9-06e78627fd9c€24.00€0.37matched
67capture01a1b02d-14d3-79f5-957e-bd75eb9e46c2€49.00€0.67matched
68refund01a1b02d-1ad1-7769-a767-d74f8b707bfd-€30.00€0.00matched
69capture01a1b02d-1df1-7305-84c0-302cfc4b6f29€15.00€0.26matched
70capture01a1b02d-2c7d-7efe-b62e-cdc207ff4a35€35.00€0.50matched
71capture01a1b02d-359f-71ec-a0d0-878046871173€9.00€0.19matched
72capture01a1b02d-3793-7807-86af-ade2d4770ee7€15.00€0.26matched
73capture01a1b02d-4022-7252-959a-f26faebed3a4€24.00€0.37matched
74capture01a1b02d-573f-7f39-84a2-c7f2f9e9f054€35.00€0.50matched
75capture01a1b02d-6dff-7f12-966b-c275be2c1faf€24.00€0.37matched
76capture01a1b02d-71c4-75d2-ba18-03411875b84a€49.00€0.67matched
77capture01a1b02d-73eb-7e19-bd9c-f44e60034263€15.00€0.26matched
78capture01a1b02d-86b1-75bd-9c09-a8d85f557814€24.00€0.37matched
79capture01a1b02d-ac74-74b6-816e-a65252e26d21€24.00€0.37matched
80capture01a1b02d-adce-7ea3-a313-2ca10ee0a861€49.00€0.67matched
81capture01a1b02d-c22b-781b-a0c3-d818916c24c5€24.00€0.37matched
82refund01a1b02d-ca52-7e1f-9a2a-3dd992a093d8-€11.00€0.00matched
83capture01a1b02e-681c-75cf-99e5-cd66ac9a9875€24.00€0.37matched
84capture01a1b02e-6cd4-7dd7-b484-80e53f5ec9a4€35.00€0.50matched
85capture01a1b02e-6f08-769f-97e0-2ea8a0266158€9.00€0.19matched
86capture01a1b02e-7ea7-7c71-89c7-03e23ecd5bc0€24.00€0.37matched
87refund01a1b02e-972d-71be-9d6c-2c7e461412e4-€10.00€0.00matched
88capture01a1b02e-a7f2-79aa-8225-777ae3710141€24.00€0.37matched
89capture01a1b02e-d7df-7e28-b773-4b1d267994de€15.00€0.26matched
90capture01a1b02e-e117-7c10-b015-8f36698f5231€35.00€0.50matched
91capture01a1b02e-f019-7ef7-8f39-913cca947d0c€49.00€0.67matched
92capture01a1b02e-f84e-7009-a9dc-38d33e5878c7€9.00€0.19matched
93capture01a1b02f-2207-7fbb-b0ab-d451731254e2€24.00€0.37matched
94capture01a1b02f-2573-7871-b869-8fbc9ddd2845€49.00€0.67matched
95capture01a1b02f-2819-7d37-b6c8-e6ddf2a13f5e€24.00€0.37matched
96capture01a1b02f-282f-73c7-93be-4946721cb33f€35.00€0.50matched
97capture01a1b02f-3d19-7f1b-ad78-2662307d7afa€15.00€0.26matched
98capture01a1b02f-8699-7fdb-895b-96eec04efa89€15.00€0.26matched
99capture01a1b02f-95f0-7f53-bb69-12103ae09403€9.00€0.19matched
100capture01a1b02f-9b0e-70b0-848e-db3eb368cccf€24.00€0.37matched
101capture01a1b030-096a-7442-9923-6b15bea30434€24.00€0.37matched
102capture01a1b030-331a-79b3-a6f4-b212db900a66€15.00€0.26matched
103capture01a1b030-527a-76dd-975f-4a00a6ff9dc3€35.00€0.50matched
104capture01a1b030-6b55-7c8f-97a7-fc8a606619ed€15.00€0.26matched
105capture01a1b030-8bb5-79c5-8288-16376a4d991b€49.00€0.67matched
106capture01a1b030-9407-70d5-bec6-71f368bbced5€49.00€0.67matched
107refund01a1b030-994a-7590-8f4d-6c439c4c7c61-€10.00€0.00matched
108capture01a1b030-bd25-7c88-aeb1-989f37c0b134€15.00€0.26matched
109capture01a1b030-caa5-7fd4-85f9-ed81866bb68f€15.00€0.26matched
110capture01a1b030-e396-763a-a76a-270d17293dc8€49.00€0.67matched
111capture01a1b031-0bbc-7c25-a6c7-3a475b2e2fae€15.00€0.26matched
112capture01a1b031-25a0-72e9-9da3-6ef7b2d3e2b8€9.00€0.19matched
113capture01a1b031-2b9f-7473-8753-096d6de968e9€35.00€0.50matched
114capture01a1b031-30d6-73f7-9cff-9496aeee1e85€9.00€0.19matched
115capture01a1b031-34fc-71bb-98e2-3a05b56c7baf€35.00€0.50matched
116capture01a1b031-4d02-7870-8773-a1cc7da6f12f€35.00€0.50matched
117capture01a1b031-5751-7b96-90ec-ee9f09ffb24d€35.00€0.50matched
118capture01a1b031-5f6b-708e-acb3-6a6ce19a93aa€9.00€0.19matched
119capture01a1b031-66ae-7d7d-930f-3229b0c1527b€24.00€0.37matched
120capture01a1b031-815c-782c-bda3-1d0f624fbe0a€9.00€0.19matched