Import unpaid invoices from Xero
Bring the unpaid invoices from Xero into Stackem, so what customers owe is right from the start for statements and reminders.
This page lists the unpaid sales invoices in your connected Xero organisation, so you can bring them into Stackem. Then statements, overdue reminders and what each customer owes are right from the start.
To open it, go to Administration > Integrations, Accounting tab, and click Import under Import unpaid invoices. You need the Accounting Manage permission. If Xero isn't connected, you're sent back to Integrations to connect it first.
The list
Each invoice shows its Invoice number (with Xero's reference under it), Customer, Issued and Due dates, Total, how much is Owing, and Status:
- The Due date is red when the invoice is overdue.
- Status is New if the invoice hasn't been imported yet, or Imported if it has.
Only approved Xero sales invoices with an amount still owing are listed. The list starts filtered to New invoices, soonest due first. Clear the Status filter to see all of them. You can search by invoice number, reference or customer.
Importing
- Import on a row imports that invoice.
- Import selected imports the rows you've ticked.
- Import all new imports every invoice that hasn't been imported yet. The button shows how many invoices that is.
Each invoice is only imported once. If some can't be imported, the message says which and why; the rest are still imported.
What an imported invoice looks like
Each Xero invoice becomes a sales order, already delivered and invoiced:
- The invoice has the same number as in Xero (unless Stackem already has an invoice with that number), and the same issue and due dates.
- The order's reference is "Xero" and the invoice number, for example Xero INV-0042.
- It has one line, "Xero invoice" and its number, for the Xero total. The line has no tax on it, because the GST was already reported in Xero.
- Payments and credits already made in Xero come across too, so the amount owing matches Xero.
- If the invoice's customer hasn't been imported from Xero yet, they're imported too.
Nothing is sent back to Xero: the invoice is already there. Payments made in Xero later come across by themselves.
Refreshing
Invoices are fetched from Xero and kept for about ten minutes. Click Refresh from Xero to fetch them again straight away, for example after raising invoices in Xero.