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

2 Nov, 12:10

Gross

€2,570.00

PSP fee

€41.66

Net to the bank

€2,528.34

Settlement journal

#342580

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19c2b-f6ce-7d2a-9ada-3489326b1b32 is already settled by stl_EUR_2989369 line 19
  • duplicate linethe file lists it twicecapture:01a19c31-a06f-77e0-bb6c-ec0d2379d95b is already settled by stl_EUR_2989369 line 88
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
LineKindReferenceGrossFeeStatus
6capture01a19c2a-c621-7454-9983-c013bd0a6970€35.00€0.51fee difference
20capture01a19c2b-f8c1-772a-8269-fab99589ba0c€49.00€0.67duplicate line
89capture01a19c31-a092-7a70-969c-6b4c16e5732c€24.00€0.37duplicate line
1capture01a19c22-8578-7dd1-b40c-5336ad699eba€49.00€0.67matched
2capture01a19c22-f2e5-7189-8eae-c9fd065db6ae€9.00€0.19matched
3capture01a19c27-624c-7159-b48a-8d6bacece0ce€15.00€0.26matched
4capture01a19c2a-0728-74e1-b1cc-456e7cfda345€35.00€0.50matched
5capture01a19c2a-88c2-78d6-b67e-7afdc0b73db2€9.00€0.19matched
7capture01a19c2a-dc9c-7e98-993d-36a7fef41417€15.00€0.26matched
8capture01a19c2a-e14b-767f-b084-c723c2980ddc€24.00€0.37matched
9capture01a19c2a-e1b0-7a70-b52b-05b58c685dab€9.00€0.19matched
10capture01a19c2a-efce-7d75-8d0a-7e7a3ec9b5e4€24.00€0.37matched
11capture01a19c2a-f881-7c95-b746-306337813a4f€49.00€0.67matched
12capture01a19c2b-0611-7676-ab45-9bc6f2b5c27f€9.00€0.19matched
13capture01a19c2b-1141-782d-bb74-b4a4a7bb22ff€24.00€0.37matched
14capture01a19c2b-338f-7cc0-a198-6118b99cc5d0€35.00€0.50matched
15capture01a19c2b-67a7-74a8-9d3c-78525d486584€15.00€0.26matched
16capture01a19c2b-a943-7681-abf3-ad073d54ce30€49.00€0.67matched
17capture01a19c2b-ac68-7fec-93b0-b6d839d54d51€49.00€0.67matched
18capture01a19c2b-d7c5-74ad-a6ff-f4f0beaefda9€15.00€0.26matched
19capture01a19c2b-f8c1-772a-8269-fab99589ba0c€49.00€0.67matched
21capture01a19c2b-ffa9-790d-87a5-c27679114b23€9.00€0.19matched
22capture01a19c2c-033e-77be-a3f7-4f67c5e860e3€35.00€0.50matched
23capture01a19c2c-0a7b-7fd5-af69-7a45f0846a11€9.00€0.19matched
24capture01a19c2c-281a-7f7e-a8ce-b1277efc6118€49.00€0.67matched
25capture01a19c2c-2ead-7978-b5a8-02ff4662dfde€9.00€0.19matched
26capture01a19c2c-3eba-75bb-a60a-b8ac01de40cb€49.00€0.67matched
27capture01a19c2c-7efb-781d-b91a-a18a139e503d€15.00€0.26matched
28capture01a19c2c-a861-795f-b6dc-09fb4927fdde€24.00€0.37matched
29capture01a19c2c-bb8d-7629-8381-d53f97b8111a€24.00€0.37matched
30capture01a19c2c-c67b-7bf1-9bbb-6a61230fdf94€9.00€0.19matched
31capture01a19c2c-d572-70a0-933d-db58e5741fe1€49.00€0.67matched
32capture01a19c2c-dd2e-7286-b593-e41a1f3ee800€24.00€0.37matched
33capture01a19c2d-0fae-7f80-9f21-85ef7c0e47de€15.00€0.26matched
34capture01a19c2d-1487-7379-b4f5-797db8988966€49.00€0.67matched
35capture01a19c2d-5213-7739-9763-2130ff223ed7€24.00€0.37matched
36capture01a19c2d-77ca-7e8b-a760-1fdd5f1318e2€49.00€0.67matched
37capture01a19c2d-7d9e-7c9b-a7f3-ed58c8770610€15.00€0.26matched
38capture01a19c2d-808e-73d0-8d50-1912eed2e9bf€24.00€0.37matched
39capture01a19c2d-9326-7f73-a050-f7402c2ec7c5€35.00€0.50matched
40refund01a19c2d-a80a-73e9-9de8-55e674fe6ba6-€24.00€0.00matched
41capture01a19c2d-c0f8-7187-aa71-66c8b0e236f0€9.00€0.19matched
42capture01a19c2d-d70d-76f8-8d00-f11ed4209cbc€49.00€0.67matched
43refund01a19c2d-e3e7-7e04-b253-df8eb81190d0-€27.00€0.00matched
44refund01a19c2e-2310-7aaf-a9aa-14cefbb74f92-€10.00€0.00matched
45capture01a19c2e-26e1-7f8f-b850-916256a9256b€49.00€0.67matched
46capture01a19c2e-39a7-75e2-a177-f4268c207b8f€15.00€0.26matched
47refund01a19c2e-6af4-7479-9c27-b83c9ebef66f-€27.00€0.00matched
48capture01a19c2e-76a8-73a6-9a16-be0e28e18f4a€24.00€0.37matched
49capture01a19c2e-9ba6-7f77-838f-e3f66ec28960€15.00€0.26matched
50capture01a19c2e-ae53-7d4f-82c5-5aaad2637834€24.00€0.37matched
51capture01a19c2e-d26e-7f4d-a284-359f1978c26d€9.00€0.19matched
52capture01a19c2f-0e09-7fdc-bd64-80709246871a€9.00€0.19matched
53capture01a19c2f-10d1-7655-a850-9c7711defe93€24.00€0.37matched
54capture01a19c2f-35bb-7cea-b603-38276f8d1811€9.00€0.19matched
55capture01a19c2f-4aa2-7439-a6fc-c0a95970447c€49.00€0.67matched
56capture01a19c2f-5332-7cd8-a325-a6db12b52bce€24.00€0.37matched
57capture01a19c2f-62f7-706e-80fc-85fd5df7ae45€15.00€0.26matched
58capture01a19c2f-76ba-7902-9d99-59b9bcbcb067€24.00€0.37matched
59capture01a19c2f-7f47-7567-afad-dcc9a6e6d798€15.00€0.26matched
60capture01a19c2f-7f69-729c-a7bc-b84667b0bf96€9.00€0.19matched
61capture01a19c2f-97d6-77c2-adda-a02de24064a6€9.00€0.19matched
62capture01a19c2f-b1f9-7430-88af-41666fedd421€35.00€0.50matched
63refund01a19c2f-b83e-7084-9ce1-d44797418505-€9.00€0.00matched
64capture01a19c2f-cbbd-70c9-9262-4c20fb19eb0a€9.00€0.19matched
65capture01a19c2f-ce06-7c08-9bd9-e8c1874c7ebf€24.00€0.37matched
66capture01a19c2f-f083-7308-b62d-9e442536cf94€15.00€0.26matched
67capture01a19c2f-f43b-78bb-b569-b8b5d5e03e52€49.00€0.67matched
68capture01a19c30-08f4-7c5a-962f-a2ae006fc8c6€24.00€0.37matched
69capture01a19c30-2988-706f-a2e0-b5dab266b8d8€15.00€0.26matched
70capture01a19c30-29bf-7fb1-9873-2214a409a83a€15.00€0.26matched
71refund01a19c30-5e97-7434-82be-b36572dd5259-€19.00€0.00matched
72capture01a19c30-9455-7ff2-ad3c-3811f97b7e53€24.00€0.37matched
73capture01a19c30-c5a9-7d61-9687-54ef6fe53e77€35.00€0.50matched
74capture01a19c30-e74d-7eae-b91f-236138bbb71a€9.00€0.19matched
75refund01a19c30-fba8-7a7c-b991-ae3a3ba26f17-€20.00€0.00matched
76capture01a19c31-2949-7640-9057-2bcd6e076ce6€49.00€0.67matched
77capture01a19c31-3498-7018-b6b9-d6d9de652d87€15.00€0.26matched
78capture01a19c31-35d8-71b5-b025-871a923b51d9€9.00€0.19matched
79capture01a19c31-3dcf-7914-815b-ccf5d6e30421€49.00€0.67matched
80capture01a19c31-4d06-7557-8329-6c833a6009ba€24.00€0.37matched
81capture01a19c31-60fd-79be-9997-f4bb34da72c8€35.00€0.50matched
82capture01a19c31-65ad-74cf-9536-43350769c6c2€15.00€0.26matched
83capture01a19c31-6a9a-738a-be43-2dc09fd571e2€35.00€0.50matched
84capture01a19c31-7993-773b-9253-b05a6f0d7de9€15.00€0.26matched
85capture01a19c31-80d2-7280-bd90-63ab21451752€9.00€0.19matched
86refund01a19c31-8f51-7da1-9758-18d361774ae9-€46.00€0.00matched
87capture01a19c31-8fdb-783e-95f5-7554263c127d€35.00€0.50matched
88capture01a19c31-a092-7a70-969c-6b4c16e5732c€24.00€0.37matched
90capture01a19c31-a267-7335-903e-a2c74c0ed1c8€35.00€0.50matched
91capture01a19c31-a3ad-72ac-9b98-0ef100aedb11€15.00€0.26matched
92capture01a19c31-b04a-7039-8991-820ab8c37bb2€35.00€0.50matched
93capture01a19c31-c704-71ff-89ea-39c15142effa€24.00€0.37matched
94refund01a19c32-0148-7dea-9397-0fd5241f016f-€7.00€0.00matched
95capture01a19c32-1467-78a3-b6e2-491928a23695€24.00€0.37matched
96capture01a19c32-1735-739d-8ca1-0a218ce432e5€24.00€0.37matched
97capture01a19c32-34d8-7b7a-b8d1-1f9536ca886b€49.00€0.67matched
98capture01a19c32-3dcb-7e58-b93d-6f3563877e92€24.00€0.37matched
99capture01a19c32-4fd7-740e-b281-f2f9df4beb6f€49.00€0.67matched
100capture01a19c32-c29d-79c9-a18b-7f428a17c38c€9.00€0.19matched
101capture01a19c32-ce54-7dad-a3f8-be6e3c1b97aa€15.00€0.26matched
102capture01a19c32-d356-792f-9ad9-dc3b33845817€49.00€0.67matched
103capture01a19c32-e2db-7461-bd67-fccb8c0b20d8€9.00€0.19matched
104capture01a19c32-f1cc-7f62-9083-feedd52da5cf€49.00€0.67matched
105capture01a19c33-00ea-7454-bed3-5023422798c1€49.00€0.67matched
106capture01a19c33-3953-7f1d-ae5f-bdb9282279cd€49.00€0.67matched
107capture01a19c33-41a5-77ec-a42d-1911cf3ee768€15.00€0.26matched
108capture01a19c33-4890-724c-a5f0-fa0ad03f33a1€15.00€0.26matched
109capture01a19c33-59a7-73cb-9f35-3cbf7353a190€9.00€0.19matched
110capture01a19c33-5f61-7a75-9a1a-8aadf4642cb1€24.00€0.37matched
111capture01a19c33-79bc-7826-86ce-885b8c25ce8c€49.00€0.67matched
112capture01a19c33-a9f8-7eb6-a6e8-abb26a915d76€35.00€0.50matched
113capture01a19c33-b2a5-7786-808e-659349c58da9€24.00€0.37matched
114capture01a19c33-bbbb-7ffd-929c-4a6fd20b0c55€24.00€0.37matched