Customer (AR) payment reconciliation

ACCT
Reconcile payment receipts in your platform and communicate accounting receivable invoices and payments to your customer’s accounting platform

1. User authorizes access

Your user authorizes your application to access their accounting service (e.g., QuickBooks Online, NetSuite) via an OAuth or similar authorization flow through Merge Link.

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 customers, accounts, items, and tracking categories. To do this, we will access four endpoints:


  • Sync your customer’s chart of accounts by using the GET /accounts endpoint.
    • You can use the classification and parent_account fields to compile account types and hierarchy!
  • Follow the steps outlined in the Sync Customers or Suppliers” use case to sync your customers in your system with the third party.
  • If your customer has classes, locations, or departments configured, you can retrieve them from the accounting platform with GET /Tracking Categories.
  • Utilize the GET /items endpoint to pull in your customer’s products, goods, and services.

3. Retrieve customer invoices

Retrieve all invoices for all customers:

  • Use the GET /Invoices endpoint to access all invoices, and set the type query param = ACCOUNTS_RECEIVABLE to filter to only AR invoices.
  • Look at the balance and status fields to find invoices that are not fully paid.

4. Reconcile invoices and payments

Based on the reconciliation process that occurs within your platform, you’ll programmatically create payments and/or invoices.

  • If an Invoice does not exist for a receipt of money, create an Invoice using the POST /invoice endpoint and corresponding Payment using the POST /payment endpoint.
  • If an Invoice is not yet paid, create a Payment against the Invoice using the POST /payment endpoint.
  • If you need to update an Invoice or Payment in the accounting platform, you can use PATCH /invoice or PATCH /payment endpoints.

Make it easy to make sense of spend 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

Create invoices
ACCT
Serve specific industries by either automating invoice or bill creation, or creating approval processes around sending invoices or bills to third-party accounting systems
Sync customers or suppliers
ACCT
Read and write contacts to keep your database of customers/suppliers in sync with your customer's accounting system
Key models & fields
name
status
unit_price
purchase_price
purchase_account
sales_account
company
GETPOST
type
issue_date
status
total_amount
balance
applied_payments
name
description
classification
type
status
GETPOST
contact
account
transaction_date
GETPOST
is_customer
Typical sync frequency
Highest
Industries
CPG Tools
Billing