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, 03:00

Gross

€2,714.00

PSP fee

€42.30

Net to the bank

€2,671.70

Settlement journal

#335629

Breaks for a person to look at

  • 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 54, the contract says 50
  • missing linein the books, not in the filecapture:01a19a35-3339-7ff6-ae48-ff2f54e6a58c is in no file
LineKindReferenceGrossFeeStatus
3capture01a19a31-93b0-75d1-85a2-11a911c97e6e€35.00€0.50duplicate line
47capture01a19a36-b179-7e28-892c-f55e8cde681f€9.00€0.23fee difference
55capture01a19a37-5007-7d33-9583-2c9e8ab4b7b7€35.00€0.54fee difference
1capture01a19a2d-fe3b-715f-a5f8-d0f1bddf16e7€49.00€0.67matched
2capture01a19a31-93b0-75d1-85a2-11a911c97e6e€35.00€0.50matched
4capture01a19a32-79fb-733b-8457-c6610824c405€15.00€0.26matched
5capture01a19a33-206c-7e1d-8d12-5f8b2d61d875€35.00€0.50matched
6capture01a19a33-249f-7dcf-8cc0-09b62303b862€9.00€0.19matched
7capture01a19a33-6b36-78d3-bc17-7c03593f7f5c€9.00€0.19matched
8refund01a19a33-6d1a-7f18-bc41-2635b0c2c7b8-€4.00€0.00matched
9capture01a19a33-8903-7738-9aeb-98234166ecc4€9.00€0.19matched
10capture01a19a33-a9e8-77da-9fbe-a6da9dccfb51€15.00€0.26matched
11capture01a19a33-c3b0-75bb-aadc-8bbe2ba9667b€9.00€0.19matched
12capture01a19a33-d0e8-7ab4-9839-ca0316447c1b€49.00€0.67matched
13capture01a19a33-f6bd-7045-8111-cb2a73423646€49.00€0.67matched
14capture01a19a34-3e88-7663-839b-b9d0a11b4893€15.00€0.26matched
15capture01a19a34-410c-789d-89ed-ce13b8be0ac3€24.00€0.37matched
16capture01a19a34-48c4-7313-b1e8-8960d7b57bb6€9.00€0.19matched
17capture01a19a34-5bb1-7ab2-abca-b88a37f4d39a€35.00€0.50matched
18capture01a19a34-7851-7e35-b652-c58717340e3f€9.00€0.19matched
19capture01a19a34-82a8-7686-8b9f-7aad579b7859€49.00€0.67matched
20capture01a19a34-a338-75fd-a3b3-73fda90ff567€9.00€0.19matched
21capture01a19a34-bec0-7207-9816-ccfe826aec03€35.00€0.50matched
22capture01a19a34-c66c-7f76-8e98-aa5836c67d01€24.00€0.37matched
23capture01a19a34-cb43-79f7-8f1d-49d38177a434€24.00€0.37matched
24capture01a19a34-dd35-76f5-8ed4-63001f97816c€35.00€0.50matched
25capture01a19a34-eb53-776d-9107-41b754f6de5f€24.00€0.37matched
26capture01a19a35-1762-773f-a807-f7c717ef20c3€35.00€0.50matched
27capture01a19a35-3765-7482-b13e-10da0560c562€49.00€0.67matched
28capture01a19a35-5054-7964-8931-fac66b149e31€9.00€0.19matched
29capture01a19a35-5a6c-79c3-b9ec-b553ffe39c56€15.00€0.26matched
30capture01a19a35-5eba-79a7-a1ba-b8122643f8f5€24.00€0.37matched
31capture01a19a35-831e-7b64-96e9-6e6828ec1965€35.00€0.50matched
32capture01a19a35-8642-7c8b-98f7-8243bcbd3593€9.00€0.19matched
33capture01a19a35-89ec-7846-9cf0-4328f4f49a75€24.00€0.37matched
34capture01a19a35-8b48-79fb-983c-93afd03dc801€24.00€0.37matched
35capture01a19a35-9738-7ab8-9391-6ec94b1b8872€9.00€0.19matched
36capture01a19a35-ab28-7393-ab5a-d274df757ae1€49.00€0.67matched
37capture01a19a35-b5ef-737d-8806-b388d55bcd62€24.00€0.37matched
38capture01a19a35-cd5c-73e1-bd1b-dba9ca3a1436€35.00€0.50matched
39capture01a19a35-f541-76ea-8b75-553d53589a34€9.00€0.19matched
40capture01a19a36-1071-7236-8e52-a5e9e891ace3€15.00€0.26matched
41capture01a19a36-2d51-7f86-9d91-958c0a676b21€24.00€0.37matched
42capture01a19a36-3c9e-7de8-8718-f054fa51a586€9.00€0.19matched
43capture01a19a36-631d-7e91-bd12-96287a368634€35.00€0.50matched
44capture01a19a36-6cde-7d88-b414-46dab0cef12d€24.00€0.37matched
45refund01a19a36-a7ad-7ef3-b383-f636d975e031-€13.00€0.00matched
46capture01a19a36-a7de-781d-ba3f-d7222cf6397b€15.00€0.26matched
48capture01a19a36-b364-737f-a330-1dd1ac253118€35.00€0.50matched
49capture01a19a36-d877-7850-bfbb-bef3149b0b55€9.00€0.19matched
50capture01a19a36-da28-7532-8c7e-d92dafe421e5€24.00€0.37matched
51capture01a19a36-df23-7f25-b50c-e886d16ff523€35.00€0.50matched
52capture01a19a36-f339-7729-acc0-4d6cf2a05d73€9.00€0.19matched
53refund01a19a37-00d1-72d9-8584-7f43c0b9c43f-€8.00€0.00matched
54capture01a19a37-250c-79b4-8cc7-a68cfa5029df€49.00€0.67matched
56refund01a19a37-82ed-7f0c-847d-b98c5c8f306d-€32.00€0.00matched
57capture01a19a37-a0fa-7849-acae-3a803bbd2e43€35.00€0.50matched
58capture01a19a37-b85d-768b-99f7-c68be8c988ff€35.00€0.50matched
59capture01a19a37-e5da-7a4a-b09c-5e7354527e9a€49.00€0.67matched
60capture01a19a38-067d-73f0-9d75-8a3e994d847d€15.00€0.26matched
61capture01a19a38-2604-7007-8f9f-9599fbc2f524€35.00€0.50matched
62capture01a19a38-262d-702a-b616-8eba4bd60340€24.00€0.37matched
63capture01a19a38-2d72-778a-a28f-feb24a997610€35.00€0.50matched
64capture01a19a38-2de6-783e-81b0-d617b2a5d02d€9.00€0.19matched
65capture01a19a38-2fb4-76b5-b3cf-c807f8d3f273€15.00€0.26matched
66capture01a19a38-3b91-7eef-88c2-87b653bc7a4e€24.00€0.37matched
67capture01a19a38-40b1-7f19-a2b0-7ec3cb33c454€9.00€0.19matched
68capture01a19a38-4288-78b2-a64b-91e2c68b4cf4€9.00€0.19matched
69capture01a19a38-4605-72da-bd98-d95d5adb8703€49.00€0.67matched
70capture01a19a38-54c4-77d5-aa55-814ec208cb70€24.00€0.37matched
71capture01a19a38-78c9-7124-989f-bfa832c3225e€35.00€0.50matched
72capture01a19a38-9e52-7f83-a50d-7c172913a599€15.00€0.26matched
73capture01a19a38-a79c-7406-a055-9016d2c9ea4a€35.00€0.50matched
74capture01a19a38-def1-7280-8d1f-6e4d9d2cd2b1€9.00€0.19matched
75capture01a19a38-fc61-765a-b490-723545c3d417€9.00€0.19matched
76capture01a19a39-134e-73ba-8131-7d40ce85d0a1€49.00€0.67matched
77capture01a19a39-43a6-777d-9631-1ad3bc029856€49.00€0.67matched
78capture01a19a39-4b2d-7d23-b516-46c826179481€24.00€0.37matched
79capture01a19a39-688b-782f-94dc-9b5a1a46cd4d€35.00€0.50matched
80capture01a19a39-701c-7c1a-8fd6-2a35f8957610€24.00€0.37matched
81capture01a19a39-795c-73e4-b51d-f9ce4e9465e4€35.00€0.50matched
82capture01a19a39-9af7-7f0a-8757-11a3506404b5€9.00€0.19matched
83capture01a19a39-a85e-7520-9dbf-48e8ab656f22€15.00€0.26matched
84capture01a19a39-abf5-7c46-adf8-da1a10860b4d€9.00€0.19matched
85capture01a19a39-cadd-78aa-93bd-d73270770825€35.00€0.50matched
86capture01a19a39-cd7c-702e-9543-78c18786862c€9.00€0.19matched
87capture01a19a3a-01f4-7070-860f-69dceeb9e0d2€9.00€0.19matched
88capture01a19a3a-026e-7202-8046-77fa742c40bb€9.00€0.19matched
89capture01a19a3a-044a-760e-ad41-137aae3b33f9€49.00€0.67matched
90capture01a19a3a-0eb2-7248-ae0c-fcde9cca1877€15.00€0.26matched
91capture01a19a3a-1b89-7597-9609-9a6112106d85€9.00€0.19matched
92capture01a19a3a-2e98-7c36-877c-0a8d6c02ad25€49.00€0.67matched
93refund01a19a3a-6c90-71a3-baee-8d71ec1438ee-€9.00€0.00matched
94capture01a19a3a-706e-7720-9e3b-9591e66ed065€9.00€0.19matched
95capture01a19a3a-7fc0-79b2-866e-c6392f8c882f€35.00€0.50matched
96capture01a19a3a-9fde-7575-a0a1-57939988d419€15.00€0.26matched
97capture01a19a3a-a190-7fe9-9321-b8dc8fc8a616€49.00€0.67matched
98capture01a19a3a-b256-722b-81a6-e62f320d3b31€24.00€0.37matched
99capture01a19a3a-b2a6-7230-8e31-eafdebb3449c€35.00€0.50matched
100capture01a19a3a-b2e8-73d3-a494-12f5064af573€9.00€0.19matched
101capture01a19a3a-c08b-7e95-8bba-19f0b7518f62€9.00€0.19matched
102capture01a19a3b-046c-7a09-9d66-08aa4c3a0381€49.00€0.67matched
103capture01a19a3b-3431-758d-89be-617ce63db17f€49.00€0.67matched
104capture01a19a3b-3fb7-7173-a0b5-8486baf583b0€24.00€0.37matched
105capture01a19a3b-59e4-730c-b836-e5d6103dbeee€9.00€0.19matched
106capture01a19a3b-5c67-7dbd-b8e1-b7a93be1f2ba€49.00€0.67matched
107capture01a19a3b-97ac-7792-9e8f-6aa34cc22f2f€35.00€0.50matched
108capture01a19a3b-c616-7b98-ab7b-7634dfde8d6e€35.00€0.50matched
109capture01a19a3b-d72c-7990-9630-56d9beea686d€49.00€0.67matched
110capture01a19a3b-dffc-7323-8be5-d85bf3e2f2d5€15.00€0.26matched
111capture01a19a3b-eb70-796d-9688-1c028c03907f€9.00€0.19matched
112capture01a19a3c-0f31-7d59-a63e-62fa5bc474ea€49.00€0.67matched
113capture01a19a3c-1503-7cd8-8382-65550e35746c€24.00€0.37matched
114capture01a19a3c-2577-7878-88a6-0b1c9c3a4c1a€9.00€0.19matched