What Is Reconciliation?

Reconciliation is the process of matching two payment amounts against each other:

• Amount billed:  what you invoiced the broker for a load

• Amount received: what actually landed in your bank account (paid by the broker directly or through a factoring company)

The goal is to confirm that every invoice is accounted for and to record any difference, whether the load was underpaid, fully paid, or unpaid.

Step 1 — Filter and Select Invoices

1. Go to Accounting > Invoices > Reconciliation

2. Click Add Reconciliation
   
   

    

3. Use the date filter to narrow down the invoice list
4. Select the invoices you want to reconcile and click Add
   
   

Step 2 — Choose a Reconciliation Method

Method 1: Manual Reconciliation

Best for: matching a specific payment amount to one or more loads by hand.

1. Copy the Load ID of each invoice being reconciled
2. Paste the Load ID(s) into the Load ID field
3. Enter the amount received in your bank account (as sent by the broker)
4. Enter the Collected Date
5. Click Reconcile
   
   
    
6. If the received amount differs from the invoiced amount, click Finalize to close out the reconciliation with the difference recorded

Method 2: "Other" Reconciliation

Best for: recording factoring company payments where you have a file from the factoring company.

1. Select Other from the dropdown next to the Collected Date
2. Upload the file sent by the factoring company, then match the Load Pay and Load ID from the file to the corresponding invoices
   
   
    
3. Click Submit 
4. Click Finalize. Datatruck will show you any invoices where the received amount differs from the expected amount, so you can review and resolve each discrepancy.

We hope this article was helpful. However, if you have any further questions, please don't hesitate to reach out to our Live Support.
​
​