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

7 Nov, 12:00

Gross

€3,232.00

PSP fee

€50.75

Net to the bank

€3,181.25

Settlement journal

#434104

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b5e1-3a22-72dc-83d7-66bde0952f98 is already settled by stl_EUR_2990088 line 4
  • missing linein the books, not in the filecapture:01a1b5ea-3909-7d6c-8b3e-93c32a8a1c74 is in no file
  • missing linein the books, not in the filecapture:01a1b5e6-3fe5-71d5-a4f7-a2da6557ada1 is in no file
LineKindReferenceGrossFeeStatus
5capture01a1b5e1-3ad7-73c8-b370-16f1fb4925b4€35.00€0.50duplicate line
1capture01a1b5d9-676a-7a4e-9c2e-4335b1eb2e19€35.00€0.50matched
2capture01a1b5db-2279-7ea4-9449-0c37c84ba178€24.00€0.37matched
3capture01a1b5e1-40b7-7ecf-bfd6-787a13bf332e€49.00€0.67matched
4capture01a1b5e1-3ad7-73c8-b370-16f1fb4925b4€35.00€0.50matched
6capture01a1b5e1-564c-7fd4-ada4-a38e01dabba1€49.00€0.67matched
7capture01a1b5e1-9ab2-72cb-bc39-9012d8268f6f€15.00€0.26matched
8capture01a1b5e1-a854-7440-97ae-cb135821a95e€9.00€0.19matched
9refund01a1b5e1-b344-7655-979f-d53ec59d594e-€25.00€0.00matched
10capture01a1b5e1-c4df-7425-87c9-3d26b072efc9€49.00€0.67matched
11capture01a1b5e1-ca33-787f-817b-610c2e9e54ee€49.00€0.67matched
12capture01a1b5e1-cdd2-7742-a1fd-cf184cfa0f63€15.00€0.26matched
13capture01a1b5e2-03d1-7ec1-9950-bbe3ea2b3641€24.00€0.37matched
14capture01a1b5e2-0458-77ed-9a8e-34b24bfeb457€9.00€0.19matched
15capture01a1b5e2-1b2c-783e-928a-a8737d96eedb€35.00€0.50matched
16capture01a1b5e2-1fc3-7185-aaaa-beeeb056cbc2€49.00€0.67matched
17capture01a1b5e2-61e9-7e15-a95a-7ca78e736610€24.00€0.37matched
18capture01a1b5e2-68e2-7d26-9350-cd235bdd8255€9.00€0.19matched
19capture01a1b5e2-7b95-72ac-9e67-63edb77873e4€49.00€0.67matched
20capture01a1b5e2-95a3-783e-9558-9bcc684e1d14€49.00€0.67matched
21capture01a1b5e2-c02a-7163-8302-ae30aaf5d1ba€24.00€0.37matched
22capture01a1b5e2-d906-7139-8125-68cccaca6f5a€9.00€0.19matched
23capture01a1b5e2-ecd9-79c3-8620-fd73464527a0€49.00€0.67matched
24capture01a1b5e3-0b31-70fd-abe3-8850f9952102€9.00€0.19matched
25capture01a1b5e3-2574-75d9-b5f5-34a542053ac9€24.00€0.37matched
26capture01a1b5e3-4993-7d8e-aa33-b32f77b049f8€9.00€0.19matched
27capture01a1b5e3-59cf-7a43-b8ba-6e13f67597cb€9.00€0.19matched
28capture01a1b5e3-6db8-7d88-a6e1-d5429a8b6aab€49.00€0.67matched
29capture01a1b5e3-9157-74b5-907b-4301ccae3020€49.00€0.67matched
30capture01a1b5e3-9bf6-721b-b3c5-f5e43b50f8d1€9.00€0.19matched
31capture01a1b5e3-ab3c-7053-a74b-7d4c01177ee5€9.00€0.19matched
32capture01a1b5e3-bd03-75c2-8a57-593f78c24929€49.00€0.67matched
33capture01a1b5e3-bde2-711f-81b9-945dda3576c3€49.00€0.67matched
34capture01a1b5e3-d0c2-7d37-b32c-8c320bd10d45€15.00€0.26matched
35capture01a1b5e3-d216-7190-8c39-8c1e3fcacf3b€9.00€0.19matched
36refund01a1b5e4-180a-7e61-8142-1942b5b85745-€15.00€0.00matched
37capture01a1b5e4-1bcd-7ec8-8f0a-ae0d78c20933€9.00€0.19matched
38capture01a1b5e4-32f0-7f05-85a4-5090852e5b3d€9.00€0.19matched
39capture01a1b5e4-3841-7ed1-8afd-75f9504bef32€9.00€0.19matched
40capture01a1b5e4-469b-7aa3-880a-1f76ea5ed28e€49.00€0.67matched
41capture01a1b5e4-5058-791e-8525-7fd273bee6c0€35.00€0.50matched
42capture01a1b5e4-5eb2-7d04-a7d1-d88b8f105ba0€9.00€0.19matched
43capture01a1b5e4-6639-7f96-9aac-8dc22d82005d€49.00€0.67matched
44capture01a1b5e4-8ef0-7456-afee-69c15f691d19€15.00€0.26matched
45capture01a1b5e4-a26f-7ee7-aba7-74a76be694a9€49.00€0.67matched
46capture01a1b5e4-ab4a-7730-8320-82d4f2d7c7d8€15.00€0.26matched
47capture01a1b5e4-b369-7cd4-8068-09632f9c949d€35.00€0.50matched
48capture01a1b5e4-c607-79f8-a49a-95feab4c949c€9.00€0.19matched
49capture01a1b5e4-d335-76df-b945-bed8bf39f579€35.00€0.50matched
50capture01a1b5e5-32bd-77a1-9a23-6fa4ef3d0cb8€35.00€0.50matched
51capture01a1b5e5-3c24-7447-8da8-215e73f31caf€35.00€0.50matched
52capture01a1b5e5-42aa-7286-8ed6-e424a40ebbd6€35.00€0.50matched
53capture01a1b5e5-48ee-760b-be5d-9654cfc5c3ad€24.00€0.37matched
54capture01a1b5e5-4ee9-7a32-8e68-37cae22318fb€9.00€0.19matched
55capture01a1b5e5-6d8a-70d5-9099-6dadd57d723e€24.00€0.37matched
56capture01a1b5e5-78ee-7e5b-9861-715eaf9a32c3€24.00€0.37matched
57capture01a1b5e5-8567-71be-90ca-698b21d3fad5€15.00€0.26matched
58capture01a1b5e5-8830-7d75-90a6-50da237dc072€49.00€0.67matched
59capture01a1b5e5-9247-778b-9e89-6a5e5197db58€49.00€0.67matched
60refund01a1b5e5-af00-70cd-976f-3e7995287cf8-€6.00€0.00matched
61capture01a1b5e5-b106-7e4b-a8e5-067dc4d7d5d2€24.00€0.37matched
62capture01a1b5e5-b1a2-727c-a79f-12441c3b62cb€35.00€0.50matched
63capture01a1b5e5-bae8-79e8-8ec9-e8cfc6ed971a€49.00€0.67matched
64capture01a1b5e5-bf3a-77e5-a5d0-6f8c7de0762c€35.00€0.50matched
65capture01a1b5e5-ccd6-74e0-b21d-4a234013ed27€9.00€0.19matched
66capture01a1b5e5-ebeb-77ad-9e14-d8207d1163b2€24.00€0.37matched
67capture01a1b5e5-fd1c-7d80-89b2-70568dd416d5€49.00€0.67matched
68capture01a1b5e6-0720-7137-9031-e9a7d24a6b06€24.00€0.37matched
69capture01a1b5e6-0d40-7f6a-bc22-1dc4f718534b€24.00€0.37matched
70capture01a1b5e6-102c-7a34-968f-d6c045578451€9.00€0.19matched
71capture01a1b5e6-1f3e-7107-af06-96d5a40fcd42€15.00€0.26matched
72refund01a1b5e6-2fe7-74c0-83c3-7ae62e0721c7-€6.00€0.00matched
73capture01a1b5e6-67f3-7bc6-8356-79408c2bf0f8€35.00€0.50matched
74capture01a1b5e6-71c6-77bb-83e3-382f70f55221€24.00€0.37matched
75capture01a1b5e6-7d19-7dc4-a5e2-b1050673ffd0€24.00€0.37matched
76capture01a1b5e6-8caa-7854-b5f1-800ab87ee698€24.00€0.37matched
77capture01a1b5e6-a315-7d3d-a2f5-2c951279724d€15.00€0.26matched
78capture01a1b5e6-a45e-78d5-a069-c9ae4630cd0f€9.00€0.19matched
79capture01a1b5e6-a81e-71a9-b013-390c6a394f90€49.00€0.67matched
80capture01a1b5e6-c782-7d29-afb8-fad988c18f39€24.00€0.37matched
81capture01a1b5e6-cf33-7317-9f84-4d7578ef4e5e€24.00€0.37matched
82capture01a1b5e6-d2e1-7648-a17b-1da147e58a1a€15.00€0.26matched
83capture01a1b5e6-d60b-72d3-bdf6-2589e962949d€49.00€0.67matched
84capture01a1b5e7-0ae7-7957-9daf-d3893694d080€49.00€0.67matched
85capture01a1b5e7-18f5-79b7-9a73-e6df78cc56fa€15.00€0.26matched
86capture01a1b5e7-2773-758f-9ec3-ad8d6ca7afa5€49.00€0.67matched
87capture01a1b5e7-3f16-7d2f-b72f-200bd91e50de€15.00€0.26matched
88capture01a1b5e7-54a1-771e-9a69-6f72c36164f4€15.00€0.26matched
89capture01a1b5e7-6dc6-75e7-a10b-d39cfdc4c18f€24.00€0.37matched
90capture01a1b5e7-89f7-72e3-a28f-ec394c2b8cdd€49.00€0.67matched
91capture01a1b5e7-9f69-7d7f-89f4-300843633cd7€9.00€0.19matched
92capture01a1b5e7-b7fa-7d7d-92df-e052fbe1bcdb€9.00€0.19matched
93capture01a1b5e7-bb88-76bd-88a9-4181a23edc75€35.00€0.50matched
94capture01a1b5e7-c0fe-7d92-bd3a-0963bde7f274€24.00€0.37matched
95capture01a1b5e7-cb60-78b8-85e8-924d857c453d€15.00€0.26matched
96refund01a1b5e7-ccc7-74d4-af2c-ccb44d448ba2-€43.00€0.00matched
97capture01a1b5e7-da06-717e-be68-6a712039b5f6€15.00€0.26matched
98capture01a1b5e7-edcf-7176-a891-86abeda0660d€9.00€0.19matched
99capture01a1b5e8-06e6-74f9-9830-7eb094f9fd09€15.00€0.26matched
100capture01a1b5e8-0d6c-7f1f-bbd0-a1b0017e05aa€49.00€0.67matched
101capture01a1b5e8-27d0-75e4-ad69-d5bad9c69ff1€15.00€0.26matched
102capture01a1b5e8-2e3c-7157-925d-b89c8547bcce€49.00€0.67matched
103capture01a1b5e8-4463-76a6-a132-ab17d01c43c3€35.00€0.50matched
104capture01a1b5e8-4b9b-7781-b9aa-3b8623b9cfcf€15.00€0.26matched
105capture01a1b5e8-5b73-78b5-911c-f32875d1f711€15.00€0.26matched
106capture01a1b5e8-67ba-7e30-adbd-7d1e4f13b2eb€15.00€0.26matched
107capture01a1b5e8-7720-794e-9905-80a4de2d47ea€24.00€0.37matched
108capture01a1b5e8-7e5d-767d-a46e-00d12156ce1e€35.00€0.50matched
109capture01a1b5e8-826d-70f7-b033-aeb361429bf0€9.00€0.19matched
110capture01a1b5e8-8ce1-7d9b-a22b-df7d26ef2afb€15.00€0.26matched
111capture01a1b5e8-8fc2-76b2-9a69-28b625522989€35.00€0.50matched
112capture01a1b5e8-9b63-72f2-a7fe-58b30605e271€35.00€0.50matched
113capture01a1b5e8-b561-79ca-8799-70e88ee25a8e€9.00€0.19matched
114capture01a1b5e8-c363-7250-8d4c-91dc09e2c419€15.00€0.26matched
115capture01a1b5e8-d410-7dfd-90aa-8994a6015677€9.00€0.19matched
116refund01a1b5e8-dbac-7449-aa20-5ca358ddfbb4-€14.00€0.00matched
117refund01a1b5e8-dede-7fb6-9cdd-5b45ed6b7c64-€6.00€0.00matched
118capture01a1b5e8-f142-729a-a8c9-84a5421e3972€9.00€0.19matched
119capture01a1b5e9-0340-74c4-ae65-fb83b21a623f€15.00€0.26matched
120capture01a1b5e9-39e6-7b42-8494-053d82ce797c€15.00€0.26matched
121capture01a1b5e9-5fc1-7e91-9d74-42cd62e1784b€9.00€0.19matched
122capture01a1b5e9-8be7-7359-9b60-f9b2c1b9cbb3€15.00€0.26matched
123capture01a1b5e9-a527-7f64-89da-2462be4420ca€15.00€0.26matched
124capture01a1b5e9-c4ae-775e-abd5-2749f724f213€15.00€0.26matched
125capture01a1b5e9-d2d4-769b-ad4f-93846171c79a€35.00€0.50matched
126capture01a1b5ea-0ad2-72f5-b68b-65628c57e3c4€15.00€0.26matched
127capture01a1b5ea-16d9-77e2-8d18-01dac32e6a31€9.00€0.19matched
128capture01a1b5ea-17f1-7966-b630-da04dcd8b556€24.00€0.37matched
129capture01a1b5ea-1bed-745c-b9cb-a77b3ed9b3c1€9.00€0.19matched
130capture01a1b5ea-1fa2-7b4d-a7da-cf8892bfdc82€15.00€0.26matched
131refund01a1b5ea-21d0-733e-9223-5c647dd5fbd4-€6.00€0.00matched
132capture01a1b5ea-2ace-7222-b358-9a98198fc132€35.00€0.50matched
133capture01a1b5ea-35e1-75b8-bd04-10bdecbcb68a€15.00€0.26matched
134capture01a1b5ea-367e-79db-ac27-37a86f83013c€49.00€0.67matched
135capture01a1b5ea-432a-76aa-a1db-4cc928ac955a€35.00€0.50matched
136capture01a1b5ea-433b-7324-a451-1f6808bcdfe4€49.00€0.67matched
137capture01a1b5ea-4aed-772d-9b04-adaa231b423c€49.00€0.67matched
138refund01a1b5ea-5021-7f54-b7ae-0a2cee1faca8-€3.00€0.00matched