What it is, why it matters, and how to use it
What is the Reconciliation Report?
The Reconciliation Report helps validate and match submitted invoice data against processed transactions in your Nimbello system. It's designed to ensure consistency between what has been entered and what has actually moved through the export/import process.
Think of it as your quality control checkpoint—spotting discrepancies, stuck invoices, or confirming that everything went through as expected.
💡 Why It Matters
The Reconciliation Report is especially valuable for:
-
✅ Ensuring accuracy before month-end closing
-
🔍 Troubleshooting missing or delayed invoices
-
🔄 Monitoring invoice status movement across systems
If you're trying to answer the question: "Did this invoice actually go through?" — the Reconciliation Report is where you go first.
🔎 How to Use It
First, Navigate to the report
Reports>AP Reports>Reconciliation Report
Then, Set Your Filters
Use the filters at the top of the report to narrow your search. This is helpful if you're tracking a specific invoice, vendor, or timeframe.
Available Filters:
-
Invoice Number
-
Vendor Name
-
Vendor Number
-
Export Date
-
Import Start Date
-
Import End Date
-
DirectTo (If you only want to see invoices directed to a specific user)
💡 Tips:
- Combine filters (e.g., Vendor Number + Export Date) for more precise results.
- It is recommended to select a start date so that it doesn't take a long time to load in the data
Transaction Summary
Once filters are applied, this section of the report displays a summary of invoices in the following status categories:
-
Archived
-
Not Exported
-
Exported
-
Imported
This gives you a quick snapshot of where your invoices stand overall.
💡 Tips:
- If you feel too many invoices are getting archived, it's possible that you're getting a lot of duplicates processed through Nimbello, and they are getting archived automatically. For a tutorial showing how you can generate a custom report to isolate the issue, see the article below:
How to identify which vendors send the most duplicates in Nimbello
Transaction Info
Scroll down to the Transaction Info section for a breakdown of invoices in more detailed "hold" or transitional statuses. These can help you pinpoint delays or identify invoices needing manual action.
Hold/Transition Statuses Include:
-
Portal Verification
-
Hold PO
-
Hold Non PO
-
Verification
-
Manual
-
Error
-
AP Review
-
Ready To Export
-
Paysite Hold
-
Factor Vendor Hold
-
Tenant Transfer
-
Paid
-
Exporting
-
Posted
-
Awaiting Confirmation
-
Failed Import
🛠️ Use this section to troubleshoot and escalate issues with stuck invoices.
Tip: If you would like more information about any of the invoices statuses listed above, check our knowledgebase. If you can't find what you're looking for, feel free to reach out to Support!
Hold PO Reason Summary - By Category
Invoices can be caught in Hold PO Status for a variety of reasons. This section shows you the count of how many invoices are stuck, as well as what the hold reason is
💡 Tips:
- For specific articles going over resolving invoices stuck in Hold PO statuses, we have a series of articles available.
Hold PO Status: Comprehensive Guides and Resolutions for Invoice Holds
✅ Pro Tips
-
Use this report regularly to keep your invoicing clean and on track.
-
If an invoice is missing from your accounting system, check here before escalating.
-
Combine it with vendor filters for vendor-specific performance reviews.
Need help interpreting your Reconciliation Report? Contact Nimbello Support—we’re here to help.