All Collections
Integrations
QuickBooks Online
QuickBooks Online: Match your Owed to Settle report
QuickBooks Online: Match your Owed to Settle report
Becca Campbell avatar
Written by Becca Campbell
Updated over a week ago

Settle provides an aging report just for all payables that are due to Settle. This Owed to Settle report will list the following where applicable:

  • EPT principal owed

  • EPT fees owed

  • MVC principal owed

  • MVC fees owed

  • Principal owed + any interest accrued from amortized loans

To download this report, navigate to Docs and reports and click Export on the Owed to Settle report

Owed to Settle report in QuickBooks Online

Follow these steps to run a Owed to Settle report in QuickBooks Online:

  1. Open QuickBooks and navigate to the Reports tab

  2. Select the Transaction List by Vendor report under Expenses and vendors

3) Customize the report by Filtering by Vendor. Select Settle

4) To save this report, select Save customization and name your report to Owed to Settle report

FAQ

Why isn’t QuickBooks' AP Aging report matching with the Owed to Settle report?

  • Settle syncs EPT repayments as journal entries that pay down the liability in your Settle Loans Payable account. Since journal entries inherently don’t have a due date, they will never appear in the AP Aging report. Therefore your liability to Settle will appear overstated compared the report exported from Settle. It’s best practice to compare the Owed to Settle report from Settle to the Owed to Settle report in QBO.

  • For more on how our EPT syncing works, read here.

Why can’t I see amortized interested owed to Settle in QuickBooks?

  • Settle does not currently record accrued interest in QuickBooks for amortized loans. We record the interest expense as journal entries as installments are paid.

  • For more on how amortized loans sync to QuickBooks, read here.

Why is the amount in the QuickBooks’ owed to Settle export sometimes different from the amount in the Owed to Settle report within the Reporting in Settle?


In the Settle app Owed to Settle report, the liability for loans is based on the payment creation/initiation date. The QBO accounting sync uses the payment completed at date. This is why there is sometimes a discrepancy with reporting when comparing the Settle report, as of a given date, compared to the Settle outstanding balance export in QBO. As an example, if a loan is paid off in Settle on January 30, that loan will no longer be included in your Settle app Owed to Settle report as of January 31. The loan payment may not show in QuickBooks until February 1, though, so will still show in your owed to Settle export as of January 31.

Did this answer your question?