Hi Daira,
First, the hard truth: there is no payment type in Mews that closes a balance with zero accounting impact, and you don’t actually want one. A true zero-impact close would break double entry and your books would never reconcile. What you want isn’t “no entry,” it’s the correct entry. Adrianne’s dedicated cleanup payment type is right for one of the cases below, but not all of them, so before you build it, sort your open items into three buckets. We cleared a few hundred of these after our own go-live, and the method matters more than the tool.
The rule: the correct fix depends on where the revenue is actually recognized.
Bucket A. Cash was collected in the other system, and the Mews charge is your real revenue.
The balance is open only because the payment is missing in Mews, not the charge. Post a payment, but through a dedicated external payment type mapped to a balance sheet clearing/suspense account, not a revenue account. This is exactly what Adrianne described. It records cash that genuinely came in (just outside Mews) and parks the offset in a clearing account your accountant reconciles against the external system. You aren’t inventing revenue, you’re recording a real receipt.
Bucket B. The revenue is recognized in the other system, and the Mews charge is a duplicate of it.
Do not post a payment here. If you do, you leave a phantom charge on your Mews books and your revenue is overstated by that amount. The correct fix is to rebate the original charge on the guest profile. The rebate removes the charge and the balance together, and reverses revenue that was never really yours in Mews. This is the part missing from the thread, and it’s the one most people get wrong by trying to “pay off” everything.
Bucket C. The money is genuinely owed and won’t be collected.
That’s a write off, not a cleanup. Rebate it, or use a bad debt payment type mapped to a bad debt expense account, so it hits the right line and doesn’t sit forever as a fake receivable.
How to sort them fast, instead of one by one:
Export your open guest ledger items, then export the “paid” list from each external system, and match them on name, dates and amount. Anything that matches a paid record is Bucket A or B, depending on where you book the revenue. Anything with no match is Bucket C or a genuine open item to chase. This also fixes the other three worries you raised: once everything is in a bucket, your receivables view is clean again, reminders only go to real debtors, and you can actually say who owes what. We matched ours in a spreadsheet against the OTA and external exports to catch the ones showing as debts that were already settled.
One caveat on rebates (Buckets B and C): the rebate lands in the period you post it, at the original VAT rate. If that revenue was already declared in a closed VAT period, post the rebate in thecurrent open period and flag it to your accountant so you don’t reopen a filed period.
Net: build the cleanup payment type Adrianne suggested for Bucket A, use rebates for B and C, and bucket everything first by matching against your external exports. That gives you a clean ledger and a full audit trail, which is the part Mews support will want to see anyway.
Erick
The Haus Group