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

4 Nov, 11:00

Gross

€3,128.00

PSP fee

€49.89

Net to the bank

€3,078.11

Settlement journal

#378155

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a63f-25ff-748d-b5b8-fd7c7a62bcd1 is already settled by stl_EUR_2989650 line 122
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
LineKindReferenceGrossFeeStatus
45capture01a1a63a-2555-7aae-adcf-18fcf85f33f5€15.00€0.28fee difference
46capture01a1a63a-3cfb-728d-a7ec-f8a3bc433e71€9.00€0.24fee difference
123capture01a1a63f-2620-7efc-a731-cf7754ef3167€49.00€0.67duplicate line
1capture01a1a630-3f5f-7e36-8d7b-24a08ca8f00d€15.00€0.26matched
2capture01a1a630-65cb-78cf-b70f-98eafff80179€9.00€0.19matched
3capture01a1a634-feb5-7287-a8c0-52d40fed7618€35.00€0.50matched
4capture01a1a637-3e81-76a2-986b-48ee810e2b8b€24.00€0.37matched
5capture01a1a637-55fc-7fd8-8993-9346fe6c1877€24.00€0.37matched
6capture01a1a637-69ca-71be-9a69-77ae87c65147€24.00€0.37matched
7capture01a1a637-6bdc-7a30-9d43-03c0998ef25d€15.00€0.26matched
8capture01a1a637-7127-7fb8-9c4b-8728d90a8259€35.00€0.50matched
9capture01a1a637-8311-7765-b78b-a19b90547d26€35.00€0.50matched
10refund01a1a637-93e2-78cf-9b4f-3e849c917596-€15.00€0.00matched
11capture01a1a637-dfa2-7936-890b-9e0561a79aef€49.00€0.67matched
12refund01a1a637-dfe6-7841-abfa-29aa680537dd-€48.00€0.00matched
13capture01a1a637-ebff-766e-b0a6-5ab51c0c741b€35.00€0.50matched
14refund01a1a637-ed06-7370-b302-c90bbdfe5b2f-€19.00€0.00matched
15capture01a1a637-fec7-73ea-91e3-979ebf0b0f2e€9.00€0.19matched
16capture01a1a638-3ac8-713f-a44d-aad4918ba270€24.00€0.37matched
17capture01a1a638-47ed-77b2-8053-4c0d49389c05€15.00€0.26matched
18capture01a1a638-5278-7117-86a2-e6fb1beeca07€15.00€0.26matched
19capture01a1a638-7784-7a69-b13b-8b4244085210€24.00€0.37matched
20capture01a1a638-8552-7a3b-a955-5e4e60cf6853€35.00€0.50matched
21capture01a1a638-a4a3-7e13-bca8-ff84b0823ef3€15.00€0.26matched
22capture01a1a638-aaaa-7e60-b38d-1ada314d36b2€9.00€0.19matched
23refund01a1a638-b22f-7ec2-8f7e-31e826a161bc-€4.00€0.00matched
24capture01a1a638-bd09-71f9-b726-577e19562ac8€15.00€0.26matched
25capture01a1a638-cad9-7de1-ac76-a344a3e02632€24.00€0.37matched
26capture01a1a638-db18-76c4-a865-45ac008670ad€9.00€0.19matched
27capture01a1a639-04f9-7858-95ee-1040adc568db€15.00€0.26matched
28capture01a1a639-0853-7d00-942a-9e2a71592ef0€24.00€0.37matched
29capture01a1a639-19c0-7ce0-9471-bf7c41a27a43€49.00€0.67matched
30capture01a1a639-1df6-7ba6-a753-692698fb045c€15.00€0.26matched
31capture01a1a639-2320-7320-9865-54a5a649c8dd€35.00€0.50matched
32capture01a1a639-32ee-7dcd-8ec1-c0dd524ca279€15.00€0.26matched
33capture01a1a639-7734-74f6-b35f-edcaba4c66f6€49.00€0.67matched
34capture01a1a639-77b3-76db-8973-67eeb3b4e255€24.00€0.37matched
35capture01a1a639-7e51-741e-b1c8-1a453f7740b9€9.00€0.19matched
36capture01a1a639-b8b3-7e9a-be35-e43dc5dc20a7€24.00€0.37matched
37capture01a1a639-c4be-74b4-b967-9c161ac0f261€49.00€0.67matched
38capture01a1a639-cb4a-7e6e-b671-d4977693b692€15.00€0.26matched
39capture01a1a639-d412-7030-9235-b615bcce4922€15.00€0.26matched
40capture01a1a639-e161-7f5c-87cf-370eff0eb8ee€49.00€0.67matched
41capture01a1a639-f135-729e-928c-d6717d72678b€35.00€0.50matched
42capture01a1a63a-1707-7d1d-9550-40a57b193a5a€49.00€0.67matched
43refund01a1a63a-1ca6-72b5-94e7-6e605d1c59e5-€15.00€0.00matched
44capture01a1a63a-2626-77d5-b07a-e8e87af76392€24.00€0.37matched
47capture01a1a63a-5c3b-71ec-b9ed-b66bc90dfd51€35.00€0.50matched
48capture01a1a63a-63ac-7e15-86c8-d1bacbee8c4e€9.00€0.19matched
49capture01a1a63a-74f2-7ca4-bc6b-6c8b59ade87c€9.00€0.19matched
50capture01a1a63a-94d9-72ab-a9fb-d6f05ef71b94€24.00€0.37matched
51capture01a1a63a-952a-704c-9b51-44af2bf7b893€49.00€0.67matched
52capture01a1a63a-c430-7609-861e-dc73c0b446e9€49.00€0.67matched
53capture01a1a63a-c507-76bd-86e6-9b925ede46f0€15.00€0.26matched
54capture01a1a63a-dc79-7887-b5a1-1e48930498fb€49.00€0.67matched
55capture01a1a63a-dcb2-78ff-bf8d-c6db8994eb66€24.00€0.37matched
56capture01a1a63a-edea-75c1-ac0d-5d13dffd4dcd€9.00€0.19matched
57capture01a1a63a-fc7e-75ca-af9c-404b53283d72€49.00€0.67matched
58capture01a1a63a-ff9e-74d5-8077-8ab7bf67c8a9€35.00€0.50matched
59capture01a1a63b-053f-7956-87ce-711ad6f9b9f1€49.00€0.67matched
60refund01a1a63b-0a8f-799a-acb3-5f30f6fd8026-€22.00€0.00matched
61capture01a1a63b-34c2-7936-8ee1-48f38f6633d9€15.00€0.26matched
62capture01a1a63b-643c-7ce7-93ca-43b5caade4fd€24.00€0.37matched
63capture01a1a63b-9e40-794b-9083-ed4f1e3795aa€9.00€0.19matched
64capture01a1a63b-a6f2-718f-b1f7-09e7bb95bbb4€24.00€0.37matched
65capture01a1a63b-d42e-7fe5-aff5-5e6683e56c69€49.00€0.67matched
66capture01a1a63c-29a5-7447-a149-6407e3f71ed7€24.00€0.37matched
67capture01a1a63c-2b18-74d2-ac8c-b2323ca6ff50€49.00€0.67matched
68capture01a1a63c-307f-778e-b2a2-bad63726be01€24.00€0.37matched
69capture01a1a63c-3f96-7b84-998c-2170ab163ecd€35.00€0.50matched
70capture01a1a63c-4052-77e1-a6ab-61caf472903f€35.00€0.50matched
71capture01a1a63c-6d11-70d6-a114-c2ba55820286€49.00€0.67matched
72capture01a1a63c-7abc-75b1-8fc7-e33504f26931€15.00€0.26matched
73refund01a1a63c-88f8-78e2-8d5f-abe6d14aa400-€7.00€0.00matched
74capture01a1a63c-da06-75c9-aa69-6eabb84f1451€35.00€0.50matched
75capture01a1a63c-db92-71bd-bad3-1a4f02459bca€49.00€0.67matched
76capture01a1a63c-e101-748d-8e7c-98437990bdb7€35.00€0.50matched
77capture01a1a63c-e463-7f41-bdee-831645160504€9.00€0.19matched
78capture01a1a63c-eb5f-7833-a919-a45344de1178€35.00€0.50matched
79capture01a1a63d-0020-7386-b922-2ca565d3bdf6€24.00€0.37matched
80capture01a1a63d-0478-717d-bf22-555633d6d769€9.00€0.19matched
81capture01a1a63d-0673-711e-b89c-7896f8aab9d9€15.00€0.26matched
82capture01a1a63d-0ab8-7701-acc2-a5738a3c073b€9.00€0.19matched
83capture01a1a63d-0ff4-7549-b152-2001f65fdcdb€49.00€0.67matched
84capture01a1a63d-16c4-7c32-8889-62857358850e€9.00€0.19matched
85capture01a1a63d-3358-764c-b722-ccd01f5a3577€49.00€0.67matched
86capture01a1a63d-3529-7bdb-b207-768a878e302c€15.00€0.26matched
87capture01a1a63d-56f0-7d8c-b19f-22946441c5ab€35.00€0.50matched
88capture01a1a63d-87ba-75fc-9c77-1f0c1c9046c1€35.00€0.50matched
89capture01a1a63d-96bf-7c63-8fba-25cf7da894fc€9.00€0.19matched
90capture01a1a63d-b715-76d8-a670-7918e3d3b330€24.00€0.37matched
91capture01a1a63d-ce0d-719a-9163-930db2a473d2€24.00€0.37matched
92capture01a1a63d-d54c-738d-ade2-ae0fa711bd23€15.00€0.26matched
93refund01a1a63d-e148-7d85-a207-605538483e71-€21.00€0.00matched
94capture01a1a63d-ed4b-7ce1-85db-6d6d83e1b924€35.00€0.50matched
95capture01a1a63d-f040-7325-a6ff-60616a533320€49.00€0.67matched
96refund01a1a63d-fd28-734d-b4f1-7aa6889a604c-€20.00€0.00matched
97capture01a1a63e-070f-7f18-a936-88a6444bc722€9.00€0.19matched
98capture01a1a63e-14c7-7538-ba41-1a9b3c2ddf20€9.00€0.19matched
99capture01a1a63e-199e-750e-bff2-2103eff37d50€49.00€0.67matched
100capture01a1a63e-1fb3-7bf4-ae4d-7690f8b55dd8€35.00€0.50matched
101capture01a1a63e-20af-7491-be67-2c888f88cb76€35.00€0.50matched
102capture01a1a63e-2251-73e2-9609-1a3aa91e4389€35.00€0.50matched
103capture01a1a63e-25c2-7a66-bd3b-10f4be45ebc6€49.00€0.67matched
104capture01a1a63e-3e65-71d4-85a7-816ef9fbb83f€49.00€0.67matched
105capture01a1a63e-4276-754d-9026-78e6a8dd650e€9.00€0.19matched
106refund01a1a63e-707f-75a4-81e1-5866ff7aaea2-€4.00€0.00matched
107capture01a1a63e-955e-7a24-a5f6-8aef54601f3a€49.00€0.67matched
108capture01a1a63e-97eb-736d-872d-ade3e05a0bdb€24.00€0.37matched
109capture01a1a63e-9ac5-7dd5-9bf4-a8d6ac004552€15.00€0.26matched
110capture01a1a63e-a842-75cd-a9c6-1f68a01aecd8€15.00€0.26matched
111capture01a1a63e-b02b-766e-bdf7-9097af023f99€35.00€0.50matched
112capture01a1a63e-b44d-752a-a9b6-6f80ea8aea3a€15.00€0.26matched
113capture01a1a63e-bd99-751d-83d7-37c3f6cfd8e1€9.00€0.19matched
114capture01a1a63e-be08-7705-8e69-cd68e3277728€15.00€0.26matched
115capture01a1a63e-c6ea-7c91-a00c-4aaf8e1734e8€24.00€0.37matched
116capture01a1a63e-cf3b-7f14-8dc3-282d948ebb35€49.00€0.67matched
117capture01a1a63e-d888-7b9f-a994-f6103bb67cc7€15.00€0.26matched
118capture01a1a63e-ef9b-7f7f-9bb8-54d91d482403€49.00€0.67matched
119capture01a1a63f-106a-7574-bdc5-58de5b6b0fb7€35.00€0.50matched
120refund01a1a63f-114a-79b1-8f89-08f0d7fa839b-€4.00€0.00matched
121capture01a1a63f-1272-72da-9ad9-1c9c3d1c09ef€49.00€0.67matched
122capture01a1a63f-2620-7efc-a731-cf7754ef3167€49.00€0.67matched
124capture01a1a63f-2b1f-758b-b5ad-6c63ce7707df€24.00€0.37matched
125capture01a1a63f-455e-75a8-80a2-ad5d47052ff2€15.00€0.26matched
126capture01a1a63f-6fe4-7a02-adb4-e423f1155b4a€49.00€0.67matched
127refund01a1a63f-8a56-7787-b317-e4fb78463430-€19.00€0.00matched
128capture01a1a63f-a89d-7192-8384-1905f2d79df4€9.00€0.19matched
129capture01a1a63f-b697-7f7d-8c3b-9bcde1c30667€9.00€0.19matched
130capture01a1a63f-cae6-70b0-ae86-32b11cf4f1be€35.00€0.50matched
131capture01a1a63f-d65b-7ed5-b48a-19381e061819€15.00€0.26matched
132capture01a1a63f-e0f3-71f3-b218-7bc6624b33a3€24.00€0.37matched
133capture01a1a63f-e8f5-7093-8c7f-7b6847e70f1d€24.00€0.37matched
134capture01a1a63f-f0e5-77f4-b9ba-2a5f88a7bf24€9.00€0.19matched