LedgerMatch
LedgerMatch for Excel
Bank reconciliation directly in your spreadsheet. Import two sheets, reconcile transactions, and export matched and unmatched rows — without leaving Excel.
Install the Excel add-in
The add-in is not yet on Microsoft AppSource. Download manifest.xml below and sideload it manually using the instructions for your platform.
What you get
- Match bank and ledger rows automatically
- Flag unmatched and duplicate transactions
- Export results back to your spreadsheet
Excel Online (office.com)
- 1. Open Excel Online — Go to office.com and open any workbook in Excel for the web.
- 2. Open Insert → Add-ins — Click Insert in the top ribbon, then select Add-ins → Upload My Add-in.
- 3. Upload the manifest — Click Browse and select the manifest.xml file you just downloaded, then click Upload.
- 4. Open LedgerMatch — A new "LedgerMatch" button appears on the Home tab. Click it to open the reconciliation panel.
Excel for Windows (Desktop)
- 1. Download manifest.xml — Save the file somewhere easy to find, such as your Desktop.
- 2. Create a shared network folder — Create a folder (e.g. C:\ExcelAddins), share it on your network with read access, and note its UNC path (e.g. \\YOURPC\ExcelAddins).
- 3. Add as a trusted catalog — In Excel → File → Options → Trust Center → Trust Center Settings → Trusted Add-in Catalogs, paste the UNC path and click Add Catalog, then check "Show in Menu".
- 4. Restart Excel — Close and reopen Excel, then go to Insert → Add-ins → Shared Folder and select LedgerMatch.
Excel for Mac (Desktop)
- 1. Download manifest.xml — Save the file anywhere — your Downloads folder is fine.
- 2. Locate the sideload folder — In Finder, press ⌘+Shift+G and go to ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef/ — create the wef folder if it does not exist.
- 3. Copy manifest.xml there — Drag or copy manifest.xml into the wef folder.
- 4. Open LedgerMatch — Open (or restart) Excel. Go to Insert → Add-ins → Developer Add-ins and select LedgerMatch.