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:
Open QuickBooks and navigate to the Reports tab
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
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.