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

1 Nov, 02:00

Gross

€2,787.00

PSP fee

€43.97

Net to the bank

€2,743.03

Settlement journal

#316594

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a194db-e064-724e-9651-8c6b52f52f28 is already settled by stl_EUR_2989164 line 74
  • missing linein the books, not in the filecapture:01a194d8-fea6-7a03-a1e8-9392712dbce2 is in no file
  • missing linein the books, not in the filecapture:01a194db-28af-7f9f-8e76-0a7f7935d103 is in no file
LineKindReferenceGrossFeeStatus
75capture01a194db-e0fc-751d-9921-d5dcc578d1aa€35.00€0.50duplicate line
1capture01a194cf-7a3b-76a6-a579-91f15c404beb€35.00€0.50matched
2capture01a194d5-80cc-7d97-a34e-6f9c89b2086c€15.00€0.26matched
3capture01a194d5-cca0-7c07-a355-c859ab98e51b€9.00€0.19matched
4capture01a194d5-fbe1-7854-94ef-5a7bf74a14ba€49.00€0.67matched
5capture01a194d5-fcc2-7b73-8df6-5375a410b996€35.00€0.50matched
6capture01a194d6-3000-73bf-8f05-5cc0b0efc912€24.00€0.37matched
7capture01a194d6-3324-76d9-901e-230dbe54d1d8€15.00€0.26matched
8capture01a194d6-3939-719a-916b-1ce75e2d52c5€24.00€0.37matched
9capture01a194d6-3d76-7418-823f-7a811cc9348e€35.00€0.50matched
10capture01a194d6-45c1-745e-945b-7fe298b0dae3€15.00€0.26matched
11capture01a194d6-57a5-7aa8-91f3-6c05b920c696€9.00€0.19matched
12capture01a194d6-6f4b-7c76-86de-8be2a2f06d4b€35.00€0.50matched
13capture01a194d6-6e24-74c8-861e-cc61edc5a26e€35.00€0.50matched
14capture01a194d6-8300-7e45-9b9f-4f394048366b€9.00€0.19matched
15capture01a194d6-8720-7f3b-9919-9928a97e0cdb€15.00€0.26matched
16capture01a194d6-fa4a-7828-8342-f6ecc033ba9b€49.00€0.67matched
17capture01a194d7-17cb-780c-95f0-e6f5ee898179€24.00€0.37matched
18capture01a194d7-371a-7e2e-9e7e-4a97ad1ef39d€49.00€0.67matched
19capture01a194d7-3a95-7e0a-873b-99d205c67f56€35.00€0.50matched
20capture01a194d7-466b-76b6-9775-95090693d3c3€35.00€0.50matched
21capture01a194d7-4e79-7eb4-a136-be8a9c7dcd37€24.00€0.37matched
22refund01a194d7-5d02-7020-a6e3-f277a16debd2-€23.00€0.00matched
23capture01a194d7-817c-79f6-b5d3-05988425971e€15.00€0.26matched
24refund01a194d7-a480-707c-af84-228f1308154c-€18.00€0.00matched
25capture01a194d7-a852-739e-854b-d03ca5a24eb9€24.00€0.37matched
26capture01a194d7-a8e4-7977-b28c-a38bc8379c90€24.00€0.37matched
27capture01a194d7-ac4d-7289-be2c-1b878a717bc8€15.00€0.26matched
28capture01a194d7-b6b1-761b-b702-05866747702c€35.00€0.50matched
29capture01a194d7-c6bb-7fca-bfa2-7739e20bd852€49.00€0.67matched
30capture01a194d7-d1a4-739a-9b68-e3dd23e592a8€15.00€0.26matched
31capture01a194d7-ef48-7633-ac3d-ac2dd6624e71€24.00€0.37matched
32capture01a194d8-072e-710b-b95d-47eb67cec000€9.00€0.19matched
33capture01a194d8-2d1e-7d14-b944-8c0fed49c1b4€35.00€0.50matched
34capture01a194d8-2faf-78a9-a8de-7941b33689b5€35.00€0.50matched
35capture01a194d8-54c7-7468-93db-1fab44b277bb€49.00€0.67matched
36capture01a194d8-5858-764e-a893-6b16947df4a1€35.00€0.50matched
37capture01a194d8-a73d-797f-9c19-aa2431801319€49.00€0.67matched
38capture01a194d8-a892-7cc5-937f-3a20c7b36fd7€35.00€0.50matched
39capture01a194d8-c5e6-7091-ba29-eed9ef3768be€9.00€0.19matched
40capture01a194d8-e012-7d74-b4e0-48cd64acbf8b€9.00€0.19matched
41capture01a194d9-0527-7c7c-a8e3-3f62b1427cb5€9.00€0.19matched
42capture01a194d9-0b01-737f-8e68-1405b7ff9f93€15.00€0.26matched
43capture01a194d9-1542-7317-841c-3a1b5052fee6€9.00€0.19matched
44capture01a194d9-17e0-7539-b693-b1715bf35076€49.00€0.67matched
45capture01a194d9-44eb-7467-b097-390c28659f33€35.00€0.50matched
46capture01a194d9-46af-758c-830f-25c889bc25fc€49.00€0.67matched
47refund01a194d9-54f0-7578-842e-60cb5051050f-€2.00€0.00matched
48capture01a194d9-6993-7d5c-bebd-d4357ec6eb5f€15.00€0.26matched
49capture01a194d9-99b1-7d91-99e1-91dcf6dd2f63€15.00€0.26matched
50capture01a194d9-b3bd-702f-8763-17cc37caf8da€24.00€0.37matched
51capture01a194d9-c70d-7cbb-813b-b937e59db4c0€24.00€0.37matched
52capture01a194d9-e6dd-7cdd-8065-1f611f93c80b€9.00€0.19matched
53capture01a194da-0420-7152-b0ec-1689b297430d€49.00€0.67matched
54capture01a194da-2980-751d-8903-32e04ee62f42€49.00€0.67matched
55capture01a194da-4d6b-78b9-a5cc-a9f2be1c100d€49.00€0.67matched
56capture01a194da-6b2d-7fec-bca7-4903e1a84805€15.00€0.26matched
57capture01a194da-8a83-7fc6-9b00-7ceae836d8b0€35.00€0.50matched
58capture01a194da-96bc-70da-a66f-ebfffa106c49€24.00€0.37matched
59capture01a194da-a4ce-7445-9a2a-67708e780e49€24.00€0.37matched
60capture01a194da-de56-7644-ac53-9dccca341461€9.00€0.19matched
61capture01a194da-e4d7-742a-84d1-1e8533229477€15.00€0.26matched
62capture01a194da-e831-7ca6-b441-7f7557b95d56€15.00€0.26matched
63capture01a194da-f571-7f2f-9bc3-be66239acaf7€49.00€0.67matched
64capture01a194da-fc62-7b7c-ad7c-2cc3892ca5af€24.00€0.37matched
65capture01a194db-1a10-711c-a84a-bac485ad2461€24.00€0.37matched
66capture01a194db-3b9c-7e62-bae2-a81f4f0bfd78€9.00€0.19matched
67capture01a194db-4187-7320-b1e6-c0a6c139dbb2€9.00€0.19matched
68capture01a194db-649d-7e8a-b50d-466482a44fc6€24.00€0.37matched
69capture01a194db-a895-722f-a988-112e99a19d8d€9.00€0.19matched
70capture01a194db-b0d5-70b0-a012-17d9da9082e4€15.00€0.26matched
71capture01a194db-b457-7f5f-b24a-7c32d6b80849€49.00€0.67matched
72capture01a194db-bedd-75e5-9141-f345cd692c71€49.00€0.67matched
73capture01a194db-d8eb-730a-8d3d-2cde87fd69c8€35.00€0.50matched
74capture01a194db-e0fc-751d-9921-d5dcc578d1aa€35.00€0.50matched
76capture01a194db-f3f1-725b-88de-c435d581c3ba€15.00€0.26matched
77capture01a194db-f7d8-7915-a659-28a7bb68d531€24.00€0.37matched
78capture01a194dc-0327-784f-b620-d090d3f93223€24.00€0.37matched
79capture01a194dc-1136-7000-8144-c8b2a2bd02a5€35.00€0.50matched
80capture01a194dc-26de-7307-a811-623d26b53b60€49.00€0.67matched
81refund01a194dc-4346-726e-8056-6f509cd5458f-€32.00€0.00matched
82capture01a194dc-60a1-74b8-abdd-2275b009c4c3€24.00€0.37matched
83capture01a194dc-976d-7043-a91a-824065046466€49.00€0.67matched
84capture01a194dc-a7a0-753c-a9f4-1e909b764894€24.00€0.37matched
85capture01a194dc-b288-7462-8a1d-32c3dd6de081€35.00€0.50matched
86capture01a194dc-b9a0-7cf3-a00e-94954e864be7€9.00€0.19matched
87refund01a194dc-d2f1-73b8-bd6d-8baedb271793-€18.00€0.00matched
88capture01a194dc-f386-7fe2-8f29-0885b76c8bc8€24.00€0.37matched
89capture01a194dd-0a8d-726c-95a8-6099e0b4eb3b€15.00€0.26matched
90capture01a194dd-0d89-76ab-9c81-4e61d4256dd4€9.00€0.19matched
91capture01a194dd-0fc5-7467-8ad0-dbd76d3bafd4€9.00€0.19matched
92capture01a194dd-1d9a-7ea0-9378-71236b652fd1€49.00€0.67matched
93capture01a194dd-261a-7287-ae3b-af564e329b4b€9.00€0.19matched
94capture01a194dd-2ae9-7112-8b3d-e21f3da128dd€24.00€0.37matched
95capture01a194dd-2f9a-7682-a4bc-4fa739ebd8c8€9.00€0.19matched
96capture01a194dd-37c8-79a6-911f-90acf80e1d33€9.00€0.19matched
97capture01a194dd-3a31-7d9a-a066-503c1e8457ba€24.00€0.37matched
98capture01a194dd-5537-7620-9806-f505e19b3585€15.00€0.26matched
99capture01a194dd-6584-714d-a635-bf1079c2c1a8€35.00€0.50matched
100capture01a194dd-6dcb-723a-a623-2a74a733fd0c€24.00€0.37matched
101capture01a194dd-ae85-7618-8fc7-142b740024fd€9.00€0.19matched
102capture01a194dd-c0fd-7b1f-bc13-86da5910d7e7€49.00€0.67matched
103capture01a194dd-ef09-70d5-8d91-a650d188fb14€15.00€0.26matched
104capture01a194de-0c44-76a2-ad6a-6468bd2aa146€9.00€0.19matched
105refund01a194de-0ec7-70d9-9ec5-0743e0c4f077-€26.00€0.00matched
106capture01a194de-0f22-725c-b3d3-c238ad0c1e5d€15.00€0.26matched
107capture01a194de-4752-735b-881b-cbdf1e161790€35.00€0.50matched
108capture01a194de-496e-7e3e-85bd-fddc42110ee3€49.00€0.67matched
109capture01a194de-5daf-7bc6-9025-e790b82706c5€35.00€0.50matched
110capture01a194de-68cb-7727-8615-ba0d966ae08a€49.00€0.67matched
111capture01a194de-71e2-70b3-922c-f414c1ad4d9f€49.00€0.67matched
112capture01a194de-7dfc-736a-80bb-52b7fce84e65€15.00€0.26matched
113capture01a194de-84e2-70e8-8cdc-577549c6c12e€9.00€0.19matched
114capture01a194de-941f-7e2d-a86a-1e4469b2ff30€24.00€0.37matched
115capture01a194de-9504-7efe-bf10-3c699d2cdb27€9.00€0.19matched
116capture01a194de-cdd7-7fa0-9e04-1defe83e63f8€24.00€0.37matched
117capture01a194de-db0e-7476-8b93-890fde19f574€9.00€0.19matched
118capture01a194de-e214-7aa7-8086-7856a48689c3€15.00€0.26matched