I would like to see the customer statement changed to be a complete listing of all transactions on the customer’s account
regardless of whether they are allocated or not.
Other recommendations would be around the labels for the totals and the format of the excel export
Currently, unallocated payments are not shown on the statement.
This means that any customer who has either paid in advance of an invoice, or who has not clearly stated which invoice they are paying needs additional information to interpret their balance.
At the moment I have to run out a list of unallocated payments with their dates, make sure it matches the “credit” figure on the statement and send that with the customer statement.
Rename “credits” to “unallocated payments and credits”
Rename “outstanding balance” to “outstanding invoices”
Add new field of “Customer Account Total” (= outstanding invoices - unallocated payments and credits)
On the export file please can you either remove GBP against every number or parse it into a separate column. Currently I have to remove them all in order to add up any numbers.
What are other people doing with their statements when they are not fully representative of a customer’s account?
As with all feature requests, we’ll leave this open for other users to comment or add their support to. We do like to see a bit of support from the community before we change or add things, especially when it comes to relabelling or altering features.
As the topic starter, you should already be subscribed to the topic, so any replies should be emailed to you, depending on your account settings.
I agree that it is not immediately obvious that the “outstanding balance” is actually the total of unpaid invoices. I would expect the “balance” to be the amount required to bring the account to zero after allowing for unallocated credits and pre-payments.
I have read your forums that tell me the only way you can get a receipt or payment onto a statement is to link it to an invoice, but this does not happen in every case. I cannot see why it is impossible to keep a running total of invoices and payments on a specific account.
I can give you some examples of where it is inconvenient.
Budget Payments to an energy supplier. You pay the same amount every month and your energy bills vary each month.
A customer makes a nominal payment into his account that is not linked to specific invoices
Your bank reconciliation system allows you to allocate a payment to a customers account but it then does not show on the statement even though the money has been paid and the the entry is tagged
same thing with the debtors ageing report.
Agree that advance payment is not a debt so will not show on the ageing report.
We have had several discussions on this.
We are looking for a debtors report (note: ageing excluded), whereby the balance (i.e. in the balance sheet) on any given date of the DEBTORS CONTROL ACCOUNT agrees with a list of debtors. This list of debtors is a debtors report… it would have both outstanding amounts and overpayments from customers.
see post below.
Similarly, if client statement is not picking up advance payments (which are not allocated to any invoice) then it’s not a correct statement.
The statement does show accumulated credits (prepayments) in the top right hand corner. They are just not itemised on the actual statement view. The statement will however detail exactly when a prepayment is linked to an invoice but it won’t show the original receipt of the prepayment. It’s not likely we will be able to change this due to the way the system is designed.
I think I’ve explained the logic behind the debtor ageing report, so I would refer to my previous comments on that subject.
Hi Glenn, I agree with you if it’s an ageing report. My point is about a debtors report.
I don’t think I have seen a report which shows exactly the breakdown of the DEBTORS CONTROL ACCOUNT.
It is this report that the accountants using the software are looking for.
Is there absolutely no way to adjust the design?
I note your point that any unallocated credits are displayed on the top right hand corner.
This is helpful.
This Historic Invoice Report will provide a fairly detailed breakdown of the debtor and creditor control accounts at a particular point in time. It will include all invoices, balance of prepayments, journals and opening balances.
We may be able to achieve this in a slightly different way. One approach would be to include a separate box under the itemised section to list out any unspent prepayments, e.g. dates and amounts.
Not sure where the historic invoice report is. If you can point it out to me then I will check it out.
A few of months ago, I managed to get this data from the client management , but I had to include ALL years (since the beginning of start of the business or QF) in my date range. This is because there are client with older credits.
See screenshot below.
I then export the data, delete the rows with no balance or credit. What remains is the figure that is in the debtors control account.
But honestly, it should not be this difficult and time consuming for the users to get to this…
I am sure many of us will appreciate a direct and simple report to achieve the above.
Thank you. This is helpful.
A further breakdown of the prepayments figures will be more helpful, as presently I can’t see how the system picks the prepayment figure.
In the screenshot below
The total prepayment figure should be £631 but the report pics up £1,111 and explains the difference to bank.
Why is there a pick highlight on the figure, I assume that means the figures don’t reconcile?
I tagged £480 directly to Debtors control account.
This was because credit note and refund were issued at different dates (refund later).
For the benefit of others,I am reposting parts of our private conversation.
I just created a test refund to dated 4th Oct in the Bank account. This refund is for CR note dated 01/04/2017 to client X They have credit of £xx on the account. When I went in to tag it, there is no option to tag it to the credit note or to allocate it to the client account. The drop-down box only gave me option to apply refund to older invoices in the client account.
I reckon it was because of this, I may have tagged the £480 directly to the debtors control account. To me doing this made sense, as I was reducing the debtors balance in the accounts (even though I could not tag it directly to the client account)
I suppose, it may be handy to have a further option when tagging a refund, where we could tag the refund direct to client account rather than it only being applied to an invoice? Not sure your system is designed for this?