Settle offers a variety of reports and exports to help businesses track their finances, manage accounts payable, and stay organized. Below is a breakdown of the available reports, their purpose, and how they can be used.
AP Aging Details - Shows AP Aging information for each bill, grouped into 30-day aging buckets. This report can be downloaded as of any date. Bills with an invoice date (not Due Date) in the future, are included. Bills are included even if the bill or payment is in the In Review status. The report also includes an Approver column listing the names of the users who approved each bill.
AP Aging Summary - Shows AP Aging information for each vendor (if anything is owed), aggregating outstanding liabilities into 30-day aging buckets. This report can be downloaded as of any date. Bills with an invoice date (not Due Date) in the future, are included. Bills are included even if the bill or payment is in the In Review status.
Owed to Settle - Shows what you still owe Settle on financed payments, as of a date: the principal, the fee or interest, and the total owed on each item. This report can be downloaded as of any date. For the full repayment schedule, see the Outstanding Loans Report.
Outstanding Loans Report - Shows financing information for bills financed through Settle, breaking down outstanding liability and expected repayment. This report can be downloaded as of any date.
Product Cost Report - Shows the weighted average cost of each catalog item, based on your purchase orders and work orders from the past year. It always uses weighted average cost. This report needs a plan that includes the Product Cost feature.
Cash Outflows - Shows total payment amounts, organized by category, for each week starting two weeks in the past for a 6 month period.
1099 export - Contains all information for vendors required to file your 1099. This export conforms to tax1099.com’s upload template and can be used to easily file your 1099s for the year.
Exports: These all export info about the filtered items, similar to what you’d see in our UI. Each of these can be exported for all-time or a given date range.
Bills
Payments
Purchase Orders
Purchase Orders with line items
Invoices
Vendors
Documents: These export PDF versions of various documents generated during various activities in your account. Each of these can be exported for all-time or a given date range.
Business Loan and Security agreements
Payment confirmations for all bills
Payment confirmations for all Invoices
Exported reports keep their own dates and times. They don't follow the Time zone setting in your profile.
Stored reports – Fast access to your latest data
Tired of re-running reports? With Stored Reports, businesses can quickly download the most recently generated version without having to start from scratch.
Scheduling reports – Get a report by email
Instead of downloading the same report again and again, you can have Settle email it to your team on a schedule.
What you can schedule
Reports: AP Aging Details, AP Aging Summary, Owed to Settle, Outstanding Loans Report, Product Cost Report, Cash Outflows
Exports: Bills, Payments, Purchase Orders, Purchase Orders with line items
The 1099 reports, Vendors, Invoices, and the Documents don't have a schedule option.
How to schedule one
Go to Docs and Reports, find the report or export, and choose Download, then Email on schedule.
Pick how often: Weekly, Biweekly (every other week), or Monthly.
Pick the day. Weekly and Biweekly use a day of the week. Monthly uses the First day or Last day of the month.
In Send to, choose one or more teammates. Only active team members are listed, and you need at least one.
The note at the bottom of the window shows what will be sent: a CSV file and a link to the report, from reports@settle.co, at 7 AM ET.
Optional: choose Send test now to get a test email first. It is sent once the report is ready.
Choose Create schedule.
What recipients get
Each recipient gets an email with the report as a CSV file and a link to it. Exports (Bills, Payments, Purchase Orders, Purchase Orders with line items) send your year to date. Everyone on the schedule gets the same report the person who set it up would get, even if a recipient's own role can't see that data in Settle. Choose recipients with that in mind.
If a report takes a while to prepare, Settle keeps preparing it and emails it when it's ready.
Change or delete a schedule
A report with a schedule shows a Scheduled tag on its row. Select the tag to change the schedule, or to Delete it. You can also choose Download, then Edit delivery schedule.
For more information or troubleshooting help, contact our support team! 🚀