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, 06:20

Gross

€2,714.00

PSP fee

€44.26

Net to the bank

€2,669.74

Settlement journal

#338123

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

LineKindReferenceGrossFeeStatus
1capture01a19ae4-0ee3-7fee-a2a0-36c8a7f6094a€15.00€0.26matched
2refund01a19ae6-ade8-7bc5-9441-ce97a7e40141-€5.00€0.00matched
3refund01a19ae6-be01-73b2-a078-298427094750-€15.00€0.00matched
4capture01a19ae7-b604-7e18-b304-23e4a6367dc7€15.00€0.26matched
5capture01a19aea-34c7-7700-b19c-6ed5aeeba52b€9.00€0.19matched
6capture01a19aea-4199-7c28-af28-f7604fa40678€9.00€0.19matched
7capture01a19aea-510b-7c04-8d96-a0b6243d0341€15.00€0.26matched
8capture01a19aea-5d50-701c-9e30-720ab2e768f4€9.00€0.19matched
9refund01a19aea-5d5b-78f3-acc8-6ccb8b2eac13-€10.00€0.00matched
10refund01a19aea-67ec-7306-a033-69f0e0987f71-€20.00€0.00matched
11capture01a19aea-7de7-7937-891d-b915674dd094€49.00€0.67matched
12capture01a19aea-90db-737c-84e6-370aca63b2fa€49.00€0.67matched
13capture01a19aea-a7b3-7d90-ac32-0395d4fa8089€15.00€0.26matched
14capture01a19aea-ed21-7d6e-b7c3-bbb2a6d0b8e0€9.00€0.19matched
15capture01a19aeb-0098-7855-8411-25d84d26a9e9€49.00€0.67matched
16capture01a19aeb-064e-7672-b50e-0f38a9b01075€35.00€0.50matched
17capture01a19aeb-2acc-7a53-97d3-ecab492f4f2d€24.00€0.37matched
18capture01a19aeb-2ebf-7d51-982b-f21179b636f8€15.00€0.26matched
19capture01a19aeb-382f-74e1-bd61-26cad09c4449€9.00€0.19matched
20capture01a19aeb-46e3-722a-af81-85500efb89e1€24.00€0.37matched
21capture01a19aeb-4bb1-7a65-9e14-6cd91589f784€9.00€0.19matched
22capture01a19aeb-82a5-7cbe-89f9-582622fff5d4€15.00€0.26matched
23capture01a19aeb-94e3-71ee-88f8-6df8646dc2b5€9.00€0.19matched
24capture01a19aeb-a20b-7c35-b923-8d160429e385€49.00€0.67matched
25capture01a19aeb-a48f-7bf7-9ae4-b65624309eaf€49.00€0.67matched
26capture01a19aeb-a964-7753-802f-01e985477524€15.00€0.26matched
27capture01a19aeb-b153-768c-98a9-1cea20b60e9d€15.00€0.26matched
28refund01a19aeb-d86f-79be-a2b0-fd19e720359b-€12.00€0.00matched
29capture01a19aeb-e7b2-7e82-9369-be35a9389965€9.00€0.19matched
30capture01a19aeb-fb24-7d9d-b104-25458add26a4€24.00€0.37matched
31capture01a19aec-04c3-774a-80fe-5f1e6e5a88d9€15.00€0.26matched
32capture01a19aec-2c7b-7395-9719-1ee81292a1c7€15.00€0.26matched
33capture01a19aec-58e8-7831-ae7f-5f237e66c5e7€49.00€0.67matched
34capture01a19aec-62f7-790b-ae43-223b71a05fd7€9.00€0.19matched
35capture01a19aec-69e5-7050-b10f-2a3d98e5a2c5€35.00€0.50matched
36capture01a19aec-6f21-72f7-8968-6d207522ae0f€24.00€0.37matched
37capture01a19aec-9efa-77cc-95e5-40226d29d331€24.00€0.37matched
38capture01a19aec-aa72-7cec-bc1c-167a4b970d55€35.00€0.50matched
39refund01a19aec-be97-769f-83b0-a9b43a3fe66b-€20.00€0.00matched
40capture01a19aec-f0f0-707d-8b30-163e978d0550€35.00€0.50matched
41capture01a19aec-fd74-7611-816e-fe82e10e78c7€35.00€0.50matched
42capture01a19aed-2bd0-7b6e-99fb-838c89148d10€35.00€0.50matched
43capture01a19aed-296a-7bf2-bc50-9d78d7ef8c36€9.00€0.19matched
44capture01a19aed-4687-7fff-ba50-b20cfa463aa1€15.00€0.26matched
45capture01a19aed-4dc1-752b-92ba-ebbb006256ee€35.00€0.50matched
46capture01a19aed-55ec-73b3-8e70-f1d6e8a2efca€24.00€0.37matched
47capture01a19aed-65d1-7c14-a84d-285d86b630ca€24.00€0.37matched
48capture01a19aed-6a1d-7357-952b-585d0555eb56€9.00€0.19matched
49capture01a19aed-7a50-7152-98ca-db5c54da818c€15.00€0.26matched
50capture01a19aed-857d-76ee-a80d-66183fc8fd0e€15.00€0.26matched
51capture01a19aed-8a8d-7ab4-9f4c-75b903fd9acc€9.00€0.19matched
52capture01a19aed-8bda-759a-9392-df00c23b0d9f€15.00€0.26matched
53capture01a19aed-95fb-723a-a0a3-5db29613babb€24.00€0.37matched
54capture01a19aed-a21e-7656-81f7-eb8a1221855f€15.00€0.26matched
55capture01a19aed-a791-7745-b04d-ee31990a8326€24.00€0.37matched
56capture01a19aed-a984-7940-904e-b6b46053e00c€24.00€0.37matched
57capture01a19aed-acb5-7e72-a5b0-47213651e40f€15.00€0.26matched
58capture01a19aed-b2f8-7d96-a80d-20181c5dac4e€24.00€0.37matched
59refund01a19aed-bbd9-7436-9f60-18750ce3df8a-€7.00€0.00matched
60capture01a19aed-e5b7-7ec9-b564-35d580e68a24€15.00€0.26matched
61capture01a19aed-e69c-7630-9df7-167a92ae6849€49.00€0.67matched
62capture01a19aee-1735-75fe-a445-e1ff80d29cc6€35.00€0.50matched
63capture01a19aee-1bad-7017-b513-955a103d15c9€49.00€0.67matched
64capture01a19aee-3484-7284-b60b-541bbeced6ce€24.00€0.37matched
65capture01a19aee-53e8-7797-9fb7-21c264e95034€9.00€0.19matched
66capture01a19aee-5eef-7c9d-a598-5c0b5d4b8f54€49.00€0.67matched
67capture01a19aee-635c-76bb-9959-6ab3c2fd2120€24.00€0.37matched
68capture01a19aee-6409-71e1-9575-4f6de20ed48c€15.00€0.26matched
69capture01a19aee-7237-78db-ad06-5435d008ad62€15.00€0.26matched
70capture01a19aee-78a2-7e42-a17e-5a058aab52d4€15.00€0.26matched
71capture01a19aee-8f49-7241-820e-2ff390432c8b€24.00€0.37matched
72capture01a19aee-98ff-7ff2-b110-47cafd413123€9.00€0.19matched
73capture01a19aee-b2f7-7798-b292-bf1580202264€24.00€0.37matched
74refund01a19aee-ca0e-7fbf-8593-372856096bd5-€9.00€0.00matched
75capture01a19aee-d160-7a44-afad-4d4a5ce3ce29€9.00€0.19matched
76capture01a19aee-d7c3-7fa1-addf-e1c00b68ab5b€24.00€0.37matched
77capture01a19aee-ea0a-7500-a6c8-35c72ca54154€35.00€0.50matched
78capture01a19aef-0a2f-7824-8c48-7fc42afcfdc8€9.00€0.19matched
79capture01a19aef-16fc-759f-b515-c96870d3838d€15.00€0.26matched
80capture01a19aef-2a67-7cfb-a13c-2a07f2a6e1a7€35.00€0.50matched
81capture01a19aef-32f3-7d70-a1bf-eddc48c8c84e€9.00€0.19matched
82capture01a19aef-5e2c-7db1-ade9-cda71a4516b3€24.00€0.37matched
83capture01a19aef-63be-74df-8741-b98545662d0d€9.00€0.19matched
84capture01a19aef-76cd-70ef-9b09-51f13053ba31€24.00€0.37matched
85capture01a19aef-8f22-7a8e-a64a-fa9c258ed06a€35.00€0.50matched
86capture01a19aef-a350-772d-8167-51b66ccd08f0€24.00€0.37matched
87capture01a19aef-bc39-77fd-8efe-2aae00190dfb€15.00€0.26matched
88capture01a19aef-c5e3-721d-9a01-20bf3bedab50€24.00€0.37matched
89refund01a19aef-c852-73d7-9ffc-f2ab745b019d-€11.00€0.00matched
90capture01a19aef-cb83-7f36-b8f4-db971ef8e146€24.00€0.37matched
91capture01a19aef-d115-7744-96e7-12d70eeb1529€15.00€0.26matched
92capture01a19aef-fa62-7f42-8718-05a61352cc98€24.00€0.37matched
93capture01a19aef-fd58-7566-bf48-14c9edc5ee34€15.00€0.26matched
94capture01a19af0-1dd5-757f-96ac-5a543f3fa203€15.00€0.26matched
95capture01a19af0-234c-75a4-ad6a-042412e3898c€15.00€0.26matched
96capture01a19af0-2a8a-7705-8e31-7ede07761f6a€35.00€0.50matched
97capture01a19af0-2f44-707e-b90f-79df72fe0a16€9.00€0.19matched
98capture01a19af0-344d-70b9-9b9f-dfc112a13e2e€49.00€0.67matched
99refund01a19af0-3ce5-7e8b-b132-b8f6bc52fa9a-€19.00€0.00matched
100capture01a19af0-4741-729e-ba32-fddcb267b76c€24.00€0.37matched
101capture01a19af0-7146-748b-976d-f34987ae2831€49.00€0.67matched
102capture01a19af0-a497-7bc5-9123-0d0d74a0b1a9€24.00€0.37matched
103capture01a19af0-f12d-770f-bb17-78858d991a04€35.00€0.50matched
104capture01a19af0-fba5-7852-8331-7d579b812fe2€24.00€0.37matched
105capture01a19af1-19a1-7748-b519-d1783f640314€24.00€0.37matched
106capture01a19af1-52be-75e3-b430-b724b69aa8d3€49.00€0.67matched
107capture01a19af1-6ba9-7331-9034-0393bfe07737€49.00€0.67matched
108capture01a19af1-76b5-7eec-b651-e6ccdce876da€15.00€0.26matched
109capture01a19af1-780b-7a50-9d37-f71868c3f267€9.00€0.19matched
110capture01a19af1-8431-7e7d-a01c-67652d60311f€24.00€0.37matched
111capture01a19af1-c2fe-7de6-8925-05058d339514€24.00€0.37matched
112capture01a19af1-c608-7a04-8464-ee64b53ee3d5€24.00€0.37matched
113capture01a19af1-dc1e-7336-a060-cf1d3a3bde02€49.00€0.67matched
114capture01a19af2-03fd-7077-a071-c6eb2ed7fec6€9.00€0.19matched
115capture01a19af2-07ab-73f3-85a3-cd1bc5dd677d€24.00€0.37matched
116capture01a19af2-104e-7f3e-b1fe-4a05e0a1993c€9.00€0.19matched
117capture01a19af2-4077-75d6-9ec2-f7bbba320337€24.00€0.37matched
118capture01a19af2-5034-70d8-80a3-56f1eeb6fa47€15.00€0.26matched
119capture01a19af2-5578-75fc-baa7-afa3b5b70f1f€15.00€0.26matched
120capture01a19af2-61f0-72da-acac-7b2e79cab102€9.00€0.19matched
121capture01a19af2-6b98-7779-b1d7-e3833f948ea8€24.00€0.37matched
122capture01a19af2-763f-7ed8-b26d-1822d37b5288€49.00€0.67matched
123capture01a19af2-76b1-7585-8b9a-a51df1d55b44€9.00€0.19matched
124capture01a19af2-8d3a-7dd6-b27d-5528b740c3cf€9.00€0.19matched
125capture01a19af2-9054-7486-bb94-d253064d518a€9.00€0.19matched
126capture01a19af2-bf02-77b7-aa7a-6534c26a14eb€49.00€0.67matched
127capture01a19af2-c323-787a-9bfe-9561ecb85021€9.00€0.19matched
128capture01a19af2-cd32-77eb-8f49-e96a6e08ca44€9.00€0.19matched
129capture01a19af2-de92-7fc6-929f-53b87f662dab€15.00€0.26matched
130capture01a19af2-f5ba-70e5-a1ce-2be9c2b4ed87€15.00€0.26matched
131capture01a19af3-0451-7246-9940-e1b80fe76e59€15.00€0.26matched
132capture01a19af3-0510-795e-94a3-4c534d87d501€9.00€0.19matched
133capture01a19af3-2217-703a-a773-2821496b1470€35.00€0.50matched
134capture01a19af3-3a75-7fb6-9dbb-57e332c55c60€35.00€0.50matched
135capture01a19af3-41dc-7528-ac98-a700a76856d4€24.00€0.37matched