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

Gross

€2,655.00

PSP fee

€42.33

Net to the bank

€2,612.67

Settlement journal

#385064

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a82c-5a07-7f51-82af-6d41f675d0fb is already settled by stl_EUR_2989704 line 78
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • missing linein the books, not in the filecapture:01a1a827-eb32-7e37-964f-d6c304e692ff is in no file
LineKindReferenceGrossFeeStatus
17capture01a1a827-9aef-763a-a81c-be949805c58f€24.00€0.39fee difference
79capture01a1a82c-5a4b-77d0-88ed-f7c0057b9c3d€49.00€0.67duplicate line
1capture01a1a825-b0ad-702b-a799-1acd1ac02167€49.00€0.67matched
2capture01a1a825-d0e5-76be-8123-9ac5fc2e90b6€24.00€0.37matched
3capture01a1a825-efea-7028-804c-721d6e7a7a2e€9.00€0.19matched
4capture01a1a826-092e-79ce-b0c7-37d0d0be3beb€9.00€0.19matched
5capture01a1a826-375a-792b-8926-3bb3c4134b78€49.00€0.67matched
6capture01a1a826-59df-7f43-a42f-2396735f3c5f€49.00€0.67matched
7capture01a1a826-65ce-73ee-a884-3491ac3ee314€49.00€0.67matched
8capture01a1a826-970e-795e-8131-9e5ea65b3828€9.00€0.19matched
9capture01a1a826-a640-7c16-a8ee-3c4ce5526cdd€49.00€0.67matched
10capture01a1a827-59e3-77b9-a039-cf628c18a542€49.00€0.67matched
11capture01a1a827-6a57-735b-979e-566a382fcdcc€49.00€0.67matched
12capture01a1a827-76bd-7473-b48b-5cbef00952c0€9.00€0.19matched
13capture01a1a827-7bf0-7750-958a-61d66ee8ae61€49.00€0.67matched
14capture01a1a827-7f53-7b73-884d-341060fec7d6€49.00€0.67matched
15capture01a1a827-866d-71df-bad7-13c3d8eb4cbf€9.00€0.19matched
16capture01a1a827-986a-7da4-913e-016285d0a5b4€35.00€0.50matched
18capture01a1a827-a112-7d5b-80c1-65daf160b791€15.00€0.26matched
19capture01a1a827-a217-7463-9220-d8a2763ff9ca€15.00€0.26matched
20capture01a1a827-a273-72e5-aff9-f4d4e848c754€24.00€0.37matched
21capture01a1a827-a368-7fbe-9241-ca19437a4a5d€49.00€0.67matched
22capture01a1a827-a99b-755e-b20d-a57af650ce41€15.00€0.26matched
23capture01a1a827-ac1d-711f-b3c5-4a95de3e1e08€24.00€0.37matched
24capture01a1a827-c70d-7009-9e62-e6ae2fe14a3f€35.00€0.50matched
25capture01a1a827-d5dc-779f-88e2-120abd85ee08€35.00€0.50matched
26refund01a1a827-d61e-7511-b2f4-9116a3f94f13-€25.00€0.00matched
27capture01a1a827-da34-730e-8e10-7a12a24ab96e€15.00€0.26matched
28capture01a1a827-ed1a-72e5-b555-47653e2cc08f€9.00€0.19matched
29refund01a1a827-fcaa-7470-91e2-6198160f532f-€9.00€0.00matched
30capture01a1a827-ff09-707c-b4c3-8ef661bd3032€35.00€0.50matched
31capture01a1a828-12a8-78a9-8032-151a4a5bf391€24.00€0.37matched
32capture01a1a828-1dab-7c18-92c4-9cc6379c1a05€15.00€0.26matched
33capture01a1a828-322e-7240-8688-9b548e40f117€49.00€0.67matched
34capture01a1a828-74d9-764e-bef7-e5f81ff153c9€15.00€0.26matched
35capture01a1a828-7394-7833-a951-b05b8b6b4205€35.00€0.50matched
36capture01a1a828-7b94-7e3b-9b6b-0e723c086a1e€9.00€0.19matched
37capture01a1a828-84b4-7d53-b8c0-d0547ad09f17€35.00€0.50matched
38capture01a1a828-905d-7077-b1e3-64005c55a2c1€35.00€0.50matched
39refund01a1a828-ce76-7a77-a848-474bb5ab79c0-€24.00€0.00matched
40capture01a1a828-daf6-70ad-a180-6735decd63c0€35.00€0.50matched
41capture01a1a829-19ab-7245-bdb5-a1f93d0beff3€49.00€0.67matched
42capture01a1a829-58c1-7360-966f-5c020fe2bc76€24.00€0.37matched
43capture01a1a829-7fdd-7e68-9b70-b1da08413226€24.00€0.37matched
44capture01a1a829-9483-7563-bb69-c0e722f8016f€9.00€0.19matched
45capture01a1a829-a554-7855-a436-0a25d1984ef8€9.00€0.19matched
46capture01a1a829-bf85-7167-ba62-2b4468fe589c€15.00€0.26matched
47capture01a1a829-ec1c-78be-981f-90763ecf427a€49.00€0.67matched
48capture01a1a829-f529-7e5a-8010-5b87d624ada7€9.00€0.19matched
49capture01a1a82a-3cf4-7b33-a8ad-229177285473€24.00€0.37matched
50capture01a1a82a-41db-7b64-a610-befa17c4c537€35.00€0.50matched
51capture01a1a82a-45f0-7fc6-9ae4-1f963f604d96€49.00€0.67matched
52capture01a1a82a-4e8a-7e5b-b542-eddc135fd09d€9.00€0.19matched
53capture01a1a82a-61a1-711a-abc3-77c57b96c3cb€9.00€0.19matched
54capture01a1a82a-904b-75d6-bfb5-eec990033252€15.00€0.26matched
55capture01a1a82a-9c60-7513-b98d-20d9a229ac09€35.00€0.50matched
56refund01a1a82a-a551-7590-8430-d32482a2891a-€5.00€0.00matched
57capture01a1a82a-cd8f-71ed-8b99-a00ed2ab233b€15.00€0.26matched
58capture01a1a82a-d5ad-7c7a-abc2-ff2504f3ecbf€15.00€0.26matched
59capture01a1a82a-d781-7803-b5e8-a6077ca96ce2€9.00€0.19matched
60capture01a1a82a-de35-752e-8c53-100fa2735cfc€24.00€0.37matched
61capture01a1a82a-e83e-765e-a181-d826291da63e€35.00€0.50matched
62capture01a1a82b-39ef-7bf8-9ebc-96aaac51703b€9.00€0.19matched
63capture01a1a82b-3e2e-746d-a70c-f51dfb506e3c€24.00€0.37matched
64capture01a1a82b-40fb-7ec4-bacd-5e9a7cc547df€24.00€0.37matched
65capture01a1a82b-67a0-7d74-ad5d-ab32479645e2€24.00€0.37matched
66capture01a1a82b-6a87-7dc8-88dc-1d24ed0252b5€24.00€0.37matched
67refund01a1a82b-7c33-7e9b-9ee9-577c1b267580-€24.00€0.00matched
68capture01a1a82b-8408-7e05-8089-9d2b3e5d65c8€24.00€0.37matched
69capture01a1a82b-86d7-7992-a03e-7fa58c230a62€49.00€0.67matched
70capture01a1a82b-d024-71e3-b5ba-752ca6c59fd7€24.00€0.37matched
71refund01a1a82b-d7a6-74b7-b61d-5e7f04482d4f-€30.00€0.00matched
72refund01a1a82b-d482-78e2-9c4d-17c3c5d82025-€11.00€0.00matched
73capture01a1a82c-03c4-759e-8939-3cb2219e0050€24.00€0.37matched
74capture01a1a82c-10a5-74f0-bc6c-a7d4b3cb5f1f€24.00€0.37matched
75capture01a1a82c-109c-7122-a752-4fe5414a7c44€24.00€0.37matched
76capture01a1a82c-30ee-751e-b3af-343ec7d1bcb2€9.00€0.19matched
77capture01a1a82c-498c-7e98-825f-aa57dc78c9a9€35.00€0.50matched
78capture01a1a82c-5a4b-77d0-88ed-f7c0057b9c3d€49.00€0.67matched
80capture01a1a82c-5c54-73b6-8b47-530c5b2e14b7€24.00€0.37matched
81capture01a1a82c-6510-76a2-bd2d-a607f70c3052€35.00€0.50matched
82capture01a1a82c-7813-7fe6-9593-20d8de55d040€9.00€0.19matched
83refund01a1a82c-846c-760b-b302-642a3ea47746-€8.00€0.00matched
84capture01a1a82c-ad9e-785f-a188-0035275d127d€35.00€0.50matched
85capture01a1a82c-eb49-7df7-96d8-b6a32f23cabd€49.00€0.67matched
86capture01a1a82c-ebce-7f29-885b-992ebe8953c6€15.00€0.26matched
87capture01a1a82c-fecb-7dff-9829-a963e34970dc€49.00€0.67matched
88capture01a1a82d-00e0-7a92-8112-d2cb0e5935ce€49.00€0.67matched
89capture01a1a82d-06d3-706d-933e-a499b217b08b€9.00€0.19matched
90capture01a1a82d-1518-7733-b96f-e6f48b706173€9.00€0.19matched
91capture01a1a82d-20b6-703e-8c0b-bab504e766ea€35.00€0.50matched
92refund01a1a82d-3428-7680-90de-c61286aa8b4d-€15.00€0.00matched
93capture01a1a82d-4fd3-7a3e-9c60-5ff145ba7fe0€35.00€0.50matched
94capture01a1a82d-66ec-72b8-bb38-1d301e956362€9.00€0.19matched
95capture01a1a82d-78b7-796a-9484-1390b3a6112a€24.00€0.37matched
96capture01a1a82d-8a46-71f2-9aa8-d72965c94b16€24.00€0.37matched
97capture01a1a82d-904e-7f29-8e1f-85edfd4812e6€35.00€0.50matched
98capture01a1a82d-a025-7cb4-b808-cfd1ff4cd088€15.00€0.26matched
99capture01a1a82d-b388-775b-86b8-da412e9fc4fe€35.00€0.50matched
100refund01a1a82d-cd7b-7a7d-8c6d-987148f495a1-€8.00€0.00matched
101capture01a1a82d-d272-716a-a8e3-4c22c67b077b€9.00€0.19matched
102capture01a1a82d-ed29-74fe-bf14-ccbdd022a860€35.00€0.50matched
103capture01a1a82d-f5d0-72e0-b8b2-5eb61b7a0dea€35.00€0.50matched
104capture01a1a82d-fe0f-70eb-ab72-aea05b0e06dc€49.00€0.67matched
105capture01a1a82d-ff5c-74ac-8f46-d8765c3f0889€35.00€0.50matched
106capture01a1a82e-3686-77b9-a498-1479ea07c698€24.00€0.37matched
107capture01a1a82e-5553-7cb6-83c3-a8da01d7d90a€49.00€0.67matched
108capture01a1a82e-7f8f-7002-aa1b-9ceac77e5428€15.00€0.26matched
109refund01a1a82e-9558-7051-9967-a7bbfa62670c-€14.00€0.00matched
110capture01a1a82e-9a1b-738f-b711-cfcb7d2b2ec2€49.00€0.67matched
111capture01a1a82e-9fb6-7de3-b543-ea11e1599ce4€15.00€0.26matched
112capture01a1a82e-a450-7d02-bc5d-5919f2d1dfc1€15.00€0.26matched
113capture01a1a82e-a683-7ee5-aa2e-d9932c9da7fa€9.00€0.19matched
114capture01a1a82e-c586-7781-9e24-59426351907d€24.00€0.37matched