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

Gross

€2,632.00

PSP fee

€43.83

Net to the bank

€2,588.17

Settlement journal

#413219

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b00e-0fc1-72ec-b546-0391cb12fe63 is already settled by stl_EUR_2989925 line 16
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
LineKindReferenceGrossFeeStatus
17capture01a1b00e-0feb-7bf3-b287-4ada80ce88c0€15.00€0.26duplicate line
120capture01a1b015-79f3-74b4-95c3-c8411eed573f€49.00€0.68fee difference
124capture01a1b016-0e84-73b5-b6dd-e7b4d58f6870€49.00€0.72fee difference
1capture01a1b009-72bb-7e01-ad4a-1fb21e6f8c87€24.00€0.37matched
2capture01a1b00c-d130-71ad-a419-a20ead29bf4d€15.00€0.26matched
3capture01a1b00c-efed-7c63-aba3-0e7cad079f64€35.00€0.50matched
4capture01a1b00d-0619-778c-a099-4230d8165bd5€24.00€0.37matched
5capture01a1b00d-07b1-7de2-8296-9f6e9e6a8f46€24.00€0.37matched
6capture01a1b00d-3da0-7bc3-b420-cb59e070020e€9.00€0.19matched
7capture01a1b00d-6511-7ef4-bacb-36ce99b3e5db€15.00€0.26matched
8capture01a1b00d-6f25-7e42-ba7e-43054fcce605€24.00€0.37matched
9capture01a1b00d-931c-777b-9772-c12923cf35f9€15.00€0.26matched
10capture01a1b00d-b8ae-7671-b3ab-593b63974751€24.00€0.37matched
11refund01a1b00d-e5f8-7947-b4e6-912cc3192d21-€10.00€0.00matched
12capture01a1b00d-e78a-7bf3-90ed-5b4eeaab5db2€15.00€0.26matched
13capture01a1b00e-02e8-7ab5-b0b0-b66fa1f1a51e€49.00€0.67matched
14capture01a1b00e-08d4-74b1-a32d-d64438222ba4€35.00€0.50matched
15capture01a1b00e-0aee-7988-9320-631e5ffb1ea9€49.00€0.67matched
16capture01a1b00e-0feb-7bf3-b287-4ada80ce88c0€15.00€0.26matched
18capture01a1b00e-38c3-7e4b-ac12-875eb1206a94€15.00€0.26matched
19capture01a1b00e-3ecd-7a23-b120-65ca910b84e4€24.00€0.37matched
20capture01a1b00e-4adb-7fad-a7db-20b4f5ca52c1€9.00€0.19matched
21refund01a1b00e-72ed-7c39-82d8-f94ae3ebf5a8-€3.00€0.00matched
22capture01a1b00e-7e79-77b0-aa36-f20e55984388€49.00€0.67matched
23capture01a1b00e-9c1a-7401-940e-92971b906509€15.00€0.26matched
24capture01a1b00e-a65a-7562-b5eb-d93da269b63e€24.00€0.37matched
25capture01a1b00e-bc05-71c4-b0b9-74634b3fcd9f€15.00€0.26matched
26refund01a1b00e-cabc-7d1c-bd99-a901e4d40184-€40.00€0.00matched
27capture01a1b00e-f8b1-7385-8341-234fd14cf3dd€24.00€0.37matched
28capture01a1b00f-04ad-7c64-bd34-2cf5b602803c€49.00€0.67matched
29capture01a1b00f-1c03-7f92-a326-3e9c5e2ead9e€49.00€0.67matched
30capture01a1b00f-4d4a-7093-b936-825ce58488da€15.00€0.26matched
31capture01a1b00f-65a4-7d55-9705-d45010c5e623€15.00€0.26matched
32capture01a1b00f-6bdf-744f-9fd1-7ecfe7dec231€49.00€0.67matched
33capture01a1b00f-93ba-7103-b985-c48cb6825505€9.00€0.19matched
34capture01a1b00f-9815-7266-9b93-3e62433f5f27€15.00€0.26matched
35capture01a1b00f-9d67-74e0-a400-6b271ccab1af€24.00€0.37matched
36capture01a1b00f-a6e2-7e3f-8241-6fd5e13925ff€49.00€0.67matched
37capture01a1b00f-b72e-7f0f-b6ba-43e18f89c5a2€9.00€0.19matched
38capture01a1b00f-c33f-7a0c-9af6-206d16d2bfcf€35.00€0.50matched
39capture01a1b00f-c532-7189-95fd-a31520836367€9.00€0.19matched
40capture01a1b00f-d2af-7d69-8d21-7c568d1c654f€15.00€0.26matched
41capture01a1b00f-d92a-73e7-8bd7-4be43ca5df73€49.00€0.67matched
42capture01a1b00f-dd58-77e4-9052-40bb95fda1b9€49.00€0.67matched
43refund01a1b00f-fcf6-7893-aea9-fe1d57673847-€33.00€0.00matched
44capture01a1b010-1055-7f59-9c41-4dcfccaa5c05€35.00€0.50matched
45refund01a1b010-1d42-7b12-9d13-21144ff11a26-€40.00€0.00matched
46capture01a1b010-2b16-7271-82d9-084b92c0431a€15.00€0.26matched
47capture01a1b010-2d0c-762e-9ba1-c65b592c846c€15.00€0.26matched
48capture01a1b010-55aa-7da5-aaed-5ff622e14398€24.00€0.37matched
49capture01a1b010-5a62-747a-9aa0-ba3f33df74a6€24.00€0.37matched
50capture01a1b010-615d-7268-8e86-56280e65dd3f€15.00€0.26matched
51capture01a1b010-7aa2-756b-afaa-637c47f8c279€49.00€0.67matched
52capture01a1b010-8ae6-7ca5-b8af-f9a3355d1840€49.00€0.67matched
53capture01a1b010-8eee-71fd-b51e-05d6266ae2c7€35.00€0.50matched
54capture01a1b010-93a8-7cc8-9d60-7b7da8d9cc1d€35.00€0.50matched
55capture01a1b010-bd1a-7f9d-8103-62d46103bfa5€9.00€0.19matched
56capture01a1b010-c8c7-7a23-b0bb-885601773d89€35.00€0.50matched
57capture01a1b010-fbbd-75ba-8f95-29d9b03bf199€49.00€0.67matched
58refund01a1b011-1127-7199-af21-fce3e4bea8dd-€8.00€0.00matched
59capture01a1b011-28b2-7d6b-9ff6-5d0c2a21ecbf€24.00€0.37matched
60capture01a1b011-2f27-7d39-b71f-5e7619b990fd€9.00€0.19matched
61capture01a1b011-4097-7bc4-9d88-a70c7a1fe237€15.00€0.26matched
62refund01a1b011-656e-7f68-a302-ea4df1dad203-€8.00€0.00matched
63capture01a1b011-6ca6-7238-9630-7a9108c8e89b€15.00€0.26matched
64capture01a1b011-7ce2-7c4a-8464-5a9496490e4b€15.00€0.26matched
65capture01a1b011-981b-782f-815b-874a26b5b860€35.00€0.50matched
66capture01a1b011-a653-7a84-ae48-c801db89466e€15.00€0.26matched
67capture01a1b011-ab9d-7281-813b-ca3eaa6c601d€24.00€0.37matched
68capture01a1b012-0670-77b9-b510-19fbeff596f3€35.00€0.50matched
69capture01a1b012-0d1d-7d4d-9818-8492800c1d81€15.00€0.26matched
70capture01a1b012-22e5-73ca-8c99-fc7ef1eeb36e€24.00€0.37matched
71capture01a1b012-242d-7a17-8511-91e18cd2b446€15.00€0.26matched
72capture01a1b012-4097-71a7-a298-5ca8ec66a6d0€49.00€0.67matched
73refund01a1b012-500b-7dd2-b877-ef13fb03e489-€3.00€0.00matched
74capture01a1b012-58d9-7d87-b27f-33e79d7ac204€35.00€0.50matched
75capture01a1b012-5d20-7602-b9f7-8d433ec9df16€9.00€0.19matched
76refund01a1b012-6209-7dfa-a88f-922247b4939f-€13.00€0.00matched
77capture01a1b012-7b57-72ed-aa20-07c73159bdb3€49.00€0.67matched
78capture01a1b012-8c04-79f3-a866-8ffe5e8174c2€35.00€0.50matched
79capture01a1b012-c074-7939-8265-ae8239433f49€24.00€0.37matched
80capture01a1b012-d26c-7f0a-885c-e817a8aa10c8€9.00€0.19matched
81capture01a1b012-f82d-7214-96c8-b0cfb612255f€24.00€0.37matched
82capture01a1b013-2c8f-7d38-9c66-4c6ae8ac12c1€49.00€0.67matched
83capture01a1b013-2de7-7478-b218-6768b7db4243€15.00€0.26matched
84capture01a1b013-2e00-7b23-8fcc-10d789a805fa€35.00€0.50matched
85capture01a1b013-6103-71fd-bce1-9d0d46665cc7€35.00€0.50matched
86capture01a1b013-6f61-7d16-9f2e-b9b00145dc99€49.00€0.67matched
87capture01a1b013-7548-72ee-b40e-bf5610ee290b€35.00€0.50matched
88capture01a1b013-7bd5-77cd-8add-62f40b968da9€35.00€0.50matched
89capture01a1b013-7ef8-7949-8569-f0b344d5d7e5€49.00€0.67matched
90capture01a1b013-92e7-7a1d-b32e-cadd0d74609d€49.00€0.67matched
91capture01a1b013-952a-7ed9-81c6-3d4a23c00187€15.00€0.26matched
92capture01a1b013-9cee-7aaf-9ab5-46dd8907fc1b€15.00€0.26matched
93refund01a1b013-b2cd-7ccc-8a64-b1db331a9ef8-€47.00€0.00matched
94capture01a1b013-c2f3-7de5-beef-0cecc6874f43€15.00€0.26matched
95capture01a1b013-dc5c-78b9-8b24-a5fd87b2139b€9.00€0.19matched
96capture01a1b013-fdf5-77f9-aeed-f27dff44abbc€9.00€0.19matched
97capture01a1b014-1fe8-7d91-888f-90aa3d0bd409€49.00€0.67matched
98capture01a1b014-4a42-73b8-8221-3da087bc0df1€49.00€0.67matched
99capture01a1b014-5d12-7262-8a88-12bec1ff7ad7€24.00€0.37matched
100capture01a1b014-5ff8-7e6d-8eff-e7122874205b€9.00€0.19matched
101capture01a1b014-6bfe-7cbb-b3f4-63a58477b61d€15.00€0.26matched
102capture01a1b014-7d5d-73b7-a277-a4d604dc8a1a€15.00€0.26matched
103capture01a1b014-8682-78c0-aec8-11763efab3fc€9.00€0.19matched
104capture01a1b014-86af-7d1b-a5e2-ae9b7c702167€15.00€0.26matched
105capture01a1b014-9df0-749d-8ba7-77e40424930e€35.00€0.50matched
106capture01a1b014-a446-7ec8-8e5c-2ba78d49bdcf€9.00€0.19matched
107capture01a1b014-abdb-7f1e-b295-d1b1d8a39c02€9.00€0.19matched
108capture01a1b014-ac59-7344-af23-273def7a629f€9.00€0.19matched
109capture01a1b014-d1d4-7a3c-a044-954d88a51e53€24.00€0.37matched
110capture01a1b014-ddfc-7bcb-b961-55c01ba4bebc€9.00€0.19matched
111refund01a1b014-db1a-7fc0-bd6c-c4c4059d4b81-€4.00€0.00matched
112capture01a1b015-0590-7df1-95a5-8d1429c17a54€24.00€0.37matched
113capture01a1b015-09bf-7740-b6a3-bd0524dbc083€35.00€0.50matched
114capture01a1b015-2474-7e21-bf61-43ec437e38cd€35.00€0.50matched
115capture01a1b015-3593-72c9-9220-7e2dd738d103€24.00€0.37matched
116capture01a1b015-461b-773b-90eb-54a47d93b640€9.00€0.19matched
117refund01a1b015-4833-7fcb-9890-587cb6af6e57-€20.00€0.00matched
118capture01a1b015-5da9-7edb-9238-112d4e89457e€49.00€0.67matched
119capture01a1b015-641d-7f8b-b6c3-67dd15b16f43€24.00€0.37matched
121refund01a1b015-d8dd-757a-af88-7c530196c91b-€36.00€0.00matched
122capture01a1b015-f4a3-73ca-9b95-6b58568a2efd€15.00€0.26matched
123capture01a1b016-03dd-75ac-8ede-1604e45bbacb€24.00€0.37matched