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, 19:40

Gross

€3,180.00

PSP fee

€49.37

Net to the bank

€3,130.63

Settlement journal

#384826

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
LineKindReferenceGrossFeeStatus
11capture01a1a814-09c8-7ed6-9462-8b417c9f075e€49.00€0.70fee difference
93capture01a1a819-f7c4-7d6e-bf79-df026affe9e2€9.00€0.21fee difference
1capture01a1a813-66f3-7f19-b4c1-d09278378838€15.00€0.26matched
2capture01a1a813-80d7-7e86-893d-74674b5f85fb€15.00€0.26matched
3capture01a1a813-8b9f-71f7-afab-953f125b7f3f€15.00€0.26matched
4capture01a1a813-998a-7982-80e8-6edb961b6c2d€24.00€0.37matched
5capture01a1a813-a8ca-7cd6-a187-a00bd8c618c5€49.00€0.67matched
6capture01a1a813-c69d-79cd-b1bb-bf33a63aa909€35.00€0.50matched
7capture01a1a813-d51d-7346-a820-8ddc2d3b83a5€49.00€0.67matched
8capture01a1a813-d7aa-7167-8b14-ceb6d9ef578a€49.00€0.67matched
9capture01a1a813-f4c1-76e7-9844-04873bae8e60€35.00€0.50matched
10capture01a1a813-f9f3-73d7-b072-d7038e3a2d7b€35.00€0.50matched
12capture01a1a814-0af7-73c8-a628-038365d3a8dc€24.00€0.37matched
13capture01a1a814-4e2d-7c04-8d6c-7900b0167095€35.00€0.50matched
14capture01a1a814-559c-745e-8823-1d3ddf331d17€9.00€0.19matched
15capture01a1a814-6e93-7097-8f82-e86a7349753b€35.00€0.50matched
16capture01a1a814-96ff-7411-bda9-5d675328beda€49.00€0.67matched
17capture01a1a814-a7d6-7719-8fc3-d50a445dafd7€35.00€0.50matched
18capture01a1a814-e7b8-76ec-ac09-9b0a55f5ec64€49.00€0.67matched
19capture01a1a814-f86d-765b-b48e-23624d10ddd8€9.00€0.19matched
20capture01a1a815-194f-7bc6-abc0-f5e175bbcb00€24.00€0.37matched
21refund01a1a815-19ed-71ca-b8ff-7ea07b6aaf5f-€33.00€0.00matched
22capture01a1a815-2f78-7db5-b0b6-8b1c9a68452e€24.00€0.37matched
23capture01a1a815-39c1-7756-bca9-67d4a78e6d8e€15.00€0.26matched
24capture01a1a815-3d62-7a77-8a2c-eb6d0b672a71€15.00€0.26matched
25capture01a1a815-4f8c-7e5a-abe4-1a3864bd42e7€49.00€0.67matched
26capture01a1a815-5cfd-7b5b-81ab-57078ada25a7€35.00€0.50matched
27capture01a1a815-5e29-713d-a98e-e09c20755c0c€49.00€0.67matched
28capture01a1a815-7765-7470-9fbd-5034bf03fc20€9.00€0.19matched
29capture01a1a815-780c-7293-8ccc-3a0d2616113a€49.00€0.67matched
30capture01a1a815-b027-7364-a91d-e7bec81036aa€49.00€0.67matched
31capture01a1a815-b43a-703d-8f2d-085d6d44b316€49.00€0.67matched
32refund01a1a815-bd73-7733-b444-9d6c07e74858-€28.00€0.00matched
33capture01a1a815-e0ef-7620-8791-5ebc9893483f€15.00€0.26matched
34capture01a1a815-e46d-7854-975a-c9c9ea212c81€49.00€0.67matched
35capture01a1a815-f638-7279-808b-fa0590f0f377€15.00€0.26matched
36capture01a1a816-42b5-755c-a37e-bdc9ec9a0abe€15.00€0.26matched
37capture01a1a816-42ae-78f7-a433-cd914931b6fa€24.00€0.37matched
38capture01a1a816-4bc0-7626-9e60-644e139bb47b€49.00€0.67matched
39capture01a1a816-b4fb-77e6-805a-614e377bc9a1€35.00€0.50matched
40capture01a1a816-d2a8-7609-9297-0fbfdadd1c8e€49.00€0.67matched
41capture01a1a816-d55e-7649-b79d-0e01d60b7bf3€15.00€0.26matched
42capture01a1a816-d74a-718d-9c0d-d35c59047c6e€24.00€0.37matched
43capture01a1a816-e4d3-7bf0-9303-641b9997d0a0€35.00€0.50matched
44capture01a1a816-f63c-77b7-8aea-ff5a49cca7ef€24.00€0.37matched
45capture01a1a816-fad6-7730-a009-116705a008a3€24.00€0.37matched
46capture01a1a817-3e2a-76df-94e2-de67fcda0d66€9.00€0.19matched
47capture01a1a817-549f-7fc1-bc90-888099a873e0€15.00€0.26matched
48capture01a1a817-5711-7e6d-b67d-62e46affff28€49.00€0.67matched
49capture01a1a817-5b17-704c-84e2-3995cc13ee96€49.00€0.67matched
50capture01a1a817-5bc3-7974-a70e-ae73f237f1bd€49.00€0.67matched
51capture01a1a817-5c3f-7864-bc3a-1872bc1322e6€9.00€0.19matched
52capture01a1a817-81ef-72cc-b2e5-ee2254845fe2€35.00€0.50matched
53capture01a1a817-8dc1-7f7f-b92e-44d77d2a324f€9.00€0.19matched
54refund01a1a817-a6ee-7cf2-953f-8df7e2471b0e-€17.00€0.00matched
55capture01a1a817-bc21-7be9-8883-55f7a41507ee€24.00€0.37matched
56capture01a1a817-df44-7bff-9a11-12bf5bd09cb3€24.00€0.37matched
57capture01a1a817-f96f-73b0-bf4b-4598503334ae€15.00€0.26matched
58capture01a1a817-f9c3-7d47-9c72-c92244564ef9€49.00€0.67matched
59capture01a1a818-0646-740a-a1aa-b20d91c06217€49.00€0.67matched
60capture01a1a818-0309-7815-b09b-ec3453611964€9.00€0.19matched
61capture01a1a818-267d-7866-b091-1bdd5d6393ef€24.00€0.37matched
62capture01a1a818-2c92-7448-b105-31f55c0342d9€9.00€0.19matched
63capture01a1a818-3dec-7883-9afd-4c402ab2b9d3€15.00€0.26matched
64capture01a1a818-3f22-79a9-8c88-01b2c766c255€9.00€0.19matched
65capture01a1a818-4a81-700c-ba38-f6d5dd687fca€35.00€0.50matched
66capture01a1a818-57ed-7066-bef0-194f19daf0f2€15.00€0.26matched
67refund01a1a818-7b62-71e0-8b4a-763ba1ebfd07-€11.00€0.00matched
68capture01a1a818-7e4c-7c1b-a8c6-af2b7a48bdec€49.00€0.67matched
69capture01a1a818-858a-7580-9fae-acbd67fbe344€24.00€0.37matched
70refund01a1a818-93f4-78f4-84c3-b0df6fdfac3f-€4.00€0.00matched
71capture01a1a818-a03f-7802-b9dc-22e69023869d€35.00€0.50matched
72capture01a1a818-b2c2-7ab0-bb3a-ddcfff890e65€15.00€0.26matched
73capture01a1a818-b9fb-78e8-bda0-cf6227e164c8€49.00€0.67matched
74capture01a1a818-c142-7320-aaba-cad8a0607954€9.00€0.19matched
75capture01a1a818-d036-7956-8e5f-4f08a82c60e1€9.00€0.19matched
76capture01a1a818-d963-716b-99be-fb252731c121€49.00€0.67matched
77capture01a1a818-ee27-7805-88aa-4322dce6c993€15.00€0.26matched
78capture01a1a818-f755-7b9e-9ddb-089415d8330c€49.00€0.67matched
79capture01a1a819-0de8-702c-bb64-1b4c285fd290€49.00€0.67matched
80capture01a1a819-24f2-71ca-8c82-db275bb6c51f€49.00€0.67matched
81capture01a1a819-3008-757b-b8c5-917af95512aa€35.00€0.50matched
82refund01a1a819-696a-7e5e-a20a-27607272d575-€35.00€0.00matched
83capture01a1a819-6c08-7873-8983-9f714d7cbc38€35.00€0.50matched
84capture01a1a819-7abf-7e0d-9400-8e530961a214€15.00€0.26matched
85capture01a1a819-823d-7167-98c0-637cd03b2c6d€49.00€0.67matched
86capture01a1a819-9f50-7436-8eb7-76650e0ab297€9.00€0.19matched
87capture01a1a819-b09b-78a6-8e8b-c120f9604312€15.00€0.26matched
88capture01a1a819-b247-736a-9939-4a1d4ecadb23€49.00€0.67matched
89capture01a1a819-c853-772c-b559-9a375c3b172a€24.00€0.37matched
90capture01a1a819-cb06-772a-8486-f8cdb2b44660€15.00€0.26matched
91refund01a1a819-deb2-7004-a7c0-b23347879547-€30.00€0.00matched
92capture01a1a819-e64c-7e18-a05d-724f72163d74€49.00€0.67matched
94refund01a1a81a-0e18-7d95-9ebb-6e7837185a43-€14.00€0.00matched
95capture01a1a81a-1edf-77cf-b86e-2cd216820392€24.00€0.37matched
96capture01a1a81a-3f88-7826-843a-14c9a02af9cf€49.00€0.67matched
97capture01a1a81a-4056-708f-845b-a419df61a43e€35.00€0.50matched
98capture01a1a81a-442d-7042-a234-d56a3928d7e4€15.00€0.26matched
99capture01a1a81a-4242-7e94-abd6-329686621c74€9.00€0.19matched
100capture01a1a81a-4d15-7e00-a846-417d2d81909f€24.00€0.37matched
101capture01a1a81a-6252-7657-bf9e-f150b4f290ef€9.00€0.19matched
102capture01a1a81a-7f23-78fe-a007-8d3dbe19e778€9.00€0.19matched
103capture01a1a81a-88cf-7761-aca0-b43f35c67aa8€49.00€0.67matched
104capture01a1a81a-8cf1-7097-93ad-2b9a4639f780€15.00€0.26matched
105capture01a1a81a-a0a0-7636-9e7b-d939e53e7e0f€49.00€0.67matched
106capture01a1a81a-af98-7d4f-8dc1-62b18cb2cae0€35.00€0.50matched
107capture01a1a81a-d0d6-705c-8b8b-e79387e7da6b€49.00€0.67matched
108capture01a1a81b-0070-74db-acb5-6e3de713e0e9€15.00€0.26matched
109capture01a1a81b-5770-758f-b1f7-a032214b82cb€35.00€0.50matched
110capture01a1a81b-6e90-78e3-b405-695028d9799d€49.00€0.67matched
111capture01a1a81b-6ffb-70c8-8819-1b8d5aded9bd€35.00€0.50matched
112capture01a1a81b-9e97-73c1-85ce-0ba023c1ce7f€15.00€0.26matched
113capture01a1a81b-cdbf-7836-b72b-580a86aa5b9e€49.00€0.67matched
114capture01a1a81b-e0e9-72f9-8400-67fbb91ed22b€9.00€0.19matched
115capture01a1a81b-e742-7072-a848-0ad2fc650a5a€35.00€0.50matched
116capture01a1a81b-eeca-73b8-97b6-6112f9c11dff€24.00€0.37matched
117capture01a1a81c-0c2e-7743-82a7-33c037ea31c5€35.00€0.50matched
118capture01a1a81c-3e52-7625-8394-243040c00c2b€49.00€0.67matched
119capture01a1a81c-5cb6-785b-b8a5-69ce685aa530€35.00€0.50matched
120capture01a1a81c-6728-70bb-ad58-65b636645134€35.00€0.50matched