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

Gross

€2,867.00

PSP fee

€46.27

Net to the bank

€2,820.73

Settlement journal

#358354

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • missing linein the books, not in the filecapture:01a1a0a2-546c-7ca9-bcdb-b11895a69441 is in no file
  • missing linein the books, not in the filecapture:01a1a09c-abd9-797c-94ee-c6008e53b2e0 is in no file
LineKindReferenceGrossFeeStatus
23capture01a1a09b-69e1-704c-9a2a-9a7e0beb8818€49.00€0.70fee difference
1refund01a1a092-dccc-721d-9628-04539e5e0fdd-€5.00€0.00matched
2capture01a1a095-528f-72ce-be58-34a6c2442d4f€49.00€0.67matched
3capture01a1a097-b996-78b5-a8c7-ec286f3a1588€9.00€0.19matched
4capture01a1a099-b21c-7f55-a441-6727707bc45e€15.00€0.26matched
5capture01a1a099-e900-75dc-858b-65cc9523f601€24.00€0.37matched
6capture01a1a09a-0fca-7c57-8096-ca9290aa6547€15.00€0.26matched
7capture01a1a09a-4467-79fa-bfa4-90269d6581c1€9.00€0.19matched
8capture01a1a09a-6c9b-7826-83cb-55c5fe80c788€49.00€0.67matched
9capture01a1a09a-8b18-7840-b30e-99eba36fe04a€24.00€0.37matched
10capture01a1a09a-94c1-7225-ac7d-b4ba83247968€24.00€0.37matched
11capture01a1a09a-97d8-70f5-8fe0-3e55ae76e6de€49.00€0.67matched
12capture01a1a09a-9926-7d6e-a812-43102e4b404c€15.00€0.26matched
13capture01a1a09a-9ad0-71ff-8ec3-03eed552a159€35.00€0.50matched
14capture01a1a09a-babb-7b9a-8a92-5cbd15d1dc8c€24.00€0.37matched
15capture01a1a09a-b682-7467-a611-81f8e5ff0f4e€9.00€0.19matched
16capture01a1a09a-c416-73ed-be81-f494fc31ab7e€35.00€0.50matched
17capture01a1a09b-104e-71e4-bd44-258af471c14e€49.00€0.67matched
18capture01a1a09b-1289-7272-9f41-7f83c28e6b36€15.00€0.26matched
19capture01a1a09b-2d46-7dd9-9cb8-62a4f6fe83b5€15.00€0.26matched
20capture01a1a09b-3c03-781f-a0f9-7168814a0190€24.00€0.37matched
21capture01a1a09b-3f09-7620-93fa-3dc992525caf€24.00€0.37matched
22refund01a1a09b-511c-7320-b3fa-cd4ae8d3a2b9-€44.00€0.00matched
24capture01a1a09b-80c0-76f7-be1b-f4c387464282€49.00€0.67matched
25capture01a1a09b-81ab-79a5-a5ac-741a449a06b3€49.00€0.67matched
26capture01a1a09b-900d-729c-a930-f11c7c68b48f€24.00€0.37matched
27capture01a1a09b-a56f-7951-812e-dcffd6b13777€24.00€0.37matched
28capture01a1a09b-b5f4-7092-855a-4e7488628fd7€15.00€0.26matched
29refund01a1a09b-c2da-7366-9d1d-804c7cddd19a-€21.00€0.00matched
30capture01a1a09b-d4c8-7f1a-8c98-2d064b1f9d95€35.00€0.50matched
31capture01a1a09b-dc45-7ab0-b669-c6f1d43cd467€24.00€0.37matched
32refund01a1a09c-1d11-77db-baed-d9d70c10e1b1-€4.00€0.00matched
33capture01a1a09c-1ee7-71af-b107-977408f334ea€24.00€0.37matched
34capture01a1a09c-312b-7185-babe-bc4175299c7c€15.00€0.26matched
35capture01a1a09c-57d4-7463-816e-6e843ff983c6€15.00€0.26matched
36capture01a1a09c-5ecd-7000-9093-b5777fdf13c6€9.00€0.19matched
37capture01a1a09c-6971-7d51-86d4-2d421b6ed618€9.00€0.19matched
38capture01a1a09c-8509-71a3-982e-7d357b48e671€24.00€0.37matched
39capture01a1a09c-a03e-70f4-8998-3fedf00bd5ca€49.00€0.67matched
40capture01a1a09c-bb87-7454-a31d-f14bee048b71€35.00€0.50matched
41capture01a1a09c-ed79-7dac-b76a-8c4f4f9aa74f€15.00€0.26matched
42capture01a1a09c-ee18-7d09-8b4c-68ad0b8751df€9.00€0.19matched
43capture01a1a09d-2610-72f0-b745-59bdddbfaaf3€49.00€0.67matched
44capture01a1a09d-2696-7f68-a911-ae52a882452f€24.00€0.37matched
45capture01a1a09d-2748-7ec8-b808-93ab90b855bd€9.00€0.19matched
46capture01a1a09d-2935-7431-8376-da758f95f94d€9.00€0.19matched
47capture01a1a09d-2f2b-79a1-9088-118abd80a035€35.00€0.50matched
48capture01a1a09d-464a-72d9-b073-214719282b0a€24.00€0.37matched
49capture01a1a09d-4c52-7f05-bf14-78189e3d3238€35.00€0.50matched
50capture01a1a09d-55bd-7f1b-9795-7cb16116ca85€35.00€0.50matched
51capture01a1a09d-6340-73ea-9a81-d6a0d35987ec€15.00€0.26matched
52capture01a1a09d-6576-783d-b1f8-2e0663d76dc8€35.00€0.50matched
53capture01a1a09d-8e4e-73aa-9b97-0ed4e1c4cd2f€24.00€0.37matched
54capture01a1a09d-8f71-7788-a626-8527408c87f0€24.00€0.37matched
55capture01a1a09d-a432-7475-9b1f-06ea09e3162b€24.00€0.37matched
56capture01a1a09d-b827-7497-97e9-1c59735f923f€49.00€0.67matched
57capture01a1a09d-c9bf-7ffa-9759-4048983035f4€9.00€0.19matched
58capture01a1a09d-e008-70d0-8d3a-5a01e82f611a€49.00€0.67matched
59capture01a1a09d-e10d-769c-bcc1-aa4cbc9fa0ea€35.00€0.50matched
60capture01a1a09d-e34f-7530-94a8-2cee0dc4b4aa€15.00€0.26matched
61capture01a1a09d-e801-79f9-96f8-683965e7c8f9€15.00€0.26matched
62capture01a1a09d-ed15-7d1f-90af-b97b554e790b€15.00€0.26matched
63capture01a1a09d-f40a-7db8-8307-6fddb151a863€49.00€0.67matched
64refund01a1a09e-0bbb-7d07-8f40-32166e1717e4-€20.00€0.00matched
65capture01a1a09e-209a-7a31-8776-ef6f79d85b4e€35.00€0.50matched
66capture01a1a09e-2d2e-779b-a424-96026ad74ac7€15.00€0.26matched
67capture01a1a09e-5534-785e-a9ff-a8f499c139f1€15.00€0.26matched
68capture01a1a09e-6a2a-7a16-9cdc-d14fe693b7e1€9.00€0.19matched
69refund01a1a09e-921a-75a6-b8f9-c21b1ca63dd1-€3.00€0.00matched
70capture01a1a09e-9ed8-717b-8a5b-b8d27fd5f3fe€9.00€0.19matched
71capture01a1a09e-a10c-7ba0-b0b3-30fbcc4fc1f0€35.00€0.50matched
72capture01a1a09e-b57c-7aa9-a75e-e9df7a4df842€15.00€0.26matched
73capture01a1a09e-be34-74d9-88e9-bdab99711744€49.00€0.67matched
74capture01a1a09e-c61c-769f-8536-3aabb164eb07€49.00€0.67matched
75capture01a1a09e-c880-7299-897a-c3af340c3691€49.00€0.67matched
76refund01a1a09f-06ac-7046-b613-edf506d39e1b-€28.00€0.00matched
77capture01a1a09f-29ed-7ab7-a25f-d95d74760c85€49.00€0.67matched
78capture01a1a09f-3f93-7695-b90e-f327747d1b88€49.00€0.67matched
79capture01a1a09f-43ca-7f38-a0b5-7bfc0a6681b1€9.00€0.19matched
80capture01a1a09f-4d5c-7386-be30-2bba4d555b91€15.00€0.26matched
81capture01a1a09f-5027-76db-84a1-b3319e605e87€24.00€0.37matched
82capture01a1a09f-5791-7577-ae2c-3761f9790f4d€49.00€0.67matched
83capture01a1a09f-6b5b-70be-bca5-f600221969c3€49.00€0.67matched
84capture01a1a09f-7be3-70e0-8577-06ad585bb494€15.00€0.26matched
85capture01a1a09f-825f-711a-96b6-5a14bb099673€15.00€0.26matched
86capture01a1a09f-8ebd-7905-ad59-97c4171eaee5€24.00€0.37matched
87capture01a1a09f-b0f3-74c8-9802-6be83aebb97f€9.00€0.19matched
88capture01a1a09f-b205-7c4f-ba3b-b404ef437f8f€9.00€0.19matched
89capture01a1a09f-bbb3-7abb-a461-9a2c0fe971ce€15.00€0.26matched
90capture01a1a09f-ee6f-7b67-b876-13b92aceabc6€49.00€0.67matched
91capture01a1a09f-f460-7219-9381-460e7d2d5713€49.00€0.67matched
92capture01a1a0a0-25bd-752a-aaec-1caaff70d5a7€24.00€0.37matched
93capture01a1a0a0-53fb-757a-992a-894f76d16d44€35.00€0.50matched
94capture01a1a0a0-54f7-7294-916f-90fa99b1fe83€24.00€0.37matched
95capture01a1a0a0-6e83-7987-b2f4-cc000f75cd57€9.00€0.19matched
96capture01a1a0a0-89b5-7393-8ea8-25a054e850c0€49.00€0.67matched
97refund01a1a0a0-9c57-7042-adaf-710c5b4a53c2-€20.00€0.00matched
98capture01a1a0a0-b283-743d-8078-5c5115c72f5b€9.00€0.19matched
99capture01a1a0a0-f78f-78da-86da-03034e9ae0a6€35.00€0.50matched
100capture01a1a0a1-07b0-78b5-8e1f-adcd9c78dd25€35.00€0.50matched
101capture01a1a0a1-3d4e-746c-af33-98977d428802€15.00€0.26matched
102capture01a1a0a1-45da-7d6e-8791-fdea66eb569a€35.00€0.50matched
103capture01a1a0a1-5db4-742c-bbb6-aea75f1b57f2€49.00€0.67matched
104capture01a1a0a1-b9b8-7f2c-9ca7-843bbcee999a€15.00€0.26matched
105capture01a1a0a1-c1b4-7fdf-9be4-47881dbe67f5€15.00€0.26matched
106capture01a1a0a1-c6e2-70d0-ab8b-d28627b61b16€35.00€0.50matched
107capture01a1a0a1-d077-73a7-b34f-50e5758cb486€35.00€0.50matched
108capture01a1a0a1-d73e-7095-9841-25315dde9a05€35.00€0.50matched
109capture01a1a0a1-ea4e-71b4-9ece-7424c7b58084€24.00€0.37matched
110capture01a1a0a1-ee1a-7894-8ea7-1690f0ce5097€24.00€0.37matched
111capture01a1a0a2-0516-7173-8ddb-4c1cdd28b0c0€15.00€0.26matched
112refund01a1a0a2-13b5-7a8a-afb8-7aa979ace173-€22.00€0.00matched
113capture01a1a0a2-16c2-7f80-91fd-1cac35870dbb€49.00€0.67matched
114refund01a1a0a2-27eb-7d0f-a6b4-078808cd6741-€17.00€0.00matched
115refund01a1a0a2-2ff3-7cf0-b512-7fc20d24b035-€31.00€0.00matched
116capture01a1a0a2-4b10-75ff-9b7e-ec3adad5af2e€49.00€0.67matched
117capture01a1a0a2-5854-7034-b37d-280cf85410ee€9.00€0.19matched
118capture01a1a0a2-76cc-7c12-a499-ac8977c0d23f€15.00€0.26matched
119capture01a1a0a2-7f85-7bfd-80ef-42682e4a8cd5€15.00€0.26matched
120capture01a1a0a2-8f4e-7bd7-b7d0-34bafdb37647€9.00€0.19matched
121capture01a1a0a2-90f2-7be5-a181-aa06d6d690fb€35.00€0.50matched
122capture01a1a0a2-9615-7d39-8790-6fd42cb811d8€24.00€0.37matched
123capture01a1a0a2-9c6a-73ce-95bd-b85245c37315€24.00€0.37matched
124capture01a1a0a2-e599-73f8-8105-41524ecb83cf€15.00€0.26matched
125capture01a1a0a2-f48e-7958-8921-9c63401819fd€49.00€0.67matched