- or
4707 results found
-
Projects - Lock staff pay rates
The ability to 'lock in' previous periods pay rates in Projects. Currently, when uploading any pay rate changes per member of staff, this cascades back to all hours worked on projects which skews figures.
29 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.
-
UK Payroll - Employee Contact Details
Payroll Employee Contact Details would be good to see a column for terminated employee showing date left and employee number
1 vote -
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 -
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 -
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.
-
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 -
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
302 votes -
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?
-
Chart of accounts - Ability to set up credit card as a liability without a feed
Set credit card accounts as liabilities, not assets. We are not a bank, so credit cards are properly liabilities. There should be no reason these accounts should be reported as assets in any circumstance.
I can't set Account Type for bank accounts unless there is a feed associated with it. Even though, I'm not sure what good that actually does, and we don't have feeds for all our accounts. "Credit Card" is an available account type for bank accounts when they are feed-enabled, so adding credit cards as bank accounts appears to be what Xero intended, and that's what we do because we want to reconcile our credit card account.
Despite this, regardless of what you pick for Account Type, if it's even available, Xero considers credit card accounts as assets. You can move them in reports within the Xero UI, but it cannot be changed when getting reports through the API. As a result, credit card accounts have the wrong type and sign, requiring workarounds when using third-party apps. For example, we use ODataLink to get the data into Excel and Power Platform, but we have to create workarounds in the queries because the balances have the wrong sign.
We need the ability to change credit account accounts to be liabilities, as they always should have been.
Set credit card accounts as liabilities, not assets. We are not a bank, so credit cards are properly liabilities. There should be no reason these accounts should be reported as assets in any circumstance.
I can't set Account Type for bank accounts unless there is a feed associated with it. Even though, I'm not sure what good that actually does, and we don't have feeds for all our accounts. "Credit Card" is an available account type for bank accounts when they are feed-enabled, so adding credit cards as bank accounts appears to be what Xero intended, and that's what we…
4 votes
- Don't see your idea?