Vendor (AP) payment reconciliation

ACCT
Receive vendor payment-related information in your application, do reconciliation in your application, and submit that information back to your platform

1. Authorize integration

Ensure your user authorizes their integration with their specific accounting platform

2. Retrieve your user's accounting configuration data

The following steps will cover the business logic you will need to configure in your backend to interact with Merge’s Unified API.

“Settings” data refers to all information related to suppliers, accounts, and tracking categories. To do this, we will access three endpoints:

  • Retrieve all suppliers in the accounting platform using the GET /Contacts endpoint. You can filter this by is_supplier.
  • Retrieve accounts in the accounting platform using the GET /accounts endpoint. You may choose to only look at certain classifications.
  • If your user has tracking categories configured, you can retrieve them from the accounting platform with GET /Tracking Categories .
3. Retrieve unpaid bills

Retrieve all bills for all suppliers that aren’t yet paid

  • Use the GET /Invoices endpoint to access all invoices, and use the query param = ACCOUNTS_PAYABLE to filter to only bills.
  • Look at the Balance field to find invoices that have a non-zero value. Filter to only show invoices that haven’t been paid.
4. Create payments against bills

Based on the status of the bills you pulled into the system, you’ll programmatically create payments/expenses against bills. You should pull this information from your customer’s banking platform.

5. Reconcile payments

For Payments that do not match the bill amount, you will want to reconcile these payments by updating the Invoice information.

Currently, Merge does not support the PATCH /Invoice endpoint. Instead, this can be supported through our Authenticated Passthrough Requests.

Reach out to schedule a demo to get access to our Authenticated Passthrough requests.
6. Keep your users' finances in check automatically

With financial and accounting data flowing properly, your app can help your users keep their financial statements in balance, matching their payments to bills and reconciling the differences.

Automate reconciliation with Merge

Integrate today or talk to our sales team to learn how Merge unlocks hundreds of integrations in days - not years.
Share your feedback:
Optional

Related use cases

Financial analysis with transaction-level detail (low-level)
ACCT
Create budgets, predict runway, and provide other information based on key transaction information
Key models & fields
name
account_number
current_balance
accounts_payable
balance
is_supplier
Typical sync frequency
Highest
Industries
SaaS Procurement
CPG Tools