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

Gross

€3,609.00

PSP fee

€56.71

Net to the bank

€3,552.29

Settlement journal

#378312

Every line paired with the books, and every capture and refund of the day is in the file.

LineKindReferenceGrossFeeStatus
1capture01a1a637-80cf-7339-9bbc-537e52b17067€49.00€0.67matched
2capture01a1a63b-6356-76cd-a6a4-e68b46296d92€15.00€0.26matched
3capture01a1a63f-40a5-73a4-9463-e38d3790624b€24.00€0.37matched
4capture01a1a640-7bdd-73e7-8168-3ddcfa1e90eb€9.00€0.19matched
5capture01a1a640-b3bf-7f63-b47c-cab5beebcde9€15.00€0.26matched
6capture01a1a640-c53c-7fd5-87b7-7d85dc17b1a2€9.00€0.19matched
7capture01a1a640-e1f6-7c60-854e-890423ef3ec4€9.00€0.19matched
8capture01a1a640-f077-7aa5-80ed-342c8f6e452b€15.00€0.26matched
9capture01a1a640-f0c0-72f7-93d4-e7e84f80399a€35.00€0.50matched
10capture01a1a640-fde5-7b84-b653-94c0eef669e2€49.00€0.67matched
11capture01a1a641-0bde-71a5-a686-1adc76f6e099€9.00€0.19matched
12capture01a1a641-1b29-74cf-90a2-9f1957158ff6€35.00€0.50matched
13capture01a1a641-1bc6-7db3-96d6-3992f8c2d603€15.00€0.26matched
14refund01a1a641-2e88-73e6-9a00-0a7841f41770-€8.00€0.00matched
15capture01a1a641-3f78-7e7d-8abc-b92c0cf80abf€24.00€0.37matched
16capture01a1a641-46ab-78d5-9995-773d0831046c€24.00€0.37matched
17capture01a1a641-5172-760f-8840-25a75110da76€24.00€0.37matched
18refund01a1a641-5489-74f5-9244-6bdd3c4670d0-€5.00€0.00matched
19capture01a1a641-8783-76b6-bc39-cc2a7134d878€49.00€0.67matched
20capture01a1a641-8bdb-7c27-a458-32b7260ca8d2€15.00€0.26matched
21capture01a1a641-a8f9-7a4d-8276-71b76752df28€24.00€0.37matched
22capture01a1a641-f76e-73a0-b668-cca2140cf1a7€9.00€0.19matched
23capture01a1a641-fdc9-791d-86d3-213fe663c2fc€35.00€0.50matched
24capture01a1a642-09d7-7c6f-9047-e7a951358d09€49.00€0.67matched
25capture01a1a642-0ef2-75b2-9ab3-49bd4616b104€24.00€0.37matched
26capture01a1a642-2f85-73e7-b162-2e8d6a8f7d8b€35.00€0.50matched
27capture01a1a642-39ac-7185-9eaa-9355b5a37c50€49.00€0.67matched
28capture01a1a642-3f48-7e01-a05c-d4b0e31ac493€24.00€0.37matched
29capture01a1a642-4013-73e4-8ce8-faaf3f38cca3€35.00€0.50matched
30capture01a1a642-54cb-7fd8-87aa-4a06da172d28€49.00€0.67matched
31capture01a1a642-6b4e-7869-9570-ec506fa882d3€35.00€0.50matched
32capture01a1a642-9d6c-7f78-ba50-14dc6a5555e0€35.00€0.50matched
33refund01a1a642-a47c-72d8-8aa6-7be8370d100c-€32.00€0.00matched
34refund01a1a642-b438-7a44-9bb1-f928d5332e4e-€33.00€0.00matched
35capture01a1a642-dab6-771f-a046-a9b861110611€35.00€0.50matched
36capture01a1a642-e516-7c66-8374-ee3d7902bdc2€49.00€0.67matched
37capture01a1a642-e76c-7fe2-8224-fd17be7b133b€15.00€0.26matched
38capture01a1a642-ee03-7bb1-85a7-d6fb27c2aa94€35.00€0.50matched
39capture01a1a643-12bf-7d00-941f-a406d884cf32€24.00€0.37matched
40capture01a1a643-4617-7306-8d75-73864aa001cd€15.00€0.26matched
41capture01a1a643-448a-77c1-94fc-e9926bd48b63€9.00€0.19matched
42capture01a1a643-4729-7555-a4b8-1941de7ffc0a€9.00€0.19matched
43capture01a1a643-5443-7f12-83da-d0df25fb2b19€24.00€0.37matched
44capture01a1a643-555f-7739-89e9-371724b0e9e1€15.00€0.26matched
45capture01a1a643-5890-7385-b7a8-58b457a54f8f€35.00€0.50matched
46capture01a1a643-6a47-7053-a744-91af0943af41€24.00€0.37matched
47capture01a1a643-6dfb-7063-9439-2d29e2aa066e€15.00€0.26matched
48refund01a1a643-9a9f-7bd3-a1ae-26563394a210-€15.00€0.00matched
49capture01a1a643-9b32-7a28-b054-30cda4635282€9.00€0.19matched
50capture01a1a643-aac5-7a90-8102-627fe900f6a1€49.00€0.67matched
51capture01a1a643-b30d-7640-a886-d220b56ed38b€9.00€0.19matched
52capture01a1a643-b596-7bae-ae14-964c6c533592€15.00€0.26matched
53capture01a1a643-bc2e-786a-bfe4-ec07b06402aa€35.00€0.50matched
54capture01a1a643-c3d8-783b-8580-49dd142f6fd2€49.00€0.67matched
55capture01a1a643-dba4-7935-9724-af546a3a8838€9.00€0.19matched
56capture01a1a643-e9f2-7214-8dd9-4d9e79a07310€35.00€0.50matched
57capture01a1a643-f884-7415-9d4a-cfaecd2f5737€24.00€0.37matched
58capture01a1a644-0756-7fe1-8eae-f4d4789575a9€49.00€0.67matched
59refund01a1a644-2203-712b-a41e-a125e83b1fbd-€5.00€0.00matched
60capture01a1a644-27f9-7ea7-b911-2b1e22b5d428€35.00€0.50matched
61capture01a1a644-367a-7ef0-ac41-8586c8737c09€24.00€0.37matched
62capture01a1a644-40d6-7266-9880-73e068109f1e€24.00€0.37matched
63capture01a1a644-4c3d-7438-b182-c09d53a9ee68€49.00€0.67matched
64capture01a1a644-635d-7d7c-b48f-9ca8aa693bfb€35.00€0.50matched
65capture01a1a644-640a-7a7e-acbc-bf7f5561b4d5€35.00€0.50matched
66refund01a1a644-68af-76d0-adf8-8548537fec8f-€18.00€0.00matched
67capture01a1a644-79c6-7d24-a669-820f9c042dea€15.00€0.26matched
68capture01a1a644-7b6a-7a79-bf4f-9c677ade70db€35.00€0.50matched
69capture01a1a644-93fc-702f-88fd-077e0f8d2daa€49.00€0.67matched
70capture01a1a644-977f-7caa-8fda-0217a283e152€24.00€0.37matched
71capture01a1a644-9cb7-7baa-b0a9-852d4f2a32c6€49.00€0.67matched
72capture01a1a644-a624-70a6-bd02-8eea9bebdc19€15.00€0.26matched
73capture01a1a644-b0f5-7065-ac81-a6d203279bd2€24.00€0.37matched
74capture01a1a644-b5b4-7018-9aab-62d1f1483829€49.00€0.67matched
75capture01a1a644-b8fe-75b3-b402-aaf76ebedc49€24.00€0.37matched
76capture01a1a645-0391-73c4-923c-762a571faa0c€15.00€0.26matched
77capture01a1a645-1196-74a7-90d0-a35b0db0c7e7€15.00€0.26matched
78capture01a1a645-17b6-76bf-a429-029e5be675be€49.00€0.67matched
79capture01a1a645-1fee-77a8-9b81-35d81aeea5e7€49.00€0.67matched
80capture01a1a645-2209-78aa-af06-992776c72585€35.00€0.50matched
81capture01a1a645-2da4-7779-aed4-068d22ade98f€24.00€0.37matched
82capture01a1a645-4508-7275-aa2d-4fc662bec910€15.00€0.26matched
83refund01a1a645-4e6b-7565-81c8-8919be1eb276-€25.00€0.00matched
84capture01a1a645-5d10-7170-947a-807b4aed38d1€15.00€0.26matched
85capture01a1a645-5e0a-7dec-8b92-6d55d6e1d5ba€24.00€0.37matched
86capture01a1a645-662b-7cfb-a033-37110aed7568€24.00€0.37matched
87capture01a1a645-715d-78c6-afbc-d59eb7845f83€24.00€0.37matched
88capture01a1a645-75ac-7fd7-9f95-bfd5a85ef61c€15.00€0.26matched
89capture01a1a645-8520-7963-8a71-e1af3bc120a4€35.00€0.50matched
90capture01a1a645-a373-7f95-b622-4eafc745b494€15.00€0.26matched
91capture01a1a645-b921-7e97-9a5d-e36811f5bae4€24.00€0.37matched
92capture01a1a645-d2d7-7840-8472-cbb0081a4de4€49.00€0.67matched
93capture01a1a645-da73-7ff2-8d37-2450092048ff€15.00€0.26matched
94capture01a1a645-f770-777e-bb19-3dbc1b217b55€9.00€0.19matched
95capture01a1a646-2cd6-7cfd-80b3-2abc56aee0a2€35.00€0.50matched
96capture01a1a646-2da0-78d3-823a-ff9d6359d268€15.00€0.26matched
97capture01a1a646-3733-72b3-ac12-4279be4a2285€9.00€0.19matched
98capture01a1a646-38d1-7357-8e37-91f8b4b4f032€15.00€0.26matched
99capture01a1a646-51ae-7f65-a72a-7c6f892e364f€49.00€0.67matched
100capture01a1a646-6568-782b-bc9f-b279dc033e29€15.00€0.26matched
101capture01a1a646-7194-71f0-9768-fe426a834158€15.00€0.26matched
102capture01a1a646-7300-7843-9734-0660cd4ab20d€15.00€0.26matched
103refund01a1a646-9f4b-741b-b5db-28daa9fc8985-€5.00€0.00matched
104capture01a1a646-afc2-7dd0-8c22-90f49cfd7ba7€49.00€0.67matched
105capture01a1a646-d6cc-71b6-adc0-e3fc6e30753b€24.00€0.37matched
106capture01a1a646-fe3f-7563-8687-e50f9aafcbb4€24.00€0.37matched
107capture01a1a647-234d-7e70-bf86-5ec5e8a1397a€49.00€0.67matched
108capture01a1a647-2fbe-730f-aa02-d2bd5d07627a€24.00€0.37matched
109capture01a1a647-464d-7fcc-842b-cf8db0caaa54€15.00€0.26matched
110capture01a1a647-4c00-764e-972f-0f913b0b85ef€9.00€0.19matched
111capture01a1a647-4ee4-7774-a719-87ed17576e85€24.00€0.37matched
112capture01a1a647-4b50-7162-bf68-464fb5e0915e€24.00€0.37matched
113capture01a1a647-5973-7b7b-adc9-12e7166d42b4€9.00€0.19matched
114capture01a1a647-754f-703e-8b88-bfa2c5847de7€49.00€0.67matched
115capture01a1a647-7fcd-73a7-bd9b-6a28b93050fd€24.00€0.37matched
116capture01a1a647-ab32-793a-a244-36caa2e4bc79€49.00€0.67matched
117capture01a1a647-b777-75e2-afff-6c5bd5bad735€9.00€0.19matched
118capture01a1a647-bcac-74ff-92e1-605aaed52d78€15.00€0.26matched
119capture01a1a647-d03a-7cad-a621-06489e57d2b4€24.00€0.37matched
120capture01a1a647-d664-7f11-9c6b-d149d9f9be22€9.00€0.19matched
121capture01a1a647-e5fa-7875-8e1a-d45d167571a2€15.00€0.26matched
122capture01a1a647-f255-7a3c-9f47-c0f16061eaef€49.00€0.67matched
123capture01a1a647-fa68-7191-a3f5-b618c1a565de€49.00€0.67matched
124capture01a1a647-fdee-7f3f-b833-26d49026fad7€24.00€0.37matched
125capture01a1a648-2760-7a30-b7e9-01d51298af4f€24.00€0.37matched
126capture01a1a648-3216-72b4-b3e7-84a683b08e32€49.00€0.67matched
127capture01a1a648-40a5-709b-9ba0-68b061b9ab41€15.00€0.26matched
128capture01a1a648-49ff-7e19-8b91-ce701c1f3f74€49.00€0.67matched
129capture01a1a648-4c2b-765f-a2c3-ecc3e53df1c7€24.00€0.37matched
130capture01a1a648-56d9-7763-9a9b-dd6d331f36be€24.00€0.37matched
131capture01a1a648-8663-78de-8898-a5238d62054d€15.00€0.26matched
132capture01a1a648-87b6-75dd-a023-cbeb19f2096d€49.00€0.67matched
133capture01a1a648-a2d8-7dab-b6d0-8aec39e7fc8d€35.00€0.50matched
134capture01a1a648-a76e-758a-b8ad-0984736dd761€15.00€0.26matched
135capture01a1a648-b9b3-71c6-9976-c870ad68b537€15.00€0.26matched
136capture01a1a648-bc2c-73f4-8e4f-33e95187a82f€49.00€0.67matched
137capture01a1a648-e356-7447-820e-f1266d83c8f8€49.00€0.67matched
138capture01a1a648-eb38-72fd-bbe1-72d3689d5a3c€35.00€0.50matched
139capture01a1a648-f519-7fcd-9e28-505f23e61cc2€24.00€0.37matched
140capture01a1a648-f8cb-71e6-bbd0-9bb14c11b1d9€35.00€0.50matched
141capture01a1a649-0524-7cc5-8e20-e23a739abca7€49.00€0.67matched
142capture01a1a649-0890-7f45-b617-2061e39a1362€35.00€0.50matched
143capture01a1a649-0f0c-7c44-8484-b46c2b58ac38€24.00€0.37matched
144refund01a1a649-4e56-7d59-8341-2775a84a8812-€30.00€0.00matched
145capture01a1a649-53ac-745b-a94d-d8a0acf67cc9€49.00€0.67matched
146capture01a1a649-6b44-7d7f-bfef-39dab490de18€9.00€0.19matched
147capture01a1a649-6bdf-727d-9324-412689a6665d€9.00€0.19matched
148capture01a1a649-6db8-72cf-bb40-848bb458e2df€9.00€0.19matched
149capture01a1a649-8ade-7151-9964-041daad09cfe€9.00€0.19matched