154 results found
-
Monzo feed
I have a Monzo business account that's reconciled with Xero. When I upload the receipts to Monzo they don't come over into Xero. Are you planning to add this as a feature? If not with Monzo do you offer this with any other accounts like Pleo? It would be good to attach the receipts in Monzo as they happen as they show in Monzo straight away.
1 voteHi Emma, you can connect your Monzo account with Xero to import your transactions. We have a bit of detail on the criteria for automatically importing data from your Monzo account and the steps of how to connect this in Xero Central.
If you have more questions on this I'd recommend connecting with our specialists at Xero Support through the Contact Xero Support link at the bottom of the page there.
-
Reporting - Add ageing for Customers and Suppliers
Add the following to reports:
Supplier Activity Statement to compare with the statement received from your suppliers.
Alternatively - enable a Customer and Supplier DETAILED LEDGER as per usual accounting practice. This should be standard within Xero.10 votesHi all, with no response from my last update we are going to shift this to delivered with the ability to run the Aged Payable or Receivable Detail reports where you can set the Ageing periods to be Day, Week or Month based on your choosing. If needed you can also filter these reports by Contact.
For ageing periods on a customer's statement - we have an idea for this that we've shared on and to be upfront we don't have any plans in the foreseeable future.
Supplier statements have been discussed on a different idea. However, we want to be upfront this isn't planned.
-
Reports - Add a total column to Budget Summary
Please can we have a total column
12 votesHi team, appreciate your feedback of improvements we could make to the Budget Summary to help you here. We've recently released a new Budget Summary report, and you'll find within the new report there's a Total column!
If this doesn't automatically appear for you, just click the More option to select 'Total' and re run the report. 🙂
-
Bank Reconciliation - Allocate Payments to a Supplier's account
I do not know if there is a way to do this if so it is not too simple. I would like to allocate a payment from the Bank to a Supplier but to not allocate it against any invoices. This would not be a new invoice but would sit on there account so it is easy to know what they owe a supplier. This idea would be similar to Sage "Payment on Account" which is very simple to do on Sage.
2 votesHi team, the way to do this in Xero would be to reconcile the payment as an overpayment or a prepayment. This would then be credit on a suppliers account that could be applied to a bill at a later date.
Best to connect with your adviser if you're unsure which transaction type you should record these as, however we have a bit more information on these here and here respectively. 😊
-
bulk change customer or supplier VAT to organisations own, as not all of our services require VAT
To be able to bulk change settings for customer or suppliers.. for example, all of our customers and suppliers (4000+) were added to Xero but have all been pre set to include 20% VAT when invoicing.
But not all of our services are VAT chargeable, now whenever we invoice the VAT rate is pre set, causing us to need to remember to remove it. We can individually change this per customer or supplier to use our organisations own setting, in which this pulls from our schedule of rates. But to have the ability to change this in bulk would make…
1 voteHi Mabyn, sorry for not rounding back to your idea sooner. This should be possible through imports. To bulk update your contacts in Xero, you can export your current contacts list, make adjustments (in this case it sounds like you'll want to update the 'AccountsReceivableTaxCodeName'), then re-import your contacts list to Xero.
As long as you don't change your contact's name this will updated the details of that contact when imported to your organisation 🙂
-
Bulk update account
Bulk update account for multiple line entries to allow for easier reanalysis of multiple line items within the software.
Include a feature to make it easier to change the account for multiple line entries at once through the supplier side to make it easier when bookkeeping to reanalyse multiple line items, rather than editing them one by one if they get reanalysed within the accounts.
I.e. for a client I originally posted all AXA payments as insurance, in the accounts they were reanalysed as other staff costs, at the moment I need to edit every single line item included in…1 voteHi Adam, we have a feature called Find and recode that will enable you to bulk update the account code for multiple lines at once. You could filter by the contact and then recode whatever lines of transactions as needed.
I'd recommend giving this a try in the demo co first and potentially working with your accountant before implementing this in your organisation. Have more of a read on this here.
-
Reports - Use custom report layout across all organisations
This is so customers can use the same custom made report layout for multiple entities.
22 votesHi everyone, appreciate your interest and sharing on the idea here. Right now Report Templates offer the ability to create a custom report layout that can be used in multiple organisations.
To access Report Templates you must be a Xero Partner, if you don't have one you can find one through the Xero advisor directory.
-
How to record and reconcile a part payment on a Bill
The client has been using Hubdoc for uploading the bills into Xero. How can we record the part payment for the bill during the reconciliation in Xero please?
In general, we use "Split" to record the part payment but we are unable to see the split on Hubdoc bill1 voteHi Just a heads-up that this is a public forum for discussing improvements to Xero, rather than finding support with using Xero.
To do this you could:
- View the bill and scroll to the bottom to the 'Make a payment' section.
- Record the part payment here, directly on the bill.
- Finally, use Find & Match to reconcile the bank statement line with the part payment.
If you need any further assistance with this, or anything else in Xero, please raise a case with some details on Xero Central, and our Support team will be happy to help.
-
SG - Manually edit GST amount
There is a need to manually edit the amount of GST paid instead of using Xero's calculation. For example, for credit card merchant fees, merchants calculate GST based on individual transactions and sum up the total GST payable, add onto the merchant fees for the total amount payable. As Xero calculate GST based on the total amount, there is a difference in the GST payable. Other accounting systems allows you to adjust, and it will automatically adjust the total amount. Without this feature, we have to use either rounding (for below 0.10c) or add a new line item. The problem…
2 votesHi 👋 Xero calculates the GST on each line item in invoices, bills and other transactions. The GST is then rounded to the nearest cent. The total GST is the sum of these amounts.
We don't offer alternative rounding methods but if you have the global or Singapore versions of Xero you can enter a tax adjustment if you want to.
Simply,
- Select the Tax Exclusive option in the Amounts are field.
- Edit the amount shown in the Tax Amount box - if this box isn't showing, click the + symbol next to the Tax Rate heading
We have more information in our article here.
-
Reporting - Report that shows bank entries with the same value
It would be great to have a report that would highlight any payments paid from the bank account with the same value.
2 votesHi team, you could use the Account Transactions Report here. When you run this report, select the bank account, then sort the results by the relevant amount column, this will group any items for the same amount together.
-
Activity Statements - Collapse or Expand Transactions by Tax Type
It would be really helpful when in the Transactions by Tax Rate or Transactions by BAS Field tabs in the Activity Statement if you could collapse by the Tax Types. It is currently very cumbersome navigating these screens for businesses with high volumes of transactions. If you want to view the GST Free Expenses, you will have to scroll through hundreds of transactions and hope that you find the GST Free Expense heading in amongst all of them. The current work around is to export to Excel and manage the data that way, which isn't always ideal.
3 votesHi Amy, I'm pleased to say that we've recently introduced this feature, making several improvements to the GST transactions report:
- The 'Transactions by Tax Rate' and 'Transactions by BAS Field' tabs have been combined into a single view, now accessible through a 'By Tax Rate vs By BAS Field' filter.
- Users can now filter transactions by specific BAS fields, tax rates, or both, a feature that is particularly beneficial for organisations with a large volume of transactions.
- A wider view has been introduced for better visibility
- We've also added a sticky top header for easier navigation.
-
Inventory - Highest selling product and most profitable item reporting
I want a report that will tell me the most popular products and that will tell me what products are the most profitable
3 votesHi team, rounding back to the idea here the Inventory Item Details report should be able to provide what you're asking. This report will provide line-by-line sales and purchase details of your inventory items.
If not shown already you can select to include Profit and Margin columns and Group by Item name.
-
Difference of Invoice template between Preview and PDF format
I have discovered that the invoices as they appear in the Preview button of an invoice only gives a preview of how the online invoice will display. This is therefore different from the PDF version of the invoice when it is downloaded as a PDF or sent to my clients. The PDF version looks a lot messier and looks far less professional. It was informed that, it is currently not possible to make the PDF version appear like the Preview version, or vice versa. I would like to know if anyone else has some ideas of how to align the…
20 votesHi everyone, recently we made a change to the Preview option in new invoicing. Now, when you select to 'Preview' in new invoicing this'll open a new browser tab with a view of the PDF of the invoice. This means you can also see how your invoice will look to the customer with a docx / advanced branding theme applied.
Our team are also doing more to look into how preview works and how your invoices look. We'll update again if there's more development to share.
-
Invoices - Create new repeating invoices from draft invoices
There is an issue with the new GUI for invoices in xero. My work flow requires making multiplke repeating invoices from a standard invoice. At present this can be done by creating a draft, and then converting the draft invoice to a repeating invoice. The draft stays put in the drafts folder and can be converted into a new repeating invoice. Once I have set up all the repeating invoices I require, I can delete the draft.
The option to create repeating invoices from drafts in the new GUI has been removed. Where is it?3 votesHi community, we have just gone live with the ability to create a new Repeat template from a Draft invoice 🎉
You'll find this option from the 3 dot menu within a draft invoice. Thanks for your input through this idea.
-
OLD P&L report - compare tracking options to be brought into new P & L reports
In the old P&L reports there was an option to compare jobs(tracking options) for a selected period. There was an option to filter the exact period (eg 1 month or 6 months) and it also displayed the line items relevant to the job for that month (eg individual COGS lines) It was used to compare Job COGS to a Project Management program used by the business.The new P&L has very limited features particularly relating to filtering. The only option we see now is hours of opening each job, line by line (as it shows all the jobs with no way…
5 votesHi team, returning to the idea here I believe what you're after is now available in the new Profit & Loss report. You can edit the report layout to add individual tracking columns and once all set up and saved as you like save the report as custom so you can easily access this anytime you need.
-
Reporting - Add a GST Summary Tab to the Activity Statement
Include an extra tab that summarises the totals for the Tax Rates including the cents.
This will eliminate the need to scroll through all the detail to code the journal/payment.
2 votesHi team, I know it's been sometime since this idea was originally raised and we wanted to provide an update for you all here.
Xero's Activity Statement report today has two tabs - Summary and Transactions.
The Summary tab summarises the Tax Rates totals of all transactions. This shows a round number without cents in line with ATO. Transactions tab includes all transactions associated with the Activity Statement period.
You can find more detail about how Xero populates the Activity Statement on Xero Central.
-
Payables report
Create a payables report in Xero accounting software that shows all future committments due within a date range that includes supplier credit notes
1 voteHi Lea, this is already possible with the Payables Invoice Details or Summary reports. It's based on the date range set for the report. So if you set a date in the future you'll be able to see all activity that has been entered with a date in that period.
-
NZ GST return - Ability to customise the GST Audit Report layout
Can the GST Audit report print in order to match return , Ie sales at top, than expense and non GST last. rather than exporting and sorting . Usually less transactions and easier to check first. but have scroll through 100s to find.
3 votesHi all, just confirming as per my recent update. Within the Transactions tab of the new GST Return, you can now choose to view by box number or tax rate, giving more customisation of how you review associated transactions.
-
BAS - Notification when Activity Statement is due
Xero should show at the top of the screen or show a notification if you have an activity statement to submit (otherwise you have to specifically go into "Activity Statement" under "Accounting" to check).
3 votesHi June, we've made a recent improvement for Activity Statements to surface the payment due date for any lodged statements. You'll find this from the list of Activity statements within the Completed section, and when you open a Statement you'll see the payment dude date shown at the top of the statement along with payment options to help simplify the process. 😊
-
User role- Limit invoice only draft only users to their own invoices
User role- Limit invoice access to seeing and working on only user's own invoices. So as to enable different user to work on their own invoices without having access to other user invoices. Only manager should have access to all members of his team .
6 votesHi team, coming back across this idea I wanted to confirm that this is how the Invoice Only - Drafts role currently works - Someone with this role will be able to create and submit bills and invoices they enter to be approved by someone else with the right permissions in the org.
They will only have access to view invoices and bills that they have entered themselves, and will not be able to view bills or invoices raised by others in the organisation.
Danny, it sounds like you're referring to the Invoice Only - Purchase role which will enable a user to raise and approve bills they have entered. The user is not able to access Sales, but they'll be able to view any bills or purchase orders that have been raised by any user in the organisation. We have a somewhat similar idea for a tick box option…
- Don't see your idea?