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, 11:40

Gross

€3,321.00

PSP fee

€52.43

Net to the bank

€3,268.57

Settlement journal

#360473

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a137-4a4c-7b48-9907-ce989a86f876 is already settled by stl_EUR_2989510 line 18
  • duplicate linethe file lists it twicecapture:01a1a138-119e-79fb-bfd5-1942edbc8269 is already settled by stl_EUR_2989510 line 28
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
LineKindReferenceGrossFeeStatus
1capture01a1a12c-73a7-79d2-9079-6244c9d377ec€49.00€0.71fee difference
19capture01a1a137-4a69-7bb1-8126-b1d7770fd918€15.00€0.26duplicate line
29capture01a1a138-11b7-7485-ab30-b69a19b51425€24.00€0.37duplicate line
76capture01a1a13a-2266-7cf9-8e0f-33ca82086019€35.00€0.55fee difference
133capture01a1a13d-cbcd-7f5b-aaf5-0f69e9a57a92€9.00€0.21fee difference
2capture01a1a132-eaf3-7cff-8515-00aeeb81092d€35.00€0.50matched
3capture01a1a135-8aac-71b3-b49e-a4bc1848406e€9.00€0.19matched
4capture01a1a136-1eee-7bf9-8199-8b3105fb0548€49.00€0.67matched
5capture01a1a136-4f0f-72a0-a1c4-b4ea0b6a671e€35.00€0.50matched
6capture01a1a136-5a96-7d84-9099-66a8e7a96ebc€24.00€0.37matched
7capture01a1a136-6737-7a0f-a0bd-a048954f25de€35.00€0.50matched
8capture01a1a136-7716-7b97-a237-e5dc6963cd6d€49.00€0.67matched
9refund01a1a136-8b03-73e9-b49c-9c243693e40f-€14.00€0.00matched
10capture01a1a136-ab20-78da-86b3-9635ba42ffca€24.00€0.37matched
11capture01a1a136-d6a9-7fd3-a3ae-defcf070de39€24.00€0.37matched
12capture01a1a136-fb56-7e4c-a3d2-e4040a896ff9€24.00€0.37matched
13capture01a1a136-feba-71a3-887e-468083ff50e4€9.00€0.19matched
14capture01a1a137-0738-7035-af64-ce8905247417€49.00€0.67matched
15capture01a1a137-38be-749d-85c9-9a5584ea4a2d€9.00€0.19matched
16capture01a1a137-3bf9-7396-b4ad-8330af0b563c€24.00€0.37matched
17capture01a1a137-4051-78b8-95e6-76840034208b€49.00€0.67matched
18capture01a1a137-4a69-7bb1-8126-b1d7770fd918€15.00€0.26matched
20capture01a1a137-8d82-7451-b0f3-5b73c74c06b5€35.00€0.50matched
21capture01a1a137-bec4-7d63-8273-b38da889e6ff€15.00€0.26matched
22capture01a1a137-bf9a-7bec-a842-70d06921c498€24.00€0.37matched
23capture01a1a137-cb0c-7d2f-b2d0-b9e4da4f2efc€9.00€0.19matched
24capture01a1a137-f8e2-7e01-81d8-b6976ba83ee1€9.00€0.19matched
25capture01a1a137-fa0c-792c-a59b-e26863484f8d€49.00€0.67matched
26capture01a1a138-029a-7799-aa1a-f726af2b4373€9.00€0.19matched
27capture01a1a138-0beb-7c17-932c-548c1a1cd2e4€35.00€0.50matched
28capture01a1a138-11b7-7485-ab30-b69a19b51425€24.00€0.37matched
30capture01a1a138-1eac-70fc-b3f1-79b87d240688€49.00€0.67matched
31capture01a1a138-2c66-78c7-b1f8-b599df0b499f€9.00€0.19matched
32capture01a1a138-3771-7bcb-9697-41512101baec€49.00€0.67matched
33capture01a1a138-3c48-7a5c-bc82-dc80df66b59e€24.00€0.37matched
34refund01a1a138-3fd6-7b2f-9105-d6932bb6b7ce-€4.00€0.00matched
35capture01a1a138-4d94-7c47-afa4-6edf82061c48€24.00€0.37matched
36capture01a1a138-558f-7fc6-baf1-074573763484€24.00€0.37matched
37capture01a1a138-5bc2-747e-8043-cd9dfbb623ea€35.00€0.50matched
38refund01a1a138-5cc2-737d-88af-1c10ed3c0943-€4.00€0.00matched
39capture01a1a138-63ec-7e8e-9a7c-ac55a767a952€35.00€0.50matched
40capture01a1a138-6e91-718a-ba5c-e87be2e12b1c€24.00€0.37matched
41capture01a1a138-709a-7a7c-9781-a501228c445c€49.00€0.67matched
42capture01a1a138-7470-722a-9bcb-c412dcce0d86€15.00€0.26matched
43capture01a1a138-80c2-7edd-8c57-858fa0ab3aca€9.00€0.19matched
44capture01a1a138-8515-7278-abcf-0d1b6096bbdb€24.00€0.37matched
45capture01a1a138-8a75-78cf-b94c-ff28161b68bb€15.00€0.26matched
46capture01a1a138-8fed-7309-a32c-d55b6b897c69€9.00€0.19matched
47capture01a1a138-a449-74cb-bf70-12dc44570aaa€35.00€0.50matched
48capture01a1a138-b703-74aa-8045-3b1d8e830139€49.00€0.67matched
49capture01a1a138-b7bd-7122-92c9-90ead731d0ab€9.00€0.19matched
50capture01a1a138-c9fb-7e5d-adf4-7769ae739894€49.00€0.67matched
51capture01a1a138-cda1-745b-8ad1-ad10f7753531€35.00€0.50matched
52capture01a1a138-d581-7076-880c-3435149430e9€35.00€0.50matched
53capture01a1a138-e109-7c8e-97b8-7ee05fc33458€15.00€0.26matched
54capture01a1a138-e7a2-753d-aa51-d4bd358aa9ae€15.00€0.26matched
55capture01a1a138-e7b5-7761-8dde-541fbd9c5cfe€24.00€0.37matched
56capture01a1a138-eb8d-776b-b290-f5021a478395€35.00€0.50matched
57refund01a1a139-0476-7214-b4d5-aac1ae384b3f-€8.00€0.00matched
58capture01a1a139-1f7f-7bfd-8773-8c54f62eae84€49.00€0.67matched
59capture01a1a139-270b-7aa3-878e-2ee39eb8630a€24.00€0.37matched
60refund01a1a139-4878-70f9-8c00-fdbb46453ba1-€14.00€0.00matched
61refund01a1a139-55e8-7740-affc-0cdbe7732aad-€4.00€0.00matched
62capture01a1a139-5681-7a06-85d5-ed012f31a0d6€9.00€0.19matched
63capture01a1a139-568d-7292-a0eb-0c0ef787aa85€49.00€0.67matched
64capture01a1a139-5ab4-7854-a678-beb64689dc3b€9.00€0.19matched
65capture01a1a139-7cad-7f74-8f3b-910f5d994a8f€35.00€0.50matched
66capture01a1a139-876e-7feb-bc7d-eac7ecd51fef€35.00€0.50matched
67capture01a1a139-9676-7ef7-99c4-6c9e9d60e3d2€9.00€0.19matched
68capture01a1a139-b0e6-7415-9886-b3892200ee01€15.00€0.26matched
69capture01a1a139-df5f-78ea-8f1d-a65d0e639f1d€24.00€0.37matched
70capture01a1a139-eff0-7aa6-9c96-eca275d8af52€9.00€0.19matched
71capture01a1a13a-0259-76b5-be67-cacd8383c0c9€49.00€0.67matched
72capture01a1a13a-0a5a-76ed-8cc7-98990c9eb04c€24.00€0.37matched
73capture01a1a13a-0d58-7d67-addd-8b26def60197€35.00€0.50matched
74capture01a1a13a-1015-7e0a-90db-a00d99bab671€35.00€0.50matched
75capture01a1a13a-1cbf-7186-9bd4-6cfacb7b7e3e€9.00€0.19matched
77capture01a1a13a-2e03-7550-b275-2c5e87db99fa€9.00€0.19matched
78capture01a1a13a-444b-78d3-a239-c6d214e667a0€9.00€0.19matched
79capture01a1a13a-4790-7f8d-9cd1-28a9ea98b14c€24.00€0.37matched
80capture01a1a13a-5b8e-71ff-b794-a0213f3a83ad€15.00€0.26matched
81capture01a1a13a-6499-740c-add0-1e4ef790dd85€49.00€0.67matched
82capture01a1a13a-72b0-73a2-9e3f-d82eca9e5b33€24.00€0.37matched
83capture01a1a13a-7937-7405-b2b6-03ff69c19f0f€35.00€0.50matched
84refund01a1a13a-7d24-7030-a981-428875e863cf-€32.00€0.00matched
85capture01a1a13a-8986-77b4-8c76-3ba2e094a8f3€24.00€0.37matched
86capture01a1a13a-8f6d-7a0c-849c-13755de620a9€24.00€0.37matched
87capture01a1a13a-b329-71f3-93c8-6c6217596a74€9.00€0.19matched
88capture01a1a13a-be63-7efa-837c-0f07106bfb65€24.00€0.37matched
89capture01a1a13a-d9ee-7e1a-b2e3-4a8d53e1a7ee€24.00€0.37matched
90refund01a1a13a-f7b0-780f-bbd1-aff5d7227bd0-€8.00€0.00matched
91capture01a1a13b-0a1b-773a-bbc3-1a4670d3ebaf€49.00€0.67matched
92capture01a1a13b-1a69-790f-a588-df41f1c55434€35.00€0.50matched
93capture01a1a13b-2bef-7220-8ce7-b7cedd76da92€35.00€0.50matched
94refund01a1a13b-37b8-774a-ae2a-704cf57136b1-€21.00€0.00matched
95capture01a1a13b-413a-71ff-9b51-e2471c83d48f€49.00€0.67matched
96capture01a1a13b-7e4d-7bd9-9c1a-a5245fa4bd18€9.00€0.19matched
97capture01a1a13b-8a07-717c-97ac-315881249dd3€49.00€0.67matched
98capture01a1a13b-8a5a-7ed8-8e68-a40e377c85ac€49.00€0.67matched
99capture01a1a13b-9068-75a1-8316-c73b81fed919€35.00€0.50matched
100capture01a1a13b-bb31-7397-9d74-93bf2b3f102b€35.00€0.50matched
101capture01a1a13b-beb2-776e-9aba-d5924aec78b5€9.00€0.19matched
102capture01a1a13b-c5b7-7426-918a-19a027e992d9€24.00€0.37matched
103capture01a1a13b-eacc-79f1-accb-9bcdc9219397€49.00€0.67matched
104capture01a1a13b-f069-749d-9c3e-e5dc3ef2aa60€15.00€0.26matched
105refund01a1a13b-f197-72fc-a639-997fcf98295c-€8.00€0.00matched
106capture01a1a13b-f55c-7320-b941-3ad61b303356€35.00€0.50matched
107capture01a1a13b-fadc-7b59-9d05-b44f479a6b13€49.00€0.67matched
108capture01a1a13b-fef2-731c-948d-da4b5d2ca170€49.00€0.67matched
109capture01a1a13c-67ab-799d-8273-69d3da6eed04€9.00€0.19matched
110capture01a1a13c-69d5-7343-9e0d-47cb479cab87€49.00€0.67matched
111capture01a1a13c-7d38-717a-be3d-77567019d279€9.00€0.19matched
112capture01a1a13c-8cb0-7781-bed1-88bf225a39c1€49.00€0.67matched
113capture01a1a13c-8d88-7fb6-92ab-fc04e0b2ee3d€9.00€0.19matched
114capture01a1a13c-abf0-7a51-a51a-76c21fd870de€9.00€0.19matched
115capture01a1a13c-c58c-7c87-94fa-f84643e2b62f€35.00€0.50matched
116capture01a1a13c-e671-7646-8e2e-158b6ce14232€24.00€0.37matched
117capture01a1a13c-ebd9-7ab8-be53-5cb1d9959e70€15.00€0.26matched
118capture01a1a13c-f6e9-710f-b54c-9cd87c620a5b€24.00€0.37matched
119capture01a1a13d-00f3-7bf1-9243-f0007e84271b€9.00€0.19matched
120capture01a1a13d-0c62-7bbf-a555-7eb18efb44c8€35.00€0.50matched
121capture01a1a13d-18d0-79e5-b8fb-20ba41420781€15.00€0.26matched
122capture01a1a13d-2656-7698-8ba3-8ab632093c93€9.00€0.19matched
123capture01a1a13d-31e2-7786-b487-bded8499e14a€35.00€0.50matched
124capture01a1a13d-38ca-77ef-9ff2-7d17337998ba€15.00€0.26matched
125capture01a1a13d-3a1e-748e-b97d-44d62c50f123€15.00€0.26matched
126refund01a1a13d-4216-75b2-9212-c4c71582179a-€13.00€0.00matched
127capture01a1a13d-7ae0-764d-9c68-fb2922a5274a€24.00€0.37matched
128capture01a1a13d-7ddc-72de-b323-4031cbe5d716€24.00€0.37matched
129capture01a1a13d-a3f4-77e9-a0f8-85b2b645a5f7€9.00€0.19matched
130capture01a1a13d-aac8-7a1d-a6fc-bc8f8327f2ce€24.00€0.37matched
131capture01a1a13d-b250-74ad-8449-4608ff5cf9ca€15.00€0.26matched
132capture01a1a13d-cabb-77ec-ac92-653a15a3b011€9.00€0.19matched
134refund01a1a13d-d0f7-7340-8e30-212af5c288fd-€14.00€0.00matched
135capture01a1a13d-d752-72ca-9a41-9bfa37e565e3€24.00€0.37matched
136capture01a1a13d-e6ff-72de-ab82-e71707f916df€9.00€0.19matched
137capture01a1a13d-fb0b-709f-9680-784734fa770a€9.00€0.19matched
138capture01a1a13e-02c7-765b-b343-c08caf32bc7a€9.00€0.19matched
139capture01a1a13e-352c-769f-b0ea-0c9cfe53d51a€49.00€0.67matched
140capture01a1a13e-3b7c-768c-a31a-495c34449e6f€24.00€0.37matched
141capture01a1a13e-3d0b-751a-be4a-f169750295d9€35.00€0.50matched
142capture01a1a13e-55da-7168-9f22-e482d68cc602€9.00€0.19matched
143capture01a1a13e-8d9f-7751-9fd0-9abff804a5ba€49.00€0.67matched
144capture01a1a13e-a2de-7123-80d8-36093a408654€15.00€0.26matched