181 results found
-
Bank Reconciliation - Automatic payment allocation to oldest invoices first
If you have multiple invoices for the same client, a feature that allows you the option to automatically apply bank transactions receiving money from the client to the oldest invoices first moving closer to date would be mighty helpful. At the current moment, we have to manually split out each transaction to the invoices when reconciling bank transactions; it stands to reason that if you have a client with multiple invoices and they pay off in chunks, you would want to apply payments to their oldest debt first; having this as a selectable option for a contact / bank rule…
13 votes -
Batch Deposit - Reference to pull through to bank reconciliation
When I enter a reference in batch deposit, this does not pull through to the bank reconciliation. On the bank reconciliation report, the Description is "Payment: multiple items" and the Reference field is blank. This is not useful as I have to go into each transaction and see which company the receipt has come from. Why enter a reference when it does not appear on the bank reconciliation report? When I try to search to match deposits using the company name, these deposits do not appear as the Description is unhelpful. If there are smaller batches which add up to…
12 votes -
Bank Rules - Show account, description and tax details
On the reconciliation screen in the bank account, if a transaction is being picked up by a rule, could we see both which rule it is being picked up by as well as the name, account, description, and tax details that the rule is using?
10 votesThanks for the idea, Garrett. This isn't in any plans at the moment, but we'll keep an eye on it as the team are thinking about this in the wider context of the bank reconciliation process.
In the meantime a workaround could be to include those details in the title of your bank rule. For example Supplier Name - Motor (20% VAT)
-
Bank Reconciliation - Add an End Date to bank rules
Add end date to Bank Rules
Can we have the option to add an 'end/final date' to a bank rule.
5 votes -
Transaction Entry - Alert to warn when a future date has been entered
have a warning come up when an entry is dated in the future to avoid posting to the wrong year
8 votes -
Bank Rules - Bulk edit bank rules to include GST/VAT/TAX
When a client changes from GST registered to no longer GST registered - It would be greatly appreciated if all the rules changed to BAS Exc like it does in Chart of Accounts. Young clients shop everywhere and therefore there are hundreds of rules to edit.
4 votes -
Xero Accounting app - Create Overpayments & Prepayments
Would be really useful to have the ability to add Spend or Receive money transactions (overpayments or prepayments) within the mobile app. At p[resent the only options are bank fees or adjustments. So quite often reconciling transactions requiring this type of action need to be left until able to access a full web browser version.
6 votes -
Bank Rules - Add condition for transaction type
Bank Rules - Add condition for Transaction Type (and other Statement Details)
Sometimes loan payments only come through with the loan number as the payee, but the transaction is for Interest only. I want to be able to set up a bank rule based on the "Transaction Type" coming through in the bank feed so that Interest and Principal payments can be coded directly to the correct codes. Most banks have these details in one of "Payee", "Description", or "Reference". ANZ bank does not, there may be other banks that are similar.
I have tried to add criteria for this…
16 votes -
Bank Reconciliation - reconcile transactions for multiple bank accounts at a time
I'd like the Reconcile pages to allow me to select some all of my bank accounts to display. This would aggregate the unreconciled statement lines and display them all in date order to be reconciled all the same time.
Reason 1: Convenience. I use several bank accounts and would prefer to reconcile all of the transactions in one go.
Reason 2: Error reduction. The most common error I see relating my clients' bank balances is their misuse of Transfer (setting the wrong account, using it for accounts that aren't linked etc.). If they could see both accounts and therefore both…
9 votes -
Bank reconciliation - Find and Match transactions to show Minor Adjustments variances
A setting in the backend to turn on/off to find and match transactions within a certain amount (i.e.-/+0.05).
These are usually (if not always a rounding adjustment). It's currently a 4-step process to add a minor adjustment.
Also, selecting minor adjustment or bank fee, can the difference auto populate in the amount field?!!
6 votes -
Bank Reconciliation - Improve date recognition for auto-suggestion
Reconciliation - when you have multiple payments of the same amounts over several days... Always selects the Invoice to the newest payment.. even tho the invoice date is the same as the first payment? seem like the system allocates backwards?.. We get lots of the same payments and Invoice totals and we have to always manually select/search for the invoice as the Auto reconciliation seems to not factor in Invoice date to Payment date as an option.
4 votes -
Bank Rules - List rules in Alphabetical order
BANK RULES LIST IN ALPHABETICAL ORDER
Just put them in alphabetical order as the default. I don't have time to go through dozens of them and drag them into order.4 votes -
Reporting: Reconciliation Reports - Ability to upload bank/credit card statement
ability to add/upload the bank statement/credit card statement to reconciliation report for future cross checking by accountant
267 votesHey everyone, thanks for engaging with this idea about being able to attach PDF bank or credit card statements directly to reconciliation reports in Xero. We know this can help simplify the cross-check process.
Right now there is the ability to upload statements into the Files inbox where you could create a dedicated folder for these type of files. However we understand the limitation in that this doesn't link them to report as you'd like here.
Our product team are looking into possible ways to attach files within the banking space and how we might fit it into the reconciliation workflow. It’s early days, and we’ll share an update when there's more news.
-
Cash Coding - Use an 'Unknown' contact if no Payee is entered
Currently, when using the cash coding screen, if you do not allocate a payee a new payee is created for each line item. If there is no Payee the contact should be Unknown otherwise there is too many contacts created for no reason.
3 votes -
Bank Reconciliation: Add the ability to search by contact account number when matching transactions
Bank Reconciliation - Match Does Not Work with Contact Account Numbers
The ability to search by contact account numbers when matching bank transactions is essential as most deposits on the bank statements are referenced with the client/customer account number only. The bank reconciliation ignores contact account numbers in totality.
50 votes -
Reconciliation - Bulk 'OK' for reconciling bank transactions
Ability to select multiple/all transactions during reconciliation.
Purpose: To save users time from having to reconcile the transactions one by one.
240 votesHi everyone, we've been tracking this idea for some years now and truly value all the feedback we've heard on the desire and time saving reducing the manual steps in reconciliation
would achieve. We completely get wanting to skip that extra ‘OK’ click when you trust the suggested matches.
We’re excited to share that this idea is now in development. At Xerocon this year we shared automated bank reconciliation - Using JAX to automatically match and categorise your bank transactions with your Xero transactions.😊
It's in beta already and being tested by a small group of users atm, and as soon as we have more to share on this rolling out wider I'll give you another update here. Thanks again for helping us shape the future of Xero!
-
Bank Reconciliation - Templates for common split payments
TEMPLATE FOR COMMON SPLIT PAYMENTS
We need to be able to save a split payment as a template (like a bank rule)
eg: registration is always split with gst, no gst etc, let us save that transaction as a template for easy recon next time. Bank rule isnt helpfull as when you have 20 different regos being paid to the same company then a simple split template would be very helpful3 votesHi team, while we appreciate you raising your idea here. Not getting much community traction overtime, and not being in our current roadmap we will remove this idea from the forums.
While I appreciate it's not solution you're after, to import transactions that match multiple statement lines you could consider importing these as Invoices or Bills.
With regard to the consideration of templates for split payments, one option could be to use the percentage split option in Bank rules rather than the fixed amount.
If this idea is still important and would make a big impact to your business flows, you're welcome to start it again to see if there is renewed interest from the community.
-
Reconciliation - Foreign payment from foreign currency (different)
It would be useful to be able to reconcile a payment from one foreign bank account (eg USD) for another foreign currency.
We tend to have predominately USD customers and a lot of EUR suppliers, so we find that quite often we make a payment to our EUR supplier out of our USD bank account.
When reconciling this in the bank we have to post a payment to a manual clearing account to then be able to post the payment to the EUR Supplier account to clear the invoices.
It would be useful if the feature shown when reconciling (show…
37 votes -
Bank Reconciliation - Upload files within the "Match" option
Upload AR Remittance Advices within "Match" option within Bank Reconciliations
I have noticed that when processing the Bank Reconciliation and matching bank deposits to raised AR invoices, the Remittance Advice can't be uploaded directly to the receipt under the "Match" option (see attached screenshot).
However, under the "Create" option (next to Match then clicking "Add Details") there is the option to Upload files.
Not being able to do this directly within Bank Rec matching means it is an inefficient process where I have to go back to the Customer account, look for the Invoice(s) that were paid and open it…12 votes -
Bank Rules - Set Payee when contact name shown within the description field
I want Xero to automatically set contact names when importing transactions from bank feeds, but this doesn't happen on of my several 'bank feeds' where the 'payee name' is blank and the actual payee data appears in the 'description' field instead.
This means that the option to set the contact name directly from the payee field (when using bank rules) doesn't work and I have to manually enter the contact name for every transaction when reconciling the account transactions. Extremely tedious and labour intensive!
When I edit section 2 of the bank rule the choices on the picklist are 1.…
3 votes
.PNG){kind=link}
.PNG){kind=link}
.PNG){kind=link}
.PNG){kind=link}
- Don't see your idea?