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

3 Nov, 21:30

Gross

€2,923.00

PSP fee

€46.65

Net to the bank

€2,876.35

Settlement journal

#367955

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a357-d588-7cb4-99a5-4218e55d4789 is already settled by stl_EUR_2989569 line 96
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
LineKindReferenceGrossFeeStatus
31capture01a1a353-2052-7911-841b-bfbf4defe625€9.00€0.23fee difference
90capture01a1a357-1549-73d6-8f0a-28d6b7f78bb3€9.00€0.22fee difference
97capture01a1a357-ec5e-7f70-807c-5daae60d7f48€35.00€0.50duplicate line
1capture01a1a348-b46d-7f58-a567-26cec26022f0€15.00€0.26matched
2refund01a1a349-b3bf-737b-9317-12063beabad2-€10.00€0.00matched
3capture01a1a34d-36b7-7c76-b8ef-186e9c549928€49.00€0.67matched
4capture01a1a34f-888a-7581-b973-277bc7f06224€24.00€0.37matched
5capture01a1a351-afd1-7cf6-a1a0-d76726a7f69b€15.00€0.26matched
6capture01a1a351-c141-705c-9afd-d81e25ac45df€49.00€0.67matched
7capture01a1a351-cc3d-7a6e-a9a1-41b1d41863b0€9.00€0.19matched
8capture01a1a351-ea25-7418-aa77-f15259668039€9.00€0.19matched
9capture01a1a351-ec98-75df-b918-32d0cd26df27€9.00€0.19matched
10capture01a1a352-1d7b-78cd-b29e-642e4e5abb88€24.00€0.37matched
11capture01a1a352-2f77-7457-a44f-6622b5434fb5€35.00€0.50matched
12capture01a1a352-3cfd-7871-ba46-7ae213f24c7f€24.00€0.37matched
13capture01a1a352-4226-7ce3-bc29-0508b9eca165€35.00€0.50matched
14capture01a1a352-4b61-7845-9994-6d5425fed7ac€15.00€0.26matched
15capture01a1a352-5749-7e03-9ee4-b058ec5aa82e€15.00€0.26matched
16refund01a1a352-5f6c-7379-81fc-c4a70eeeafe4-€10.00€0.00matched
17capture01a1a352-705d-7fb7-8913-f42d61c70f4b€15.00€0.26matched
18refund01a1a352-7a00-7715-a006-15ba614b4e50-€9.00€0.00matched
19capture01a1a352-810c-78cb-a899-02fbd1ed84ff€24.00€0.37matched
20capture01a1a352-8a0e-7d3f-813a-c33e8ae12ab1€9.00€0.19matched
21capture01a1a352-8e00-78b2-a13b-3a75bb2a1d19€15.00€0.26matched
22capture01a1a352-91ec-7ec0-9f27-d53cf1509c85€15.00€0.26matched
23capture01a1a352-9395-774d-9359-ab656c8a5652€15.00€0.26matched
24refund01a1a352-bfd1-75e7-a5d9-359c47d1c67e-€11.00€0.00matched
25capture01a1a352-c138-7c4b-87dc-56cb346ecda1€9.00€0.19matched
26capture01a1a352-c4fe-70c8-ac01-986cf6319212€15.00€0.26matched
27capture01a1a352-d71e-7d57-a8cc-9885eb84d41f€24.00€0.37matched
28capture01a1a352-f88a-798b-9094-f02ce4aec049€9.00€0.19matched
29capture01a1a353-0d74-77dd-b87c-c53b33a24be3€15.00€0.26matched
30capture01a1a353-14b3-78bd-ad5d-ae1664ac10e2€35.00€0.50matched
32capture01a1a353-2afe-737c-9080-33c5382e3828€49.00€0.67matched
33capture01a1a353-37ef-7094-b10a-69c5d21dc4d6€24.00€0.37matched
34capture01a1a353-43c4-79ba-a50e-e39147f28b17€35.00€0.50matched
35capture01a1a353-4bde-7c37-9293-75536650330b€35.00€0.50matched
36capture01a1a353-6f65-740b-8129-812141229c27€24.00€0.37matched
37capture01a1a353-70c5-7fd6-bbf4-46223c107245€24.00€0.37matched
38capture01a1a353-78e9-7a40-bb9c-92934af30877€9.00€0.19matched
39capture01a1a353-84d9-7c61-906b-7ce4db30d575€15.00€0.26matched
40capture01a1a353-903c-7f7d-97f3-1a2d3cf39a59€9.00€0.19matched
41capture01a1a353-9d8c-71eb-aed8-b4417efb69c8€9.00€0.19matched
42capture01a1a353-9da9-7285-84f6-d0c51c0dc5c1€49.00€0.67matched
43capture01a1a353-aa30-7609-be49-1234c6d848b8€24.00€0.37matched
44capture01a1a353-b46f-7cf7-bd74-998dfd3a0516€49.00€0.67matched
45capture01a1a353-b893-7a6b-871f-ddd2e74ee716€24.00€0.37matched
46capture01a1a353-c130-787c-aaa2-0eade5ff9a8f€15.00€0.26matched
47capture01a1a353-c317-70d3-9572-64cf90bfa259€24.00€0.37matched
48capture01a1a353-cc1e-7907-ae72-2427068e936e€24.00€0.37matched
49capture01a1a353-e580-76f2-84cb-81eb4ae71356€15.00€0.26matched
50capture01a1a353-e6f6-7014-bc06-8c40d2e18c5f€35.00€0.50matched
51capture01a1a353-f495-79a2-935d-3add3925a3a4€35.00€0.50matched
52refund01a1a354-2ec0-7736-8057-0b464ea75f0f-€19.00€0.00matched
53refund01a1a354-423d-713e-a6df-ee7dffd99ce2-€12.00€0.00matched
54capture01a1a354-4328-780f-8765-e5315e15f4c6€15.00€0.26matched
55capture01a1a354-9b85-7a3d-87ff-c3d1ab3900b1€15.00€0.26matched
56capture01a1a354-c06a-79d2-9f15-5dbf69115358€49.00€0.67matched
57capture01a1a354-f66c-72f6-a05a-fa5439fe2028€9.00€0.19matched
58capture01a1a354-fd7e-71e2-ab12-8853b6eda93a€35.00€0.50matched
59capture01a1a355-005a-7fab-8b20-e58b113fca81€9.00€0.19matched
60capture01a1a355-299f-73c9-adb7-7236451c5eaa€15.00€0.26matched
61capture01a1a355-3561-72f6-9c3c-ea195af7423e€24.00€0.37matched
62capture01a1a355-5c95-72c1-8bfb-b02ca7b8b560€24.00€0.37matched
63capture01a1a355-66ef-78a3-94df-9ea47cdce501€35.00€0.50matched
64capture01a1a355-6baa-7213-b3cc-f35dc523d51a€24.00€0.37matched
65capture01a1a355-7e60-7e83-8e6b-172250e9a5b2€9.00€0.19matched
66capture01a1a355-9567-755c-bc29-e0c594e6457b€9.00€0.19matched
67capture01a1a355-9b49-7515-85e2-7008eb21661c€35.00€0.50matched
68capture01a1a355-b49b-7d4f-97d8-37f534feb232€24.00€0.37matched
69capture01a1a355-bb13-7e75-a45c-9deaa9d5bfb5€9.00€0.19matched
70capture01a1a355-d58d-7627-b547-7817d4046476€35.00€0.50matched
71capture01a1a355-ed35-7836-a0fb-b3bc501004ab€35.00€0.50matched
72capture01a1a355-f903-7260-9d68-f75b6f2e7718€9.00€0.19matched
73capture01a1a356-0787-707d-8cc2-b0c84baca16f€35.00€0.50matched
74refund01a1a356-150e-7f99-9b21-1ef9e74aafe0-€13.00€0.00matched
75capture01a1a356-1fd6-7c7a-ae18-db5c2d6ea3df€15.00€0.26matched
76capture01a1a356-391d-7e3f-bda0-45db50aba53c€24.00€0.37matched
77capture01a1a356-4fa2-7d70-9be2-0b877ca51208€9.00€0.19matched
78capture01a1a356-5ea5-758e-9b6c-38bdfd9ffb83€35.00€0.50matched
79capture01a1a356-6204-7022-8cd2-fefec40ddfef€24.00€0.37matched
80capture01a1a356-664d-7d43-9cd3-5d390d16e71a€49.00€0.67matched
81capture01a1a356-739a-7a49-a606-2d514275ccf9€15.00€0.26matched
82capture01a1a356-77d3-7bc5-85d5-73bdcb99421c€49.00€0.67matched
83capture01a1a356-86b7-7757-ac76-cfab736833d8€24.00€0.37matched
84capture01a1a356-a5d9-7f22-9cc5-0e1c66ed49b2€49.00€0.67matched
85capture01a1a356-ad53-7814-af52-74e4f582c95d€24.00€0.37matched
86refund01a1a356-add9-7423-9122-18862ba0767d-€4.00€0.00matched
87capture01a1a356-b16f-7bc7-87c0-c55c20fd768f€9.00€0.19matched
88capture01a1a356-ef2b-7c31-93d4-3840296662cd€49.00€0.67matched
89capture01a1a357-146f-7b5d-85a9-323abbfc7db5€9.00€0.19matched
91capture01a1a357-2094-778b-bbcc-e472bd9cec00€24.00€0.37matched
92capture01a1a357-8bde-7ecb-8bc8-65bdcde18ed1€49.00€0.67matched
93capture01a1a357-c52c-77f4-8af5-b0fa323583f0€24.00€0.37matched
94capture01a1a357-d27a-74bd-8659-03e454051490€9.00€0.19matched
95capture01a1a357-d5aa-7b5d-92fe-58ab8ec2a8ba€9.00€0.19matched
96capture01a1a357-ec5e-7f70-807c-5daae60d7f48€35.00€0.50matched
98capture01a1a358-302b-797d-a83c-061601751cb3€35.00€0.50matched
99capture01a1a358-39fb-732b-a145-ad9a0d893b2a€49.00€0.67matched
100capture01a1a358-4f97-76a4-b350-632536c41665€24.00€0.37matched
101capture01a1a358-5c45-7f12-9726-3c64f130368e€15.00€0.26matched
102capture01a1a358-6be7-72bf-a1e6-aecb87d7d8d6€49.00€0.67matched
103capture01a1a358-9177-702b-9b4f-c09247d3ef84€15.00€0.26matched
104capture01a1a358-be47-7eaf-b2fd-7e840258235e€15.00€0.26matched
105capture01a1a358-cbe5-79ec-b47d-9db0979b75a8€24.00€0.37matched
106capture01a1a358-de8a-701c-b3a3-f46c8a4b7fa5€24.00€0.37matched
107capture01a1a359-0b4b-7f3b-a490-b44bbbb717c4€35.00€0.50matched
108capture01a1a359-0b8d-771a-b7b0-cfbdeaaf9b5e€9.00€0.19matched
109capture01a1a359-1fe6-71c4-a57e-fe61ea06e4a5€35.00€0.50matched
110capture01a1a359-2c2e-7e47-b01e-2d8e2aea7944€35.00€0.50matched
111capture01a1a359-2ec2-7fc4-b795-68b849f21acc€24.00€0.37matched
112capture01a1a359-35f7-7745-a41c-12581278f9df€9.00€0.19matched
113capture01a1a359-3734-71f0-bae9-57eac1e1a404€15.00€0.26matched
114capture01a1a359-491d-796d-b6eb-8564ad7dc361€49.00€0.67matched
115capture01a1a359-5a19-7333-91e8-0a1ad695bb9a€35.00€0.50matched
116capture01a1a359-606e-79d6-bbfc-a842ad356e4d€9.00€0.19matched
117capture01a1a359-78ba-7701-aebe-e36935b3fe26€35.00€0.50matched
118capture01a1a359-8184-7498-acc5-6e0bbf8c54a9€49.00€0.67matched
119capture01a1a359-88f4-78da-9029-a23fe49a2d24€15.00€0.26matched
120capture01a1a359-92ce-7bcd-8fe9-b9a014d2a408€49.00€0.67matched
121capture01a1a359-98b8-7df6-8f3e-67447e6f2fd1€9.00€0.19matched
122capture01a1a359-a735-7d07-be4b-50b3fed7194a€9.00€0.19matched
123capture01a1a359-aa7a-7daa-bbb8-d00297368cdc€9.00€0.19matched
124refund01a1a359-b425-797f-8207-9dbb8fbfb571-€41.00€0.00matched
125capture01a1a359-dd75-7be4-b481-78edecb947e8€49.00€0.67matched
126refund01a1a35a-0249-7f94-bfef-8eac77c87c0e-€4.00€0.00matched
127capture01a1a35a-072b-7537-8b7a-a5584a7fc952€49.00€0.67matched
128capture01a1a35a-07da-7cfe-82b0-d55fab24d74b€35.00€0.50matched
129capture01a1a35a-40ab-74b8-ac6b-790a437c3936€49.00€0.67matched
130capture01a1a35a-4a40-7c52-a14c-cd35b517211f€49.00€0.67matched
131capture01a1a35a-b916-7df1-a1fd-a6b87aa16310€35.00€0.50matched
132capture01a1a35a-c881-7c55-b509-47aad9c43f9e€15.00€0.26matched