Bank Rule for overpayments
We have a lot of clients that make payments on account that don't match invoices.
For example they may have a food supplier who they pay £500 a week but this doesn't match any invoices.
It would be beneficial if we could set up a Bank Rule so that these payments are automatically treated as overpayments to the designated supplier ledger.
Currently we have to go "add details", select "overpayment", put in supplier name, then "save transaction" for every single one. A Bank Rule would do them all in the press of a button and save a lot of time.
Hi all, while it's really great to see how many of our users are making use of automating reconciliation by setting up Bank Rules, priorities lye in other areas of Bank Reconciliation for the team at present.
We know where our customers would like to see our attention when we have resource to broaden horizons in the space of Bank Rules and Overpayments will be high on this list when the time comes.
To confirm there is no work planned atm, but we'll share if and when this changes.
Peryn Clement-Evans commented
we receive regular 4-weekly payments each payment needs to be split to be allocated to the same batch of customer accounts. It would be helpful and save time to use bank rules to automatically record as overpayments
Catherine Whiting commented
A bank rule to set as an overpayment would be really helpful ....
Elizabeth Budzynski commented
I would really like to see this Bank Rule for Overpayments/Payment on Account implemented in the next update. It should be relativly simple to do and would save users lots of time.
Nigel Mitchell commented
We receive numerous payments on account each week from a large number of our clients. They are payments in advance of an annual invoice we raise to them. Not being able to set up a rule makes this an incredibly time-consuming task - particularly as recording an "overpayment" takes so many keyboard strokes and mouse clicks.
Furthermore, why it is called "overpayment"? Would prefer these transactions to be showing as a "Payment on account", because that's what they are, they are not overpayments.
Really miss this functionality that I had in Sage before we switched to Xero.
Dino Sideras commented
Cant understand why this isn't planned? Is it that hard to implement?
Judy Diamond commented
Yes please . Lots of clients would use this
Claire Peniket commented
Yes - please add this feature. It makes no sense to exclude it from rules. Lots of suppliers (in particular utilities) use payment plans where payments are made on account and allocated against invoices as they are raised. It's odd that Xero does not support this as Quickbooks does.
Tayque Holmes commented
I would love to see this feature as many of the clients I work with make weekly/monthly payments on account which would then save a significant amount of time for processing.
Marc L commented
This would cut out a lot of manual work for business that make regulay overpayments to build up credit...
Linda Bates commented
The ability to add a bank rule to post an overpayment would be a very welcome addition for me, particularly with messy supplier accounts where payments don't always match invoices/statements.
John Hannah commented
This would be an excellent feature and be of huge help to our clients who pay fees via standing order payments on account each month.
Bradley Lanning commented
@peter, how does the bank rule for overpayment work if you say it already exists?
Jacco du Toit commented
Currently there are only three types of Bank Rules:
1. Spend money rules – post to GL accounts
2. Receive money rules – post to GL accounts
3. Transfer money rules – post to other bank accounts
Please create a rule functionality for “Contact Receipt/Payment Rules” whereby a payment/receipt is allocated via the usual rule functionality to a pre-identified rule set-up to contact accounts.
We have clients where the bank transactions never match the bill or invoice value for several reasons, (could be that multiple invoices/bills are paid, deposits, short payment etc, etc.), forcing a user to process and reconcile the bank via the extra steps using the overpayment function.
Find and match won't work either since the bank transaction amount must match/balance to invoices totalling the payment/receipt.
Considering that one of Xero's selling points is to simplify processing, this appears to be an oversight. Allocating payments/receipts to a contact's account via a bank rule will create real value as these types of transactions are more often the rule and not the exception.
Allocation of payments/receipts to bills/invoices can then be managed through the usual process on each contact’s account.
Steven Ellison commented
I've only just seen your comment.
Please can you let us know how this is done as I can only see how to do each one manually one at a time.
If you know a way for these to be done automatically it would save so much time!
Edelnet Accounts commented
I fully agree if these overpayments can be "automated"
Peter Miles commented
This exists already
Sarah Pemberton commented
I agree with Emma, Overpayments are a bug bear, something does need to be done as a priority.
Emma Hunt commented
This is critical to how we operate our seat fee accounts at the rowing club. I receive 100 regular payments each month that are held on account and then used to offset fees for entering rowing events. I have to manually add these to each account. Labour-intensive when a simple rule could fix this. Please consider as a standard feature, or advise an alternative way...
matthew clarke commented
This would be extremely useful, why is it not a feature already?