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

7 Nov, 12:20

Gross

€3,232.00

PSP fee

€49.87

Net to the bank

€3,182.13

Settlement journal

#434362

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b5fc-3fd6-7dd4-89a1-93868ad95365 is already settled by stl_EUR_2990090 line 120
  • missing linein the books, not in the filecapture:01a1b5f8-ddb4-7245-866d-678f68a41c48 is in no file
  • missing linein the books, not in the filecapture:01a1b5fb-15af-7632-a822-b9644c53d4de is in no file
LineKindReferenceGrossFeeStatus
121capture01a1b5fc-4075-7527-ad63-86fa5d122f28€9.00€0.19duplicate line
1refund01a1b5ef-b8d1-7848-86ad-549bb57277d8-€24.00€0.00matched
2capture01a1b5f3-cd30-7a42-8a65-26881a47176c€35.00€0.50matched
3capture01a1b5f3-dca9-7549-9b04-e08aa03680d1€49.00€0.67matched
4capture01a1b5f3-e6c8-7f3f-8d1f-78d6fbab78f1€15.00€0.26matched
5capture01a1b5f3-eace-7ec4-b762-2e49dfc90481€24.00€0.37matched
6capture01a1b5f4-02d5-7223-9021-58e987f2b826€49.00€0.67matched
7capture01a1b5f4-051b-7ca7-9483-55b84b6b6028€15.00€0.26matched
8capture01a1b5f4-0663-732a-a375-369090461b8f€24.00€0.37matched
9capture01a1b5f4-4926-7d36-91f7-3263661aa047€49.00€0.67matched
10capture01a1b5f4-7514-7c3c-a6bd-d0a16ede8047€49.00€0.67matched
11capture01a1b5f4-a2fb-7c98-b814-75ce9afbbe5f€9.00€0.19matched
12capture01a1b5f4-b9b7-7c22-9934-e15adc1d88d0€49.00€0.67matched
13capture01a1b5f4-c181-73c1-9d93-239240538723€24.00€0.37matched
14capture01a1b5f4-c6c3-7f96-b627-6c98fcf5bc8b€49.00€0.67matched
15capture01a1b5f4-d160-7279-a1d2-837c653cbae4€49.00€0.67matched
16capture01a1b5f4-f412-7b74-a38e-d21c5f738d44€24.00€0.37matched
17capture01a1b5f5-2dd5-79f7-9a5f-67619d363406€49.00€0.67matched
18capture01a1b5f5-386f-7731-8eec-cce26570e1c0€49.00€0.67matched
19capture01a1b5f5-410f-762c-9473-490bd031bdb5€35.00€0.50matched
20capture01a1b5f5-839b-73b1-b9cb-d72dcf45d692€9.00€0.19matched
21capture01a1b5f5-9ae3-7201-8c54-f9b94fdfe918€49.00€0.67matched
22capture01a1b5f5-b5f5-7f5a-84ca-cdc2bb625a42€49.00€0.67matched
23capture01a1b5f5-c208-7e0c-90cd-27d6db15c23c€9.00€0.19matched
24capture01a1b5f5-c7de-7710-af75-c279c51d837a€24.00€0.37matched
25capture01a1b5f5-f272-76c4-9ae1-32593b09edc7€15.00€0.26matched
26capture01a1b5f5-fdc7-7fda-b046-c26b183c1039€9.00€0.19matched
27capture01a1b5f6-079a-77d1-a904-565305784485€9.00€0.19matched
28capture01a1b5f6-3db4-74a0-99f9-8107b218a13c€9.00€0.19matched
29capture01a1b5f6-488c-79e4-bfce-b64ed3f41b8c€24.00€0.37matched
30capture01a1b5f6-4eba-71fd-bdd7-c99f67cfde70€35.00€0.50matched
31capture01a1b5f6-5ed2-725a-bd7d-f0f3d43caf68€24.00€0.37matched
32capture01a1b5f6-6e2c-7ba7-a5de-bda14401cb83€15.00€0.26matched
33capture01a1b5f6-77d3-7d39-98dc-26ceb3dd9347€35.00€0.50matched
34capture01a1b5f6-8268-76ae-b56b-546db20d00b4€35.00€0.50matched
35capture01a1b5f6-9ef4-7ec2-8b49-1d0a563baad1€24.00€0.37matched
36capture01a1b5f6-abce-736f-9508-16af608b4ada€49.00€0.67matched
37capture01a1b5f6-d220-7b8e-beaf-ef4845553993€24.00€0.37matched
38capture01a1b5f6-dcbf-76ed-8312-324f2ac54309€9.00€0.19matched
39capture01a1b5f6-f13d-7957-89fb-34730b0ea2d6€35.00€0.50matched
40capture01a1b5f7-01a7-71f5-96e9-c4d49c13e00e€15.00€0.26matched
41capture01a1b5f7-01ae-70c8-b680-89d748bb7df0€15.00€0.26matched
42capture01a1b5f7-33b6-79da-9cbf-d13b8ef600c1€9.00€0.19matched
43capture01a1b5f7-40e4-77bb-8136-65aa17c47a57€24.00€0.37matched
44capture01a1b5f7-6b7a-77c7-bf3c-deae06ca348a€35.00€0.50matched
45refund01a1b5f7-6c7d-7e6d-8f77-87b3287f3081-€11.00€0.00matched
46capture01a1b5f7-759a-7c5a-b495-7f83863c1cfb€9.00€0.19matched
47capture01a1b5f7-803d-7e4c-b7c2-b87917fe76fc€49.00€0.67matched
48capture01a1b5f7-8e33-7bb8-a5d0-01c20f2f9f65€24.00€0.37matched
49capture01a1b5f7-8fbe-7f29-a2e3-e2375321096c€49.00€0.67matched
50capture01a1b5f7-9ef8-710c-8cd9-d7ec3ca68403€49.00€0.67matched
51capture01a1b5f7-b26a-7194-a2c6-0e66cb588b8d€9.00€0.19matched
52capture01a1b5f7-c5c5-70b3-aca0-61fd6a24581f€9.00€0.19matched
53refund01a1b5f7-e6d9-7258-a378-2235158aedb8-€2.00€0.00matched
54capture01a1b5f8-02c7-766e-b41c-3bba1451c4c4€49.00€0.67matched
55capture01a1b5f8-0ad4-77f8-a8d2-428cfad265ab€15.00€0.26matched
56capture01a1b5f8-0c4c-7990-9b7f-69100462fb65€35.00€0.50matched
57capture01a1b5f8-360e-746f-a344-25712b6cde1e€24.00€0.37matched
58capture01a1b5f8-337a-78eb-9275-23f5e706e482€49.00€0.67matched
59capture01a1b5f8-4127-7059-b9b2-6e82898b1ad9€24.00€0.37matched
60capture01a1b5f8-4483-72f2-9238-c19b694db9fa€24.00€0.37matched
61capture01a1b5f8-59f7-762e-a468-45372216a76c€24.00€0.37matched
62capture01a1b5f8-6790-7f9a-aa60-2b8c656d44ca€35.00€0.50matched
63capture01a1b5f8-76c6-78ac-a1f5-3097cbf41afd€35.00€0.50matched
64capture01a1b5f8-83c2-72fe-a4e3-2bc397a9968f€15.00€0.26matched
65capture01a1b5f8-9bb7-73f1-95e4-40428a4027b8€9.00€0.19matched
66capture01a1b5f8-c0f5-76b6-9e95-5cbd5197b435€9.00€0.19matched
67capture01a1b5f8-cf37-7728-bd2a-03630a82668a€49.00€0.67matched
68capture01a1b5f8-d427-7421-b3f7-c17ddd843b66€49.00€0.67matched
69capture01a1b5f8-da7a-70f4-9e38-4b7c466384fd€49.00€0.67matched
70refund01a1b5f8-e6c5-7423-bd88-f8d84daceb97-€34.00€0.00matched
71capture01a1b5f8-f071-7929-ba2a-bb29fb672db2€24.00€0.37matched
72capture01a1b5f9-064b-7567-aafa-8eddcef6ff28€9.00€0.19matched
73capture01a1b5f9-3cf1-745b-825b-c1576823e8bb€24.00€0.37matched
74capture01a1b5f9-416b-778c-b04a-9f79e8705dd2€15.00€0.26matched
75capture01a1b5f9-4845-7084-b725-7981df0e3759€35.00€0.50matched
76capture01a1b5f9-590d-7275-af7c-829cf0a23f85€15.00€0.26matched
77capture01a1b5f9-86b3-79a6-af21-0152df71187c€15.00€0.26matched
78capture01a1b5f9-a61c-793e-a323-51659d3c153a€24.00€0.37matched
79refund01a1b5f9-c831-76bb-8b23-69c607788d99-€8.00€0.00matched
80capture01a1b5f9-ddda-771e-bd46-5cbab26feca6€24.00€0.37matched
81capture01a1b5f9-ecdb-7d05-8ffd-ff67529fba5c€9.00€0.19matched
82capture01a1b5f9-f284-7e92-9dec-2a6f5601de2d€49.00€0.67matched
83capture01a1b5fa-0bf0-740e-ba9f-1b19d953a1e0€15.00€0.26matched
84capture01a1b5fa-29a5-7d23-b703-59064076242c€15.00€0.26matched
85capture01a1b5fa-2d2d-744c-b34f-d45c9c2427fb€9.00€0.19matched
86capture01a1b5fa-310b-79e5-939a-3ee3e21e4562€24.00€0.37matched
87capture01a1b5fa-3c37-7a05-8816-cf4e4d20ddac€24.00€0.37matched
88capture01a1b5fa-7d3c-7421-ba05-c9ea9aae0a44€49.00€0.67matched
89refund01a1b5fa-84af-7e30-a34e-7b467456f981-€6.00€0.00matched
90capture01a1b5fa-8fb0-7a3f-9403-d29a32e62876€9.00€0.19matched
91capture01a1b5fa-e0b4-7573-99b3-7e0f96c202ee€24.00€0.37matched
92capture01a1b5fa-f228-78fe-94f5-6ee81c5ca9a8€49.00€0.67matched
93capture01a1b5fb-01e5-7190-a715-5dd959b1f0cb€49.00€0.67matched
94capture01a1b5fb-0434-765e-a0d9-18b77763cfd5€15.00€0.26matched
95capture01a1b5fb-0476-74e1-bf37-97dc9c2b837d€15.00€0.26matched
96capture01a1b5fb-0840-7299-b505-a138f1ca3867€15.00€0.26matched
97capture01a1b5fb-0fd1-7e68-a4e3-b1a2652cfd12€9.00€0.19matched
98capture01a1b5fb-1d16-7427-bff0-3ebd95bd5f0c€35.00€0.50matched
99refund01a1b5fb-2e82-7595-a76d-bcd5b2147500-€5.00€0.00matched
100capture01a1b5fb-3943-7059-9229-a29f4499ebfc€35.00€0.50matched
101capture01a1b5fb-3baa-7e45-aa75-110a0b4ee1c9€35.00€0.50matched
102capture01a1b5fb-40af-7e3d-95ed-96d05f6080ec€24.00€0.37matched
103capture01a1b5fb-4c4b-7ff2-8a7f-6d85dc58d0cf€35.00€0.50matched
104capture01a1b5fb-550d-7e11-a51f-57b7f88d1ba7€35.00€0.50matched
105capture01a1b5fb-60f0-7bd4-a448-56bdd6bf2795€35.00€0.50matched
106capture01a1b5fb-6e34-7a71-a319-8c2bc3433862€9.00€0.19matched
107capture01a1b5fb-6f0b-709b-9d2f-1d77b13fcc85€49.00€0.67matched
108capture01a1b5fb-7f67-7e3c-ac3f-655e9635f028€49.00€0.67matched
109capture01a1b5fb-9fe1-748f-af37-d5217c2f1d54€9.00€0.19matched
110capture01a1b5fb-b198-726e-8b3b-277c51ef5e23€35.00€0.50matched
111capture01a1b5fb-c6c8-7b5c-864a-53d0e5c93856€9.00€0.19matched
112capture01a1b5fb-cc0b-7f36-89bd-d964defd4b2c€24.00€0.37matched
113capture01a1b5fb-d5d5-7836-861d-4e8f3d38af74€49.00€0.67matched
114capture01a1b5fb-dab4-775d-bd78-4f96b5b4c9b6€15.00€0.26matched
115capture01a1b5fb-e13e-7f09-9695-518e6b063b5f€15.00€0.26matched
116capture01a1b5fb-f1bc-79f6-9626-181c52a864c3€35.00€0.50matched
117capture01a1b5fc-0aab-7137-aeff-ae675d6aad81€9.00€0.19matched
118capture01a1b5fc-2485-77a8-b43d-91a6d11952b1€24.00€0.37matched
119capture01a1b5fc-39a1-74f2-b64d-a87ed095e432€49.00€0.67matched
120capture01a1b5fc-4075-7527-ad63-86fa5d122f28€9.00€0.19matched
122capture01a1b5fc-66b5-75c4-b08e-2a1e5ac42983€49.00€0.67matched
123capture01a1b5fc-6bdb-77d4-b9d5-9cdd7ef35090€9.00€0.19matched
124capture01a1b5fc-7717-7c69-aed0-cf244dd9ad57€9.00€0.19matched
125capture01a1b5fc-8ea1-7828-9026-e0eb25f664dd€15.00€0.26matched
126capture01a1b5fc-92ab-7749-b242-8d364501f33b€15.00€0.26matched
127capture01a1b5fc-9706-7eb7-b96b-350dcf315a29€9.00€0.19matched
128capture01a1b5fc-a53d-716f-936b-05808e109a8d€35.00€0.50matched
129capture01a1b5fc-b360-7745-948c-25bc86e0f337€49.00€0.67matched
130capture01a1b5fc-b489-72bd-badd-a2544cb0765b€9.00€0.19matched