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

Gross

€3,025.00

PSP fee

€47.07

Net to the bank

€2,977.93

Settlement journal

#410894

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1af6b-040e-7208-a8df-b8086345556e is already settled by stl_EUR_2989907 line 37
  • missing linein the books, not in the filerefund:01a1af71-3200-7510-8f49-cb152124e6ae is in no file
LineKindReferenceGrossFeeStatus
38capture01a1af6b-042c-7527-8898-a9ad1b0aa9f5€49.00€0.67duplicate line
1capture01a1af5f-5616-7532-97f3-7a611c68524d€9.00€0.19matched
2capture01a1af66-6de0-70a4-a562-de5f404c488f€49.00€0.67matched
3capture01a1af68-27c6-72bd-a221-e3df29d04cae€24.00€0.37matched
4capture01a1af68-3497-7a90-a6c5-29d1918865e2€49.00€0.67matched
5capture01a1af68-3820-7c4a-b50c-b8d36a6803f2€9.00€0.19matched
6capture01a1af68-47df-7b2a-8a61-21ac57f08c52€49.00€0.67matched
7capture01a1af68-8ea1-7656-80e7-20bf220b339f€49.00€0.67matched
8capture01a1af68-ac5d-704e-8330-24454e696550€15.00€0.26matched
9capture01a1af68-b65d-7c24-b8c4-8dd7e1ac85fc€24.00€0.37matched
10capture01a1af68-b8b8-7e6f-8985-4437a09b3366€49.00€0.67matched
11capture01a1af68-b476-72c1-9af9-198d62e3e6bf€35.00€0.50matched
12capture01a1af68-c10e-79bf-a3ab-836d9e61971d€9.00€0.19matched
13capture01a1af68-cd49-7ab4-bae3-dcbc59b06d36€24.00€0.37matched
14capture01a1af68-d057-76ad-9d95-f18a93a3b257€35.00€0.50matched
15capture01a1af68-d7b1-7673-bc61-bde431b116a8€9.00€0.19matched
16capture01a1af68-dfd6-7bae-a708-4ba09f294670€49.00€0.67matched
17capture01a1af69-2549-7bd9-a107-c9c86ce36302€24.00€0.37matched
18capture01a1af69-3a43-71ff-bc5c-56e350e47866€15.00€0.26matched
19capture01a1af69-3f2c-700a-b925-46aa2eaf9f9c€15.00€0.26matched
20capture01a1af69-47ed-7aa2-8b14-b21435c7dcc5€15.00€0.26matched
21capture01a1af69-5144-7541-90c3-3f889a1c6391€35.00€0.50matched
22capture01a1af69-87e7-7d16-a270-d6b88de270fe€24.00€0.37matched
23capture01a1af69-a9bb-7001-ade1-ad90c30745ec€15.00€0.26matched
24capture01a1af69-b872-7f81-a6d3-f4175d8b15fc€49.00€0.67matched
25capture01a1af69-f59e-7bdc-8a37-a8266cf8424f€9.00€0.19matched
26capture01a1af6a-1a80-7ff3-8b26-5ff0e894b43e€9.00€0.19matched
27capture01a1af6a-4a8e-7e4c-be68-e3304bdf3014€24.00€0.37matched
28capture01a1af6a-57c3-7263-8850-c90b20564272€35.00€0.50matched
29capture01a1af6a-6ace-70d6-9a1e-e5de230fa0f0€15.00€0.26matched
30capture01a1af6a-99e5-7860-8457-fc776bc9ab64€49.00€0.67matched
31capture01a1af6a-b349-7f30-ade1-2ee734b4a945€49.00€0.67matched
32capture01a1af6a-c39c-7cea-8249-0bfbad4830d0€15.00€0.26matched
33capture01a1af6a-c59d-7fd7-aaee-5b81d4d7a5d3€35.00€0.50matched
34capture01a1af6a-e2c8-7735-a5ae-6ed884f287d5€9.00€0.19matched
35capture01a1af6a-e583-7573-b585-c81cd86dc582€24.00€0.37matched
36capture01a1af6a-f920-78e1-aa8f-cefe7701f53c€24.00€0.37matched
37capture01a1af6b-042c-7527-8898-a9ad1b0aa9f5€49.00€0.67matched
39capture01a1af6b-07f3-7b21-8be9-07869e854901€24.00€0.37matched
40capture01a1af6b-1363-7202-9347-fc98b47c1b9f€24.00€0.37matched
41capture01a1af6b-7525-7d9e-9c37-1bad72e51b0f€24.00€0.37matched
42refund01a1af6b-77fb-766c-977f-e30ed9402d2d-€22.00€0.00matched
43capture01a1af6b-9c74-7b3c-955b-063dda8f515e€35.00€0.50matched
44capture01a1af6b-a2bb-7fb2-8eee-32f58c78efcb€15.00€0.26matched
45capture01a1af6b-aab3-7532-8cd1-580f7ddf69e9€49.00€0.67matched
46capture01a1af6b-c4ba-74c1-b788-92d51097a759€49.00€0.67matched
47capture01a1af6b-cc6e-7377-a881-4d125a1faaed€24.00€0.37matched
48capture01a1af6b-d0d9-708b-841b-9c1666c9db4f€15.00€0.26matched
49capture01a1af6b-dbdf-7a40-8a85-a945ab4573ab€15.00€0.26matched
50capture01a1af6c-341e-7a3c-a737-9246324dbd32€24.00€0.37matched
51capture01a1af6c-4725-7608-a9e9-21586ac2e139€9.00€0.19matched
52capture01a1af6c-5e4b-7e73-bc12-e0bcf528e6a6€24.00€0.37matched
53capture01a1af6c-68e2-7dfc-94dc-0fe210c79fd2€24.00€0.37matched
54capture01a1af6c-8e93-738e-a927-6e5eb1f21308€49.00€0.67matched
55capture01a1af6c-9918-76cc-b050-56d16ca4b6dd€49.00€0.67matched
56capture01a1af6c-b649-7f06-b6c9-a350e9833302€49.00€0.67matched
57capture01a1af6c-c9a7-75f5-a6b8-90718a4d0996€15.00€0.26matched
58capture01a1af6c-d031-781f-937e-d0523539b4c2€9.00€0.19matched
59capture01a1af6c-d21b-71b6-b193-fd02031724e7€24.00€0.37matched
60capture01a1af6c-d2d7-7fb3-960b-4d090c8649a3€15.00€0.26matched
61capture01a1af6c-e6d4-7803-9245-b92c0f02265b€24.00€0.37matched
62capture01a1af6c-f8ed-7cd2-baa1-ee8e80b38cd6€49.00€0.67matched
63refund01a1af6d-1530-702d-aa24-603384a23695-€19.00€0.00matched
64refund01a1af6d-2058-74bb-8afb-300ca7e0291a-€17.00€0.00matched
65capture01a1af6d-246b-72df-89e0-587216f86d28€9.00€0.19matched
66capture01a1af6d-2763-7615-b2c9-5fabeb3db2bb€24.00€0.37matched
67capture01a1af6d-2a9e-7ced-bbb5-9ad173d77bbb€24.00€0.37matched
68capture01a1af6d-9062-72e5-9d1b-557ac14778ce€9.00€0.19matched
69capture01a1af6d-91b8-7d94-8686-45da26dc29d0€24.00€0.37matched
70capture01a1af6d-9318-799f-9178-a00a52eccdb6€9.00€0.19matched
71capture01a1af6d-b3ed-7dea-aa4f-6951f904d8ef€9.00€0.19matched
72capture01a1af6d-b8af-73a1-9e91-559b53596738€9.00€0.19matched
73capture01a1af6d-bea3-7524-9900-b2cfa466b9bf€15.00€0.26matched
74capture01a1af6d-f6c5-7cf2-bbe4-18049232d341€24.00€0.37matched
75capture01a1af6e-1cb0-762c-b5d6-a69041008152€49.00€0.67matched
76capture01a1af6e-2005-7742-b75d-d178b442a974€24.00€0.37matched
77capture01a1af6e-35fd-70c2-89d6-17bad37d562e€49.00€0.67matched
78capture01a1af6e-3693-7935-8e5a-e12aa9de588b€9.00€0.19matched
79capture01a1af6e-3f62-7e80-96ee-00da8baed7fb€49.00€0.67matched
80capture01a1af6e-6da8-7f75-9c15-f821277c4cdf€24.00€0.37matched
81capture01a1af6e-7050-7476-acfd-22ff2876586c€9.00€0.19matched
82capture01a1af6e-78eb-7be9-bc22-24974abf1ed7€9.00€0.19matched
83refund01a1af6e-8073-7f11-bea2-074b21a63d08-€22.00€0.00matched
84capture01a1af6e-9498-78fd-943a-d9f10f554866€35.00€0.50matched
85capture01a1af6e-ab34-73c8-b131-935cba334935€35.00€0.50matched
86refund01a1af6e-b343-7ebe-82eb-52adfedb6f95-€5.00€0.00matched
87capture01a1af6e-cf8a-78fd-8d0b-55b870c15ed3€15.00€0.26matched
88capture01a1af6e-f313-73a3-9b19-9db239329e6e€15.00€0.26matched
89capture01a1af6e-fcb1-7efc-b994-b65dc0de35ee€15.00€0.26matched
90capture01a1af6f-1115-7b50-90e5-ac090e473357€9.00€0.19matched
91capture01a1af6f-12d5-75c4-aabb-31995e61a0f5€49.00€0.67matched
92capture01a1af6f-1ae0-71a2-8e92-970840b77094€15.00€0.26matched
93capture01a1af6f-20e7-726b-b6e7-cdd3814df7d5€24.00€0.37matched
94capture01a1af6f-4350-7769-af3f-6f37f2f72d47€35.00€0.50matched
95capture01a1af6f-47fc-7e6f-9b22-c35b4731dc4e€35.00€0.50matched
96refund01a1af6f-5b29-78ab-882b-c7d10703402c-€11.00€0.00matched
97capture01a1af6f-8576-7200-942f-7070f0e79834€9.00€0.19matched
98capture01a1af6f-927d-7ef8-9339-8ac1ab14351f€24.00€0.37matched
99capture01a1af6f-966e-7b9f-a8e2-b809ea6227c0€15.00€0.26matched
100capture01a1af6f-ab18-79cc-865c-8098ea6c76b8€49.00€0.67matched
101capture01a1af6f-b93e-79bc-bda6-7e1aa829f23e€35.00€0.50matched
102capture01a1af6f-ce0c-7a5b-a4dd-3bac904f5eff€15.00€0.26matched
103capture01a1af6f-ce33-7d75-a073-cb18a7763d1b€49.00€0.67matched
104capture01a1af6f-e2de-7a1b-b36d-4f49b78a587c€15.00€0.26matched
105capture01a1af6f-e489-70b7-8bb2-3b3feb0930a5€15.00€0.26matched
106capture01a1af6f-fe7a-75f9-9781-f66231cf238a€15.00€0.26matched
107capture01a1af70-117d-70a9-b0a1-e8b6e3b0bd2e€35.00€0.50matched
108capture01a1af70-1522-72e8-932e-6fd0764e1241€49.00€0.67matched
109capture01a1af70-27c7-79db-bfd6-e9a0f50320c7€24.00€0.37matched
110capture01a1af70-4618-71df-adb0-782e5a274ec3€9.00€0.19matched
111capture01a1af70-4cc9-78a2-b509-e65bfa5bddf2€24.00€0.37matched
112capture01a1af70-6bfd-7fbc-a6ac-94cd02b0adc8€15.00€0.26matched
113refund01a1af70-74e5-7874-aa51-3c19a32a63e5-€2.00€0.00matched
114capture01a1af70-817c-78af-be19-4e90b1283dae€24.00€0.37matched
115capture01a1af70-88ee-771c-b4a9-48dc4abe45de€35.00€0.50matched
116capture01a1af70-8c99-785b-8cfc-cabf9ba44c13€15.00€0.26matched
117capture01a1af70-a467-7ca4-85a5-a8f10ae7e8d9€35.00€0.50matched
118capture01a1af70-bca3-7107-a37f-d98ff90d8ac3€49.00€0.67matched
119capture01a1af70-ce7e-7f21-8e39-93c143586598€49.00€0.67matched
120capture01a1af70-d0b1-7941-968e-3fbad977118c€9.00€0.19matched
121capture01a1af70-d26a-7d5c-b4a3-7036cc6aed74€24.00€0.37matched
122capture01a1af70-ec62-721b-b011-31c840c6d753€15.00€0.26matched
123capture01a1af70-eda2-7fad-9359-1d4cf0e29fc7€49.00€0.67matched
124capture01a1af71-1015-7b59-b062-ebaebcc0782d€15.00€0.26matched
125capture01a1af71-3fe0-7f1e-9630-61d6fdad3b13€35.00€0.50matched