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

3 Nov, 22:20

Gross

€2,802.00

PSP fee

€44.18

Net to the bank

€2,757.82

Settlement journal

#368529

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • missing linein the books, not in the filecapture:01a1a385-7847-7a10-863c-c2f3483d062c is in no file
  • missing linein the books, not in the filecapture:01a1a380-eedb-73c2-9c6b-f7cc46920ff0 is in no file
LineKindReferenceGrossFeeStatus
7capture01a1a37f-c4b9-753a-bc57-a6baf440ebf0€9.00€0.22fee difference
1capture01a1a37a-826c-7761-a92d-3826a42d3269€35.00€0.50matched
2capture01a1a37d-defa-7567-81ed-dc4db7783a1e€15.00€0.26matched
3capture01a1a37e-5bb2-70cb-a4b2-8ad98eac78ce€35.00€0.50matched
4capture01a1a37f-7ac1-7839-bba8-be1f2538b437€15.00€0.26matched
5capture01a1a37f-891b-72a5-88c4-435bfa229cca€15.00€0.26matched
6capture01a1a37f-96e7-7676-9196-6b57bb34f0ae€15.00€0.26matched
8capture01a1a37f-c563-7712-92bf-0620873dbea4€24.00€0.37matched
9capture01a1a37f-e5d4-7e0a-b788-dd767a3d4b7b€9.00€0.19matched
10capture01a1a37f-f957-7eab-9da9-c29e6c2adfcc€49.00€0.67matched
11capture01a1a380-1f6b-7c1d-8248-9d5dbd272d0a€35.00€0.50matched
12capture01a1a380-402e-79a5-857a-1f8192851664€9.00€0.19matched
13capture01a1a380-4a37-74b8-b41e-4e561440a972€15.00€0.26matched
14capture01a1a380-4f07-71d5-af25-fb24180c8ab8€35.00€0.50matched
15capture01a1a380-5fbb-733a-a80c-e936e0d3e1e8€15.00€0.26matched
16capture01a1a380-6298-7aa8-8617-76bb3eaf4da9€35.00€0.50matched
17capture01a1a380-6f46-7a43-b78d-4509fa0aa678€35.00€0.50matched
18capture01a1a380-9156-7371-ae92-e4450d62fbd8€49.00€0.67matched
19refund01a1a380-9e80-78cd-9083-1e1111bd1891-€8.00€0.00matched
20capture01a1a380-d5a3-70a1-9aec-eaa0a2f74ba8€49.00€0.67matched
21capture01a1a380-d5df-7e53-b3cb-d773f38e1390€24.00€0.37matched
22capture01a1a380-e0dc-7244-99e1-15b816b27d79€15.00€0.26matched
23refund01a1a380-e789-72a0-a107-ad7823ff1836-€34.00€0.00matched
24refund01a1a381-0d62-7d06-a10b-d8c88337db2f-€7.00€0.00matched
25capture01a1a381-0d67-74eb-84b9-e8716ad235b4€49.00€0.67matched
26capture01a1a381-0f64-7914-925d-b705410c0523€49.00€0.67matched
27capture01a1a381-1a96-70e0-bffb-9ad507fe58f4€35.00€0.50matched
28refund01a1a381-2125-79e7-8291-6475ba8bb992-€17.00€0.00matched
29capture01a1a381-40ab-73b5-8f64-6d6b176bf685€9.00€0.19matched
30capture01a1a381-4ccc-7d1c-937c-fed42b0afabb€35.00€0.50matched
31capture01a1a381-55b2-77dd-9bce-cc465842cf32€24.00€0.37matched
32refund01a1a381-64e4-7379-a1ae-60bfe03ccf74-€13.00€0.00matched
33refund01a1a381-80b5-794e-ac8c-8e8c6d07edad-€5.00€0.00matched
34capture01a1a381-9296-768f-8294-4183a50d8f3f€24.00€0.37matched
35capture01a1a381-a267-7393-807d-00322c053125€35.00€0.50matched
36capture01a1a381-b935-78dd-8483-a468570eec7e€9.00€0.19matched
37capture01a1a381-c014-7bdc-b240-ff849a660b83€49.00€0.67matched
38refund01a1a381-ef1f-7245-8172-c171fc892134-€47.00€0.00matched
39capture01a1a382-010c-7aab-ac0b-b0c20ad7e697€35.00€0.50matched
40capture01a1a382-1bf2-7181-937f-4589c8a04016€24.00€0.37matched
41capture01a1a382-271e-7a15-99e0-5751b06100ac€35.00€0.50matched
42capture01a1a382-589c-772d-95fc-5dd560651eb4€15.00€0.26matched
43capture01a1a382-849a-7aaa-bf3d-136a0abc728a€9.00€0.19matched
44capture01a1a382-9e1c-7fe6-8c8c-f9aa4c09c7a6€15.00€0.26matched
45capture01a1a382-bb46-7431-a33c-f7a06281d012€35.00€0.50matched
46capture01a1a382-bf00-7936-af99-73ab22f0235d€15.00€0.26matched
47capture01a1a382-e803-790f-9b41-f4582791a07d€24.00€0.37matched
48capture01a1a382-f046-7b6d-b7be-9b142b6d2862€49.00€0.67matched
49capture01a1a382-f115-777e-a36b-07a59a8bca8b€15.00€0.26matched
50capture01a1a383-1655-70d5-b884-e3e626daf1e4€24.00€0.37matched
51capture01a1a383-2375-71dc-9039-b87f91d58a32€15.00€0.26matched
52capture01a1a383-23a3-73f9-bfeb-8fcde3c081a1€15.00€0.26matched
53capture01a1a383-3971-741b-8152-e5e54206af8a€24.00€0.37matched
54capture01a1a383-56d9-79db-bf95-28092c53ad93€24.00€0.37matched
55capture01a1a383-7312-777b-88c8-22c47f558d80€35.00€0.50matched
56capture01a1a383-7a3c-754f-a0f3-04753c930a90€15.00€0.26matched
57capture01a1a383-9827-7c6d-b1d1-59df7942e5c4€49.00€0.67matched
58refund01a1a383-9f06-7912-827d-4d56e54b9c0f-€5.00€0.00matched
59capture01a1a383-d17a-72c7-bfae-3f32b3f921b9€49.00€0.67matched
60capture01a1a383-f096-781f-911d-94d721a7dd37€9.00€0.19matched
61capture01a1a384-1968-7d03-ae34-2d05e0ea5194€9.00€0.19matched
62capture01a1a384-3288-78c6-8a4f-6de2ba2aef73€35.00€0.50matched
63capture01a1a384-3687-7652-b533-5d674ccf34ed€35.00€0.50matched
64capture01a1a384-4062-73ab-b133-c460e9c3cb56€49.00€0.67matched
65capture01a1a384-46f0-7cbb-9ab1-f32fa1be8f56€9.00€0.19matched
66capture01a1a384-7025-70d0-b5ea-7dcec2fa5b53€15.00€0.26matched
67capture01a1a384-7130-792f-a254-6ef8a92dac1c€24.00€0.37matched
68capture01a1a384-7e15-702c-b907-02d201ae7468€24.00€0.37matched
69capture01a1a384-9523-7f9a-ad58-7543a0a2900b€35.00€0.50matched
70capture01a1a384-9cd0-7c10-b72b-10730e0a66c8€15.00€0.26matched
71capture01a1a384-a9a0-744e-bc79-7110e8c58f02€9.00€0.19matched
72capture01a1a384-b199-7d4d-b8b2-b0c73a69145b€49.00€0.67matched
73capture01a1a384-d100-74ea-8382-8dac36e42e3f€49.00€0.67matched
74capture01a1a384-e61d-7f78-988c-42e87e9eb98d€24.00€0.37matched
75capture01a1a384-f867-7b53-89b4-d062a19da11d€49.00€0.67matched
76capture01a1a385-107f-7760-8a03-4732eddda81d€9.00€0.19matched
77capture01a1a385-1400-7f6d-9a33-fb7d83cf3309€9.00€0.19matched
78capture01a1a385-2a51-7763-b845-1b2af6f7ce7e€49.00€0.67matched
79capture01a1a385-35b7-73d5-93e8-d05c18c42de8€49.00€0.67matched
80capture01a1a385-56a5-717b-85cd-dfc39456ae78€35.00€0.50matched
81capture01a1a385-742f-75c6-8e28-2f852f9b2445€35.00€0.50matched
82refund01a1a385-aa3c-77bf-9fe0-77a27553bce2-€14.00€0.00matched
83capture01a1a385-b9e3-7367-90a9-7179a889a217€35.00€0.50matched
84capture01a1a385-f567-7bbb-a43e-fb3b16439814€24.00€0.37matched
85capture01a1a386-0396-723a-99d6-9021c47ad653€15.00€0.26matched
86capture01a1a386-1fde-7e75-973f-b5fc0d83bcc7€24.00€0.37matched
87capture01a1a386-7c67-739a-b749-905d4411f562€49.00€0.67matched
88capture01a1a386-8067-7ef7-a444-bc87393e0bca€49.00€0.67matched
89capture01a1a386-83cc-7184-95e3-7810b2d022d1€49.00€0.67matched
90capture01a1a386-899a-7e54-8596-df5ac1639a0a€49.00€0.67matched
91capture01a1a386-9511-7929-a645-9cafcbc7557a€35.00€0.50matched
92capture01a1a386-c0db-78cb-b7c8-3b795650f9d9€9.00€0.19matched
93capture01a1a386-c8e0-78c9-9022-fca69db0ceb8€49.00€0.67matched
94capture01a1a386-d740-7907-85f4-dd54a20feb16€15.00€0.26matched
95capture01a1a386-fbd8-79bc-a0b9-18888fc7294e€9.00€0.19matched
96capture01a1a387-0971-7211-9298-7eef4158b948€9.00€0.19matched
97capture01a1a387-0ae4-7fe1-9d2c-7c047daa3936€9.00€0.19matched
98capture01a1a387-2705-7285-9fff-d4d3ef0327aa€49.00€0.67matched
99capture01a1a387-3152-7b85-84fa-785027ceb995€15.00€0.26matched
100capture01a1a387-41d2-73a1-b548-1adbea76799f€49.00€0.67matched
101capture01a1a387-6099-793a-9895-e5c0fb4dcf8a€35.00€0.50matched
102capture01a1a387-756c-7f60-a6bd-8e2912188256€49.00€0.67matched
103capture01a1a387-7f9e-7b84-9be8-de63918073bc€24.00€0.37matched
104capture01a1a387-85ba-792e-99a1-c98b6c851c23€35.00€0.50matched
105capture01a1a387-9e4d-7a6f-81dc-2fbd3732558f€49.00€0.67matched
106capture01a1a387-bd19-7976-a27f-8911364d4bea€49.00€0.67matched
107capture01a1a387-d4ee-7e44-bba3-ebbffe8d2c1d€9.00€0.19matched
108capture01a1a388-0a12-7deb-a07e-ef2458c39951€24.00€0.37matched
109capture01a1a388-1312-7700-9523-f4ec9d45aedc€49.00€0.67matched
110capture01a1a388-1ed6-7911-a4e7-d8c51783bda3€24.00€0.37matched
111capture01a1a388-2496-7c62-9904-d9b97f79702f€9.00€0.19matched
112capture01a1a388-49e2-78f3-b1ed-3dc99bbebc92€15.00€0.26matched
113capture01a1a388-6160-7beb-968d-6fd19c515081€15.00€0.26matched
114capture01a1a388-7383-79d7-b728-dd02fa3a24c3€24.00€0.37matched
115refund01a1a388-74d6-7c96-8d73-bed85d50c65b-€10.00€0.00matched
116capture01a1a388-7eb3-71eb-9b5a-58a804599c53€9.00€0.19matched