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

5 Nov, 09:00

Gross

€2,474.00

PSP fee

€40.17

Net to the bank

€2,433.83

Settlement journal

#394957

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aaf6-5036-7505-869e-94d57cf47085 is already settled by stl_EUR_2989782 line 82
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
LineKindReferenceGrossFeeStatus
83capture01a1aaf6-505e-78fa-b5a1-0fbf53507721€15.00€0.26duplicate line
100capture01a1aaf7-6523-716f-b222-9f9b4cdde94d€49.00€0.70fee difference
1capture01a1aaeb-2238-7315-b53e-38a41c1ad294€9.00€0.19matched
2capture01a1aaeb-aa5d-76b5-8742-ea002c7d0820€9.00€0.19matched
3capture01a1aaee-5414-7554-9d59-73a2b35ab6c9€24.00€0.37matched
4capture01a1aaef-bbaf-7778-ac2d-a6f1e6fd09bf€24.00€0.37matched
5capture01a1aaef-c6cb-7ab6-b924-a82d1c861573€15.00€0.26matched
6capture01a1aaef-dd8d-7c24-86e3-e6bbcd754310€35.00€0.50matched
7capture01a1aaef-e794-7dec-b98e-b72be5133337€24.00€0.37matched
8capture01a1aaef-fe4f-72a2-a47f-a32dfaad1ef0€9.00€0.19matched
9capture01a1aaf0-1e3b-751c-ab84-78e4b5f8a342€35.00€0.50matched
10capture01a1aaf0-6d54-7018-923b-13d3738594f0€24.00€0.37matched
11capture01a1aaf0-7fe6-7163-bbec-c80f21e58981€9.00€0.19matched
12capture01a1aaf0-8327-7d47-9dea-6776918bd4cc€15.00€0.26matched
13capture01a1aaf0-8949-76ae-8f7c-39ecb8c7ae3b€9.00€0.19matched
14capture01a1aaf0-9b7f-7768-b6ca-389e2308cea1€24.00€0.37matched
15capture01a1aaf0-b612-75ca-9d32-d1c7947bd53b€49.00€0.67matched
16capture01a1aaf0-be71-7237-8adb-561055dcd388€35.00€0.50matched
17capture01a1aaf0-ce3d-71be-99be-950fd435acc4€24.00€0.37matched
18capture01a1aaf0-dc12-7a44-ad8b-eaefd52910a3€24.00€0.37matched
19capture01a1aaf0-f4b3-776d-8de3-a358435d9424€49.00€0.67matched
20capture01a1aaf0-fbd1-7e7b-816c-5179418c16d8€15.00€0.26matched
21capture01a1aaf1-0b55-746f-8eb4-0062b869b6ce€9.00€0.19matched
22capture01a1aaf1-1f52-7a8c-972d-b76c0eebe37a€35.00€0.50matched
23capture01a1aaf1-2435-76e8-a623-e59a498f61fc€24.00€0.37matched
24capture01a1aaf1-2825-7369-b84e-a26075f79cd6€24.00€0.37matched
25refund01a1aaf1-6999-70db-adb0-3f01f16ceb9a-€25.00€0.00matched
26capture01a1aaf1-60a3-7b57-9ec7-84fd0cf0a021€49.00€0.67matched
27capture01a1aaf1-976b-7457-8c20-f362cdba6753€24.00€0.37matched
28capture01a1aaf1-9e0c-7908-a5d5-0efebf2a9d56€49.00€0.67matched
29capture01a1aaf1-a874-75b8-bae7-9fb438a438b6€49.00€0.67matched
30capture01a1aaf1-c67a-76ad-b10f-4962a27eb1f2€35.00€0.50matched
31capture01a1aaf1-c86c-7140-955c-e66c550015c0€9.00€0.19matched
32capture01a1aaf1-f1a7-76e5-bf84-d9c88ab5d4e7€35.00€0.50matched
33capture01a1aaf2-003a-7d61-afd1-5eaff5ba1de9€35.00€0.50matched
34refund01a1aaf2-1bf9-7e33-9f63-6746f1e88af9-€15.00€0.00matched
35capture01a1aaf2-489f-721a-a80b-2c37248e0282€35.00€0.50matched
36capture01a1aaf2-510c-7915-b752-e0a68a54a337€15.00€0.26matched
37capture01a1aaf2-56e5-7709-b5d5-791a4927aced€24.00€0.37matched
38capture01a1aaf2-66d1-7604-8019-e6fdffb18459€49.00€0.67matched
39capture01a1aaf2-ac4b-777a-860c-435dc9bb126e€24.00€0.37matched
40capture01a1aaf2-cb83-76d9-9377-d22d849002ca€49.00€0.67matched
41capture01a1aaf2-d07e-7be5-8032-79d485f77e22€24.00€0.37matched
42capture01a1aaf3-039c-7fc6-a88c-ac4cec7200c8€49.00€0.67matched
43capture01a1aaf3-0e5a-7a20-9a27-481e67f2e0d4€15.00€0.26matched
44capture01a1aaf3-159e-71c1-b6e5-93c3b9a30d25€15.00€0.26matched
45capture01a1aaf3-334c-7dff-ae78-d08f0dd1292e€9.00€0.19matched
46capture01a1aaf3-45f3-7a4b-af91-e5880187187e€35.00€0.50matched
47capture01a1aaf3-5165-79a4-8aa5-cbdd81a23f12€9.00€0.19matched
48capture01a1aaf3-71ca-7a0f-aa46-8ab9e8687942€9.00€0.19matched
49refund01a1aaf3-7f60-7f8e-97d8-b8fafc2a1140-€11.00€0.00matched
50capture01a1aaf3-93e3-7bbd-91b1-5192039a73cf€35.00€0.50matched
51capture01a1aaf3-aca1-7fee-b33b-c51059577b56€35.00€0.50matched
52capture01a1aaf3-b421-71d8-aad0-758a54fe371f€15.00€0.26matched
53capture01a1aaf3-bbb6-7a9c-8228-34c4db9b8298€15.00€0.26matched
54capture01a1aaf3-cc79-72c5-ace0-68601c227f72€35.00€0.50matched
55capture01a1aaf3-dec7-7dfc-a3d6-2b35b4094e7a€24.00€0.37matched
56capture01a1aaf3-dff6-7897-b287-6afc0f719894€35.00€0.50matched
57refund01a1aaf4-06b5-78d4-9318-9777ffe7d9c9-€23.00€0.00matched
58capture01a1aaf4-0ea3-7858-bcb4-2e1acb85f59c€15.00€0.26matched
59refund01a1aaf4-2630-7d4f-975d-a10a6e275d57-€21.00€0.00matched
60refund01a1aaf4-44c8-7c09-9c69-7c00ea9e8666-€32.00€0.00matched
61capture01a1aaf4-58ee-7bd0-b9e9-2d61bad2a859€9.00€0.19matched
62capture01a1aaf4-64ed-7de6-864b-d8587252f248€15.00€0.26matched
63capture01a1aaf4-6f5c-7375-9bef-3d83d0287f92€35.00€0.50matched
64capture01a1aaf4-77a3-7dc5-8241-81b10526e692€15.00€0.26matched
65capture01a1aaf4-80b6-7b79-853f-54169a5042d1€15.00€0.26matched
66capture01a1aaf4-9afe-7970-8b67-01ac2ffcb546€35.00€0.50matched
67capture01a1aaf4-aae0-7c21-8432-2f836b850e9e€15.00€0.26matched
68capture01a1aaf4-cbd5-7990-a5bb-a1d0b6689400€9.00€0.19matched
69capture01a1aaf4-df97-7063-a964-528416e29141€24.00€0.37matched
70capture01a1aaf5-0172-7fcc-ada5-0dffd1575297€9.00€0.19matched
71refund01a1aaf5-224b-7874-ae2b-445bdc0dd7c6-€8.00€0.00matched
72capture01a1aaf5-437f-70d3-a7a9-40675101fa30€9.00€0.19matched
73capture01a1aaf5-74f1-7c67-9610-25dd7e969294€15.00€0.26matched
74capture01a1aaf5-a83d-7413-8c78-9bbdb1019b57€24.00€0.37matched
75capture01a1aaf5-d4d5-75c7-be0a-0031afbefdc4€15.00€0.26matched
76refund01a1aaf5-e69a-7670-b202-cb31bfa7cde4-€10.00€0.00matched
77capture01a1aaf5-f367-7c51-a382-9a4cea38a6a1€9.00€0.19matched
78capture01a1aaf6-1d7a-79b4-9cf3-7cb34bfa587f€9.00€0.19matched
79capture01a1aaf6-2b84-7032-b94a-03c8efc0cbe9€35.00€0.50matched
80capture01a1aaf6-44d5-726a-abb2-29ff0cd59ed5€24.00€0.37matched
81capture01a1aaf6-5210-7f9f-8837-d447cbdbfd71€15.00€0.26matched
82capture01a1aaf6-505e-78fa-b5a1-0fbf53507721€15.00€0.26matched
84capture01a1aaf6-8795-7419-8e2e-6d94ba97c5a2€49.00€0.67matched
85capture01a1aaf6-8a0c-74ff-b48f-46a7a8dc9995€9.00€0.19matched
86capture01a1aaf6-8a16-708e-9134-76dad274e2c1€49.00€0.67matched
87capture01a1aaf6-8dec-7080-8403-dc5132fcaefa€24.00€0.37matched
88refund01a1aaf6-aa4f-7525-98ce-5e7434c2d634-€8.00€0.00matched
89capture01a1aaf6-b812-77fd-83fc-a414f05f1741€24.00€0.37matched
90capture01a1aaf6-bc9f-7790-827a-fd5e93bf1b61€49.00€0.67matched
91capture01a1aaf6-ba5d-724d-8aed-0cd9f315b580€9.00€0.19matched
92capture01a1aaf6-dccf-7169-9f78-efbc9193b1e0€9.00€0.19matched
93capture01a1aaf6-e308-7cbe-88fc-06ffe356e012€24.00€0.37matched
94capture01a1aaf6-f944-7445-98f5-69f32bcb2952€49.00€0.67matched
95capture01a1aaf7-001b-71df-8e8a-9dd7b74bd574€15.00€0.26matched
96capture01a1aaf7-060a-7e28-aacc-e148ddf98aa4€49.00€0.67matched
97capture01a1aaf7-1e66-799d-a7fd-6962b6d0973e€9.00€0.19matched
98capture01a1aaf7-4c83-7752-a3c2-83abf7fa3db2€24.00€0.37matched
99capture01a1aaf7-5c68-7de3-a246-ce9a3774135b€15.00€0.26matched
101capture01a1aaf7-9a41-7a23-b69b-1f6583f4cb9b€24.00€0.37matched
102capture01a1aaf7-a10c-707b-bd67-7ee33d83a199€24.00€0.37matched
103capture01a1aaf7-a801-728a-8413-16b35d10d9cf€24.00€0.37matched
104capture01a1aaf7-ac7e-7581-9261-27aa6b020bda€15.00€0.26matched
105capture01a1aaf7-bdc7-738c-a1fc-4ff572c86502€49.00€0.67matched
106capture01a1aaf7-c916-718b-b134-9bc561b98804€9.00€0.19matched
107capture01a1aaf7-cc75-7f3c-a2ff-b3d5636edcf8€49.00€0.67matched
108capture01a1aaf7-ebde-7a5b-aaa2-adabb20328a7€9.00€0.19matched
109capture01a1aaf7-f0d9-787e-8190-6c9a8f6e275f€49.00€0.67matched
110capture01a1aaf8-1004-7a93-8b5a-aef16b4b8a88€9.00€0.19matched
111capture01a1aaf8-1929-7a92-9df5-d671b5c0bb3d€24.00€0.37matched
112capture01a1aaf8-a741-70c8-a037-89c29ee7d39d€24.00€0.37matched
113capture01a1aaf8-a9d1-7b67-94f9-4aecebdb3a70€49.00€0.67matched
114capture01a1aaf8-bf2d-7619-ad60-ddd4d0087f83€15.00€0.26matched
115capture01a1aaf8-cf69-7f2f-8eb8-360f62b8bd0a€24.00€0.37matched