Contact report / export - Including credit limits and terms
Report listing all customers including contact details, credit terms and credit limits
James Davey
shared this idea
Hi everyone, while there isn't a report that you can report 'terms' atm, you could run the Aged Receivables Summary report that'll provide all the other detail you're asking here.
From Columns in the report you'll see the option to include Credit Limit as well as many of the contact details such as Email and Phone. If this is a report you'd want to access frequently, save it as Custom and maybe even favourite the report so you can easily access it.
When you mention wanting to include 'terms' it'd be good to get more detail of your expectations in this would this be the terms and conditions of the theme applied to invoices for that contact, or perhaps billing information that you may have saved in notes for the contact? Thanks
-
Robyn Sharp
commented
customer report that lists all the contact details plus their billing information.
-
Rob Newton
commented
This type of export (credit limit and credit balance), particularly with API is critical to those who use ERP and other systems to manage customer quotations and orders.
and not just for a single contact but all company customers at once, especially if there are 1000 transaction limits per day.The system we work in must have access to credit limits and balances so that when an order is received before it is accepted, we can check if credit limit will be exceeded .
The same at order dispatch - before we release the goods, we need to know if account is on hold.best to have one source of truth, the accounting system that receives the money .
It is difficult to believe that after all the requests for proper credit management that Xero has not provided.
Does Xero understand its clients? Manufacturers use ERP for front line sales. We need to know what clients have in balance on credit limit and on order BEFORE entering an order otherwise the limit will be exceeded and we are at risk of invoicing a client out of limit AND if we hold the client might cancel an order underway .Get with the program Xero - MYOB can do this, why can't you?
-
Shirley Connor
commented
We would like to print a list of ALL our customers showing credit limit, credit terms, Account number, ABN number, State, contact details (primary name & phone number).
We can export the contact list and edit it but it doesn't show the credit limit which we have entered on the contact. -
Jeffrey Pfeiffer
commented
While we can add credit limits per contact, and the Aged Receivables Summary can show credit limits in the report if the contact has an outstanding balance, no where is there a way to see ALL unused credit limits when used = $0. It seems that an easy fix would be to add credit limit to the contact download. HOW EASY WOULD THIS BE? Seems like a quick / easy fix!!!
-
Nicole Holden
commented
Client gifting, Christmas cards, mailing lists etc - the info is in Xero and XPM, why can't we get it out?
-
Monica Rossi
commented
Currently, there is not a report which will show all companies in one report with their address, name and opening balances.
It is frustrating having to individually display/export each contact and then add the balances to the exported document.
It would be great if this feature could be made available as soon as possible.
Thank you