- or
4702 results found
-
Reports - Voided invoices have a currency value on the Receivable Invoice Summary
It could be a glitch or just how the reports work, but Voided Invoices that were voided with a currency value in them, appear on the Receivable Invoice Summary with that value. So Invoice INV-45831 was for £123.00 but was voided. You can now no longer edit that invoice and in this report it eternally has the value of £123.00.
This is an issue as the data is downloaded to extrapolate many different analysis for sales data.
A bad fix after the data has been downloaded is to try filter and take out the ££ and change the data after extraction to £0 on all voided invoices.
Where this is not practical is when you use look up functions in excel to adjust a master sales record buy looking up onto the data from xero extracted daily. That look up will constantly return the £1234 value of a voided invoice of the source data from Xero.
You can then only change the master record to £0 taking the formula out of the cell. But each time the formula is updated for the cell range - this again means all the £1234 values pop back up and you go round the circle again.
The only real fix is to stop the Xero data containing a value for voided invoices. So you need to be able to edit them or they should show £0 value in the invoice reports.
It could be a glitch or just how the reports work, but Voided Invoices that were voided with a currency value in them, appear on the Receivable Invoice Summary with that value. So Invoice INV-45831 was for £123.00 but was voided. You can now no longer edit that invoice and in this report it eternally has the value of £123.00.
This is an issue as the data is downloaded to extrapolate many different analysis for sales data.
A bad fix after the data has been downloaded is to try filter and take out the ££ and change the data after…
1 vote -
Bill import - Allow default Supplier settings to apply to CSV imported bills
Example we explain here is a 4 line Purchase Order in CSV format which, using the Bills To Pay Template, we are importing in my test Xero platform.
Each line in the PO use a different Account Code from our Chart of Accounts.In brief, if we leave any of the Account Code fields empty the system does not seem to want to import the Supplier Contacts Purchasing Default Account settings.
I have tried all versions of this import and the only one I can get to work is one where all the fields are completed.
This means we have to code every part in our MRP with a Supplier Purchasing Account Code.
This to us is around 2,000 lines of purchased parts.However when I import Customer Invoice Data, if the Account Code Field is left blank, the system automatically pulls the default Account Code in for me.
Question ? why will it not do it for Suppliers ?See Harry's reply below.
Harry - Xero Specialist
Thank you for reaching out.
You're correct that there is a difference in behaviour between importing customer invoices and supplier bills when it comes to default account codes. This is a known limitation in Xero's import functionality for bills. Here's what's happening:
Customer Invoices: When importing customer invoices, if the Account Code field is left blank, Xero will indeed use the default sales account specified in the customer's contact settings.
Supplier Bills: Unfortunately, when importing supplier bills, Xero does not automatically apply the default purchase account specified in the supplier's contact settings if the Account Code field is left blank.
This discrepancy is not ideal, and I apologize for any inconvenience it may cause. To work around this limitation, you have a few options:
Complete all fields: As you've discovered, filling in all fields, including the Account Code, allows for successful imports.
Use a placeholder: You could use a placeholder account code in your CSV for all lines where you want the supplier's default to apply. Then, after import, you can bulk edit these transactions to apply the correct account codes.
Consider using the Xero API: If you're importing large volumes of data regularly, you might want to explore using Xero's API, which offers more flexibility in handling default values.
Provide feedback to Xero: I encourage you to submit this as a feature request to Xero. They value user feedback and use it to prioritize improvements to the platform.
I understand this isn't the ideal solution you were hoping for, but I hope these workarounds can help you manage your imports more efficiently. If you need any further clarification or assistance with implementing these suggestions, please don't hesitate to ask.
Kind regards,
Harry
Agent profile pic
Julian Newton-Turner
Today 8:24 AM
Hello Harry,
Thanks for the information.
I understand what you have said and how the system differs between Customer Invoices - Suppliers Bills To Pay.
I thought I was going nuts...why would it not work ? what am I not doing ?
it works with invoices ? aaaarrhhhh !
Now you have explained it , it makes sense.
To keep this message short, we are working with our MRP software supplier to build a customer API from their system into Xero. When we export data we can fully code the export / import file so it loads the right Account Code for the parts.
In our MRP - Purchase Order Export File we will only ever use 6 - 8 codes at a max.
I have attached our Chart of Accounts highlighted with our codes that we want to use in the import / export process.
Also Full PO Import CSV , Import Result ScreenshotYes I will look at the Xero API
Yes I will push this forward as a suggestion.Once again thanks for the explanation.
Julian
Example we explain here is a 4 line Purchase Order in CSV format which, using the Bills To Pay Template, we are importing in my test Xero platform.
Each line in the PO use a different Account Code from our Chart of Accounts.In brief, if we leave any of the Account Code fields empty the system does not seem to want to import the Supplier Contacts Purchasing Default Account settings.
I have tried all versions of this import and the only one I can get to work is one where all the fields are completed.
This means we have…1 vote -
NZ Payroll - Add statutory deductions for contractors
Add statutory deductions for contractors ie, court fines. With a reducing balance
1 vote -
Prepaid Expense Manager
My Idea: Somewhere to enter a prepaid annual or longterm expense (ie Insurance) that can first go into a Prepaid Expenses asset account and then set to either expense at regular intervals until "used up" or able to manually expense as periods come to a close. This manager would help keep track of all prepaid expenses in one place and would keep a running balance for each item. Viewing options would include being able to filter/sort by item (ie 2023 Insurance Premium), or by type (ie software subscriptions) or by expense account (ie Insurance Expense).
4 votes -
Sales Invoice - Show Subtotal Breakdown before VAT
Layout of invoices with subtotal breakdowns for various VAT rates. To be able to present multiple subtotal amounts before various types of VAT are applied to the invoice. I have included an altered pdf file as an example of what you would want to see on the invoice.
4 votes -
eInvoicing - Allow e-invoices across different countries
Under classic invoicing I can share invoices across the Xero network between Xero entities from different countries (in my case, Australian company invoicing a USA company) Why can't this feature be available under the new invoice format (I don't see what eInvoicing actually has to do with it)
First time I've seen Xero take a major step backwards (I now have to spend more time doing the same job... well done folks)
4 votes -
Bank Feeds - Bank feeds from Macquarie Bank
Ive moved form Quickbooks to Xero (I guess this is common).
Xero does not accept bank feeds from Macquarie Banks - Offset Accounts.
It's very frustrating to manually have to import bank statements every month and I would love if they could please collaborate so it can occurs. It makes it tedious for my business and I lose hours trying to do it every time.Cheers
2 votes -
Bug or Missing Feature Reporting
There is nowhere to report missing features and bugs apart from this forum, which is more for ideas.
I have found it difficult to find a place to report an issue quickly.
For new invoicing the list of missing features and bugs should be reported so we can see what has already been picked up and what is being worked on and fixed.6 votesHI Jill, appreciate you posting here, not knowing where else to go.
For something that appears to not be working as it should or where you're having performance issues in Xero - these are best to raise with our specialists at Xero Support where we have tools to investigate, triage any issues and escalate with our team if needed.
When it comes to new invoicing we've communicated a lot of the changes and what's coming up through our Xero central page here. Otherwise, you'll also find many ideas for changes across product ideas here that I'd recommend joining for updates where you're interested. Searching 'New invoicing' on the main page of the site should help you find a list of the different features.
-
edit transactions dates and accounts.
I would like to be able to edit an entered transaction, i.e., transfer, payment, etc. When I am reconciling, some transactions are posted on the following month, but they were entered at the end of the prior month this creates a problem when reconciling. All I need to do is edit the date and change it, but I have to remove and redo the transaction. This is extremely time-consuming.
Also, could we change the bank account when we enter the transaction in the wrong registry instead of removing and redoing it?
2 votes -
Purchase Order - Change Contact when copying to Invoice
Have also the change payee option, From copying the Purchase order to Invoice, so the customer from PO will remain in supplier contact lists only.
2 votesHi Janilyn, appreciate it's not an option when going through the copy to process. However, once the invoice is created you can click the 'x' next to the contacts name to remove and type the correct customers name.
If the previous contact has only had purchase transactions entered for them, once you've remove them from the invoice they should not be shown in the customers list in your organisation.
-
Entertainment ledger codes in COA - misleading
Chart of Accounts - the ledger codes (a) Entertainment-100% business and (b) Entertainment-0%. Can you change these categories? We accountants all know that the descriptions are misleading.
Almost all (unqualified) bookkeepers use (a) for client entertainment and claim VAT. Subsequently, accountants blindly treat this category as business expenses, reducing the taxable profit. (i.e. wrongly deduct it for corporation tax purposes) I cannot tell you how many cases I've seen in the past few years.
Please change the default categories to (a) Staff-only entertainment and (b) Client entertainment?
1 vote -
Payables report by planned date
Hi Guys,
Is there an option for us to general a payable report by the planned date?
1 voteHi Kai, you can run the Payable Invoice Summary report which has the ability to include Planned Date as a column, or you can also choose to group by this field if you'd prefer - Does this achieve what you're in need of here?
-
Dashboard - View exceeded credit limit
Hi, It would be great to see customers who exceeded their credit limits on the dashboard. We push sales invoices from third-party app therefore we don't see alerts if someone has no credit limit left. If we could see a list on the dashboard we could act immediately. Thanks
4 votes -
Reporting - Print pdf shortcut
To be able to have a short cut to be able to print pdf straight from report screen without having to click multiple times to get there
1 voteThanks for your feedback, Sadie. We don't have any direct plans for a PDF / Print shortcut atm but we'll feel out the interest from your idea here and let you know if there's any progress.
-
AU Payroll - Add payroll reports to management report
My EOM reports include PL, BS, Receivables AND payroll. Management report doesn't allow payroll reports to be added. Please allow this to be added to minimise time generating additional reports.
1 vote -
Expense Claims Date of Entry Retention
When entering expense claims, the program should be set to retain the date entered in the last expense claim item. When catching up on accounting, it is cumbersome to be working on July in December and have to go back and change the entire date for each entry. I should be able to retain the last entry date on the next and simply be able to edit the day.
1 vote -
Changing VAT code on paid supplier invoices
It would save a lot of time if it would be possible to edit the VAT code on paid and reconcilled invoices, just like you can change the nominal code. The VAT return is done at the end of each quarter, which means that the majority of invoices and expenses have been paid, by the time you are running your VAT return and double checking that all invoices and expenses have been correctly coded for VAT. At the moment, if an item is miscoded I need to go to that item, unreconcile the paymemt, go back to the item and the edit the VAT coding then go to the bank rec and re-reconcile the payment. This is bad enough if it was a signgle payment, but often it is a batch payment of a number of payments often 30+ that I then have to re-create the batch payment and re-run it. This is a very time consuming process.
It would save a lot of time if it would be possible to edit the VAT code on paid and reconcilled invoices, just like you can change the nominal code. The VAT return is done at the end of each quarter, which means that the majority of invoices and expenses have been paid, by the time you are running your VAT return and double checking that all invoices and expenses have been correctly coded for VAT. At the moment, if an item is miscoded I need to go to that item, unreconcile the paymemt, go back to the item and…
2 votes -
AU Payroll - Pay Contractors in payroll and include GST
Hi,
It would be great to be able to pay contractors (who are paid Super) in Payroll and have an option for GST. I feel the Contractor payments aren't user friendly for most small business as they have subcontractors and contractors where only GST is added and no PAYG tax is deducted.5 votes -
Sales Invoice - Include files attached to an invoice when sending
Ability or setting to default include files attached to an invoice when sending from Xero
Purpose | Steps are currently involved to include files that are on an invoice when sending the invoice to a customer, an option like this would ease the process of including files that a customer needs to have access to and see when they received their invoice
298 votes -
AU Payroll - Ability to apply tracking categories to superannuation
We have grant funding so wages as well as super needs to be applied with the tracking code to acquit grant correctly. Presently, there is no availability to apply tracking codes against the superannuation, as well it is only available through timesheets for the wages.
It would be very helpful if tracking codes could be applied directly with pay items in employee template (similarly like other software) so this can be applied when leave is taken also31 votes
- Don't see your idea?