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

Gross

€2,697.00

PSP fee

€43.17

Net to the bank

€2,653.83

Settlement journal

#416721

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • missing linein the books, not in the filerefund:01a1b105-697d-7525-857a-809a8ad37875 is in no file
LineKindReferenceGrossFeeStatus
82capture01a1b109-96cb-7374-8e36-3b7f2f8efa7b€35.00€0.54fee difference
1capture01a1b0fc-f1c4-73fb-a2b2-6a50a05d6972€24.00€0.37matched
2capture01a1b0fc-f0b2-70af-b716-4f55153abb4d€9.00€0.19matched
3capture01a1b101-307b-7627-b40d-c1e47318a8bd€24.00€0.37matched
4capture01a1b103-6857-720a-842d-272e27e54285€49.00€0.67matched
5capture01a1b103-b8da-74ee-b827-1e7959e62a76€15.00€0.26matched
6capture01a1b104-2440-7616-ba86-7f2e428449ab€15.00€0.26matched
7capture01a1b104-4ec4-71de-b6fe-0a7760bc63ec€35.00€0.50matched
8capture01a1b104-5032-75ff-8da3-6700cc6deaac€9.00€0.19matched
9capture01a1b104-75c8-7f2c-8102-082120d6926b€24.00€0.37matched
10capture01a1b104-8470-74d5-8ed2-5d4f67b08505€49.00€0.67matched
11capture01a1b104-aed6-7d0b-ab51-ea603e0a5205€24.00€0.37matched
12capture01a1b104-d839-7efd-b118-38bd184e2b73€9.00€0.19matched
13capture01a1b104-e09c-7ba2-9099-d447f05842fb€15.00€0.26matched
14capture01a1b104-f364-738a-9bb2-f189200027f7€9.00€0.19matched
15capture01a1b104-f50c-786a-b826-f643451a90df€35.00€0.50matched
16capture01a1b105-0aaf-7e44-b9d1-00a5bd6ddf60€24.00€0.37matched
17capture01a1b105-0e0b-79cc-8299-21c97f3b01c1€24.00€0.37matched
18capture01a1b105-1c28-7e29-afbe-1ea4cf4558f3€9.00€0.19matched
19capture01a1b105-263a-7502-8995-38cd739979a6€49.00€0.67matched
20capture01a1b105-3a6c-7791-a4f5-fea33c605825€49.00€0.67matched
21refund01a1b105-3caa-70bd-b901-125490306e8c-€4.00€0.00matched
22capture01a1b105-40f2-7c0f-87e1-dcd3d73fae2a€9.00€0.19matched
23capture01a1b105-4ffe-781e-b098-688add5eddb0€15.00€0.26matched
24refund01a1b105-6616-734e-869f-bfce39931ddb-€34.00€0.00matched
25capture01a1b105-7cd3-74f8-8f87-9b77cece11a0€9.00€0.19matched
26capture01a1b105-8643-7887-8d68-40a76fd79f69€9.00€0.19matched
27refund01a1b105-9070-7773-9506-735dcc0661d3-€42.00€0.00matched
28capture01a1b105-b37d-752e-b2e9-cf141aa04b05€9.00€0.19matched
29capture01a1b105-b7c7-7543-a6c7-044df6e76084€9.00€0.19matched
30capture01a1b105-c38d-784d-9ed3-2dbf053828ff€15.00€0.26matched
31capture01a1b105-cbad-70b4-b472-8924b60324fe€49.00€0.67matched
32capture01a1b105-cf48-75f4-ad2d-4a14046d9057€49.00€0.67matched
33capture01a1b105-d6cc-7a73-aa94-6826bf7d8ae4€9.00€0.19matched
34capture01a1b105-e58e-7103-9608-0f735028d5a9€35.00€0.50matched
35capture01a1b105-ec63-72af-8069-24731f56647c€9.00€0.19matched
36capture01a1b106-02b0-7258-b7e7-3c9f0a498fd7€49.00€0.67matched
37capture01a1b106-48d2-71c7-b131-1be7690bf2da€24.00€0.37matched
38capture01a1b106-4c57-7ce3-b72a-c83d3f828acf€49.00€0.67matched
39capture01a1b106-4e3b-78a8-b6fe-eab4a61c6728€9.00€0.19matched
40capture01a1b106-4e9d-735b-85e6-cb33509671aa€9.00€0.19matched
41capture01a1b106-535d-7199-9cff-aae879421468€35.00€0.50matched
42capture01a1b106-7b33-7f68-8a4b-dd3f40389763€24.00€0.37matched
43capture01a1b106-aba6-782a-b37b-463141a354b9€15.00€0.26matched
44capture01a1b106-b7e9-71c5-9a20-a151790aface€15.00€0.26matched
45capture01a1b106-dbea-79c9-9318-2b538701faac€9.00€0.19matched
46capture01a1b106-e3ab-77ff-83ba-6d7e7037363b€9.00€0.19matched
47capture01a1b106-e330-7bb8-b386-9c1c6db242a4€49.00€0.67matched
48capture01a1b106-e7cd-7110-879c-617be59bbdf8€35.00€0.50matched
49capture01a1b106-eea9-76a0-8f4d-3870873de960€35.00€0.50matched
50capture01a1b106-f08d-7060-93ff-2ff66c1fb438€35.00€0.50matched
51capture01a1b107-0011-72a0-8cda-eb8bb5b185a6€49.00€0.67matched
52capture01a1b107-16fa-73b9-bec1-505069e3a911€15.00€0.26matched
53capture01a1b107-458c-7916-be09-5ced31ff4720€9.00€0.19matched
54capture01a1b107-48a8-7da1-8361-f6357ffbe796€15.00€0.26matched
55capture01a1b107-56b1-7514-be97-653fd976cb66€35.00€0.50matched
56capture01a1b107-56df-7fa4-aa1a-10a14503e9d8€49.00€0.67matched
57capture01a1b107-5f77-7406-a816-26f4c5bc82be€9.00€0.19matched
58capture01a1b107-ae79-7855-aa17-8a7f5f9d9ceb€49.00€0.67matched
59capture01a1b107-d722-7e51-b6f3-f4ab8f44d31f€49.00€0.67matched
60capture01a1b107-e48f-748a-9c0b-8e83df6a1e16€24.00€0.37matched
61capture01a1b107-fcfb-7ecf-85fa-7942e79b2725€49.00€0.67matched
62capture01a1b108-040f-718d-992d-5aa180b65834€9.00€0.19matched
63capture01a1b108-0601-738d-a456-7f44089d248d€49.00€0.67matched
64capture01a1b108-08d4-7587-9b61-7406f928d83e€15.00€0.26matched
65capture01a1b108-0b2b-77d7-9cc5-cb8550f75f7f€15.00€0.26matched
66capture01a1b108-561e-7dc7-8d1e-af808cc616a0€15.00€0.26matched
67capture01a1b108-5c60-767c-8232-8ed6401c3f96€35.00€0.50matched
68capture01a1b108-6af1-7620-82bb-00080e0a953f€35.00€0.50matched
69capture01a1b108-71d1-795e-a8d1-98f6eecdef40€15.00€0.26matched
70capture01a1b108-a794-7f74-8ea4-c882c5286802€35.00€0.50matched
71refund01a1b108-bb99-7c80-afb1-49f180bcb081-€5.00€0.00matched
72capture01a1b108-bdfb-710c-857d-7ff396a0d68c€24.00€0.37matched
73capture01a1b108-d6ba-72d9-ab8a-10f8e20d4ded€49.00€0.67matched
74capture01a1b108-dbd3-7e5c-a454-ada013ae95e2€9.00€0.19matched
75capture01a1b108-dbcc-77d6-86b6-665910ffe1c2€49.00€0.67matched
76capture01a1b108-e785-76e9-b311-3a1995419756€9.00€0.19matched
77capture01a1b108-ee5d-7758-aa9a-ada546516870€24.00€0.37matched
78capture01a1b108-fd03-7e58-baf4-570fc3c20225€15.00€0.26matched
79capture01a1b109-0981-74c1-b00c-61e47891c7e4€15.00€0.26matched
80capture01a1b109-3a8a-756a-934c-02b5e60dc3a8€35.00€0.50matched
81capture01a1b109-7549-7654-811b-86c0d43f24f0€49.00€0.67matched
83capture01a1b109-9e25-74f9-8be0-bb4a4c930aad€49.00€0.67matched
84capture01a1b109-bb1c-74ca-a60b-dfe68cf9996c€35.00€0.50matched
85capture01a1b109-ca47-789e-ad65-040478f6534a€15.00€0.26matched
86capture01a1b109-fc0a-7974-8760-0c7b34bcfb40€24.00€0.37matched
87capture01a1b10a-2151-75e1-a8f1-30bd54fb3ff9€24.00€0.37matched
88capture01a1b10a-365f-7d84-b281-73c1c2f54783€9.00€0.19matched
89capture01a1b10a-59bb-7915-8fcc-e42387a0ea43€9.00€0.19matched
90capture01a1b10a-d5fc-7fd8-a701-09db5c934af3€24.00€0.37matched
91capture01a1b10a-defe-705d-b50e-c53a2328e909€35.00€0.50matched
92capture01a1b10a-ed8d-788a-ad06-876fb74c7065€24.00€0.37matched
93capture01a1b10b-0687-7a83-8b9a-30e94866bab0€15.00€0.26matched
94capture01a1b10b-10ae-763b-94cc-f7d49b4bff28€9.00€0.19matched
95capture01a1b10b-255f-7202-942a-af84dc753ef2€24.00€0.37matched
96capture01a1b10b-3216-706a-98fa-8228da9d980a€9.00€0.19matched
97capture01a1b10b-4558-794f-a969-f6394d99465e€9.00€0.19matched
98capture01a1b10b-494b-700f-99d1-6e32fa0af21c€24.00€0.37matched
99capture01a1b10b-776e-7f38-af7e-8aa466048bab€9.00€0.19matched
100refund01a1b10b-7fc4-7cf9-a813-8a6d08a61d3d-€6.00€0.00matched
101capture01a1b10b-95fa-731d-9e5d-e33c3a3db110€15.00€0.26matched
102capture01a1b10b-b610-7267-9303-73764173adbc€9.00€0.19matched
103capture01a1b10b-bc08-7b47-9ecc-c249b6180e29€15.00€0.26matched
104capture01a1b10b-ccb6-7d38-a94e-fba24d718d6a€24.00€0.37matched
105capture01a1b10b-e471-7e29-874c-c444efd97586€49.00€0.67matched
106capture01a1b10b-f2da-74d3-8206-c0aebc3c5446€49.00€0.67matched
107capture01a1b10c-33f6-7f6d-ac10-0b8aab9c6723€15.00€0.26matched
108capture01a1b10c-4259-72be-81c8-8059fee63bf8€15.00€0.26matched
109capture01a1b10c-6b2c-7df2-a3fa-aad0a1386716€9.00€0.19matched
110capture01a1b10c-7342-7f33-a3cc-9f7f80bc4682€9.00€0.19matched
111capture01a1b10c-799c-7f06-ba93-4fa7cf7b3024€9.00€0.19matched
112capture01a1b10c-7fba-7209-943e-9236d17ba57e€24.00€0.37matched
113capture01a1b10c-8b38-7cf0-9917-7f5de9605afb€9.00€0.19matched
114capture01a1b10c-b48a-77be-aec3-127917174059€24.00€0.37matched
115capture01a1b10c-b533-7a8a-885f-3c48badfc04f€15.00€0.26matched
116capture01a1b10c-b9c3-7064-9da6-a2adb4f72c76€15.00€0.26matched
117capture01a1b10c-c0b4-7e3f-bed3-522a361c21e3€15.00€0.26matched
118refund01a1b10c-e931-72bf-b867-fdb28200e0a1-€4.00€0.00matched
119capture01a1b10c-e9ab-734b-9daf-dec42a305d3d€15.00€0.26matched
120capture01a1b10c-fe72-7571-9695-a9c6b99abaf9€15.00€0.26matched
121capture01a1b10d-1883-7252-9b42-0da3a1f455e4€24.00€0.37matched
122capture01a1b10d-190f-70a2-b0e3-2d898fabe0a1€9.00€0.19matched
123capture01a1b10d-22c3-7a54-a349-8161ce4a0bfa€35.00€0.50matched
124capture01a1b10d-261c-742f-b349-e7cd97a175ba€15.00€0.26matched
125refund01a1b10d-28c2-7e92-b711-b7160c30c233-€3.00€0.00matched