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

Gross

€2,856.00

PSP fee

€45.48

Net to the bank

€2,810.52

Settlement journal

#414942

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b085-f09e-7613-b2af-b16a50113b44 is already settled by stl_EUR_2989938 line 25
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • missing linein the books, not in the filecapture:01a1b08a-919b-7844-bccf-b2e908cd2397 is in no file
  • missing linein the books, not in the filecapture:01a1b08a-d70a-7c7e-b165-82a14c280a3b is in no file
LineKindReferenceGrossFeeStatus
18capture01a1b085-3a99-7ff4-a95e-64d3b28ef162€35.00€0.52fee difference
26capture01a1b086-0082-7e17-a7e4-17a40fedeef0€35.00€0.50duplicate line
1capture01a1b07b-3631-70bd-8767-ac165681c1f1€35.00€0.50matched
2capture01a1b084-0efa-7da9-966c-cf545f8fb532€35.00€0.50matched
3capture01a1b084-153e-7891-9c13-4256e52aba3f€49.00€0.67matched
4capture01a1b084-32a3-7580-b077-2c6b8e808909€49.00€0.67matched
5capture01a1b084-3aef-7982-8156-bba34ef7c0ac€49.00€0.67matched
6capture01a1b084-4587-790a-8b20-b7d6bf5d6d80€9.00€0.19matched
7capture01a1b084-50b3-7f00-8a52-8ba81a59229c€24.00€0.37matched
8capture01a1b084-5681-7635-be8e-e0d9ee50684c€49.00€0.67matched
9capture01a1b084-7217-72a5-baaa-4024873504d3€35.00€0.50matched
10capture01a1b084-793f-7479-8a72-e2016476639a€9.00€0.19matched
11refund01a1b084-bba5-7e1a-b35a-40bf068c831e-€10.00€0.00matched
12capture01a1b084-c8b2-745c-b605-cf2c8b565c12€24.00€0.37matched
13capture01a1b084-e6bb-76b1-8a60-78da34acb17b€49.00€0.67matched
14capture01a1b084-ed83-7014-960f-ed6a0f56e4ac€24.00€0.37matched
15capture01a1b084-fdbf-788f-b48f-e94c44bfa130€49.00€0.67matched
16capture01a1b085-18e8-7331-922c-e870b9ddbdd9€49.00€0.67matched
17capture01a1b085-2c86-7203-b4d3-dbd0a46ebde5€9.00€0.19matched
19capture01a1b085-7b49-7e4c-89f6-3473f478b4d2€15.00€0.26matched
20capture01a1b085-8672-73f6-be98-9f2746e3d470€15.00€0.26matched
21capture01a1b085-90c3-7353-94b1-66b82df2179d€49.00€0.67matched
22capture01a1b085-a588-7c8f-8305-645c65c03b65€35.00€0.50matched
23capture01a1b085-c9ae-7dc3-8c15-70a7d151ff04€35.00€0.50matched
24refund01a1b085-dd30-72bb-a4e4-ca33eb5cc8bd-€4.00€0.00matched
25capture01a1b086-0082-7e17-a7e4-17a40fedeef0€35.00€0.50matched
27capture01a1b086-1f14-7c52-b156-22de50f58332€15.00€0.26matched
28capture01a1b086-270e-7ff7-8811-efc28955de96€49.00€0.67matched
29capture01a1b086-2821-782e-8f40-c57b702adb17€9.00€0.19matched
30capture01a1b086-35a8-79a9-885d-4ed467f8b69b€49.00€0.67matched
31capture01a1b086-47a9-79db-a796-623a0887748c€15.00€0.26matched
32capture01a1b086-63ea-79a5-9319-2c496dc19e66€35.00€0.50matched
33capture01a1b086-7be8-7446-9d8d-bde035310421€24.00€0.37matched
34capture01a1b086-78ae-72f5-b47f-a0ef84e88135€9.00€0.19matched
35capture01a1b086-95c4-79c0-93c0-243e0622adf8€35.00€0.50matched
36capture01a1b086-ae12-72d5-a4d4-ea3dac0beaa8€35.00€0.50matched
37capture01a1b086-bce5-79fa-830d-0e7d5a2b25f1€24.00€0.37matched
38capture01a1b086-c0fa-79ca-a795-47b63c19a982€9.00€0.19matched
39capture01a1b086-d63f-74c7-82ac-c9b700dc29f6€24.00€0.37matched
40refund01a1b086-dfa5-7e83-bb68-746aba5d7302-€10.00€0.00matched
41capture01a1b086-fcbd-75d6-b13b-5807e94c8e85€49.00€0.67matched
42capture01a1b087-2d39-79e3-9b28-55884f12327d€9.00€0.19matched
43capture01a1b087-3226-7c6b-941a-6b04247a95a0€24.00€0.37matched
44capture01a1b087-3b0c-7b9d-b5fa-1738e1e5736b€9.00€0.19matched
45capture01a1b087-58b6-7394-983b-e871f58e4595€9.00€0.19matched
46capture01a1b087-866b-7090-a53a-6688fe3253d2€15.00€0.26matched
47capture01a1b087-8ed7-70f1-b54c-8de7987d9c23€15.00€0.26matched
48capture01a1b087-9283-723f-928d-be6d1105a852€9.00€0.19matched
49capture01a1b087-93dc-7981-9b5e-89872667488f€15.00€0.26matched
50capture01a1b087-a814-7a55-ad90-943a0577327e€49.00€0.67matched
51capture01a1b087-ac4e-76fc-afd7-d12eef38e211€9.00€0.19matched
52capture01a1b087-ccec-76e2-98ac-b6686d357340€15.00€0.26matched
53capture01a1b087-fb04-719b-a32d-aa61069cac44€15.00€0.26matched
54capture01a1b088-2706-7e56-81a8-60a9c5b13232€15.00€0.26matched
55capture01a1b088-2a3f-7d12-8759-25d87387804a€9.00€0.19matched
56capture01a1b088-2c4e-78fd-985c-3dedb05478b7€49.00€0.67matched
57capture01a1b088-5b7b-7810-a5e7-c8549d358974€9.00€0.19matched
58capture01a1b088-68e8-79c5-b84c-72a81b85aaff€35.00€0.50matched
59capture01a1b088-71d3-798e-8f63-bc42f1d9d2cc€15.00€0.26matched
60capture01a1b088-73e9-7db8-b0b8-e019647de56d€9.00€0.19matched
61capture01a1b088-7996-70b1-a9c2-9bfffef634da€15.00€0.26matched
62capture01a1b088-8cbb-747c-bf43-90515d7c3c28€35.00€0.50matched
63capture01a1b088-96b3-7bea-a3a3-425ad6002742€35.00€0.50matched
64capture01a1b088-a3d6-7147-ae0c-89434ae68c56€35.00€0.50matched
65capture01a1b088-a683-72e2-90d5-a5873584cae0€24.00€0.37matched
66capture01a1b088-a932-7827-b51a-445d01e8e9fb€35.00€0.50matched
67capture01a1b088-cfcd-7400-a90d-a4356d5da704€9.00€0.19matched
68capture01a1b088-d727-7990-8000-9f8c4935f790€49.00€0.67matched
69capture01a1b088-ced9-7a5a-a017-bc1081542333€49.00€0.67matched
70refund01a1b088-f261-706b-ac6f-01beac5832a8-€19.00€0.00matched
71capture01a1b089-299d-7baa-8447-8becd397c540€15.00€0.26matched
72capture01a1b089-331c-7458-b6b0-f011fe01e469€35.00€0.50matched
73capture01a1b089-38aa-7ac0-90b0-0f83e5c5527d€9.00€0.19matched
74capture01a1b089-3deb-706f-86c1-6cf056d4eab3€9.00€0.19matched
75refund01a1b089-4d82-77d8-a6cf-7bb6090e95d0-€10.00€0.00matched
76capture01a1b089-5020-7876-9e88-d73b077b1591€9.00€0.19matched
77capture01a1b089-6b19-7275-8bde-9d564a8b1ccc€15.00€0.26matched
78capture01a1b089-6ca8-7a04-953b-6f3520a391af€9.00€0.19matched
79capture01a1b089-782c-73ae-b1f6-26f47f70a977€35.00€0.50matched
80capture01a1b089-91da-7363-9855-11e20d9e2700€24.00€0.37matched
81capture01a1b089-9741-7528-a808-7100d213dc48€24.00€0.37matched
82capture01a1b089-9c33-7304-b32a-cedbcb3cd61e€49.00€0.67matched
83capture01a1b089-b304-77a2-9e60-c1b777f42c7a€49.00€0.67matched
84capture01a1b089-d20b-7886-816b-1fd2504d1328€35.00€0.50matched
85capture01a1b089-e2e9-7bbb-858f-4b30ae4f3e5a€35.00€0.50matched
86capture01a1b089-e579-79d8-8aa6-4cf1f2d40b94€35.00€0.50matched
87capture01a1b089-f3ea-71a4-9a1a-f106eee121ab€35.00€0.50matched
88capture01a1b089-f944-747a-8b8d-298e0d8c4724€15.00€0.26matched
89refund01a1b089-fba2-7da1-942d-58f3fc2a8802-€15.00€0.00matched
90capture01a1b08a-0f18-7ecc-abf3-584bcf3567b7€9.00€0.19matched
91capture01a1b08a-24ce-70e0-83a4-4bdf7f154f7a€35.00€0.50matched
92capture01a1b08a-755b-70d5-8a10-5b382a960eff€24.00€0.37matched
93capture01a1b08a-9f38-7925-8c9e-6b9b3c0272ed€9.00€0.19matched
94capture01a1b08a-c111-7a1c-89d7-5806d8955ba2€24.00€0.37matched
95capture01a1b08a-c73b-7434-9b77-054f1481dbb0€9.00€0.19matched
96capture01a1b08a-d71c-7a13-8c18-44b8cb7b8260€15.00€0.26matched
97capture01a1b08a-cd00-722e-ae7e-be847476a3d3€9.00€0.19matched
98capture01a1b08a-ece0-78eb-abd4-0e9305fdc921€9.00€0.19matched
99capture01a1b08a-eda9-7809-84a7-ea967411337d€15.00€0.26matched
100capture01a1b08b-02b7-7314-92b5-925a06792968€9.00€0.19matched
101capture01a1b08b-0a26-79a6-975e-01003028c326€49.00€0.67matched
102capture01a1b08b-0bcc-7f93-bd05-a50d17937f65€15.00€0.26matched
103refund01a1b08b-329a-797d-a5b2-6d81422f02fa-€8.00€0.00matched
104capture01a1b08b-3768-79bf-90a6-0707b52fe61a€35.00€0.50matched
105capture01a1b08b-3cd9-73ca-b2be-3d2f944169cb€24.00€0.37matched
106capture01a1b08b-4176-7571-aa18-c45b078962ca€24.00€0.37matched
107capture01a1b08b-4c76-7522-b03e-8736be4c2490€9.00€0.19matched
108capture01a1b08b-5d6e-7568-a79d-f39e161bb936€49.00€0.67matched
109capture01a1b08b-6447-7994-aea3-e740ffc29ac2€9.00€0.19matched
110refund01a1b08b-683e-7747-a01a-49f44f0b7921-€14.00€0.00matched
111capture01a1b08b-69cc-78f2-b3a3-6b39a82f9455€35.00€0.50matched
112capture01a1b08b-7781-7c6f-be2e-b3f46dc0fb1b€9.00€0.19matched
113refund01a1b08b-8892-7c96-8039-847e9b7e76d0-€32.00€0.00matched
114capture01a1b08b-9951-7ce2-a99d-45366379d6d4€15.00€0.26matched
115capture01a1b08b-a2cb-7f97-8f78-e614025a9ee3€15.00€0.26matched
116refund01a1b08b-aa7c-7855-afd0-ec50a757e5a5-€6.00€0.00matched
117capture01a1b08b-c08b-718c-be11-670bb36c4ed6€15.00€0.26matched
118capture01a1b08b-bff0-7beb-b03e-a246e38bad03€35.00€0.50matched
119capture01a1b08b-d52c-7821-af8b-de6d514bfc5a€9.00€0.19matched
120capture01a1b08b-e8da-7d9f-afb1-e34deae9461e€24.00€0.37matched
121capture01a1b08b-f27b-7096-b9d3-3547f4436b7a€24.00€0.37matched
122capture01a1b08b-ed21-740e-9c26-8f8f45d4d6d6€15.00€0.26matched
123capture01a1b08c-0dd1-7ec6-b8f5-ca18f252ccfe€35.00€0.50matched
124capture01a1b08c-43bd-7f4a-8763-44c175eea6d7€15.00€0.26matched
125capture01a1b08c-4438-7452-8ea6-76ef17acb524€15.00€0.26matched
126capture01a1b08c-4880-7a4e-b60d-e82081dcb3e7€24.00€0.37matched
127capture01a1b08c-b176-7de4-9cda-8dc9ab264a57€15.00€0.26matched
128capture01a1b08c-beb2-71fe-8af4-01e119f4ba4f€49.00€0.67matched
129capture01a1b08c-fbbc-7e55-ab36-84f426acc7d8€15.00€0.26matched