- or
4717 results found
-
Bank Reconciliation - Allow the Tax Setting to Default to Tax Exclusive
When creating new 'spend money' transactions during bank reconciliation, allow the tax setting to match the tax setting in financial settings, if set to tax exclusive, so that it doesn't just default to tax inclusive.
5 votes -
Reporting - Flag when actual Retained Earnings doesn't match to the report value
A flag which shows when the profit & loss figure plus brought forward retained earnings does not add up to the retained earnings on the reports. This is usually due to a mapping issue where a figure is causing a transposition error. It only seems to flag if you opt to include a statement of changes to equity. Seems like there should be a more obvious flag for this issue to ensure it is not missed.
Also perhaps a reconciliation between the profit & loss figure in the company accounts versus the Xero business, appreciate this is likely to be different due to accounting adjustments but a reconciliation to prove the difference would be useful.A flag which shows when the profit & loss figure plus brought forward retained earnings does not add up to the retained earnings on the reports. This is usually due to a mapping issue where a figure is causing a transposition error. It only seems to flag if you opt to include a statement of changes to equity. Seems like there should be a more obvious flag for this issue to ensure it is not missed.
Also perhaps a reconciliation between the profit & loss figure in the company accounts versus the Xero business, appreciate this is likely to be…3 votes -
US Integrate Invoicing with Invoice Processing Platform ipp.gov
Integrate invoicing with the US Govvernment Invoice Processing Platform, which covers nearly all invoicing of US Government Contracts, other than DoD and Intelligence Community. Right now, there’s only a manual entry process from a Xero generated invoice. https://www.ipp.gov/
1 voteAppreciate wanting a streamlined process for this. We'll track the interest in this through the idea here, and share if there are any plans made.
-
New invoicing | Online invoice - View supplier ABN
Why does the Supplier ABN not appear on the online invoice view? We now have to download the invoice as a PDF to see the ABN. This was not an issue with the Classic view.
2 votes -
Reports - Ability to add Sales Inventory Items to P&L Report
We would love the ability to include/add Sales Items to the P&L Report under Cost of Goods Sold - in order to track specific items(products/services).
1 vote -
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 -
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 -
NZ tax- Student Loan overseas borrower repayments
Overseas Borrower Student Loan repayments have different payment dates (30 September and 31 March), there is currently no functionality within Xero Tax (NZ) to manage these payments. I understand it is not possible for the system to calculate the repayment amounts as these are determined based on the loan balance, but if there could be an override amount like for Provisional Tax that would be useful, instead of having to track these borrowers manually.
14 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 -
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 also32 votes -
Account Transactions - Edit transaction dates without remove & redo
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 votesHi Ana, out of interest is there a transaction type you generally find needing to use these actions? For example Spend money, Receive money or Payments applied to invoices and bills?
I've slightly amended the title of your idea for the date of the transactions, we have separate idea for changing the bank account you can join for any updates.
-
Quotes - Add optional items
IT would be really good to have the capability to add 'optional' items to a single quotation -
- example #1: supplying in quantities of 10, 25 and 50,
- example #2: there are five items in the 'basic quote' but the customer may choose to add items 6,7 and/or 8 but these aren't a fundamental requirement to include.
If there is a quotation tool, then being able to offer customer flexibility is important as issuing multiple quotes can appear unprofessional
5 votes -
Find & Recode - Reverse Find & Recode
The ability to reverse batches of Find & Recode. Currently not available and can pose a risk to Xero files with higher volumes of transactions.
24 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.
-
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
303 votesThanks so much for sharing your feedback on this idea, community. We appreciate that having to manually select attachments on every invoice can feel a little fiddly. We get that you want a smoother workflow, that saves you time.
As noted by others in the idea, one option for now would be to add standard files, like your terms and conditions, directly to your invoice template. That way, they'll be included automatically when you send out your invoices.
To confirm how this functionality currently works - this is based on the user and driven by the last invoice that was sent. Where you have files attached, and you had selected to include files as an attachment when emailing the invoice, the next invoice you send with file attachments should have this selected by default.
A caveat to this is when you are working in incognito mode, or refresh your browser settings at which point the next invoice will revert to this option being deselected.
We want to transparent with you here that we don't have intentions of changing behaviour of how the send modal works in the near term.
Thanks so much for sharing your feedback on this idea, community. We appreciate that having to manually select attachments on every invoice can feel a little fiddly. We get that you want a smoother workflow, that saves you time.
As noted by others in the idea, one option for now would be to add standard files, like your terms and conditions, directly to your invoice template. That way, they'll be included automatically when you send out your invoices.
To confirm how this functionality currently works - this is based on the user and driven by the last invoice that was sent. Where you have files attached, and you had selected to include files as an attachment when emailing the invoice, the next invoice you send with file attachments should have this selected by default.
A caveat to this is when you are working in incognito mode, or refresh your browser…
-
Overall budget report - add annual (and quarterly) total column
In the overall budget report, add column for annual total.
Add additional option to include quarterly or triannual sub-total columns.10 votesHi team, to get a better understanding of exactly where you're wanting to see these columns can I confirm - would it be the Budget Summary report you're wanting to see this?
If so, right you could adjust the period option to 12 months for an annual view or 3 months for a quarterly view.
-
New Invoicing | Attachments - Record Actions in History and Notes
All Actions relating to attached files should be recorded in History and notes, eg Attachment added from Files:Inbox, Attachment Downloaded, Attachment Deleted, Attachment returned to Files:Inbox
11 votes -
Financial reports - Insert blank rows
Insert blank row in customised financial reports to separate different groups..
9 votesHi Karen, could you edit the report to create groups that would show this separation?
-
Chart of Accounts - Change Xero's default Entertainment ledger codes
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 voteHi Ray, appreciate your raising this through product ideas.
We'll get a sense of the interest in changing this within the default chart of accounts from the community here.
Just to confirm, while Xero offers a default chart of accounts, you can import your own chart of accounts to set these up as you prefer, or edit individual accounts within Xero.
- Don't see your idea?