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

Gross

€3,604.00

PSP fee

€56.25

Net to the bank

€3,547.75

Settlement journal

#389323

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • missing linein the books, not in the filecapture:01a1a956-c313-75ac-bd19-c5687342ec06 is in no file
LineKindReferenceGrossFeeStatus
114capture01a1a95a-b101-79ef-ae4b-1dc53653d0cd€24.00€0.39fee difference
1capture01a1a94b-f0d1-792e-8d5c-7e1f4bae10dd€35.00€0.50matched
2capture01a1a94f-4f44-72f1-bdef-9db4d258dffc€49.00€0.67matched
3capture01a1a950-1208-79ae-8573-efec14d67437€15.00€0.26matched
4capture01a1a953-c7c0-7b27-b3bd-dddffaa8581c€9.00€0.19matched
5capture01a1a953-e7ab-7f21-a681-340afa3e3067€35.00€0.50matched
6capture01a1a953-f890-7fe4-b9c7-0750ca8732ac€9.00€0.19matched
7capture01a1a953-fbb6-7729-9456-eb22cf012434€24.00€0.37matched
8capture01a1a954-0017-7ec2-a84d-ff375481c1e9€35.00€0.50matched
9capture01a1a954-0143-7aa2-a7d9-cfd6cd360411€24.00€0.37matched
10capture01a1a954-0db7-7e8e-b382-6f93249465e9€24.00€0.37matched
11capture01a1a954-44be-72e0-807f-b818c99290b6€35.00€0.50matched
12capture01a1a954-47e2-739d-9933-a411c84c7ab8€35.00€0.50matched
13capture01a1a954-6119-75cf-bdaa-be70269a97a6€35.00€0.50matched
14capture01a1a954-6243-7797-8d4e-715df902dc58€24.00€0.37matched
15capture01a1a954-7335-725a-8b7b-0e8e524dc6cd€49.00€0.67matched
16capture01a1a954-8a45-76d8-b0ba-c50193acecac€24.00€0.37matched
17capture01a1a954-8f36-7061-bb06-b3852151a451€15.00€0.26matched
18capture01a1a954-9005-7596-855f-0d1a9b3ce6d0€15.00€0.26matched
19refund01a1a954-9487-7b78-8613-bd8bc3337147-€8.00€0.00matched
20capture01a1a954-9bb0-71d3-9d57-5c7ea776fcd4€15.00€0.26matched
21capture01a1a954-a16c-7c39-be73-2654b29a1bd8€35.00€0.50matched
22capture01a1a954-bb36-7e03-82d1-037935a42309€24.00€0.37matched
23capture01a1a954-cf59-7fd8-8b02-00c97a08f23a€24.00€0.37matched
24capture01a1a954-d0a8-791d-a3bf-c48d1159eb80€49.00€0.67matched
25capture01a1a954-d363-73ab-a569-08a9a2c68121€35.00€0.50matched
26capture01a1a954-dc83-7317-9e6c-325a7c31a367€49.00€0.67matched
27capture01a1a954-fd82-78fe-9b72-97381811c7f0€24.00€0.37matched
28refund01a1a955-02c9-7f30-b67a-23ebdf980ace-€8.00€0.00matched
29capture01a1a955-0c31-7f9a-882f-2b456f0ca542€24.00€0.37matched
30refund01a1a955-1258-767c-94d5-1b272e913790-€22.00€0.00matched
31capture01a1a955-1563-78a7-8fce-dc71ef04f258€15.00€0.26matched
32capture01a1a955-2225-75ee-b82c-6c70525cb922€24.00€0.37matched
33capture01a1a955-2498-7f6f-8b6c-6afe968246ae€24.00€0.37matched
34capture01a1a955-29d7-7d25-b317-2488c9f97577€15.00€0.26matched
35capture01a1a955-3ac4-76b9-a1ec-b50743f0836f€15.00€0.26matched
36capture01a1a955-3e7d-78f9-888d-8ab83f86d167€15.00€0.26matched
37capture01a1a955-4454-7ca0-88b9-57d5202dc3af€24.00€0.37matched
38capture01a1a955-4cd1-7404-b3af-3579f958bee6€49.00€0.67matched
39capture01a1a955-7476-797e-82d2-2384870bcf54€35.00€0.50matched
40capture01a1a955-c90a-7092-90b6-395388d7b269€35.00€0.50matched
41capture01a1a955-deaf-71e5-ade4-8f34289c6cba€35.00€0.50matched
42capture01a1a955-df8a-7dc8-8def-7a37b9fa48cd€24.00€0.37matched
43capture01a1a955-fe4d-733c-8cd3-91dbaf9efb0a€9.00€0.19matched
44capture01a1a956-1b68-7e18-ab7e-6375c23456b5€35.00€0.50matched
45capture01a1a956-2550-7407-9db4-4420078ff22c€9.00€0.19matched
46capture01a1a956-5bc5-7e11-b0f3-43695fbd1681€49.00€0.67matched
47capture01a1a956-6c37-7230-a1b3-4b2af0c244d4€9.00€0.19matched
48capture01a1a956-75a8-72d2-b993-c40627ce4ef3€35.00€0.50matched
49capture01a1a956-829d-7ed0-88c1-b1f374c42395€24.00€0.37matched
50capture01a1a956-8bea-7ef2-9265-568bbc54eb38€24.00€0.37matched
51capture01a1a956-9863-7555-909f-36b327032c9c€15.00€0.26matched
52capture01a1a956-ae58-75f9-bc6d-ff26f9579a64€24.00€0.37matched
53capture01a1a956-b324-71df-8511-244979299e74€15.00€0.26matched
54capture01a1a956-c40d-7679-a1ff-a7ccd52fa404€35.00€0.50matched
55capture01a1a956-c47a-7e49-9367-44563a0485c2€35.00€0.50matched
56capture01a1a956-e010-7e4c-918f-918d09da0272€49.00€0.67matched
57capture01a1a956-e3bb-7eb4-9033-41af8b4ad1ca€35.00€0.50matched
58capture01a1a957-093e-73b6-9ae4-819043c5d961€35.00€0.50matched
59capture01a1a957-12b2-7589-833e-0c11c40d0e4d€9.00€0.19matched
60capture01a1a957-2d99-7981-b427-b3fc2a5c3fba€24.00€0.37matched
61capture01a1a957-2ee8-7213-8252-ef9ba1813844€35.00€0.50matched
62capture01a1a957-3d80-7ff6-8fc9-6d7f8184d830€24.00€0.37matched
63capture01a1a957-4137-74d1-a2c7-513dfb0a29e9€9.00€0.19matched
64capture01a1a957-687c-722b-91c4-73d060255828€24.00€0.37matched
65capture01a1a957-7187-7be3-b952-389f11156406€24.00€0.37matched
66refund01a1a957-729c-73fb-b08b-163507a23888-€13.00€0.00matched
67capture01a1a957-7a61-71be-80eb-422b55c0f0a4€15.00€0.26matched
68capture01a1a957-a10c-7ec8-b95b-664b76bd6541€49.00€0.67matched
69capture01a1a957-ab0a-7529-b6d0-6412df8fc766€24.00€0.37matched
70capture01a1a957-c827-72ee-8cb1-77494948b7e0€9.00€0.19matched
71capture01a1a957-d788-7128-81d5-c75b72f482d3€15.00€0.26matched
72capture01a1a957-e1b3-7d53-9f42-00e79bee035e€35.00€0.50matched
73capture01a1a957-f2c0-7152-970b-a4acb3301a8b€15.00€0.26matched
74refund01a1a958-001b-794c-843a-77cce37cf74e-€8.00€0.00matched
75capture01a1a958-0fa2-739b-af43-e95be8c6fb6e€15.00€0.26matched
76capture01a1a958-29d2-7217-bb63-3b0461daa9b9€9.00€0.19matched
77capture01a1a958-4ef7-7d96-892a-eb63488c5a3a€9.00€0.19matched
78capture01a1a958-6a7f-7b93-bd67-ee30a0c64c2c€15.00€0.26matched
79capture01a1a958-7aee-7ec4-992e-54afaf551625€35.00€0.50matched
80capture01a1a958-8513-7f41-a166-f0a039474fc8€9.00€0.19matched
81capture01a1a958-7c30-78e0-86ec-44673398a342€24.00€0.37matched
82capture01a1a958-d9f2-784a-ae46-5a3036b0107c€24.00€0.37matched
83capture01a1a958-dc9b-7ee2-9f8f-fccca99f5ddb€35.00€0.50matched
84capture01a1a958-ea0c-77bf-9e17-ebe622fd612a€24.00€0.37matched
85capture01a1a958-f213-750d-ba61-381887e5d76d€9.00€0.19matched
86capture01a1a959-15b6-772a-acb2-976861971086€24.00€0.37matched
87capture01a1a959-2811-78f3-898a-a5cce2f733c9€15.00€0.26matched
88capture01a1a959-4b48-7245-bd5f-9c7ff9c24b88€15.00€0.26matched
89capture01a1a959-647b-7473-870d-73dadac66064€35.00€0.50matched
90capture01a1a959-66b5-7a0c-8880-ea5b37c0bce2€24.00€0.37matched
91capture01a1a959-8d50-7104-b06a-1553e8ddf168€49.00€0.67matched
92capture01a1a959-90c4-7674-8d23-cfc260ad6c85€49.00€0.67matched
93refund01a1a959-93f0-77ce-8d3b-9f81bc5fb69d-€18.00€0.00matched
94capture01a1a959-94e4-77fb-8522-0eb8f446d633€49.00€0.67matched
95capture01a1a959-9c30-7efc-ba40-e1aa08fbd54d€49.00€0.67matched
96capture01a1a959-b76b-79e6-a3c5-ce254a934aff€15.00€0.26matched
97capture01a1a959-be66-7f38-acd4-3a3bfdcd1233€49.00€0.67matched
98capture01a1a959-c8c4-7e46-ba4f-f6215e7f2f13€35.00€0.50matched
99capture01a1a959-cd9b-7e78-b10b-7a0c84e08d65€35.00€0.50matched
100capture01a1a959-db01-7520-a0c4-0cf3c039f112€35.00€0.50matched
101capture01a1a959-ffda-7f80-97b2-e98b85e7543f€15.00€0.26matched
102capture01a1a95a-15a9-75ee-9ec7-39e4a0a8d8bf€49.00€0.67matched
103capture01a1a95a-1b73-77a9-bf5d-10fb46698b92€35.00€0.50matched
104refund01a1a95a-277d-7529-93eb-dbe45bcc8224-€9.00€0.00matched
105capture01a1a95a-42a0-714a-8257-c978f241f241€49.00€0.67matched
106capture01a1a95a-55d4-78e3-8a8e-57b1f78043c8€9.00€0.19matched
107capture01a1a95a-7c36-7f97-b6da-4e290682984a€35.00€0.50matched
108capture01a1a95a-87a0-72ba-b2dc-fbe534febabd€35.00€0.50matched
109capture01a1a95a-8a1e-7dfc-bef5-973bf046e624€35.00€0.50matched
110capture01a1a95a-9807-74ba-82ab-5126cf23badc€15.00€0.26matched
111capture01a1a95a-a675-7250-adf1-1b841c5ce861€35.00€0.50matched
112capture01a1a95a-ade7-70a0-a106-6ea7b34a86a3€15.00€0.26matched
113capture01a1a95a-af81-79b6-b02c-7ee0489f0756€15.00€0.26matched
115capture01a1a95a-dc24-7044-8d70-af019391eee9€35.00€0.50matched
116capture01a1a95a-df17-7c25-9b29-5b9242d535ea€15.00€0.26matched
117capture01a1a95a-f7b6-7697-988f-ce65d2025210€15.00€0.26matched
118capture01a1a95b-0853-7b56-9ca2-82c5043256fd€35.00€0.50matched
119capture01a1a95b-0bac-7704-83d0-730070593b79€24.00€0.37matched
120capture01a1a95b-296b-78e9-8534-917a9304360c€9.00€0.19matched
121capture01a1a95b-3122-73c1-99d9-34e9cb0a744f€9.00€0.19matched
122capture01a1a95b-34d9-74e0-815c-c7476a6e6f70€24.00€0.37matched
123capture01a1a95b-3850-79f9-8d14-578399fea1bf€24.00€0.37matched
124capture01a1a95b-3cba-754e-82e5-940f15cdf6b6€24.00€0.37matched
125capture01a1a95b-44d1-7330-8490-12a7cda9cc95€35.00€0.50matched
126capture01a1a95b-576f-75a1-9240-e02abc0e930c€49.00€0.67matched
127capture01a1a95b-a9a6-7582-8d22-a3afa9a797af€49.00€0.67matched
128capture01a1a95b-b8cf-771b-8303-4f8bbf8c90bf€9.00€0.19matched
129capture01a1a95b-bf8e-79e0-a4fe-791a9e976721€49.00€0.67matched
130capture01a1a95b-cf56-7de9-ac2e-e7deb7611b78€24.00€0.37matched
131capture01a1a95b-d4f0-76e4-af15-3bd794e0f32f€49.00€0.67matched
132refund01a1a95b-e577-7bd1-a24a-793370f56f48-€5.00€0.00matched
133capture01a1a95b-f79d-7dcf-b3da-d235777b10e6€35.00€0.50matched
134capture01a1a95c-191d-7f8f-a7b3-d6833225e449€15.00€0.26matched
135capture01a1a95c-25ac-7dd9-b9a1-ac6e72d542bb€9.00€0.19matched
136refund01a1a95c-376f-7c17-a952-9f59fd772fb9-€12.00€0.00matched
137capture01a1a95c-3cf0-76e0-823e-b2f969ef8279€49.00€0.67matched
138capture01a1a95c-226b-7ef9-8180-f907efb8905e€15.00€0.26matched
139capture01a1a95c-4aeb-7691-b4c8-ea56603b9526€49.00€0.67matched
140capture01a1a95c-5332-7801-8b82-8f3e06268541€24.00€0.37matched
141capture01a1a95c-7c8a-75d4-b0a3-4ef170f58afe€49.00€0.67matched
142capture01a1a95c-7d8a-77ff-8b9d-e27fe122cf59€24.00€0.37matched
143refund01a1a95c-809e-7db4-b62f-c8b03b378d1c-€33.00€0.00matched
144capture01a1a95c-80bd-78c8-b8b4-12a9ce693eef€15.00€0.26matched
145capture01a1a95c-9267-7f17-b5a8-a2ff9f8f927c€15.00€0.26matched
146capture01a1a95c-a314-7f14-bac4-a933e6b120c1€9.00€0.19matched
147capture01a1a95c-bdcb-7118-9f11-746423362dd0€15.00€0.26matched
148capture01a1a95c-c613-79f8-bfb3-09b97880c549€15.00€0.26matched
149capture01a1a95c-d152-76c2-9718-882f220c99b4€9.00€0.19matched
150capture01a1a95c-e411-7e68-9e43-82730ac74056€35.00€0.50matched