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, 05:30

Gross

€2,670.00

PSP fee

€42.18

Net to the bank

€2,627.82

Settlement journal

#392331

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

LineKindReferenceGrossFeeStatus
1capture01a1aa2a-7191-7ef6-87a9-c3417691439e€49.00€0.67matched
2capture01a1aa2e-b5f0-77e8-b843-4a922b075c96€24.00€0.37matched
3capture01a1aa2f-7b42-72eb-a241-cdfc6d617c88€35.00€0.50matched
4capture01a1aa2f-a0d8-7805-b026-4421449f660f€24.00€0.37matched
5capture01a1aa2f-b136-7620-9e29-f25b41d52cd5€35.00€0.50matched
6capture01a1aa2f-b301-7f69-ad26-c742116be1d8€15.00€0.26matched
7capture01a1aa2f-b472-79d5-bf40-501b60e1f8a4€15.00€0.26matched
8capture01a1aa2f-c59f-7171-be71-9a8f5b4a0cf1€35.00€0.50matched
9capture01a1aa2f-c99c-71cf-a2fc-05246c326f64€15.00€0.26matched
10capture01a1aa2f-d56e-7e4c-b6b7-ad932ff6ca52€49.00€0.67matched
11capture01a1aa2f-dcd3-7d37-8740-60d247ed1b01€24.00€0.37matched
12refund01a1aa2f-e065-7a2d-bc1a-5f838058ea6f-€6.00€0.00matched
13capture01a1aa2f-e06d-709c-8361-a33b620c0faf€24.00€0.37matched
14capture01a1aa2f-e5ad-79ca-9002-be8bd8467e4e€35.00€0.50matched
15refund01a1aa2f-e7a2-7d3b-a08c-c6d8cbaac2ac-€10.00€0.00matched
16capture01a1aa2f-f5d3-7305-83c0-019312876658€49.00€0.67matched
17capture01a1aa30-565f-791e-ad65-9c6ec868571e€35.00€0.50matched
18capture01a1aa30-72f5-75b8-bbf2-a70aa8eacaa9€15.00€0.26matched
19capture01a1aa30-c8b3-7638-bd69-3b00bf082054€15.00€0.26matched
20capture01a1aa30-cd59-709a-abd9-39e61b2295c6€49.00€0.67matched
21refund01a1aa30-d5c0-739d-88c0-319b00c943c3-€5.00€0.00matched
22capture01a1aa30-daaa-7a0b-8de2-23b5724090a9€15.00€0.26matched
23capture01a1aa31-27bc-7c3c-af98-ba5ee5ae78c2€49.00€0.67matched
24capture01a1aa31-3241-731b-97fc-5600d263bd49€9.00€0.19matched
25capture01a1aa31-3471-7031-a42e-09d8a3910d33€35.00€0.50matched
26capture01a1aa31-35fd-7178-aeaa-0a2b9a01af2e€9.00€0.19matched
27capture01a1aa31-38c0-7d3b-8c17-6f9802d2091d€24.00€0.37matched
28capture01a1aa31-6f5a-779c-a425-83fa1df70c46€24.00€0.37matched
29capture01a1aa31-a8dc-71ee-ba0b-238482f8c884€15.00€0.26matched
30capture01a1aa31-ac8c-7233-8722-96baa7e96a50€35.00€0.50matched
31capture01a1aa31-b935-78ac-8f92-03907330ab20€15.00€0.26matched
32capture01a1aa31-bbb5-7c2f-a214-b613020a1818€35.00€0.50matched
33capture01a1aa31-f1a4-78a5-9c80-12f8bb3f25f2€15.00€0.26matched
34capture01a1aa32-0446-7dbd-ae62-b57d5e4bc9cf€24.00€0.37matched
35capture01a1aa32-0c1c-7418-b5be-8d600e10c099€24.00€0.37matched
36capture01a1aa32-28b1-74e3-ac9a-a4122775286a€15.00€0.26matched
37capture01a1aa32-39fb-7e35-addb-5affc5d52219€24.00€0.37matched
38capture01a1aa32-5867-730f-ae4b-ae0534b038b0€24.00€0.37matched
39capture01a1aa32-919f-79dd-93e1-f08f4efed07f€15.00€0.26matched
40capture01a1aa32-98c8-78a5-a817-e10d1c2345b4€15.00€0.26matched
41capture01a1aa32-9cca-72af-a5bd-983f402c1584€9.00€0.19matched
42capture01a1aa32-a19b-754e-b52f-99b8dfddae97€24.00€0.37matched
43capture01a1aa32-a572-7506-a5bf-44456cb1c369€49.00€0.67matched
44capture01a1aa32-b7ab-7619-8a9a-6f246132f7c1€9.00€0.19matched
45capture01a1aa32-c19b-7503-8ed7-7ce11dd5a7b3€15.00€0.26matched
46capture01a1aa32-cc28-79fa-9229-055e9c2c431a€9.00€0.19matched
47refund01a1aa32-da35-7410-89b4-d318a8615775-€8.00€0.00matched
48capture01a1aa32-da7e-7c1f-8a9c-dfb57fcfa7ac€15.00€0.26matched
49refund01a1aa32-ec21-7327-b199-eb5a45cfd512-€45.00€0.00matched
50refund01a1aa33-03f0-7a38-8333-25e5ee63fa9f-€9.00€0.00matched
51capture01a1aa33-0e54-7fa3-a031-1d6bd13cb40e€49.00€0.67matched
52refund01a1aa33-0fc7-7024-8651-8c46421dff7f-€3.00€0.00matched
53capture01a1aa33-384f-7750-a259-9095641a5b9e€35.00€0.50matched
54capture01a1aa33-97af-7469-b3fa-b322e28f7afb€35.00€0.50matched
55capture01a1aa33-d500-7052-818f-6198487766d8€24.00€0.37matched
56capture01a1aa33-e025-7bde-aaf0-c85880fae198€9.00€0.19matched
57capture01a1aa33-ee42-7c3e-bba0-42401fed3fe8€49.00€0.67matched
58capture01a1aa34-02c6-701c-b55d-1a52143db2ce€15.00€0.26matched
59capture01a1aa34-4fbd-77f0-b251-96657bbf1e2b€24.00€0.37matched
60capture01a1aa34-56a1-750f-aacd-640bd5d9ea35€24.00€0.37matched
61capture01a1aa34-60c5-71d8-ab5c-c7d4b406ef84€35.00€0.50matched
62capture01a1aa34-7123-74e1-85b8-9a095aac4f6f€24.00€0.37matched
63capture01a1aa34-72e5-7e9f-89c4-0fc86e14337e€49.00€0.67matched
64capture01a1aa34-78d7-78da-872d-b004ab99a2fa€9.00€0.19matched
65capture01a1aa34-8cc0-7cfb-8928-21d470b3b749€9.00€0.19matched
66capture01a1aa34-a702-72d8-8d8d-110145a34bfb€9.00€0.19matched
67capture01a1aa34-ee4f-7df6-acd8-a98dabb03d2b€9.00€0.19matched
68capture01a1aa35-0884-74ac-941f-e01e800cc794€49.00€0.67matched
69capture01a1aa35-10e6-70fa-bbff-6229b927e3e1€24.00€0.37matched
70capture01a1aa35-1a6c-7ca4-a935-18f81818a114€49.00€0.67matched
71capture01a1aa35-2272-76b9-92e9-d7b62fc98b25€24.00€0.37matched
72capture01a1aa35-2524-77e1-a1ec-c604763a25e2€15.00€0.26matched
73capture01a1aa35-2d12-7947-b084-32af6636b1ab€35.00€0.50matched
74capture01a1aa35-43d5-70ac-986f-77b0182b47bc€35.00€0.50matched
75capture01a1aa35-6a4b-7dfe-bdf5-8f95211ddf20€24.00€0.37matched
76refund01a1aa35-789c-796c-8f42-3cd70e118e93-€38.00€0.00matched
77capture01a1aa35-833f-7299-a276-269c97134b69€24.00€0.37matched
78capture01a1aa35-b70a-748e-a7de-1e7c506c4ef0€35.00€0.50matched
79capture01a1aa35-b7e5-7224-b93a-c30b5431d7d3€15.00€0.26matched
80capture01a1aa35-fcd8-7080-9584-e7db5cf299aa€9.00€0.19matched
81capture01a1aa36-0e0f-7930-88d4-fc7c3785597f€24.00€0.37matched
82capture01a1aa36-133b-7147-a0e7-5e0b3cd8e6c5€9.00€0.19matched
83capture01a1aa36-14b8-7df8-b692-f0d82c67bf18€35.00€0.50matched
84capture01a1aa36-2d1a-7403-ae32-d23c19a50557€35.00€0.50matched
85capture01a1aa36-420b-7648-9cbf-ccf36498c989€35.00€0.50matched
86capture01a1aa36-5e4d-7eac-a5ea-66220e5baf37€15.00€0.26matched
87capture01a1aa36-6023-7591-8897-72026198551a€49.00€0.67matched
88capture01a1aa36-67e2-7d27-a7f5-b08eed536534€35.00€0.50matched
89capture01a1aa36-7b9d-7c26-8acd-e1c16e23fa55€15.00€0.26matched
90capture01a1aa36-9179-7b25-93b8-360390d8663d€9.00€0.19matched
91capture01a1aa36-bd79-7918-93ec-afdac692798b€49.00€0.67matched
92capture01a1aa36-c620-786b-a052-606991e0e682€35.00€0.50matched
93refund01a1aa36-ca1a-71c6-a366-64db850e67e7-€11.00€0.00matched
94capture01a1aa36-eaa1-7356-ad0f-ee6d243ef3ca€35.00€0.50matched
95capture01a1aa36-fb71-718e-815a-338724948460€35.00€0.50matched
96capture01a1aa37-0d5b-7217-bc4f-69bd474b023a€49.00€0.67matched
97capture01a1aa37-0f89-75ba-a2c1-dfe57d2f481a€24.00€0.37matched
98capture01a1aa37-1811-7837-9e42-c3c06ab6d5a4€49.00€0.67matched
99capture01a1aa37-3d94-7e95-b033-acaea55cd298€15.00€0.26matched
100capture01a1aa37-6582-7bbe-bf20-5ee26438c635€24.00€0.37matched
101capture01a1aa37-68c7-7a44-bcef-a78d7c4e2e0e€24.00€0.37matched
102capture01a1aa37-97ee-7466-898d-1862dc30e0eb€24.00€0.37matched
103capture01a1aa37-b086-7995-879e-d19a4105b4c4€35.00€0.50matched
104capture01a1aa37-cbe6-75cd-b4da-4521f6c19bf7€9.00€0.19matched
105capture01a1aa37-d554-7652-927f-b70fa5862147€35.00€0.50matched
106capture01a1aa37-d6a9-7c53-8af2-c751a3adb324€49.00€0.67matched
107capture01a1aa37-e4cc-774a-b64d-557ae152e97f€9.00€0.19matched
108capture01a1aa37-e84f-7005-8381-8ab43864df30€49.00€0.67matched
109capture01a1aa37-f8e9-7c9c-87b9-22310cfbcf35€15.00€0.26matched
110capture01a1aa38-0e9e-7529-b7ac-7bfd65c0fb93€49.00€0.67matched
111capture01a1aa38-107a-7454-b2ba-14a732434b96€35.00€0.50matched
112capture01a1aa38-25d9-73a4-aec1-93f9d91dfbcf€24.00€0.37matched
113capture01a1aa38-802d-7547-9139-bbc07c8c84df€9.00€0.19matched
114capture01a1aa38-9925-7fc9-950b-beb71b408127€24.00€0.37matched