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

Gross

€2,983.00

PSP fee

€46.73

Net to the bank

€2,936.27

Settlement journal

#367477

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 3, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
  • missing linein the books, not in the filecapture:01a1a335-2be8-7eb0-8e63-19748db46898 is in no file
LineKindReferenceGrossFeeStatus
24refund01a1a32e-69d4-74bf-9c7d-52566ddf57db-€20.00€0.03fee difference
82capture01a1a332-0836-79ef-a741-92f908f4f207€9.00€0.22fee difference
115refund01a1a334-d554-7a3e-9953-7f96a2cd9cb1-€7.00€0.02fee difference
1capture01a1a323-e643-725d-976d-93a1dc2d305b€24.00€0.37matched
2capture01a1a32a-920b-7f99-bce7-df395d61a278€24.00€0.37matched
3capture01a1a32d-511a-7d7e-9db9-a6938b00b7df€15.00€0.26matched
4capture01a1a32d-56cd-7f01-946d-3a452ddf4594€49.00€0.67matched
5capture01a1a32d-62bc-7351-acd3-f781b617e89a€9.00€0.19matched
6refund01a1a32d-8fa4-76c5-b857-474c78e9e549-€4.00€0.00matched
7capture01a1a32d-92ef-707b-bf5f-baab59d75578€24.00€0.37matched
8capture01a1a32d-a47a-77fa-9728-286ccfee09e8€9.00€0.19matched
9capture01a1a32d-b180-792e-9c4d-d7c6201cb7ad€49.00€0.67matched
10capture01a1a32d-c050-71e0-bbf1-689278c693aa€15.00€0.26matched
11capture01a1a32d-e63f-7f04-a33f-827f25aba3db€9.00€0.19matched
12capture01a1a32d-e6b2-70be-a195-21bc99e3e628€24.00€0.37matched
13capture01a1a32d-ec16-72b8-92c9-c6a2473986f7€35.00€0.50matched
14capture01a1a32d-f178-7d51-bdad-fd989d80b41a€15.00€0.26matched
15capture01a1a32d-f269-77f4-ab42-13a79f938413€35.00€0.50matched
16capture01a1a32d-f512-7cd1-bbc5-30da1c0b2206€24.00€0.37matched
17capture01a1a32d-faf8-79f9-b5c3-d83737d5f3de€15.00€0.26matched
18capture01a1a32e-1b39-7115-bc61-a4d260542671€24.00€0.37matched
19capture01a1a32e-2348-7230-8a90-8311b0bbaa47€49.00€0.67matched
20capture01a1a32e-391d-7f15-849f-11bfa8133cdf€9.00€0.19matched
21capture01a1a32e-4aff-7273-a2f3-991d8f0cac16€24.00€0.37matched
22capture01a1a32e-5093-70ca-bf27-9e8f8a1199b8€49.00€0.67matched
23capture01a1a32e-5cd5-7166-aa99-3afcab0fb7a4€24.00€0.37matched
25capture01a1a32e-6cc5-7ee7-b730-e874f18be032€24.00€0.37matched
26refund01a1a32e-8855-743a-ad2b-4db2b4a539d2-€21.00€0.00matched
27capture01a1a32e-93ce-7723-ad13-63358ca331ad€35.00€0.50matched
28capture01a1a32e-96f1-7fc5-8f7c-aad485b5bb2f€49.00€0.67matched
29capture01a1a32e-a1d5-7a69-809a-efe2eb0b5fd8€24.00€0.37matched
30capture01a1a32e-b0d8-7f5c-aa0d-08b68b3a2830€24.00€0.37matched
31capture01a1a32e-bd60-7116-91d5-332dfd857c10€15.00€0.26matched
32capture01a1a32e-c678-7805-af53-bc32c5f19ec8€15.00€0.26matched
33capture01a1a32e-c6f4-72ca-af81-0c87a18ddfd1€15.00€0.26matched
34capture01a1a32e-c919-77f2-bd4a-b5125ebd25ea€49.00€0.67matched
35capture01a1a32e-dba0-7422-bf25-32ec7ede400c€9.00€0.19matched
36capture01a1a32e-dbba-7b46-b47b-6ad9d0de45b3€35.00€0.50matched
37capture01a1a32e-f6ee-79d7-b520-a158461effce€35.00€0.50matched
38capture01a1a32f-03be-7367-8076-1e2ab6e8f271€49.00€0.67matched
39capture01a1a32f-0fdb-7a94-9d36-b9c0117109f8€24.00€0.37matched
40capture01a1a32f-12a9-71ef-b13d-0869c4c2865f€49.00€0.67matched
41capture01a1a32f-2b8c-72a9-802f-da9267fbbb75€35.00€0.50matched
42capture01a1a32f-3c3f-7964-95b3-907109ed8c4e€49.00€0.67matched
43capture01a1a32f-3d0e-7d4b-ae78-270836b93853€9.00€0.19matched
44capture01a1a32f-4698-77a2-911d-b48ff30a4727€9.00€0.19matched
45capture01a1a32f-4777-73dc-8e8d-e384888900f4€24.00€0.37matched
46capture01a1a32f-633b-7aba-b9e8-04811594ba85€49.00€0.67matched
47refund01a1a32f-7256-73fd-987c-4c1d7121ba82-€3.00€0.00matched
48capture01a1a32f-765d-7455-8697-f28f65be867b€9.00€0.19matched
49capture01a1a32f-79f8-7fcd-a096-0cc0447741d6€49.00€0.67matched
50refund01a1a32f-760e-7d7d-baf9-24164725c585-€16.00€0.00matched
51capture01a1a32f-84e5-7fd9-b4a8-524323ad10d9€24.00€0.37matched
52capture01a1a32f-88f7-78f6-bd4e-203ec97dfb1b€24.00€0.37matched
53capture01a1a32f-9265-7b9f-9617-5e8857c65c10€49.00€0.67matched
54capture01a1a32f-9630-74b3-ad16-991db5f3889a€35.00€0.50matched
55capture01a1a32f-9681-7161-b9b8-a26f27efb9e3€24.00€0.37matched
56capture01a1a32f-9e8d-7752-b5b1-df2bbc6014d2€24.00€0.37matched
57capture01a1a32f-a3d5-735b-9b1c-8fca809bb430€35.00€0.50matched
58capture01a1a32f-a688-7bc4-b6ba-0c7728c332e4€9.00€0.19matched
59refund01a1a32f-a6f1-7cfa-9dfe-c742868248a2-€5.00€0.00matched
60capture01a1a32f-c968-7e61-bc96-2c340370add9€9.00€0.19matched
61capture01a1a32f-e170-7973-b6f3-8552da096980€24.00€0.37matched
62capture01a1a330-1144-791a-a41a-89a471159e19€9.00€0.19matched
63capture01a1a330-1909-74c5-a0a2-671ef36db624€9.00€0.19matched
64capture01a1a330-2876-7f4b-aa12-895040655d18€15.00€0.26matched
65capture01a1a330-3516-7da1-948d-b600a1858300€24.00€0.37matched
66capture01a1a330-665f-7007-9e96-503cb62cacec€9.00€0.19matched
67refund01a1a330-7f20-72fb-94e5-fec3b8bfa232-€8.00€0.00matched
68capture01a1a330-c18d-7cc7-aa49-c1f6f19bfaeb€24.00€0.37matched
69capture01a1a330-cb56-7751-98c0-f21203938fd6€49.00€0.67matched
70capture01a1a330-e498-7ee5-9e52-ef775fcd1371€49.00€0.67matched
71capture01a1a330-edee-717e-9ad3-d73c83c84f8f€24.00€0.37matched
72capture01a1a331-2e8b-7a14-aca7-d3719ef9a060€35.00€0.50matched
73capture01a1a331-3101-7d76-aaec-98e8534348d1€15.00€0.26matched
74capture01a1a331-47a7-72c0-8ca8-a78754716ab4€15.00€0.26matched
75capture01a1a331-5794-7cc4-9928-ec6b0c2359c3€49.00€0.67matched
76capture01a1a331-90f3-7f21-a7d5-6e1deb698164€35.00€0.50matched
77capture01a1a331-94ee-73c3-8a14-9be46ed4daba€35.00€0.50matched
78capture01a1a331-9fee-76bc-a9f8-612d4ad646fb€35.00€0.50matched
79capture01a1a331-aad3-7924-923c-9159721f20a3€24.00€0.37matched
80capture01a1a331-e312-737c-8ee4-cfdf6691180c€49.00€0.67matched
81capture01a1a332-0063-7510-b041-0bcb562bd8e4€24.00€0.37matched
83capture01a1a332-17ca-725b-973e-b35f446f578c€24.00€0.37matched
84capture01a1a332-36b0-7e0e-886e-26164c90a2f7€9.00€0.19matched
85capture01a1a332-68f5-721f-81ad-991b60cc6f82€24.00€0.37matched
86capture01a1a332-723a-71b4-abe0-0605ecb865ba€24.00€0.37matched
87capture01a1a332-84b9-73ba-827a-7783f09c6ac6€15.00€0.26matched
88capture01a1a332-94e2-7a15-a4d4-fac71be351f4€35.00€0.50matched
89capture01a1a332-b9f2-7065-a4f9-e87150e28595€24.00€0.37matched
90capture01a1a332-d526-7172-b6af-b8a1425d1bb8€24.00€0.37matched
91capture01a1a332-ed4c-7063-9bfb-bf625b3884e2€15.00€0.26matched
92capture01a1a332-f679-7616-a1e3-ab3782837629€9.00€0.19matched
93refund01a1a333-0167-79dc-9ab0-3a1e8115385a-€17.00€0.00matched
94capture01a1a333-3105-781d-96eb-db72e86d8478€15.00€0.26matched
95capture01a1a333-5097-726f-950b-7e852adfb48c€35.00€0.50matched
96capture01a1a333-589a-7194-9a47-0f41c7e8b964€9.00€0.19matched
97capture01a1a333-6a3f-77cf-a2c4-88d8fc23ab6b€24.00€0.37matched
98refund01a1a333-8b7d-77d2-8ee8-23d100933bf6-€7.00€0.00matched
99capture01a1a333-a7d4-7c73-b094-40c51f90bc99€15.00€0.26matched
100capture01a1a333-bd00-7cc1-9bf2-58462c271291€24.00€0.37matched
101capture01a1a333-d579-7f7d-a001-f4539c6e9a8f€24.00€0.37matched
102capture01a1a333-e9ff-7f76-8688-53fb4086d834€15.00€0.26matched
103capture01a1a334-0cfd-7ba8-b582-cac562fccdb9€9.00€0.19matched
104capture01a1a334-1211-7ec4-a205-802cfe68f68c€24.00€0.37matched
105capture01a1a334-2d5d-7551-ae7e-dfda705ad3ab€49.00€0.67matched
106capture01a1a334-2ff9-7981-b635-a4ded22f5790€49.00€0.67matched
107refund01a1a334-43d0-72c2-a2be-17a842fd6afa-€3.00€0.00matched
108capture01a1a334-6805-7724-8c26-955e1aadbb05€9.00€0.19matched
109capture01a1a334-8930-7909-b069-a904f3abd824€9.00€0.19matched
110capture01a1a334-a08b-7432-a601-525bf231d3ca€49.00€0.67matched
111capture01a1a334-a0ca-7256-8540-4bbb507042c7€24.00€0.37matched
112capture01a1a334-a394-7da7-a043-3cba7ec9cea1€49.00€0.67matched
113capture01a1a334-a561-7854-9828-0343e6987de8€35.00€0.50matched
114capture01a1a334-b664-7ea5-8315-960a07511ad3€15.00€0.26matched
116capture01a1a334-ec11-79dc-af0b-a089be9cb8be€49.00€0.67matched
117capture01a1a335-1dd6-7f39-97be-d62d6ba91cdf€35.00€0.50matched
118capture01a1a335-23d5-73d4-a07d-11705908bf0b€35.00€0.50matched
119capture01a1a335-52b2-7f30-b9a2-472d14ea15ed€15.00€0.26matched
120capture01a1a335-53c2-7112-8041-7acfdb56c20a€49.00€0.67matched
121capture01a1a335-6547-79d9-92d7-e5d8c1a4d592€24.00€0.37matched
122capture01a1a335-726d-7f80-a9f0-b443bf62611e€49.00€0.67matched
123capture01a1a335-809b-76a8-8d04-e0d1e32b6094€15.00€0.26matched
124capture01a1a335-c854-759d-a885-525afbc803c6€24.00€0.37matched
125capture01a1a335-deb9-79a5-9164-c9b5a02373a4€15.00€0.26matched
126capture01a1a335-e5df-7c98-9889-4f7b3365dc5b€9.00€0.19matched
127capture01a1a336-2394-7887-9ace-8ae1fa22ae77€9.00€0.19matched
128capture01a1a336-2c5e-7fdf-801c-2e88ee9aaad4€49.00€0.67matched