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

2 Nov, 20:20

Gross

€2,570.00

PSP fee

€41.44

Net to the bank

€2,528.56

Settlement journal

#348809

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19deb-a45b-7a96-bc2e-f21fdc6e0180 is already settled by stl_EUR_2989418 line 10
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
LineKindReferenceGrossFeeStatus
11capture01a19deb-a4f2-7041-812a-3f238736f775€35.00€0.50duplicate line
17capture01a19dec-236b-7935-b47b-4aab1c3e13ba€49.00€0.68fee difference
77capture01a19df0-9371-75e1-ad58-b9ccc5fc0aae€15.00€0.27fee difference
1capture01a19de7-4f61-71bd-ad96-b1e401651d8a€49.00€0.67matched
2capture01a19deb-2d97-7c70-9532-fcbb30b9854c€9.00€0.19matched
3capture01a19deb-4beb-7606-8c01-c6136d6830e4€9.00€0.19matched
4capture01a19deb-5656-7386-a2cb-a1a59b838b90€9.00€0.19matched
5capture01a19deb-57d8-7a20-b9a5-24f5116ac534€9.00€0.19matched
6capture01a19deb-6064-7289-8886-34f4247fa913€9.00€0.19matched
7capture01a19deb-76d2-785f-8e9b-fbbf97c2b2c5€15.00€0.26matched
8refund01a19deb-792d-7f64-b8cb-17b700f6752e-€22.00€0.00matched
9refund01a19deb-8e04-734a-aad1-031ec3742df0-€6.00€0.00matched
10capture01a19deb-a4f2-7041-812a-3f238736f775€35.00€0.50matched
12capture01a19deb-c71e-7f98-bdba-6dc31649b332€24.00€0.37matched
13capture01a19deb-df40-70e7-8fcb-67150b921cec€24.00€0.37matched
14capture01a19deb-f132-7df0-86bd-6de1b4cb9c6c€24.00€0.37matched
15capture01a19dec-0146-74fb-af31-70b505c6b846€9.00€0.19matched
16capture01a19dec-0ded-7599-a69d-05923bea4a26€35.00€0.50matched
18capture01a19dec-2611-7bff-bcd9-5e7bf5653ba6€15.00€0.26matched
19refund01a19dec-2c0d-779e-8966-1315a6103bf3-€8.00€0.00matched
20capture01a19dec-3084-7096-8a53-18a6fbd4765f€15.00€0.26matched
21capture01a19dec-32f8-75e9-9433-6a3938dc70c2€9.00€0.19matched
22capture01a19dec-3a5a-7ca7-82a3-22b9a33fa949€9.00€0.19matched
23capture01a19dec-47d1-7441-9bf1-a93342aab062€9.00€0.19matched
24capture01a19dec-5ed8-7cb6-8de2-c6dabeecf352€9.00€0.19matched
25capture01a19dec-62f2-73e3-a6f1-b372a21b0d6b€15.00€0.26matched
26capture01a19dec-767e-7811-8e4f-b6e64a13decc€9.00€0.19matched
27capture01a19dec-832c-7358-9162-e556c670483c€24.00€0.37matched
28capture01a19ded-1dee-76d6-9b04-ab107bc271a7€35.00€0.50matched
29capture01a19ded-25fc-75fd-a55f-8197a12c0594€49.00€0.67matched
30capture01a19ded-2695-77ab-9b5f-09be10ac3236€24.00€0.37matched
31capture01a19ded-33f1-7f7f-ade5-cc6565e6f504€15.00€0.26matched
32capture01a19ded-4147-74ba-8679-ae4116ef875a€9.00€0.19matched
33capture01a19ded-46a2-7cba-abf1-e8adfc5bbec1€15.00€0.26matched
34capture01a19ded-5a8f-7f5a-94d5-165e687489ac€9.00€0.19matched
35capture01a19ded-78d1-79bf-94e3-8d7ecaee78b6€35.00€0.50matched
36refund01a19ded-7aa8-7dcb-9c11-1aa12cf39562-€18.00€0.00matched
37capture01a19ded-95a1-73a1-b9b5-91c94783c581€24.00€0.37matched
38capture01a19ded-9df0-7442-866d-d63d70f701f1€15.00€0.26matched
39capture01a19ded-cb7d-7b81-85d9-551178bbd670€35.00€0.50matched
40capture01a19ded-e25d-75f5-bfdb-f6308c198d50€24.00€0.37matched
41capture01a19ded-e547-7911-90c6-71d6cdb05223€15.00€0.26matched
42capture01a19ded-ecc2-7fab-81fa-03ffe2552950€24.00€0.37matched
43capture01a19ded-ff3a-7aa1-87c3-9dd31553f6a1€24.00€0.37matched
44capture01a19dee-1d57-75c5-b2ee-a4ca9ea10b0d€35.00€0.50matched
45capture01a19dee-219d-7933-8c42-b45232cf1eb1€24.00€0.37matched
46capture01a19dee-2278-722c-9541-e9dcedc73e77€24.00€0.37matched
47capture01a19dee-228e-761b-9cd1-28b0826563ce€9.00€0.19matched
48capture01a19dee-3269-7c93-877b-366842879125€49.00€0.67matched
49capture01a19dee-3435-7133-99c6-0bd4a60b4b11€9.00€0.19matched
50capture01a19dee-38bd-75a7-afa9-2af7b087c8a0€24.00€0.37matched
51capture01a19dee-3ce7-733f-b13b-3072f8093ba1€24.00€0.37matched
52capture01a19dee-625f-78b8-a7cf-9287e10fba08€15.00€0.26matched
53capture01a19dee-65e9-7d65-b49e-d83bf8ad00e2€15.00€0.26matched
54capture01a19dee-5f47-75fc-a40b-2faa615fd7c3€15.00€0.26matched
55refund01a19dee-6fea-7452-8a55-07fa0583198d-€21.00€0.00matched
56refund01a19dee-7b22-700d-bc44-fdc581dd8abe-€2.00€0.00matched
57refund01a19dee-83b8-7422-be31-caaf52852d65-€16.00€0.00matched
58capture01a19dee-8811-743c-9a78-a14cfdd7f217€24.00€0.37matched
59capture01a19dee-8935-777b-b0c1-ecfe0e9b8ba5€15.00€0.26matched
60capture01a19dee-bc23-7b6e-bd44-72a7fa5e5b2a€35.00€0.50matched
61capture01a19def-0107-786c-8abb-d9e6cbbaf7c5€49.00€0.67matched
62capture01a19def-02b0-7593-ae1e-3466d45bd413€9.00€0.19matched
63capture01a19def-3e3c-7948-866b-487d7721caf5€9.00€0.19matched
64capture01a19def-5216-7ff8-b783-30bedd79aeb5€15.00€0.26matched
65capture01a19def-700e-7cf9-b610-947281bdd703€24.00€0.37matched
66capture01a19def-73f4-795e-8697-539fc94b3771€15.00€0.26matched
67capture01a19def-a836-793f-ab28-b0dcb4c6b59d€35.00€0.50matched
68capture01a19def-d477-78f3-8be0-08d9586e02fe€15.00€0.26matched
69capture01a19df0-0015-7686-83f6-0df908633573€9.00€0.19matched
70capture01a19df0-02b5-7f65-9a49-f020c7721bc3€9.00€0.19matched
71capture01a19df0-0d53-7713-976a-e9008e26f87b€9.00€0.19matched
72capture01a19df0-206b-7ee7-a113-a36151935fcc€35.00€0.50matched
73capture01a19df0-376e-7f41-af76-2f2ce00bde6f€49.00€0.67matched
74capture01a19df0-4075-7d8a-8503-ea09a66b0e56€24.00€0.37matched
75capture01a19df0-5e1a-7052-a247-2be4a594fdc3€49.00€0.67matched
76capture01a19df0-8e23-7c15-848f-b43e2380484e€9.00€0.19matched
78capture01a19df0-97fb-7097-b176-5ccfd0ac5783€24.00€0.37matched
79capture01a19df0-9a73-738e-97be-c0ac3d68483a€35.00€0.50matched
80capture01a19df0-9da1-788d-ab2e-47e14e24c1be€9.00€0.19matched
81capture01a19df0-bd00-71a7-a5fe-afd4498c8d32€35.00€0.50matched
82capture01a19df0-e0c3-7942-aac5-ef881d6af362€15.00€0.26matched
83refund01a19df0-f262-70fb-957c-62b2e039c151-€4.00€0.00matched
84capture01a19df0-f38b-7312-893f-fa91d6a6af9e€35.00€0.50matched
85capture01a19df0-f6d6-73b7-97de-80c15f1006e5€35.00€0.50matched
86capture01a19df1-0278-7cca-bfa1-1857fb3079c6€35.00€0.50matched
87capture01a19df1-2c6c-7c08-9751-23f30d9fe0da€24.00€0.37matched
88capture01a19df1-41fa-74c4-b95d-845296454f1f€15.00€0.26matched
89capture01a19df1-4ee2-75ce-9945-e3609f9e46ec€24.00€0.37matched
90capture01a19df1-67f5-715d-a2ee-bac2c4645c2a€9.00€0.19matched
91capture01a19df1-b2ee-767d-9288-4d327c923d3c€15.00€0.26matched
92capture01a19df1-b413-7a3d-8436-ef09f79547c4€24.00€0.37matched
93capture01a19df1-ca02-7a0d-8731-40669c89c46b€35.00€0.50matched
94capture01a19df1-cfcf-77d5-934e-724f03e67055€24.00€0.37matched
95capture01a19df1-d292-7d3e-9526-f9679c97f6ad€49.00€0.67matched
96capture01a19df1-d9ad-77fc-a4e9-a3574768ca83€24.00€0.37matched
97capture01a19df2-00b2-7894-97b2-5073a94abc69€49.00€0.67matched
98capture01a19df2-55fd-79f6-970d-004525b38729€15.00€0.26matched
99capture01a19df2-8dd3-7ef6-bb1e-38eb827b724b€9.00€0.19matched
100capture01a19df2-97cb-7570-9886-d8698779669c€35.00€0.50matched
101capture01a19df2-9a85-7701-9885-a8b3e7be1c65€9.00€0.19matched
102capture01a19df2-b38b-79ad-8845-8576139cdb49€24.00€0.37matched
103capture01a19df2-bc44-7dbf-aec7-8fe84f28dc33€9.00€0.19matched
104capture01a19df2-c2ca-72e0-8b14-da4cd7d2b973€49.00€0.67matched
105capture01a19df2-e87f-7f41-a685-521b48e30a9f€35.00€0.50matched
106capture01a19df2-eb38-7ff6-b3a8-be7340eb91a2€15.00€0.26matched
107capture01a19df3-137d-7081-b199-c5c525a2b265€9.00€0.19matched
108capture01a19df3-2fc0-7fca-afe9-f4c82794e844€9.00€0.19matched
109capture01a19df3-4257-7807-b165-2e14a5a4f4e3€35.00€0.50matched
110capture01a19df3-4603-7b3c-b34a-ddee7b570094€9.00€0.19matched
111capture01a19df3-5ec8-7586-908c-4c1d86d77f69€15.00€0.26matched
112capture01a19df3-78e1-7755-bb94-920a9117adba€15.00€0.26matched
113capture01a19df3-8650-75bb-adec-18b050a0b256€49.00€0.67matched
114capture01a19df3-8f76-732c-bdf6-605f9d350b96€49.00€0.67matched
115capture01a19df3-8faa-7bf1-9fd5-a4b841ba5cb4€15.00€0.26matched
116capture01a19df3-9420-7bf3-9adc-6e1e38153657€49.00€0.67matched
117capture01a19df3-99c7-73d8-abce-51e1edaf2e5a€15.00€0.26matched
118capture01a19df3-9c91-79ad-99d1-eadfa7ae3bbb€35.00€0.50matched
119capture01a19df3-9dc6-7ed5-b615-ff7af85a9708€35.00€0.50matched
120capture01a19df3-f008-7976-9d3c-57025716754b€9.00€0.19matched
121capture01a19df4-0122-76e0-b406-e4a017d525f6€35.00€0.50matched
122capture01a19df4-045d-7751-90f7-17515f173ea6€24.00€0.37matched
123capture01a19df4-1a6b-7bbc-86ab-cb9a91b4a901€24.00€0.37matched
124capture01a19df4-5b93-76c8-80a9-8690f0104478€15.00€0.26matched