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

5 Nov, 00:20

Gross

€3,273.00

PSP fee

€51.35

Net to the bank

€3,221.65

Settlement journal

#388410

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a915-aa31-7432-9765-b71fe921f111 is already settled by stl_EUR_2989730 line 36
  • duplicate linethe file lists it twicecapture:01a1a91a-c604-79cc-b349-0047a5b73741 is already settled by stl_EUR_2989730 line 98
  • missing linein the books, not in the filecapture:01a1a91b-ffae-7036-a06b-52e42d962ecc is in no file
  • missing linein the books, not in the filecapture:01a1a917-632b-74b5-8def-cf583a81bdde is in no file
LineKindReferenceGrossFeeStatus
37capture01a1a915-ad90-76f7-8ca8-476a38e1face€9.00€0.19duplicate line
99capture01a1a91a-c61b-7e4a-9060-d98b68b23237€35.00€0.50duplicate line
1capture01a1a90c-253c-708f-b19f-b118d3a8a817€35.00€0.50matched
2capture01a1a90c-8ffc-7050-81e7-168636e958fe€9.00€0.19matched
3capture01a1a910-51e3-7bbd-a72b-3ac1a00b2046€49.00€0.67matched
4capture01a1a913-a77b-7a15-9a53-22400f629c04€15.00€0.26matched
5capture01a1a913-d838-7a28-93a2-2ae4608910cf€35.00€0.50matched
6capture01a1a913-db6c-7caa-9720-d0eacb21c18a€35.00€0.50matched
7capture01a1a913-e282-7bf2-8ad6-c167848fb525€49.00€0.67matched
8capture01a1a913-d4dc-7268-ac3d-30ecac599a12€49.00€0.67matched
9capture01a1a913-ea29-7096-a6f3-6f4bfe34123f€49.00€0.67matched
10capture01a1a914-422a-72e4-811d-a15464f9c061€49.00€0.67matched
11capture01a1a914-436a-760a-910e-bfdddeebbac3€9.00€0.19matched
12capture01a1a914-4e24-76af-acdc-a8ffc6e72a9e€9.00€0.19matched
13capture01a1a914-56de-7f88-b082-a30c02855a49€49.00€0.67matched
14capture01a1a914-5fe8-7d90-a21c-c831ba7640a2€15.00€0.26matched
15capture01a1a914-8b34-7529-ba98-8179325aa5a7€9.00€0.19matched
16capture01a1a914-9bec-7c22-816c-cb057447f15a€35.00€0.50matched
17capture01a1a914-b1fb-7a0c-8f98-71a0c1551703€9.00€0.19matched
18capture01a1a914-b6ce-7a71-83f1-0e7cdc63059e€49.00€0.67matched
19capture01a1a914-bbf0-7678-9388-db917ce203ab€15.00€0.26matched
20capture01a1a914-d236-7546-b60b-2db47c592d3e€49.00€0.67matched
21capture01a1a914-d81e-7cba-82c6-279a3ee1c8c7€49.00€0.67matched
22capture01a1a914-daa4-72e8-bc89-1068e0db2521€35.00€0.50matched
23capture01a1a914-dea9-7409-89be-c8ed41d69953€49.00€0.67matched
24capture01a1a914-ea6c-74d0-bb76-6179d6e79123€15.00€0.26matched
25capture01a1a914-ebd7-7343-9fb1-75b181caa002€24.00€0.37matched
26capture01a1a915-1287-790f-b64e-bc19c6583e22€35.00€0.50matched
27capture01a1a915-2a0b-7d86-b130-167ff43d37f4€24.00€0.37matched
28capture01a1a915-2fdb-796d-811a-932c3098bb7e€35.00€0.50matched
29capture01a1a915-3dd7-75f0-82f2-2f7eed9b1761€15.00€0.26matched
30capture01a1a915-657c-750e-8833-1256ab72b989€9.00€0.19matched
31capture01a1a915-748f-7793-98d2-bd36e475853f€49.00€0.67matched
32capture01a1a915-7494-78a2-83e7-e51447c90946€15.00€0.26matched
33capture01a1a915-83c5-7cdb-b865-74890989d5e8€24.00€0.37matched
34capture01a1a915-9dab-743a-9753-61de9820d67d€35.00€0.50matched
35capture01a1a915-a4ad-7390-a4d2-2352d3464c26€15.00€0.26matched
36capture01a1a915-ad90-76f7-8ca8-476a38e1face€9.00€0.19matched
38capture01a1a915-c7f9-7a5d-b4a9-db6dfb9eff37€49.00€0.67matched
39capture01a1a915-c724-78a3-a7a6-7948e638a212€24.00€0.37matched
40capture01a1a915-cbf8-7568-8206-d420b90dc145€35.00€0.50matched
41refund01a1a915-d684-7f62-b7f5-b84fc7a2f482-€7.00€0.00matched
42capture01a1a915-daba-7468-a808-f5e5b7f6dac7€49.00€0.67matched
43refund01a1a915-f007-714f-b9c0-6c8ab087a7a1-€37.00€0.00matched
44capture01a1a916-1ee3-74a6-9d45-b2363cd0ba04€24.00€0.37matched
45capture01a1a916-202e-7b43-977c-533cd13a253d€49.00€0.67matched
46capture01a1a916-20b0-7a19-8333-8bec35a415f6€24.00€0.37matched
47capture01a1a916-2551-7504-8163-d00cef252283€49.00€0.67matched
48capture01a1a916-2a12-7c8b-9299-aae2011d7578€35.00€0.50matched
49capture01a1a916-2b55-7efb-991a-c2bced70173e€15.00€0.26matched
50refund01a1a916-5dc5-7c3d-8781-8706bb28089c-€7.00€0.00matched
51capture01a1a916-7345-7662-a30c-c9f30d25b6ca€49.00€0.67matched
52capture01a1a916-7a0d-7245-9af7-28b6e6767a19€15.00€0.26matched
53capture01a1a916-963c-7b5f-89c5-1969a5b97111€9.00€0.19matched
54capture01a1a916-b962-7954-b65e-7e87a1fc9f04€24.00€0.37matched
55capture01a1a916-d067-7cd8-af1e-8027a37fb2b5€9.00€0.19matched
56refund01a1a916-d31b-7eeb-a630-59e75da73eb4-€4.00€0.00matched
57capture01a1a916-d352-75b3-b677-978ca066c64b€24.00€0.37matched
58capture01a1a916-db23-7e23-a728-75435820d42b€35.00€0.50matched
59capture01a1a916-f06d-760d-aa40-ec666ae48493€35.00€0.50matched
60capture01a1a917-0caf-72a5-8b02-695a09468223€35.00€0.50matched
61capture01a1a917-17d8-7999-b360-962b06ddaf65€35.00€0.50matched
62capture01a1a917-1b65-7a2d-a845-961d1d7a751e€24.00€0.37matched
63capture01a1a917-44cf-795f-9f03-7d562d79f32c€15.00€0.26matched
64capture01a1a917-4ebd-779b-8388-7142db02cec7€15.00€0.26matched
65capture01a1a917-5ffb-70c4-a200-3902064171e7€24.00€0.37matched
66capture01a1a917-8250-7a41-b4b5-63c891da7f13€15.00€0.26matched
67capture01a1a917-c0f5-7e50-85d3-0d3e7e3af5c8€35.00€0.50matched
68capture01a1a917-c323-7805-9bcb-7e932667337b€9.00€0.19matched
69capture01a1a917-f16a-76d0-bbaf-5972c3f2068f€35.00€0.50matched
70capture01a1a917-f2aa-714e-aad4-e2bb8b723541€9.00€0.19matched
71capture01a1a918-1865-71ce-9a41-70557141da2d€9.00€0.19matched
72capture01a1a918-2483-7164-8cf8-ad33ea16df20€49.00€0.67matched
73capture01a1a918-34c7-716d-8947-595b8c95d4a5€15.00€0.26matched
74capture01a1a918-66c3-73b3-aec9-8292e355cefe€49.00€0.67matched
75capture01a1a918-7eb4-7b2a-adc2-fd144961907f€24.00€0.37matched
76capture01a1a918-944d-779d-92e1-c41f07e46751€9.00€0.19matched
77capture01a1a918-cb3c-7320-8317-b1b58ede9efa€15.00€0.26matched
78capture01a1a918-e754-738a-b96e-3a6cbb5cb6f2€49.00€0.67matched
79capture01a1a919-0bc9-74d8-a31c-757f0826ea2f€49.00€0.67matched
80capture01a1a919-0d76-772b-8e84-506b15ec590c€24.00€0.37matched
81refund01a1a919-1ec0-7565-9c65-9b3c38eeff81-€19.00€0.00matched
82refund01a1a919-2ca5-77f5-a3bc-6b8046dddad2-€13.00€0.00matched
83capture01a1a919-2c93-702b-96e1-2ecdbb572c09€9.00€0.19matched
84capture01a1a919-4bf3-7e82-b812-40a1570d9b54€35.00€0.50matched
85capture01a1a919-65bd-7fa2-8b64-a33531ff35e0€9.00€0.19matched
86capture01a1a919-8e06-7e63-9823-5e581737ca8a€49.00€0.67matched
87capture01a1a919-9e5c-7b8b-ad74-54c52011e5ea€24.00€0.37matched
88capture01a1a919-bc80-70c7-82fe-73d6780c2f2b€24.00€0.37matched
89capture01a1a919-c01e-7704-a015-d641cf244fce€49.00€0.67matched
90capture01a1a919-ea06-712f-82a7-43089fe8cc09€24.00€0.37matched
91capture01a1a919-ee35-76fe-b83e-8d607aa04bdb€9.00€0.19matched
92refund01a1a91a-0833-7901-96fc-f35529394305-€42.00€0.00matched
93capture01a1a91a-34c1-7f01-b7ff-c4e5b84e253f€9.00€0.19matched
94capture01a1a91a-63ae-7240-8e73-97093f2e831c€24.00€0.37matched
95capture01a1a91a-7b96-78c8-adc7-8d77a2da9ec2€24.00€0.37matched
96capture01a1a91a-922e-766d-9e04-c2c508a3ef63€9.00€0.19matched
97capture01a1a91a-9bba-7064-8a74-9fecd30e5c40€49.00€0.67matched
98capture01a1a91a-c61b-7e4a-9060-d98b68b23237€35.00€0.50matched
100capture01a1a91a-d403-7a27-b031-0d9650b028e2€9.00€0.19matched
101refund01a1a91a-d561-7c56-aa54-b240ec731a67-€44.00€0.00matched
102capture01a1a91a-ece0-75ca-90dd-67efde95a1d5€35.00€0.50matched
103capture01a1a91a-f17e-726a-a78c-2578531d9cd3€49.00€0.67matched
104capture01a1a91b-1191-7194-b9f6-51fc77b540c5€49.00€0.67matched
105capture01a1a91b-18cd-7f52-8191-6daa4c630bdc€35.00€0.50matched
106capture01a1a91b-296a-740c-92ab-6b2ad779f6f5€15.00€0.26matched
107capture01a1a91b-41c5-7e3f-b6f7-3ba8c74d285d€49.00€0.67matched
108capture01a1a91b-5e6f-7a74-ba0c-aff36545a786€49.00€0.67matched
109capture01a1a91b-6720-7824-9268-c851b2cbb486€35.00€0.50matched
110capture01a1a91b-7390-72df-9d6b-1e3cb78051e6€35.00€0.50matched
111capture01a1a91b-8726-72b0-89a1-9f5e08f49bc0€9.00€0.19matched
112capture01a1a91b-89f2-7f21-8b3b-082a784aa686€9.00€0.19matched
113refund01a1a91b-8a87-7ca2-abc4-6ce0b3d2395a-€14.00€0.00matched
114capture01a1a91b-93e8-7f39-bd92-22103c2974d1€24.00€0.37matched
115capture01a1a91b-a368-76c2-8129-8faa5d317d31€15.00€0.26matched
116capture01a1a91b-df1c-7e97-83fd-baaa9fe13d1b€35.00€0.50matched
117capture01a1a91b-e49f-73bd-a934-b401cc8a1070€49.00€0.67matched
118capture01a1a91c-02c2-794d-9f6e-f4eab352e741€35.00€0.50matched
119capture01a1a91c-10f6-7fd4-acdd-a942eededf2a€35.00€0.50matched
120capture01a1a91c-1595-77c5-b5b0-5e109ffafe43€15.00€0.26matched
121capture01a1a91c-2310-7580-b028-4bffaca904b5€24.00€0.37matched
122capture01a1a91c-6a0d-7826-b59d-8ea05c64688f€49.00€0.67matched
123capture01a1a91c-6b5f-7868-b649-178ad86613f0€35.00€0.50matched
124capture01a1a91c-8bc7-7efe-adac-3d0e9cee7fa9€9.00€0.19matched
125capture01a1a91c-92bc-7b82-a638-3a980ca6a32b€49.00€0.67matched
126capture01a1a91c-96fd-79ed-8151-1a1d513a2380€35.00€0.50matched
127capture01a1a91c-a3f9-759b-b2b4-1e5a556fa648€24.00€0.37matched
128capture01a1a91c-aed7-795a-a515-689bdcf3c825€35.00€0.50matched
129capture01a1a91c-b15f-7681-b550-7351299e2ab7€9.00€0.19matched
130capture01a1a91c-b3d8-7ea3-b9dc-dd18edbaae11€24.00€0.37matched