{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/723d69938e9c413c9dd8ca818683ab83\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/723d69938e9c413c9dd8ca818683ab83-d21e713df2f77e18.gif","duration":134.033333,"title":"Pay by Bank: Reconciling Deposits","description":"This Loom explains how to reconcile pay-by-bank transactions to bank deposits using July 3 as an example. The closing report shows total prepayments of $8,061.72, and the sales report provides a fast match where total income minus processing fees equals the disbursement shown on the deposit, $7,800.42 for July 3. It also notes that voided or cancelled pay-by-bank transactions may not appear on the sales report, creating discrepancies. In those cases, it recommends using the Duchy Pay Settlement Report for transaction-level detail, focusing on transaction amount, transaction fees, and the disbursement batch total, though totals must be calculated manually after export."}