All Collections
Integrations
QuickBooks Online
QuickBooks Online: Match your Owed to Settle report
QuickBooks Online: Match your Owed to Settle report
Anna Briggs avatar
Written by Anna Briggs
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.

Did this answer your question?