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

4 Nov, 22:10

Gross

€2,729.00

PSP fee

€42.62

Net to the bank

€2,686.38

Settlement journal

#386732

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a8a5-201e-79cd-ad74-d9f18615bdab is already settled by stl_EUR_2989717 line 110
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
LineKindReferenceGrossFeeStatus
97capture01a1a8a4-8184-7bb9-b4bb-04da1d55eca1€49.00€0.70fee difference
111capture01a1a8a5-2045-7eb5-a0eb-b70594b8feb1€15.00€0.26duplicate line
1capture01a1a896-d3c5-7d92-898e-2f71961c0934€9.00€0.19matched
2capture01a1a89a-e3f8-704c-a08a-a75a67a5c4cc€9.00€0.19matched
3capture01a1a89c-b94c-7f7a-8be6-3bc6ba60d41f€35.00€0.50matched
4capture01a1a89d-5f17-73d0-8ce4-88f1bc1c9168€9.00€0.19matched
5capture01a1a89d-6908-781b-9d48-60a1a6452124€35.00€0.50matched
6capture01a1a89d-7d38-7db5-a544-bd7b6b89b989€9.00€0.19matched
7capture01a1a89d-7fb7-7612-b858-17e35bdb74a1€9.00€0.19matched
8capture01a1a89d-8ae8-7138-afab-167a5443c8f3€15.00€0.26matched
9capture01a1a89d-9a97-7164-9331-cabc3e70db35€15.00€0.26matched
10capture01a1a89d-a74c-7f70-8fd9-a955b824709f€49.00€0.67matched
11capture01a1a89d-b4a1-75db-8c84-9a4bfe2ce967€35.00€0.50matched
12capture01a1a89d-d297-74a9-bb73-1941ddf12d66€9.00€0.19matched
13capture01a1a89d-d786-789a-87cd-e33872ead1e4€9.00€0.19matched
14capture01a1a89d-fb32-77e3-926a-7203d5127cb7€15.00€0.26matched
15capture01a1a89e-23ab-7e44-a65e-e3563b596f54€24.00€0.37matched
16capture01a1a89e-3eb5-74ce-ba07-0bfec310cd7c€15.00€0.26matched
17capture01a1a89e-40c9-770b-99ee-279d3bd38ca8€49.00€0.67matched
18capture01a1a89e-7154-7009-852e-a7f5c742d9bb€49.00€0.67matched
19capture01a1a89e-83e0-7404-87ee-0b0eb6857658€24.00€0.37matched
20capture01a1a89e-8683-778a-951f-cb3f05f1e866€35.00€0.50matched
21capture01a1a89e-8790-716f-99f3-e5d6ff1eeb07€15.00€0.26matched
22capture01a1a89e-96a8-73f7-bf08-fc948846e951€49.00€0.67matched
23capture01a1a89e-9f68-7116-9116-68ff25122486€49.00€0.67matched
24capture01a1a89e-a137-7cbd-9c02-50c2dcc39111€9.00€0.19matched
25refund01a1a89e-b474-777b-8eb5-9f10337b9818-€14.00€0.00matched
26capture01a1a89e-b77c-70c0-9bb4-4781ea09c494€15.00€0.26matched
27capture01a1a89e-bd3a-7ff3-b15f-dfa1566e4d49€9.00€0.19matched
28capture01a1a89f-03d1-70e3-b1d1-7aac53108151€49.00€0.67matched
29capture01a1a89f-3860-7ec8-9bfe-59bdc9e9c75a€9.00€0.19matched
30capture01a1a89f-48d0-746f-a5b5-ad0911c8f3d6€15.00€0.26matched
31capture01a1a89f-6431-7cb5-a8b8-3103664986d6€35.00€0.50matched
32capture01a1a89f-7645-7221-8d9e-e4c7db0306b8€9.00€0.19matched
33capture01a1a89f-b2cd-7c9f-855f-4be555336510€24.00€0.37matched
34capture01a1a89f-c281-7bb8-a9f4-ee76875a68ee€9.00€0.19matched
35capture01a1a89f-d057-7202-b0ef-173f3b4ce051€15.00€0.26matched
36capture01a1a89f-d2ec-7931-ae23-4ce1499d8488€35.00€0.50matched
37capture01a1a89f-fed9-7ee7-8407-9a7663eb69a8€9.00€0.19matched
38capture01a1a8a0-118a-72f6-853a-9515c88cf11a€35.00€0.50matched
39capture01a1a8a0-21d4-79ba-88a8-546909e48ef2€15.00€0.26matched
40capture01a1a8a0-2fe2-7892-b4ae-2bece59dc881€9.00€0.19matched
41capture01a1a8a0-37d1-7bd8-b2d8-906b831ef12e€9.00€0.19matched
42capture01a1a8a0-53cb-785c-91f8-f30091784e16€49.00€0.67matched
43capture01a1a8a0-5ea5-736c-8699-5eb38c0f2947€9.00€0.19matched
44capture01a1a8a0-5f37-77b3-a5b0-460afcccee9e€9.00€0.19matched
45capture01a1a8a0-72c6-79c4-b133-fb22bed33f2e€35.00€0.50matched
46capture01a1a8a0-aa24-767a-8459-2b2ba81a19b4€24.00€0.37matched
47capture01a1a8a0-adf2-7bc5-bb6a-ac295f888c58€49.00€0.67matched
48capture01a1a8a0-d449-7604-891a-66a182e87f95€15.00€0.26matched
49capture01a1a8a0-fda5-7756-b440-3cc83982ee96€15.00€0.26matched
50capture01a1a8a1-1963-7bcf-9eb6-456d8bcf8915€24.00€0.37matched
51capture01a1a8a1-1e4a-7a75-b6b9-eef490fc8a45€49.00€0.67matched
52capture01a1a8a1-3edf-7165-a91b-02142e8b7a75€9.00€0.19matched
53capture01a1a8a1-470e-7a5a-898a-605dbe3d9729€9.00€0.19matched
54capture01a1a8a1-494d-7248-8025-da4d0b772d04€24.00€0.37matched
55capture01a1a8a1-6529-772c-b4a4-30014a9527c3€49.00€0.67matched
56capture01a1a8a1-6fbe-7e2b-8d31-50606c13fc7b€35.00€0.50matched
57capture01a1a8a1-76d0-787d-90ea-43396d674429€24.00€0.37matched
58capture01a1a8a1-84e5-75fb-8c7c-4ed2398a1161€15.00€0.26matched
59capture01a1a8a1-91f8-7bf9-b260-5190c7ba3686€24.00€0.37matched
60capture01a1a8a1-a30d-736d-88c0-9b65b76a8538€15.00€0.26matched
61capture01a1a8a1-abb3-76e8-9008-96f8426b4fa8€15.00€0.26matched
62capture01a1a8a1-be60-7f91-a028-1b5fc6a1b784€35.00€0.50matched
63capture01a1a8a1-e335-7d52-b08d-0a3e6e2d9dfd€9.00€0.19matched
64refund01a1a8a1-e456-7e04-97c4-5488afb92223-€8.00€0.00matched
65capture01a1a8a1-f007-7283-bcea-036d53cb53b5€35.00€0.50matched
66capture01a1a8a2-05c4-7877-8d4b-d96bd752474f€15.00€0.26matched
67capture01a1a8a2-0b12-7022-9092-02013234aed3€9.00€0.19matched
68capture01a1a8a2-3ded-7cee-ac53-9b4b272962e1€15.00€0.26matched
69capture01a1a8a2-4119-72a0-a798-4425868aab6a€49.00€0.67matched
70capture01a1a8a2-4398-7ed8-bccc-fdd9523552bb€35.00€0.50matched
71capture01a1a8a2-4cab-7566-800e-f19bcbed16ce€9.00€0.19matched
72capture01a1a8a2-7718-7cd8-a8fd-beb73f1e981c€49.00€0.67matched
73capture01a1a8a2-acf3-7a57-8385-fb6e40f9aff4€15.00€0.26matched
74capture01a1a8a2-bf4e-7097-925f-77abf4fc4d60€24.00€0.37matched
75capture01a1a8a2-c1c4-798e-9411-3dd447641aa0€9.00€0.19matched
76capture01a1a8a2-d219-7ba7-8534-d1c20600a2be€15.00€0.26matched
77capture01a1a8a2-dfbc-796c-b9e7-03368ae9b8fb€35.00€0.50matched
78capture01a1a8a2-f9c0-7605-a0c3-540db9fbf763€15.00€0.26matched
79capture01a1a8a2-ff22-7220-8b4f-f169a98e8bcb€49.00€0.67matched
80capture01a1a8a3-2cf6-7c2b-8a56-db99e53b37d1€35.00€0.50matched
81capture01a1a8a3-39f4-7906-a23a-67d8678983d7€15.00€0.26matched
82capture01a1a8a3-4220-72e0-bd74-8cabf0df4817€24.00€0.37matched
83capture01a1a8a3-cdfb-7d86-955a-23c2bf511d20€9.00€0.19matched
84capture01a1a8a3-cebd-7a8a-ad7d-82de6934f189€35.00€0.50matched
85capture01a1a8a3-d4df-7492-a9a0-2f24f87a0a91€35.00€0.50matched
86capture01a1a8a3-f5b0-74e5-936f-5eb6158d5e95€24.00€0.37matched
87capture01a1a8a4-2045-7140-a9c8-230bebaadfcb€49.00€0.67matched
88capture01a1a8a4-237c-7aa8-b3b6-c3cdcdb4ea49€15.00€0.26matched
89capture01a1a8a4-2f34-7efd-aea4-3009821f2f8b€24.00€0.37matched
90capture01a1a8a4-3936-7993-b939-f9895ece1c01€24.00€0.37matched
91capture01a1a8a4-42f6-7907-ad6c-d7f2a25c63d0€9.00€0.19matched
92capture01a1a8a4-573a-7ddf-84a2-afab0c690605€24.00€0.37matched
93capture01a1a8a4-5313-7ed7-ba27-7cb23c31f7ad€24.00€0.37matched
94capture01a1a8a4-6451-73ec-ade0-acae0033fb95€35.00€0.50matched
95refund01a1a8a4-6472-7eaa-a8b2-12d03a934870-€16.00€0.00matched
96capture01a1a8a4-6f42-7f1e-9945-92614c0fd547€15.00€0.26matched
98capture01a1a8a4-84a5-7887-b761-beecd2a374b2€24.00€0.37matched
99capture01a1a8a4-8861-7b92-b5bd-c96abad95f54€35.00€0.50matched
100capture01a1a8a4-9bd9-7f43-9834-9c8fc4d62e83€49.00€0.67matched
101refund01a1a8a4-9f42-7df7-88f4-b24add83e9b1-€13.00€0.00matched
102capture01a1a8a4-a5e2-7d8c-a242-6c6b9409798f€24.00€0.37matched
103capture01a1a8a4-c886-7fcb-a707-73df7fecd8fb€49.00€0.67matched
104capture01a1a8a4-d79b-7a17-8ca7-9f4a4797478f€49.00€0.67matched
105capture01a1a8a4-eb31-769b-96fc-1589e764d582€15.00€0.26matched
106capture01a1a8a4-f379-7877-8487-78990932e106€15.00€0.26matched
107capture01a1a8a4-f538-7486-a637-218ccde09978€24.00€0.37matched
108capture01a1a8a5-0fee-7b4a-8fff-62779dd57c2d€35.00€0.50matched
109capture01a1a8a5-13a3-7909-a792-0a17329410b2€15.00€0.26matched
110capture01a1a8a5-2045-7eb5-a0eb-b70594b8feb1€15.00€0.26matched
112capture01a1a8a5-3377-7d00-ab96-6964fe17b93c€24.00€0.37matched
113capture01a1a8a5-6acb-75d9-ab57-c4fec20fb81e€15.00€0.26matched
114capture01a1a8a5-6c74-7d65-8b01-84517618ea2e€15.00€0.26matched
115capture01a1a8a5-95eb-7122-9e2e-2e2d6b307bfc€49.00€0.67matched
116capture01a1a8a5-a105-75e2-9de8-43ec5bc97bfe€24.00€0.37matched
117capture01a1a8a5-a32a-7fe1-9839-fa8845196436€49.00€0.67matched
118refund01a1a8a5-c7f1-70c5-bedb-299e864f1af1-€5.00€0.00matched