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

2 Nov, 07:10

Gross

€3,220.00

PSP fee

€50.87

Net to the bank

€3,169.13

Settlement journal

#338744

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

LineKindReferenceGrossFeeStatus
1capture01a19b14-6540-772b-8c68-43acb9637501€15.00€0.26matched
2capture01a19b15-e4af-7e3d-a97f-4aec6f8bf51e€24.00€0.37matched
3capture01a19b17-f165-7e50-8f03-969767c9070b€9.00€0.19matched
4capture01a19b18-3114-72c5-8ddc-1d672d32a90a€15.00€0.26matched
5capture01a19b18-450b-7e38-bdc5-a4f0133d480c€15.00€0.26matched
6capture01a19b18-52b8-70d7-994d-ce8c03bdb9e7€9.00€0.19matched
7capture01a19b18-54af-779a-bda4-852e8c181b7e€15.00€0.26matched
8capture01a19b18-7704-736c-b47f-9f9e067fdfe3€9.00€0.19matched
9capture01a19b18-7ef6-7ff8-9443-4bee42da8406€9.00€0.19matched
10capture01a19b18-7ee0-72b8-9392-7c6c8e48b3ae€24.00€0.37matched
11refund01a19b18-a728-7432-96b8-dde923cdcb82-€9.00€0.00matched
12capture01a19b18-c2d1-740a-8b2f-73c4c015f8bb€15.00€0.26matched
13capture01a19b18-c2e0-78cc-a139-342debb6cc8d€24.00€0.37matched
14capture01a19b18-cb1b-7a98-aa9a-b5f998e01081€15.00€0.26matched
15capture01a19b18-cec5-79a4-9f8d-ab3a2aff13f5€35.00€0.50matched
16capture01a19b18-d1f9-705c-83b0-0f21e399eb9f€9.00€0.19matched
17capture01a19b18-de49-7964-b69c-f983615945b3€49.00€0.67matched
18capture01a19b18-fde5-7048-9279-f0c7c7c9a02e€49.00€0.67matched
19capture01a19b19-21a5-7b88-8d59-36c9115a70a9€35.00€0.50matched
20capture01a19b19-3a03-7e82-96a1-b3a1a2b3d20c€49.00€0.67matched
21capture01a19b19-5683-73f8-8fe4-900b4f06a016€24.00€0.37matched
22capture01a19b19-60aa-7f3b-a88c-1f2b5a69235d€49.00€0.67matched
23capture01a19b19-610b-7a95-a58a-f806036158c6€35.00€0.50matched
24capture01a19b19-638e-73d0-8209-6e43697799b2€49.00€0.67matched
25capture01a19b19-69a1-7659-9f5a-e4f12a27d437€9.00€0.19matched
26capture01a19b19-8bd8-7a94-bb41-e13c5723d267€24.00€0.37matched
27capture01a19b19-9110-74ce-a534-e2f5f2bb2382€49.00€0.67matched
28capture01a19b19-9139-7a07-80f6-846c4b993ec5€9.00€0.19matched
29capture01a19b19-d0a7-7199-b7ee-23577e771fe9€49.00€0.67matched
30capture01a19b19-d8b5-7276-a8f9-6ecc7fb818db€15.00€0.26matched
31capture01a19b19-e14f-77ad-ad00-605e25c232df€24.00€0.37matched
32capture01a19b19-e823-7df4-8838-7df84094862d€15.00€0.26matched
33capture01a19b1a-0592-7794-b313-44c55efa33be€35.00€0.50matched
34refund01a19b1a-162e-7464-aee7-0e8c0e50a090-€13.00€0.00matched
35capture01a19b1a-25ee-7002-ae7b-d3902ba2e2d1€49.00€0.67matched
36capture01a19b1a-2b85-7f69-9223-72b306b1aaed€24.00€0.37matched
37capture01a19b1a-3366-711c-a241-a3e46a7733e1€35.00€0.50matched
38capture01a19b1a-4188-7d30-9ca0-932d4126a794€15.00€0.26matched
39capture01a19b1a-5871-76bc-9182-dd05200efba7€49.00€0.67matched
40capture01a19b1a-6b0e-769d-a3d7-bd8a3e7702e3€49.00€0.67matched
41capture01a19b1a-7783-7012-ae52-d8e55e9d74d5€49.00€0.67matched
42capture01a19b1a-8982-7116-aa36-3229e9256e47€15.00€0.26matched
43capture01a19b1a-a38a-732a-b546-1aa5473d7cf4€15.00€0.26matched
44capture01a19b1a-a5c8-74d9-b7ce-2b6bdf378861€15.00€0.26matched
45capture01a19b1a-c8d6-76b3-93e8-e9f9c63a7fb6€49.00€0.67matched
46capture01a19b1a-c005-73b2-af14-64d1caf546b5€49.00€0.67matched
47refund01a19b1a-cd25-73f2-8b79-08ebd0c26485-€38.00€0.00matched
48capture01a19b1a-cf85-7ef4-bb3a-029616d6abab€35.00€0.50matched
49capture01a19b1a-f13e-760f-a2f8-b3dada3b2589€9.00€0.19matched
50capture01a19b1a-f529-739d-b121-551e2b4f2558€49.00€0.67matched
51capture01a19b1a-f7dc-72b5-8c82-a0004bd3160a€49.00€0.67matched
52capture01a19b1b-022a-7706-99b3-f90e1db8d485€24.00€0.37matched
53capture01a19b1b-0aa8-742d-9768-79a4d2cc65a1€49.00€0.67matched
54capture01a19b1b-1efd-7a7a-9938-d8c6577957c8€49.00€0.67matched
55capture01a19b1b-2218-706a-92f5-45d8f4243fca€24.00€0.37matched
56capture01a19b1b-2505-74f2-8f09-81a037b69a1b€35.00€0.50matched
57capture01a19b1b-2dae-7e66-8885-02686dff6fcf€49.00€0.67matched
58capture01a19b1b-3e00-76e6-8939-9bc7276a9032€35.00€0.50matched
59capture01a19b1b-55d9-7e69-9589-6e57c56f4b5a€9.00€0.19matched
60capture01a19b1b-656a-7115-8f95-23e1f30767bd€49.00€0.67matched
61capture01a19b1b-6f31-7f10-9faa-4ad501dbd8a5€24.00€0.37matched
62capture01a19b1b-8c6a-7276-b171-9591a548aed0€49.00€0.67matched
63capture01a19b1b-96fe-7101-a405-366e398eebed€24.00€0.37matched
64capture01a19b1c-1330-7cb4-b039-f4896c5365cf€24.00€0.37matched
65capture01a19b1c-1461-75c4-aa3d-e287430ecc54€24.00€0.37matched
66capture01a19b1c-2c64-719d-bcbf-197d5e0130ef€15.00€0.26matched
67capture01a19b1c-56fa-7bf0-ab56-fc71470eac01€9.00€0.19matched
68capture01a19b1c-5ebc-75c6-bd03-dca98b8358d4€9.00€0.19matched
69refund01a19b1c-6fae-7ce6-95af-33f5f866f568-€22.00€0.00matched
70capture01a19b1c-835c-72d2-9c82-97bb68ef95ca€35.00€0.50matched
71capture01a19b1c-9b8a-77ac-a890-613b3bacd63d€24.00€0.37matched
72refund01a19b1c-f9a9-76af-9861-ee20eed77541-€24.00€0.00matched
73capture01a19b1d-0188-7fb9-9ac2-a8eaa973fdf5€35.00€0.50matched
74capture01a19b1d-0363-7cea-8cdb-84c9f2f80d0a€9.00€0.19matched
75capture01a19b1d-19a3-7666-92e6-176ec9b471fe€9.00€0.19matched
76capture01a19b1d-26ae-7a6a-8a69-088b837e8299€35.00€0.50matched
77capture01a19b1d-2b22-79d6-893b-bc6a3a7f4e33€49.00€0.67matched
78capture01a19b1d-2ed5-7f45-bb17-7a9caa6cf5a0€49.00€0.67matched
79capture01a19b1d-329c-7fad-9edf-f19baec49b17€35.00€0.50matched
80capture01a19b1d-472e-7d13-b5d4-26a93cdf30f6€15.00€0.26matched
81capture01a19b1d-5208-7a72-a7a9-c9b59d9fc496€9.00€0.19matched
82capture01a19b1d-545a-7b6f-95c6-99dcc02f2b19€49.00€0.67matched
83capture01a19b1d-54d4-7c2f-818a-841cf9aade02€9.00€0.19matched
84capture01a19b1d-810f-763c-ab13-346deb0ed0ec€9.00€0.19matched
85capture01a19b1d-88e1-7e61-8b10-c9560b55d064€15.00€0.26matched
86capture01a19b1d-9b1b-70b7-9bc5-cc799c875a00€15.00€0.26matched
87capture01a19b1d-a32a-7be6-9065-4b647ce9ba62€35.00€0.50matched
88refund01a19b1d-a691-7f69-88dd-ca3f0cf56215-€8.00€0.00matched
89capture01a19b1d-aca1-724b-a04f-0faf98ce0d4e€24.00€0.37matched
90capture01a19b1d-b5b4-7670-91bb-dd33a8632217€15.00€0.26matched
91refund01a19b1d-d6af-7a43-981a-55957ae7b6e5-€14.00€0.00matched
92capture01a19b1d-dabf-7e6e-942d-5f2b80993d7d€24.00€0.37matched
93capture01a19b1e-1a52-76a5-964b-a38aa5408e31€35.00€0.50matched
94capture01a19b1e-2e0f-75fd-a39e-785b055d70c3€15.00€0.26matched
95capture01a19b1e-595e-7745-b515-8b24d5a30220€49.00€0.67matched
96capture01a19b1e-9db3-798f-89fd-6b637333ea0e€35.00€0.50matched
97capture01a19b1e-afbd-7707-856d-2edf1be0d391€9.00€0.19matched
98capture01a19b1e-afc9-7724-b240-e78c7e13e445€35.00€0.50matched
99capture01a19b1e-c39d-7650-ae7f-4952dc734aa3€15.00€0.26matched
100capture01a19b1e-db35-7ca2-bc35-91271f12e22e€15.00€0.26matched
101capture01a19b1e-f2b6-7da7-8b2b-c75d1a660371€35.00€0.50matched
102capture01a19b1e-ff12-7f1b-a5db-b0b7f853d2a5€9.00€0.19matched
103capture01a19b1f-0337-7e7d-b674-b0eb5e3be9e9€15.00€0.26matched
104capture01a19b1f-3ce7-76d8-8cc6-ca98f5132c6a€49.00€0.67matched
105capture01a19b1f-5104-7670-84b4-5e6f0a32fda3€9.00€0.19matched
106capture01a19b1f-5410-7618-93d3-c30a2b2cfdb7€9.00€0.19matched
107refund01a19b1f-5732-707d-a6bb-b8ae005acafe-€10.00€0.00matched
108refund01a19b1f-655e-7457-bbd7-ebd44a37d5fd-€25.00€0.00matched
109refund01a19b1f-8b4d-7a50-bb74-5257ac8ec6f3-€4.00€0.00matched
110capture01a19b1f-8be1-79d2-810c-1713cb19698a€35.00€0.50matched
111capture01a19b1f-90b6-7efd-97ec-7e1afb9f66d1€49.00€0.67matched
112capture01a19b1f-bf63-756d-91be-9a4fe92e3f51€49.00€0.67matched
113capture01a19b1f-fc64-799b-9e52-15183e093831€9.00€0.19matched
114capture01a19b20-12ba-72a3-b2e2-e769a7d8a29e€24.00€0.37matched
115capture01a19b20-1ad9-7fcd-a25a-489aa6286fa5€49.00€0.67matched
116capture01a19b20-1ec7-799d-81ed-ecdd5742354a€35.00€0.50matched
117capture01a19b20-21c8-726c-84fb-4385aaf53353€15.00€0.26matched
118refund01a19b20-2b07-7394-9e16-cd951dde3d0f-€20.00€0.00matched
119capture01a19b20-3fb8-7f6d-901c-532d9640efe3€15.00€0.26matched
120capture01a19b20-424e-7e78-8b89-8daf2f182a45€49.00€0.67matched
121capture01a19b20-46e6-7888-b369-b9fd4476ea52€9.00€0.19matched
122capture01a19b20-485e-7219-a137-df3183beddaf€24.00€0.37matched
123capture01a19b20-80b2-70e6-8ca2-03e26c50baa6€35.00€0.50matched
124capture01a19b20-8a52-748d-a528-a55c5e066c6c€35.00€0.50matched
125capture01a19b20-9f48-7ff7-a38b-ac53d00969a8€35.00€0.50matched
126capture01a19b20-a270-7a1e-b30b-6cecdd3c3ebc€24.00€0.37matched
127capture01a19b20-abdb-7a59-83be-3616a6854720€15.00€0.26matched
128capture01a19b20-cc7c-7a6a-9be7-6c6f86210836€49.00€0.67matched
129capture01a19b20-d414-7874-bde3-2fbbd707b774€24.00€0.37matched
130capture01a19b20-e5f0-7193-b896-b98cfc93dcd2€35.00€0.50matched
131capture01a19b20-f445-78f0-82b2-ca5dcb92d618€35.00€0.50matched
132capture01a19b21-0462-7031-a915-eecf1a8f0b45€15.00€0.26matched
133capture01a19b21-07f3-7b0b-b995-67b40811ccbe€9.00€0.19matched
134capture01a19b21-09ec-7d72-b858-176fd6cd827e€35.00€0.50matched