Skip to main content

How to reconcile Bills in Xero with Wallets

Updated over a month ago

ApprovalMax Pay Wallets make reconciling Bills in Xero seamless and straightforward. Once you complete a Batch Payment, Xero will show two entries — the Bill payment and the associated fee — both of which can be reconciled in just a few clicks.

How reconciliation works with Wallets

  • Once your Batch Payment has been paid in ApprovalMax, click the Open in Xero link next to a Bill:

    <a href="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfq0sdX1DfXF_tB8-naY28cJfHPrLyf8cE55lSZdNaPzS5X90S6y1NEwXHbs4S-40dn_vPkW0cVl4XAorxfSqcL8et0JUucEg1_Z8hIosZ9yso1Rc2gARIJyS0CoV87TG8_FJHBZJ7WcbriUZfvSN1zNLhbR2Q?key=fjTG5ZEjS1mSlf2SiP13bw" rel="nofollow noopener noreferrer" target="_blank">https://lh7-rt.googleusercontent.com/docsz/AD_4nXfq0sdX1DfXF_tB8-naY28cJfHPrLyf8cE55lSZdNaPzS5X90S6y1NEwXHbs4S-40dn_vPkW0cVl4XAorxfSqcL8et0JUucEg1_Z8hIosZ9yso1Rc2gARIJyS0CoV87TG8_FJHBZJ7WcbriUZfvSN1zNLhbR2Q?key=fjTG5ZEjS1mSlf2SiP13bw</a>

  • This takes you directly to a Payment record created in Xero against each Bill:

    <a href="https://lh7-rt.googleusercontent.com/docsz/AD_4nXeen-XzkXuFaDQyXMij3obsHbbXaDPI2H9MJNA-85dVEs9-hLs87TxLROoPXOAEizRyRuDI4MYRIRS5FbWDnMypEq15ofSNdkvdC5DJjCYh7XSgulfGl66WHJDLFJSCs9fNOyN1VDg4nJUqhvL-STrEOTUWpdg?key=fjTG5ZEjS1mSlf2SiP13bw" rel="nofollow noopener noreferrer" target="_blank">https://lh7-rt.googleusercontent.com/docsz/AD_4nXeen-XzkXuFaDQyXMij3obsHbbXaDPI2H9MJNA-85dVEs9-hLs87TxLROoPXOAEizRyRuDI4MYRIRS5FbWDnMypEq15ofSNdkvdC5DJjCYh7XSgulfGl66WHJDLFJSCs9fNOyN1VDg4nJUqhvL-STrEOTUWpdg?key=fjTG5ZEjS1mSlf2SiP13bw</a>

  • If needed, you can also see all Payment records under the Account transactions tab of your Wallet’s bank account in Xero:

    <a href="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfaQr2FrI9ntIZpU3E5-5ZHaHT26q2cDPoudWoBAO5zk9q-0VDAIQ2ajX6zc_cycxBbpyBz-wllxWSCZ2nTSwHieQnPME0XQ9dq2K47GoCuHgQm6DyN5eB9EWBnfdqxexUWA7bbrHGrRBImQEwWOn3by1i_D6A?key=fjTG5ZEjS1mSlf2SiP13bw" rel="nofollow noopener noreferrer" target="_blank">https://lh7-rt.googleusercontent.com/docsz/AD_4nXfaQr2FrI9ntIZpU3E5-5ZHaHT26q2cDPoudWoBAO5zk9q-0VDAIQ2ajX6zc_cycxBbpyBz-wllxWSCZ2nTSwHieQnPME0XQ9dq2K47GoCuHgQm6DyN5eB9EWBnfdqxexUWA7bbrHGrRBImQEwWOn3by1i_D6A?key=fjTG5ZEjS1mSlf2SiP13bw</a>

  • At the same time, ApprovalMax pushes a matching Bank Statement line into Xero, showing the payment outflow from each Wallet:

    <a href="https://lh7-rt.googleusercontent.com/docsz/AD_4nXd9UR5AGepl9nss6K7k3yQevv46P2WInQDCK4M9N6onAp5mhI__ofa0VWLfQewf2uyUxjLssyZCAAWe2Th74Io3r0hSdFTvS2BKS_R8c59INEOyRi6c4DsY0Wqg39vMZUWT-0RAec9yGsxqitAbX2yhcgJ7YKA?key=fjTG5ZEjS1mSlf2SiP13bw" rel="nofollow noopener noreferrer" target="_blank">https://lh7-rt.googleusercontent.com/docsz/AD_4nXd9UR5AGepl9nss6K7k3yQevv46P2WInQDCK4M9N6onAp5mhI__ofa0VWLfQewf2uyUxjLssyZCAAWe2Th74Io3r0hSdFTvS2BKS_R8c59INEOyRi6c4DsY0Wqg39vMZUWT-0RAec9yGsxqitAbX2yhcgJ7YKA?key=fjTG5ZEjS1mSlf2SiP13bw</a>

  • Go to the Reconcile tab in your Xero Bank Account to reconcile the Payment:

    <a href="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfxnIaOFr0qBkr1PHcQtL1HCbUGfxmH8u8w0VnAJzKvmVyx6U43fv_OSJ_sJLM1mpyzciaMZ5ZybHqdkOAJA0iO60LNTx_yAb4nnDyiGIbdzje-68VcCceNqBeGIwcv53FHtP4Wt0kUWdi5UgfBFLX2MJn6aQ?key=fjTG5ZEjS1mSlf2SiP13bw" rel="nofollow noopener noreferrer" target="_blank">https://lh7-rt.googleusercontent.com/docsz/AD_4nXfxnIaOFr0qBkr1PHcQtL1HCbUGfxmH8u8w0VnAJzKvmVyx6U43fv_OSJ_sJLM1mpyzciaMZ5ZybHqdkOAJA0iO60LNTx_yAb4nnDyiGIbdzje-68VcCceNqBeGIwcv53FHtP4Wt0kUWdi5UgfBFLX2MJn6aQ?key=fjTG5ZEjS1mSlf2SiP13bw</a>


  • Xero will automatically suggest a match between the Payment record and the bank statement line. Review the details. If everything looks correct, click on OK.

    <a href="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfKd98kizjibgNXTl-KE9aZA8x5cu5dmWXsN1uEIDWL4NoSIz4pIKjMLt4JC7fD_cSrbBbhsp2i3vTcOTwATvW1JuJx6YbAPyaNu-GJ_IrB44ny9MS-bH3r7c6osQ6_PBT15liBQWVqiRNXAfmZheSanPOuOcI?key=fjTG5ZEjS1mSlf2SiP13bw" rel="nofollow noopener noreferrer" target="_blank">https://lh7-rt.googleusercontent.com/docsz/AD_4nXfKd98kizjibgNXTl-KE9aZA8x5cu5dmWXsN1uEIDWL4NoSIz4pIKjMLt4JC7fD_cSrbBbhsp2i3vTcOTwATvW1JuJx6YbAPyaNu-GJ_IrB44ny9MS-bH3r7c6osQ6_PBT15liBQWVqiRNXAfmZheSanPOuOcI?key=fjTG5ZEjS1mSlf2SiP13bw</a>

  • In addition to reconciling the Bill payment itself, you’ll also need to reconcile the associated payment fee. In the Reconcile tab, for each Bill, you'll see an unmatched line with the fee amount:

  • In the Create tab. Fill in the following fields:


    • Who: set this to ApprovalMAx

    • What: choose the account you want the fees booked to (for example, 404 – Bank Fees).

    • Why: copy the description from the statement details (e.g., Payment fee for payment PAYM-XXXX).

  • Click OK to complete the reconciliation:

    Troubleshooting

    ApprovalMax needs specific permissions from Xero to push Wallet bank statement lines into Xero. If these permissions are missing, you’ll see Payment records created in Xero, but the corresponding bank statement entries won’t appear.

    How to check:

    Look at your Wallet card in ApprovalMax. If you see the label “Xero Bank account connected”, your Wallet is linked correctly.

    If permissions are missing, ApprovalMax will display a warning message on the Wallet screen, the KYC submitted screen, or the Payment confirmation pop-up when paying with Wallets.

    To resolve this:

    Go to your Organisation settings and reconnect your Xero organisation. This will automatically grant all required permissions.



Did this answer your question?