- or
4594 results found
-
Recon on accounts
Can you recon your accounts once and next time it is the same I have alot of recons that are always the same How do you keep it for next time to recon
1 voteAssume you are referring to reconciliation, Alletta? While it may help to make sure auto suggestions are turned on in your org, perhaps Bank rules would fit your purpose here?
-
Reporting - Add report fields
Customising and adding Employee Details Fields so that Employee Details Reports can be produced providing all required information and important information regarding the employee can be kept. For example, licence numbers, certifications etc.
1 vote -
NZ Payroll - 63 days leave liability report
Hi There, curious to know, does Xero provides report 63 days payroll liability report. This is needed to accrue for the liability at the end of each tax year, since IRD allows this accrual to be accounted, with one condition, if the company has paid the staff with in 63 days from the end of each tax year. I know, this report is availabe by the other payroll software. Can this report be extracted from payroll reports.
thanks
Murli Vasu
SBA Albany1 vote -
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 -
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.
-
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 -
UK Payroll - New Starters and Leavers payroll report
Joiner and leaver payroll report
A report to show who has joined and left within a certain period
48 votes
- Don't see your idea?