Upload your AR aging report and get a daily collections plan
You don't need a live accounting integration to use Nectivo.ai. Export an accounts receivable aging report from NetSuite, Xero, Sage, Microsoft Dynamics, QuickBooks Desktop or any other system, upload it as a CSV or Excel file, and get the same live DSO, aging buckets and AI-recommended next steps as a QuickBooks Online connection.
What your file needs
Only two columns are required: the customer name and the balance due. Everything else is optional and makes the plan smarter.
- Required: customer name, balance due.
- Helpful: invoice number, invoice date, due date, days overdue, invoice amount.
- Contact details: email and phone, so you can send reminders and texts.
- Follow-up history: last and next follow-up dates, customer notes and comments.
- Entity, if you manage more than one company or division.
Files can be CSV or Excel, up to 20,000 rows. A downloadable import template is available inside the app.
How the upload works
- Export an AR aging report (detail or summary) from your accounting system.
- Upload it in Nectivo and match your column names to Nectivo's fields. Your mapping is saved, so the next upload is one step.
- Review any rows that couldn't be read. Nectivo tells you which rows failed and why.
- Work the list. Amber ranks the accounts that need attention and drafts the next message for each one.
Messy report? The import template includes a ready-made prompt you can paste into ChatGPT, Claude or any AI assistant to turn a PDF, an awkward export or a copy-pasted table into a clean import file in minutes.
Keep it current automatically
Each company also gets its own import email address. If your accounting system can email a scheduled AR aging report, send it there and Nectivo imports it automatically with your saved column mapping. If a file is late or the columns change, the admin gets a notice explaining what to fix.
What you get
- Live DSO (days sales outstanding) and AR aging by bucket, with a trend over time. Check your numbers with the free DSO calculator.
- A daily list of who to contact next and why, from Amber, Nectivo's AI.
- Payment reminder and collection email templates with your balances filled in. See our past-due invoice email templates.
- Follow-up dates, call logs, a shared inbox for replies and a full audit trail.
Using QuickBooks Online? Connect it directly instead and skip the upload. See QuickBooks collections software.
Frequently asked questions
Which accounting systems does the upload work with?
Any system that can export an AR aging report to CSV or Excel, including NetSuite, Xero, Sage, Microsoft Dynamics 365 Business Central and QuickBooks Desktop. Nectivo connects directly only to QuickBooks Online; the others work through the upload.
What is an AR aging report?
An accounts receivable aging report lists what each customer owes, grouped by how long it has been outstanding, typically current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due.
How often should I upload a new aging report?
Weekly at a minimum, or daily if you work collections every day. A scheduled email to your import address keeps it current without manual uploads.
Does uploading a file change my accounting system?
No. Nectivo only reads the file you upload. Nothing is written back to your accounting system.